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
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?
#####################################################################################
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is
waived or lost by any mistransmission. If you receive this message in error,
please
immediately delete it and all copies of it from your system, destroy any hard
copies
of it and notify the sender. You must not, directly or indirectly, use,
disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Vox Generation Limited and any of its subsidiaries each reserve the
right
to monitor all e-mail communications through its networks. Any views expressed
in
this message are those of the individual sender, except where the message
states
otherwise and the sender is authorised to state them to be the views of any
such entity.
Thank You.
VoxGen
Manor House
21 Soho Square
London W1D 3QP
--------------------------------------------------------------------------------
VoxGen is a trading name of Vox Generation Limited
Registered in England and Wales: 3937784 VAT Registration 756 2842 09
Registered Address: 90 Fetter Lane, London, EC4A 1JP
--------------------------------------------------------------------------------
############################################################################
Awarded ISO/IEC27001:2005 Certification in 2007.
Awarded ISO9001:2000 Certification in 2006.
Winner - e-Government excellence 2005.
Runner up - European Information Management awards 2004:
- The Premier Project Award.
- B2C Commerce Project Award.
- CRM Project Award.
For more information visit us at www.voxgen.com
###########################################################################
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared
by NetIQ MailMarshal
#####################################################################################
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
