On Fri, May 2, 2008 at 8:46 AM, Tory M Blue <tmblue at gmail.com> wrote:
> On Fri, May 2, 2008 at 5:58 AM, Charles Duffy <charles.duffy at gmail.com> wrote:
>  > >  > I'd have expected such a patch would have been applied to the 1.2.14rc tarball? I guess I don''t understand something about the release procedures etc.
>  >  >
>  >  >  I think so too.. the original patch which I sent was not applied correctly,
>  >  >  I hope the release 1.2.14 or 1.2.14rc2.
>  >  >
>  >
>  >  Oh, just noticed that it was committed:
>  >
>  >  http://lists.slony.info/pipermail/slony1-commit/2008-March/002214.html
>  >
>  >  Didn't make it into the tarball...
>
>  Okay going to patch the 1.2.14rc release and do some further testing
>  thanks
>  Tory


So appears this does in fact fix the fail over issue for the most
part.Although I see this on one of the slave nodes after initial
switchover. I do not see a hanging slave node causing issues with
failover nor did I have to rebuild, but I did see this error, each
time I switchover. Have done this test 4 times now (switchover,
switchback, verifying replication between each switch).

any idea? It appears to be the last node each time..

Qslavehost2 (node 4)

-Tory

2008-05-02 09:34:42 PDT DEBUG4 version for "dbname=clsdb
host=devidb04.domain.com user=postgres password=SECURED" is 80205
2008-05-02 09:34:42 PDT ERROR  remoteListenThread_3:
db_getLocalNodeId() returned 2 - wrong database?
2008-05-02 09:34:42 PDT DEBUG2 remoteListenThread_1: LISTEN
2008-05-02 09:34:42 PDT DEBUG2 remoteWorkerThread_1: forward confirm
2,103 received by 1
2008-05-02 09:34:44 PDT DEBUG2 remoteListenThread_1: queue event 1,180 SYNC
2008-05-02 09:34:44 PDT DEBUG2 remoteListenThread_1: UNLISTEN
2008-05-02 09:34:44 PDT DEBUG2 remoteWorkerThread_1: Received event 1,180 SYNC
2008-05-02 09:34:44 PDT DEBUG2 calc sync size - last time: 1 last
length: 3010 ideal: 19 proposed size: 3
2008-05-02 09:34:44 PDT DEBUG2 remoteWorkerThread_1: SYNC 180 processing
2008-05-02 09:34:44 PDT DEBUG2 remoteWorkerThread_1: no sets need
syncing for this event
2008-05-02 09:34:44 PDT DEBUG2 remoteWorkerThread_1: forward confirm
2,103 received by 3
2008-05-02 09:34:44 PDT DEBUG2 remoteWorkerThread_1: forward confirm
1,180 received by 3
2008-05-02 09:34:46 PDT DEBUG2 remoteListenThread_2: LISTEN
2008-05-02 09:34:46 PDT DEBUG2 remoteWorkerThread_2: forward confirm
1,180 received by 2
2008-05-02 09:34:46 PDT DEBUG2 localListenThread: Received event 4,92 SYNC
2008-05-02 09:34:46 PDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 93
2008-05-02 09:34:48 PDT DEBUG2 remoteWorkerThread_2: forward confirm
4,93 received by 2
2008-05-02 09:34:49 PDT DEBUG2 remoteListenThread_1: queue event 3,94 SYNC
2008-05-02 09:34:49 PDT DEBUG2 remoteListenThread_1: UNLISTEN
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_3: Received event 3,94 SYNC
2008-05-02 09:34:49 PDT DEBUG2 calc sync size - last time: 1 last
length: 5015 ideal: 11 proposed size: 3
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_3: SYNC 94 processing
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_3: no sets need
syncing for this event
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_1: forward confirm
3,94 received by 1
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_1: forward confirm
4,93 received by 1
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_1: forward confirm
4,93 received by 3
2008-05-02 09:34:49 PDT DEBUG2 remoteListenThread_2: LISTEN
2008-05-02 09:34:49 PDT DEBUG2 remoteWorkerThread_2: forward confirm
3,94 received by 2
2008-05-02 09:34:51 PDT DEBUG2 remoteListenThread_2: queue event 2,104 SYNC
2008-05-02 09:34:51 PDT DEBUG2 remoteListenThread_2: UNLISTEN
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2: Received event 2,104 SYNC
2008-05-02 09:34:51 PDT DEBUG2 calc sync size - last time: 1 last
length: 2019 ideal: 29 proposed size: 3
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2: SYNC 104 processing
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2: syncing set 1
with 9 table(s) from provider 2
2008-05-02 09:34:51 PDT DEBUG4  ssy_action_list value:
2008-05-02 09:34:51 PDT DEBUG2  ssy_action_list length: 0
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2: current local
log_status is 0
2008-05-02 09:34:51 PDT DEBUG3 remoteWorkerThread_2: activate helper 2
2008-05-02 09:34:51 PDT DEBUG4 remoteWorkerThread_2: waiting for log data
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: got work to do
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2_2: current remote
log_status = 0
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: allocate line buffers
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: fetch from cursor
2008-05-02 09:34:51 PDT DEBUG2 remoteHelperThread_2_2: 0.002 seconds
delay for first row
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: fetched 0 log rows
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: return 10
unused line buffers
2008-05-02 09:34:51 PDT DEBUG2 remoteHelperThread_2_2: 0.002 seconds
until close cursor
2008-05-02 09:34:51 PDT DEBUG2 remoteHelperThread_2_2: inserts=0
updates=0 deletes=0
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: change helper
thread status
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: send DONE/ERROR
line to worker
2008-05-02 09:34:51 PDT DEBUG3 remoteWorkerThread_2: helper 2 finished
2008-05-02 09:34:51 PDT DEBUG4 remoteWorkerThread_2: returning lines to pool
2008-05-02 09:34:51 PDT DEBUG3 remoteWorkerThread_2: all helpers done.
2008-05-02 09:34:51 PDT DEBUG4 remoteWorkerThread_2: changing helper 2 to IDLE
2008-05-02 09:34:51 PDT DEBUG4 remoteWorkerThread_2: cleanup
2008-05-02 09:34:51 PDT DEBUG4 remoteHelperThread_2_2: waiting for work
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2: new sl_rowid_seq
value: 2000000000000000
2008-05-02 09:34:51 PDT DEBUG2 remoteWorkerThread_2: SYNC 104 done in
0.010 seconds
2008-05-02 09:34:51 PDT DEBUG2 localListenThread: Received event 4,93 SYNC
2008-05-02 09:34:52 PDT DEBUG4 version for "dbname=clsdb
host=devidb04.domain.com user=postgres password=SECURED" is 80205
2008-05-02 09:34:52 PDT ERROR  remoteListenThread_3:
db_getLocalNodeId() returned 2 - wrong database?