Slony1 PostgreSQL Replication

Author

slon failure

Dmitry Karasik

2005-05-23, 7:29 am

I need a help with a three-node slony 1.0.5 setup, where one of the two
slave slon-daemons fails with an error. The setup is that 9mcons001
is a master host, and 8kdb001 is one of two slaves. The strange sting is
that slon on the other slave host runs o.k., and the both slaves have
identical configuration. Any ideas?=20

mail8kdb001:~ # slon newsmtp 'dbname=3Dnewsmtp user=3Dpostgres host=3D8kd=
b001'
CONFIG main: slon version 1.0.5 starting up
CONFIG main: local node id =3D 4
CONFIG main: loading current cluster configuration
CONFIG storeNode: no_id=3D1 no_comment=3D'Master
Node'
CONFIG storeNode: no_id=3D2 no_comment=3D'Slave node'
CONFIG storePath: pa_server=3D1 pa_client=3D4 pa_conninfo=3D"dbname=3Dnew=
smtp
host=3D9mcons001 user=3Dpostgres" pa_connretry=3D10
CONFIG storeListen: li_origin=3D1 li_receiver=3D4 li_provider=3D1
CONFIG storeSet: set_id=3D1 set_origin=3D1 set_comment=3D'All newsmtp rep=
lication
tables'
WARN remoteWorker_wakeup:
node 1 - no worker thread
CONFIG main: configuration complete - starting threads
CONFIG enableNode: no_id=3D1
CONFIG enableNode: no_id=3D2
ERROR remoteWorkerThread_1
: "begin transaction; set transaction isolatio=
n
level serializable; lock table "_newsmtp".sl_config_lock; select
"_newsmtp". enableSubscription(1
, 1, 2); notify "_newsmtp_Event"; notify
"_newsmtp_Confirm"; insert into "_newsmtp".sl_event (ev_origin,
ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ,
ev_data1, ev_data2, ev_data3, ev_data4 ) values ('1', '17', '2005-05-2=
3
11:39:58.652283', '203665', '203666', '', 'ENABLE_SUBSCRIPTION
', '1', '1'=
,
'2', 'f'); insert into "_newsmtp".sl_confirm (con_origin, con_received,
con_seqno, con_timestamp) values (1, 4, '17', CURRENT_TIMESTAMP); comm=
it
transaction;" PGRES_FATAL_ERROR ERROR: insert or update on table
"sl_subscribe" violates foreign key constraint "sl_subscribe-sl_path-ref"
DETAIL: Key (sub_provider,sub_re
ceiver)=3D(1,2) is not present in table
"sl_path".
CONTEXT: SQL statement "insert into "_newsmtp".sl_subscribe (sub_set,
sub_provider, sub_receiver, sub_forward, sub_active) values ( $1 , $2 ,
$3 , false, true)"
PL/pgSQL function " enablesubscription_i
nt" line 22 at SQL statement
PL/pgSQL function "enablesubscription" line 6 at return
INFO remoteListenThread_1
: disconnecting from 'dbname=3Dnewsmtp
host=3D9mcons001 user=3Dpostgres'

--=20
Sincerely,
Dmitry Karasik

Brad Nicholson

2005-05-24, 9:24 am

Dmitry Karasik wrote:

>I need a help with a three-node slony 1.0.5 setup, where one of the two
>slave slon-daemons fails with an error. The setup is that 9mcons001
>is a master host, and 8kdb001 is one of two slaves. The strange sting is
>that slon on the other slave host runs o.k., and the both slaves have
>identical configuration. Any ideas?
>
>
>
>DETAIL: Key (sub_provider,sub_re
ceiver)=(1,2) is not present in table
>"sl_path".
>
>

Looks like you are missing an entry in sl_path between node 1 and node
2. If you are add this entry, it should fix the problem. If not,
please post the contents of sl_path.

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

Sponsored Links