Sorry there is a missing space...
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);
Le mardi 14 novembre 2006 à 16:56 +0100, Jean-Samuel Reynaud a écrit :
> 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
