hi
i have two problems:
1) 2-3 months ago i have try to merge 1500 sets (ech 11 tables) into one
big single. after 10 sets have merged, slony on slave database stoped
worging. child process of slony was all thie time killed by system
SYGSENV. strace showed that last system call is futex, no other clue, no
other error. so i thought that slony have limitation of elements in one
set, and i'v created couple of medium sets with no more than 1000 tables.
but week ago i had to unsubscribe set and subscribe it again, and again,
slony child process was terminated on and on by SIGSENV signal as he
tryied subscribe set. any of slony/postgres/system restart do not helped.
but... i'v "manualy" unsubscribed set (deleted entries in sl_subscribe,
sl_setsync, sl_event...) and again started slony and slony stared to
working (synchronizing other sets). when synchronization was on the fly, i
again subscribed set and this time operation finished. any clue what may
been happened ? if i again face this problem, what to check, where and how
?
2) i have two sets (s1 and s2) in slave database (sd1) replicated from
master (m1). tables in those sets are connected by foreign keys (across
sets). but schema/shape of database changed : there is another master
database (m2) which is origin of first set (s1) and for this set is
another slave database (sd2).
before:
------ s1 ------ >
m1 sd1
-------s2 ------->
now:
m1 --------s2--------> sd1
m2 --------s1--------> sd2
now on sd1 i am trying to drop table from old set s1 (because on m1 there
is no anymore such table) and as a result there is error:
ERROR: "xxx_pkey" is an index
xxx_pkey is primary key of table which is in still replicated set s2, and
table i am trying to drop have foreign key to table xxx primary key. when
i drop table xxx out of the synchronization (from set s2), i can then drop
table which i wanted to dropped in first place. is there any workoround of
this issue ?
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
