[Sqlgrey-users] Postgresql + lost connection

[Daniel V. P. <dv...@cs...>]

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

 

This seems to happen every half hour or so.

 

Perl is 5.8.5, OS FreeBSD 5.3, Postfix 2.2.5, PostgreSQL 8.0.x (Server 8.0.3
/ client libs 8.0.5), DBD::Pg 1.43, DBI 1.48

 

I've tried fiddling and searching but coulden't really find anything,

So sorry if this have been asked/answered in the past.

 

Cheers,

 

Dan.