>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;
}
>Submitter-Id: <submitter ID>
>Originator: Matthias Urlichs
>Organization:
>MySQL support: licence
>Synopsis: mysqlbinlog doesn't print the offset
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: change-request
>Release: mysql-3.23.32 (noris network MySQL)
>Environment:
System: Linux play.smurf.noris.de 2.4.0s-noris-t5-2 #58 SMP Wed Jul 19 10:24:19 CEST
2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs
gcc version 2.95.3 19991030 (prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-DTHREAD_SAFE_CLIENT
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 8 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4118299 Sep 20 1999 /lib/libc-2.1.2.so
-rwxr-xr-x 1 root root 4123003 Jun 8 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 19203634 Jun 8 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jun 8 2000 /usr/lib/libc.so
-rwxr-xr-x 1 root root 2042654 Oct 27 17:09 /usr/lib/libc-client.a
Configure command: ./configure --prefix=/usr --with-debug --enable-shared
--without-mit-threads --libexecdir=/usr/sbin --localstatedir=/var/mysql
--enable-thread-safe-client --sysconfdir=/etc --datadir=/usr/share
--enable-large-files --without-readline --with-mysqld-user=mysql
--with-unix-socket-path=/var/run/mysql.socket --enable-strcoll '--with-comment=noris
network MySQL' --with-docs --with-bench --without-berkeley-db --without-bench
---------------------------------------------------------------------
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