http://www.slony.info/bugzilla/show_bug.cgi?id=63

           Summary: slony 2.0 RC2 cleanupThread problem
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: major
          Priority: high
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: smith.not.western at gmail.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


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?

It is quite frustrating as slon needs to be constantly restarted. Yes, I use
launch_clusters.sh to automate it, but nonetheless am reporting it here.

Cheers,

Mike


-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.