Dear Bill Moran,

Before i test slony with network fail, It run well, the master and slave
node update data together very well.

Then I simulated the network failure and slave don't have data as master.

I tested this case two times, and I have the same result, slony don't update
to slave node.

The second testing, I don't restart slony service and don't restart computer
and I wait for two hours.

But no change.

I attch slony log and system view, please see them and help me.
http://www.nabble.com/file/p25670372/postgresql-2009-09-29_000000.log
postgresql-2009-09-29_000000.log 
http://www.nabble.com/file/p25670372/system%2Bview.csv system+view.csv 

Thank you vey much.
baoluc at gmail.com



Bill Moran wrote:
> 
> In response to Airbus380 <baoluc at gmail.com>:
>> 
>> Hi all,
>> Slony-I is new with me, so I have a problem as following:
>> 
>> I have two databse, db_master (host: 192.168.1.226) and db_slave (host:
>> 192.168.1.5).
>> I config slony-i work well, all operates on data is ok. 
>> 
>> I using pgadminIII (on host 192.168.1.226) to connect two db, 
>> then I try to disable network adapter on host 192.168.1.226.
>> 
>> Next, I insert and edit some data on db_master and wait for minute.
>> 
>> After that I enable network adapter on host 192.168.1.226, the data on
>> db_slave.
>> 
>> The problem is: the data on db_slave and db_master are diffrent. On
>> db_slave, the data isn't updated.
>> 
>> Note: I use postgres on windows. I restart slony service and restart
>> computer 192.168.1.226.
>> But I can't resolve this problem.
>> 
>> Please help me.
> 
> First, did you test and verify that replication was working correctly
> _before_ you simulated the network failure?
> 
> Second, how long did you wait after reconnecting?  Slony sometimes takes
> a few minutes to get going again after a network failure.  Restarting
> everything only makes it take longer.
> 
> Third, What's in slony's logs?
> 
> -- 
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

-- 
View this message in context: http://www.nabble.com/Slony-I%2C-slave-node-can%27t-get-data-from-master-after-network-fail-tp25648985p25670372.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.