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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
