>Description:
If i call get_lock('kornexl',10) in the master (Version 3.23.47), and
release_lock('kornexl') later, there are no errors in the master.
The slave (Version 3.23.44) stops with the following error:
ERROR: 1064 You have an error in your SQL syntax near 'DO RELEASE_LOCK("kornexl")' at
line 1
020128 14:55:04 Slave: error running query 'DO RELEASE_LOCK("kornexl")'
020128 14:55:04 Error running query, slave aborted. Fix the problem,
and re-start the slave thread with "mysqladmin start-slave".
We stopped at log 'www-bin.006' position 40034
020128 14:55:04 Slave thread exiting, replication stopped in log
'www-bin.006' at position 40034
>How-To-Repeat:
mysql> select get_lock('xx',10); select release_lock('xx');
>Fix:
on the slave: set sql_slave_skip_counter=1 ; slave start
>Submitter-Id: <submitter ID>
>Originator: Anton kornexl
>Organization:
Universitaet Passau
>MySQL support: email support
>Synopsis: Bug in Replication
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.44 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.44-Max-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 days 22 hours 2 min 12 sec
Threads: 1 Questions: 53171 Slow queries: 0 Opens: 187 Flush tables: 1 Open
tables: 25 Queries per second avg: 0.157
>Environment:
System: Linux www22 2.4.10-64GB-SMP #1 SMP Tue Sep 25 12:36:09 GMT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 -mcpu=i486 -march=i486
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE
-felide-constructors -fno-exceptions
-fno-rtti' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1384040 Dez 18 17:24 /lib/libc.so.6
-rw-r--r-- 1 root root 25214756 Dez 18 17:07 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dez 18 17:07 /usr/lib/libc.so
-rw-r--r-- 1 root root 856542 Sep 24 04:13 /usr/lib/libc-client.a
lrwxrwxrwx 1 root root 20 Dez 27 15:48 /usr/lib/libc-client.so ->
libc-client.so.2000c
-rwxr-xr-x 1 root root 718160 Sep 24 04:13 /usr/lib/libc-client.so.2000c
Configure command: ./configure --disable-shared --with-mysqld-ldflags='-all-static'
--with-client-ldflags='-all-static' --without-berkeley-db --without-innodb
--enable-assembler --enable-large-files --infodir=/usr/share/info --libdir=/usr/lib
--libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man
--prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug
--datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-libwrap
---------------------------------------------------------------------
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
