Server crashes after a while (error reading tcp socket Connection reset by peer)

[X-Ray]

Hello together,

i have a problem. My server crashes after a while. (online about 6 hours).

Last i have updated my Server to 3.2.0. I use MariaDB and MySQL.

Here is my log:

2018-06-05 10:45:55.646774|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.2.0 (2018-05-08 06:11:20)
2018-06-05 10:45:55.646903|INFO    |ServerLibPriv |   |SystemInformation: Linux 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u2 (2017-06-26) x86_64 Binary: 64bit
2018-06-05 10:45:55.646928|INFO    |ServerLibPriv |   |Using hardware aes
2018-06-05 10:45:55.647782|INFO    |DatabaseQuery |   |dbPlugin name:    MariaDB plugin, version 3, (c)TeamSpeak Systems GmbH
2018-06-05 10:45:55.647813|INFO    |DatabaseQuery |   |dbPlugin version: 2
2018-06-05 10:45:55.768779|INFO    |Accounting    |   |Licensing Information
2018-06-05 10:45:55.768840|INFO    |Accounting    |   |type              : Non-Profit License
2018-06-05 10:45:55.768863|INFO    |Accounting    |   |starting date     : Sat Mar 31 00:00:00 2018
2018-06-05 10:45:55.768876|INFO    |Accounting    |   |ending date       : Mon Oct  8 00:00:00 2018
2018-06-05 10:45:55.768886|INFO    |Accounting    |   |max virtualservers: 10
2018-06-05 10:45:55.768897|INFO    |Accounting    |   |max slots         : 512
2018-06-05 10:45:56.434667|INFO    |              |   |Puzzle precompute time: 568
2018-06-05 10:45:56.435038|INFO    |FileManager   |   |listening on xx:30033, xx:30033
2018-06-05 10:45:56.717400|INFO    |CIDRManager   |   |updated query_ip_whitelist ips: xx, xx/128, 
2018-06-05 10:45:56.717587|INFO    |Query         |   |listening on xx:10011, [xx]:10011
2018-06-05 10:46:36.802877|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:47:01.912068|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:47:02.544909|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:47:02.584670|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.969750|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.973098|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.975721|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.977331|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.983464|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.985774|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.988011|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:01.999702|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:02.001030|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:02.003116|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:02.005067|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:02.007472|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:02.020227|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:49:02.033346|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:50:01.980324|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:51:37.017704|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.040613|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.043642|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.049682|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.051530|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.074015|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.075856|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.087841|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.104185|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.115442|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.116989|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.129339|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:52:02.190781|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:53:37.187885|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:55:01.124615|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:55:01.126317|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:55:01.127669|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:55:01.131165|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.163152|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.164865|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.166441|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.168027|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.173225|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.186877|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.188863|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.192321|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.193794|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.210350|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.229397|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.306376|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.307820|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.341718|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.343335|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.344543|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:57:01.355133|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:59:01.775658|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:59:01.788131|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 10:59:01.801462|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:00:01.499525|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:00:01.533957|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:00:01.546112|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:00:01.557913|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:00:01.569612|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:00:01.581909|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:02:01.840573|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:02:01.852985|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:02:01.865568|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:03:01.947473|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.325436|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.357962|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.360051|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.366513|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.367464|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.373336|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.388962|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.391124|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.393229|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.395624|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.397520|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.413536|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.426104|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.428768|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.430097|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.506137|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.530921|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.945042|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.983681|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:01.996425|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:02.008949|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:05:02.046273|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:06:01.439010|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:07:37.662178|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.441774|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.443177|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.543685|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.545725|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.547290|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.607089|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.609407|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.621661|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.638705|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.649562|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.651638|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.662468|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:08:01.674691|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.420368|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.736905|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.737902|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.749374|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.761054|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.784303|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.826387|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.838471|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.850674|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.862202|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.863988|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.865024|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.877138|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.889928|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.947798|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:09:01.962745|ERROR   |              |   |error reading tcp socket Connection reset by peer
...more more more...
2018-06-05 11:55:01.924376|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:55:01.926104|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:55:01.943183|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:55:01.954649|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:55:01.994932|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:55:01.996627|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:57:01.926607|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:57:01.942849|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:57:01.946398|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:57:01.959326|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:57:01.970838|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:57:02.275962|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:58:02.265263|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.009012|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.102618|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.113531|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.126668|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.139642|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.256595|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.274111|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.291638|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.307323|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.318897|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.330577|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.439980|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:02.463258|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 11:59:39.954554|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:01:02.413882|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:01:02.425698|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.053326|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.056753|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.060528|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.064414|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.066705|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.078770|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.080394|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.083611|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.084919|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.109822|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.112164|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.125888|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.140225|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.150919|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.163112|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:04:02.174614|ERROR   |              |   |error reading tcp socket Connection reset by peer
2018-06-05 12:06:57.903463|ERROR   |DatabaseQuery |   |db_exec() insert into clients
( server_id,
  client_unique_id,
  client_nickname error: Query was empty
2018-06-05 12:06:57.903719|CRITICAL|Client        |1  |Assertion "m_ClientDBID != 0" failed at ../../../../s/deps/teamspeak_common_lib/src/chanclients/client.cpp:245;

Hope someone can help me!

[X-Ray]

Tried, same problem :/

[dante696]

Rikku's reply wasn't related to your problem anyways.

We still need to evaluate the problem. For the moment it looks like traffic packets are blocked.

[X-Ray]

Thank you!

I tried something with my iptables.
This is my currently tested table:

# TeamSpeak 3
-A INPUT -p tcp --dport 10011 -j ACCEPT
-A INPUT -p tcp --dport 10012 -j ACCEPT
-A INPUT -p tcp --dport 30033 -j ACCEPT
-A INPUT -p tcp --dport 30034 -j ACCEPT
-A INPUT -p tcp --dport 41144 -j ACCEPT
-A OUTPUT -p tcp --dport 2008 -j ACCEPT
-A INPUT -p tcp --dport 2008 -j ACCEPT
-A OUTPUT -p tcp --dport 2010 -j ACCEPT
-A OUTPUT -p tcp --dport 443 -j ACCEPT

# TS3 Instanzen
-A INPUT -p udp --dport 11111 -j ACCEPT
-A INPUT -p udp --dport 1234 -j ACCEPT
-A INPUT -p udp --dport 9987 -j ACCEPT
-A INPUT -p udp --dport 8987 -j ACCEPT
-A INPUT -p udp --dport 9989 -j ACCEPT
-A INPUT -p udp --dport 1337 -j ACCEPT
-A INPUT -p udp --dport 9999 -j ACCEPT
-A INPUT -p udp --dport 9000 -j ACCEPT
-A INPUT -p udp --dport 9001 -j ACCEPT
-A INPUT -p udp --dport 9988 -j ACCEPT
-A INPUT -p udp --dport 9990 -j ACCEPT
-A INPUT -p udp --dport 9991 -j ACCEPT
-A INPUT -p udp --dport 9992 -j ACCEPT

Are there maybe any new ports since the latest updates?

[X-Ray]

My Server crashs everyday, can't someone help me? :/

[ZerefGG]

My Server crashs everyday, can't someone help me? :/

if the servers craches with the "error reading tcp socket Connection reset by peer" you should recheck your firewall.
Are you the only one who has access to the (v-)server? "maybe" someone has set up a cronjob to shut the server down daily.

[ZerefGG]

... I use MariaDB and MySQL.

Here is my log:

2018-06-05 12:06:57.903463|ERROR   |DatabaseQuery |   |db_exec() insert into clients
( server_id,
  client_unique_id,
  client_nickname error: Query was empty
2018-06-05 12:06:57.903719|CRITICAL|Client        |1  |Assertion "m_ClientDBID != 0" failed at ../../../../s/deps/teamspeak_common_lib/src/chanclients/client.cpp:245;

Sorry I didn't read your post well, next time use bold style for important keywords
I think the problem comes from the db.
What's in your ts3server.ini and ts3db_mariadb.ini files?

[X-Ray]

ts3server.ini

machine_id=
default_voice_port=9987
voice_ip=xx,xx
liscensepath=
TS3SERVER_LICENSE=accept
filetransfer_port=30033
filetransfer_ip=xx,xx
query_port=10011
query_ip=xx,xx
dbplugin=ts3db_mariadb
dbpluginparameter=ts3db_mariadb.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mariadb/
logpath=logs
logquerycommands=0

ts3db_mariadb.ini

[config]
host=127.0.0.1
port=3306
username=teamspeak3
password=xx
database=teamspeak3
socket=
wait_until_ready=5

When a new client connect with the server who is not in the client table the server crashes with the message.
But the entry in the table appears after the server is crashed.

[X-Ray]

I've used now a backup of teamspeak and db.

My Question: How can i easily update from 3.0.13.6 to 3.2.0? I think this was the reason for the problems.

Thanks!

[ZerefGG]

Sorry, I can't help you with your problem.
try to migrate mariadb to sqlite, do the server update and revert to mariadb,
but why are you using mariadb? are you a host? if not you should not use mariadb, sqlite is more performant!