Menu
▾
▴
sqlgrey-users
|
From: Daniel V. P. <dv...@cs...> - 2005-07-27 12:41:31
|
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. |
|
From: Daniel V. P. <dv...@cs...> - 2005-07-27 13:05:31
|
Arf, Server is 8.0.1 / client side is 8.0.3 _____ From: sql...@li... [mailto:sql...@li...] On Behalf Of Daniel V. Pedersen Sent: 27. juli 2005 14:41 To: sql...@li... Subject: [Sqlgrey-users] Postgresql + lost connection 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. |
|
From: Lionel B. <lio...@bo...> - 2005-07-27 16:15:16
|
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. |
|
From: Daniel V. P. <dv...@cs...> - 2005-07-27 16:28:31
|
> -----Original Message----- > From: sql...@li... [mailto:sqlgrey-users- > ad...@li...] On Behalf Of Lionel Bouton > > You don't get only these messages, do you? Well, apart from the regular log output, yup, that's pretty much All in the mail log I get from grey, that looks erroneous. I do get a mail almost directly after with a "SQLgrey recovered DB". > Which SQLgrey version are you using? Can you reproduce the problem with > SQLgrey 1.6.5 and "clean_method=sync" in sqlgrey.conf? 1.6.4, And I don't know, I suspected something with the cleaning since That happens each 1800th second. I'll give 1.6.5 a swing tomorrow, see how It behaves. Oh, and yes, changed from async to sync, same problem. /Dan. |
|
From: Lionel B. <lio...@bo...> - 2005-07-27 16:52:30
|
Daniel V. Pedersen wrote the following on 27.07.2005 18:28 : >>-----Original Message----- >>From: sql...@li... [mailto:sqlgrey-users- >>ad...@li...] On Behalf Of Lionel Bouton >> >>You don't get only these messages, do you? >> >> > >Well, apart from the regular log output, yup, that's pretty much >All in the mail log I get from grey, that looks erroneous. > >I do get a mail almost directly after with a "SQLgrey recovered DB". > > > >>Which SQLgrey version are you using? Can you reproduce the problem with >>SQLgrey 1.6.5 and "clean_method=sync" in sqlgrey.conf? >> >> > >1.6.4, And I don't know, I suspected something with the cleaning since >That happens each 1800th second. I'll give 1.6.5 a swing tomorrow, see how >It behaves. Oh, and yes, changed from async to sync, same problem. > > All versions before 1.6.5 didn't use sync when told to do so. Some configurations have database related problems with async... Lionel |
|
From: Daniel V. P. <dv...@cs...> - 2005-07-28 11:37:29
|
> -----Original Message----- > From: sql...@li... [mailto:sqlgrey-users- > ad...@li...] On Behalf Of Lionel Bouton > Sent: 27. juli 2005 18:54 > > All versions before 1.6.5 didn't use sync when told to do so. Some > configurations have database related problems with async... Yup, upgraded to 1.6.5 and so far no errors (been running about an hour) So that seems to have solved it, cheers. /Dan. |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X