Joachim Wieland joe
Sat Jul 2 11:08:07 PDT 2005
Hi,

I tried to replicate the pgbench example as described in the tutorial.
However I get an error when I start slon on the slave node. Can
anybody tell me if I've done something wrong or if this is a slon bug?

When I run 

slon $CLUSTERNAME "dbname=$SLAVEDBNAME user=$REPLICATIONUSER host=$SLAVEHOST password=passwd"

that's what I get:

DEBUG2 remoteWorkerThread_1: SYNC 1087 processing
DEBUG2 remoteWorkerThread_1: syncing set 1 with 0 table(s) from provider 1
DEBUG2 remoteWorkerThread_1: Didn't add or to provider
DEBUG3 remoteWorkerThread_1: activate helper 1
DEBUG4 remoteWorkerThread_1: waiting for log data
ERROR  remoteWorkerThread_1: "declare LOG cursor for select     log_origin, log_xid, log_tableid,     log_actionseq, log_cmdtype, log_cmddata from "_pgbench_rep".sl_log_1 where log_origin = 1 and (  order by log_actionseq; " PGRES_FATAL_ERROR ERROR:  syntax error at or near "order" at character 170
ERROR  remoteWorkerThread_1: "close LOG; " PGRES_FATAL_ERROR ERROR:  current transaction is aborted, commands ignored until end of transaction block
DEBUG2 remoteHelperThread_1_1: 0.002 seconds until close cursor
DEBUG4 remoteHelperThread_1_1: change helper thread
DEBUG4 remoteHelperThread_1_1: send DONE/ERROR line toworker
DEBUG3 remoteHelperThread_1_1: waiting for workgroup to finish
ERROR  remoteWorkerThread_1: helper 1 finished with error

(this is slony 1.1 and pgsql 8.0.3)

Thanks
Joachim



More information about the Slony1-general mailing list