Steve Singer ssinger at ca.afilias.info
Tue May 6 07:54:38 PDT 2014

I see what is going on (based on the logs you sent that the list didn't 
like)


node 4 is configured to use node 2 as the provider for the set

Node 4 has the following in its event queue

1,5000000111 SYNC
.
.
1,5000000118 FAILOVER_NODE

remoteWorker_1 on node 4 doesn't process the FAILOVER_NODE because it 
can't get beyond the SYNC.  It can't get beyond the SYNC because the 
provider for 1 is 2 which has gone offline.


2014-05-01_165630 BSTDEBUG2 remoteWorkerThread_1: SYNC 5000000111 
processing 2014-05-01_165630 BSTERROR slon_connectdb: 
PQconnectdb("dbname=TEST host=localhost port=5433 user=slony") failed - 
could not connect to server: Connection refused Is the server running on 
host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 
5433? 2014-05-01_165630 BSTERROR remoteWorkerThread_1: cannot connect to 
data provider 2 on 'dbname=TEST host=localhost port=5433 user=slony' 
2014-05-01_165630 BSTDEBUG2 remoteWorkerThread_1: rollback SYNC 
transaction 2014-05-01_165632 BSTERROR slon_connectdb: 
PQconnectdb("dbname=TEST host=localhost port=5434 user=slony") failed - 
could not connect to server: Connection refused Is the server running on 
host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 
5434? 2014-05-01_165632 BSTWARN remoteListenThread_3: DB connection 
failed - sleep 10 seconds




More information about the Slony1-general mailing list