-- SET SQL_MODE=''; at tge begining of rpl_bug38174.test to avoid strict mode error in 5.7+ -- 5.7.23 ./mtr rpl_bug38174 Logging: ./mtr rpl_bug38174 MySQL Version 5.7.23 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] SET BINLOG_FORMAT = 'STATEMENT'; SET SQL_MODE=''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. drop table if exists t1; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ); INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y'); SELECT * FROM t1 ORDER BY RAND () LIMIT 8 INTO OUTFILE "/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-1.test"; LOAD DATA INFILE "/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-1.test" REPLACE INTO TABLE t1; SELECT * FROM t1 ORDER BY RAND () LIMIT 4 INTO OUTFILE "/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-2.test"; LOAD DATA INFILE "/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-2.test" REPLACE INTO TABLE t1; main.rpl_bug38174 [ fail ] Test ended at 2018-08-23 08:09:17 CURRENT_TEST: main.rpl_bug38174 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 2364 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 6630 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4461 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 1290 Last_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-10d5590e-a69b-11e8-8d5b-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Skip_Counter 0 Exec_Master_Log_Pos 4246 Relay_Log_Space 7052 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 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1290 Last_SQL_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-10d5590e-a69b-11e8-8d5b-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 10ca5674-a69b-11e8-8d7d-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 180823 09:09:16 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name Master_TLS_Version ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 3 User root Host localhost:51126 db test Command Sleep Time 0 State Info ---- 2. ---- Id 4 User root Host localhost:51127 db test Command Sleep Time 0 State Info ---- 3. ---- Id 5 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 7 User root Host localhost:51133 db test Command Query Time 0 State starting Info SHOW PROCESSLIST ---- 5. ---- Id 8 User root Host localhost:51134 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 68: sync_with_master failed: 'select master_pos_wait('master-bin.000001', 6630, 300)' returned NULL indicating slave SQL thread failure safe_process[4268]: Child process: 4269, exit: 1 == /export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2018-08-23 09:09:16 @@SERVER_ID 1 @@SERVER_UUID 10ca5674-a69b-11e8-8d7d-0010e05f3e06 @@PORT 13000 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED Warnings: Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; **** replication_applier_status on default **** SELECT * FROM performance_schema.replication_applier_status; **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 6630 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 Slave_UUID 10d5590e-a69b-11e8-8d5b-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 6 root localhost:56228 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 9 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4213 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4216 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4217 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4218 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4219 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4220 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4221 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4222 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4223 11 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4225 12 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4226 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4227 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4228 15 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4230 16 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4231 17 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4229 18 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4232 19 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4241 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4242 21 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4249 22 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 4253 27 thread/sql/one_connection FOREGROUND 6 root localhost NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 1 NULL YES YES TCP/IP 4275 30 thread/sql/one_connection FOREGROUND 9 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket 4277 **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 6630 **** 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 123 Server ver: 5.7.23-log, Binlog ver: 4 master-bin.000001 123 Previous_gtids 1 154 master-bin.000001 154 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 219 Query 1 344 use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ master-bin.000001 344 Anonymous_Gtid 1 409 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 409 Query 1 1024 use `test`; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) master-bin.000001 1024 Anonymous_Gtid 1 1089 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1089 Query 1 1168 BEGIN master-bin.000001 1168 Query 1 4215 use `test`; INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y') master-bin.000001 4215 Xid 1 4246 COMMIT /* xid=181 */ master-bin.000001 4246 Anonymous_Gtid 1 4311 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 4311 Query 1 4390 BEGIN master-bin.000001 4390 Begin_load_query 1 5140 ;file_id=1;block_len=723 master-bin.000001 5140 Execute_load_query 1 5587 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-1.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=1 master-bin.000001 5587 Xid 1 5618 COMMIT /* xid=183 */ master-bin.000001 5618 Anonymous_Gtid 1 5683 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 5683 Query 1 5762 BEGIN master-bin.000001 5762 Begin_load_query 1 6152 ;file_id=2;block_len=363 master-bin.000001 6152 Execute_load_query 1 6599 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-2.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=2 master-bin.000001 6599 Xid 1 6630 COMMIT /* xid=185 */ **** 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 **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position Channel_name Tls_version **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; == /export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2018-08-23 09:09:16 @@SERVER_ID 2 @@SERVER_UUID 10d5590e-a69b-11e8-8d5b-0010e05f3e06 @@PORT 13001 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED Warnings: Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. **** 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 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 6630 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4461 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 1290 Last_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-10d5590e-a69b-11e8-8d5b-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Skip_Counter 0 Exec_Master_Log_Pos 4246 Relay_Log_Space 7052 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 1290 Last_SQL_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-10d5590e-a69b-11e8-8d5b-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 10ca5674-a69b-11e8-8d7d-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 180823 09:09:16 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name Master_TLS_Version **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID 10ca5674-a69b-11e8-8d7d-0010e05f3e06 THREAD_ID 26 SERVICE_STATE ON COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00 **** replication_applier_status on default **** SELECT * FROM performance_schema.replication_applier_status; CHANNEL_NAME SERVICE_STATE OFF REMAINING_DELAY NULL COUNT_TRANSACTIONS_RETRIES 0 **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; CHANNEL_NAME WORKER_ID 0 THREAD_ID NULL SERVICE_STATE OFF LAST_SEEN_TRANSACTION ANONYMOUS LAST_ERROR_NUMBER 1290 LAST_ERROR_MESSAGE Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-10d5590e-a69b-11e8-8d5b-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' LAST_ERROR_TIMESTAMP 2018-08-23 09:09:16 **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 2364 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 system user NULL Connect 0 Waiting for master to send event NULL 9 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4215 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4233 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4234 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4235 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4236 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4237 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4238 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4239 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4240 11 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4246 12 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4248 13 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4247 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4250 15 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4252 16 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4254 17 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4255 18 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4251 19 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4256 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4257 21 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4260 22 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 4261 26 thread/sql/slave_io FOREGROUND 5 root localhost NULL Connect 0 Waiting for master to send event NULL 24 NULL YES YES NULL 4273 30 thread/sql/one_connection FOREGROUND 9 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket 4279 **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 2364 **** 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 123 Server ver: 5.7.23-log, Binlog ver: 4 slave-bin.000001 123 Previous_gtids 2 154 slave-bin.000001 154 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 219 Query 1 344 use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ slave-bin.000001 344 Anonymous_Gtid 1 409 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 409 Query 1 1024 use `test`; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) slave-bin.000001 1024 Anonymous_Gtid 1 1089 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 1089 Query 1 1161 BEGIN slave-bin.000001 1161 Table_map 1 1225 table_id: 222 (test.t1) slave-bin.000001 1225 Write_rows 1 2333 table_id: 222 flags: STMT_END_F slave-bin.000001 2333 Xid 1 2364 COMMIT /* xid=205 */ **** 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 123 Server ver: 5.7.23-log, Binlog ver: 4 slave-relay-bin.000002 123 Previous_gtids 2 154 slave-relay-bin.000002 154 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 202 Format_desc 1 123 Server ver: 5.7.23-log, Binlog ver: 4 slave-relay-bin.000002 321 Rotate 0 369 master-bin.000001;pos=154 slave-relay-bin.000002 369 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 434 Query 1 344 use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ slave-relay-bin.000002 559 Anonymous_Gtid 1 409 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 624 Query 1 1024 use `test`; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) slave-relay-bin.000002 1239 Anonymous_Gtid 1 1089 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1304 Query 1 1168 BEGIN slave-relay-bin.000002 1383 Query 1 4215 use `test`; INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y') slave-relay-bin.000002 4430 Xid 1 4246 COMMIT /* xid=181 */ slave-relay-bin.000002 4461 Anonymous_Gtid 1 4311 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 4526 Query 1 4390 BEGIN slave-relay-bin.000002 4605 Begin_load_query 1 5140 ;file_id=1;block_len=723 slave-relay-bin.000002 5355 Execute_load_query 1 5587 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-1.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=1 slave-relay-bin.000002 5802 Xid 1 5618 COMMIT /* xid=183 */ slave-relay-bin.000002 5833 Anonymous_Gtid 1 5683 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 5898 Query 1 5762 BEGIN slave-relay-bin.000002 5977 Begin_load_query 1 6152 ;file_id=2;block_len=363 slave-relay-bin.000002 6367 Execute_load_query 1 6599 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/tmp/bug38174-2.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=2 slave-relay-bin.000002 6814 Xid 1 6630 COMMIT /* xid=185 */ **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position Channel_name Tls_version **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test/var/log/main.rpl_bug38174/rpl_bug38174.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 4 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug38174 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases -- 8.0.12 ./mtr rpl_bug38174 Logging: ./mtr rpl_bug38174 MySQL Version 8.0.12 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.rpl_bug38174 [ fail ] Test ended at 2018-08-23 08:12:23 CURRENT_TEST: main.rpl_bug38174 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 2440 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 6708 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4512 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 1290 Last_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-7fb42b45-a69b-11e8-aeac-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Skip_Counter 0 Exec_Master_Log_Pos 4296 Relay_Log_Space 7132 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 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1290 Last_SQL_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-7fb42b45-a69b-11e8-aeac-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 7fa4d9ae-a69b-11e8-afe5-0010e05f3e06 Master_Info_File mysql.slave_master_info SQL_Delay 0 SQL_Remaining_Delay Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 180823 09:12:23 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name Master_TLS_Version Master_public_key_path Get_master_public_key 0 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 4 User event_scheduler Host localhost db Command Daemon Time 1 State Waiting on empty queue Info ---- 2. ---- Id 8 User root Host localhost:51146 db test Command Sleep Time 0 State Info ---- 3. ---- Id 9 User root Host localhost:51147 db test Command Sleep Time 1 State Info ---- 4. ---- Id 10 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 5. ---- Id 12 User root Host localhost:51153 db test Command Query Time 0 State starting Info SHOW PROCESSLIST ---- 6. ---- Id 13 User root Host localhost:51154 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 68: sync_with_master failed: 'select master_pos_wait('master-bin.000001', 6708, 300)' returned NULL indicating slave SQL thread failure safe_process[4437]: Child process: 4438, exit: 1 == /export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2018-08-23 09:12:23 @@SERVER_ID 2 @@SERVER_UUID 7fb42b45-a69b-11e8-aeac-0010e05f3e06 @@PORT 13001 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_OWNED **** 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 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 6708 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 4512 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 1290 Last_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-7fb42b45-a69b-11e8-aeac-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Skip_Counter 0 Exec_Master_Log_Pos 4296 Relay_Log_Space 7132 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 1290 Last_SQL_Error Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-7fb42b45-a69b-11e8-aeac-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 7fa4d9ae-a69b-11e8-afe5-0010e05f3e06 Master_Info_File mysql.slave_master_info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 180823 09:12:23 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name Master_TLS_Version Master_public_key_path Get_master_public_key 0 **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID 7fa4d9ae-a69b-11e8-afe5-0010e05f3e06 THREAD_ID 40 SERVICE_STATE ON COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION ANONYMOUS LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 2018-08-23 09:12:23.192011 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 2018-08-23 09:12:23.192011 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP 2018-08-23 09:12:23.192234 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP 2018-08-23 09:12:23.192255 QUEUEING_TRANSACTION QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000 **** replication_applier_status on default **** SELECT * FROM performance_schema.replication_applier_status; CHANNEL_NAME SERVICE_STATE OFF REMAINING_DELAY NULL COUNT_TRANSACTIONS_RETRIES 0 **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; CHANNEL_NAME WORKER_ID 0 THREAD_ID NULL SERVICE_STATE OFF LAST_ERROR_NUMBER 1290 LAST_ERROR_MESSAGE Error 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement' on query. Default database: 'test'. Query: 'LOAD DATA INFILE '../../tmp/SQL_LOAD-7fb42b45-a69b-11e8-aeac-0010e05f3e06-1-1.data' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`)' LAST_ERROR_TIMESTAMP 2018-08-23 09:12:23.326534 LAST_APPLIED_TRANSACTION ANONYMOUS LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 2018-08-23 09:12:23.189200 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 2018-08-23 09:12:23.189200 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP 2018-08-23 09:12:23.198416 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP 2018-08-23 09:12:23.326170 APPLYING_TRANSACTION ANONYMOUS APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 2018-08-23 09:12:23.190754 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 2018-08-23 09:12:23.190754 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 2018-08-23 09:12:23.326179 **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 2440 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 4 event_scheduler localhost NULL Daemon 1 Waiting on empty queue NULL 10 system user NULL Connect 0 Waiting for master to send event NULL 14 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID RESOURCE_GROUP 1 thread/sql/main BACKGROUND NULL NULL NULL mysql NULL 1 NULL NULL NULL NULL YES YES NULL 4366 SYS_default 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4384 SYS_default 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4385 SYS_default 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4386 SYS_default 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4387 SYS_default 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4388 SYS_default 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4389 SYS_default 9 thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4390 SYS_default 10 thread/innodb/log_closer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4395 SYS_default 11 thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4394 SYS_default 12 thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4396 SYS_default 13 thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4397 SYS_default 14 thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4398 SYS_default 15 thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4399 SYS_default 16 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4400 SYS_default 17 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4401 SYS_default 18 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4402 SYS_default 19 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4410 SYS_default 20 thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4409 SYS_default 21 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4411 SYS_default 22 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4412 SYS_default 23 thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4413 SYS_default 26 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4424 SYS_default 27 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4425 SYS_default 28 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4426 SYS_default 29 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4427 SYS_default 30 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4425 SYS_default 31 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4427 SYS_default 32 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4426 SYS_default 33 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4424 SYS_default 34 thread/sql/event_scheduler FOREGROUND 4 NULL NULL NULL Sleep NULL Waiting on empty queue NULL 1 NULL YES YES NULL 4428 SYS_default 35 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4429 SYS_default 36 thread/sql/compress_gtid_table FOREGROUND 6 NULL NULL NULL Daemon 1 Suspending NULL 1 NULL YES YES NULL 4430 SYS_default 40 thread/sql/slave_io FOREGROUND 10 root localhost NULL Connect 0 Waiting for master to send event NULL 38 NULL YES YES NULL 4442 SYS_default 44 thread/sql/one_connection FOREGROUND 14 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket 4448 USR_default **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 2440 **** 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 124 Server ver: 8.0.12, Binlog ver: 4 slave-bin.000001 124 Previous_gtids 2 155 slave-bin.000001 155 Anonymous_Gtid 1 235 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 235 Query 1 363 use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ slave-bin.000001 363 Anonymous_Gtid 1 445 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 445 Query 1 1072 use `test`; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) /* xid=211 */ slave-bin.000001 1072 Anonymous_Gtid 1 1154 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 1154 Query 1 1229 BEGIN slave-bin.000001 1229 Table_map 1 1301 table_id: 125 (test.t1) slave-bin.000001 1301 Write_rows 1 2409 table_id: 125 flags: STMT_END_F slave-bin.000001 2409 Xid 1 2440 COMMIT /* xid=214 */ **** 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 124 Server ver: 8.0.12, Binlog ver: 4 slave-relay-bin.000002 124 Previous_gtids 2 155 slave-relay-bin.000002 155 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 203 Format_desc 1 124 Server ver: 8.0.12, Binlog ver: 4 slave-relay-bin.000002 323 Rotate 0 371 master-bin.000001;pos=155 slave-relay-bin.000002 371 Anonymous_Gtid 1 228 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 444 Query 1 356 use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ slave-relay-bin.000002 572 Anonymous_Gtid 1 431 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 647 Query 1 1058 use `test`; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) /* xid=197 */ slave-relay-bin.000002 1274 Anonymous_Gtid 1 1133 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1349 Query 1 1215 BEGIN slave-relay-bin.000002 1431 Query 1 4265 use `test`; INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y') slave-relay-bin.000002 4481 Xid 1 4296 COMMIT /* xid=198 */ slave-relay-bin.000002 4512 Anonymous_Gtid 1 4371 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 4587 Query 1 4453 BEGIN slave-relay-bin.000002 4669 Begin_load_query 1 5200 ;file_id=1;block_len=720 slave-relay-bin.000002 5416 Execute_load_query 1 5650 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-1.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=1 slave-relay-bin.000002 5866 Xid 1 5681 COMMIT /* xid=200 */ slave-relay-bin.000002 5897 Anonymous_Gtid 1 5756 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 5972 Query 1 5838 BEGIN slave-relay-bin.000002 6054 Begin_load_query 1 6227 ;file_id=2;block_len=362 slave-relay-bin.000002 6443 Execute_load_query 1 6677 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-2.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=2 slave-relay-bin.000002 6893 Xid 1 6708 COMMIT /* xid=202 */ **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name 7 ./slave-relay-bin.000002 4512 master-bin.000001 4296 0 0 1 **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position Channel_name Tls_version Public_key_path Get_public_key 27 master-bin.000001 155 127.0.0.1 root 13000 1 0 0 30 0 7fa4d9ae-a69b-11e8-afe5-0010e05f3e06 10 0 0 **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; == /export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2018-08-23 09:12:23 @@SERVER_ID 1 @@SERVER_UUID 7fa4d9ae-a69b-11e8-afe5-0010e05f3e06 @@PORT 13000 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; **** replication_applier_status on default **** SELECT * FROM performance_schema.replication_applier_status; **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 6708 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 Slave_UUID 7fb42b45-a69b-11e8-aeac-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 4 event_scheduler localhost NULL Daemon 1 Waiting on empty queue NULL 11 root localhost:56248 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 14 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID RESOURCE_GROUP 1 thread/sql/main BACKGROUND NULL NULL NULL mysql NULL 1 NULL NULL NULL NULL YES YES NULL 4364 SYS_default 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4369 SYS_default 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4370 SYS_default 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4372 SYS_default 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4371 SYS_default 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4373 SYS_default 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4374 SYS_default 9 thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4375 SYS_default 10 thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4377 SYS_default 11 thread/innodb/log_closer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4378 SYS_default 12 thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4379 SYS_default 13 thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4381 SYS_default 14 thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4380 SYS_default 15 thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4382 SYS_default 16 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4391 SYS_default 17 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4392 SYS_default 18 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4393 SYS_default 19 thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4403 SYS_default 20 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4404 SYS_default 21 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4405 SYS_default 22 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4406 SYS_default 23 thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4407 SYS_default 26 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4415 SYS_default 27 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4416 SYS_default 28 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4417 SYS_default 29 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4418 SYS_default 30 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4416 SYS_default 31 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4417 SYS_default 32 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4418 SYS_default 33 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4415 SYS_default 34 thread/sql/event_scheduler FOREGROUND 4 NULL NULL NULL Sleep NULL Waiting on empty queue NULL 1 NULL YES YES NULL 4420 SYS_default 35 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4421 SYS_default 36 thread/sql/compress_gtid_table FOREGROUND 6 NULL NULL NULL Daemon 1 Suspending NULL 1 NULL YES YES NULL 4422 SYS_default 41 thread/sql/one_connection FOREGROUND 11 root localhost NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 1 NULL YES YES TCP/IP 4444 USR_default 44 thread/sql/one_connection FOREGROUND 14 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket 4446 USR_default **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 6708 **** 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 124 Server ver: 8.0.12, Binlog ver: 4 master-bin.000001 124 Previous_gtids 1 155 master-bin.000001 155 Anonymous_Gtid 1 228 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 228 Query 1 356 use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ master-bin.000001 356 Anonymous_Gtid 1 431 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 431 Query 1 1058 use `test`; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) /* xid=197 */ master-bin.000001 1058 Anonymous_Gtid 1 1133 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1133 Query 1 1215 BEGIN master-bin.000001 1215 Query 1 4265 use `test`; INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y') master-bin.000001 4265 Xid 1 4296 COMMIT /* xid=198 */ master-bin.000001 4296 Anonymous_Gtid 1 4371 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 4371 Query 1 4453 BEGIN master-bin.000001 4453 Begin_load_query 1 5200 ;file_id=1;block_len=720 master-bin.000001 5200 Execute_load_query 1 5650 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-1.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=1 master-bin.000001 5650 Xid 1 5681 COMMIT /* xid=200 */ master-bin.000001 5681 Anonymous_Gtid 1 5756 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 5756 Query 1 5838 BEGIN master-bin.000001 5838 Begin_load_query 1 6227 ;file_id=2;block_len=362 master-bin.000001 6227 Execute_load_query 1 6677 use `test`; LOAD DATA INFILE '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-2.test' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`pk`, `int_nokey`, `int_key`, `date_key`, `date_nokey`, `time_key`, `time_nokey`, `datetime_key`, `datetime_nokey`, `varchar_key`, `varchar_nokey`) ;file_id=2 master-bin.000001 6677 Xid 1 6708 COMMIT /* xid=202 */ **** 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 **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position Channel_name Tls_version Public_key_path Get_public_key **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] SET BINLOG_FORMAT = 'STATEMENT'; SET SQL_MODE=''; drop table if exists t1; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ); INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y'); SELECT * FROM t1 ORDER BY RAND () LIMIT 8 INTO OUTFILE "/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-1.test"; LOAD DATA INFILE "/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-1.test" REPLACE INTO TABLE t1; SELECT * FROM t1 ORDER BY RAND () LIMIT 4 INTO OUTFILE "/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-2.test"; LOAD DATA INFILE "/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/tmp/bug38174-2.test" REPLACE INTO TABLE t1; ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test/var/log/main.rpl_bug38174/rpl_bug38174.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 6 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug38174 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases -- 5.6.41 ./mtr rpl_bug38174 Logging: ./mtr rpl_bug38174 2018-08-23 08:15:06 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-08-23 08:15:06 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.41/bin/mysqld (mysqld 5.6.41) starting as process 4800 ... 2018-08-23 08:15:06 4800 [Note] Plugin 'FEDERATED' is disabled. 2018-08-23 08:15:06 4800 [Note] Binlog end 2018-08-23 08:15:06 4800 [Note] Shutting down plugin 'MyISAM' 2018-08-23 08:15:06 4800 [Note] Shutting down plugin 'CSV' MySQL Version 5.6.41 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] SET BINLOG_FORMAT = 'STATEMENT'; SET SQL_MODE=''; drop table if exists t1; CREATE TABLE t1 ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ); INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'), (2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'), (3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'), (4,1,4,'2002-12-03','2002-12-03','20:34:58','20:34:58','2009-10-28 09:46:21','2009-10-28 09:46:21','g','g'), (5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'), (7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'), (8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'), (9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'), (10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'), (11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'), (12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'), (13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'), (14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''), (15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'), (16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'), (17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'), (18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''), (19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'), (20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'), (77,6,0,'2009-05-19','2009-05-19','14:56:44','14:56:44','2007-09-09 22:47:39','2007-09-09 22:47:39','',''), (35,6,3,'0000-00-00','0000-00-00','09:38:22','09:38:22','0000-00-00 00:00:00','0000-00-00 00:00:00','i','i'), (39,8,8,'0000-00-00','0000-00-00','10:25:31','10:25:31','2003-01-24 10:45:23','2003-01-24 10:45:23','',''), (29,5,6,'0000-00-00','0000-00-00','00:21:35','00:21:35','0000-00-00 00:00:00','0000-00-00 00:00:00','y','y'), (53,3,5,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-11-05 23:51:21','2007-11-05 23:51:21','p','p'), (60,0,2,'2009-09-11','2009-09-11','23:56:26','23:56:26','2003-12-24 04:28:32','2003-12-24 04:28:32','n','n'), (93,7,2,'2007-08-18','2007-08-18','00:00:00','00:00:00','2009-02-01 00:00:00','2009-02-01 00:00:00','y','y'); SELECT * FROM t1 ORDER BY RAND () LIMIT 8 INTO OUTFILE "/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/bug38174-1.test"; LOAD DATA INFILE "/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/bug38174-1.test" REPLACE INTO TABLE t1; SELECT * FROM t1 ORDER BY RAND () LIMIT 4 INTO OUTFILE "/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/bug38174-2.test"; LOAD DATA INFILE "/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/bug38174-2.test" REPLACE INTO TABLE t1; main.rpl_bug38174 [ pass ] 59 MTR's internal check of the test case 'main.rpl_bug38174' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/check-mysqld_1.result 2018-08-23 09:15:09.635037073 +0300 +++ /export/umesh/server/binaries/GABuilds/mysql-5.6.41/mysql-test/var/tmp/check-mysqld_1.reject 2018-08-23 09:15:09.861042255 +0300 @@ -517,6 +517,7 @@ def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +t1 tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.059 of 7 seconds executing testcases Check of testcase failed for: main.rpl_bug38174 Completed: All 1 tests were successful.