Forum

Results 1 to 4 of 4
  1. #1
    Join Date
    December 2009
    Location
    Iowa
    Posts
    10

    Database Error after trying to reconnect

    I am using teamspeak3 amd64 latest beta 11 with a non-profit license. The server starts fine, users can connect, no errors what so ever. After a while of running, a user disconnects and wants to reconnect but it fails.

    Code:
    2009-12-30 01:46:58.452279|INFO    |VirtualServer |  1| client disconnected 'User'(id:4) reason 'reasonmsg=leaving'
    2009-12-30 01:50:13.672427|INFO    |VirtualServer |  1| client connected 'User'(id:4) from userip:58407
    2009-12-30 01:59:25.817066|INFO    |ClientQuery   |   | clientquery from userip:58407 issued: quit
    2009-12-30 03:23:35.755455|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'ZvC+Y4TvefPYuTY8k8duTz error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:43:20.705721|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'bk6DuRt6mT5reN/oOk/IE7 error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:43:28.546772|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'bk6DuRt6mT5reN/oOk/IE7 error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:43:48.609233|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'bk6DuRt6mT5reN/oOk/IE7 error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:43:56.724899|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'bk6DuRt6mT5reN/oOk/IE7 error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:44:13.213500|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'bk6DuRt6mT5reN/oOk/IE7 error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:48:02.348524|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'iulxoS3n8JSutWKrRhm1eN error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 04:48:09.582082|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'iulxoS3n8JSutWKrRhm1eN error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 06:16:33.861527|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = '1C7JC1XFzCXVlIzAsC7Cnk error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 06:16:44.731254|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = '1C7JC1XFzCXVlIzAsC7Cnk error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 06:52:28.163703|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = '1C7JC1XFzCXVlIzAsC7Cnk error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    2009-12-30 07:40:50.425249|ERROR   |DatabaseQuery |   | db_exec() select * from clients where client_unique_id = 'HKeP4oeo485ZjXT9eiQHMk error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    This has been happening since beta 1 and without a license also. The error on the client is:
    Code:
    <01:40:48> Trying to resolve hostname myhost.com
    <01:40:48> Connecting to server IP:9987
    <01:40:49> database error
    <01:40:49> Failed to connect to server
    Any ideas? We tried starting with different commands. Starting normaly and leaving the ssh client open has the same results.

  2. #2
    Join Date
    December 2009
    Location
    Good old Germany
    Posts
    222
    Hi,

    if you have this error check if your MYSQL is running with ps aux | more.

    If not you have your fault.

    Cheech

  3. #3
    Join Date
    December 2009
    Location
    Iowa
    Posts
    10
    mysql is always running, even when you cant connect because we have teamspeak on our webserver.

  4. #4
    Join Date
    February 2010
    Location
    US
    Posts
    1
    I am having a similar issue using 3.0.0-beta18 [Build: 10190]. I have not yet found a solution and the only information that I can add is that it does seem to stay functioning more often if I leave a client connected (was able to have it stay working overnight). If it stays idle for a few hours, it almost always starts failing and I have to cycle the server process.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Database Error
    By alexandrep in forum Windows
    Replies: 5
    Last Post: May 22nd, 2012, 07:29 PM
  2. database error
    By shayran in forum Windows
    Replies: 6
    Last Post: March 29th, 2012, 06:08 AM
  3. DataBase Error
    By MattyB in forum Linux / FreeBSD
    Replies: 1
    Last Post: May 23rd, 2011, 07:27 AM

Posting Permissions

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