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 ...
>