worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
include/master-slave.inc
|
[connection master]
|
connection master;
|
CREATE TABLE t (c VARCHAR(1) CHARACTER SET utf32 COLLATE utf32_turkish_ci) ENGINE=MyISAM;
|
CALL sys.statement_performance_analyzer (1,1,1);
|
summary
|
Disabled 1 thread
|
ERROR 45000: The snapshot action requires in_table to be NULL, NOW() or specify an existing table. The table `sys`.`1` does not exist.
|
DROP TABLE t;
|
CREATE TABLE t (c INT) ENGINE=MyISAM;
|
SET sql_log_bin=1;
|
INSERT INTO t VALUES (1);
|
DROP TABLE t;
|
include/rpl_end.inc
|
main.test 'row' [ fail ]
|
Test ended at 2023-09-27 14:58:50
|
|
CURRENT_TEST: main.test
|
analyze: sync_with_master
|
mysqltest: In included file "./include/rpl_sync.inc":
|
included from ./include/rpl_end.inc at line 80:
|
included from /test/BASE_MD260923-mariadb-10.6.16-linux-x86_64-opt/mysql-test/main/test.test at line 14:
|
At line 157: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 937, 300, '')' returned NULL indicating slave SQL thread failure
|
|
|
== /test/BASE_MD260923-mariadb-10.6.16-linux-x86_64-opt/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err ==
|
|
############################## default ##############################
|
|
**** SHOW WARNINGS on default ****
|
SHOW WARNINGS;
|
Level Code Message
|
|
**** SELECT replication-related variables on default ****
|
SELECT NOW(), @@SERVER_ID;
|
NOW() @@SERVER_ID
|
2023-09-27 14:58:49 1
|
|
**** SHOW SLAVE STATUS on default ****
|
SHOW SLAVE STATUS;
|
|
**** SHOW MASTER STATUS on default ****
|
SHOW MASTER STATUS;
|
File master-bin.000001
|
Position 937
|
Binlog_Do_DB
|
Binlog_Ignore_DB
|
|
**** SHOW SLAVE HOSTS on default ****
|
SHOW SLAVE HOSTS;
|
Server_id 2
|
Host 127.0.0.1
|
Port 16001
|
Master_id 1
|
|
**** SHOW PROCESSLIST on default ****
|
SHOW PROCESSLIST;
|
Id User Host db Command Time State Info Progress
|
7 root localhost:17356 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 0.000
|
10 root localhost NULL Query 0 starting SHOW PROCESSLIST 0.000
|
|
**** SHOW BINARY LOGS on default ****
|
SHOW BINARY LOGS;
|
Log_name File_size
|
master-bin.000001 937
|
|
**** SHOW BINLOG EVENTS on default ****
|
binlog_name = 'master-bin.000001'
|
SHOW BINLOG EVENTS IN 'master-bin.000001';
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 4 Format_desc 1 256 Server ver: 10.6.16-MariaDB-log, Binlog ver: 4
|
master-bin.000001 256 Gtid_list 1 285 []
|
master-bin.000001 285 Binlog_checkpoint 1 329 master-bin.000001
|
master-bin.000001 329 Gtid 1 371 GTID 0-1-1
|
master-bin.000001 371 Query 1 535 use `test`; CREATE TABLE t (c VARCHAR(1) CHARACTER SET utf32 COLLATE utf32_turkish_ci) ENGINE=MyISAM
|
master-bin.000001 535 Gtid 1 577 BEGIN GTID 0-1-2
|
master-bin.000001 577 Annotate_rows 1 624 INSERT INTO t VALUES (1)
|
master-bin.000001 624 Table_map 1 668 table_id: 38 (test.t)
|
master-bin.000001 668 Write_rows_v1 1 706 table_id: 38 flags: STMT_END_F
|
master-bin.000001 706 Query 1 779 COMMIT
|
master-bin.000001 779 Gtid 1 821 GTID 0-1-3
|
master-bin.000001 821 Query 1 937 use `test`; DROP TABLE `t` /* generated by server */
|
|
**** SHOW RELAYLOG EVENTS on default ****
|
relaylog_name = 'No such row'
|
SHOW RELAYLOG EVENTS IN 'No such row';
|
Log_name Pos Event_type Server_id End_log_pos Info
|
connection default;
|
|
== /test/BASE_MD260923-mariadb-10.6.16-linux-x86_64-opt/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err ==
|
|
############################## default ##############################
|
|
**** SHOW WARNINGS on default ****
|
SHOW WARNINGS;
|
Level Code Message
|
|
**** SELECT replication-related variables on default ****
|
SELECT NOW(), @@SERVER_ID;
|
NOW() @@SERVER_ID
|
2023-09-27 14:58:49 2
|
|
**** SHOW SLAVE STATUS on default ****
|
SHOW SLAVE STATUS;
|
Slave_IO_State Waiting for master to send event
|
Master_Host 127.0.0.1
|
Master_User root
|
Master_Port 16000
|
Connect_Retry 1
|
Master_Log_File master-bin.000001
|
Read_Master_Log_Pos 937
|
Relay_Log_File slave-relay-bin.000002
|
Relay_Log_Pos 835
|
Relay_Master_Log_File master-bin.000001
|
Slave_IO_Running Yes
|
Slave_SQL_Running No
|
Replicate_Do_DB
|
Replicate_Ignore_DB
|
Replicate_Do_Table
|
Replicate_Ignore_Table
|
Replicate_Wild_Do_Table
|
Replicate_Wild_Ignore_Table
|
Last_Errno 1677
|
Last_Error Column 0 of table 'test.t' cannot be converted from type 'int' to type ''
|
Skip_Counter 0
|
Exec_Master_Log_Pos 535
|
Relay_Log_Space 1546
|
Until_Condition None
|
Until_Log_File
|
Until_Log_Pos 0
|
Master_SSL_Allowed No
|
Master_SSL_CA_File
|
Master_SSL_CA_Path
|
Master_SSL_Cert
|
Master_SSL_Cipher
|
Master_SSL_Key
|
Seconds_Behind_Master NULL
|
Master_SSL_Verify_Server_Cert No
|
Last_IO_Errno 0
|
Last_IO_Error
|
Last_SQL_Errno 1677
|
Last_SQL_Error Column 0 of table 'test.t' cannot be converted from type 'int' to type ''
|
Replicate_Ignore_Server_Ids
|
Master_Server_Id 1
|
Master_SSL_Crl
|
Master_SSL_Crlpath
|
Using_Gtid No
|
Gtid_IO_Pos
|
Replicate_Do_Domain_Ids
|
Replicate_Ignore_Domain_Ids
|
Parallel_Mode optimistic
|
SQL_Delay 0
|
SQL_Remaining_Delay NULL
|
Slave_SQL_Running_State
|
Slave_DDL_Groups 1
|
Slave_Non_Transactional_Groups 1
|
Slave_Transactional_Groups 0
|
|
**** SHOW MASTER STATUS on default ****
|
SHOW MASTER STATUS;
|
File slave-bin.000001
|
Position 534
|
Binlog_Do_DB
|
Binlog_Ignore_DB
|
|
**** SHOW SLAVE HOSTS on default ****
|
SHOW SLAVE HOSTS;
|
|
**** SHOW PROCESSLIST on default ****
|
SHOW PROCESSLIST;
|
Id User Host db Command Time State Info Progress
|
6 system user NULL Slave_IO 0 Waiting for master to send event NULL 0.000
|
10 root localhost NULL Query 0 starting SHOW PROCESSLIST 0.000
|
|
**** SHOW BINARY LOGS on default ****
|
SHOW BINARY LOGS;
|
Log_name File_size
|
slave-bin.000001 534
|
|
**** SHOW BINLOG EVENTS on default ****
|
binlog_name = 'slave-bin.000001'
|
SHOW BINLOG EVENTS IN 'slave-bin.000001';
|
Log_name Pos Event_type Server_id End_log_pos Info
|
slave-bin.000001 4 Format_desc 2 256 Server ver: 10.6.16-MariaDB-log, Binlog ver: 4
|
slave-bin.000001 256 Gtid_list 2 285 []
|
slave-bin.000001 285 Binlog_checkpoint 2 328 slave-bin.000001
|
slave-bin.000001 328 Gtid 1 370 GTID 0-1-1
|
slave-bin.000001 370 Query 1 534 use `test`; CREATE TABLE t (c VARCHAR(1) CHARACTER SET utf32 COLLATE utf32_turkish_ci) ENGINE=MyISAM
|
|
**** SHOW RELAYLOG EVENTS on default ****
|
relaylog_name = 'slave-relay-bin.000002'
|
SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000002';
|
Log_name Pos Event_type Server_id End_log_pos Info
|
slave-relay-bin.000002 4 Format_desc 2 256 Server ver: 10.6.16-MariaDB-log, Binlog ver: 4
|
slave-relay-bin.000002 256 Rotate 1 0 master-bin.000001;pos=4
|
slave-relay-bin.000002 304 Format_desc 1 256 Server ver: 10.6.16-MariaDB-log, Binlog ver: 4
|
slave-relay-bin.000002 556 Gtid_list 1 285 []
|
slave-relay-bin.000002 585 Binlog_checkpoint 1 329 master-bin.000001
|
slave-relay-bin.000002 629 Gtid 1 371 GTID 0-1-1
|
slave-relay-bin.000002 671 Query 1 535 use `test`; CREATE TABLE t (c VARCHAR(1) CHARACTER SET utf32 COLLATE utf32_turkish_ci) ENGINE=MyISAM
|
slave-relay-bin.000002 835 Gtid 1 577 BEGIN GTID 0-1-2
|
slave-relay-bin.000002 877 Annotate_rows 1 624 INSERT INTO t VALUES (1)
|
slave-relay-bin.000002 924 Table_map 1 668 table_id: 38 (test.t)
|
slave-relay-bin.000002 968 Write_rows_v1 1 706 table_id: 38 flags: STMT_END_F
|
slave-relay-bin.000002 1006 Query 1 779 COMMIT
|
slave-relay-bin.000002 1079 Gtid 1 821 GTID 0-1-3
|
slave-relay-bin.000002 1121 Query 1 937 use `test`; DROP TABLE `t` /* generated by server */
|
connection default;
|
|
|
|
- saving '/test/BASE_MD260923-mariadb-10.6.16-linux-x86_64-opt/mysql-test/var/log/main.test-row/' to '/test/BASE_MD260923-mariadb-10.6.16-linux-x86_64-opt/mysql-test/var/log/main.test-row/'
|
--------------------------------------------------------------------------
|