[EMAIL PROTECTED] writes:
> >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
>
>
Hi!
Thank you for your contribution.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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