How annoying. Notice that the table is not copied at any time. All
echo's were received and no errors were issued.
Slony 1.1.5 BTW.
try {
create set (id = 999, origin = 1, comment = 'merge set');
set add table (set id = 999, origin = 1, id = 999, fully qualified
name = '$TAB');
}
wait for event( origin = all, confirmed = all, wait on = 1, timeout
= 0);
echo 'Added $TAB to temporary set';
subscribe set (id = 999, provider = 1, receiver = 2, forward = no);
wait for event( origin = all, confirmed = all, wait on = 1, timeout
= 0);
echo 'Subscribed $TAB';
merge set (id = 667, add id = 999, origin = 1);
wait for event( origin = all, confirmed = all, wait on = 1, timeout
= 0);
echo 'Merged $TAB';
==> slonypg8-db1.log <==
2006-04-27 19:26:25 EDT CONFIG storeSet: set_id=999 set_origin=1
set_comment='merge set'
==> slonypg8-db1-pg81.log <==
2006-04-27 19:26:24 EDT CONFIG storeSet: set_id=999 set_origin=1
set_comment='merge set'
==> slonypg8-db3.log <==
2006-04-27 19:26:25 EDT CONFIG storeSet: set_id=999 set_origin=1
set_comment='merge set'
==> slonypg8-nas2.log <==
2006-04-27 19:26:25 EDT CONFIG storeSet: set_id=999 set_origin=1
set_comment='merge set'
==> slonypg8-db1.log <==
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=10 li_receiver=1
li_provider=10
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=4 li_receiver=1
li_provider=4
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=2 li_receiver=1
li_provider=2
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=10 li_receiver=1
li_provider=10
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=4 li_receiver=1
li_provider=4
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=2 li_receiver=1
li_provider=2
==> slonypg8-db1-pg81.log <==
2006-04-27 19:26:45 EDT CONFIG storeSubscribe: sub_set=999
sub_provider=1 sub_forward='f'
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=1 li_receiver=2
li_provider=1
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=10 li_receiver=2
li_provider=10
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=4 li_receiver=2
li_provider=4
2006-04-27 19:26:45 EDT DEBUG1 copy_set 999
2006-04-27 19:26:45 EDT DEBUG1 remoteWorkerThread_1: connected to
provider DB
2006-04-27 19:26:45 EDT WARN remoteWorkerThread_1: transactions
earlier than XID 1721362913 are still in progress
2006-04-27 19:26:45 EDT WARN remoteWorkerThread_1: data copy for set
999 failed - sleep 15 seconds
==> slonypg8-db3.log <==
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=2 li_receiver=10
li_provider=2
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=1 li_receiver=10
li_provider=1
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=4 li_receiver=10
li_provider=1
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=2 li_receiver=10
li_provider=2
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=1 li_receiver=10
li_provider=1
2006-04-27 19:26:45 EDT CONFIG storeListen: li_origin=4 li_receiver=10
li_provider=1
==> slonypg8-nas2.log <==
2006-04-27 19:26:51 EDT CONFIG storeListen: li_origin=10 li_receiver=4
li_provider=1
2006-04-27 19:26:51 EDT CONFIG storeListen: li_origin=10 li_receiver=4
li_provider=2
2006-04-27 19:26:51 EDT CONFIG storeListen: li_origin=1 li_receiver=4
li_provider=1
2006-04-27 19:26:51 EDT CONFIG storeListen: li_origin=2 li_receiver=4
li_provider=2
2006-04-27 19:26:52 EDT CONFIG storeListen: li_origin=10 li_receiver=4
li_provider=1
2006-04-27 19:26:52 EDT CONFIG storeListen: li_origin=10 li_receiver=4
li_provider=2
2006-04-27 19:26:52 EDT CONFIG storeListen: li_origin=1 li_receiver=4
li_provider=1
2006-04-27 19:26:52 EDT CONFIG storeListen: li_origin=2 li_receiver=4
li_provider=2
==> slonypg8-db1.log <==
2006-04-27 19:27:00 EDT CONFIG dropSet: set_id=999
==> slonypg8-db1-pg81.log <==
2006-04-27 19:27:00 EDT DEBUG1 copy_set 999
2006-04-27 19:27:00 EDT DEBUG1 remoteWorkerThread_1: connected to
provider DB
2006-04-27 19:27:00 EDT WARN remoteWorkerThread_1: transactions
earlier than XID 1721362913 are still in progress
2006-04-27 19:27:00 EDT WARN remoteWorkerThread_1: data copy for set
999 failed - sleep 30 seconds
==> slonypg8-db3.log <==
2006-04-27 19:27:01 EDT CONFIG dropSet: set_id=999
==> slonypg8-nas2.log <==
2006-04-27 19:27:04 EDT CONFIG dropSet: set_id=999
==> slonypg8-db1-pg81.log <==
2006-04-27 19:27:30 EDT DEBUG1 copy_set 999
2006-04-27 19:27:30 EDT DEBUG1 remoteWorkerThread_1: connected to
provider DB
2006-04-27 19:27:30 EDT WARN remoteWorkerThread_1: transactions
earlier than XID 1721362913 are still in progress
2006-04-27 19:27:30 EDT WARN remoteWorkerThread_1: data copy for set
999 failed - sleep 60 seconds
2006-04-27 19:28:30 EDT DEBUG1 copy_set 999
2006-04-27 19:28:30 EDT DEBUG1 remoteWorkerThread_1: connected to
provider DB
2006-04-27 19:28:32 EDT DEBUG1 remoteWorkerThread_1: disconnected from
provider DB
2006-04-27 19:28:32 EDT DEBUG1 copy_set 999 done in 1.377 seconds
2006-04-27 19:28:32 EDT CONFIG enableSubscription: sub_set=999
2006-04-27 19:28:32 EDT CONFIG storeListen: li_origin=1 li_receiver=2
li_provider=1
2006-04-27 19:28:32 EDT CONFIG storeListen: li_origin=10 li_receiver=2
li_provider=10
2006-04-27 19:28:32 EDT CONFIG storeListen: li_origin=4 li_receiver=2
li_provider=4
2006-04-27 19:28:32 EDT CONFIG dropSet: set_id=999
--
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
