diff options
author | Sven Sandberg <sven.sandberg@sun.com> | 2010-04-28 14:47:49 +0200 |
---|---|---|
committer | Sven Sandberg <sven.sandberg@sun.com> | 2010-04-28 14:47:49 +0200 |
commit | cf5ebc58215e46ae7ec4d4d5a8dc5b90506d817a (patch) | |
tree | 48236122e000ffb3a4e841a3b5437b2525adc2fe /mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result | |
parent | 164ff4475429bea2fcc5ac6125f76ecb0b7d5627 (diff) | |
download | mariadb-git-cf5ebc58215e46ae7ec4d4d5a8dc5b90506d817a.tar.gz |
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.
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result')
-rw-r--r-- | mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result b/mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result index ad396bce9e4..837aafb9ae7 100644 --- a/mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result +++ b/mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result @@ -1,5 +1,5 @@ CALL mtr.add_suppression("Statement may not be safe to log in statement format."); -call mtr.add_suppression("Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT"); +call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); drop table if exists t1, t2; create table t1 (a int) engine=innodb; create table t2 (a int) engine=myisam; @@ -8,7 +8,7 @@ begin; insert into t1 values(1); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. commit; show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info @@ -23,7 +23,7 @@ begin; insert into t1 values(2); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. rollback; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back @@ -42,7 +42,7 @@ savepoint my_savepoint; insert into t1 values(4); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. rollback to savepoint my_savepoint; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back @@ -65,7 +65,7 @@ savepoint my_savepoint; insert into t1 values(6); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. rollback to savepoint my_savepoint; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back @@ -95,7 +95,7 @@ begin; insert into t1 values(8); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. select get_lock("a",10); get_lock("a",10) 1 @@ -111,7 +111,7 @@ reset master; insert into t1 values(9); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN @@ -127,7 +127,7 @@ insert into t1 values(10); begin; insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN @@ -246,11 +246,11 @@ Warning 1196 Some non-transactional changed tables couldn't be rolled back create table t0 (n int); insert t0 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. set autocommit=1; insert into t0 select GET_LOCK("lock1",null); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement uses a system function whose value may differ on slave. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. set autocommit=0; create table t2 (n int) engine=innodb; insert into t2 values (3); @@ -335,7 +335,7 @@ INSERT INTO t1 values (6,6); CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a)) engine=innodb ; INSERT INTO t1 values (7,7); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Non-transactional reads or writes are unsafe if they occur after transactional reads or writes inside a transaction. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction. ROLLBACK; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back @@ -429,7 +429,7 @@ begin; insert into t1 values(8); insert into t2 select * from t1; Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements that read from both transactional (or a temporary table of any engine type) and non-transactional tables and write to any of them are unsafe. select get_lock("a",10); get_lock("a",10) 1 @@ -516,10 +516,10 @@ end| reset master; insert into t2 values (bug27417(1)); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. insert into t2 select bug27417(2); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. reset master; insert into t2 values (bug27417(2)); ERROR 23000: Duplicate entry '2' for key 'PRIMARY' @@ -539,7 +539,7 @@ count(*) 2 delete from t2 where a=bug27417(3); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. select count(*) from t2 /* nothing got deleted */; count(*) 2 @@ -556,7 +556,7 @@ count(*) delete t2 from t2 where t2.a=bug27417(100) /* must not affect t2 */; affected rows: 0 Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. select count(*) from t1 /* must be 7 */; count(*) 7 @@ -774,10 +774,10 @@ end| reset master; insert into t2 values (bug27417(1)); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. insert into t2 select bug27417(2); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. reset master; insert into t2 values (bug27417(2)); ERROR 23000: Duplicate entry '2' for key 'PRIMARY' @@ -796,7 +796,7 @@ count(*) 2 delete from t2 where a=bug27417(3); Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. select count(*) from t2 /* nothing got deleted */; count(*) 2 @@ -812,7 +812,7 @@ count(*) delete t2 from t2 where t2.a=bug27417(100) /* must not affect t2 */; affected rows: 0 Warnings: -Note 1592 Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Statement invokes a trigger or a stored function that inserts into AUTO_INCREMENT column which is unsafe to binlog in STATEMENT format because slave may execute it non-deterministically. +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. select count(*) from t1 /* must be 7 */; count(*) 7 |