Hi, I have a slon instance that is running 2.0.3 RC3 with PostgreSQL 8.3 and 8.4. They all run on the same server (my personal server).
Today I restarted 8.3 instance to perform an upgrade. Since then, Slony-I reports a lag when I query it from slave. On master, everything looks ok. There is nothing suspicious in the logs -- and logs say that data is flowing from 8.3 to 8.4 -- and I confirmed that data on origin and subscriber are the same. I restarted slon daemons, but it did not help. It just reset the lag time, but since then lag is still increasing. Here is what I exactly have: Origin: # SELECT * from _replication.sl_status; -[ RECORD 1 ]-------------+--------------------------- st_origin | 3 st_received | 4 st_last_event | 902839 st_last_event_ts | 2009-12-10 16:02:56.016067 st_last_received | 902838 st_last_received_ts | 2009-12-10 16:02:51.185257 st_last_received_event_ts | 2009-12-10 16:02:46.011313 st_lag_num_events | 1 st_lag_time | 00:00:13.556469 Subscriber: # SELECT * from _replication.sl_status; -[ RECORD 1 ]-------------+--------------------------- st_origin | 4 st_received | 3 st_last_event | 19 st_last_event_ts | 2009-12-10 15:59:58.911679 st_last_received | 19 st_last_received_ts | 2009-12-10 16:00:01.781158 st_last_received_event_ts | 2009-12-10 15:59:58.911679 st_lag_num_events | 0 st_lag_time | 00:03:38.107517 Is there anything that I can help you to debug this issue? Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
