Bug #61298 Strange behavior creating events on the slave server

• Submitted: 26 May 2011 8:01
• Modified: 14 Aug 2011 20:06
• Reporter: Pavel Dobryakov
• Status: No Feedback
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.1.54
• OS: FreeBSD
• CPU Architecture: Any

[26 May 2011 8:01] Pavel Dobryakov

Description:
I have some events on master server and  mixed-based binlog.
when I pick up replication from the dump, on the slave, events on the slave server events on the slave creating without option "disabled on slave",which leads to errors.

How to repeat:
create some events, then make dump of database (such as mysqldump --opt -R -E -K --triggers --master-data=1 -B database), then load this dump on slave server.

[26 May 2011 17:44] Valeriy Kravchuk

Please, send some small result of mysqldump that demonstrates the problem.

[27 May 2011 5:54] Pavel Dobryakov

I`ve attached file whith this. This is exactly what you asked?

[27 May 2011 5:55] Pavel Dobryakov

dump

Attachment: dump.txt (text/plain), 5.88 KiB.

[31 May 2011 14:14] Pavel Dobryakov

is-there any results? This error is extremely distasteful to expand the slave servers, especially when a large of number of logic in the database

[14 Jul 2011 20:06] Sveta Smirnova

Thank you for the report.

I can not repeat any error with version 5.5.14. Additionally version 5.1.54 is old. Please try with current version 5.1.58 and if problem still exists send us errors you get.

[14 Aug 2011 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".