| Bug #50670 | Slave stops with error code 1644 | ||
|---|---|---|---|
| Submitted: | 27 Jan 2010 17:55 | Modified: | 4 Aug 2010 12:13 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.5.99-m3 | OS: | Any |
| Assigned to: | Sven Sandberg | CPU Architecture: | Any |
[18 Feb 2010 15:30]
Alfranio Tavares Correia Junior
Hi all, This is not a bug, and the behavior was introduced by the fix in BUG#39934. What is happening? ================== The SQL Thread is running in SBR and receives events in row format, complains about this by printing out the following message Last_Errno 1666 Last_Error Error 'Cannot execute row injection: binlogging impossible since BINLOG_FORMAT = STATEMENT.' on opening tables and right after stops. Cheers.
[23 Feb 2010 10:17]
Sven Sandberg
This is expected behavior. Slave is running with binlog_format = STATEMENT, which means that row injections (i.e., statements that the master logged in row format) cannot be logged. Since the row injection cannot be logged, we cannot execute it, so we have to stop the slave. I find the error message pretty clear too, but maybe we can work on a way to improve it? Is the term "row injection" confusing? Would it be better to say "row event"? Or would it be better to say "When slave uses BINLOG_FORMAT = STATEMENT, it cannot execute a statement that the master logged in row format"?
[23 Feb 2010 12:09]
Matthias Leich
1. From the user point of view:
Start servers with --binlog-format=statement and run
the application worked nice in history but the application
earns now an error message.
This means the user is here faced with a significant change
in system behaviour between actual and old release
= incompatible behaviour.
Assuming that this effect cannot be avoided than there
must be excellent help for the user like
- a very clear error message (see 2.)
- an easy to find explanation of the effect met
including a hint and how to solve this -> manual
(... start with --binlog-format=row_or_mixed ...)
2. "When slave uses BINLOG_FORMAT = STATEMENT,
it cannot execute a statement that the master
logged in row format" explains excellent what
the current problem is.
IMHO unfortunate wording from the old error message
- "row injection" - What is injection?
If it means INSERT, why not "INSERT"?
- "on opening tables" - Opening of which tables?
The tables used
- within the current statement
- within statements of executed by the session before
the current one
- MySQL system tables in general
A customer should not be forced to guess or to
read much documentation just because we did not
gave a clear message.
[10 Mar 2010 19:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/102931 3124 Sven Sandberg 2010-03-10 BUG#50670: Slave stops with error code 1644 Clarified error messages related to unsafe statements: - avoid the internal technical term "row injection" - use 'binary log' instead of 'binlog' - avoid the word 'unsafeness' @ sql/share/errmsg-utf8.txt Clarified error messages.
[14 Apr 2010 13:32]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/105645 3010 Sven Sandberg 2010-04-14 BUG#50670: Slave stops with error code 1644 Clarified error messages related to unsafe statements: - avoid the internal technical term "row injection" - use 'binary log' instead of 'binlog' - avoid the word 'unsafeness' @ mysql-test/extra/binlog_tests/blackhole.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_binlog_max_cache_size.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_insert_id.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_mixing_engines.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_start_stop_slave.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_stm_000001.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_stop_middle_group.test updated suppression pattern @ mysql-test/r/archive.result updated suppression pattern @ mysql-test/r/commit_1innodb.result updated suppression pattern @ mysql-test/r/partition_innodb_stmt.result updated result file @ mysql-test/suite/binlog/r/binlog_innodb.result updated result file @ mysql-test/suite/binlog/r/binlog_killed.result updated result file @ mysql-test/suite/binlog/r/binlog_multi_engine.result updated result file @ mysql-test/suite/binlog/r/binlog_row_mix_innodb_myisam.result updated result file @ mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_blackhole.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_do_db.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_ps.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_row.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result updated result file @ mysql-test/suite/binlog/r/binlog_unsafe.result updated result file @ mysql-test/suite/binlog/t/binlog_killed.test updated result file @ mysql-test/suite/binlog/t/binlog_multi_engine.test updated result file @ mysql-test/suite/binlog/t/binlog_statement_insert_delayed.test updated result file @ mysql-test/suite/binlog/t/binlog_stm_ps.test updated result file @ mysql-test/suite/binlog/t/binlog_stm_row.test updated result file @ mysql-test/suite/binlog/t/binlog_stm_unsafe_warning.test updated result file @ mysql-test/suite/ndb/r/ndb_binlog_format.result updated result file @ mysql-test/suite/ndb/t/ndb_binlog_format.test updated result file @ mysql-test/suite/perfschema/r/binlog_stmt.result updated result file @ mysql-test/suite/perfschema/t/binlog_stmt.test updated result file @ mysql-test/suite/rpl/r/rpl_begin_commit_rollback.result updated result file @ mysql-test/suite/rpl/r/rpl_blackhole.result updated result file @ mysql-test/suite/rpl/r/rpl_concurrency_error.result updated result file @ mysql-test/suite/rpl/r/rpl_get_lock.result updated result file @ mysql-test/suite/rpl/r/rpl_insert_id.result updated result file @ mysql-test/suite/rpl/r/rpl_insert_ignore.result updated result file @ mysql-test/suite/rpl/r/rpl_misc_functions.result updated result file @ mysql-test/suite/rpl/r/rpl_mixed_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_mixed_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_mysql_upgrade.result updated result file @ mysql-test/suite/rpl/r/rpl_nondeterministic_functions.result updated result file @ mysql-test/suite/rpl/r/rpl_read_only.result updated result file @ mysql-test/suite/rpl/r/rpl_row_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result updated result file @ mysql-test/suite/rpl/r/rpl_row_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_slow_query_log.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_000001.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_loadfile.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_stop_middle_group.result updated result file @ mysql-test/suite/rpl/r/rpl_variables_stm.result updated result file @ mysql-test/suite/rpl/t/rpl_begin_commit_rollback.test updated result file @ mysql-test/suite/rpl/t/rpl_blackhole.test updated result file @ mysql-test/suite/rpl/t/rpl_concurrency_error.test updated result file @ mysql-test/suite/rpl/t/rpl_err_ignoredtable.test updated result file @ mysql-test/suite/rpl/t/rpl_get_lock.test updated result file @ mysql-test/suite/rpl/t/rpl_insert.test updated result file @ mysql-test/suite/rpl/t/rpl_insert_id.test updated result file @ mysql-test/suite/rpl/t/rpl_insert_ignore.test updated result file @ mysql-test/suite/rpl/t/rpl_invoked_features.test updated result file @ mysql-test/suite/rpl/t/rpl_misc_functions.test updated result file @ mysql-test/suite/rpl/t/rpl_mixed_bit_pk.test updated result file @ mysql-test/suite/rpl/t/rpl_mysql_upgrade.test updated result file @ mysql-test/suite/rpl/t/rpl_nondeterministic_functions.test updated result file @ mysql-test/suite/rpl/t/rpl_optimize.test updated result file @ mysql-test/suite/rpl/t/rpl_read_only.test updated result file @ mysql-test/suite/rpl/t/rpl_semi_sync.test updated result file @ mysql-test/suite/rpl/t/rpl_semi_sync_event.test updated result file @ mysql-test/suite/rpl/t/rpl_session_var.test updated result file @ mysql-test/suite/rpl/t/rpl_slow_query_log.test updated result file @ mysql-test/suite/rpl/t/rpl_stm_auto_increment_bug33029.test updated result file @ mysql-test/suite/rpl/t/rpl_stm_found_rows.test updated result file @ mysql-test/suite/rpl/t/rpl_stm_insert_delayed.test updated result file @ mysql-test/suite/rpl/t/rpl_stm_loadfile.test updated result file @ mysql-test/suite/rpl/t/rpl_timezone.test updated result file @ mysql-test/suite/rpl/t/rpl_trigger.test updated result file @ mysql-test/suite/rpl/t/rpl_udf.test updated result file @ mysql-test/suite/rpl/t/rpl_user_variables.test updated result file @ mysql-test/suite/rpl/t/rpl_variables_stm.test updated result file @ mysql-test/suite/rpl/t/rpl_view_multi.test updated result file @ mysql-test/suite/rpl_ndb/r/rpl_ndb_binlog_format_errors.result updated result file @ mysql-test/suite/rpl_ndb/t/rpl_ndb_binlog_format_errors.test updated result file @ mysql-test/suite/rpl_ndb/t/rpl_ndb_stm_innodb.test updated result file @ mysql-test/suite/sys_vars/t/rpl_init_slave_func.test updated result file @ mysql-test/t/archive.test updated result file @ mysql-test/t/commit_1innodb.test updated result file @ mysql-test/t/lock_sync.test updated result file @ mysql-test/t/mysqldump.test updated result file @ mysql-test/t/sp_trans.test updated result file @ sql/log_event.cc Clarified error message. @ sql/share/errmsg-utf8.txt Clarified error messages.
[27 Apr 2010 9:44]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/106604 3017 Sven Sandberg 2010-04-27 BUG#50670: Slave stops with error code 1644 Clarified error messages related to unsafe statements: - avoid the internal technical term "row injection" - use 'binary log' instead of 'binlog' - avoid the word 'unsafeness' @ mysql-test/extra/binlog_tests/blackhole.test updated suppression pattern @ mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_binlog_max_cache_size.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_insert_id.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_loaddata.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_mixing_engines.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_start_stop_slave.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_stm_000001.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_stop_middle_group.test updated suppression pattern @ mysql-test/r/archive.result updated result file @ mysql-test/r/commit_1innodb.result updated result file @ mysql-test/r/ctype_cp932_binlog_stm.result updated result file @ mysql-test/r/partition_innodb_stmt.result updated result file @ mysql-test/suite/binlog/r/binlog_innodb.result updated result file @ mysql-test/suite/binlog/r/binlog_killed.result updated result file @ mysql-test/suite/binlog/r/binlog_multi_engine.result updated result file @ mysql-test/suite/binlog/r/binlog_row_mix_innodb_myisam.result updated result file @ mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_blackhole.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_do_db.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_ps.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_row.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result updated result file @ mysql-test/suite/binlog/r/binlog_unsafe.result updated result file @ mysql-test/suite/binlog/t/binlog_killed.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_multi_engine.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_statement_insert_delayed.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_stm_ps.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_stm_row.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_stm_unsafe_warning.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_tmp_table.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_unsafe.test updated suppression pattern @ mysql-test/suite/ndb/r/ndb_binlog_format.result updated result file @ mysql-test/suite/ndb/t/ndb_binlog_format.test updated suppression pattern @ mysql-test/suite/perfschema/r/binlog_stmt.result updated result file @ mysql-test/suite/perfschema/t/binlog_stmt.test updated suppression pattern @ mysql-test/suite/rpl/r/rpl_begin_commit_rollback.result updated result file @ mysql-test/suite/rpl/r/rpl_blackhole.result updated result file @ mysql-test/suite/rpl/r/rpl_concurrency_error.result updated result file @ mysql-test/suite/rpl/r/rpl_get_lock.result updated result file @ mysql-test/suite/rpl/r/rpl_insert_id.result updated result file @ mysql-test/suite/rpl/r/rpl_insert_ignore.result updated result file @ mysql-test/suite/rpl/r/rpl_misc_functions.result updated result file @ mysql-test/suite/rpl/r/rpl_mixed_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_mixed_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_mysql_upgrade.result updated result file @ mysql-test/suite/rpl/r/rpl_non_direct_mixed_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_non_direct_row_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_non_direct_stm_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_nondeterministic_functions.result updated result file @ mysql-test/suite/rpl/r/rpl_read_only.result updated result file @ mysql-test/suite/rpl/r/rpl_row_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result updated result file @ mysql-test/suite/rpl/r/rpl_row_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_slow_query_log.result updated result file @ mysql-test/suite/rpl/r/rpl_sp.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_000001.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_loadfile.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_stop_middle_group.result updated result file @ mysql-test/suite/rpl/r/rpl_temp_temporary.result updated result file @ mysql-test/suite/rpl/r/rpl_variables_stm.result updated result file @ mysql-test/suite/rpl/t/rpl000013.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_begin_commit_rollback.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_blackhole.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_concurrency_error.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_err_ignoredtable.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_get_lock.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_insert.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_insert_id.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_insert_ignore.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_invoked_features.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_misc_functions.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_mixed_bit_pk.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_mysql_upgrade.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_nondeterministic_functions.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_optimize.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_read_only.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_semi_sync.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_semi_sync_event.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_session_var.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_slow_query_log.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_sp.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_auto_increment_bug33029.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_found_rows.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_insert_delayed.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_loadfile.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_temp_table.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_temp_temporary.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_temporary.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_timezone.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_trigger.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_udf.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_user_variables.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_variables_stm.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_view_multi.test updated suppression pattern @ mysql-test/suite/rpl_ndb/r/rpl_ndb_binlog_format_errors.result updated result file @ mysql-test/suite/rpl_ndb/t/rpl_ndb_binlog_format_errors.test updated suppression pattern @ mysql-test/suite/rpl_ndb/t/rpl_ndb_stm_innodb.test updated suppression pattern @ mysql-test/suite/sys_vars/t/rpl_init_slave_func.test updated suppression pattern @ mysql-test/t/archive.test updated suppression pattern @ mysql-test/t/commit_1innodb.test updated suppression pattern @ mysql-test/t/create_select_tmp.test updated suppression pattern @ mysql-test/t/ctype_cp932_binlog_stm.test updated suppression pattern @ mysql-test/t/lock_sync.test updated suppression pattern @ mysql-test/t/mysqlbinlog.test updated suppression pattern @ mysql-test/t/mysqldump.test updated suppression pattern @ mysql-test/t/sp_trans.test updated suppression pattern @ sql/log_event.cc Clarified error message. @ sql/share/errmsg-utf8.txt Clarified error messages.
[28 Apr 2010 12:48]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/106815 3025 Sven Sandberg 2010-04-28 BUG#50670: Slave stops with error code 1644 Clarified error messages related to unsafe statements: - avoid the internal technical term "row injection" - use 'binary log' instead of 'binlog' - avoid the word 'unsafeness' @ mysql-test/extra/binlog_tests/blackhole.test updated suppression pattern @ mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_binlog_max_cache_size.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_insert_id.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_loaddata.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_mixing_engines.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_start_stop_slave.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_stm_000001.test updated suppression pattern @ mysql-test/extra/rpl_tests/rpl_stop_middle_group.test updated suppression pattern @ mysql-test/r/archive.result updated result file @ mysql-test/r/commit_1innodb.result updated result file @ mysql-test/r/ctype_cp932_binlog_stm.result updated result file @ mysql-test/r/partition_innodb_stmt.result updated result file @ mysql-test/suite/binlog/r/binlog_innodb.result updated result file @ mysql-test/suite/binlog/r/binlog_killed.result updated result file @ mysql-test/suite/binlog/r/binlog_multi_engine.result updated result file @ mysql-test/suite/binlog/r/binlog_row_mix_innodb_myisam.result updated result file @ mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_blackhole.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_do_db.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_ps.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_row.result updated result file @ mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result updated result file @ mysql-test/suite/binlog/r/binlog_unsafe.result updated result file @ mysql-test/suite/binlog/t/binlog_killed.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_multi_engine.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_statement_insert_delayed.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_stm_ps.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_stm_row.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_stm_unsafe_warning.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_tmp_table.test updated suppression pattern @ mysql-test/suite/binlog/t/binlog_unsafe.test updated suppression pattern @ mysql-test/suite/ndb/r/ndb_binlog_format.result updated result file @ mysql-test/suite/ndb/t/ndb_binlog_format.test updated suppression pattern @ mysql-test/suite/perfschema/r/binlog_stmt.result updated result file @ mysql-test/suite/perfschema/t/binlog_stmt.test updated suppression pattern @ mysql-test/suite/rpl/r/rpl_begin_commit_rollback.result updated result file @ mysql-test/suite/rpl/r/rpl_blackhole.result updated result file @ mysql-test/suite/rpl/r/rpl_concurrency_error.result updated result file @ mysql-test/suite/rpl/r/rpl_get_lock.result updated result file @ mysql-test/suite/rpl/r/rpl_insert_id.result updated result file @ mysql-test/suite/rpl/r/rpl_insert_ignore.result updated result file @ mysql-test/suite/rpl/r/rpl_misc_functions.result updated result file @ mysql-test/suite/rpl/r/rpl_mixed_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_mixed_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_mysql_upgrade.result updated result file @ mysql-test/suite/rpl/r/rpl_non_direct_mixed_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_non_direct_row_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_non_direct_stm_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_nondeterministic_functions.result updated result file @ mysql-test/suite/rpl/r/rpl_read_only.result updated result file @ mysql-test/suite/rpl/r/rpl_row_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_row_inexist_tbl.result updated result file @ mysql-test/suite/rpl/r/rpl_row_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_slow_query_log.result updated result file @ mysql-test/suite/rpl/r/rpl_sp.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_000001.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_binlog_max_cache_size.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_loadfile.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_mixing_engines.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result updated result file @ mysql-test/suite/rpl/r/rpl_stm_stop_middle_group.result updated result file @ mysql-test/suite/rpl/r/rpl_temp_temporary.result updated result file @ mysql-test/suite/rpl/r/rpl_variables_stm.result updated result file @ mysql-test/suite/rpl/t/rpl000013.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_begin_commit_rollback.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_blackhole.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_concurrency_error.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_err_ignoredtable.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_get_lock.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_insert.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_insert_id.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_insert_ignore.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_invoked_features.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_misc_functions.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_mixed_bit_pk.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_mysql_upgrade.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_nondeterministic_functions.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_optimize.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_read_only.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_semi_sync.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_semi_sync_event.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_session_var.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_slow_query_log.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_sp.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_auto_increment_bug33029.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_found_rows.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_insert_delayed.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_stm_loadfile.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_temp_table.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_temp_temporary.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_temporary.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_timezone.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_trigger.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_udf.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_user_variables.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_variables_stm.test updated suppression pattern @ mysql-test/suite/rpl/t/rpl_view_multi.test updated suppression pattern @ mysql-test/suite/rpl_ndb/r/rpl_ndb_binlog_format_errors.result updated result file @ mysql-test/suite/rpl_ndb/t/rpl_ndb_binlog_format_errors.test updated suppression pattern @ mysql-test/suite/rpl_ndb/t/rpl_ndb_stm_innodb.test updated suppression pattern @ mysql-test/suite/sys_vars/t/rpl_init_slave_func.test updated suppression pattern @ mysql-test/t/archive.test updated suppression pattern @ mysql-test/t/commit_1innodb.test updated suppression pattern @ mysql-test/t/create_select_tmp.test updated suppression pattern @ mysql-test/t/ctype_cp932_binlog_stm.test updated suppression pattern @ mysql-test/t/lock_sync.test updated suppression pattern @ mysql-test/t/mysqlbinlog.test updated suppression pattern @ mysql-test/t/mysqldump.test updated suppression pattern @ mysql-test/t/sp_trans.test updated suppression pattern @ sql/log_event.cc Clarified error message. @ sql/share/errmsg-utf8.txt Clarified error messages.
[29 Apr 2010 20:48]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/106997 3161 Alfranio Correia 2010-04-29 Post-merge fix for BUG#50670 Updated result file.
[7 May 2010 9:21]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100507091908-vqyhpwf2km0aokno) (version source revid:alik@sun.com-20100507091737-12vceffs11elb25g) (merge vers: 6.0.14-alpha) (pib:16)
[7 May 2010 9:22]
Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100507091655-349gwq21ursz8y4p) (version source revid:alik@sun.com-20100507091655-349gwq21ursz8y4p) (merge vers: 5.5.5-m3) (pib:16)
[7 May 2010 9:23]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100507091823-nzao4h3qosau4tin) (version source revid:alik@sun.com-20100507091720-ib9r8uny2aeazvas) (pib:16)
[7 May 2010 19:54]
Paul DuBois
Cosmetic changes (improvements to error messages). No changelog entry needed.
[4 Aug 2010 8:04]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100507093958-2y0wy6svnc3zfgqb) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:20]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100507093958-2y0wy6svnc3zfgqb) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 12:13]
Jon Stephens
Closed without further action; see Paul's comment above.
Description: My script: ---------- --source include/master-slave.inc --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 ( f1 BIGINT); SET SESSION BINLOG_FORMAT = ROW; INSERT INTO t1 ( f1 ) VALUES ( 13 ); COMMIT; --sync_slave_with_master connection master; DROP TABLE t1; Result on 5.5.99-m3 (mysql-next-mr revno: 2965 2010-01-25) -------------------------------------- ./mysql-test-run --mysqld=--binlog-format=statement rpl_ml50 ... TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.rpl_ml50 [ fail ] Test ended at 2010-01-27 18:32:36 ... === SHOW SLAVE STATUS === ---- 1. ---- ... Last_Errno 1666 Last_Error Error 'Cannot execute row injection: binlogging impossible since BINLOG_FORMAT = STATEMENT.' on opening tables ... analyze: sync_with_master mysqltest: At line 14: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 500, 300)' returned NULL indicating slave SQL thread failure The result from queries just before the failure was: < snip > reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; SELECT VERSION(); VERSION() 5.5.99-m3-debug-log DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( f1 BIGINT); SET SESSION BINLOG_FORMAT = ROW; INSERT INTO t1 ( f1 ) VALUES ( 13 ); COMMIT; == /work2/6.0/mysql-next-mr/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:25863 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 6 root localhost NULL Query 0 NULL SHOW PROCESSLIST SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.99-m3-debug-log, Binlog ver: 4 master-bin.000001 107 Query 1 193 use `test`; DROP TABLE IF EXISTS t1 master-bin.000001 193 Query 1 284 use `test`; CREATE TABLE t1 ( f1 BIGINT) master-bin.000001 284 Query 1 352 BEGIN master-bin.000001 352 Table_map 1 393 table_id: 41 (test.t1) master-bin.000001 393 Write_rows 1 431 table_id: 41 flags: STMT_END_F master-bin.000001 431 Query 1 500 COMMIT == /work2/6.0/mysql-next-mr/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == SHOW PROCESSLIST; Id User Host db Command Time State Info 4 system user NULL Connect 0 Waiting for master to send event NULL 6 root localhost NULL Query 0 NULL SHOW PROCESSLIST SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 107 Server ver: 5.5.99-m3-debug-log, Binlog ver: 4 slave-bin.000001 107 Query 1 193 use `test`; DROP TABLE IF EXISTS t1 slave-bin.000001 193 Query 1 284 use `test`; CREATE TABLE t1 ( f1 BIGINT) Workaround: The bug disappears if you use binlog_format <> STATEMENT at startup. ./mysql-test-run --mysqld=--binlog-format=row rpl_ml50 The following releases show this bug: ------------------------------------- - 5.5.99-m3 mysql-next-mr revno: 2965 2010-01-25 - 6.0.14-alpha mysql-6.0-codebase-bugfixing revno: 3854 2010-01-27 - 5.1.43 !! mysql-5.1-rep+3 revno: 3134 2010-01-20 The following releases do not show this bug: -------------------------------------------- - 5.1.43 mysql-5.1-bugteam revno: 3336 2010-01-27 - 5.1.44 mysql-5.1 revno: 3315 2010-01-15 How to repeat: See above ./mysql-test-run --mysqld=--binlog-format=statement rpl_ml50