On Wed, May 11, 2011 at 2:26 PM, Steve Singer <ssinger at ca.afilias.info>wrote:

> On 11-05-11 04:29 PM, Richard Yen wrote:
>
>> Thanks Steve.  I've put the dumps for the master and my two slaves at
>> http://richyen.com/slony/
>>
>
> As Jan suspected there isn't really anything still left in the logs about
> events from before the failed insert.
>
> When should the row have been deleted from cron_lock? immediately before or
> sometime before?
>
The cron runs every hour, so there should have been a DELETE  at 10:40AM,
just milliseconds before the INSERT.


> Did anything else happen around this time? (server restarts, moving masters
> etc?)
>
No, we didn't do anything during this time.  The previous action I performed
on this cluster was at 10:04AM, which was to INSERT a row into another table
in the database.  The sync_interval I have is 500ms, so I'm fairly confident
that this would have been processed long before the offending INSERT to
cron_lock arrived at 10:40AM.  The oldest entry in sl_even right now is
'2011-05-11 10:40:02.354653'

If we can't get any more clues, I'll go ahead an process the DELETE.  Thanks
again for your help in trying to get to the bottom of this.
--Richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110511/f0461a44/attachment.htm