On Wed, Mar 27, 2013 at 1:07 PM, Csaba Nagy <[email protected]> wrote: > Hi all, > > We have here a slony setup where this error is consistently showing up: > > PGRES_FATAL_ERROR ERROR: stack depth limit exceeded > HINT: Increase the configuration parameter "max_stack_depth", after > ensuring the platform's stack depth limit is adequate. > > The line before this error message in the slony logs has ~11MB worth of > text consisting mainly in a long concatenation of: > > ... and log_actionseq <> '...'
This was noticed in 2.0.7, reported as bug #264, and fixed: http://www.slony.info/bugzilla/show_bug.cgi?id=264 Essentially, adding an "ORDER BY" to two queries. (See the patches attached to the bug) You'd need to recompile slon, but it shouldn't be necessary to upgrade to an altogether newer version. We did get a positive response that the patch rectified things in 2.0.7, so that seems precisely relevant to your situation. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
