Vg Stops Calling

[mehdi_h]

Hi

I have experience an issue today, my VG is connected to an external Mysql DB.

For any reason, outgoing calls have been sopped.I had to restart VG to see outgoing calls run again.

Do you know what is the reason for that? I would like to know if is is possible to detect that VG is not callings so that I could make any alerting actions.

 

Here is the last logs before I restart the service.

 

Regards

Mh

0223_1237_vgEngine.zip

[SupportTeam]

Trace shows that there are errors reported by the database layer, with "Fatal error encountered during command execution" timeouts and then 'invalid connection' type errors returned when VoiceGuide tries to issue SQL queries to the database.

 

Which version of MySQL is VoiceGuide connecting to and which version of ADO.NET MySQL drivers are used on this system?

 

Was the whole machine restarted, of just the VoiceGuide service?

 

Are there any errors visible in any MySQL logs?

 

 

 

124323.656 11 ERROR v7.1.3699.20074 (2010-02-16 11:09:08.70) DbOutDialQue_UpdateDateAndRetries ExecuteNonQuery error. : Fatal error encountered during command execution.

MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

à MySql.Data.MySqlClient.MySqlDataReader.NextResult()

à MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

à MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

à MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

 

 

124323.656 11 ERROR v7.1.3699.20074 (2010-02-16 11:09:08.70) DbProcessQueue_DoQueuedWork_RunCoreSql : Connection must be valid and open.

 

à MySql.Data.MySqlClient.MySqlCommand.CheckState()

à MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

à MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

 

124323.671 11 ERROR v7.1.3699.20074 (2010-02-16 11:09:08.70) DoWorkFindCall stage1 : Connection must be valid and open.

 

à MySql.Data.MySqlClient.MySqlCommand.CheckState()

à MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

à MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

à System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

à ktlib.vgDb.vgDb_ProviderInvariant.DbProcessQueue_DoQueuedWork_FindCall(Object sender, ProcessingQueueEventArgs`1 args)