| 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; |