Debian Codegraph @

mysql-test/suite/binlog/r/binlog_incident.result

raw
1 RESET MASTER;
2 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
3 call mtr.add_suppression("Replica SQL for channel '': The incident LOST_EVENTS occurred on the source.");
4 call mtr.add_suppression("Non-transactional changes were not written to the binlog. An incident event has been written to the binary log which will stop the replicas.");
5 SET GLOBAL max_binlog_stmt_cache_size = 4096;
6 Warnings:
7 Warning 1745 Option binlog_stmt_cache_size (32768) is greater than max_binlog_stmt_cache_size (4096); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size.
8 SET GLOBAL binlog_stmt_cache_size = 4096;
9 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000)) ENGINE=MyIsam;
10 #
11 # A single statement on non-transactional table causes to log an incident
12 # event with an unique gtid due to the stmt_cache is not big enough to
13 # accommodate the changes.
14 #
15 Got one of the listed errors
16 include/show_binlog_events.inc
17 Log_name Pos Event_type Server_id End_log_pos Info
18 binlog.000001 # Query # # use `test`; CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000)) ENGINE=MyIsam
19 binlog.000001 # Incident # # #1 (LOST_EVENTS)
20 binlog.000001 # Rotate # # binlog.000002;pos=POS
21 DROP TABLE t1;
22 Contain RELOAD DATABASE
23 1
24 SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE;
25 SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE;