Hi,
I am having the following when traying to do a failover and drop node in a 2
nodes 3 sets setup:
[EMAIL PROTECTED] ~]# ./promote.sh
<stdin>:6: NOTICE: failedNode: set 1 has no other direct receivers - move
now
<stdin>:6: NOTICE: failedNode: set 2 has no other direct receivers - move
now
<stdin>:6: NOTICE: failedNode: set 3 has no other direct receivers - move
now
<stdin>:6: PGRES_FATAL_ERROR select
"_monkey_cluster".failedNode2(1,2,1,'45','46'); - ERROR: INSERT has more
expressions than target columns
CONTEXT: SQL statement "INSERT INTO "_monkey_cluster".sl_event (ev_origin,
ev_seqno, ev_timestamp, ev_snapshot, ev_type, ev_data1, ev_data2, ev_data3,
ev_data4) values ( $1 ,
"pg_catalog".nextval('"_monkey_cluster".sl_event_seq'), CURRENT_TIMESTAMP,
'0', '0', '0:0:', 'ACCEPT_SET', $2 ::text, $3 ::text, $1 ::text, $4
::text)"
PL/pgSQL function "failoverset_int" line 35 at SQL statement
SQL statement "SELECT "_monkey_cluster".failoverSet_int( $1 , $2 , $3 ,
$4 )"
PL/pgSQL function "failednode2" line 39 at PERFORM
<stdin>:6: PGRES_FATAL_ERROR select
"_monkey_cluster".failedNode2(1,2,2,'45','47'); - ERROR: current
transaction is aborted, commands ignored until end of transaction block
<stdin>:6: PGRES_FATAL_ERROR select
"_monkey_cluster".failedNode2(1,2,3,'45','48'); - ERROR: current
transaction is aborted, commands ignored until end of transaction block
Slony version: 2.0.0. RC1, postgresql-8.3.3
The cluster setup is the following:
#!/bin/sh
export PATH=$PATH:/usr/local/pgsql/bin/
CLUSTER1=monkey_cluster
DB1=pickmonkey
DB2=pickmonkey2
H1=192.168.10.73
H2=192.168.10.73
U=postgres
PASSWORD=postgres
slonik <<_EOF_
cluster name=$CLUSTER1;
node 1 admin conninfo='dbname=$DB1 host=$H1 user=$U password=$PASSWORD';
node 2 admin conninfo='dbname=$DB2 host=$H2 user=$U password=$PASSWORD';
init cluster (id=1, comment='Production');
#TABLE ORDER DATA
create set (id=1, origin=1, comment='order table');
set add table (set id=1, origin=1, id=1, full qualified
name='public.order_data', comment='Table Order Data');
set add sequence (set id=1, origin=1, id=1, full qualified
name='public.assrt_order_data_seq', comment='Sequence
assrt_order_data_seq');
#TABLE TRANSFER_MISSED_FILES
create set (id=2, origin=1, comment='Transfer Missed Files table');
set add table (set id=2, origin=1, id=2, full qualified
name='public.transfer_missed_files', comment='Table transfer_missed_files');
set add sequence (set id=2, origin=1, id=2, full qualified
name='public.assrt_transfer_files_seq', comment='Sequence
assrt_transfer_files_seq');
#BIG GROUP OF TABLES WITH FKs
create set (id=3, origin=1, comment='The rest of tables');
set add table (set id=3, origin=1, id=3, full qualified
name='public.address', comment='Table address');
set add table (set id=3, origin=1, id=4, full qualified
name='public.tel_number', comment='Table tel_number');
set add table (set id=3, origin=1, id=5, full qualified
name='public.country', comment='Table country');
set add table (set id=3, origin=1, id=6, full qualified
name='public.customer', comment='Table customer');
set add table (set id=3, origin=1, id=7, full qualified
name='public.zip_code', comment='Table zip_code');
set add table (set id=3, origin=1, id=8, full qualified
name='public.holiday', comment='Table holiday');
set add table (set id=3, origin=1, id=9, full qualified name='public.depot',
comment='Table depot');
set add table (set id=3, origin=1, id=10, full qualified
name='public.contact_centre', comment='Table contact_centre');
set add sequence (set id=3, origin=1, id=3, full qualified
name='public.assrt_address_seq', comment='Sequence assrt_address_seq');
set add sequence (set id=3, origin=1, id=4, full qualified
name='public.assrt_tel_number_seq', comment='Sequence
assrt_tel_number_seq');
set add sequence (set id=3, origin=1, id=5, full qualified
name='public.assrt_country_seq', comment='Sequence assrt_country_seq');
set add sequence (set id=3, origin=1, id=6, full qualified
name='public.assrt_customer_seq', comment='Sequence assrt_customer_seq');
set add sequence (set id=3, origin=1, id=7, full qualified
name='public.assrt_zip_code_seq', comment='Sequence assrt_zip_code_seq');
set add sequence (set id=3, origin=1, id=8, full qualified
name='public.assrt_holiday_seq', comment='Sequence assrt_holiday_seq');
set add sequence (set id=3, origin=1, id=9, full qualified
name='public.assrt_depot_seq', comment='Sequence assrt_depot_seq');
set add sequence (set id=3, origin=1, id=10, full qualified
name='public.assrt_contact_centre_seq', comment='Sequence
assrt_contact_centre_seq');
store node (id=2, comment='Backup', EVENT NODE=1);
store path (server=1, client=2, conninfo='dbname=$DB1 host=$H1 user=$U
password=$PASSWORD');
store path (server=2, client=1, conninfo='dbname=$DB2 host=$H2 user=$U
password=$PASSWORD');
store listen (origin=1, provider=1, receiver=2);
store listen (origin=2, provider=2, receiver=1);
_EOF_
the subscribe script:
#!/bin/sh
export PATH=$PATH:/usr/local/pgsql/bin/
CLUSTER1=monkey_cluster
DB1=pickmonkey
DB2=pickmonkey2
H1=192.168.10.73
H2=192.168.10.73
U=postgres
PASSWORD=postgres
slonik <<_EOF_
cluster name = $CLUSTER1;
node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U password=$PASSWORD';
node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U password=$PASSWORD';
subscribe set (id = 1, provider = 1, receiver = 2, forward = yes);
subscribe set (id = 2, provider = 1, receiver = 2, forward = yes);
subscribe set (id = 3, provider = 1, receiver = 2, forward = yes);
_EOF_
and to promote:
#!/bin/bash
#
#promote.sh
export PATH=$PATH:/usr/local/pgsql/bin/
CLUSTER1=monkey_cluster
DB1=pickmonkey
DB2=pickmonkey2
H1=192.168.10.73
H2=192.168.10.73
U=postgres
PASSWORD=postgres
su - postgres -c /usr/local/pgsql/bin/slonik <<_EOF_
cluster name = $CLUSTER1;
node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U password=$PASSWORD';
node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U password=$PASSWORD';
failover (id = 1, backup node = 2);
drop node (id = 1, event node = 2);
_EOF_
Any idea in what may be wrong?
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
