Shaun Hofer
2007-Aug-30 00:03 UTC
[asterisk-users] Unknown connection error: (2006) MySQL server has gone away
Hi, I get the following after a call has finished: ERROR[6862]:mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away Does this error message only appear when asterisk makes a new connection to mysql, because the old connection was stale (and dropped) ? If so, is there a way to get asterisk to stop reporting this as an error seeing it seems to write the CDR to database just fine ? Thanks Shaun (Second time sending this email, first one seemed have gone missing) -- Email: shaun.hofer at voxpak.com ******************************************************* If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it.
Atis
2007-Aug-30 01:10 UTC
[asterisk-users] Unknown connection error: (2006) MySQL server has gone away
On 8/30/07, Shaun Hofer <shaun.hofer at voxpak.com> wrote:> Hi, > I get the following after a call has finished: > > ERROR[6862]:mysql_log: cdr_mysql: Unknown connection error: (2006) > MySQL server has gone awayI also got those, approximately 20-30 per day (out of call volume 2000/day). I don't know what cause them, but asterisk manages to reconnect - so everything is ok - i'm just ignoring them. Regards, Atis -- Atis Lezdins, IT Responsible of BEST Riga, atis at BEST.eu.org ICQ: 142239285 Skype: atis.lezdins Cell Phone: +371 28806004 [Tele2, Latvia] Work phone: +1 800 7502835 [Toll free, USA] ?BEST? -> www.BEST.eu.org
Matt Riddell
2007-Aug-30 02:22 UTC
[asterisk-users] Unknown connection error: (2006) MySQL server has gone away
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Shaun Hofer wrote:> Hi, > I get the following after a call has finished: > > ERROR[6862]:mysql_log: cdr_mysql: Unknown connection error: (2006) > MySQL server has gone away > > Does this error message only appear when asterisk makes a new connection > to mysql, because the old connection was stale (and dropped) ?Correct.> If so, is there a way to get asterisk to stop reporting this as an error > seeing it seems to write the CDR to database just fine ?In my cdr_addon_mysql.c around line 160 there are the series of statements: case CR_SERVER_LOST: ast_log(LOG_ERROR, "cdr_mysql: Server has gone away. Attempting to reconnect.\n"); break; You can just comment out that line by putting // at the beginning of it. I guess it should really be a debug message at that stage and then an error further down: ast_log(LOG_ERROR, "cdr_mysql: Retried to connect fives times, giving up.\n"); Because it will retry 5 times and the "gone away" message is printed on each of those times but doesn't necessarily indicate any problem (i.e. stale connection). - -- Kind Regards, Matt Riddell Director _______________________________________________ http://www.venturevoip.com (Great new VoIP end to end solution) http://www.venturevoip.com/news.php (Daily Asterisk News - html) http://feeds.venturevoip.com/AsteriskNews (Daily Asterisk News - rss) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG1inoDQNt8rg0Kp4RArqhAJ9WfGJ9NvQwtxJn11HGi/FWMQvydwCdEtQ5 5kpz7xZ5FE8UAsii3l24mGQ=X1h1 -----END PGP SIGNATURE-----
Possibly Parallel Threads
- Snom 360 flickering screen
- subscription to mail folders not working properly anymore with dovecot1.0x ?
- Restore a node in a replicating Gluster setup after data loss
- LMTP Setup/Design Help Request
- cdr_addon_mysql 'Failed to insert into database' stops * call processing