hannu at skype.net hannu
Mon Sep 20 15:11:56 PDT 2004
My replication progress stopped after postgres was unable to process a
597kb long query with the folowing error message:

ERROR  remoteWorkerThread_2: "declare LOG cursor for select    
log_origin, log_xid, log_tableid,     log_actionseq, log_cmdtype,
log_cmddata from "_accountdb_cluster".sl_log_1 where log_origin = 2 and ( 
(
 log_tableid in
(50,49,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,24,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,25,23,2001)
    and (log_xid < '39569026' and
"_accountdb_cluster".xxid_lt_snapshot(log_xid,
'39564058:39569026:''39564058'''))
    and (log_xid >= '39095969' and
"_accountdb_cluster".xxid_ge_snapshot(log_xid,
'39095969:39381336:''39095969'',''39380612'',''39378857''')) and
log_actionseq not in ('12555522','12555523',
...
~597kbytes of integers
...
) ) order by log_actionseq; " PGRES_FATAL_ERROR ERROR:  expression too
complex
DETAIL:  Nesting depth exceeds maximum expression depth 10000.
HINT:  Increase the configuration parameter "max_expr_depth".
ERROR  remoteWorkerThread_2: "close LOG; " PGRES_FATAL_ERROR ERROR: 
current transaction is aborted, commands ignored until end of transaction
block
ERROR  remoteWorkerThread_2: helper 2 finished with error
ERROR  remoteWorkerThread_2: SYNC aborted


this situation was caused by setting up a replication client which missed
some primary keys in table definition, to which slon reacted by (trying to
replicate the set, failing after a few hour work, rollback and retry after
60 sec:) , repeat
it managed to do that 4 times before I noticed

so what are my oprions now ?



More information about the Slony1-general mailing list