-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kevin Kempter a écrit :
> Hi All ;
> 
> we created a new replication set 4 hrs ago and we continue to see messages 
> like this in the logs from the slave (the slon logs):
> 
> 2010-02-02 21:04:23 PST DEBUG1 remoteWorkerThread_1: connected to provider DB
> 2010-02-02 21:04:23 PST WARN   remoteWorkerThread_1: transactions earlier than 
> XID 31685677 are still in progress
> 2010-02-02 21:04:23 PST WARN   remoteWorkerThread_1: data copy for set 2 
> failed 178 times - sleep 60 seconds
> 
> 
> The master is busy but I see no processes in pg_stat_activity that are waiting 
> and no rows in pg_locks have granted = 'f' (all rows are granted = 't')
> 
> also our st_lag_num_events in sl_status have climbed to 2729 since we ran the 
> create set command
> 
> 
>  any thoughts?

Hi,

Sometimes a simple restart of slon daemons help.

Regards,
- --
Stéphane Schildknecht
Président de PostgreSQLFr
http://www.postgresql.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFLaSgDA+REPKWGI0ERAr56AJ9pFQfnu6DaqwsbsVukWRKSJXuPiwCfWu5R
sQ+gqHKkNsQlfHDSb5gg+3M=
=Gx1Z
-----END PGP SIGNATURE-----