Hi,

I am currently encountering some problem when I attempt to perform a
switchover. Locking of set seems successful, but failed something after the
locking when it's attempting the move set I guess.

1) The switchover process keeps on complaining about a missing trigger which
I don't know where to find.

pgplus at amkfis141-z2:>> switchover_db.sh
WARNING! U are attempting to perform a Switchover from amkatdcmb to
amkatdcma!!
Confirm switchover from amkatdcmb to amkatdcma? (Y/N): Y
<stdin>:20: Cluster arcdcm_rep Node amkatdcmb 2 set 1 lock successful.
<stdin>:26: PGRES_FATAL_ERROR select "_arcdcm_rep".moveSet(1, 1);  - ERROR: 
trigger "_arcdcm_rep_logtrigger_1" for table "attribute_map" does not exist
CONTEXT:  SQL statement "drop trigger "_arcdcm_rep_logtrigger_1" on
"dccmgr"."attribute_map""
PL/pgSQL function "altertablerestore" line 56 at execute statement
SQL statement "SELECT  "_arcdcm_rep".alterTableRestore( $1 )"
PL/pgSQL function "moveset_int" line 33 at perform
SQL statement "SELECT  "_arcdcm_rep".moveSet_int( $1 ,  $2 ,  $3 , 0)"
PL/pgSQL function "moveset" line 61 at perform
<stdin>:30: ERROR moving Cluster arcdcm_rep amkatdcmb Node 2 set 1.
<stdin>:32: Unlock the set before exiting ...
<stdin>:42: Cluster arcdcm_rep Node amkatdcmb 2 set 1 lock unlock
successful.
ERROR! Error when performing slonik set switchover. Exiting ...


2) I have configured a master and a slave node. Now I'm unable to do any
insert/delete/update on either of the host. It just complain about me doing
the insert/delete/update on a subscriber node.


Appreciate any opinion or suggestions.

Thanks in advance.
Eugene
-- 
View this message in context: http://www.nabble.com/Switchover-Error-tp21598970p21598970.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.