Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 13 of 13

Thread: TS3 locks up

  1. #1
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16

    Unhappy TS3 locks up

    Hi,

    Got a problem with my TS3 running on Linux Debian Lenny. After it has been running for a few hours TS3 locks up for connections.
    I have to do a kill -9 (kill alone doesnt stop it) to stop the server and then restart it.

    I am running 3.0.0-beta28 on the server and I am using mysql which is running on an other server.

    I start ts3 with :
    screen -dmS ts3 ./ts3server.sh
    and the ts3server.sh looks like this :
    #!/bin/sh
    export LD_LIBRARY_PATH=".:$LD_LIBRARY_PATH"

    ./ts3server_linux_x86 inifile=ts3server.ini
    My ts3server.ini files looks like this :
    machine_id=
    create_default_virtualserver=0
    voice_ip=192.168.1.40
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=192.168.1.40
    default_voice_port=9987
    query_port=10011
    query_ip=192.168.1.40
    query_ip_whitelist=query_ip_whitelist.txt
    query_ip_blacklist=query_ip_blacklist.txt
    dbplugin=ts3db_mysql
    dbpluginparameter=
    dbsqlpath=sql/
    dbsqlcreatepath=create_sqlite/
    dblogkeepdays=90
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    Last lines in the log file :
    2010-09-12 18:26:18.838396|ERROR | | | read invalid packet size size
    2010-09-12 19:49:14.626396|ERROR |DatabaseQuery | | db_exec() select count(*) as unread from messages where message_to_client_id= 1 error: Lost connection to MySQL server during query
    2010-09-12 21:37:06.878876|ERROR |DatabaseQuery | | db_exec() select * from clients where client_unique_id = 'serveradmin' and serve error:
    2010-09-13 05:49:56.082365|ERROR |DatabaseQuery | | db_exec() update clients set client_lastconnected=1284356067, client_totalconnec error: Lost connection to MySQL server during query
    2010-09-14 05:40:37.286363|ERROR |DatabaseQuery | | db_exec() update clients set client_nickname='DKLeader' where client_id=3 and se error: Lost connection to MySQL server during query
    Any ideas to why it does this?

    // DKLeader

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    Hello

    Can you try just with this start command :

    Code:
    ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    Have you create the ts3db_mysql.ini file ?

  3. #3
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16
    Ok I will try with that command.

    Yes I have created the ts3db_mysql.ini and can see that it works well - it has created everything in the db.

  4. #4
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16

    Still the same problem

    Ok tried the suggestion by starting it using :
    Code:
    ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    This is what I got

    mumbleserver:/usr/local/gcp/teamspeak3-server_linux-x86# ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    TeamSpeak Server 3.0.0-beta28 [Build: 12264]
    (c)TeamSpeak Systems GmbH

    Logging started
    2010-09-14 06:54:09.642171|INFO |ServerLibPriv | | Server Version: 3.0.0-beta28 [Build: 12264], Linux
    2010-09-14 06:54:09.645203|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2010-09-14 06:54:09.645393|INFO |DatabaseQuery | | dbPlugin version: 1
    2010-09-14 06:54:09.655503|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
    2010-09-14 06:54:10.165839|INFO |Accounting | | Licensing Information
    2010-09-14 06:54:10.167739|INFO |Accounting | | licensed to : CZGames.dk
    2010-09-14 06:54:10.169164|INFO |Accounting | | type : Hoster
    2010-09-14 06:54:10.171447|INFO |Accounting | | starting date : Tue Aug 31 00:00:00 2010
    2010-09-14 06:54:10.187507|INFO |Accounting | | ending date : Wed Aug 31 00:00:00 2011
    2010-09-14 06:54:10.188987|INFO |Accounting | | max virtualservers: 2500
    2010-09-14 06:54:10.190436|INFO |Accounting | | max slots : 25000
    2010-09-14 06:54:10.256718|INFO |FileManager | | listening on 192.168.1.40:30033
    2010-09-14 06:54:10.425530|INFO |VirtualServer | 1| listening on 192.168.1.40:9988
    2010-09-14 06:54:10.427240|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1, 192.168.1.1, 192.168.1.40, 92.62.196.69,
    2010-09-14 06:54:10.429101|INFO |Query | | listening on 192.168.1.40:10011
    After 2 hours I tried to disconnect on my client and connect again (done it a few times during those 2 hours without problems) but then it comes with :
    <11:09:33> Trying to resolve hostname ts3.cz-games.dk
    <11:09:33> Trying to connect to server on ts3.cz-games.dk:9988
    <11:09:38> Failed to connect to server
    Went to my server and tried pressing CTRL-C in the console - got this, but the process was never stopped.
    ^C2010-09-14 08:44:24.554635|INFO |ServerMain | | Received signal SIGINT, shutting down.
    Killed the process using kill -9 and started the server again. Went back and connected from the client again :
    <11:14:09> Trying to resolve hostname ts3.cz-games.dk
    <11:14:09> Trying to connect to server on ts3.cz-games.dk:9988
    <11:14:09> Connected to server: CZGames.dk Demo Server
    <11:14:09> Velkommen til CZGames Demo Server - Kunne du bruge din egen - så kig forbi vores shop.
    <11:14:09> You subscribed to all channels
    Any new suggestions

    // DKLeader

  5. #5
    Join Date
    May 2010
    Posts
    6,310
    Try with nohup script (or screen if you want)

    in your ts3server.sh write :

    Code:
    nohup ./ts3server_minimal_runscript.sh inifile=ts3server.ini &
    Start with ./ts3server.sh

  6. #6
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16

    Might be the problem.

    If I add this to channel description :
    Velkommen til CZGames.dk Demo Server.

    Du er velkommen til at bruge denne server til at teste vores produkt.

    Hos os har du mulighed for at leje en server hvor alle admministrations mulighederne (SA) er kontrolleret og styret af dig som administrator.

    Synes du om vores produkt, så tag et kig forbi vores shop.

    Har du spørgsmål til vores produkter så kig på vores FAQ eller skriv til Support

    MVH
    Management CZGames.dk
    then it seems to lock-up the teamspeak server after that. Then after I restart the TS server and look in the channels it has been changed to :
    Velkommen til CZGames.dk Demo Server.

    Du er velkommen til at bruge denne server til at teste vores produkt.

    Hos os har du mulighed for at leje en server hvor alle admministrations mulighederne (SA) er kontrolleret og styret af dig som ad
    From the nohup.out :
    TeamSpeak Server 3.0.0-beta28 [Build: 12264]
    (c)TeamSpeak Systems GmbH

    Logging started
    2010-09-14 09:16:31.399609|INFO |ServerLibPriv | | Server Version: 3.0.0-beta28 [Build: 12264], Linux
    2010-09-14 09:16:31.403108|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2010-09-14 09:16:31.403310|INFO |DatabaseQuery | | dbPlugin version: 1
    2010-09-14 09:16:31.413977|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
    2010-09-14 09:16:31.896805|INFO |Accounting | | Licensing Information
    2010-09-14 09:16:31.898369|INFO |Accounting | | licensed to : CZGames.dk
    2010-09-14 09:16:31.899524|INFO |Accounting | | type : Hoster
    2010-09-14 09:16:31.900944|INFO |Accounting | | starting date : Tue Aug 31 00:00:00 2010
    2010-09-14 09:16:31.902063|INFO |Accounting | | ending date : Wed Aug 31 00:00:00 2011
    2010-09-14 09:16:31.903483|INFO |Accounting | | max virtualservers: 2500
    2010-09-14 09:16:31.904573|INFO |Accounting | | max slots : 25000
    2010-09-14 09:16:31.961122|INFO |FileManager | | listening on 192.168.1.40:30033
    2010-09-14 09:16:32.158592|INFO |VirtualServer | 1| listening on 192.168.1.40:9988
    2010-09-14 09:16:32.160202|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1, 192.168.1.1, 192.168.1.40, 92.62.196.69,
    2010-09-14 09:16:32.161865|INFO |Query | | listening on 192.168.1.40:10011
    Is there a limit on the length in descriptions?

    //DKLeader

  7. #7
    Join Date
    December 2009
    Posts
    237
    Hi,
    as you seem to have an athp license i'll assume that you have access to a sufficient ammount of hardware, performance and knowledge.

    In any case, your connection to the MySQL server seems to not be stable enough.
    Is the server hosting the MySQL DB in the same local network as the ts3 server?
    If not try moving it to the local network or even to the same machine the teamspeak server is running on as this not only drastically reduces the time you have to wait for all servers and their channels to be loaded on a box with many servers but also ensures the stability of the connection between database and server.

    The second serverlog you posted only shows a correct startup of the server. The important parts would have been the entries concerning the connection of a user as it is at this moment where a lot of database operations come into play.

    Concerning your descriptions :
    The description field in the database is a Varchar with length 255 by default. You can insert a description longer than that but upon serverrestart it will be cut.
    Also special characters like å or ø take up more than 1 character.
    You can increase the maximum length of the descriptions by changing the type of the description field to Text and then setting a higher length limit.

  8. #8
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16

    Database moved

    I have now moved the database to the same server hosting TS3.

    Was trying to have databases on one server.
    The TS3 server and my db server are not in the same local network (they have there own public static IP's)

    Will test and see if this has solved my problem.

    // DKLeader

  9. #9
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16
    Still same problem.

    From nohup.out :
    TeamSpeak Server 3.0.0-beta28 [Build: 12264]
    (c)TeamSpeak Systems GmbH

    Logging started
    2010-09-14 13:04:43.586426|INFO |ServerLibPriv | | Server Version: 3.0.0-beta28 [Build: 12264], Linux
    2010-09-14 13:04:43.589599|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2010-09-14 13:04:43.589776|INFO |DatabaseQuery | | dbPlugin version: 1
    2010-09-14 13:04:53.634599|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
    2010-09-14 13:04:54.063060|INFO |Accounting | | Licensing Information
    2010-09-14 13:04:54.064842|INFO |Accounting | | licensed to : CZGames.dk
    2010-09-14 13:04:54.065942|INFO |Accounting | | type : Hoster
    2010-09-14 13:04:54.067017|INFO |Accounting | | starting date : Tue Aug 31 00:00:00 2010
    2010-09-14 13:04:54.067968|INFO |Accounting | | ending date : Wed Aug 31 00:00:00 2011
    2010-09-14 13:04:54.068956|INFO |Accounting | | max virtualservers: 2500
    2010-09-14 13:04:54.069955|INFO |Accounting | | max slots : 25000
    2010-09-14 13:04:54.119278|ERROR |FileManager | | bind() failed: 98
    2010-09-14 13:04:54.120231|ERROR |FileManager | | bind failed on 192.168.1.40:30033
    2010-09-14 13:04:54.308918|ERROR |VirtualServer | 1| bind failed on 192.168.1.40:9988
    2010-09-14 13:04:54.310052|ERROR |VirtualSvrMgr | | loading VirtualServer(1) failed to start, error: unable to bind network port
    2010-09-14 13:04:54.338604|INFO |VirtualServer | 1| stopped
    2010-09-14 13:04:54.340210|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1, 192.168.1.1, 192.168.1.40, 92.62.196.69,
    2010-09-14 13:04:54.341459|ERROR |Query | | 192.168.1.40:10011 unable to bind error: 98:Address already in use
    2010-09-14 13:04:54.342630|ERROR |Query | | bind failed on 192.168.1.40:10011
    2010-09-14 13:04:54.586754|ERROR | | | read invalid packet size size
    2010-09-14 13:05:01.682822|INFO |VirtualServer | 1| client connected 'DKLeader'(id:2) from 92.62.196.68:51282
    2010-09-14 16:43:11.499099|INFO |VirtualServer | 1| server was edited by 'DKLeader'(id:2)
    2010-09-14 16:43:14.533177|INFO |VirtualServer | 1| client disconnected 'DKLeader'(id:2) reason 'reasonmsg=leaving'
    2010-09-14 16:58:45.062385|ERROR |DatabaseQuery | | db_exec() select count(*) as unread from messages where message_to_client_id= 2 error: Lost connection to MySQL server during query
    Any ideas?

    //DKLeader

  10. #10
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16

    Observation

    It seems that the server lock-ups if a setting is changed and the length (ex in a value with max varchar(255) ) is exceeded in the mysql database.

    I have tried it a few times now and same happens every time I change a describtion and the length of the text is longer than varchar is set to.

    // DKLeader

  11. #11
    Join Date
    May 2010
    Posts
    6,310
    This message in your server log

    2010-09-14 13:04:54.341459|ERROR |Query | | 192.168.1.40:10011 unable to bind error: 98:Address already in use
    2010-09-14 13:04:54.342630|ERROR |Query | | bind failed on 192.168.1.40:10011
    2010-09-14 13:04:54.586754|ERROR | | | read invalid packet size size
    show you that you have another teamspeak instance running.

    Stop all (kill -9) before start your server.

  12. #12
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16
    Tried it after reading my post - and still have the same problem.
    And found out that the length of inputs in the database is not the case.

    This is the latest from restart to crash (copied from nohup.out)
    TeamSpeak Server 3.0.0-beta28 [Build: 12264]
    (c)TeamSpeak Systems GmbH

    Logging started
    2010-09-15 06:10:04.343570|INFO |ServerLibPriv | | Server Version: 3.0.0-beta28 [Build: 12264], Linux
    2010-09-15 06:10:04.345735|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2010-09-15 06:10:04.345836|INFO |DatabaseQuery | | dbPlugin version: 1
    2010-09-15 06:10:09.414254|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
    2010-09-15 06:10:09.841234|INFO |Accounting | | Licensing Information
    2010-09-15 06:10:09.843028|INFO |Accounting | | licensed to : CZGames.dk
    2010-09-15 06:10:09.844138|INFO |Accounting | | type : Hoster
    2010-09-15 06:10:09.845317|INFO |Accounting | | starting date : Tue Aug 31 00:00:00 2010
    2010-09-15 06:10:09.846449|INFO |Accounting | | ending date : Wed Aug 31 00:00:00 2011
    2010-09-15 06:10:09.847414|INFO |Accounting | | max virtualservers: 2500
    2010-09-15 06:10:09.848406|INFO |Accounting | | max slots : 25000
    2010-09-15 06:10:09.898066|INFO |FileManager | | listening on 192.168.1.40:30033
    2010-09-15 06:10:10.059546|INFO |VirtualServer | 1| listening on 192.168.1.40:9988
    2010-09-15 06:10:10.061061|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1, 192.168.1.1, 192.168.1.40, 92.62.196.69,
    2010-09-15 06:10:10.062497|INFO |Query | | listening on 192.168.1.40:10011
    2010-09-15 06:10:26.964160|INFO |VirtualServer | 1| client connected 'DKLeader'(id:2) from 92.62.196.68:51282
    2010-09-15 06:10:39.330510|INFO |VirtualServer | 1| client connected 'DKLeader1'(id:3) from 92.62.196.68:49732
    2010-09-15 06:10:46.101280|INFO |VirtualServer | 1| client disconnected 'DKLeader'(id:2) reason 'reasonmsg=leaving'
    2010-09-15 06:10:48.327321|INFO |VirtualServer | 1| client connected 'DKLeader'(id:2) from 92.62.196.68:51282
    2010-09-15 06:11:07.952835|INFO |VirtualServer | 1| query client connected 'serveradmin from 92.62.196.70:44267'(id:1)
    2010-09-15 06:11:07.998020|INFO |VirtualServer | 1| query client disconnected 'serveradmin from 92.62.196.70:44267'(id:1) reason 'reasonmsg=connection lost'
    2010-09-15 06:12:29.793566|INFO |VirtualServer | 2| listening on 192.168.1.40:9989
    2010-09-15 06:12:29.795527|INFO |VirtualServer | 2| client 'server'(id:0) added privilege key for servergroup 'Server Admin'(id:11)
    2010-09-15 06:12:29.796588|WARNING |VirtualServer | 2| --------------------------------------------------------
    2010-09-15 06:12:29.797524|WARNING |VirtualServer | 2| ServerAdmin privilege key created, please use the line below
    2010-09-15 06:12:29.798664|WARNING |VirtualServer | 2| token=something
    2010-09-15 06:12:29.799811|WARNING |VirtualServer | 2| --------------------------------------------------------

    ------------------------------------------------------------------
    I M P O R T A N T
    ------------------------------------------------------------------
    ServerAdmin privilege key created, please use it to gain
    serveradmin rights for your virtualserver. please
    also check the doc/token_guide.txt for details.

    token=something
    ------------------------------------------------------------------

    2010-09-15 06:12:29.800943|INFO |VirtualSvrMgr | | addServer() VirtualServer(2) started
    2010-09-15 06:12:33.032673|INFO |VirtualServer | 1| query client connected 'serveradmin from 92.62.196.70:44277'(id:1)
    2010-09-15 06:12:33.103705|INFO |VirtualServer | 1| query client disconnected 'serveradmin from 92.62.196.70:44277'(id:1) reason 'reasonmsg=connection lost'
    2010-09-15 06:12:39.126585|INFO |VirtualServer | 1| client disconnected 'DKLeader'(id:2) reason 'reasonmsg=leaving'
    2010-09-15 06:13:07.247764|INFO |VirtualServer | 2| client (id:6) was added to servergroup 'Server Admin'(id:11) by client 'server'(id:0)
    2010-09-15 06:13:07.251513|INFO |VirtualServer | 2| client 'DKLeader'(id:6) used privilege key 'something' and was added to servergroup 'Server Admin'(id:11)
    2010-09-15 06:15:54.739125|INFO |VirtualServer | 1| query client connected 'serveradmin from 92.62.196.70:45045'(id:1)
    2010-09-15 06:15:54.784822|INFO |VirtualServer | 1| query client disconnected 'serveradmin from 92.62.196.70:45045'(id:1) reason 'reasonmsg=connection lost'
    2010-09-15 06:17:34.174209|INFO |VirtualServer | 1| client connected 'DKLeader'(id:2) from 92.62.196.68:51282
    2010-09-15 06:17:38.513392|INFO |VirtualServer | 1| client disconnected 'DKLeader'(id:2) reason 'reasonmsg=leaving'
    2010-09-15 06:19:51.446875|INFO |VirtualServer | 1| query client connected 'serveradmin from 92.62.196.70:46363'(id:1)
    2010-09-15 06:19:51.492336|INFO |VirtualServer | 1| query client disconnected 'serveradmin from 92.62.196.70:46363'(id:1) reason 'reasonmsg=connection lost'

  13. #13
    Join Date
    May 2008
    Location
    Denmark, Ishoej
    Posts
    16

    [solved]

    I think this can be closed.

    Hav 2 "speak" servers running on same router and was sure I did the move of the database to the one hosting my teamspeak servers. But since both are running mysql and did from phpmyadmin I moved it to the wrong server. Have now moved it to the right server and I have not been having any problems the last few hours.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •