Re: smsd and MySQL server has gone away

[Jan Derfinak]

On Fri, 22 Sep 2006, massimo citterio wrote:

> hallo
> sometimes smsd lose messages. 
> It's trying to insert sms from phone into db, and if the db is not availabe 
> (I still don't know why), it prints:
> 
> 22 Sep 2006 11:57:59: Inserting sms from +39348XXXXXXX unsuccessful.
> 
> 158: SELECT FROM outbox command failed.
> Error: MySQL server has gone away
> 
> If I stop mysql when smsd is running, It happens the same.
> If I restart mysql, smsd doesn't reconnect and lose all messages since last 
> mysql failure.
> I think this is a bug. 
> If the db backend doesn't work, smsd should either leave the message in the 
> phone or in a queue.
> If db is available, it should reconnect, or it should die when db is not 
> available, in order for  a daemon supervisor (e.g. monit ) to restart it.

Massimo, thanks for your report. You are right smsd should stop in such
situation.

jan