Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: MySQL server is always gone away  (Read 4437 times)

0 Members and 1 Guest are viewing this topic.

GhosT

  • Anope User
  • Offline Offline
  • Posts: 43
MySQL server is always gone away
« on: March 02, 2011, 08:49:08 AM »

I always get Denora disconnected from MySQL server. I have looked in log file but could not figure out what happens.

Here are the software I am running:
  • Host OS: Linux hostname 2.6.18-194.26.1.el5.028stab079.2 #1 SMP Fri Dec 17 19:25:15 MSK 2010 x86_64 x86_64 x86_64 GNU/Linux
  • Inspircd 2.0
  • Anope 1.8.5
  • Denora 1.4.5 (just installed)

The remote MySQL server is from different host. I already added the permission and I am sure that it has access to mysql database (I tested it by log in from denora machine to remote mysql server).

Here are some log lines:
Code: [Select]
[Mar 02 15:42:14.215550 2011] debug: Sent: :22AAAAAAB NOTICE 531AAABG1 :SQL is enabled
[Mar 02 15:42:18.221024 2011] MySQL server has gone away, trying to reconnect...
[Mar 02 15:42:18.221173 2011] debug: Sent: :22AAAAAAB PRIVMSG #services :MySQL server has gone away, trying to reconnect...
[Mar 02 15:42:18.221276 2011] MySQL Client Flag for IGNORE SIGPIPE is set on
[Mar 02 15:42:18.223166 2011] MySQL connection reestablished
[Mar 02 15:42:18.223355 2011] debug: Sent: :22AAAAAAB PRIVMSG #services :MySQL connection reestablished
[Mar 02 15:42:19.305757 2011] debug: Received: :531AAABG1 PRIVMSG #cit :!top
[Mar 02 15:43:00.361142 2011] debug: Received: :314 PING 314 22A
[Mar 02 15:43:00.361238 2011] debug: Sent: :22A PONG 314
[Mar 02 15:43:03.483309 2011] debug: Received: :531 PING 531 22A
[Mar 02 15:43:03.483398 2011] debug: Sent: :22A PONG 531
[Mar 02 15:44:00.723368 2011] debug: Received: :314 PING 314 22A
[Mar 02 15:44:00.723657 2011] debug: Sent: :22A PONG 314
[Mar 02 15:44:00.723714 2011] debug: Saving FFF information to disk
[Mar 02 15:44:00.727469 2011] MySQL server has gone away, trying to reconnect...
[Mar 02 15:44:00.727610 2011] debug: Sent: :22AAAAAAB PRIVMSG #services :MySQL server has gone away, trying to reconnect...
[Mar 02 15:44:00.727671 2011] MySQL Client Flag for IGNORE SIGPIPE is set on
[Mar 02 15:44:00.729318 2011] MySQL connection reestablished
[Mar 02 15:44:00.729522 2011] debug: Sent: :22AAAAAAB PRIVMSG #services :MySQL connection reestablished
[Mar 02 15:44:00.730217 2011] debug: Sent: :22A PING 22A :3AX
[Mar 02 15:44:00.730298 2011] debug: Sent: :22A PING 22A :531
[Mar 02 15:44:00.730329 2011] debug: Sent: :22A PING 22A :314
[Mar 02 15:44:00.730500 2011] debug: Received: :314 PONG 314 22A
[Mar 02 15:44:00.730537 2011] debug: Ping Time from 314 : 0 = 1299055440 - 1299055440
[Mar 02 15:44:00.770200 2011] debug: Received: :3AX PONG 3AX 22A
[Mar 02 15:44:00.770277 2011] debug: Ping Time from 3AX : 0 = 1299055440 - 1299055440
[Mar 02 15:44:00.818086 2011] debug: Received: :531 PONG 531 22A
[Mar 02 15:44:00.818171 2011] debug: Ping Time from 531 : 0 = 1299055440 - 1299055440
[Mar 02 15:45:00.870505 2011] debug: Received: :314 PING 314 22A
[Mar 02 15:45:00.870591 2011] debug: Sent: :22A PONG 314
[Mar 02 15:46:00.873534 2011] debug: Saving FFF information to disk
[Mar 02 15:46:00.877341 2011] MySQL server has gone away, trying to reconnect...
[Mar 02 15:46:00.877510 2011] debug: Sent: :22AAAAAAB PRIVMSG #services :MySQL server has gone away, trying to reconnect...
[Mar 02 15:46:00.877571 2011] MySQL Client Flag for IGNORE SIGPIPE is set on
[Mar 02 15:46:00.879700 2011] MySQL connection reestablished
[Mar 02 15:46:00.879777 2011] debug: Sent: :22AAAAAAB PRIVMSG #services :MySQL connection reestablished
[Mar 02 15:46:00.880362 2011] debug: Sent: :22A PING 22A :3AX

Any help?
Logged

Jobe

  • Contributor
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 1023
    • Anope IRC Services
Re: MySQL server is always gone away
« Reply #1 on: March 02, 2011, 10:47:28 AM »

This error is in my own experiance usually caused by one of 2 things. 1) The MySQL server was stopped or crashed 2) the MySQL server has limits on how long a MySQL connection can remain connected for.

For 1 there's not a lot you can do about that short of not stopping the server or fixing whatver causes it to crash. For 2 you need to configure MySQL to allow your Denora user to remain connected indefinately without any limits on the ammount of data it can send per connection.

The good news is that because Denora is able to reconnect to MySQL you should be able to just ignore the error.
Logged
Your IP: ()
My IRC Status:

Come along and visit http://www.anopequotes.org/

GhosT

  • Anope User
  • Offline Offline
  • Posts: 43
Re: MySQL server is always gone away
« Reply #2 on: March 02, 2011, 11:51:36 AM »

Well, I remembered that it was working fine with the same MySQL server before with 1.4.4 when I used Inspircd 1.2. After I upgraded IRCD to Inspircd 2.0 with Denora 1.4.5, that problem occured.

Actually, the MySQL Server is a VE node of a host box which Denora is running on. So I think that, the connection and data sending/receiving to and from MySQL server should be OK.

Anyways, any suggestion on MySQL configuration then?
Logged

GhosT

  • Anope User
  • Offline Offline
  • Posts: 43
Re: MySQL server is always gone away
« Reply #3 on: March 03, 2011, 12:40:49 PM »

It seems working now. I adjusted some value of my.cnf.
Logged
Pages: [1]   Go Up