Forum

Results 1 to 3 of 3
  1. #1
    Join Date
    November 2011
    Posts
    3

    Question TS3 Crash with an sql error

    Hey guys,

    I have a teamspeak 3 and a web interface(i wrote it my self).
    But my teamspeak is crash every day with an sql error.
    Here the errors:
    PHP Code:
    2016-07-04 07:15:24.005355|INFO    |Query         |   |query from 97040 **.**.**.***:53150 issuedlogin with account "serveradmin"(serveradmin)
    2016-07-04 07:15:24.607534|INFO    |Query         |   |query from 97042 **.**.**.***:53168 issuedlogin with account "serveradmin"(serveradmin)
    2016-07-04 07:15:25.026557|INFO    |Query         |   |query from 97043 **.**.**.***:53172 issuedlogin with account "serveradmin"(serveradmin)
    2016-07-04 07:15:25.285493|INFO    |Query         |   |query from 97043 **.**.**.***:53172 issuedlogin with account "serveradmin"(serveradmin)
    2016-07-04 07:18:44.522836|CRITICAL|DatabaseQuery |   |setSQLfromFilefile:sql/client_get_by_uid.sqlfailed 
    Long time ago my teamspeak frozen(clients can connect but telnet doesn't responding), so i have to stop the server and i wrote stop command, but server didn't stop so i had to kill server, i killed server with kill PROCESSID, after this event every day my teamspeak crash with this sql error.
    1) Why my teamspeak frozen(clients can connect but telnet doesn't responding and server doesn't stop)
    2) How can fix this sql error, do i have to create a new database file ?

    Info:
    I start the server with: ts3server_startscript.sh start inifile=ts3server.ini

    ts3server.ini
    PHP Code:
    machine_id=1
    default_voice_port
    =9987
    voice_ip
    =**.**.**.***
    filetransfer_ip=**.**.**.***
    filetransfer_port=*****
    query_ip=**.**.**.***
    query_port=*****
    dbplugin=ts3db_sqlite3
    dbpluginparameter
    =
    dbsqlpath=sql/
    dbsqlcreatepath=create_sqlite/
    logpath=logs/
    logquerycommands=0
    serveradmin_password
    =***********
    ulimit -c 500000 

  2. #2
    Join Date
    November 2011
    Posts
    3
    Now it crashed with different error, i guess there is a exploit

    PHP Code:
    2016-07-06 18:22:23.430877|CRITICAL|Connection    |   |Assertion "!m_cryptoInitComplete" failed at ../../../../s/deps/teamspeak_common_lib/src/connection.cpp:363
    Edit: Fixed this one with upgrading the teamspeak 3 version.
    But the first error still makes crashes.
    Last edited by dangerlord63; July 6th, 2016 at 10:12 PM.

  3. #3
    Join Date
    June 2008
    Posts
    18,409
    This crash is from outdated server 3.0.12.3.
    http://forum.teamspeak.com/threads/1...ection-cpp-363
    Please update your server http://www.teamspeak.com/downloads

    About your main post, i would say your SQL server is to slow or could not be reached several times.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Teamspeak 3 error(Crash)
    By aza_kick in forum Windows
    Replies: 0
    Last Post: June 5th, 2011, 12:11 AM
  2. Crash on startup, error (0xc0150002)
    By D3u577 in forum Windows
    Replies: 38
    Last Post: September 2nd, 2010, 04:11 PM

Tags for this Thread

Posting Permissions

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