mmmm, the binlog numbers are not consecutive when I look at the file modification dates.
[/beanstalkd-log @ 14:57:49]>ll -t total 7168000 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-05 11:29 binlog. 669 -r-------- 1 beanstalkd beanstalkd 10485597 2010-11-05 10:58 binlog. 668 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-05 10:42 binlog. 700 -r-------- 1 beanstalkd beanstalkd 10485697 2010-11-05 08:11 binlog. 667 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-05 07:59 binlog. 699 -r-------- 1 beanstalkd beanstalkd 10485623 2010-11-05 05:15 binlog. 666 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-05 05:08 binlog. 698 -r-------- 1 beanstalkd beanstalkd 10485504 2010-11-05 03:42 binlog. 665 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-05 03:32 binlog. 697 -r-------- 1 beanstalkd beanstalkd 10485612 2010-11-05 01:08 binlog. 664 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-05 00:56 binlog. 696 -r-------- 1 beanstalkd beanstalkd 10485596 2010-11-05 00:01 binlog. 663 -r-------- 1 beanstalkd beanstalkd 10485760 2010-11-04 23:56 binlog. 695 Does it mean that there's no way I could manually play with the binlog files ? Nicolas On Nov 5, 2:50 pm, Nicolas <[email protected]> wrote: > Hi, > > After some bad manipulations, our queues became completely empty. > I looked at the binlog and saw that, even if it's a binary format, the > instructions are readable by a human. > > So here are my questions: > - An easy (but not complete) recovery would be to simply drop the most > recent binlog file and launch beanstalkd again. Would it work ? > - An complete recovery would be to detect in the binlog where the bad > instructions began, and delete everything after that. I'm not sure > it's a good idea, as the binlog files seem to have the same size, with > a lot of empty lines. Also, I can't see any date before each > instruction (to help me find where the bad instructions began). Is > their a date per instruction ? Is it encoded in a binary format ? > > I'm trying the 2 scenarii above right now with a copy of my binlog, > but as my binlog is 7GB, an answer could save me some time. > > Thanks, > Nicolas -- You received this message because you are subscribed to the Google Groups "beanstalk-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/beanstalk-talk?hl=en.
