Forum

Results 1 to 10 of 10
  1. #1
    Join Date
    February 2012
    Location
    Nuremberg, Bavaria
    Posts
    258

    Updated to server version 3.0.12 and server dies

    Hi,

    I've just updated an instance from the version 3.0.11.4 to the latest version 3.0.12:

    Code:
    version
    version=3.0.12 build=1453376224 platform=Linux
    error id=0 msg=ok
    
    hostinfo
    instance_uptime=771 host_timestamp_utc=1454108317 virtualservers_running_total=2 virtualservers_total_maxclients=256 virtualservers_total_clients_online=0 virtualservers_total_channels_online=206 connection_filetransfer_bandwidth_sent=0 connection_filetransfer_bandwidth_received=0 connection_filetransfer_bytes_sent_total=0 connection_filetransfer_bytes_received_total=0 connection_packets_sent_total=0 connection_bytes_sent_total=0 connection_packets_received_total=0 connection_bytes_received_total=0 connection_bandwidth_sent_last_second_total=0 connection_bandwidth_sent_last_minute_total=0 connection_bandwidth_received_last_second_total=0 connection_bandwidth_received_last_minute_total=0
    error id=0 msg=ok
    Code:
    $ tail -f logs/ts3server_2016-01-29__21_41_24.525720_*
    ==> logs/ts3server_2016-01-29__21_41_24.525720_0.log <==
    2016-01-29 21:41:24.525924|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.12 (2016-01-21 11:37:04)
    2016-01-29 21:41:24.536962|INFO    |ServerLibPriv |   |SystemInformation: Linux 3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u5 x86_64 Binary: 64bit
    2016-01-29 21:41:24.539723|INFO    |DatabaseQuery |   |dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
    2016-01-29 21:41:24.539845|INFO    |DatabaseQuery |   |dbPlugin version: 3.6.21
    2016-01-29 21:41:24.541195|INFO    |DatabaseQuery |   |checking database integrity (may take a while)
    2016-01-29 21:41:25.014416|INFO    |Accounting    |   |Licensing Information
    2016-01-29 21:41:25.014560|INFO    |Accounting    |   |licensed to       : Max Mustermann
    2016-01-29 21:41:25.014626|INFO    |Accounting    |   |type              : Hoster
    2016-01-29 21:41:25.014717|INFO    |Accounting    |   |starting date     : Sat May 30 00:00:00 2015
    2016-01-29 21:41:25.014782|INFO    |Accounting    |   |ending date       : Mon May 30 00:00:00 2016
    2016-01-29 21:41:25.014838|INFO    |Accounting    |   |max virtualservers: 5
    2016-01-29 21:41:25.014892|INFO    |Accounting    |   |max slots         : 256
    2016-01-29 21:41:26.042534|INFO    |              |   |Puzzle precompute time: 960
    2016-01-29 21:41:26.042773|INFO    |FileManager   |   |listening on 0.0.0.0:30033
    2016-01-29 21:41:26.262778|INFO    |CIDRManager   |   |updated query_ip_whitelist ips: 127.0.0.1,
    2016-01-29 21:41:26.263078|INFO    |Query         |   |listening on 0.0.0.0:10011
    
    ==> logs/ts3server_2016-01-29__21_41_24.525720_1.log <==
    2016-01-29 21:41:26.170179|INFO    |VirtualServer |1  |listening on 0.0.0.0:9987
    
    ==> logs/ts3server_2016-01-29__21_41_24.525720_2.log <==
    2016-01-29 21:41:26.262510|INFO    |VirtualServer |2  |listening on 0.0.0.0:9988
    The server was online for about 32 minutes and after that, it just crashed. Since that I've fully stopped the instance, deleted all log files and started the instance again. The server tells me, that it was started successful, but when I try to connect, the server dies:
    Code:
    ==> logs/ts3server_2016-01-29__21_41_24.525720_0.log <==
    2016-01-29 21:42:09.375923|ERROR   |DatabaseQuery |   |invalid parameter found :value:
    2016-01-29 21:42:09.376175|ERROR   |DatabaseQuery |   |db_exec failed near ":tablename": syntax error
    2016-01-29 21:42:09.376266|ERROR   |DatabaseQuery |   |db_exec() insert into :tablename: ( server_id, id, ident, value) values (:server error: near ":tablename": syntax error
    2016-01-29 21:42:09.376336|ERROR   |              |   |unable to save properties to: client_properties
    2016-01-29 21:42:09.380499|CRITICAL|Client        |2  |Assertion "m_ClientDBID != 0" failed at ../../../../s/deps/teamspeak_common_lib/src/chanclients/client.cpp:245;
    2016-01-29 21:42:09.380499|CRITICAL|Client        |2  |Assertion "m_ClientDBID != 0" failed at ../../../../s/deps/teamspeak_common_lib/src/chanclients/client.cpp:245;
    It seems to be an change on the database structure, but I didn't found an update for under sql/updates_and_fixes/.

    Can somebody explain me this problem and tell me, how to solve it? Thanks in advance!
    Last edited by Sebi94; January 29th, 2016 at 11:58 PM. Reason: Added ServerQuery version and hostinfo output

  2. #2
    Join Date
    February 2012
    Location
    Germany
    Posts
    576
    It may be that you didn't fully update all the *.sql files in the sql/ subdirectory. Some changed with the current server release.

  3. #3
    Join Date
    February 2012
    Location
    Nuremberg, Bavaria
    Posts
    258
    What the f... I've just downloaded and uploaded the full archive file and what happened? Two SQL files were missing...

    Thanks @Schlumpi!

  4. #4
    Join Date
    March 2014
    Posts
    1
    What was this files? Where did you get them?
    I have the same problem with 64 bit version with dbases.
    And second question: I downloaded update and I can see only tsserver.exe and there is no tsserver_win64.exe. Is it normal?

  5. #5
    Join Date
    June 2008
    Posts
    18,396
    He just downloaded the server package again and did overwite his files again.
    http://www.teamspeak.com/downloads
    And he is a linux user and not on windows.

    Server 3.0.12 only uses ts3server for all server binary instead of using the operation system in the binary name. This is normal.
    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?

  6. #6
    Join Date
    February 2016
    Posts
    1

    Server crashes when connecting with android

    I am having similar issues as you are. how did you fix this issue?

    here is my log

    Code:
    2016-02-27 06:49:47.941900|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
    2016-02-27 06:49:47.941900|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-02-27 06:49:47.941900|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-02-27 06:49:47.942900|ERROR   |Variables     |   | unable to save ident: client_created value: 1456555787
    2016-02-27 06:49:47.943900|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
    2016-02-27 06:49:47.944900|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-02-27 06:49:47.944900|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-02-27 06:49:47.944900|ERROR   |Variables     |   | unable to save ident: client_flag_avatar value: 
    2016-02-27 06:49:47.945900|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
    2016-02-27 06:49:47.946901|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-02-27 06:49:47.946901|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-02-27 06:49:47.947901|ERROR   |Variables     |   | unable to save ident: client_description value: 
    2016-02-27 06:49:47.948901|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
    2016-02-27 06:49:47.949901|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-02-27 06:49:47.949901|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-02-27 06:49:47.949901|ERROR   |Variables     |   | unable to save ident: client_unread_messages value: 0
    2016-02-27 06:49:47.973902|CRITICAL|Client        |  2| Assertion "m_ClientDBID != 0" failed at common\chanclients\client.cpp:239;

  7. #7
    Join Date
    April 2016
    Posts
    1

    Server Crashing Critical Client

    Since a few days ago, when a friend tries to conect to my server, it crashes. How can I fix this?
    Log file attched.
    Tks
    Attached Files Attached Files
    Last edited by dante696; April 25th, 2016 at 09:48 AM. Reason: merged, does not belong into server dump section

  8. #8
    Join Date
    February 2012
    Location
    Nuremberg, Bavaria
    Posts
    258
    @swsadmin:
    Quote Originally Posted by Sebi94 View Post
    I've just downloaded and uploaded the full archive file
    It seems like, that a SQL fix hasn't been imported at your server.

    Same for you @betovicente. Please download and upload the files again.

  9. #9
    Join Date
    January 2016
    Posts
    4
    Just updated my server to version Server 64-bit 3.0.12.4 and having same issue. Any idea how to fix it?

    Code:
    2016-06-12 20:31:16.073187|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-06-12 20:31:16.073187|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-06-12 20:31:16.073187|ERROR   |Variables     |   | unable to save ident: channel_flag_semi_permanent value: 0
    2016-06-12 20:31:16.073187|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
    2016-06-12 20:31:16.074188|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-06-12 20:31:16.074188|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-06-12 20:31:16.074188|ERROR   |Variables     |   | unable to save ident: channel_flag_default value: 1
    2016-06-12 20:31:16.074188|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
    2016-06-12 20:31:16.074188|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
    2016-06-12 20:31:16.074188|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
    2016-06-12 20:31:16.074188|ERROR   |Variables     |   | unable to save ident: channel_flag_password value: 0
    2016-06-12 20:31:16.074188|ERROR   |DatabaseQuery |   | invalid parameter found :value*:

  10. #10
    Join Date
    June 2008
    Posts
    18,396
    Please post the beginning of the server log.

    As as explained before, the main report here was about an older version and the user have used the old server binary.
    Last edited by dante696; June 5th, 2018 at 04:22 PM.
    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. Old Version Instead Of The Updated One
    By Gincal in forum Off Topic
    Replies: 3
    Last Post: November 24th, 2015, 08:32 AM
  2. [Resolved] Updated Sever to newest Version, Wont Start Now
    By slamanna212 in forum Linux / FreeBSD
    Replies: 3
    Last Post: October 7th, 2014, 03:46 PM
  3. Replies: 3
    Last Post: January 19th, 2010, 09:33 AM

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
  •