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

Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    February 2012
    Posts
    1

    Server Crash (db_database.cpp:113;)

    Hello,

    today my teamspeak server suddenly crashed. Error message was:

    2013-04-13 10:35:33.706909|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    I tryed to restart the teamspeak server and the whole vServer, still same error. I already googled it but i didn't find anything useful. Any ideas to fix it?

    finalgamer

  2. #2
    Join Date
    June 2008
    Posts
    18,513
    Does that happen with server 3.0.7.1 ?
    Could you please send me your databse in a private message? So we can have a look at this on monday.
    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?

  3. #3
    Join Date
    December 2013
    Location
    Poland
    Posts
    17
    Hi
    I have the same problem

    Code:
    2014-03-15 06:04:50.973246|CRITICAL|DatabaseQuery |   | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    How to fix it?

  4. #4
    Join Date
    September 2012
    Posts
    6,079
    No Information = no Help!

    Post complete logs and mention your environment, server version etc.

    You should also update to the latest version if not already done. Current version at the time of writing is 3.0.10.3
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

  5. #5
    Join Date
    November 2008
    Location
    Romania
    Posts
    12
    Hi guys,

    Sorry for the necro of the 3 months old answer, but after upgrading the server I started having the same problem again.

    Now, here is what I know after being able to stop the server from crashing!
    * I initially configured the server to use a specific user account to run (teamspeak)
    * When running the server after the update, it crashes
    * If i run the server as root, it works fine.
    * just in case I chmod over the whole TS3 folder over again so that the user "teamspeak" has full access
    * Also, I am not running Teamspeak 3 with a MySQL database (so i guess it is using the lightSQL or other)
    * There is no information in the logs, cleaned it, and when the server crashes, it crashes bad. (No log in the TS3 logs)

    Since i don't have the source, I was wondering if you could tell me which file the system is trying to access or if it is trying to access my MySQL server (yes I am running one but not for TS) so that I can fix the permission so that I can run the server again as user "teamspeak"

    Regards

  6. #6
    Join Date
    June 2008
    Posts
    18,513
    Chryzo

    The answer above counts too!
    What server, what OS etc.....

    The server does use SQLite per default setting and not MYSQL.
    http://forum.teamspeak.com/showthrea...ighlight=mysql
    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?

  7. #7
    Join Date
    November 2008
    Location
    Romania
    Posts
    12
    Linux Ubuntu 13.

    But I did a massive upgrade and updated a lot of package. No problems anymore at the moment. That error must come from an incompatibility or something between 2 applications.

  8. #8
    Join Date
    December 2009
    Location
    Russia
    Posts
    63

    Exclamation error

    Starting the TeamSpeak 3 server
    TeamSpeak 3 server started, for details please view the log file
    [email protected]:~$ 2014-07-18 15:38:24.656292|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;


    How fix it?

  9. #9
    Join Date
    January 2015
    Posts
    4

    Server Crashes with Datebase-Error

    My TeamSpeak Server crashed on the 27th of December and was unable to launch again.

    whenever i start it putty prints following error
    |CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    I tried to backup the server, because our host emailed my that some data could've been corrupted during to a network-issue.
    After the backup from 25.12.2015 was installed the server lauched without any problems again.
    However 2 days later the server crashed with the same problem again.

    This is my newest serverlog:
    2015-01-01 18:16:17.085238|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.10.3 (2014-01-01 16:28:39)
    2015-01-01 18:16:17.085546|INFO |ServerLibPriv | | SystemInformation: Linux 2.6.32-042stab094.7 #1 SMP Wed Oct 22 12:43:21 MSK 2014 x86_64 Binary: 64bit
    2015-01-01 18:16:17.108884|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
    2015-01-01 18:16:17.111713|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
    2015-01-01 18:16:17.131389|INFO |DatabaseQuery | | checking database integrity (may take a while)
    2015-01-01 18:16:17.339386|INFO |Accounting | | Licensing Information
    2015-01-01 18:16:17.339436|INFO |Accounting | | type : Non-profit
    2015-01-01 18:16:17.339479|INFO |Accounting | | starting date : Wed Sep 10 00:00:00 2014
    2015-01-01 18:16:17.339498|INFO |Accounting | | ending date : Thu Mar 19 00:00:00 2015
    2015-01-01 18:16:17.339514|INFO |Accounting | | max virtualservers: 10
    2015-01-01 18:16:17.339529|INFO |Accounting | | max slots : 512
    2015-01-01 18:16:18.631239|INFO | | | Puzzle precompute time: 1260
    2015-01-01 18:16:18.650842|INFO |FileManager | | listening on 0.0.0.0:30033
    2015-01-01 18:16:18.650879|INFO |VirtualSvrMgr | | executing monthly interval
    2015-01-01 18:16:18.663090|INFO |VirtualSvrMgr | | reset virtualserver traffic statistics
    2015-01-01 18:16:18.814526|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1, 85.25.120.233,
    2015-01-01 18:16:18.814942|INFO |Query | | listening on 0.0.0.0:10011
    2015-01-03 10:17:10.066902|ERROR |DatabaseQuery | | db_exec failed unable to open database file
    2015-01-03 10:17:10.066968|ERROR |DatabaseQuery | | db_exec() update clients set client_lastconnected=1420280229, client_totalconnec error: unable to open database file
    2015-01-03 10:17:10.066990|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    Does anyone know why my server starts to crash always so suddenly.

    It also tells me on startup the disk quota would've been exceeded.
    ts3server_startscript.sh: line 68: ts3server.pid: Disk quota exceeded
    However, neither the hard drive disk space nor the RAM are fully used yet.
    Last edited by dante696; January 3rd, 2015 at 05:24 PM. Reason: merged

  10. #10
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266
    Ask your hoster... at 2015-01-03 10:17:10 your server was unable to access the database file.

  11. #11
    Join Date
    June 2008
    Posts
    18,513
    + Please update your server to 3.0.11.2.

    We do not support outdated version on forum.
    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?

  12. #12
    Join Date
    January 2016
    Posts
    1

    Crash

    Hi,

    I have a problem since about 1 month with my TS server running on Debian 7.5, the server crashes, i have no logs, i have to reboot the server if i want to restart the TS server.

    If i try to start the TS server without rebooting i have this message :

    [email protected]***:~/teamspeak3-server_linux-amd64$ 2016-01-12 18:58:30.816610|CRITICAL|DatabaseQuery | | Assertion "err or == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;

    I have this error too :

    bash: /usr/bin/vi: Input/output error

    I bet this is an error with the server not with TS server, but i'd like to be sure.

    If someone can help, thx.
    Last edited by dante696; January 13th, 2016 at 01:43 PM. Reason: merged

  13. #13
    Join Date
    June 2008
    Posts
    18,513
    Please post more log lines. 2-3 log lines above will tell you the reason.
    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?

  14. #14
    Join Date
    November 2006
    Location
    Kent - UK
    Posts
    67

    What caused this crash? nearly a year with no issues..

    Code:
    2016-06-02 13:33:17.915884|ERROR   |DatabaseQuery |   | db_exec failed unable to open database file
    2016-06-02 13:33:17.932199|ERROR   |DatabaseQuery |   | db_exec() update clients set client_lastconnected=1464874397, client_totalconnec error: unable to open database file
    2016-06-02 13:33:17.932350|CRITICAL|DatabaseQuery |   | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    Last edited by dante696; June 3rd, 2016 at 09:07 AM. Reason: merged

  15. #15
    Join Date
    September 2012
    Posts
    6,079
    your outdated server version most likely.
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] teamspeak 3 application android crash crash crash
    By hycksou in forum Android
    Replies: 4
    Last Post: July 5th, 2017, 07:05 PM
  2. Replies: 0
    Last Post: November 18th, 2014, 10:40 PM
  3. Replies: 11
    Last Post: April 19th, 2010, 12:51 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
  •