Forum

Results 1 to 4 of 4

Thread: Database Error

  1. #1
    Join Date
    July 2018
    Location
    California, USA
    Posts
    14

    Database Error

    Server Version: 3.3.1 on Linux
    DB being used: MariaDB (used same database since server version 3.1.0)

    PHP Code:
    2018-09-23 05:26:33.970127|ERROR   |DatabaseQuery |   |db_open() select from servers where server_port 9987errorCan't connect to MySQL server on '127.0.0.1' (107)
    2018-09-23 05:26:59.651464|ERROR   |DatabaseQuery |   |db_open() select distinct c.client_id, c.server_id from (clients c left outer jo error: Can'
    t connect to MySQL server on '127.0.0.1' (107 
    PHP Code:
    2018-09-23 06:36:12.245457|ERROR   |DatabaseQuery |   |db_open() select from clients where client_unique_id 'ServerQuery' and serve errorCan't connect to MySQL server on '127.0.0.1' (107)
    2018-09-23 06:50:07.845528|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: Can'
    t connect to MySQL server on '127.0.0.1' (107

    Above I simply copied some of the errors I was getting to showcase them to you, but they are repeated frequently, as you can see in the pictures below. Log file ends up being over 3000 lines of this, with the pictures only incorporating the top of the log file.
    (1/2) Click image for larger version. 

Name:	WinSCP_2018-09-23_11-20-20.png 
Views:	56 
Size:	241.0 KB 
ID:	17137
    (2/2) Click image for larger version. 

Name:	WinSCP_2018-09-23_11-21-53.png 
Views:	91 
Size:	249.3 KB 
ID:	17138

    This all ends up resulting in the TeamSpeak client as '<11:10:53> database error' when I attempt to connect. This is currently happening about every 2 weeks for the past 2-3 months with a simple server restart resolving the issue temporarily.

    A remedy to this issue would be much appreciated,
    $harpY

  2. #2
    Join Date
    December 2004
    Location
    RF
    Posts
    3,006
    You have to "remedy" this yourself, it is your server and your database after all.

  3. #3
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,350
    Maybe server crashed.
    Another reason why it is highly recommended for end users to use SQLite.

  4. #4
    Join Date
    July 2018
    Location
    California, USA
    Posts
    14
    Quote Originally Posted by numma_cway View Post
    Maybe server crashed.
    The server was rebooted once prior to the TeamSpeak server being properly stopped, could this cause the corruption I am possibly experiencing?

    Assuming so, would a backup of the database prior to the reboot suffice as a "remedy"?

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 NYDAITA in forum Client Support
    Replies: 0
    Last Post: June 1st, 2017, 09:40 AM
  2. Database Error
    By Speshals in forum Server Support
    Replies: 2
    Last Post: July 24th, 2015, 09:11 AM
  3. database error
    By shayran in forum Windows
    Replies: 6
    Last Post: March 29th, 2012, 06:08 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
  •