Hi All,
At src/slon/remote_worker.c line 5506 there is a query with only
sl_log_1. So when there is a large log_cmddata on the sl_log_2 table, no
data are returned and replication fails...
I suppose that
slon_mkquery(&query2,
"select log_cmddata "
"from %s.sl_log_1 "
"where log_origin = '%s' "
" and log_xid = '%s' "
" and log_actionseq = '%s'",
rtcfg_namespace,
log_origin, log_xid, log_actionseq);
should be rewritten as
slon_mkquery(&query2,
"select log_cmddata "
"from %s.sl_log_1 "
"where log_origin = '%s' "
" and log_xid = '%s' "
" and log_actionseq = '%s'"
" union all"
"select log_cmddata "
"from %s.sl_log_2 "
"where log_origin = '%s' "
" and log_xid = '%s' "
" and log_actionseq = '%s'",
rtcfg_namespace,
log_origin, log_xid, log_actionseq,
rtcfg_namespace,
log_origin, log_xid, log_actionseq);
Or something like that ...
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
