>Description:
Sometimes, when you get a resync error, you need to skip
a particular update and restart with the next bit.
>How-To-Repeat:
Insert conflicting records and try to re-sync without deleting one.
>Fix:
Apply this patch.
Index: noris.38/sql/mysqlbinlog.cc
--- noris.38/sql/mysqlbinlog.cc Wed, 24 Jan 2001 21:35:51 +0100 smurf
(database_mysql/N/b/20_mysqlbinlo 1.12 664)
+++ noris.39/sql/mysqlbinlog.cc Mon, 05 Feb 2001 22:00:12 +0100 smurf
+(database_mysql/N/b/20_mysqlbinlo 1.13 664)
@@ -355,18 +355,25 @@
while(1)
{
char llbuff[21];
+ my_off_t old_off = my_b_tell(file);
+
Log_event* ev = Log_event::read_log_event(file, 0);
if (!ev)
{
if (file->error)
die("\
Could not read entry at offset %s : Error in log format or read error",
- llstr(my_b_tell(file),llbuff));
+ llstr(old_off,llbuff));
// file->error == 0 means EOF, that's OK, we break in this case
break;
}
if (rec_count >= offset)
+ {
+ if (!short_form)
+ printf("# at %s\n",llstr(old_off,llbuff));
+
ev->print(stdout, short_form);
+ }
rec_count++;
delete ev;
}
Applied. Thanks!
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php