Jean-Samuel Reynaud reynaud
Tue Nov 14 07:56:20 PST 2006
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 ...





More information about the Slony1-general mailing list