-- 5.7.30 vi t/bug99572.test [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test: ./mtr --debug-server bug99572 Logging: ./mtr --debug-server bug99572 MySQL Version 5.7.30 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.30/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 # Reset innodb_sort_buffer_size to a lower value to make ALTER TABLE # use sort files. # restart: --innodb_sort_buffer_size=65536 CREATE TABLE t_inplace_alter_tmp_file_02( a INT PRIMARY KEY, b VARCHAR(100), c INT DEFAULT NULL, d VARCHAR(100), e INT, f INT, g INT, h INT, x INT, y INT, z INT) ENGINE=INNODB; # con1 used to signal at sync point # connection DEFAULT # > Case 1: Generate Row Log Files # ----------------------------------------------------------------------- # connection default # 1. Prepare data. CALL load_data("t_inplace_alter_tmp_file_02", 0, 20000); # 2. Alter table inplace. SET DEBUG_SYNC='RESET'; SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL do_dml WAIT_FOR go_on_execute EXECUTE 1'; ALTER TABLE t_inplace_alter_tmp_file_02 ADD INDEX ci(c);; # 3. Do concurrent DML. # connnection con1 SET DEBUG_SYNC='now WAIT_FOR do_dml'; CALL load_data("t_inplace_alter_tmp_file_02", 20000, 20000); SET DEBUG_SYNC='now SIGNAL go_on_execute'; [100%] main.bug99572 [ fail ] Test ended at 2020-05-14 14:02:38 CURRENT_TEST: main.bug99572 mysqltest: At line 72: query 'reap' failed: 2013: Lost connection to MySQL server during query safe_process[31830]: Child process: 31831, exit: 1 Server [mysqld.1 - pid: 31835, winpid: 31835, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2020-05-14T12:02:05.141098Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-05-14T12:02:05.143644Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2020-05-14T12:02:05.143661Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-05-14T12:02:05.143738Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug (mysqld 5.7.30-debug-log) starting as process 31803 ... 2020-05-14T12:02:05.149689Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-05-14T12:02:05.149726Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2020-05-14T12:02:05.149736Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-05-14T12:02:05.149743Z 0 [Note] InnoDB: Uses event mutexes 2020-05-14T12:02:05.149754Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2020-05-14T12:02:05.149761Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-05-14T12:02:05.149770Z 0 [Note] InnoDB: Using Linux native AIO 2020-05-14T12:02:05.150396Z 0 [Note] InnoDB: Number of pools: 1 2020-05-14T12:02:05.150633Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-05-14T12:02:05.152463Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M 2020-05-14T12:02:05.168527Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-05-14T12:02:05.169333Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-14T12:02:05.183538Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-05-14T12:02:05.234518Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-05-14T12:02:05.234636Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-14T12:02:05.249815Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-05-14T12:02:05.261527Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-05-14T12:02:05.261549Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-05-14T12:02:05.262818Z 0 [Note] InnoDB: Waiting for purge to start 2020-05-14T12:02:05.313158Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 1350275 2020-05-14T12:02:05.313390Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data/ib_buffer_pool 2020-05-14T12:02:05.314109Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-05-14T12:02:05.319331Z 0 [Warning] unknown variable 'loose-mysqlx-port=13009' 2020-05-14T12:02:05.319350Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/tmp/mysqlx.1.sock' 2020-05-14T12:02:05.320381Z 0 [Note] Salting uuid generator variables, current_pid: 31803, server_start_time: 1589457725, bytes_sent: 0, 2020-05-14T12:02:05.320469Z 0 [Note] Generated uuid: 'ba898282-95da-11ea-bc7f-0010e05f3e06', server_start_time: 8951748685918482296, bytes_sent: 79234560 2020-05-14T12:02:05.320527Z 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: ba898282-95da-11ea-bc7f-0010e05f3e06. 2020-05-14T12:02:05.321518Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200514 15:02:05 2020-05-14T12:02:05.326180Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2020-05-14T12:02:05.328904Z 0 [Warning] CA certificate /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/std_data/cacert.pem is self signed. 2020-05-14T12:02:05.328992Z 0 [Note] Skipping generation of RSA key pair as --sha256_password_auto_generate_rsa_keys is set to OFF. 2020-05-14T12:02:05.329027Z 0 [Warning] RSA private key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data//private_key.pem. Some authentication plugins will not work. 2020-05-14T12:02:05.329070Z 0 [Warning] RSA public key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data//public_key.pem. Some authentication plugins will not work. 2020-05-14T12:02:05.329087Z 0 [Note] Server hostname (bind-address): '*'; port: 13000 2020-05-14T12:02:05.329126Z 0 [Note] IPv6 is available. 2020-05-14T12:02:05.329145Z 0 [Note] - '::' resolves to '::'; 2020-05-14T12:02:05.329202Z 0 [Note] Server socket created on IP: '::'. 2020-05-14T12:02:05.411342Z 0 [Note] Failed to start slave threads for channel '' 2020-05-14T12:02:05.431391Z 0 [Note] Event Scheduler: Loaded 0 events 2020-05-14T12:02:05.431856Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug: ready for connections. Version: '5.7.30-debug-log' socket: '/export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - Debug (GPL) 2020-05-14T12:02:05.974456Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-05-14T12:02:05.974480Z 0 [Note] Shutting down slave threads 2020-05-14T12:02:05.974495Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-05-14T12:02:05.974511Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-05-14T12:02:05.974693Z 0 [Note] Binlog end 2020-05-14T12:02:05.978102Z 0 [Note] Shutting down plugin 'ngram' 2020-05-14T12:02:05.978130Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-05-14T12:02:05.978148Z 0 [Note] Shutting down plugin 'partition' 2020-05-14T12:02:05.978155Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-05-14T12:02:05.978165Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-05-14T12:02:05.978224Z 0 [Note] Shutting down plugin 'CSV' 2020-05-14T12:02:05.978232Z 0 [Note] Shutting down plugin 'MEMORY' 2020-05-14T12:02:05.978240Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-05-14T12:02:05.978248Z 0 [Note] Shutting down plugin 'MyISAM' 2020-05-14T12:02:05.978271Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-05-14T12:02:05.978278Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-05-14T12:02:05.978290Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-05-14T12:02:05.978296Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-05-14T12:02:05.978307Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-05-14T12:02:05.978312Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-05-14T12:02:05.978318Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-05-14T12:02:05.978323Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-05-14T12:02:05.978338Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-05-14T12:02:05.978344Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-05-14T12:02:05.978350Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-05-14T12:02:05.978356Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-05-14T12:02:05.978361Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-05-14T12:02:05.978366Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-05-14T12:02:05.978372Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-05-14T12:02:05.978377Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-05-14T12:02:05.978382Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-05-14T12:02:05.978387Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-05-14T12:02:05.978393Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-05-14T12:02:05.978398Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-05-14T12:02:05.978403Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-05-14T12:02:05.978408Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-05-14T12:02:05.978413Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-05-14T12:02:05.978418Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-05-14T12:02:05.978423Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-05-14T12:02:05.978445Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-05-14T12:02:05.978451Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-05-14T12:02:05.978456Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-05-14T12:02:05.978461Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-05-14T12:02:05.978467Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-05-14T12:02:05.978472Z 0 [Note] Shutting down plugin 'sha256_password' 2020-05-14T12:02:05.978477Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-05-14T12:02:05.978586Z 0 [Note] Shutting down plugin 'binlog' 2020-05-14T12:02:05.978597Z 0 [Note] Shutting down plugin 'InnoDB' 2020-05-14T12:02:05.978764Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-05-14T12:02:05.978883Z 0 [Note] InnoDB: Starting shutdown... 2020-05-14T12:02:06.079128Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data/ib_buffer_pool 2020-05-14T12:02:06.079383Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200514 15:02:06 2020-05-14T12:02:06.886227Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1350294 2020-05-14T12:02:06.888643Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-05-14T12:02:06.891501Z 0 [Note] Debug sync points hit: 12134 2020-05-14T12:02:06.891516Z 0 [Note] Debug sync points executed: 0 2020-05-14T12:02:06.891521Z 0 [Note] Debug sync points max active per thread: 0 2020-05-14T12:02:06.891588Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug: Shutdown complete 2020-05-14T12:02:07.349223Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-05-14T12:02:07.351555Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2020-05-14T12:02:07.351574Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-05-14T12:02:07.351638Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug (mysqld 5.7.30-debug-log) starting as process 31836 ... 2020-05-14T12:02:07.357442Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-05-14T12:02:07.357480Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2020-05-14T12:02:07.357491Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-05-14T12:02:07.357498Z 0 [Note] InnoDB: Uses event mutexes 2020-05-14T12:02:07.357509Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2020-05-14T12:02:07.357516Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-05-14T12:02:07.357523Z 0 [Note] InnoDB: Using Linux native AIO 2020-05-14T12:02:07.358122Z 0 [Note] InnoDB: Number of pools: 1 2020-05-14T12:02:07.358337Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-05-14T12:02:07.360106Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M 2020-05-14T12:02:07.376171Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-05-14T12:02:07.376905Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-14T12:02:07.391116Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-05-14T12:02:07.437671Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-05-14T12:02:07.437803Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-14T12:02:07.453602Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-05-14T12:02:07.465344Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-05-14T12:02:07.465365Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-05-14T12:02:07.466597Z 0 [Note] InnoDB: Waiting for purge to start 2020-05-14T12:02:07.516972Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 1350294 2020-05-14T12:02:07.517337Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data/ib_buffer_pool 2020-05-14T12:02:07.518000Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-05-14T12:02:07.522233Z 0 [Warning] unknown variable 'loose-mysqlx-port=13009' 2020-05-14T12:02:07.522252Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/tmp/mysqlx.1.sock' 2020-05-14T12:02:07.525747Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200514 15:02:07 2020-05-14T12:02:07.529226Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2020-05-14T12:02:07.530392Z 0 [Warning] CA certificate /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/std_data/cacert.pem is self signed. 2020-05-14T12:02:07.530460Z 0 [Note] Skipping generation of RSA key pair as --sha256_password_auto_generate_rsa_keys is set to OFF. 2020-05-14T12:02:07.530487Z 0 [Warning] RSA private key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data//private_key.pem. Some authentication plugins will not work. 2020-05-14T12:02:07.530501Z 0 [Warning] RSA public key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/mysqld.1/data//public_key.pem. Some authentication plugins will not work. 2020-05-14T12:02:07.530514Z 0 [Note] Server hostname (bind-address): '*'; port: 13000 2020-05-14T12:02:07.530551Z 0 [Note] IPv6 is available. 2020-05-14T12:02:07.530573Z 0 [Note] - '::' resolves to '::'; 2020-05-14T12:02:07.530627Z 0 [Note] Server socket created on IP: '::'. 2020-05-14T12:02:07.548244Z 0 [Note] Failed to start slave threads for channel '' 2020-05-14T12:02:07.566781Z 0 [Note] Event Scheduler: Loaded 0 events 2020-05-14T12:02:07.567228Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug: ready for connections. Version: '5.7.30-debug-log' socket: '/export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - Debug (GPL) 2020-05-14 15:02:38 0x7fd188337700 InnoDB: Assertion failure in thread 140537909966592 in file os0file.cc line 8589 InnoDB: Failing assertion: header.m_version == 1 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. 12:02:38 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=2 max_threads=151 thread_count=2 connection_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61035 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fd138000b70 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 = 7fd188336e30 thread_stack 0x40000 /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(my_print_stacktrace+0x35)[0x190b25a] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(handle_fatal_signal+0x407)[0xefe297] /lib64/libpthread.so.0(+0xf130)[0x7fd18f994130] /lib64/libc.so.6(gsignal+0x37)[0x7fd18e38a5d7] /lib64/libc.so.6(abort+0x148)[0x7fd18e38bcc8] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1ceb333] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_ZN11Compression11deserializeEbPhS0_m+0x9f)[0x1b7a55d] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z23os_file_decompress_pagebPhS_m+0x34)[0x1b7a8bf] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1b703bd] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1b74dd8] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1b756f5] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1b75876] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z35os_file_read_no_error_handling_funcR9IORequestiPvmmPm+0x82)[0x1b76751] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1c1920e] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x1c26d66] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z13row_log_applyPK5trx_tP12dict_index_tP5TABLEP16ut_stage_alter_t+0x13e)[0x1c27b00] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z23row_merge_build_indexesP5trx_tP12dict_table_tS2_bPP12dict_index_tPKmmP5TABLEPK8dtuple_tS7_mR13ib_sequence_tbP16ut_stage_alter_tPK16dict_add_v_col_tS9_+0xc8f)[0x1bfcebc] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_ZN11ha_innobase19inplace_alter_tableEP5TABLEP18Alter_inplace_info+0x8c0)[0x1af9448] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_ZN7handler22ha_inplace_alter_tableEP5TABLEP18Alter_inplace_info+0x39)[0x1658973] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug[0x16500fd] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z17mysql_alter_tableP3THDPKcS2_P24st_ha_create_informationP10TABLE_LISTP10Alter_info+0x1d34)[0x165540e] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_ZN19Sql_cmd_alter_table7executeEP3THD+0x5be)[0x17dadb6] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z21mysql_execute_commandP3THDb+0x6e31)[0x15c04eb] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z11mysql_parseP3THDP12Parser_state+0x5f0)[0x15c25ff] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xcc1)[0x15b7155] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(_Z10do_commandP3THD+0x4b3)[0x15b5fa0] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(handle_connection+0x1e7)[0x16ee1cd] /export/umesh/server/binaries/GABuilds/mysql-5.7.30/bin/mysqld-debug(pfs_spawn_thread+0x170)[0x1ef92bc] /lib64/libpthread.so.0(+0x7df5)[0x7fd18f98cdf5] /lib64/libc.so.6(clone+0x6d)[0x7fd18e44b60d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fd138005700): ALTER TABLE t_inplace_alter_tmp_file_02 ADD INDEX ci(c) Connection ID (thread ID): 2 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[31835]: Child process: 31836, killed by signal: 6 ----------SERVER LOG END------------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-5.7.30/mysql-test/var/log/main.bug99572/bug99572.log' - found 'core.31836' (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.30/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 31860] [New LWP 31838] [New LWP 31840] [New LWP 31849] [New LWP 31843] [New LWP 31853] [New LWP 31856] [New LWP 31837] [New LWP 31859] [New LWP 31851] [New LWP 31844] [New LWP 31861] [New LWP 31858] [New LWP 31852] [New LWP 31846] [New LWP 31836] [New LWP 31854] [New LWP 31847] [New LWP 31850] [New LWP 31841] [New LWP 31848] [New LWP 31842] [New LWP 31857] [New LWP 31839] [New LWP 31855] [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.30/bin/mysqld-debug --defaults'. Program terminated with signal 6, Aborted. #0 0x00007fd18f991771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007fd18f991771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000190b2e1 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/mysys/stacktrace.c:261 #2 0x0000000000efe48d in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/signal_handler.cc:227 #3 #4 0x00007fd18e38a5d7 in raise () from /lib64/libc.so.6 #5 0x00007fd18e38bcc8 in abort () from /lib64/libc.so.6 #6 0x0000000001ceb333 in ut_dbg_assertion_failed (expr=0x246d1fe "header.m_version == 1", file=0x246b4e0 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc", line=8589) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/ut/ut0dbg.cc:75 #7 0x0000000001b7a55d in Compression::deserialize (dblwr_recover=false, src=0x7fd188266000 "", dst=0x0, dst_len=65536) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:8589 #8 0x0000000001b7a8bf in os_file_decompress_page (dblwr_recover=false, src=0x7fd188266000 "", dst=0x0, dst_len=65536) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:8730 #9 0x0000000001b703bd in os_file_io_complete (type=..., fh=57, buf=0x7fd188266000 "", scratch=0x0, src_len=65536, offset=196608, len=65536) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:1722 #10 0x0000000001b74dd8 in os_file_io (in_type=..., file=57, buf=0x7fd188266000, n=65536, offset=196608, err=0x7fd188331d0c) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:5475 #11 0x0000000001b756f5 in os_file_pread (type=..., file=57, buf=0x7fd188266000, n=65536, offset=196608, err=0x7fd188331d0c) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:5634 #12 0x0000000001b75876 in os_file_read_page (type=..., file=57, buf=0x7fd188266000, offset=196608, n=65536, o=0x0, exit_on_err=false) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:5673 #13 0x0000000001b76751 in os_file_read_no_error_handling_func (type=..., file=57, buf=0x7fd188266000, offset=196608, n=65536, o=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6091 #14 0x0000000001c1920e in pfs_os_file_read_no_error_handling_int_fd_func (type=..., file=57, buf=0x7fd188266000, offset=196608, n=65536, o=0x0, src_file=0x2491368 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0log.cc", src_line=3765) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/include/os0file.ic:394 #15 0x0000000001c26d66 in row_log_apply_ops (trx=0x7fd1886978c0, index=0x7fd1389cbe00, dup=0x7fd188332510, stage=0x7fd1389c5018) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0log.cc:3760 #16 0x0000000001c27b00 in row_log_apply (trx=0x7fd1886978c0, index=0x7fd1389cbe00, table=0x7fd1380b3d60, stage=0x7fd1389c5018) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0log.cc:3991 #17 0x0000000001bfcebc in row_merge_build_indexes (trx=0x7fd1886978c0, old_table=0x7fd138025d50, new_table=0x7fd138025d50, online=true, indexes=0x7fd1380b6e00, key_numbers=0x7fd1380b6e08, n_indexes=1, table=0x7fd1380b3d60, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=false, stage=0x7fd1389c5018, add_v=0x0, eval_table=0x7fd1380b3d60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0merge.cc:4579 #18 0x0000000001af9448 in ha_innobase::inplace_alter_table (this=0x7fd1380e7dd0, altered_table=0x7fd1380b3d60, ha_alter_info=0x7fd188333810) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/handler/handler0alter.cc:6438 #19 0x0000000001658973 in handler::ha_inplace_alter_table (this=0x7fd1380e7dd0, altered_table=0x7fd1380b3d60, ha_alter_info=0x7fd188333810) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/handler.h:3444 #20 0x00000000016500fd in mysql_inplace_alter_table (thd=0x7fd138000b70, table_list=0x7fd138006108, table=0x7fd1380e7410, altered_table=0x7fd1380b3d60, ha_alter_info=0x7fd188333810, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fd1883341a0, alter_ctx=0x7fd188332d70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_table.cc:7588 #21 0x000000000165540e in mysql_alter_table (thd=0x7fd138000b70, new_db=0x7fd138006690 "test", new_name=0x0, create_info=0x7fd188334c00, table_list=0x7fd138006108, alter_info=0x7fd188334d00) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_table.cc:9807 #22 0x00000000017dadb6 in Sql_cmd_alter_table::execute (this=0x7fd138006758, thd=0x7fd138000b70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_alter.cc:334 #23 0x00000000015c04eb in mysql_execute_command (thd=0x7fd138000b70, first_level=true) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:4845 #24 0x00000000015c25ff in mysql_parse (thd=0x7fd138000b70, parser_state=0x7fd188336690) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:5584 #25 0x00000000015b7155 in dispatch_command (thd=0x7fd138000b70, com_data=0x7fd188336e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1491 #26 0x00000000015b5fa0 in do_command (thd=0x7fd138000b70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1032 #27 0x00000000016ee1cd in handle_connection (arg=0x5044e60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:313 #28 0x0000000001ef92bc in pfs_spawn_thread (arg=0x5053340) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #29 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #30 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fd15ffff700 (LWP 31855)): #0 0x00007fd18f990ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b81d2a in os_event::timed_wait (this=0x4bf71e8, abstime=0x7fd15fffee90) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #2 0x0000000001b823aa in os_event::wait_time_low (this=0x4bf71e8, time_in_usec=10000000, reset_sig_count=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #3 0x0000000001b82610 in os_event_wait_time_low (event=0x4bf71e8, time_in_usec=10000000, reset_sig_count=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:594 #4 0x0000000001dc7a15 in dict_stats_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/dict/dict0stats_bg.cc:435 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fd181cce700 (LWP 31839)): #0 0x00007fd18f57f644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001b71819 in LinuxAIOHandler::collect (this=0x7fd181ccdda0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #2 0x0000000001b71d54 in LinuxAIOHandler::poll (this=0x7fd181ccdda0, m1=0x7fd181ccde90, m2=0x7fd181ccde88, request=0x7fd181ccde50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #3 0x0000000001b71edf in os_aio_linux_handler (global_segment=1, m1=0x7fd181ccde90, m2=0x7fd181ccde88, request=0x7fd181ccde50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #4 0x0000000001b76a19 in os_aio_handler (segment=1, m1=0x7fd181ccde90, m2=0x7fd181ccde88, request=0x7fd181ccde50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #5 0x0000000001dde2d7 in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #6 0x0000000001c83905 in io_handler_thread (arg=0x30318e8 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #7 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fd15ebfd700 (LWP 31857)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b82a0b in os_event::wait (this=0x47005e8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #2 0x0000000001b81ea1 in os_event::wait_low (this=0x47005e8, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #3 0x0000000001b82635 in os_event_wait_low (event=0x47005e8, reset_sig_count=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:611 #4 0x0000000001d4cb40 in buf_resize_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0buf.cc:3027 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fd17fecb700 (LWP 31842)): #0 0x00007fd18f57f644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001b71819 in LinuxAIOHandler::collect (this=0x7fd17fecada0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #2 0x0000000001b71d54 in LinuxAIOHandler::poll (this=0x7fd17fecada0, m1=0x7fd17fecae90, m2=0x7fd17fecae88, request=0x7fd17fecae50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #3 0x0000000001b71edf in os_aio_linux_handler (global_segment=4, m1=0x7fd17fecae90, m2=0x7fd17fecae88, request=0x7fd17fecae50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #4 0x0000000001b76a19 in os_aio_handler (segment=4, m1=0x7fd17fecae90, m2=0x7fd17fecae88, request=0x7fd17fecae50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #5 0x0000000001dde2d7 in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #6 0x0000000001c83905 in io_handler_thread (arg=0x3031900 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #7 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fd17cac1700 (LWP 31848)): #0 0x00007fd18f990ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b81d2a in os_event::timed_wait (this=0x4700408, abstime=0x7fd17cac0e50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #2 0x0000000001b823aa in os_event::wait_time_low (this=0x4700408, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #3 0x0000000001b82610 in os_event_wait_time_low (event=0x4700408, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:594 #4 0x0000000001c7d80f in srv_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:1592 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fd1808cc700 (LWP 31841)): #0 0x00007fd18f57f644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001b71819 in LinuxAIOHandler::collect (this=0x7fd1808cbda0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #2 0x0000000001b71d54 in LinuxAIOHandler::poll (this=0x7fd1808cbda0, m1=0x7fd1808cbe90, m2=0x7fd1808cbe88, request=0x7fd1808cbe50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #3 0x0000000001b71edf in os_aio_linux_handler (global_segment=3, m1=0x7fd1808cbe90, m2=0x7fd1808cbe88, request=0x7fd1808cbe50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #4 0x0000000001b76a19 in os_aio_handler (segment=3, m1=0x7fd1808cbe90, m2=0x7fd1808cbe88, request=0x7fd1808cbe50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #5 0x0000000001dde2d7 in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #6 0x0000000001c83905 in io_handler_thread (arg=0x30318f8 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #7 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fd1775fe700 (LWP 31850)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b82a0b in os_event::wait (this=0x47000e8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #2 0x0000000001b81ea1 in os_event::wait_low (this=0x47000e8, reset_sig_count=5) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #3 0x0000000001b82635 in os_event_wait_low (event=0x47000e8, reset_sig_count=5) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:611 #4 0x0000000001c7faed in srv_purge_coordinator_suspend (slot=0x46ffce0, rseg_history_len=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2683 #5 0x0000000001c80020 in srv_purge_coordinator_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2799 #6 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fd17d4c2700 (LWP 31847)): #0 0x00007fd18f990ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b81d2a in os_event::timed_wait (this=0x4700368, abstime=0x7fd17d4c1b80) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #2 0x0000000001b823aa in os_event::wait_time_low (this=0x4700368, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #3 0x0000000001b82610 in os_event_wait_time_low (event=0x4700368, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:594 #4 0x0000000001c7dd67 in srv_error_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:1758 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fd174dfa700 (LWP 31854)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b82a0b in os_event::wait (this=0x47004a8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #2 0x0000000001b81ea1 in os_event::wait_low (this=0x47004a8, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #3 0x0000000001b82635 in os_event_wait_low (event=0x47004a8, reset_sig_count=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:611 #4 0x0000000001d62c01 in buf_dump_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0dump.cc:792 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fd18fd99740 (LWP 31836)): #0 0x00007fd18e44100d in poll () from /lib64/libc.so.6 #1 0x00000000016f0a71 in Mysqld_socket_listener::listen_for_connection_event (this=0x4c7dc20) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/socket_connection.cc:859 #2 0x0000000000ef7794 in Connection_acceptor::connection_event_loop (this=0x4c7ada0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_acceptor.h:73 #3 0x0000000000eeeeee in mysqld_main (argc=94, argv=0x4585448) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/mysqld.cc:5128 #4 0x0000000000ee5d84 in main (argc=9, argv=0x7ffce3222708) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/main.cc:32 Thread 15 (Thread 0x7fd17dec3700 (LWP 31846)): #0 0x00007fd18f990ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b81d2a in os_event::timed_wait (this=0x4bc5588, abstime=0x7fd17dec2e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #2 0x0000000001b823aa in os_event::wait_time_low (this=0x4bc5588, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #3 0x0000000001b82610 in os_event_wait_time_low (event=0x4bc5588, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:594 #4 0x0000000001b4a159 in lock_wait_timeout_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/lock/lock0wait.cc:497 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fd1761fc700 (LWP 31852)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b82a0b in os_event::wait (this=0x4700228) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #2 0x0000000001b81ea1 in os_event::wait_low (this=0x4700228, reset_sig_count=14) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #3 0x0000000001b82635 in os_event_wait_low (event=0x4700228, reset_sig_count=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:611 #4 0x0000000001c7f619 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2527 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fd188378700 (LWP 31858)): #0 0x00007fd18f993ec1 in sigwait () from /lib64/libpthread.so.0 #1 0x0000000000ee914d in signal_hand (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/mysqld.cc:2132 #2 0x0000000001ef92bc in pfs_spawn_thread (arg=0x5009020) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #3 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fd1882f6700 (LWP 31861)): #0 0x00007fd18e44100d in poll () from /lib64/libc.so.6 #1 0x0000000001f76a02 in vio_io_wait (vio=0x7fd13c0009c0, event=VIO_IO_EVENT_READ, timeout=28800000) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:797 #2 0x0000000001f75845 in vio_socket_io_wait (vio=0x7fd13c0009c0, event=VIO_IO_EVENT_READ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:88 #3 0x0000000001f75921 in vio_read (vio=0x7fd13c0009c0, buf=0x7fd13c00a410 "\a", size=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:143 #4 0x00000000014bcb2f in net_read_raw_loop (net=0x7fd13c002398, count=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:694 #5 0x00000000014bcd06 in net_read_packet_header (net=0x7fd13c002398) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:778 #6 0x00000000014bce13 in net_read_packet (net=0x7fd13c002398, complen=0x7fd1882f5ce8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:844 #7 0x00000000014bcfa6 in my_net_read (net=0x7fd13c002398) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:921 #8 0x00000000014d3b20 in Protocol_classic::read_packet (this=0x7fd13c001c18) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/protocol_classic.cc:815 #9 0x00000000014d4024 in Protocol_classic::get_command (this=0x7fd13c001c18, com_data=0x7fd1882f5e00, cmd=0x7fd1882f5e28) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/protocol_classic.cc:972 #10 0x00000000015b5c52 in do_command (thd=0x7fd13c000bc0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:971 #11 0x00000000016ee1cd in handle_connection (arg=0x5044e60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:313 #12 0x0000000001ef92bc in pfs_spawn_thread (arg=0x5053340) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #13 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fd17eac9700 (LWP 31844)): #0 0x00007fd18f990ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b81d2a in os_event::timed_wait (this=0x4700548, abstime=0x7fd17eac8930) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #2 0x0000000001b823aa in os_event::wait_time_low (this=0x4700548, time_in_usec=955000, reset_sig_count=19) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #3 0x0000000001b82610 in os_event_wait_time_low (event=0x4700548, time_in_usec=955000, reset_sig_count=19) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:594 #4 0x0000000001d6be17 in pc_sleep_if_needed (next_loop_time=32560513571, sig_count=19) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0flu.cc:2700 #5 0x0000000001d6d061 in buf_flush_page_cleaner_coordinator (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0flu.cc:3201 #6 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fd176bfd700 (LWP 31851)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b82a0b in os_event::wait (this=0x4700188) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #2 0x0000000001b81ea1 in os_event::wait_low (this=0x4700188, reset_sig_count=11) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #3 0x0000000001b82635 in os_event_wait_low (event=0x4700188, reset_sig_count=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:611 #4 0x0000000001c7f619 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2527 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fd15e1fc700 (LWP 31859)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000018285e8 in native_cond_wait (cond=0x2fc6d40 , mutex=0x2fc6d00 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #2 0x0000000001828627 in my_cond_wait (cond=0x2fc6d40 , mp=0x2fc6d00 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #3 0x0000000001828917 in inline_mysql_cond_wait (that=0x2fc6d40 , mutex=0x2fc6d00 , src_file=0x23ae330 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_gtid_persist.cc", src_line=885) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #4 0x000000000182b3bb in compress_gtid_table (p_thd=0x504f430) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_gtid_persist.cc:885 #5 0x0000000001ef92bc in pfs_spawn_thread (arg=0x5053340) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #6 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fd1896b8700 (LWP 31837)): #0 0x00007fd18e38b7da in sigwaitinfo () from /lib64/libc.so.6 #1 0x0000000001915431 in timer_notify_thread_func (arg=0x7ffce3221cc0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/mysys/posix_timers.c:89 #2 0x0000000001ef92bc in pfs_spawn_thread (arg=0x4696b50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #3 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fd15f5fe700 (LWP 31856)): #0 0x00007fd18f990ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b81d2a in os_event::timed_wait (this=0x4c45cc8, abstime=0x7fd15f5fdc90) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #2 0x0000000001b823aa in os_event::wait_time_low (this=0x4c45cc8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #3 0x0000000001b82610 in os_event_wait_time_low (event=0x4c45cc8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:594 #4 0x0000000001cf06ef in ib_wqueue_timedwait (wq=0x4c45b08, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/ut/ut0wqueue.cc:168 #5 0x0000000001e23dfc in fts_optimize_thread (arg=0x4c45b08) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fts/fts0opt.cc:2910 #6 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fd1757fb700 (LWP 31853)): #0 0x00007fd18f990705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001b82a0b in os_event::wait (this=0x47002c8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #2 0x0000000001b81ea1 in os_event::wait_low (this=0x47002c8, reset_sig_count=9) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #3 0x0000000001b82635 in os_event_wait_low (event=0x47002c8, reset_sig_count=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:611 #4 0x0000000001c7f619 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2527 #5 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fd17f4ca700 (LWP 31843)): #0 0x00007fd18f57f644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001b71819 in LinuxAIOHandler::collect (this=0x7fd17f4c9da0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #2 0x0000000001b71d54 in LinuxAIOHandler::poll (this=0x7fd17f4c9da0, m1=0x7fd17f4c9e90, m2=0x7fd17f4c9e88, request=0x7fd17f4c9e50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #3 0x0000000001b71edf in os_aio_linux_handler (global_segment=5, m1=0x7fd17f4c9e90, m2=0x7fd17f4c9e88, request=0x7fd17f4c9e50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #4 0x0000000001b76a19 in os_aio_handler (segment=5, m1=0x7fd17f4c9e90, m2=0x7fd17f4c9e88, request=0x7fd17f4c9e50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #5 0x0000000001dde2d7 in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #6 0x0000000001c83905 in io_handler_thread (arg=0x3031908 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #7 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fd177fff700 (LWP 31849)): #0 0x00007fd18f99399d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000001b82f5a in os_thread_sleep (tm=1000000) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0thread.cc:287 #2 0x0000000001c7efca in srv_master_sleep () at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2337 #3 0x0000000001c7f138 in srv_master_thread (arg=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2384 #4 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fd1812cd700 (LWP 31840)): #0 0x00007fd18f57f644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001b71819 in LinuxAIOHandler::collect (this=0x7fd1812ccda0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #2 0x0000000001b71d54 in LinuxAIOHandler::poll (this=0x7fd1812ccda0, m1=0x7fd1812cce90, m2=0x7fd1812cce88, request=0x7fd1812cce50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #3 0x0000000001b71edf in os_aio_linux_handler (global_segment=2, m1=0x7fd1812cce90, m2=0x7fd1812cce88, request=0x7fd1812cce50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #4 0x0000000001b76a19 in os_aio_handler (segment=2, m1=0x7fd1812cce90, m2=0x7fd1812cce88, request=0x7fd1812cce50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #5 0x0000000001dde2d7 in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #6 0x0000000001c83905 in io_handler_thread (arg=0x30318f0 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #7 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fd1826cf700 (LWP 31838)): #0 0x00007fd18f57f644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001b71819 in LinuxAIOHandler::collect (this=0x7fd1826ceda0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #2 0x0000000001b71d54 in LinuxAIOHandler::poll (this=0x7fd1826ceda0, m1=0x7fd1826cee90, m2=0x7fd1826cee88, request=0x7fd1826cee50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #3 0x0000000001b71edf in os_aio_linux_handler (global_segment=0, m1=0x7fd1826cee90, m2=0x7fd1826cee88, request=0x7fd1826cee50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #4 0x0000000001b76a19 in os_aio_handler (segment=0, m1=0x7fd1826cee90, m2=0x7fd1826cee88, request=0x7fd1826cee50) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #5 0x0000000001dde2d7 in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #6 0x0000000001c83905 in io_handler_thread (arg=0x30318e0 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #7 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fd188337700 (LWP 31860)): #0 0x00007fd18f991771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000190b2e1 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/mysys/stacktrace.c:261 #2 0x0000000000efe48d in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/signal_handler.cc:227 #3 #4 0x00007fd18e38a5d7 in raise () from /lib64/libc.so.6 #5 0x00007fd18e38bcc8 in abort () from /lib64/libc.so.6 #6 0x0000000001ceb333 in ut_dbg_assertion_failed (expr=0x246d1fe "header.m_version == 1", file=0x246b4e0 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc", line=8589) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/ut/ut0dbg.cc:75 #7 0x0000000001b7a55d in Compression::deserialize (dblwr_recover=false, src=0x7fd188266000 "", dst=0x0, dst_len=65536) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:8589 #8 0x0000000001b7a8bf in os_file_decompress_page (dblwr_recover=false, src=0x7fd188266000 "", dst=0x0, dst_len=65536) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:8730 #9 0x0000000001b703bd in os_file_io_complete (type=..., fh=57, buf=0x7fd188266000 "", scratch=0x0, src_len=65536, offset=196608, len=65536) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:1722 #10 0x0000000001b74dd8 in os_file_io (in_type=..., file=57, buf=0x7fd188266000, n=65536, offset=196608, err=0x7fd188331d0c) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:5475 #11 0x0000000001b756f5 in os_file_pread (type=..., file=57, buf=0x7fd188266000, n=65536, offset=196608, err=0x7fd188331d0c) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:5634 #12 0x0000000001b75876 in os_file_read_page (type=..., file=57, buf=0x7fd188266000, offset=196608, n=65536, o=0x0, exit_on_err=false) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:5673 #13 0x0000000001b76751 in os_file_read_no_error_handling_func (type=..., file=57, buf=0x7fd188266000, offset=196608, n=65536, o=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6091 #14 0x0000000001c1920e in pfs_os_file_read_no_error_handling_int_fd_func (type=..., file=57, buf=0x7fd188266000, offset=196608, n=65536, o=0x0, src_file=0x2491368 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0log.cc", src_line=3765) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/include/os0file.ic:394 #15 0x0000000001c26d66 in row_log_apply_ops (trx=0x7fd1886978c0, index=0x7fd1389cbe00, dup=0x7fd188332510, stage=0x7fd1389c5018) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0log.cc:3760 #16 0x0000000001c27b00 in row_log_apply (trx=0x7fd1886978c0, index=0x7fd1389cbe00, table=0x7fd1380b3d60, stage=0x7fd1389c5018) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0log.cc:3991 #17 0x0000000001bfcebc in row_merge_build_indexes (trx=0x7fd1886978c0, old_table=0x7fd138025d50, new_table=0x7fd138025d50, online=true, indexes=0x7fd1380b6e00, key_numbers=0x7fd1380b6e08, n_indexes=1, table=0x7fd1380b3d60, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=false, stage=0x7fd1389c5018, add_v=0x0, eval_table=0x7fd1380b3d60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/row/row0merge.cc:4579 #18 0x0000000001af9448 in ha_innobase::inplace_alter_table (this=0x7fd1380e7dd0, altered_table=0x7fd1380b3d60, ha_alter_info=0x7fd188333810) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/handler/handler0alter.cc:6438 #19 0x0000000001658973 in handler::ha_inplace_alter_table (this=0x7fd1380e7dd0, altered_table=0x7fd1380b3d60, ha_alter_info=0x7fd188333810) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/handler.h:3444 #20 0x00000000016500fd in mysql_inplace_alter_table (thd=0x7fd138000b70, table_list=0x7fd138006108, table=0x7fd1380e7410, altered_table=0x7fd1380b3d60, ha_alter_info=0x7fd188333810, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fd1883341a0, alter_ctx=0x7fd188332d70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_table.cc:7588 #21 0x000000000165540e in mysql_alter_table (thd=0x7fd138000b70, new_db=0x7fd138006690 "test", new_name=0x0, create_info=0x7fd188334c00, table_list=0x7fd138006108, alter_info=0x7fd188334d00) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_table.cc:9807 #22 0x00000000017dadb6 in Sql_cmd_alter_table::execute (this=0x7fd138006758, thd=0x7fd138000b70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_alter.cc:334 #23 0x00000000015c04eb in mysql_execute_command (thd=0x7fd138000b70, first_level=true) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:4845 #24 0x00000000015c25ff in mysql_parse (thd=0x7fd138000b70, parser_state=0x7fd188336690) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:5584 #25 0x00000000015b7155 in dispatch_command (thd=0x7fd138000b70, com_data=0x7fd188336e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1491 #26 0x00000000015b5fa0 in do_command (thd=0x7fd138000b70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1032 #27 0x00000000016ee1cd in handle_connection (arg=0x5044e60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:313 #28 0x0000000001ef92bc in pfs_spawn_thread (arg=0x5053340) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #29 0x00007fd18f98cdf5 in start_thread () from /lib64/libpthread.so.0 #30 0x00007fd18e44b60d in clone () from /lib64/libc.so.6 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 43 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.bug99572 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.20 ./mtr --debug-server bug99572 --mysqld='--default-storage-engine=innodb' Logging: ./mtr --debug-server bug99572 --mysqld=--default-storage-engine=innodb MySQL Version 8.0.20 Using default engine 'innodb' Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.20/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.bug99572 [ fail ] Test ended at 2020-05-14 14:12:53 CURRENT_TEST: main.bug99572 mysqltest: At line 72: Query 'reap' failed. ERROR 1034 (HY000): Incorrect key file for table 't_inplace_alter_tmp_file_02'; try to repair it safe_process[687]: Child process: 688, exit: 1 Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- # Reset innodb_sort_buffer_size to a lower value to make ALTER TABLE # use sort files. # restart: --innodb_sort_buffer_size=65536 CREATE TABLE t_inplace_alter_tmp_file_02( a INT PRIMARY KEY, b VARCHAR(100), c INT DEFAULT NULL, d VARCHAR(100), e INT, f INT, g INT, h INT, x INT, y INT, z INT) ENGINE=INNODB; # con1 used to signal at sync point # connection DEFAULT # > Case 1: Generate Row Log Files # ----------------------------------------------------------------------- # connection default # 1. Prepare data. CALL load_data("t_inplace_alter_tmp_file_02", 0, 20000); # 2. Alter table inplace. SET DEBUG_SYNC='RESET'; SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL do_dml WAIT_FOR go_on_execute EXECUTE 1'; ALTER TABLE t_inplace_alter_tmp_file_02 ADD INDEX ci(c);; # 3. Do concurrent DML. # connnection con1 SET DEBUG_SYNC='now WAIT_FOR do_dml'; CALL load_data("t_inplace_alter_tmp_file_02", 20000, 20000); SET DEBUG_SYNC='now SIGNAL go_on_execute'; ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-8.0.20/mysql-test/var/log/main.bug99572/bug99572.log' ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 121 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.bug99572 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