Anton kornexl writes:
> >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
>
Hi!
>From the Changelog for 3.23.47:
* Fixed core-dump bug in replication when using SELECT
RELEASE_LOCK();
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
