Julian Scarfe wrote:
> Christopher
>
> For our set-up, the following patch avoids any FATAL errors on
> switchover now (regardless of the insertion of wait for event).
>
> Hope that helps.
>
> Julian
>
> --- local_listen.c.original 2006-08-23 07:41:14.000000000 +0000
> +++ local_listen.c 2006-08-23 07:42:18.000000000 +0000
> @@ -510,9 +510,10 @@
> */
> dstring_init(&query2);
> slon_mkquery(&query2,
> - "select sub_provider from %s.sl_subscribe "
> - " where sub_receiver = %d",
> - rtcfg_namespace, rtcfg_nodeid);
> + "select sub_provider from %s.sl_subscribe "
> + " where sub_receiver = %d and sub_set = %d",
> + rtcfg_namespace, rtcfg_nodeid, set_id);
> +
> res2 = PQexec(dbconn, dstring_data(&query2));
> if (PQresultStatus(res2) != PGRES_TUPLES_OK)
> {
OK, there's still some slowness to getting all the ACCEPT_SET events to
flow through, but it's flowing...
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
