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