[Asterisk-Users] MySQL Realtime Voicemail Connection Lost

[Douglas Garstang]

I'm using realtime for voicemail users, and for reasons that I don't yet understand, when it doesn't get used for a while (like overnight), the first connection attempt of the day will display this on the console.

Jun 21 07:54:00 ERROR[8112]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away
Jun 21 07:54:01 NOTICE[8120]: rtp.c:564 ast_rtp_read: Unknown RTP codec 96 received
    -- Executing VoiceMail("SIP/xxx.187.142.186-b773c428", "u2944017 at voicemail") in new stack
Jun 21 07:54:01 ERROR[8120]: res_config_mysql.c:623 mysql_reconnect: MySQL RealTime: Failed to reconnect. Check debug for more info.
Jun 21 07:54:01 WARNING[8120]: app_voicemail.c:2411 leave_voicemail: No entry in voicemail config file for '2944017'

The next connection attempt will work. Happens like clockwork every morning. It would seem that Asterisk is not reconnecting the first time, even when it says it is. I'm thinking I may open a bug on this. Has anyone else encountered this behaviour?

Doug.