Aaron Randall aaron.randall
Fri Apr 7 03:06:05 PDT 2006
Hi all!

I am seeing a problem occurring after a few days of replication between 
two of my servers - they replicate fine and then suddenly the slon 
process stops on the slave.  The log file gives good information...I 
just need help in understanding it.  Here is the point in the slave logs 
where the slon process shuts down:

"2006-03-31 12:47:40 GMT DEBUG2 remoteHelperThread_1_1: 0.007 seconds 
until close cursor
2006-03-31 12:47:40 GMT DEBUG2 remoteWorkerThread_1: new sl_rowid_seq 
value: 1000000000000000
2006-03-31 12:47:40 GMT DEBUG2 remoteWorkerThread_1: SYNC 244391 done in 
0.034 seconds
2006-03-31 12:47:47 GMT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 230540
2006-03-31 12:47:47 GMT DEBUG2 localListenThread: Received event 
2,230540 SYNC
2006-03-31 12:47:47 GMT DEBUG2 remoteWorkerThread_1: forward confirm 
2,230540 received by 1
2006-03-31 12:47:50 GMT DEBUG2 remoteListenThread_1: queue event 
1,244392 SYNC
2006-03-31 12:47:50 GMT DEBUG2 remoteWorkerThread_1: Received event 
1,244392 SYNC
2006-03-31 12:47:50 GMT DEBUG2 remoteWorkerThread_1: SYNC 244392 processing
2006-03-31 12:47:50 GMT DEBUG2 remoteWorkerThread_1: syncing set 1 with 
250 table(s) from mytable 1
2006-03-31 12:47:50 GMT DEBUG2 remoteHelperThread_1_1: 0.006 seconds 
delay for first row
2006-03-31 12:47:50 GMT DEBUG2 remoteHelperThread_1_1: 0.007 seconds 
until close cursor
2006-03-31 12:47:50 GMT DEBUG2 remoteWorkerThread_1: new sl_rowid_seq 
value: 1000000000000000
2006-03-31 12:47:50 GMT DEBUG2 remoteWorkerThread_1: SYNC 244392 done in 
0.032 seconds
2006-03-31 12:47:56 GMT FATAL  syncThread: "start transaction;set 
transaction isolation level serializable;select last_value from 
"_my_replication".sl_action_seq;" - FATAL:  terminating connection due 
to administrator command
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
2006-03-31 12:47:56 GMT DEBUG1 slon: shutdown requested
2006-03-31 12:47:56 GMT DEBUG2 slon: notify worker process to shutdown
2006-03-31 12:47:56 GMT DEBUG2 slon: wait for worker process to shutdown
2006-03-31 12:47:56 GMT INFO   remoteListenThread_1: disconnecting from 
'host=1.1.1.2 dbname=mydb user=slonyuser port=5432'
2006-03-31 12:47:56 GMT DEBUG1 remoteListenThread_1: thread done
2006-03-31 12:47:56 GMT DEBUG1 localListenThread: thread done
2006-03-31 12:47:56 GMT DEBUG1 cleanupThread: thread done
2006-03-31 12:47:56 GMT DEBUG1 main: scheduler mainloop returned
2006-03-31 12:47:56 GMT DEBUG2 main: wait for remote threads
2006-03-31 12:47:56 GMT DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + 
worker signaled)
2006-03-31 12:47:56 GMT DEBUG1 remoteWorkerThread_1: helper thread for 
provider 1 terminated
2006-03-31 12:47:56 GMT DEBUG1 remoteWorkerThread_1: disconnecting from 
data provider 1
2006-03-31 12:47:56 GMT DEBUG1 remoteWorkerThread_1: thread done
2006-03-31 12:47:56 GMT DEBUG2 main: notify parent that worker is done
2006-03-31 12:47:56 GMT DEBUG1 main: done
2006-03-31 12:47:56 GMT DEBUG2 slon: worker process shutdown ok
2006-03-31 12:47:56 GMT DEBUG2 slon: exit(-1)
"


Kind regards,

Aaron




More information about the Slony1-general mailing list