<div dir="ltr">Hi All,<br><br> I have two Slony test beds which show the exact same symptoms! <br><br><span style="font-family: courier new,monospace;">select * from sl_event order by ev_seqno;</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> ev_origin | ev_seqno | ev_timestamp | ev_snapshot | ev_type | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">-----------+------------+----------------------------+----------------------------+---------+-</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 2 | 5000000002 | 2010-04-30 08:32:38.622928 | 458:458: | SYNC | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 1 | 5000525721 | 2010-05-12 13:30:22.79626 | 72685915:72685915: | SYNC | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 1 | 5000525722 | 2010-05-12 13:30:24.800943 | 72686139:72686139: | SYNC | </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 1 | 5000525723 | 2010-05-12 13:30:26.804862 | 72686224:72686224: | SYNC | </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">...</span><br style="font-family: courier new,monospace;">
<br>The reason I think this _might_ be a bug is that on both clusters, slave node's sl_event has the exact same record for ev_seqno=<span style="font-family: courier new,monospace;">5000000002 except for the timestamp; same origin, and same snapshot!</span><br>
<br>The head of sl_confirm has:<br><br><span style="font-family: courier new,monospace;"> select * from sl_confirm order by con_seqno;</span><br><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> con_origin | con_received | con_seqno | con_timestamp</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">------------+--------------+------------+----------------------------</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 2 | 1 | 5000000002 | 2010-04-30 08:32:53.974021</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 1 | 2 | 5000527075 | 2010-05-12 14:15:41.192279</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 1 | 2 | 5000527076 | 2010-05-12 14:15:43.193607</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 1 | 2 | 5000527077 | 2010-05-12 14:15:45.196291</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 1 | 2 | 5000527078 | 2010-05-12 14:15:47.197005</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">...</span><br><br clear="all">Can someone comment on the health of the cluster? All events, except for that on, are being confirmed and purged from the system regularly, so my assumption is that the cluster is healthy and that the slave is in sync with the master.<br>
<br>Thanks in advance.<br>-- <br>gurjeet.singh<br>@ EnterpriseDB - The Enterprise Postgres Company<br><a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br><br>singh.gurjeet@{ gmail | yahoo }.com<br>
Twitter/Skype: singh_gurjeet<br>
<br>Mail sent from my BlackLaptop device<br>
</div>