Sat Jul 2 11:08:07 PDT 2005
- Previous message: [Slony1-general] Bug in tools/psql_replication_check.pl
- Next message: [Slony1-general] error in slon's query
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Bug in tools/psql_replication_check.pl
- Next message: [Slony1-general] error in slon's query
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list