Mike C smith.not.western at gmail.com
Tue Nov 11 18:37:06 PST 2008
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


More information about the Slony1-general mailing list