Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 11.0(EOL), 11.3(EOL)
-
None
Description
--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
|
Attachments
Issue Links
- relates to
-
MDEV-33376 RBR aborts with ER_NO_SUCH_TABLE, Internal MariaDB error code: 1146 upon INSERT DELAYED inside trx
- Open