Tue Nov 14 07:56:20 PST 2006
- Previous message: [Slony1-general] non-standard escape syntax
- Next message: [Slony1-general] Problem with log_cmddata > sync_max_rowsize and sl_log_2 active
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 ...
- Previous message: [Slony1-general] non-standard escape syntax
- Next message: [Slony1-general] Problem with log_cmddata > sync_max_rowsize and sl_log_2 active
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list