Public bug reported:
If the database connection to the master database is killed during a
subscription operation, an ERROR will be logged:
2008-10-24 17:49:49 BST ERROR remoteWorkerThread_1: "select
"_sl".tableHasSerialKey('"public"."translationrelicensingagreement"');"
2008-10-24 17:49:49 BST WARN remoteWorkerThread_1: data copy for set 1 failed
- sleep 15 seconds
remoteWorkerThread doesn't want to give up however:
2008-10-24 17:52:35 BST DEBUG1 copy_set 1
2008-10-24 17:52:35 BST DEBUG1 remoteWorkerThread_1: connected to provider DB
2008-10-24 17:52:35 BST DEBUG2 remoteWorkerThread_1: prepare to copy table
"public"."announcement"
Eventually it will fail again, and continue to do so until the subscription
stopped and the cluster repaired:
2008-10-24 21:24:25 BST DEBUG2 remoteWorkerThread_1: all tables for set 1 found
on subscriber
2008-10-24 21:24:25 BST DEBUG2 remoteWorkerThread_1: copy sequence
"public"."ann
ouncement_id_seq"
2008-10-24 21:24:25 BST ERROR remoteWorkerThread_1: "select
"_sl".setAddSequence_int(1, 200, '"public"."announcement_id_seq"',
'public.announcement_id_seq')" PGRES_FATAL_ERROR ERROR: Slony-I:
setAddSequence_int(): sequence ID 200 has already been assigned
2008-10-24 21:24:25 BST WARN remoteWorkerThread_1: data copy for set 1 failed
- sleep 60 seconds
** Affects: slony-i
Importance: Unknown
Status: Unknown
** Affects: slony1 (Ubuntu)
Importance: Undecided
Status: New
** Bug watch added: Slony-I Bugzilla #62
http://bugs.slony.info/bugzilla/show_bug.cgi?id=62
** Also affects: slony-i via
http://bugs.slony.info/bugzilla/show_bug.cgi?id=62
Importance: Unknown
Status: Unknown
--
Initial subscription blocks with "sequence ID <xxx> has already been assigned"
https://bugs.launchpad.net/bugs/294660
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
