On 8/21/07, angga erwina <by_pacitan at yahoo.com> wrote:
>
> hi,
> i've run slon process,then rise error messages like this..whats wrong with
> my setup connection..help me please...
> thanks,
> regards,
> bayu
>
>
> [postgres at laptopbps ~]$ /usr/local/pgsql/bin/slon sdki "dbname=3Dsdki
> user=3Dpostgres port=3D5432 host=3Dlaptopbps"
> 2007-08-20 15:53:35 UTC CONFIG main: slon version 1.2.9 starting up
> 2007-08-20 15:53:35 UTC DEBUG2 slon: watchdog process started
> 2007-08-20 15:53:35 UTC DEBUG2 slon: watchdog ready - pid =3D 4496
> 2007-08-20 15:53:35 UTC DEBUG2 slon: worker process created - pid =3D 4497
> 2007-08-20 15:53:35 UTC CONFIG main: local node id =3D 1
> 2007-08-20 15:53:35 UTC DEBUG2 main: main process started
> 2007-08-20 15:53:35 UTC CONFIG main: launching sched_start_mainloop
> 2007-08-20 15:53:35 UTC CONFIG main: loading current cluster configuration
> 2007-08-20 15:53:35 UTC CONFIG storeNode: no_id=3D2 no_comment=3D'gb 8.0 =
5432'
> 2007-08-20 15:53:35 UTC DEBUG2 setNodeLastEvent: no_id=3D2 event_seq=3D498
> 2007-08-20 15:53:35 UTC CONFIG storeNode: no_id=3D3 no_comment=3D'gb_repl=
ica
> 8.0 5430'
> 2007-08-20 15:53:35 UTC DEBUG2 setNodeLastEvent: no_id=3D3 event_seq=3D2
> 2007-08-20 15:53:35 UTC CONFIG storePath: pa_server=3D2 pa_client=3D1
> pa_conninfo=3D"dbname=3Dsdki host=3Dpchome port=3D5432 user=3Dpostgres"
> pa_connretry=3D10
> 2007-08-20 15:53:35 UTC CONFIG storePath: pa_server=3D3 pa_client=3D1
> pa_conninfo=3D"dbname=3Dsdki2 host=3Dlocalhost port=3D5432 user=3Dpostgre=
s"
> pa_connretry=3D10
> 2007-08-20 15:53:35 UTC CONFIG storeListen: li_origin=3D2 li_receiver=3D1
> li_provider=3D2
> 2007-08-20 15:53:35 UTC CONFIG storeListen: li_origin=3D3 li_receiver=3D1
> li_provider=3D3
> 2007-08-20 15:53:35 UTC CONFIG storeSet: set_id=3D1 set_origin=3D1
> set_comment=3D'gb tables'
> 2007-08-20 15:53:35 UTC DEBUG2 sched_wakeup_node(): no_id=3D1 (0 threads +
> worker signaled)
> 2007-08-20 15:53:35 UTC DEBUG2 main: last local event sequence =3D 669
> 2007-08-20 15:53:35 UTC CONFIG main: configuration complete - starting
> threads
> 2007-08-20 15:53:35 UTC DEBUG1 localListenThread: thread starts
> 2007-08-20 15:53:35 UTC DEBUG4 version for "dbname=3Dsdki user=3Dpostgres
> port=3D5432 host=3Dlaptopbps" is 80204
> 2007-08-20 15:53:35 UTC FATAL  localListenThread: "select
> "_sdki".cleanupNodelock(); insert into "_sdki".sl_nodelock values (    1,=
 0,
> "pg_catalog".pg_backend_pid()); " - ERROR:  duplicate key violates unique
> constraint "sl_nodelock-pkey"
> 2007-08-20 15:53:35 UTC FATAL  Do you already have a slon running against
> this node?
> 2007-08-20 15:53:35 UTC FATAL  Or perhaps a residual idle backend
> connection from a dead slon?
> 2007-08-20 15:53:35 UTC DEBUG2 slon_abort() from pid=3D4497
> 2007-08-20 15:53:35 UTC DEBUG1 slon: shutdown requested
> 2007-08-20 15:53:35 UTC DEBUG2 slon: notify worker process to shutdown
> 2007-08-20 15:53:55 UTC DEBUG1 slon: child termination timeout - kill
> child
> 2007-08-20 15:53:55 UTC DEBUG2 slon: child terminated status: 9; pid:
> 4497, current worker pid: 4497
> 2007-08-20 15:53:55 UTC DEBUG1 slon: done
> 2007-08-20 15:53:55 UTC DEBUG2 slon: exit(0)



You have another slon process running. Kill that before you start a new one.

Regards

Mikko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070821/=
b554803f/attachment.htm