|
# Requires standard m/s setup, use CLI on master to replay the SQL
|
RESET MASTER;
|
SET GLOBAL init_connect="foo";
|
CREATE TABLE t1 (c1 INT, c2 BINARY (25) NOT NULL, c3 SMALLINT(4) NULL, c4 BINARY (15) NOT NULL PRIMARY KEY, c5 SMALLINT NOT NULL UNIQUE KEY,c6 DEC(10,8) NOT NULL DEFAULT 3.141592) ENGINE=MyISAM;
|
CREATE TABLE t2 (a INT, b SMALLINT NOT NULL, c CHAR(12) NOT NULL, d VARCHAR(64) NOT NULL, e VARCHAR(89), f VARCHAR(5), g LONGBLOB NOT NULL, h BLOB, id BIGINT NOT NULL, KEY(b), KEY(e), PRIMARY KEY(id)) ENGINE=MyISAM;
|
Leads to (various examples, see end-of-line error codes):
|
11.3.2 63fb478f88e0061d149f5cdd3c4d21d4a35c7bd9 (Debug, Slave)
|
2024-02-02 11:37:36 5 [ERROR] Slave I/O: error reconnecting to master 'repl_user@127.0.0.1:11699' - retry-time: 60 maximum-retries: 100000 message: , Internal MariaDB error code: 0
|
|
10.4.33 1b747ffd05dd524f8d43b35a2b583dc4c00d767b (Optimized, Slave)
|
2024-02-02 11:37:36 10 [ERROR] Slave I/O: error reconnecting to master 'repl_user@127.0.0.1:10826' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused"), Internal MariaDB error code: 2003
|
|
10.6.17 9f40f02a8dda7f2becdc6e752557559e7835546d (Optimized)
|
2024-02-02 11:36:00 5 [ERROR] Slave I/O: error connecting to master 'repl_user@127.0.0.1:12014' - retry-time: 60 maximum-retries: 100000 message: Access denied for user 'repl_user'@'localhost' (using password: YES), Internal MariaDB error code: 1045
|
This significantly complicates replication testing automation.
|