Mon Sep 20 15:11:56 PDT 2004
- Previous message: [Slony1-general] SIGSEGV in cleanupThread_main()
- Next message: [Slony1-general] slony generating a "too complex" query
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 ?
- Previous message: [Slony1-general] SIGSEGV in cleanupThread_main()
- Next message: [Slony1-general] slony generating a "too complex" query
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list