Re: [Sqlgrey-users] Postgresql + lost connection

[Lionel B. <lio...@bo...>]

Daniel V. Pedersen wrote the following on 27.07.2005 14:41 :

> Howdi, I recently installed Sqlgrey and it seems to work lovely, apart
>
> From I often get database disconnects/reconnects.
>
>  
>
> Mail goes:
>
> SQLgrey encountered an SQL error and triggered a reconnection to: 
> DBI:Pg:dbname=sqlgrey;host=<host>
>
> And the reconnect goes fine.
>
>  
>
> Log:
>
>  
>
> Jul 27 10:37:13 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>
> Jul 27 11:07:16 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>
> Jul 27 11:37:42 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>
> Jul 27 12:07:39 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>
> Jul 27 12:37:34 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>
> Jul 27 13:07:46 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>
> Jul 27 13:37:45 spamwall1 sqlgrey: dbaccess: error: couldn't get now() 
> from DB: no connection to the server
>

You don't get only these messages, do you?

Which SQLgrey version are you using? Can you reproduce the problem with 
SQLgrey 1.6.5 and "clean_method=sync" in sqlgrey.conf?

Lionel.