Forum

Results 1 to 2 of 2
  1. #1
    Join Date
    December 2012
    Posts
    7

    Server crashes setSQLfromFile( file:sql/client_delete_prune.sql) failed

    Hey,

    my server was running fine for years and now it starts crashing.
    It can crash after few minutes or after some hours. It can even run a whole day without problem and then boom. Disconnected.
    Then I updated to 3.1.2 (Linux) and it still crashes.

    The Errormessage is everytime something like this:
    2018-04-27 14:45:27.469364|CRITICAL|DatabaseQuery | |setSQLfromFile( file:sql/client_get_by_uid.sql) failed
    or
    2018-04-27 14:13:03.457434|CRITICAL|DatabaseQuery | |setSQLfromFile( file:sql/client_delete_prune.sql) failed

    Once before the upgrade (had 3.0.12.3) I got this:
    Code:
    2018-04-26 17:52:49.453406|WARNING |CIDRManager   |   |unable to load query_ip_blacklist, filename: query_ip_blacklist.txt
    2018-04-26 17:52:55.567452|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:52:55.567944|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 17:52:55.568176|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:52:55.568570|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:52:55.568917|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:52:55.571497|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:53:15.451858|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:53:28.520867|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:53:37.409808|ERROR   |DatabaseQuery |   |db_open() select distinct c.client_id, c.server_id from (clients c left outer jo error: disk I/O error
    2018-04-26 17:55:02.652074|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:55:14.457104|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 17:56:37.408851|ERROR   |DatabaseQuery |   |db_open() select distinct c.client_id, c.server_id from (clients c left outer jo error: disk I/O error
    2018-04-26 17:56:52.603724|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 17:57:38.711975|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 17:58:00.070196|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:58:15.728046|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 17:59:37.409303|ERROR   |DatabaseQuery |   |db_open() select distinct c.client_id, c.server_id from (clients c left outer jo error: disk I/O error
    2018-04-26 18:00:02.093697|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 18:00:09.338894|ERROR   |DatabaseQuery |   |db_open() select * from clients where client_unique_id = 'HERE WAS AN ID error: disk I/O error
    2018-04-26 18:02:27.498868|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 18:02:37.409896|ERROR   |DatabaseQuery |   |db_open() select distinct c.client_id, c.server_id from (clients c left outer jo error: disk I/O error
    2018-04-26 18:04:52.521056|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: disk I/O error
    2018-04-26 18:04:59.930670|INFO    |ServerMain    |   |Received signal SIGTERM, shutting down.
    Do anyone know how to fix this?

    Best Regards
    UVCMD

  2. #2
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,344
    Disk I/O error means that the database (and maybe your disk) is broken. Use a working backup or use the sqlite3 command to pipe recoverable information into a new database (unsupported and not guaranteed to work).

    This thread BTW is not TeamSpeak-related in any way.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MySQL: setSQLfromFile( file:sql/update_1.sql) failed
    By tgp1994 in forum Server Support
    Replies: 7
    Last Post: February 19th, 2018, 04:33 PM
  2. Replies: 1
    Last Post: March 15th, 2016, 12:42 PM
  3. setSQLfromFile( file:sql/update_1.sql) failed
    By pHaeno* in forum Server Support
    Replies: 1
    Last Post: March 11th, 2016, 10:21 AM
  4. Replies: 1
    Last Post: April 3rd, 2013, 02:21 PM
  5. setSQLfromFile( file:sql\properties_list_by_id.sql) failed
    By ScathDeSolas in forum Linux / FreeBSD
    Replies: 1
    Last Post: March 16th, 2011, 04:57 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
  •