[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test: ./mtr --debug 1 Logging: ./mtr --debug 1 MySQL Version 5.7.20 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.20/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 CREATE TABLE `t` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `a` bigint(20) NOT NULL, `b` bigint(20) NOT NULL, `c` bigint(20) NOT NULL, `d` bigint(20) NOT NULL, `e` bigint(20) NOT NULL, PRIMARY KEY (`id`), KEY `k_cde` (`c`, `d`, `e`) ) ENGINE=InnoDB; INSERT INTO `t` (`a`, `b`, `c`, `d`, `e`) VALUES (0, 0, 0, 0, 0); CREATE UNIQUE INDEX `uk_a_b` ON `t` (`a`, `b`); SHOW CREATE TABLE t; Table Create Table t CREATE TABLE `t` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `a` bigint(20) NOT NULL, `b` bigint(20) NOT NULL, `c` bigint(20) NOT NULL, `d` bigint(20) NOT NULL, `e` bigint(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_a_b` (`a`,`b`), KEY `k_cde` (`c`,`d`,`e`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 FLUSH TABLES `t` FOR EXPORT; UNLOCK TABLES; DROP TABLE t; CREATE TABLE `t` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `a` bigint(20) NOT NULL, `b` bigint(20) NOT NULL, `c` bigint(20) NOT NULL, `d` bigint(20) NOT NULL, `e` bigint(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_a_b` (`a`,`b`), KEY `k_cde` (`c`,`d`,`e`) ) ENGINE=InnoDB; ALTER TABLE t DISCARD TABLESPACE; ALTER TABLE t IMPORT TABLESPACE; Warnings: Warning 1810 InnoDB: IO Read error: (2, No such file or directory) Error opening './test/t.cfg', will attempt to import without schema verification main.1 [ fail ] Test ended at 2017-11-09 11:05:10 CURRENT_TEST: main.1 mysqltest: [Warning] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqltest: Option 'debug=d:t:A,/export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test/var/log/mysqltest.trace' used, but is disabled mysqltest: At line 57: query 'SELECT * FROM t WHERE a = 0 and b = 0' failed: 2013: Lost connection to MySQL server during query safe_process[14474]: Child process: 14475, exit: 1 Server [mysqld.1 - pid: 14445, winpid: 14445, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-11-09T10:05:06.635503Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-11-09T10:05:06.638022Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2017-11-09T10:05:06.638055Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2017-11-09T10:05:06.638131Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug (mysqld 5.7.20-debug-log) starting as process 14446 ... 2017-11-09T10:05:06.654671Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-11-09T10:05:06.654709Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-11-09T10:05:06.654736Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-11-09T10:05:06.654756Z 0 [Note] InnoDB: Uses event mutexes 2017-11-09T10:05:06.654778Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2017-11-09T10:05:06.654797Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-11-09T10:05:06.654818Z 0 [Note] InnoDB: Using Linux native AIO 2017-11-09T10:05:06.655408Z 0 [Note] InnoDB: Number of pools: 1 2017-11-09T10:05:06.655601Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-11-09T10:05:06.657376Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M 2017-11-09T10:05:06.673318Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-11-09T10:05:06.674257Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-11-09T10:05:06.688242Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-11-09T10:05:06.742021Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-11-09T10:05:06.742153Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-11-09T10:05:07.019800Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-11-09T10:05:07.032224Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-11-09T10:05:07.032253Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-11-09T10:05:07.033727Z 0 [Note] InnoDB: Waiting for purge to start 2017-11-09T10:05:07.084114Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 1350944 2017-11-09T10:05:07.084404Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test/var/mysqld.1/data/ib_buffer_pool 2017-11-09T10:05:07.088850Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-11-09T10:05:07.093798Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171109 13:05:07 2017-11-09T10:05:07.098298Z 0 [Warning] unknown variable 'loose-mysqlx-port=13009' 2017-11-09T10:05:07.098321Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test/var/tmp/mysqlx.1.sock' 2017-11-09T10:05:07.098335Z 0 [Warning] unknown variable 'loose-sha256_password_auto_generate_rsa_keys=0' 2017-11-09T10:05:07.105360Z 0 [Note] Salting uuid generator variables, current_pid: 14446, server_start_time: 1510221906, bytes_sent: 0, 2017-11-09T10:05:07.105500Z 0 [Note] Generated uuid: '768e23b0-c535-11e7-ba88-0010e05f3e06', server_start_time: 4066187515072372928, bytes_sent: 62891392 2017-11-09T10:05:07.105910Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 768e23b0-c535-11e7-ba88-0010e05f3e06. 2017-11-09T10:05:07.112762Z 0 [Warning] CA certificate /export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test/std_data/cacert.pem is self signed. 2017-11-09T10:05:07.139549Z 0 [Note] Server hostname (bind-address): '*'; port: 13000 2017-11-09T10:05:07.139611Z 0 [Note] IPv6 is available. 2017-11-09T10:05:07.139635Z 0 [Note] - '::' resolves to '::'; 2017-11-09T10:05:07.139681Z 0 [Note] Server socket created on IP: '::'. 2017-11-09T10:05:07.354976Z 0 [Note] Event Scheduler: Loaded 0 events 2017-11-09T10:05:07.357081Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug: ready for connections. Version: '5.7.20-debug-log' socket: '/export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - Debug (GPL) 2017-11-09T10:05:07.357113Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2017-11-09T10:05:07.357128Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-11-09T10:05:07.649292Z 0 [Note] End of list of non-natively partitioned tables 2017-11-09T10:05:09.658743Z 4 [Note] InnoDB: Sync to disk of `test`.`t` started. 2017-11-09T10:05:09.658788Z 4 [Note] InnoDB: Stopping purge 2017-11-09T10:05:09.663757Z 4 [Note] InnoDB: Writing table metadata to './test/t.cfg' 2017-11-09T10:05:09.663927Z 4 [Note] InnoDB: Table `test`.`t` flushed to disk 2017-11-09T10:05:09.682320Z 4 [Note] InnoDB: Deleting the meta-data file './test/t.cfg' 2017-11-09T10:05:09.682368Z 4 [Note] InnoDB: Resuming purge 2017-11-09T10:05:09.753997Z 4 [Note] InnoDB: Sync to disk 2017-11-09T10:05:09.754370Z 4 [Note] InnoDB: Sync to disk - done! 2017-11-09T10:05:09.754473Z 4 [Note] InnoDB: Phase I - Update all pages 2017-11-09T10:05:09.755105Z 4 [Note] InnoDB: Sync to disk 2017-11-09T10:05:09.755391Z 4 [Note] InnoDB: Sync to disk - done! 2017-11-09T10:05:09.759251Z 4 [Note] InnoDB: Phase III - Flush changes to disk 2017-11-09T10:05:09.762887Z 4 [Note] InnoDB: Phase IV - Flush complete 2017-11-09T10:05:09.764766Z 4 [Note] InnoDB: `test`.`t` autoinc value set to 0 2017-11-09T10:05:09.783973Z 4 [Note] InnoDB: AUTOINC next value generation is disabled for '`test`.`t`' 2017-11-09T10:05:09.802049Z 4 [ERROR] InnoDB: Clustered record for sec rec not found index `uk_a_b` of table `test`.`t` InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 8000000000000000; asc ;; 1: len 8; hex 8000000000000000; asc ;; 2: len 8; hex 8000000000000000; asc ;; InnoDB: clust index record PHYSICAL RECORD: n_fields 8; compact format; info bits 0 0: len 8; hex 0000000000000001; asc ;; 1: len 6; hex 00000000051f; asc ;; 2: len 7; hex 00000000000000; asc ;; 3: len 8; hex 8000000000000000; asc ;; 4: len 8; hex 8000000000000000; asc ;; 5: len 8; hex 8000000000000000; asc ;; 6: len 8; hex 8000000000000000; asc ;; 7: len 8; hex 8000000000000000; asc ;; TRANSACTION 421999236155584, ACTIVE 0 sec starting index read mysql tables in use 1, locked 0 0 lock struct(s), heap size 1160, 0 row lock(s) MySQL thread id 4, OS thread handle 140524229494528, query id 40 localhost root statistics SELECT * FROM t WHERE a = 0 and b = 0 InnoDB: Submit a detailed bug report to http://bugs.mysql.com 2017-11-09 13:05:09 0x7fce58c80700 InnoDB: Assertion failure in thread 140524229494528 in file row0sel.cc line 3620 InnoDB: Failing assertion: 0 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 10:05:09 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61032 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fce0802c6d0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fce58c7fe30 thread_stack 0x40000 /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(my_print_stacktrace+0x35)[0x18d66ca] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(handle_fatal_signal+0x407)[0xed7c44] /lib64/libpthread.so.0(+0xf130)[0x7fce60ce2130] /lib64/libc.so.6(gsignal+0x37)[0x7fce5f6d95d7] /lib64/libc.so.6(abort+0x148)[0x7fce5f6dacc8] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug[0x1bee567] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug[0x1b46deb] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm+0x2c35)[0x1b4b8c0] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN11ha_innobase10index_readEPhPKhj16ha_rkey_function+0x44a)[0x19b897c] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN7handler14index_read_mapEPhPKhm16ha_rkey_function+0x6e)[0xf61a7c] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN7handler18index_read_idx_mapEPhjPKhm16ha_rkey_function+0x7b)[0xf5d82f] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN7handler21ha_index_read_idx_mapEPhjPKhm16ha_rkey_function+0x19b)[0xf53a4d] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug[0x154575c] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z21join_read_const_tableP8JOIN_TABP11st_position+0x20b)[0x154522b] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN4JOIN29extract_func_dependent_tablesEv+0x617)[0x1572857] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN4JOIN14make_join_planEv+0x2b1)[0x15711d9] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN4JOIN8optimizeEv+0xf93)[0x15657e3] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_ZN13st_select_lex8optimizeEP3THD+0x105)[0x15dfc71] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x2f2)[0x15de384] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug[0x1593533] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z21mysql_execute_commandP3THDb+0xe2c)[0x158c127] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z11mysql_parseP3THDP12Parser_state+0x540)[0x15943b9] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xd09)[0x1588d5e] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(_Z10do_commandP3THD+0x4b3)[0x1587b61] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(handle_connection+0x1e6)[0x16be3c0] /export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug(pfs_spawn_thread+0x170)[0x1910aa4] /lib64/libpthread.so.0(+0x7df5)[0x7fce60cdadf5] /lib64/libc.so.6(clone+0x6d)[0x7fce5f79a60d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fce0803d000): SELECT * FROM t WHERE a = 0 and b = 0 Connection ID (thread ID): 4 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file safe_process[14445]: Child process: 14446, killed by signal: 6 ----------SERVER LOG END------------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test/var/log/main.1/1.log' - found 'core.14446' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 14473] [New LWP 14446] [New LWP 14451] [New LWP 14452] [New LWP 14458] [New LWP 14457] [New LWP 14448] [New LWP 14449] [New LWP 14450] [New LWP 14453] [New LWP 14454] [New LWP 14456] [New LWP 14447] [New LWP 14464] [New LWP 14460] [New LWP 14461] [New LWP 14462] [New LWP 14459] [New LWP 14467] [New LWP 14471] [New LWP 14465] [New LWP 14463] [New LWP 14470] [New LWP 14466] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/umesh/server/binaries/GABuilds/mysql-5.7.20/bin/mysqld-debug --defaults'. Program terminated with signal 6, Aborted. #0 0x00007fce60cdf771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007fce60cdf771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018d6751 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/mysys/stacktrace.c:249 #2 0x0000000000ed7e3a in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/signal_handler.cc:220 #3 #4 0x00007fce5f6d95d7 in raise () from /lib64/libc.so.6 #5 0x00007fce5f6dacc8 in abort () from /lib64/libc.so.6 #6 0x0000000001bee567 in ut_dbg_assertion_failed (expr=0x232d53c "0", file=0x232e3f0 "/export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/row/row0sel.cc", line=3620) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000001b46deb in row_sel_get_clust_rec_for_mysql (prebuilt=0x7fce08014ea0, sec_index=0x7fce080da970, rec=0x7fce5946807d "\200", thr=0x7fce08015700, out_rec=0x7fce58c7cc60, offsets=0x7fce58c7cc38, offset_heap=0x7fce58c7cc40, vrow=0x0, mtr=0x7fce58c7c3b0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/row/row0sel.cc:3620 #8 0x0000000001b4b8c0 in row_search_mvcc (buf=0x7fce080db160 '\217' , "\220", , mode=PAGE_CUR_GE, prebuilt=0x7fce08014ea0, match_mode=1, direction=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/row/row0sel.cc:5763 #9 0x00000000019b897c in ha_innobase::index_read (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , key_ptr=0x7fce08ea2c00 "", key_len=16, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/handler/ha_innodb.cc:8696 #10 0x0000000000f61a7c in handler::index_read_map (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , key=0x7fce08ea2c00 "", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/handler.h:2783 #11 0x0000000000f5d82f in handler::index_read_idx_map (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , index=1, key=0x7fce08ea2c00 "", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/handler.cc:7504 #12 0x0000000000f53a4d in handler::ha_index_read_idx_map (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , index=1, key=0x7fce08ea2c00 "", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/handler.cc:3083 #13 0x000000000154575c in read_const (table=0x7fce080fc410, ref=0x7fce08ea2070) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_executor.cc:2007 #14 0x000000000154522b in join_read_const_table (tab=0x7fce08ea1fa0, pos=0x7fce08ea2138) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_executor.cc:1892 #15 0x0000000001572857 in JOIN::extract_func_dependent_tables (this=0x7fce08ea17b8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_optimizer.cc:5579 #16 0x00000000015711d9 in JOIN::make_join_plan (this=0x7fce08ea17b8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_optimizer.cc:5043 #17 0x00000000015657e3 in JOIN::optimize (this=0x7fce08ea17b8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_optimizer.cc:368 #18 0x00000000015dfc71 in st_select_lex::optimize (this=0x7fce0803d050, thd=0x7fce0802c6d0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_select.cc:1009 #19 0x00000000015de384 in handle_query (thd=0x7fce0802c6d0, lex=0x7fce0802e850, result=0x7fce0803ee60, added_options=0, removed_options=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_select.cc:164 #20 0x0000000001593533 in execute_sqlcom_select (thd=0x7fce0802c6d0, all_tables=0x7fce0803e298) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:5159 #21 0x000000000158c127 in mysql_execute_command (thd=0x7fce0802c6d0, first_level=true) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:2796 #22 0x00000000015943b9 in mysql_parse (thd=0x7fce0802c6d0, parser_state=0x7fce58c7f690) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:5577 #23 0x0000000001588d5e in dispatch_command (thd=0x7fce0802c6d0, com_data=0x7fce58c7fe00, command=COM_QUERY) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:1461 #24 0x0000000001587b61 in do_command (thd=0x7fce0802c6d0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:999 #25 0x00000000016be3c0 in handle_connection (arg=0x3fa18b0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/conn_handler/connection_handler_per_thread.cc:300 #26 0x0000000001910aa4 in pfs_spawn_thread (arg=0x3f45f50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/perfschema/pfs.cc:2190 #27 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #28 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fce417fb700 (LWP 14466)): #0 0x00007fce60cdeab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a8538e in os_event::timed_wait (this=0x3be73d8, abstime=0x7fce417fac80) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:285 #2 0x0000000001a856d2 in os_event::wait_time_low (this=0x3be73d8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:412 #3 0x0000000001a8590a in os_event_wait_time_low (event=0x3be73d8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:517 #4 0x0000000001bf3a3f in ib_wqueue_timedwait (wq=0x3be7218, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/ut/ut0wqueue.cc:160 #5 0x0000000001d26378 in fts_optimize_thread (arg=0x3be7218) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fts/fts0opt.cc:3031 #6 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fce58cc1700 (LWP 14470)): #0 0x00007fce60ce1ec1 in sigwait () from /lib64/libpthread.so.0 #1 0x0000000000ec3199 in signal_hand (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/mysqld.cc:2101 #2 0x0000000001910aa4 in pfs_spawn_thread (arg=0x3f50f40) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/perfschema/pfs.cc:2190 #3 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fce435fe700 (LWP 14463)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a85b63 in os_event::wait (this=0x36a1dd8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:165 #2 0x0000000001a85505 in os_event::wait_low (this=0x36a1dd8, reset_sig_count=20) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:335 #3 0x0000000001a8592f in os_event_wait_low (event=0x36a1dd8, reset_sig_count=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:534 #4 0x0000000001b82a66 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2520 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fce421fc700 (LWP 14465)): #0 0x00007fce60cdeab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a8538e in os_event::timed_wait (this=0x3b988f8, abstime=0x7fce421fbe90) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:285 #2 0x0000000001a856d2 in os_event::wait_time_low (this=0x3b988f8, time_in_usec=10000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:412 #3 0x0000000001a8590a in os_event_wait_time_low (event=0x3b988f8, time_in_usec=10000000, reset_sig_count=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:517 #4 0x0000000001cca0fd in dict_stats_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/dict/dict0stats_bg.cc:428 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fce3bfff700 (LWP 14471)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000017f7980 in native_cond_wait (cond=0x2db9340 , mutex=0x2db9300 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/include/thr_cond.h:140 #2 0x00000000017f79bf in my_cond_wait (cond=0x2db9340 , mp=0x2db9300 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/include/thr_cond.h:195 #3 0x00000000017f7caf in inline_mysql_cond_wait (that=0x2db9340 , mutex=0x2db9300 , src_file=0x2257970 "/export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/rpl_gtid_persist.cc", src_line=874) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/include/mysql/psi/mysql_thread.h:1184 #4 0x00000000017fa72b in compress_gtid_table (p_thd=0x3fcad10) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/rpl_gtid_persist.cc:874 #5 0x0000000001910aa4 in pfs_spawn_thread (arg=0x3f45f50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/perfschema/pfs.cc:2190 #6 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fce40dfa700 (LWP 14467)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a85b63 in os_event::wait (this=0x36a2198) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:165 #2 0x0000000001a85505 in os_event::wait_low (this=0x36a2198, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:335 #3 0x0000000001a8592f in os_event_wait_low (event=0x36a2198, reset_sig_count=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:534 #4 0x0000000001c4f9ce in buf_resize_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/buf/buf0buf.cc:3016 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fce4a1fc700 (LWP 14459)): #0 0x00007fce60ce199d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000001a860b2 in os_thread_sleep (tm=1000000) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0thread.cc:279 #2 0x0000000001b82417 in srv_master_sleep () at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2330 #3 0x0000000001b82585 in srv_master_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2377 #4 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fce43fff700 (LWP 14462)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a85b63 in os_event::wait (this=0x36a1e78) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:165 #2 0x0000000001a85505 in os_event::wait_low (this=0x36a1e78, reset_sig_count=11) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:335 #3 0x0000000001a8592f in os_event_wait_low (event=0x36a1e78, reset_sig_count=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:534 #4 0x0000000001b82a66 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2520 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fce48dfa700 (LWP 14461)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a85b63 in os_event::wait (this=0x36a1d38) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:165 #2 0x0000000001a85505 in os_event::wait_low (this=0x36a1d38, reset_sig_count=20) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:335 #3 0x0000000001a8592f in os_event_wait_low (event=0x36a1d38, reset_sig_count=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:534 #4 0x0000000001b82a66 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2520 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fce497fb700 (LWP 14460)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a85b63 in os_event::wait (this=0x36a1c98) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:165 #2 0x0000000001a85505 in os_event::wait_low (this=0x36a1c98, reset_sig_count=9) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:335 #3 0x0000000001a8592f in os_event_wait_low (event=0x36a1c98, reset_sig_count=9) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:534 #4 0x0000000001b82f3a in srv_purge_coordinator_suspend (slot=0x36a1890, rseg_history_len=9) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2676 #5 0x0000000001b8346d in srv_purge_coordinator_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:2792 #6 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fce42bfd700 (LWP 14464)): #0 0x00007fce60cde705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a85b63 in os_event::wait (this=0x36a2058) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:165 #2 0x0000000001a85505 in os_event::wait_low (this=0x36a2058, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:335 #3 0x0000000001a8592f in os_event_wait_low (event=0x36a2058, reset_sig_count=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:534 #4 0x0000000001c65a71 in buf_dump_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/buf/buf0dump.cc:782 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fce5b931700 (LWP 14447)): #0 0x00007fce5f6da7da in sigwaitinfo () from /lib64/libc.so.6 #1 0x00000000018dfdfd in timer_notify_thread_func (arg=0x7ffcc1365760) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/mysys/posix_timers.c:77 #2 0x0000000001910aa4 in pfs_spawn_thread (arg=0x3663190) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/perfschema/pfs.cc:2190 #3 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fce4bfff700 (LWP 14456)): #0 0x00007fce60cdeab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a8538e in os_event::timed_wait (this=0x3b66c98, abstime=0x7fce4bffee70) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:285 #2 0x0000000001a856d2 in os_event::wait_time_low (this=0x3b66c98, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:412 #3 0x0000000001a8590a in os_event_wait_time_low (event=0x3b66c98, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:517 #4 0x0000000001a4d9b9 in lock_wait_timeout_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/lock/lock0wait.cc:501 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fce50dfa700 (LWP 14454)): #0 0x00007fce60cdeab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a8538e in os_event::timed_wait (this=0x36a20f8, abstime=0x7fce50df9930) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:285 #2 0x0000000001a856d2 in os_event::wait_time_low (this=0x36a20f8, time_in_usec=1000000, reset_sig_count=2) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:412 #3 0x0000000001a8590a in os_event_wait_time_low (event=0x36a20f8, time_in_usec=1000000, reset_sig_count=2) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:517 #4 0x0000000001c6ec56 in pc_sleep_if_needed (next_loop_time=1510221910674, sig_count=2) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/buf/buf0flu.cc:2690 #5 0x0000000001c6fea0 in buf_flush_page_cleaner_coordinator (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/buf/buf0flu.cc:3191 #6 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fce517fb700 (LWP 14453)): #0 0x00007fce60ad1644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a75045 in LinuxAIOHandler::collect (this=0x7fce517fada0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2500 #2 0x0000000001a7550a in LinuxAIOHandler::poll (this=0x7fce517fada0, m1=0x7fce517fae90, m2=0x7fce517fae88, request=0x7fce517fae50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2646 #3 0x0000000001a75695 in os_aio_linux_handler (global_segment=5, m1=0x7fce517fae90, m2=0x7fce517fae88, request=0x7fce517fae50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2702 #4 0x0000000001a7a27c in os_aio_handler (segment=5, m1=0x7fce517fae90, m2=0x7fce517fae88, request=0x7fce517fae50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:6259 #5 0x0000000001ce0906 in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001b86d3a in io_handler_thread (arg=0x2e65988 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0start.cc:311 #7 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fce535fe700 (LWP 14450)): #0 0x00007fce60ad1644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a75045 in LinuxAIOHandler::collect (this=0x7fce535fdda0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2500 #2 0x0000000001a7550a in LinuxAIOHandler::poll (this=0x7fce535fdda0, m1=0x7fce535fde90, m2=0x7fce535fde88, request=0x7fce535fde50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2646 #3 0x0000000001a75695 in os_aio_linux_handler (global_segment=2, m1=0x7fce535fde90, m2=0x7fce535fde88, request=0x7fce535fde50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2702 #4 0x0000000001a7a27c in os_aio_handler (segment=2, m1=0x7fce535fde90, m2=0x7fce535fde88, request=0x7fce535fde50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:6259 #5 0x0000000001ce0906 in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001b86d3a in io_handler_thread (arg=0x2e65970 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0start.cc:311 #7 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fce53fff700 (LWP 14449)): #0 0x00007fce60ad1644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a75045 in LinuxAIOHandler::collect (this=0x7fce53ffeda0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2500 #2 0x0000000001a7550a in LinuxAIOHandler::poll (this=0x7fce53ffeda0, m1=0x7fce53ffee90, m2=0x7fce53ffee88, request=0x7fce53ffee50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2646 #3 0x0000000001a75695 in os_aio_linux_handler (global_segment=1, m1=0x7fce53ffee90, m2=0x7fce53ffee88, request=0x7fce53ffee50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2702 #4 0x0000000001a7a27c in os_aio_handler (segment=1, m1=0x7fce53ffee90, m2=0x7fce53ffee88, request=0x7fce53ffee50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:6259 #5 0x0000000001ce0906 in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001b86d3a in io_handler_thread (arg=0x2e65968 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0start.cc:311 #7 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fce58a5e700 (LWP 14448)): #0 0x00007fce60ad1644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a75045 in LinuxAIOHandler::collect (this=0x7fce58a5dda0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2500 #2 0x0000000001a7550a in LinuxAIOHandler::poll (this=0x7fce58a5dda0, m1=0x7fce58a5de90, m2=0x7fce58a5de88, request=0x7fce58a5de50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2646 #3 0x0000000001a75695 in os_aio_linux_handler (global_segment=0, m1=0x7fce58a5de90, m2=0x7fce58a5de88, request=0x7fce58a5de50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2702 #4 0x0000000001a7a27c in os_aio_handler (segment=0, m1=0x7fce58a5de90, m2=0x7fce58a5de88, request=0x7fce58a5de50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:6259 #5 0x0000000001ce0906 in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001b86d3a in io_handler_thread (arg=0x2e65960 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0start.cc:311 #7 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fce4b5fe700 (LWP 14457)): #0 0x00007fce60cdeab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a8538e in os_event::timed_wait (this=0x36a1f18, abstime=0x7fce4b5fdb80) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:285 #2 0x0000000001a856d2 in os_event::wait_time_low (this=0x36a1f18, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:412 #3 0x0000000001a8590a in os_event_wait_time_low (event=0x36a1f18, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:517 #4 0x0000000001b810b8 in srv_error_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:1751 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fce4abfd700 (LWP 14458)): #0 0x00007fce60cdeab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a8538e in os_event::timed_wait (this=0x36a1fb8, abstime=0x7fce4abfce40) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:285 #2 0x0000000001a856d2 in os_event::wait_time_low (this=0x36a1fb8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:412 #3 0x0000000001a8590a in os_event_wait_time_low (event=0x36a1fb8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0event.cc:517 #4 0x0000000001b80b43 in srv_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0srv.cc:1585 #5 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fce521fc700 (LWP 14452)): #0 0x00007fce60ad1644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a75045 in LinuxAIOHandler::collect (this=0x7fce521fbda0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2500 #2 0x0000000001a7550a in LinuxAIOHandler::poll (this=0x7fce521fbda0, m1=0x7fce521fbe90, m2=0x7fce521fbe88, request=0x7fce521fbe50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2646 #3 0x0000000001a75695 in os_aio_linux_handler (global_segment=4, m1=0x7fce521fbe90, m2=0x7fce521fbe88, request=0x7fce521fbe50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2702 #4 0x0000000001a7a27c in os_aio_handler (segment=4, m1=0x7fce521fbe90, m2=0x7fce521fbe88, request=0x7fce521fbe50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:6259 #5 0x0000000001ce0906 in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001b86d3a in io_handler_thread (arg=0x2e65980 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0start.cc:311 #7 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fce52bfd700 (LWP 14451)): #0 0x00007fce60ad1644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a75045 in LinuxAIOHandler::collect (this=0x7fce52bfcda0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2500 #2 0x0000000001a7550a in LinuxAIOHandler::poll (this=0x7fce52bfcda0, m1=0x7fce52bfce90, m2=0x7fce52bfce88, request=0x7fce52bfce50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2646 #3 0x0000000001a75695 in os_aio_linux_handler (global_segment=3, m1=0x7fce52bfce90, m2=0x7fce52bfce88, request=0x7fce52bfce50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:2702 #4 0x0000000001a7a27c in os_aio_handler (segment=3, m1=0x7fce52bfce90, m2=0x7fce52bfce88, request=0x7fce52bfce50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/os/os0file.cc:6259 #5 0x0000000001ce0906 in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001b86d3a in io_handler_thread (arg=0x2e65978 ) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/srv/srv0start.cc:311 #7 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fce610e7740 (LWP 14446)): #0 0x00007fce5f79000d in poll () from /lib64/libc.so.6 #1 0x00000000016c0ca5 in Mysqld_socket_listener::listen_for_connection_event (this=0x3bfa6a0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/conn_handler/socket_connection.cc:852 #2 0x0000000000ed112c in Connection_acceptor::connection_event_loop (this=0x3bc4760) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/conn_handler/connection_acceptor.h:66 #3 0x0000000000ec8ac5 in mysqld_main (argc=94, argv=0x3528448) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/mysqld.cc:5045 #4 0x0000000000ebfde4 in main (argc=9, argv=0x7ffcc1366198) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/main.cc:25 Thread 1 (Thread 0x7fce58c80700 (LWP 14473)): #0 0x00007fce60cdf771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018d6751 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/mysys/stacktrace.c:249 #2 0x0000000000ed7e3a in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/signal_handler.cc:220 #3 #4 0x00007fce5f6d95d7 in raise () from /lib64/libc.so.6 #5 0x00007fce5f6dacc8 in abort () from /lib64/libc.so.6 #6 0x0000000001bee567 in ut_dbg_assertion_failed (expr=0x232d53c "0", file=0x232e3f0 "/export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/row/row0sel.cc", line=3620) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000001b46deb in row_sel_get_clust_rec_for_mysql (prebuilt=0x7fce08014ea0, sec_index=0x7fce080da970, rec=0x7fce5946807d "\200", thr=0x7fce08015700, out_rec=0x7fce58c7cc60, offsets=0x7fce58c7cc38, offset_heap=0x7fce58c7cc40, vrow=0x0, mtr=0x7fce58c7c3b0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/row/row0sel.cc:3620 #8 0x0000000001b4b8c0 in row_search_mvcc (buf=0x7fce080db160 '\217' , "\220", , mode=PAGE_CUR_GE, prebuilt=0x7fce08014ea0, match_mode=1, direction=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/row/row0sel.cc:5763 #9 0x00000000019b897c in ha_innobase::index_read (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , key_ptr=0x7fce08ea2c00 "", key_len=16, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/innobase/handler/ha_innodb.cc:8696 #10 0x0000000000f61a7c in handler::index_read_map (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , key=0x7fce08ea2c00 "", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/handler.h:2783 #11 0x0000000000f5d82f in handler::index_read_idx_map (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , index=1, key=0x7fce08ea2c00 "", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/handler.cc:7504 #12 0x0000000000f53a4d in handler::ha_index_read_idx_map (this=0x7fce080dae70, buf=0x7fce080db160 '\217' , "\220", , index=1, key=0x7fce08ea2c00 "", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/handler.cc:3083 #13 0x000000000154575c in read_const (table=0x7fce080fc410, ref=0x7fce08ea2070) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_executor.cc:2007 #14 0x000000000154522b in join_read_const_table (tab=0x7fce08ea1fa0, pos=0x7fce08ea2138) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_executor.cc:1892 #15 0x0000000001572857 in JOIN::extract_func_dependent_tables (this=0x7fce08ea17b8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_optimizer.cc:5579 #16 0x00000000015711d9 in JOIN::make_join_plan (this=0x7fce08ea17b8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_optimizer.cc:5043 #17 0x00000000015657e3 in JOIN::optimize (this=0x7fce08ea17b8) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_optimizer.cc:368 #18 0x00000000015dfc71 in st_select_lex::optimize (this=0x7fce0803d050, thd=0x7fce0802c6d0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_select.cc:1009 #19 0x00000000015de384 in handle_query (thd=0x7fce0802c6d0, lex=0x7fce0802e850, result=0x7fce0803ee60, added_options=0, removed_options=0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_select.cc:164 #20 0x0000000001593533 in execute_sqlcom_select (thd=0x7fce0802c6d0, all_tables=0x7fce0803e298) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:5159 #21 0x000000000158c127 in mysql_execute_command (thd=0x7fce0802c6d0, first_level=true) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:2796 #22 0x00000000015943b9 in mysql_parse (thd=0x7fce0802c6d0, parser_state=0x7fce58c7f690) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:5577 #23 0x0000000001588d5e in dispatch_command (thd=0x7fce0802c6d0, com_data=0x7fce58c7fe00, command=COM_QUERY) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:1461 #24 0x0000000001587b61 in do_command (thd=0x7fce0802c6d0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/sql_parse.cc:999 #25 0x00000000016be3c0 in handle_connection (arg=0x3fa18b0) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/sql/conn_handler/connection_handler_per_thread.cc:300 #26 0x0000000001910aa4 in pfs_spawn_thread (arg=0x3f45f50) at /export/home/pb2/build/sb_0-24964902-1505322971.88/mysql-5.7.20/storage/perfschema/pfs.cc:2190 #27 0x00007fce60cdadf5 in start_thread () from /lib64/libpthread.so.0 #28 0x00007fce5f79a60d in clone () from /lib64/libc.so.6 Only 1 of 2 completed. mysql-test-run: *** ERROR: Not all tests completed [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20/mysql-test: ./mtr --debug 2 Logging: ./mtr --debug 2 MySQL Version 5.7.20 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.20/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 CREATE TABLE `t` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `a` bigint(20) NOT NULL, `b` bigint(20) NOT NULL, `c` bigint(20) NOT NULL, `d` bigint(20) NOT NULL, `e` bigint(20) NOT NULL, PRIMARY KEY (`id`), KEY `k_de` (`d`, `e`) ) ENGINE=InnoDB; INSERT INTO `t` (`a`, `b`, `c`, `d`, `e`) VALUES (0, 0, 0, 0, 0); CREATE UNIQUE INDEX `uk_a_b_c` ON `t` (`a`, `b`, `c`); SELECT * FROM `t`; id a b c d e 1 0 0 0 0 0 SHOW CREATE TABLE t; Table Create Table t CREATE TABLE `t` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `a` bigint(20) NOT NULL, `b` bigint(20) NOT NULL, `c` bigint(20) NOT NULL, `d` bigint(20) NOT NULL, `e` bigint(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_a_b_c` (`a`,`b`,`c`), KEY `k_de` (`d`,`e`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 FLUSH TABLES `t` FOR EXPORT; UNLOCK TABLES; DROP TABLE t; CREATE TABLE `t` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `a` bigint(20) NOT NULL, `b` bigint(20) NOT NULL, `c` bigint(20) NOT NULL, `d` bigint(20) NOT NULL, `e` bigint(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_a_b_c` (`a`, `b`, `c`), KEY `k_de` (`d`,`e`) ) ENGINE=InnoDB; ALTER TABLE t DISCARD TABLESPACE; ALTER TABLE t IMPORT TABLESPACE; Warnings: Warning 1810 InnoDB: IO Read error: (2, No such file or directory) Error opening './test/t.cfg', will attempt to import without schema verification SELECT * FROM t WHERE a = 0 and b = 0 and c = 0; id a b c d e SELECT * FROM t; id a b c d e 1 0 0 0 0 0 DROP TABLE t; main.2 [ pass ] 239 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.239 of 14 seconds executing testcases Completed: All 1 tests were successful.