|
--source include/have_binlog_format_row.inc
|
--source include/master-slave.inc
|
|
SET autocommit=0;
|
|
CREATE TABLE t1 (c1 INT);
|
|
--error ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN
|
CALL sys.statement_performance_analyzer('OVERALL', NULL, 'with_full_table_scans');
|
|
DROP TABLES t1;
|
CREATE TABLE t1 (c1 VARCHAR(64), PRIMARY KEY(c1)) ENGINE=MyISAM;
|
INSERT DELAYED t1 VALUES (1);
|
|
--sync_slave_with_master
|
--source include/rpl_end.inc
|
Leads to:
|
11.4.0 8bf9f21855606ddeb0fe90fb1e70165adbec6746 (Debug)
|
2024-02-03 13:30:37 6 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16000',replication starts at GTID position ''
|
2024-02-03 13:30:37 7 [ERROR] Slave SQL: Column 0 of table 'test.t1' cannot be converted from type 'varchar(64 octets)' to type 'int(11)', Gtid 0-1-2, Internal MariaDB error code: 1677
|
2024-02-03 13:30:37 7 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 485; GTID position '0-1-1'
|
2024-02-03 13:30:37 7 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000001' at position 485; GTID position '0-1-1', master: 127.0.0.1:16000
|
|