On Wed, May 11, 2011 at 2:26 PM, Steve Singer <[email protected]>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
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
