Tue Nov 11 18:37:06 PST 2008
- Previous message: [Slony1-general] Re: best way to verify slony is properly syncing
- Next message: [Slony1-general] ERROR: incompatible library
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello, I'm running postgres 8.3.3 and slony 2.0 rc2 on three servers (1 master, 2 slaves). I keep seeing this error from all 3 servers: Nov 12 02:26:49 database12 slon[4893]: [227-1] 2008-11-12 02:26:49 UTC FATAL cleanupThread: "select "_sample".cleanupEvent('10 minutes'::interval, 'false'::boolean); " - Nov 12 02:26:49 database12 slon[4893]: [227-2] ERROR: query has no destination for result data Nov 12 02:26:49 database12 slon[4893]: [227-3] HINT: If you want to discard the results of a SELECT, use PERFORM instead. Nov 12 02:26:49 database12 slon[4893]: [227-4] CONTEXT: PL/pgSQL function "logswitch_finish" line 42 at SQL statement Nov 12 02:26:49 database12 slon[4893]: [227-5] PL/pgSQL function "cleanupevent" line 99 at assignment Nov 12 02:26:49 database12 slon[4514]: [5-1] 2008-11-12 02:26:49 UTC INFO slon: retry requested Nov 12 02:26:49 database12 slon[4514]: [6-1] 2008-11-12 02:26:49 UTC INFO slon: notify worker process to shutdown Nov 12 02:26:49 database12 slon[4893]: [228-1] 2008-11-12 02:26:49 UTC INFO syncThread: thread done Nov 12 02:26:49 database12 slon[4893]: [229-1] 2008-11-12 02:26:49 UTC INFO remoteListenThread_3: disconnecting from 'dbname=sample host=1.2.3.4 user=slony port=5432' Nov 12 02:26:49 database12 slon[4893]: [230-1] 2008-11-12 02:26:49 UTC INFO remoteListenThread_1: disconnecting from 'dbname=sample host=12.3.5 user=slony port=5432' Nov 12 02:26:49 database12 slon[4893]: [231-1] 2008-11-12 02:26:49 UTC INFO localListenThread: thread done Nov 12 02:26:49 database12 slon[4893]: [232-1] 2008-11-12 02:26:49 UTC INFO main: scheduler mainloop returned Nov 12 02:26:49 database12 slon[4893]: [233-1] 2008-11-12 02:26:49 UTC CONFIG main: wait for remote threads Nov 12 02:26:49 database12 slon[4893]: [234-1] 2008-11-12 02:26:49 UTC CONFIG remoteWorkerThread_1: update provider configuration Nov 12 02:26:49 database12 slon[4893]: [235-1] 2008-11-12 02:26:49 UTC CONFIG remoteWorkerThread_1: helper thread for provider 1 terminated Nov 12 02:26:49 database12 slon[4893]: [236-1] 2008-11-12 02:26:49 UTC CONFIG remoteWorkerThread_1: disconnecting from data provider 1 Nov 12 02:26:49 database12 slon[4893]: [237-1] 2008-11-12 02:26:49 UTC INFO remoteWorkerThread_1: thread done Nov 12 02:26:49 database12 slon[4893]: [238-1] 2008-11-12 02:26:49 UTC CONFIG remoteWorkerThread_3: update provider configuration Nov 12 02:26:49 database12 slon[4893]: [239-1] 2008-11-12 02:26:49 UTC INFO remoteWorkerThread_3: thread done Nov 12 02:26:49 database12 slon[4893]: [240-1] 2008-11-12 02:26:49 UTC CONFIG main: done Nov 12 02:26:49 database12 slon[4514]: [7-1] 2008-11-12 02:26:49 UTC CONFIG slon: child terminated status: 0; pid: 4893, current worker pid: 4893 Is this a known issue? Any workarounds for it? Cheers, Mike
- Previous message: [Slony1-general] Re: best way to verify slony is properly syncing
- Next message: [Slony1-general] ERROR: incompatible library
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list