# 2019-11-26T12:12:13 INFO: Logfile for RQG Worker [51] # 2019-11-26T12:12:13 [61065] Using Log::Log4perl # 2019-11-26T12:12:13 [61065] DEBUG: rqg_home might be ->/home/mleich/work/RQG_mleich_N<- # 2019-11-26T12:12:13 [61065] INFO: Environment variable 'RQG_HOME' set to '/home/mleich/work/RQG_mleich_N' # DEBUG: $0 ->/home/mleich/work/RQG_mleich_N/rqg.pl<- # DEBUG: rqg_home_call ->/home/mleich/work/RQG_mleich_N<- # DEBUG: rqg_home_env ->/home/mleich/work/RQG_mleich_N<- # DEBUG: start_cwd ->/home/mleich/work/RQG_mleich_N<- # 2019-11-26T12:12:13 [61065] INFO: script_debug : '_nix_' # 2019-11-26T12:12:13 [61065] DEBUG: After reading command line options # 2019-11-26T12:12:13 [61065] INFO: RQG workdir : '/home/mleich/work/RQG_mleich_N/storage/1574766704/51' and infrastructure is prepared. # 2019-11-26T12:12:13 [61065] DEBUG: no_mask is defind. Therefore setting mask_level=0 , mask=0 and no_mask=undef. # 2019-11-26T12:12:13 [61065] Reading grammar from file '/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy'. # 2019-11-26T12:12:13 [61065] INFO: Sqltracing 'MarkErrors' enabled. # 2019-11-26T12:12:13 [61065] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2019-11-26T12:12:13 [61065] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2019-11-26T12:12:13 [61065] Starting # 2019-11-26T12:12:13 [61065] # /home/mleich/work/RQG_mleich_N/rqg.pl \ # 2019-11-26T12:12:13 [61065] # --duration=300 \ # 2019-11-26T12:12:13 [61065] # --queries=10000000 \ # 2019-11-26T12:12:13 [61065] # --threads=2 \ # 2019-11-26T12:12:13 [61065] # --no_mask \ # 2019-11-26T12:12:13 [61065] # --seed=random \ # 2019-11-26T12:12:13 [61065] # --gendata=conf/mariadb/table_stress.zz \ # 2019-11-26T12:12:13 [61065] # --engine=InnoDB \ # 2019-11-26T12:12:13 [61065] # --sqltrace=MarkErrors \ # 2019-11-26T12:12:13 [61065] # --rpl_mode=none \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--connect_timeout=60 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--lock-wait-timeout=86400 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--slave_net_timeout=60 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--net_write_timeout=60 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose-idle_transaction_timeout=0 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--log-bin \ # 2019-11-26T12:12:13 [61065] # --mysqld=--innodb-lock-wait-timeout=50 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--wait_timeout=28800 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose-table_lock_wait_timeout=50 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--innodb_adaptive_hash_index=off \ # 2019-11-26T12:12:13 [61065] # --mysqld=--log-output=none \ # 2019-11-26T12:12:13 [61065] # --mysqld=--innodb_stats_persistent=off \ # 2019-11-26T12:12:13 [61065] # --mysqld=--transaction-isolation=SERIALIZABLE \ # 2019-11-26T12:12:13 [61065] # --mysqld=--net_read_timeout=30 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose-idle_write_transaction_timeout=0 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--loose-innodb_page_size=4096 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--log_bin_trust_function_creators=1 \ # 2019-11-26T12:12:13 [61065] # --mysqld=--interactive_timeout=28800 \ # 2019-11-26T12:12:13 [61065] # --whitelist_statuses='STATUS_SERVER_CRASHED' \ # 2019-11-26T12:12:13 [61065] # --whitelist_patterns='mysqld: .{1,150}btr0pcur.cc:.{1,30} void btr_pcur_store_position.{1,40}: Assertion .index->table->instant. failed.','mysqld: .{1,150}btr0cur.cc.{1,30}dberr_t btr_cur_instant_init_low.{1,100}' \ # 2019-11-26T12:12:13 [61065] # --blacklist_statuses='STATUS_OK' \ # 2019-11-26T12:12:13 [61065] # --blacklist_patterns='Possible endless loop in grammar.','\[ERROR\] InnoDB: preallocating .{1,120} with error 28',' is truncated: expected core file size ' \ # 2019-11-26T12:12:13 [61065] # --reporters=Backtrace,Deadlock1,ErrorLog \ # 2019-11-26T12:12:13 [61065] # --validators=None \ # 2019-11-26T12:12:13 [61065] # --grammar=/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy \ # 2019-11-26T12:12:13 [61065] # --grammar=/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy \ # 2019-11-26T12:12:13 [61065] # --workdir=/home/mleich/work/RQG_mleich_N/storage/1574766704/51 \ # 2019-11-26T12:12:13 [61065] # --vardir=/dev/shm/vardir/1574766704/51 \ # 2019-11-26T12:12:13 [61065] # --mtr-build-thread=980 \ # 2019-11-26T12:12:13 [61065] # --basedir1=/work/10.5/bld_debug/ \ # 2019-11-26T12:12:13 [61065] # --script_debug=_nix_ # 2019-11-26T12:12:13 [61065] INFO: build_thread : 980 # 2019-11-26T12:12:13 [61065] INFO: master_port : 29600 slave_port : 29601 ports : 29600 29601 29602 MTR_BUILD_THREAD : 980 # 2019-11-26T12:12:13 [61065] INFO: Number of servers involved = 1. (0 means unknown) # 2019-11-26T12:12:13 [61065] INFO: Early RQG basedirs : ->undef<-->/work/10.5/bld_debug/<-->undef<-->undef<- # 2019-11-26T12:12:13 [61065] DEBUG: $basedirs[0] is not defined or eq ''. Setting it to $basedirs[1] '/work/10.5/bld_debug/'. # 2019-11-26T12:12:13 [61065] INFO: Final RQG basedirs : ->/work/10.5/bld_debug/<-->/work/10.5/bld_debug/<-->undef<-->undef<- # 2019-11-26T12:12:13 [61065] DEBUG: 'git --version 2>&1' exited with value 0 # 2019-11-26T12:12:13 [61065] GIT: $rqg_home('/home/mleich/work/RQG_mleich_N') HEAD -> experimental, origin/experimental 3ada9c262c9402960f5f7e0f98e1291cce5144b5 2019-11-23T18:59:59+01:00 # 2019-11-26T12:12:13 [61065] GIT: $basedirs[0]('/work/10.5/bld_debug/') HEAD -> 10.5, origin/HEAD, origin/10.5 25e2a556de2e125784d52a0c7ccda4fa6595df50 2019-11-26T10:15:03+02:00 # 2019-11-26T12:12:13 [61065] GIT: $basedirs[1]('/work/10.5/bld_debug/') HEAD -> 10.5, origin/HEAD, origin/10.5 25e2a556de2e125784d52a0c7ccda4fa6595df50 2019-11-26T10:15:03+02:00 # 2019-11-26T12:12:13 [61065] INFO: Final RQG vardirs : ->/dev/shm/vardir/1574766704/51<-->/dev/shm/vardir/1574766704/51/1<- # 2019-11-26T12:12:13 [61065] tmpdir in GenTest ->/dev/shm/vardir/1574766704/51/<- # 2019-11-26T12:12:13 [61065] tmpdir in DBServer ->/dev/shm/vardir/1574766704/51/<- # 2019-11-26T12:12:13 [61065] DEBUG: subdir_list : ->sql<-->libexec<-->bin<-->sbin<- # 2019-11-26T12:12:13 [61065] DEBUG: Basedirs : ->/work/10.5/bld_debug/<-->/work/10.5/bld_debug/<-->undef<-->undef<- # 2019-11-26T12:12:13 [61065] DEBUG: debug_server : ->undef<-->undef<-->undef<- # 2019-11-26T12:12:13 [61065] DEBUG: Server binary found : '/work/10.5/bld_debug//sql/mysqld'. # 2019-11-26T12:12:13 [61065] DEBUG: Server binary found : '/work/10.5/bld_debug//sql/mysqld'. # 2019-11-26T12:12:13 [61065] INFO: seed eq 'random'. Computation. seed : 31663 # 2019-11-26T12:12:13 [61065] INFO: Final command line: ->perl /home/mleich/work/RQG_mleich_N/rqg.pl --duration=300 --queries=10000000 --threads=2 --no_mask --gendata=conf/mariadb/table_stress.zz --engine=InnoDB --sqltrace=MarkErrors --rpl_mode=none --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--connect_timeout=60 --mysqld=--lock-wait-timeout=86400 --mysqld=--slave_net_timeout=60 --mysqld=--net_write_timeout=60 --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--log-bin --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--wait_timeout=28800 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--innodb_adaptive_hash_index=off --mysqld=--log-output=none --mysqld=--innodb_stats_persistent=off --mysqld=--transaction-isolation=SERIALIZABLE --mysqld=--net_read_timeout=30 --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--loose-innodb_page_size=4096 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--interactive_timeout=28800 --whitelist_statuses='STATUS_SERVER_CRASHED' --whitelist_patterns='mysqld: .{1,150}btr0pcur.cc:.{1,30} void btr_pcur_store_position.{1,40}: Assertion .index->table->instant. failed.','mysqld: .{1,150}btr0cur.cc.{1,30}dberr_t btr_cur_instant_init_low.{1,100}' --blacklist_statuses='STATUS_OK' --blacklist_patterns='Possible endless loop in grammar.','\[ERROR\] InnoDB: preallocating .{1,120} with error 28',' is truncated: expected core file size ' --reporters=Backtrace,Deadlock1,ErrorLog --validators=None --grammar=/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy --grammar=/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy --workdir=/home/mleich/work/RQG_mleich_N/storage/1574766704/51 --vardir=/dev/shm/vardir/1574766704/51 --mtr-build-thread=980 --basedir1=/work/10.5/bld_debug/ --script_debug=_nix_ --seed=31663<- # 2019-11-26T12:12:13 [61065] MATCHING: Region start ===================== # 2019-11-26T12:12:13 [61065] DEBUG: rpl_mode is 'none' # 2019-11-26T12:12:13 [61065] DEBUG: max_id is 0 # 2019-11-26T12:12:13 [61065] Found source directory at /work/10.5 # 2019-11-26T12:12:13 [61065] Creating MySQL 10.5.0 database at /dev/shm/vardir/1574766704/51/1/data # 2019-11-26T12:12:13 [61065] Bootstrap command: cat "/dev/shm/vardir/1574766704/51/1/boot.sql" | "/work/10.5/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/work/10.5/bld_debug/" "--lc-messages-dir=/work/10.5/bld_debug//sql/share" "--character-sets-dir=/work/10.5/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1574766704/51/1/tmp" "--datadir=/dev/shm/vardir/1574766704/51/1/data" "--loose-idle_readonly_transaction_timeout=0" "--connect_timeout=60" "--lock-wait-timeout=86400" "--slave_net_timeout=60" "--net_write_timeout=60" "--loose_innodb_lock_schedule_algorithm=fcfs" "--loose-idle_transaction_timeout=0" "--loose-debug_assert_on_not_freed_memory=0" "--log-bin" "--innodb-lock-wait-timeout=50" "--wait_timeout=28800" "--loose-table_lock_wait_timeout=50" "--innodb_adaptive_hash_index=off" "--log-output=none" "--innodb_stats_persistent=off" "--transaction-isolation=SERIALIZABLE" "--net_read_timeout=30" "--loose-idle_write_transaction_timeout=0" "--loose-innodb_page_size=4096" "--log_bin_trust_function_creators=1" "--interactive_timeout=28800" "--sql-mode=no_engine_substitution" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--loose-server-audit-logging=OFF" "--bootstrap" # 2019-11-26T12:12:16 [61065] INFO: Starting MySQL 10.5.0: "/work/10.5/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/work/10.5/bld_debug/" "--lc-messages-dir=/work/10.5/bld_debug//sql/share" "--character-sets-dir=/work/10.5/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1574766704/51/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1574766704/51/1/data" "--max-allowed-packet=128Mb" "--port=29600" "--socket=/dev/shm/vardir/1574766704/51/1/mysql.sock" "--pid-file=/dev/shm/vardir/1574766704/51/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1574766704/51/1/mysql.log" "--loose-idle_readonly_transaction_timeout=0" "--connect_timeout=60" "--lock-wait-timeout=86400" "--slave_net_timeout=60" "--net_write_timeout=60" "--loose_innodb_lock_schedule_algorithm=fcfs" "--loose-idle_transaction_timeout=0" "--loose-debug_assert_on_not_freed_memory=0" "--log-bin" "--innodb-lock-wait-timeout=50" "--wait_timeout=28800" "--loose-table_lock_wait_timeout=50" "--innodb_adaptive_hash_index=off" "--log-output=none" "--innodb_stats_persistent=off" "--transaction-isolation=SERIALIZABLE" "--net_read_timeout=30" "--loose-idle_write_transaction_timeout=0" "--loose-innodb_page_size=4096" "--log_bin_trust_function_creators=1" "--interactive_timeout=28800" "--sql-mode=no_engine_substitution" # 2019-11-26T12:12:16 [61065] MySQL Version: 10.5.0 # 2019-11-26T12:12:16 [61065] Binary: /work/10.5/bld_debug//sql/mysqld # 2019-11-26T12:12:16 [61065] Type: Debug # 2019-11-26T12:12:16 [61065] Datadir: /dev/shm/vardir/1574766704/51/1/data # 2019-11-26T12:12:16 [61065] Tmpdir: /dev/shm/vardir/1574766704/51/1/tmp # 2019-11-26T12:12:16 [61065] Corefile: /dev/shm/vardir/1574766704/51/1/data/core.61584 # 2019-11-26T12:12:16 [61065] Connecting to 29600 # 2019-11-26T12:12:16 [61065] DEBUG: dsns[0] defined. # 2019-11-26T12:12:16 [61065] --------------------------------------------------------------- # 2019-11-26T12:12:16 [61065] debug_server => ['undef', 'undef', 'undef'] # 2019-11-26T12:12:16 [61065] dsn => ['dbi:mysql:host=127.0.0.1:port=29600:user=root:database=test:mysql_local_infile=1'] # 2019-11-26T12:12:16 [61065] duration => 300 # 2019-11-26T12:12:16 [61065] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-11-26T12:12:16 [61065] gendata => /home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.zz # 2019-11-26T12:12:16 [61065] generator => FromGrammar # 2019-11-26T12:12:16 [61065] grammar => /home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.yy # 2019-11-26T12:12:16 [61065] logfile => /home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.log # 2019-11-26T12:12:16 [61065] mask => 0 # 2019-11-26T12:12:16 [61065] mask-level => 0 # 2019-11-26T12:12:16 [61065] queries => 10000000 # 2019-11-26T12:12:16 [61065] reporters => ['Backtrace', 'Deadlock1', 'ErrorLog'] # 2019-11-26T12:12:16 [61065] rpl_mode => none # 2019-11-26T12:12:16 [61065] seed => 31663 # 2019-11-26T12:12:16 [61065] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x55c57b139098)'] # 2019-11-26T12:12:16 [61065] sqltrace => MarkErrors # 2019-11-26T12:12:16 [61065] threads => 2 # 2019-11-26T12:12:16 [61065] validators => ['None'] # 2019-11-26T12:12:16 [61065] vcols => ['undef', 'undef', 'undef'] # 2019-11-26T12:12:16 [61065] views => ['undef', 'undef', 'undef'] # 2019-11-26T12:12:16 [61065] --------------------------------------------------------------- # 2019-11-26T12:12:16 [61065] ------------------------------- # 2019-11-26T12:12:16 [61065] Configuration # 2019-11-26T12:12:16 [61065] debug_server => ['undef', 'undef', 'undef'] # 2019-11-26T12:12:16 [61065] dsn => ['dbi:mysql:host=127.0.0.1:port=29600:user=root:database=test:mysql_local_infile=1'] # 2019-11-26T12:12:16 [61065] duration => 300 # 2019-11-26T12:12:16 [61065] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2019-11-26T12:12:16 [61065] gendata => /home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.zz # 2019-11-26T12:12:16 [61065] generator => FromGrammar # 2019-11-26T12:12:16 [61065] grammar => /home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.yy # 2019-11-26T12:12:16 [61065] logfile => /home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.log # 2019-11-26T12:12:16 [61065] mask => 0 # 2019-11-26T12:12:16 [61065] mask-level => 0 # 2019-11-26T12:12:16 [61065] queries => 10000000 # 2019-11-26T12:12:16 [61065] reporters => ['Backtrace', 'Deadlock1', 'ErrorLog'] # 2019-11-26T12:12:16 [61065] rpl_mode => none # 2019-11-26T12:12:16 [61065] seed => 31663 # 2019-11-26T12:12:16 [61065] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x55c57b139098)'] # 2019-11-26T12:12:16 [61065] sqltrace => MarkErrors # 2019-11-26T12:12:16 [61065] threads => 2 # 2019-11-26T12:12:16 [61065] validators => ['None'] # 2019-11-26T12:12:16 [61065] vcols => ['undef', 'undef', 'undef'] # 2019-11-26T12:12:16 [61065] views => ['undef', 'undef', 'undef'] # 2019-11-26T12:12:16 [61065] INFO: Begin of GenData activity # 2019-11-26T12:12:16 [61065] INFO: Starting GenTest::App::Gendata [61065] SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' /* E_R Gendata QNO 1 CON_ID 6 */ ; [61065] SET SQL_MODE= CONCAT(@@sql_mode,',NO_ENGINE_SUBSTITUTION') /* E_R Gendata QNO 2 CON_ID 6 */ ; [61065] SET DEFAULT_STORAGE_ENGINE= 'InnoDB' /* E_R Gendata QNO 3 CON_ID 6 */ ; [61065] CREATE SCHEMA /*!IF NOT EXISTS*/ test /* E_R Gendata QNO 4 CON_ID 6 */ ; [61065] USE test /* E_R Gendata QNO 5 CON_ID 6 */ ; # 2019-11-26T12:12:16 [61065] Creating MySQL table: test.table0_innodb_int; engine: innodb; rows: 0 . [61065] DROP TABLE /*! IF EXISTS*/ table0_innodb_int /* E_R Gendata QNO 6 CON_ID 6 */ ; [61065] CREATE TABLE `table0_innodb_int` ( pk int, `col_int` int, /*Indices*/ primary key (pk)) ENGINE=innodb /* E_R Gendata QNO 7 CON_ID 6 */ ; [61065] ALTER TABLE `table0_innodb_int` DISABLE KEYS /* E_R Gendata QNO 8 CON_ID 6 */ ; [61065] COMMIT /* E_R Gendata QNO 9 CON_ID 6 */ ; [61065] ALTER TABLE `table0_innodb_int` ENABLE KEYS /* E_R Gendata QNO 10 CON_ID 6 */ ; [61065] COMMIT /* E_R Gendata QNO 11 CON_ID 6 */ ; [61065] USE test /* E_R Gendata QNO 12 CON_ID 6 */ ; # 2019-11-26T12:12:16 [61065] INFO: Finishing GenTest::App::Gendata # 2019-11-26T12:12:16 [61065] INFO: End of GenData activity # 2019-11-26T12:12:16 [61065] GenData returned status STATUS_OK (0) # 2019-11-26T12:12:16 [61065] INFO: RQG GenData runtime in s : 0 # 2019-11-26T12:12:16 [61065] INFO: GenTest: Start of running queries : 1574766738 # 2019-11-26T12:12:16 [61065] Reading grammar from file '/home/mleich/work/RQG_mleich_N/storage/1574766704/51/rqg.yy'. # 2019-11-26T12:12:16 [61065] Reporters (for Simplifier): ->Backtrace<->Deadlock1<->ErrorLog<->None<->ServerDead<- # 2019-11-26T12:12:17 [61065] INFO: Reporter 'Backtrace' added. # 2019-11-26T12:12:17 [61065] INFO: Reporter 'Deadlock1' added. # 2019-11-26T12:12:17 [61065] INFO: Reporter 'ErrorLog' added. # 2019-11-26T12:12:17 [61065] INFO: Reporter 'ServerDead' added. # 2019-11-26T12:12:17 [61065] Validators (for Simplifier): ->None<- # 2019-11-26T12:12:17 [61065] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=29600:user=root:database=test:mysql_local_infile=1 # 2019-11-26T12:12:17 [61065] Starting 2 processes, 10000000 queries each, duration 300 seconds. # 2019-11-26T12:12:17 [61065] GenTest::ErrorFilter(61871) started [61874] SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' /* E_R Thread1 QNO 15 CON_ID 12 */ ; [61875] SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' /* E_R Thread2 QNO 15 CON_ID 13 */ ; # 2019-11-26T12:12:18 [61875] INFO: Thread2 : Mixer created. # 2019-11-26T12:12:18 [61874] INFO: Thread1 : Mixer created. # [61875] [sqltrace] ERROR 1146: ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 16 CON_ID 13 */ ; [61874] CREATE TABLE IF NOT EXISTS t3 ( col1 INT, col_text_g TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)), col_string TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)), col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = Compact /* E_R Thread1 QNO 16 CON_ID 12 */ ; [61875] ALTER TABLE t3 DROP COLUMN col_string /* E_R Thread2 QNO 17 CON_ID 13 */ ; [61874] ALTER TABLE t3 DROP COLUMN col_text_g /* E_R Thread1 QNO 17 CON_ID 12 */ ; [61875] ALTER TABLE t3 ADD PRIMARY KEY IF NOT EXISTS ( col_text(9) ) /* E_R Thread2 QNO 18 CON_ID 13 */ ; # [61874] [sqltrace] ERROR 1091: ALTER TABLE t3 DROP COLUMN col_text_g /* E_R Thread1 QNO 18 CON_ID 12 */ ; # [61875] [sqltrace] ERROR 1091: ALTER TABLE t3 DROP COLUMN col_string /* E_R Thread2 QNO 19 CON_ID 13 */ ; # 2019-11-26T12:12:18 [61871] ErrorFilter: Query: ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 16 CON_ID 13 */ failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. [61875] ALTER TABLE t3 ADD PRIMARY KEY IF NOT EXISTS ( col_text(9) ) /* E_R Thread2 QNO 20 CON_ID 13 */ ; # 2019-11-26T12:12:18 [61871] ErrorFilter: Query: ALTER TABLE t3 DROP COLUMN col_string /* E_R Thread2 QNO 19 CON_ID 13 */ failed: 1091 Can't DROP COLUMN `col_string`; check that it exists. Further errors of this kind will be suppressed. # [61874] [sqltrace] ERROR 1091: ALTER TABLE t3 DROP COLUMN col_text_g /* E_R Thread1 QNO 19 CON_ID 12 */ ; [61875] ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 21 CON_ID 13 */ ; # 2019-11-26T12:12:18 [61873] INFO: Periodic reporting process at begin of activity # [61875] [sqltrace] ERROR 2013: ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 22 CON_ID 13 */ ; # [61874] [sqltrace] ERROR 2013: ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */ ; # 2019-11-26T12:12:18 [61875] Executor::MySQL::execute: Query: ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 22 CON_ID 13 */ failed: 2013 Lost connection to MySQL server during query # 2019-11-26T12:12:18 [61874] Executor::MySQL::execute: Query: ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */ failed: 2013 Lost connection to MySQL server during query # 2019-11-26T12:12:18 [61873] ERROR: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29600:user=root:database=test:mysql_local_infile=1 failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 104 # 2019-11-26T12:12:18 [61873] ERROR: Reporter 'Deadlock': Will return status 101. # 2019-11-26T12:12:18 [61873] ERROR: Periodic reporting process: Critical status STATUS_SERVER_CRASHED got. Will exit with that. # 2019-11-26T12:12:18 [61873] GenTest: child 61873 is being stopped with status STATUS_SERVER_CRASHED # 2019-11-26T12:12:22 [61065] Process with pid 61873 for periodic reporter ended with status STATUS_SERVER_CRASHED # 2019-11-26T12:12:22 [61065] Killing remaining worker process with pid 61875... # 2019-11-26T12:12:22 [61065] Killing remaining worker process with pid 61874... # 2019-11-26T12:12:22 [61065] Kill GenTest::ErrorFilter(61871) # 2019-11-26T12:12:22 [61065] INFO: GenTest: Effective duration in s : 4 # 2019-11-26T12:12:22 [61065] Server crash reported, initiating post-crash analysis... # 2019-11-26T12:12:22 [61065] INFO: Reporter 'Backtrace' ------------------------------ Begin # 2019-11-26T12:12:22 [61065] datadir is /dev/shm/vardir/1574766704/51/1/data/ # 2019-11-26T12:12:22 [61065] binary is /work/10.5/bld_debug/sql/mysqld # 2019-11-26T12:12:22 [61065] bindir is /work/10.5/bld_debug/sql # 2019-11-26T12:12:22 [61065] error_log is /dev/shm/vardir/1574766704/51/1/data/../mysql.err # 2019-11-26T12:12:22 [61065] pid_file is /dev/shm/vardir/1574766704/51/1/mysql.pid # 2019-11-26T12:12:24 [61065] INFO: Reporter::Backtrace The pid_file '/dev/shm/vardir/1574766704/51/1/mysql.pid' did not disappear. # 2019-11-26T12:12:25 [61065] INFO: The core file name computed is '/dev/shm/vardir/1574766704/51/1/data//core'. # 2019-11-26T12:12:25 [61065] INFO: The core file '/dev/shm/vardir/1574766704/51/1/data/core' exists. 62 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. 89 abort.c: No such file or directory. # 2019-11-26T12:12:30 [61065] [New LWP 61711] # 2019-11-26T12:12:30 [61065] [New LWP 61601] # 2019-11-26T12:12:30 [61065] [New LWP 61667] # 2019-11-26T12:12:30 [61065] [New LWP 61676] # 2019-11-26T12:12:30 [61065] [New LWP 61663] # 2019-11-26T12:12:30 [61065] [New LWP 61674] # 2019-11-26T12:12:30 [61065] [New LWP 61679] # 2019-11-26T12:12:30 [61065] [New LWP 61677] # 2019-11-26T12:12:30 [61065] [New LWP 61678] # 2019-11-26T12:12:30 [61065] [New LWP 61668] # 2019-11-26T12:12:30 [61065] [New LWP 61584] # 2019-11-26T12:12:30 [61065] [New LWP 61709] # 2019-11-26T12:12:30 [61065] [New LWP 61675] # 2019-11-26T12:12:30 [61065] [New LWP 61877] # 2019-11-26T12:12:30 [61065] [New LWP 61613] # 2019-11-26T12:12:30 [61065] [Thread debugging using libthread_db enabled] # 2019-11-26T12:12:30 [61065] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". # 2019-11-26T12:12:30 [61065] Core was generated by `/work/10.5/bld_debug//sql/mysqld --no-defaults --basedir=/work/10.5/bld_debug/'. # 2019-11-26T12:12:30 [61065] Program terminated with signal SIGABRT, Aborted. # 2019-11-26T12:12:30 [61065] #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 # 2019-11-26T12:12:30 [61065] [Current thread is 1 (Thread 0x7f82682a8700 (LWP 61711))] # 2019-11-26T12:12:30 [61065] #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 # 2019-11-26T12:12:30 [61065] #1 0x000056390752f1bb in my_write_core (sig=6) at /work/10.5/mysys/stacktrace.c:518 # 2019-11-26T12:12:30 [61065] #2 0x0000563906c34bc9 in handle_fatal_signal (sig=6) at /work/10.5/sql/signal_handler.cc:343 # 2019-11-26T12:12:30 [61065] #3 # 2019-11-26T12:12:30 [61065] #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58 # 2019-11-26T12:12:30 [61065] #5 0x00007f82685ed37a in __GI_abort () at abort.c:89 # 2019-11-26T12:12:30 [61065] #6 0x00007f82685e3b47 in __assert_fail_base (fmt=, assertion=assertion@entry=0x563907a12358 "index->n_core_fields + n_add >= index->n_fields", file=file@entry=0x563907a11ec0 "/work/10.5/storage/innobase/btr/btr0cur.cc", line=line@entry=507, function=function@entry=0x563907a15ec0 "dberr_t btr_cur_instant_init_low(dict_index_t*, mtr_t*)") at assert.c:92 # 2019-11-26T12:12:30 [61065] #7 0x00007f82685e3bf2 in __GI___assert_fail (assertion=0x563907a12358 "index->n_core_fields + n_add >= index->n_fields", file=0x563907a11ec0 "/work/10.5/storage/innobase/btr/btr0cur.cc", line=507, function=0x563907a15ec0 "dberr_t btr_cur_instant_init_low(dict_index_t*, mtr_t*)") at assert.c:101 # 2019-11-26T12:12:30 [61065] #8 0x00005639072fa2cf in btr_cur_instant_init_low (index=0x7f82182ff5b8, mtr=0x7f82682a15c0) at /work/10.5/storage/innobase/btr/btr0cur.cc:507 # 2019-11-26T12:12:30 [61065] #9 0x00005639072fadb0 in btr_cur_instant_init (table=0x7f82182ff098) at /work/10.5/storage/innobase/btr/btr0cur.cc:659 # 2019-11-26T12:12:30 [61065] #10 0x00005639073b801a in dict_load_table_one (name=..., ignore_err=DICT_ERR_IGNORE_NONE, fk_tables=std::deque with 0 elements) at /work/10.5/storage/innobase/dict/dict0load.cc:3011 # 2019-11-26T12:12:30 [61065] #11 0x00005639073b6d2e in dict_load_table (name=0x7f82682a2aa0 "test/t3", ignore_err=DICT_ERR_IGNORE_NONE) at /work/10.5/storage/innobase/dict/dict0load.cc:2743 # 2019-11-26T12:12:30 [61065] #12 0x000056390739b1f7 in dict_table_open_on_name (table_name=0x7f82682a2aa0 "test/t3", dict_locked=1, try_drop=1, ignore_err=DICT_ERR_IGNORE_NONE) at /work/10.5/storage/innobase/dict/dict0dict.cc:886 # 2019-11-26T12:12:30 [61065] #13 0x000056390708fff3 in ha_innobase::commit_inplace_alter_table (this=0x7f82183036f0, altered_table=0x7f82682a4010, ha_alter_info=0x7f82682a3f80, commit=true) at /work/10.5/storage/innobase/handler/handler0alter.cc:11151 # 2019-11-26T12:12:30 [61065] #14 0x0000563906c43c95 in handler::ha_commit_inplace_alter_table (this=0x7f82183036f0, altered_table=0x7f82682a4010, ha_alter_info=0x7f82682a3f80, commit=true) at /work/10.5/sql/handler.cc:4557 # 2019-11-26T12:12:30 [61065] #15 0x00005639069ed344 in mysql_inplace_alter_table (thd=0x7f8218000a98, table_list=0x7f8218013b58, table=0x7f82183028e8, altered_table=0x7f82682a4010, ha_alter_info=0x7f82682a3f80, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f82682a4df0, alter_ctx=0x7f82682a5920) at /work/10.5/sql/sql_table.cc:7764 # 2019-11-26T12:12:30 [61065] #16 0x00005639069f3e23 in mysql_alter_table (thd=0x7f8218000a98, new_db=0x7f8218005270, new_name=0x7f8218005678, create_info=0x7f82682a6510, table_list=0x7f8218013b58, alter_info=0x7f82682a6450, order_num=0, order=0x0, ignore=false) at /work/10.5/sql/sql_table.cc:10079 # 2019-11-26T12:12:30 [61065] #17 0x0000563906a965cf in Sql_cmd_alter_table::execute (this=0x7f82180146e0, thd=0x7f8218000a98) at /work/10.5/sql/sql_alter.cc:523 # 2019-11-26T12:12:30 [61065] #18 0x00005639068fd19f in mysql_execute_command (thd=0x7f8218000a98) at /work/10.5/sql/sql_parse.cc:5959 # 2019-11-26T12:12:30 [61065] #19 0x00005639069033c6 in mysql_parse (thd=0x7f8218000a98, rawbuf=0x7f8218013980 "ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */", length=146, parser_state=0x7f82682a75d0, is_com_multi=false, is_next_command=false) at /work/10.5/sql/sql_parse.cc:7988 # 2019-11-26T12:12:30 [61065] #20 0x00005639068ee461 in dispatch_command (command=COM_QUERY, thd=0x7f8218000a98, packet=0x7f8218007ec9 "ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */ ", packet_length=147, is_com_multi=false, is_next_command=false) at /work/10.5/sql/sql_parse.cc:1846 # 2019-11-26T12:12:30 [61065] #21 0x00005639068ecbbb in do_command (thd=0x7f8218000a98) at /work/10.5/sql/sql_parse.cc:1364 # 2019-11-26T12:12:30 [61065] #22 0x0000563906a8c50e in do_handle_one_connection (connect=0x56390b773f58, put_in_cache=true) at /work/10.5/sql/sql_connect.cc:1422 # 2019-11-26T12:12:30 [61065] #23 0x0000563906a8c242 in handle_one_connection (arg=0x56390b773f58) at /work/10.5/sql/sql_connect.cc:1319 # 2019-11-26T12:12:30 [61065] #24 0x00007f82694306da in start_thread (arg=0x7f82682a8700) at pthread_create.c:456 # 2019-11-26T12:12:30 [61065] #25 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:30 [61065] #5 0x00007f82685ed37a in __GI_abort () at abort.c:89 # 2019-11-26T12:12:30 [61065] 84 in abort.c 62 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. # 2019-11-26T12:12:38 [61065] [New LWP 61711] # 2019-11-26T12:12:38 [61065] [New LWP 61601] # 2019-11-26T12:12:38 [61065] [New LWP 61667] # 2019-11-26T12:12:38 [61065] [New LWP 61676] # 2019-11-26T12:12:38 [61065] [New LWP 61663] # 2019-11-26T12:12:38 [61065] [New LWP 61674] # 2019-11-26T12:12:38 [61065] [New LWP 61679] # 2019-11-26T12:12:38 [61065] [New LWP 61677] # 2019-11-26T12:12:38 [61065] [New LWP 61678] # 2019-11-26T12:12:38 [61065] [New LWP 61668] # 2019-11-26T12:12:38 [61065] [New LWP 61584] # 2019-11-26T12:12:38 [61065] [New LWP 61709] # 2019-11-26T12:12:38 [61065] [New LWP 61675] # 2019-11-26T12:12:38 [61065] [New LWP 61877] # 2019-11-26T12:12:38 [61065] [New LWP 61613] # 2019-11-26T12:12:38 [61065] [Thread debugging using libthread_db enabled] # 2019-11-26T12:12:38 [61065] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". # 2019-11-26T12:12:38 [61065] Core was generated by `/work/10.5/bld_debug//sql/mysqld --no-defaults --basedir=/work/10.5/bld_debug/'. # 2019-11-26T12:12:38 [61065] Program terminated with signal SIGABRT, Aborted. # 2019-11-26T12:12:38 [61065] #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 # 2019-11-26T12:12:38 [61065] [Current thread is 1 (Thread 0x7f82682a8700 (LWP 61711))] # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 15 (Thread 0x7f8253ffe700 (LWP 61613)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 # 2019-11-26T12:12:38 [61065] #1 0x0000563907534b7b in safe_cond_timedwait (cond=0x563908bfa280 , mp=0x563908bfa1c0 , abstime=0x7f8253ffde50, file=0x5639078eefa0 "/work/10.5/include/mysql/psi/mysql_thread.h", line=1215) at /work/10.5/mysys/thr_mutex.c:546 # 2019-11-26T12:12:38 [61065] #2 0x0000563906eeb6cb in inline_mysql_cond_timedwait (that=0x563908bfa280 , mutex=0x563908bfa1c0 , abstime=0x7f8253ffde50, src_file=0x5639078eefd0 "/work/10.5/storage/maria/ma_servicethread.c", src_line=116) at /work/10.5/include/mysql/psi/mysql_thread.h:1215 # 2019-11-26T12:12:38 [61065] #3 0x0000563906eebbb8 in my_service_thread_sleep (control=0x5639081e8ba0 , sleep_time=29000000000) at /work/10.5/storage/maria/ma_servicethread.c:115 # 2019-11-26T12:12:38 [61065] #4 0x0000563906edf992 in ma_checkpoint_background (arg=0x1e) at /work/10.5/storage/maria/ma_checkpoint.c:707 # 2019-11-26T12:12:38 [61065] #5 0x00007f82694306da in start_thread (arg=0x7f8253ffe700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #6 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 14 (Thread 0x7f82501f8700 (LWP 61877)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 # 2019-11-26T12:12:38 [61065] #1 0x0000563907534b7b in safe_cond_timedwait (cond=0x7f820c000c68, mp=0x7f820c000bb8, abstime=0x7f82501f39a0, file=0x563907710ec0 "/work/10.5/include/mysql/psi/mysql_thread.h", line=1215) at /work/10.5/mysys/thr_mutex.c:546 # 2019-11-26T12:12:38 [61065] #2 0x0000563906a98ea8 in inline_mysql_cond_timedwait (that=0x7f820c000c68, mutex=0x7f820c000bb8, abstime=0x7f82501f39a0, src_file=0x5639077114e6 "/work/10.5/sql/mdl.cc", src_line=1148) at /work/10.5/include/mysql/psi/mysql_thread.h:1215 # 2019-11-26T12:12:38 [61065] #3 0x0000563906a9a401 in MDL_wait::timed_wait (this=0x7f820c000bb8, owner=0x7f820c000b68, abs_timeout=0x7f82501f39a0, set_status_on_timeout=false, wait_state_name=0x5639081dd110 ) at /work/10.5/sql/mdl.cc:1148 # 2019-11-26T12:12:38 [61065] #4 0x0000563906a9bfe8 in MDL_context::acquire_lock (this=0x7f820c000bb8, mdl_request=0x7f820c011ac0, lock_wait_timeout=86400) at /work/10.5/sql/mdl.cc:2326 # 2019-11-26T12:12:38 [61065] #5 0x0000563906a9c4e5 in MDL_context::acquire_locks (this=0x7f820c000bb8, mdl_requests=0x7f82501f3ae0, lock_wait_timeout=86400) at /work/10.5/sql/mdl.cc:2447 # 2019-11-26T12:12:38 [61065] #6 0x000056390685112d in lock_table_names (thd=0x7f820c000a98, options=..., tables_start=0x7f820c011678, tables_end=0x0, lock_wait_timeout=86400, flags=0) at /work/10.5/sql/sql_base.cc:4073 # 2019-11-26T12:12:38 [61065] #7 0x000056390685174a in open_tables (thd=0x7f820c000a98, options=..., start=0x7f82501f3e58, counter=0x7f82501f3e94, flags=0, prelocking_strategy=0x7f82501f3eb0) at /work/10.5/sql/sql_base.cc:4279 # 2019-11-26T12:12:38 [61065] #8 0x00005639069d74dd in open_tables (thd=0x7f820c000a98, tables=0x7f82501f3e58, counter=0x7f82501f3e94, flags=0, prelocking_strategy=0x7f82501f3eb0) at /work/10.5/sql/sql_base.h:259 # 2019-11-26T12:12:38 [61065] #9 0x00005639069f208b in mysql_alter_table (thd=0x7f820c000a98, new_db=0x7f820c005270, new_name=0x7f820c005678, create_info=0x7f82501f6510, table_list=0x7f820c011678, alter_info=0x7f82501f6450, order_num=0, order=0x0, ignore=false) at /work/10.5/sql/sql_table.cc:9412 # 2019-11-26T12:12:38 [61065] #10 0x0000563906a965cf in Sql_cmd_alter_table::execute (this=0x7f820c011e48, thd=0x7f820c000a98) at /work/10.5/sql/sql_alter.cc:523 # 2019-11-26T12:12:38 [61065] #11 0x00005639068fd19f in mysql_execute_command (thd=0x7f820c000a98) at /work/10.5/sql/sql_parse.cc:5959 # 2019-11-26T12:12:38 [61065] #12 0x00005639069033c6 in mysql_parse (thd=0x7f820c000a98, rawbuf=0x7f820c011500 "ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 22 CON_ID 13 */", length=101, parser_state=0x7f82501f75d0, is_com_multi=false, is_next_command=false) at /work/10.5/sql/sql_parse.cc:7988 # 2019-11-26T12:12:38 [61065] #13 0x00005639068ee461 in dispatch_command (command=COM_QUERY, thd=0x7f820c000a98, packet=0x7f820c0080c9 "ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_string_copy TEXT FIRST /* E_R Thread2 QNO 22 CON_ID 13 */ ", packet_length=102, is_com_multi=false, is_next_command=false) at /work/10.5/sql/sql_parse.cc:1846 # 2019-11-26T12:12:38 [61065] #14 0x00005639068ecbbb in do_command (thd=0x7f820c000a98) at /work/10.5/sql/sql_parse.cc:1364 # 2019-11-26T12:12:38 [61065] #15 0x0000563906a8c50e in do_handle_one_connection (connect=0x56390b773f58, put_in_cache=true) at /work/10.5/sql/sql_connect.cc:1422 # 2019-11-26T12:12:38 [61065] #16 0x0000563906a8c242 in handle_one_connection (arg=0x56390b773f58) at /work/10.5/sql/sql_connect.cc:1319 # 2019-11-26T12:12:38 [61065] #17 0x00007f82694306da in start_thread (arg=0x7f82501f8700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #18 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 13 (Thread 0x7f8239cfc700 (LWP 61675)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 # 2019-11-26T12:12:38 [61065] #1 0x000056390748b06d in __gthread_cond_timedwait (__cond=0x56390978dfb0, __mutex=0x56390977e6b0, __abs_timeout=0x7f8239cfbc40) at /usr/include/x86_64-linux-gnu/c++/6/bits/gthr-default.h:871 # 2019-11-26T12:12:38 [61065] #2 0x000056390748f049 in std::condition_variable::__wait_until_impl > > (this=0x56390978dfb0, __lock=..., __atime=...) at /usr/include/c++/6/condition_variable:166 # 2019-11-26T12:12:38 [61065] #3 0x000056390748e169 in std::condition_variable::wait_until > > (this=0x56390978dfb0, __lock=..., __atime=...) at /usr/include/c++/6/condition_variable:106 # 2019-11-26T12:12:38 [61065] #4 0x000056390748d857 in std::condition_variable::wait_for > (this=0x56390978dfb0, __lock=..., __rtime=...) at /usr/include/c++/6/condition_variable:138 # 2019-11-26T12:12:38 [61065] #5 0x000056390748b241 in tpool::thread_pool_generic::wait_for_tasks (this=0x56390977e5a0, lk=..., thread_data=0x56390978dfb0) at /work/10.5/tpool/tpool_generic.cc:406 # 2019-11-26T12:12:38 [61065] #6 0x000056390748b381 in tpool::thread_pool_generic::get_task (this=0x56390977e5a0, thread_var=0x56390978dfb0, t=0x7f8239cfbd68) at /work/10.5/tpool/tpool_generic.cc:455 # 2019-11-26T12:12:38 [61065] #7 0x000056390748b57c in tpool::thread_pool_generic::worker_main (this=0x56390977e5a0, thread_var=0x56390978dfb0) at /work/10.5/tpool/tpool_generic.cc:502 # 2019-11-26T12:12:38 [61065] #8 0x0000563907491615 in std::__invoke_impl(std::__invoke_memfun_deref, void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__f=@0x7f8234009928: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __t=, __args#0=) at /usr/include/c++/6/functional:227 # 2019-11-26T12:12:38 [61065] #9 0x0000563907491587 in std::__invoke(void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__fn=@0x7f8234009928: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __args#0=, __args#1=) at /usr/include/c++/6/functional:251 # 2019-11-26T12:12:38 [61065] #10 0x000056390749151b in std::_Mem_fn_base::operator()(tpool::thread_pool_generic*&&, tpool::worker_data*&&) const (this=0x7f8234009928, __args#0=, __args#1=) at /usr/include/c++/6/functional:604 # 2019-11-26T12:12:38 [61065] #11 0x00005639074914cd in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::_M_invoke<0ul, 1ul>(std::_Index_tuple<0ul, 1ul>) (this=0x7f8234009918) at /usr/include/c++/6/functional:1391 # 2019-11-26T12:12:38 [61065] #12 0x00005639074913cb in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::operator()() (this=0x7f8234009918) at /usr/include/c++/6/functional:1380 # 2019-11-26T12:12:38 [61065] #13 0x00005639074913aa in std::thread::_State_impl (tpool::thread_pool_generic*, tpool::worker_data*)> >::_M_run() (this=0x7f8234009910) at /usr/include/c++/6/thread:197 # 2019-11-26T12:12:38 [61065] #14 0x00007f8268f5883f in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6 # 2019-11-26T12:12:38 [61065] #15 0x00007f82694306da in start_thread (arg=0x7f8239cfc700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #16 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 12 (Thread 0x7f82682f2700 (LWP 61709)): # 2019-11-26T12:12:38 [61065] #0 0x00007f82686b2d8d in poll () at ../sysdeps/unix/syscall-template.S:84 # 2019-11-26T12:12:38 [61065] #1 0x0000563906e64c54 in vio_io_wait (vio=0x7f8214007ec8, event=VIO_IO_EVENT_READ, timeout=28800000) at /work/10.5/vio/viosocket.c:980 # 2019-11-26T12:12:38 [61065] #2 0x0000563906e63202 in vio_socket_io_wait (vio=0x7f8214007ec8, event=VIO_IO_EVENT_READ) at /work/10.5/vio/viosocket.c:118 # 2019-11-26T12:12:38 [61065] #3 0x0000563906e6340a in vio_read (vio=0x7f8214007ec8, buf=0x7f82140080c8 "\a", size=4) at /work/10.5/vio/viosocket.c:199 # 2019-11-26T12:12:38 [61065] #4 0x0000563906dbae22 in my_real_read (net=0x7f8214000d90, complen=0x7f82682f1db0, header=1 '\001') at /work/10.5/sql/net_serv.cc:962 # 2019-11-26T12:12:38 [61065] #5 0x0000563906dbb70d in my_net_read_packet_reallen (net=0x7f8214000d90, read_from_server=1 '\001', reallen=0x7f82682f1e18) at /work/10.5/sql/net_serv.cc:1243 # 2019-11-26T12:12:38 [61065] #6 0x0000563906dbb6c1 in my_net_read_packet (net=0x7f8214000d90, read_from_server=1 '\001') at /work/10.5/sql/net_serv.cc:1227 # 2019-11-26T12:12:38 [61065] #7 0x00005639068ec519 in do_command (thd=0x7f8214000a98) at /work/10.5/sql/sql_parse.cc:1237 # 2019-11-26T12:12:38 [61065] #8 0x0000563906a8c50e in do_handle_one_connection (connect=0x56390b7cfd88, put_in_cache=true) at /work/10.5/sql/sql_connect.cc:1422 # 2019-11-26T12:12:38 [61065] #9 0x0000563906a8c242 in handle_one_connection (arg=0x56390b7cfd88) at /work/10.5/sql/sql_connect.cc:1319 # 2019-11-26T12:12:38 [61065] #10 0x00007f82694306da in start_thread (arg=0x7f82682f2700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #11 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 11 (Thread 0x7f826a927600 (LWP 61584)): # 2019-11-26T12:12:38 [61065] #0 0x00007f82686b2d8d in poll () at ../sysdeps/unix/syscall-template.S:84 # 2019-11-26T12:12:38 [61065] #1 0x00005639067b6dac in handle_connections_sockets () at /work/10.5/sql/mysqld.cc:6254 # 2019-11-26T12:12:38 [61065] #2 0x00005639067b61ce in mysqld_main (argc=37, argv=0x5639096276a8) at /work/10.5/sql/mysqld.cc:5722 # 2019-11-26T12:12:38 [61065] #3 0x00005639067aa570 in main (argc=36, argv=0x7fff6eecc318) at /work/10.5/sql/main.cc:25 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 10 (Thread 0x7f82509f9700 (LWP 61668)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 # 2019-11-26T12:12:38 [61065] #1 0x000056390713e148 in os_event::wait (this=0x56390b5e8780) at /work/10.5/storage/innobase/os/os0event.cc:158 # 2019-11-26T12:12:38 [61065] #2 0x000056390713dc4e in os_event::wait_low (this=0x56390b5e8780, reset_sig_count=4) at /work/10.5/storage/innobase/os/os0event.cc:325 # 2019-11-26T12:12:38 [61065] #3 0x000056390713df36 in os_event_wait_low (event=0x56390b5e8780, reset_sig_count=4) at /work/10.5/storage/innobase/os/os0event.cc:502 # 2019-11-26T12:12:38 [61065] #4 0x0000563907266ce6 in sync_array_wait_event (arr=0x563909755a40, cell=@0x7f82509f8a28: 0x563909755bf0) at /work/10.5/storage/innobase/sync/sync0arr.cc:471 # 2019-11-26T12:12:38 [61065] #5 0x000056390726abe0 in rw_lock_s_lock_spin (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/sync/sync0rw.cc:367 # 2019-11-26T12:12:38 [61065] #6 0x000056390720a2f4 in rw_lock_s_lock_func (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/include/sync0rw.ic:285 # 2019-11-26T12:12:38 [61065] #7 0x000056390720a9ca in pfs_rw_lock_s_lock_func (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/include/sync0rw.ic:651 # 2019-11-26T12:12:38 [61065] #8 0x0000563907210aee in row_purge_parse_undo_rec (node=0x56390b6c0280, undo_rec=0x56390b6c0748 "", updated_extern=0x7f82509f8bae, thr=0x56390b6c01c8) at /work/10.5/storage/innobase/row/row0purge.cc:1070 # 2019-11-26T12:12:38 [61065] #9 0x000056390721152e in row_purge (node=0x56390b6c0280, undo_rec=0x56390b6c0748 "", thr=0x56390b6c01c8) at /work/10.5/storage/innobase/row/row0purge.cc:1260 # 2019-11-26T12:12:38 [61065] #10 0x00005639072117ae in row_purge_step (thr=0x56390b6c01c8) at /work/10.5/storage/innobase/row/row0purge.cc:1322 # 2019-11-26T12:12:38 [61065] #11 0x000056390717cb4c in que_thr_step (thr=0x56390b6c01c8) at /work/10.5/storage/innobase/que/que0que.cc:1037 # 2019-11-26T12:12:38 [61065] #12 0x000056390717cde3 in que_run_threads_low (thr=0x56390b6c01c8) at /work/10.5/storage/innobase/que/que0que.cc:1099 # 2019-11-26T12:12:38 [61065] #13 0x000056390717d033 in que_run_threads (thr=0x56390b6c01c8) at /work/10.5/storage/innobase/que/que0que.cc:1139 # 2019-11-26T12:12:38 [61065] #14 0x000056390725b2d8 in srv_task_execute () at /work/10.5/storage/innobase/srv/srv0srv.cc:2026 # 2019-11-26T12:12:38 [61065] #15 0x000056390725ba5f in purge_worker_callback () at /work/10.5/storage/innobase/srv/srv0srv.cc:2177 # 2019-11-26T12:12:38 [61065] #16 0x0000563907491804 in tpool::task_group::execute (this=0x563908c4db20 , t=0x563908c4d860 ) at /work/10.5/tpool/task_group.cc:55 # 2019-11-26T12:12:38 [61065] #17 0x0000563907491b80 in tpool::task::execute (this=0x563908c4d860 ) at /work/10.5/tpool/task.cc:32 # 2019-11-26T12:12:38 [61065] #18 0x000056390748b5b0 in tpool::thread_pool_generic::worker_main (this=0x56390977e5a0, thread_var=0x56390978e0b0) at /work/10.5/tpool/tpool_generic.cc:504 # 2019-11-26T12:12:38 [61065] #19 0x0000563907491615 in std::__invoke_impl(std::__invoke_memfun_deref, void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__f=@0x7f8264001d08: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __t=, __args#0=) at /usr/include/c++/6/functional:227 # 2019-11-26T12:12:38 [61065] #20 0x0000563907491587 in std::__invoke(void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__fn=@0x7f8264001d08: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __args#0=, __args#1=) at /usr/include/c++/6/functional:251 # 2019-11-26T12:12:38 [61065] #21 0x000056390749151b in std::_Mem_fn_base::operator()(tpool::thread_pool_generic*&&, tpool::worker_data*&&) const (this=0x7f8264001d08, __args#0=, __args#1=) at /usr/include/c++/6/functional:604 # 2019-11-26T12:12:38 [61065] #22 0x00005639074914cd in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::_M_invoke<0ul, 1ul>(std::_Index_tuple<0ul, 1ul>) (this=0x7f8264001cf8) at /usr/include/c++/6/functional:1391 # 2019-11-26T12:12:38 [61065] #23 0x00005639074913cb in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::operator()() (this=0x7f8264001cf8) at /usr/include/c++/6/functional:1380 # 2019-11-26T12:12:38 [61065] #24 0x00005639074913aa in std::thread::_State_impl (tpool::thread_pool_generic*, tpool::worker_data*)> >::_M_run() (this=0x7f8264001cf0) at /usr/include/c++/6/thread:197 # 2019-11-26T12:12:38 [61065] #25 0x00007f8268f5883f in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6 # 2019-11-26T12:12:38 [61065] #26 0x00007f82694306da in start_thread (arg=0x7f82509f9700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #27 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 9 (Thread 0x7f8268386700 (LWP 61678)): # 2019-11-26T12:12:38 [61065] #0 0x00007f82685ece76 in __GI___sigwaitinfo (set=, info=0x7f8268385da0) at ../sysdeps/unix/sysv/linux/sigwaitinfo.c:56 # 2019-11-26T12:12:38 [61065] #1 0x00005639067aa5ee in my_sigwait (set=0x7f8268385e80, sig=0x7f8268385e44, code=0x7f8268385e48) at /work/10.5/include/my_pthread.h:198 # 2019-11-26T12:12:38 [61065] #2 0x00005639067b0a65 in signal_hand (arg=0x0) at /work/10.5/sql/mysqld.cc:3074 # 2019-11-26T12:12:38 [61065] #3 0x00007f82694306da in start_thread (arg=0x7f8268386700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #4 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 8 (Thread 0x7f82683d0700 (LWP 61677)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 # 2019-11-26T12:12:38 [61065] #1 0x0000563907534871 in safe_cond_wait (cond=0x5639083f6638 , mp=0x5639083f6588 , file=0x563907895d30 "/work/10.5/include/mysql/psi/mysql_thread.h", line=1178) at /work/10.5/mysys/thr_mutex.c:492 # 2019-11-26T12:12:38 [61065] #2 0x0000563906d5b05a in inline_mysql_cond_wait (that=0x5639083f6638 , mutex=0x5639083f6588 , src_file=0x56390789684c "/work/10.5/sql/log.cc", src_line=10006) at /work/10.5/include/mysql/psi/mysql_thread.h:1178 # 2019-11-26T12:12:38 [61065] #3 0x0000563906d78b3f in binlog_background_thread (arg=0x0) at /work/10.5/sql/log.cc:10006 # 2019-11-26T12:12:38 [61065] #4 0x00007f82694306da in start_thread (arg=0x7f82683d0700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #5 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 7 (Thread 0x7f826833c700 (LWP 61679)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 # 2019-11-26T12:12:38 [61065] #1 0x0000563907534871 in safe_cond_wait (cond=0x5639083b6fa0 , mp=0x5639083ba160 , file=0x5639076a04d0 "/work/10.5/include/mysql/psi/mysql_thread.h", line=1178) at /work/10.5/mysys/thr_mutex.c:492 # 2019-11-26T12:12:38 [61065] #2 0x00005639067dcae8 in inline_mysql_cond_wait (that=0x5639083b6fa0 , mutex=0x5639083ba160 , src_file=0x5639076a0fd5 "/work/10.5/sql/slave.cc", src_line=519) at /work/10.5/include/mysql/psi/mysql_thread.h:1178 # 2019-11-26T12:12:38 [61065] #3 0x00005639067de3ae in handle_slave_background (arg=0x0) at /work/10.5/sql/slave.cc:519 # 2019-11-26T12:12:38 [61065] #4 0x00007f82694306da in start_thread (arg=0x7f826833c700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #5 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 6 (Thread 0x7f823a4fd700 (LWP 61674)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 # 2019-11-26T12:12:38 [61065] #1 0x00007f8268f5280c in std::condition_variable::wait(std::unique_lock&) () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6 # 2019-11-26T12:12:38 [61065] #2 0x0000563907491d5e in tpool::waitable_task::wait (this=0x563908c4d860 ) at /work/10.5/tpool/task.cc:64 # 2019-11-26T12:12:38 [61065] #3 0x000056390728be38 in trx_purge_wait_for_workers_to_complete () at /work/10.5/storage/innobase/trx/trx0purge.cc:1256 # 2019-11-26T12:12:38 [61065] #4 0x000056390728c06a in trx_purge (n_tasks=4, truncate=false) at /work/10.5/storage/innobase/trx/trx0purge.cc:1301 # 2019-11-26T12:12:38 [61065] #5 0x000056390725b5e3 in srv_do_purge (n_total_purged=0x7f823a4fcca8) at /work/10.5/storage/innobase/srv/srv0srv.cc:2100 # 2019-11-26T12:12:38 [61065] #6 0x000056390725baf5 in purge_coordinator_callback_low () at /work/10.5/storage/innobase/srv/srv0srv.cc:2193 # 2019-11-26T12:12:38 [61065] #7 0x000056390725bbd6 in purge_coordinator_callback () at /work/10.5/storage/innobase/srv/srv0srv.cc:2222 # 2019-11-26T12:12:38 [61065] #8 0x0000563907491804 in tpool::task_group::execute (this=0x563908c4dbc0 , t=0x563908c4d8e0 ) at /work/10.5/tpool/task_group.cc:55 # 2019-11-26T12:12:38 [61065] #9 0x0000563907491b80 in tpool::task::execute (this=0x563908c4d8e0 ) at /work/10.5/tpool/task.cc:32 # 2019-11-26T12:12:38 [61065] #10 0x000056390748b5b0 in tpool::thread_pool_generic::worker_main (this=0x56390977e5a0, thread_var=0x56390978e030) at /work/10.5/tpool/tpool_generic.cc:504 # 2019-11-26T12:12:38 [61065] #11 0x0000563907491615 in std::__invoke_impl(std::__invoke_memfun_deref, void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__f=@0x7f82340097c8: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __t=, __args#0=) at /usr/include/c++/6/functional:227 # 2019-11-26T12:12:38 [61065] #12 0x0000563907491587 in std::__invoke(void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__fn=@0x7f82340097c8: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __args#0=, __args#1=) at /usr/include/c++/6/functional:251 # 2019-11-26T12:12:38 [61065] #13 0x000056390749151b in std::_Mem_fn_base::operator()(tpool::thread_pool_generic*&&, tpool::worker_data*&&) const (this=0x7f82340097c8, __args#0=, __args#1=) at /usr/include/c++/6/functional:604 # 2019-11-26T12:12:38 [61065] #14 0x00005639074914cd in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::_M_invoke<0ul, 1ul>(std::_Index_tuple<0ul, 1ul>) (this=0x7f82340097b8) at /usr/include/c++/6/functional:1391 # 2019-11-26T12:12:38 [61065] #15 0x00005639074913cb in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::operator()() (this=0x7f82340097b8) at /usr/include/c++/6/functional:1380 # 2019-11-26T12:12:38 [61065] #16 0x00005639074913aa in std::thread::_State_impl (tpool::thread_pool_generic*, tpool::worker_data*)> >::_M_run() (this=0x7f82340097b0) at /usr/include/c++/6/thread:197 # 2019-11-26T12:12:38 [61065] #17 0x00007f8268f5883f in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6 # 2019-11-26T12:12:38 [61065] #18 0x00007f82694306da in start_thread (arg=0x7f823a4fd700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #19 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 5 (Thread 0x7f82513fc700 (LWP 61663)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 # 2019-11-26T12:12:38 [61065] #1 0x000056390713dab8 in os_event::timed_wait (this=0x5639097a2cd0, abstime=0x7f82513fbc20) at /work/10.5/storage/innobase/os/os0event.cc:275 # 2019-11-26T12:12:38 [61065] #2 0x000056390713dd73 in os_event::wait_time_low (this=0x5639097a2cd0, time_in_usec=976000, reset_sig_count=2) at /work/10.5/storage/innobase/os/os0event.cc:385 # 2019-11-26T12:12:38 [61065] #3 0x000056390713df11 in os_event_wait_time_low (event=0x5639097a2cd0, time_in_usec=976000, reset_sig_count=2) at /work/10.5/storage/innobase/os/os0event.cc:485 # 2019-11-26T12:12:38 [61065] #4 0x000056390736cd5a in pc_sleep_if_needed (next_loop_time=2418643613, sig_count=2, cur_time=2418642637) at /work/10.5/storage/innobase/buf/buf0flu.cc:2815 # 2019-11-26T12:12:38 [61065] #5 0x000056390736dda9 in buf_flush_page_cleaner_coordinator () at /work/10.5/storage/innobase/buf/buf0flu.cc:3230 # 2019-11-26T12:12:38 [61065] #6 0x00007f82694306da in start_thread (arg=0x7f82513fc700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #7 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 4 (Thread 0x7f82394fb700 (LWP 61676)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 # 2019-11-26T12:12:38 [61065] #1 0x000056390713e148 in os_event::wait (this=0x56390b5e8780) at /work/10.5/storage/innobase/os/os0event.cc:158 # 2019-11-26T12:12:38 [61065] #2 0x000056390713dc4e in os_event::wait_low (this=0x56390b5e8780, reset_sig_count=4) at /work/10.5/storage/innobase/os/os0event.cc:325 # 2019-11-26T12:12:38 [61065] #3 0x000056390713df36 in os_event_wait_low (event=0x56390b5e8780, reset_sig_count=4) at /work/10.5/storage/innobase/os/os0event.cc:502 # 2019-11-26T12:12:38 [61065] #4 0x0000563907266ce6 in sync_array_wait_event (arr=0x563909755a40, cell=@0x7f82394faa28: 0x563909755bb0) at /work/10.5/storage/innobase/sync/sync0arr.cc:471 # 2019-11-26T12:12:38 [61065] #5 0x000056390726abe0 in rw_lock_s_lock_spin (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/sync/sync0rw.cc:367 # 2019-11-26T12:12:38 [61065] #6 0x000056390720a2f4 in rw_lock_s_lock_func (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/include/sync0rw.ic:285 # 2019-11-26T12:12:38 [61065] #7 0x000056390720a9ca in pfs_rw_lock_s_lock_func (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/include/sync0rw.ic:651 # 2019-11-26T12:12:38 [61065] #8 0x0000563907210aee in row_purge_parse_undo_rec (node=0x56390b6c08c8, undo_rec=0x56390b6c1498 "", updated_extern=0x7f82394fabae, thr=0x56390b6c0440) at /work/10.5/storage/innobase/row/row0purge.cc:1070 # 2019-11-26T12:12:38 [61065] #9 0x000056390721152e in row_purge (node=0x56390b6c08c8, undo_rec=0x56390b6c1498 "", thr=0x56390b6c0440) at /work/10.5/storage/innobase/row/row0purge.cc:1260 # 2019-11-26T12:12:38 [61065] #10 0x00005639072117ae in row_purge_step (thr=0x56390b6c0440) at /work/10.5/storage/innobase/row/row0purge.cc:1322 # 2019-11-26T12:12:38 [61065] #11 0x000056390717cb4c in que_thr_step (thr=0x56390b6c0440) at /work/10.5/storage/innobase/que/que0que.cc:1037 # 2019-11-26T12:12:38 [61065] #12 0x000056390717cde3 in que_run_threads_low (thr=0x56390b6c0440) at /work/10.5/storage/innobase/que/que0que.cc:1099 # 2019-11-26T12:12:38 [61065] #13 0x000056390717d033 in que_run_threads (thr=0x56390b6c0440) at /work/10.5/storage/innobase/que/que0que.cc:1139 # 2019-11-26T12:12:38 [61065] #14 0x000056390725b2d8 in srv_task_execute () at /work/10.5/storage/innobase/srv/srv0srv.cc:2026 # 2019-11-26T12:12:38 [61065] #15 0x000056390725ba5f in purge_worker_callback () at /work/10.5/storage/innobase/srv/srv0srv.cc:2177 # 2019-11-26T12:12:38 [61065] #16 0x0000563907491804 in tpool::task_group::execute (this=0x563908c4db20 , t=0x563908c4d860 ) at /work/10.5/tpool/task_group.cc:55 # 2019-11-26T12:12:38 [61065] #17 0x0000563907491b80 in tpool::task::execute (this=0x563908c4d860 ) at /work/10.5/tpool/task.cc:32 # 2019-11-26T12:12:38 [61065] #18 0x000056390748b5b0 in tpool::thread_pool_generic::worker_main (this=0x56390977e5a0, thread_var=0x56390978df30) at /work/10.5/tpool/tpool_generic.cc:504 # 2019-11-26T12:12:38 [61065] #19 0x0000563907491615 in std::__invoke_impl(std::__invoke_memfun_deref, void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__f=@0x7f8234009a88: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __t=, __args#0=) at /usr/include/c++/6/functional:227 # 2019-11-26T12:12:38 [61065] #20 0x0000563907491587 in std::__invoke(void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__fn=@0x7f8234009a88: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __args#0=, __args#1=) at /usr/include/c++/6/functional:251 # 2019-11-26T12:12:38 [61065] #21 0x000056390749151b in std::_Mem_fn_base::operator()(tpool::thread_pool_generic*&&, tpool::worker_data*&&) const (this=0x7f8234009a88, __args#0=, __args#1=) at /usr/include/c++/6/functional:604 # 2019-11-26T12:12:38 [61065] #22 0x00005639074914cd in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::_M_invoke<0ul, 1ul>(std::_Index_tuple<0ul, 1ul>) (this=0x7f8234009a78) at /usr/include/c++/6/functional:1391 # 2019-11-26T12:12:38 [61065] #23 0x00005639074913cb in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::operator()() (this=0x7f8234009a78) at /usr/include/c++/6/functional:1380 # 2019-11-26T12:12:38 [61065] #24 0x00005639074913aa in std::thread::_State_impl (tpool::thread_pool_generic*, tpool::worker_data*)> >::_M_run() (this=0x7f8234009a70) at /usr/include/c++/6/thread:197 # 2019-11-26T12:12:38 [61065] #25 0x00007f8268f5883f in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6 # 2019-11-26T12:12:38 [61065] #26 0x00007f82694306da in start_thread (arg=0x7f82394fb700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #27 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 3 (Thread 0x7f823bfff700 (LWP 61667)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 # 2019-11-26T12:12:38 [61065] #1 0x000056390713e148 in os_event::wait (this=0x56390b5e8780) at /work/10.5/storage/innobase/os/os0event.cc:158 # 2019-11-26T12:12:38 [61065] #2 0x000056390713dc4e in os_event::wait_low (this=0x56390b5e8780, reset_sig_count=4) at /work/10.5/storage/innobase/os/os0event.cc:325 # 2019-11-26T12:12:38 [61065] #3 0x000056390713df36 in os_event_wait_low (event=0x56390b5e8780, reset_sig_count=4) at /work/10.5/storage/innobase/os/os0event.cc:502 # 2019-11-26T12:12:38 [61065] #4 0x0000563907266ce6 in sync_array_wait_event (arr=0x563909755a40, cell=@0x7f823bffea28: 0x563909755b70) at /work/10.5/storage/innobase/sync/sync0arr.cc:471 # 2019-11-26T12:12:38 [61065] #5 0x000056390726abe0 in rw_lock_s_lock_spin (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/sync/sync0rw.cc:367 # 2019-11-26T12:12:38 [61065] #6 0x000056390720a2f4 in rw_lock_s_lock_func (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/include/sync0rw.ic:285 # 2019-11-26T12:12:38 [61065] #7 0x000056390720a9ca in pfs_rw_lock_s_lock_func (lock=0x5639081f8050 , pass=0, file_name=0x5639079c33e0 "/work/10.5/storage/innobase/row/row0purge.cc", line=1070) at /work/10.5/storage/innobase/include/sync0rw.ic:651 # 2019-11-26T12:12:38 [61065] #8 0x0000563907210aee in row_purge_parse_undo_rec (node=0x56390b6c0008, undo_rec=0x56390b6c05b8 "", updated_extern=0x7f823bffebae, thr=0x56390b6bfe38) at /work/10.5/storage/innobase/row/row0purge.cc:1070 # 2019-11-26T12:12:38 [61065] #9 0x000056390721152e in row_purge (node=0x56390b6c0008, undo_rec=0x56390b6c05b8 "", thr=0x56390b6bfe38) at /work/10.5/storage/innobase/row/row0purge.cc:1260 # 2019-11-26T12:12:38 [61065] #10 0x00005639072117ae in row_purge_step (thr=0x56390b6bfe38) at /work/10.5/storage/innobase/row/row0purge.cc:1322 # 2019-11-26T12:12:38 [61065] #11 0x000056390717cb4c in que_thr_step (thr=0x56390b6bfe38) at /work/10.5/storage/innobase/que/que0que.cc:1037 # 2019-11-26T12:12:38 [61065] #12 0x000056390717cde3 in que_run_threads_low (thr=0x56390b6bfe38) at /work/10.5/storage/innobase/que/que0que.cc:1099 # 2019-11-26T12:12:38 [61065] #13 0x000056390717d033 in que_run_threads (thr=0x56390b6bfe38) at /work/10.5/storage/innobase/que/que0que.cc:1139 # 2019-11-26T12:12:38 [61065] #14 0x000056390725b2d8 in srv_task_execute () at /work/10.5/storage/innobase/srv/srv0srv.cc:2026 # 2019-11-26T12:12:38 [61065] #15 0x000056390725ba5f in purge_worker_callback () at /work/10.5/storage/innobase/srv/srv0srv.cc:2177 # 2019-11-26T12:12:38 [61065] #16 0x0000563907491804 in tpool::task_group::execute (this=0x563908c4db20 , t=0x563908c4d860 ) at /work/10.5/tpool/task_group.cc:55 # 2019-11-26T12:12:38 [61065] #17 0x0000563907491b80 in tpool::task::execute (this=0x563908c4d860 ) at /work/10.5/tpool/task.cc:32 # 2019-11-26T12:12:38 [61065] #18 0x000056390748b5b0 in tpool::thread_pool_generic::worker_main (this=0x56390977e5a0, thread_var=0x56390978e130) at /work/10.5/tpool/tpool_generic.cc:504 # 2019-11-26T12:12:38 [61065] #19 0x0000563907491615 in std::__invoke_impl(std::__invoke_memfun_deref, void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__f=@0x7f8264001ba8: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __t=, __args#0=) at /usr/include/c++/6/functional:227 # 2019-11-26T12:12:38 [61065] #20 0x0000563907491587 in std::__invoke(void (tpool::thread_pool_generic::* const&)(tpool::worker_data*), tpool::thread_pool_generic*&&, tpool::worker_data*&&) (__fn=@0x7f8264001ba8: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x56390748b53e , __args#0=, __args#1=) at /usr/include/c++/6/functional:251 # 2019-11-26T12:12:38 [61065] #21 0x000056390749151b in std::_Mem_fn_base::operator()(tpool::thread_pool_generic*&&, tpool::worker_data*&&) const (this=0x7f8264001ba8, __args#0=, __args#1=) at /usr/include/c++/6/functional:604 # 2019-11-26T12:12:38 [61065] #22 0x00005639074914cd in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::_M_invoke<0ul, 1ul>(std::_Index_tuple<0ul, 1ul>) (this=0x7f8264001b98) at /usr/include/c++/6/functional:1391 # 2019-11-26T12:12:38 [61065] #23 0x00005639074913cb in std::_Bind_simple (tpool::thread_pool_generic*, tpool::worker_data*)>::operator()() (this=0x7f8264001b98) at /usr/include/c++/6/functional:1380 # 2019-11-26T12:12:38 [61065] #24 0x00005639074913aa in std::thread::_State_impl (tpool::thread_pool_generic*, tpool::worker_data*)> >::_M_run() (this=0x7f8264001b90) at /usr/include/c++/6/thread:197 # 2019-11-26T12:12:38 [61065] #25 0x00007f8268f5883f in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6 # 2019-11-26T12:12:38 [61065] #26 0x00007f82694306da in start_thread (arg=0x7f823bfff700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #27 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 2 (Thread 0x7f826a827700 (LWP 61601)): # 2019-11-26T12:12:38 [61065] #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 # 2019-11-26T12:12:38 [61065] #1 0x0000563907534b7b in safe_cond_timedwait (cond=0x563908c68fe0 , mp=0x563908c68f20 , abstime=0x7f826a826f00, file=0x563907aa2890 "/work/10.5/include/mysql/psi/mysql_thread.h", line=1215) at /work/10.5/mysys/thr_mutex.c:546 # 2019-11-26T12:12:38 [61065] #2 0x0000563907535c23 in inline_mysql_cond_timedwait (that=0x563908c68fe0 , mutex=0x563908c68f20 , abstime=0x7f826a826f00, src_file=0x563907aa28bc "/work/10.5/mysys/thr_timer.c", src_line=321) at /work/10.5/include/mysql/psi/mysql_thread.h:1215 # 2019-11-26T12:12:38 [61065] #3 0x00005639075368a4 in timer_handler (arg=0x0) at /work/10.5/mysys/thr_timer.c:321 # 2019-11-26T12:12:38 [61065] #4 0x00007f82694306da in start_thread (arg=0x7f826a827700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #5 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] # 2019-11-26T12:12:38 [61065] Thread 1 (Thread 0x7f82682a8700 (LWP 61711)): # 2019-11-26T12:12:38 [61065] #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 # 2019-11-26T12:12:38 [61065] #1 0x000056390752f1bb in my_write_core (sig=6) at /work/10.5/mysys/stacktrace.c:518 # 2019-11-26T12:12:38 [61065] #2 0x0000563906c34bc9 in handle_fatal_signal (sig=6) at /work/10.5/sql/signal_handler.cc:343 # 2019-11-26T12:12:38 [61065] #3 # 2019-11-26T12:12:38 [61065] #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58 # 2019-11-26T12:12:38 [61065] #5 0x00007f82685ed37a in __GI_abort () at abort.c:89 # 2019-11-26T12:12:38 [61065] #6 0x00007f82685e3b47 in __assert_fail_base (fmt=, assertion=assertion@entry=0x563907a12358 "index->n_core_fields + n_add >= index->n_fields", file=file@entry=0x563907a11ec0 "/work/10.5/storage/innobase/btr/btr0cur.cc", line=line@entry=507, function=function@entry=0x563907a15ec0 "dberr_t btr_cur_instant_init_low(dict_index_t*, mtr_t*)") at assert.c:92 # 2019-11-26T12:12:38 [61065] #7 0x00007f82685e3bf2 in __GI___assert_fail (assertion=0x563907a12358 "index->n_core_fields + n_add >= index->n_fields", file=0x563907a11ec0 "/work/10.5/storage/innobase/btr/btr0cur.cc", line=507, function=0x563907a15ec0 "dberr_t btr_cur_instant_init_low(dict_index_t*, mtr_t*)") at assert.c:101 # 2019-11-26T12:12:38 [61065] #8 0x00005639072fa2cf in btr_cur_instant_init_low (index=0x7f82182ff5b8, mtr=0x7f82682a15c0) at /work/10.5/storage/innobase/btr/btr0cur.cc:507 # 2019-11-26T12:12:38 [61065] #9 0x00005639072fadb0 in btr_cur_instant_init (table=0x7f82182ff098) at /work/10.5/storage/innobase/btr/btr0cur.cc:659 # 2019-11-26T12:12:38 [61065] #10 0x00005639073b801a in dict_load_table_one (name=..., ignore_err=DICT_ERR_IGNORE_NONE, fk_tables=std::deque with 0 elements) at /work/10.5/storage/innobase/dict/dict0load.cc:3011 # 2019-11-26T12:12:38 [61065] #11 0x00005639073b6d2e in dict_load_table (name=0x7f82682a2aa0 "test/t3", ignore_err=DICT_ERR_IGNORE_NONE) at /work/10.5/storage/innobase/dict/dict0load.cc:2743 # 2019-11-26T12:12:38 [61065] #12 0x000056390739b1f7 in dict_table_open_on_name (table_name=0x7f82682a2aa0 "test/t3", dict_locked=1, try_drop=1, ignore_err=DICT_ERR_IGNORE_NONE) at /work/10.5/storage/innobase/dict/dict0dict.cc:886 # 2019-11-26T12:12:38 [61065] #13 0x000056390708fff3 in ha_innobase::commit_inplace_alter_table (this=0x7f82183036f0, altered_table=0x7f82682a4010, ha_alter_info=0x7f82682a3f80, commit=true) at /work/10.5/storage/innobase/handler/handler0alter.cc:11151 # 2019-11-26T12:12:38 [61065] #14 0x0000563906c43c95 in handler::ha_commit_inplace_alter_table (this=0x7f82183036f0, altered_table=0x7f82682a4010, ha_alter_info=0x7f82682a3f80, commit=true) at /work/10.5/sql/handler.cc:4557 # 2019-11-26T12:12:38 [61065] #15 0x00005639069ed344 in mysql_inplace_alter_table (thd=0x7f8218000a98, table_list=0x7f8218013b58, table=0x7f82183028e8, altered_table=0x7f82682a4010, ha_alter_info=0x7f82682a3f80, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f82682a4df0, alter_ctx=0x7f82682a5920) at /work/10.5/sql/sql_table.cc:7764 # 2019-11-26T12:12:38 [61065] #16 0x00005639069f3e23 in mysql_alter_table (thd=0x7f8218000a98, new_db=0x7f8218005270, new_name=0x7f8218005678, create_info=0x7f82682a6510, table_list=0x7f8218013b58, alter_info=0x7f82682a6450, order_num=0, order=0x0, ignore=false) at /work/10.5/sql/sql_table.cc:10079 # 2019-11-26T12:12:38 [61065] #17 0x0000563906a965cf in Sql_cmd_alter_table::execute (this=0x7f82180146e0, thd=0x7f8218000a98) at /work/10.5/sql/sql_alter.cc:523 # 2019-11-26T12:12:38 [61065] #18 0x00005639068fd19f in mysql_execute_command (thd=0x7f8218000a98) at /work/10.5/sql/sql_parse.cc:5959 # 2019-11-26T12:12:38 [61065] #19 0x00005639069033c6 in mysql_parse (thd=0x7f8218000a98, rawbuf=0x7f8218013980 "ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */", length=146, parser_state=0x7f82682a75d0, is_com_multi=false, is_next_command=false) at /work/10.5/sql/sql_parse.cc:7988 # 2019-11-26T12:12:38 [61065] #20 0x00005639068ee461 in dispatch_command (command=COM_QUERY, thd=0x7f8218000a98, packet=0x7f8218007ec9 "ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */ ", packet_length=147, is_com_multi=false, is_next_command=false) at /work/10.5/sql/sql_parse.cc:1846 # 2019-11-26T12:12:38 [61065] #21 0x00005639068ecbbb in do_command (thd=0x7f8218000a98) at /work/10.5/sql/sql_parse.cc:1364 # 2019-11-26T12:12:38 [61065] #22 0x0000563906a8c50e in do_handle_one_connection (connect=0x56390b773f58, put_in_cache=true) at /work/10.5/sql/sql_connect.cc:1422 # 2019-11-26T12:12:38 [61065] #23 0x0000563906a8c242 in handle_one_connection (arg=0x56390b773f58) at /work/10.5/sql/sql_connect.cc:1319 # 2019-11-26T12:12:38 [61065] #24 0x00007f82694306da in start_thread (arg=0x7f82682a8700) at pthread_create.c:456 # 2019-11-26T12:12:38 [61065] #25 0x00007f82686bed7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 # 2019-11-26T12:12:38 [61065] Will return STATUS_SERVER_CRASHED, ... # 2019-11-26T12:12:38 [61065] INFO: Reporter 'Backtrace' ------------------------------ End # 2019-11-26T12:12:38 [61065] ERROR: ReporterManager : Reporter 'Backtrace' reported 101 # 2019-11-26T12:12:38 [61065] INFO: Reporter 'ErrorLog' ------------------------------ Begin # 2019-11-26T12:12:38 [61065] --------- Contents of /dev/shm/vardir/1574766704/51/1/data//../mysql.err ------------- # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] /work/10.5/bld_debug//sql/mysqld (mysqld 10.5.0-MariaDB-debug-log) starting as process 61584 ... # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=skylake01' or '--log-bin=mysql-bin' to avoid this problem. # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: innodb_page_size=4096 # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Using Linux native AIO # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Uses event mutexes # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 with validation # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Number of pools: 1 # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Using SSE2 crc32 instructions # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/vardir/1574766704/51/1/tmp (disabling future attempts) # 2019-11-26T12:12:38 [61065] | io_setup(2304) returned -11 # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Completed initialization of buffer pool # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: 128 rollback segments are active. # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: 10.5.0 started; log sequence number 76487; transaction id 17 # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/1574766704/51/1/data/ib_buffer_pool # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] Plugin 'FEEDBACK' is disabled. # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Warning] /work/10.5/bld_debug//sql/mysqld: unknown variable 'loose-table_lock_wait_timeout=50' # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] InnoDB: Buffer pool(s) load completed at 191126 12:12:16 # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] Server socket created on IP: '::'. # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] Reading of all Master_info entries succeeded # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] Added new Master_info '' to hash table # 2019-11-26T12:12:38 [61065] | 2019-11-26 12:12:16 0 [Note] /work/10.5/bld_debug//sql/mysqld: ready for connections. # 2019-11-26T12:12:38 [61065] | Version: '10.5.0-MariaDB-debug-log' socket: '/dev/shm/vardir/1574766704/51/1/mysql.sock' port: 29600 Source distribution # 2019-11-26T12:12:38 [61065] | mysqld: /work/10.5/storage/innobase/btr/btr0cur.cc:507: dberr_t btr_cur_instant_init_low(dict_index_t*, mtr_t*): Assertion `index->n_core_fields + n_add >= index->n_fields' failed. # 2019-11-26T12:12:38 [61065] | 191126 12:12:18 [ERROR] mysqld got signal 6 ; # 2019-11-26T12:12:38 [61065] | This could be because you hit a bug. It is also possible that this binary # 2019-11-26T12:12:38 [61065] | or one of the libraries it was linked against is corrupt, improperly built, # 2019-11-26T12:12:38 [61065] | or misconfigured. This error can also be caused by malfunctioning hardware. # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | We will try our best to scrape up some info that will hopefully help # 2019-11-26T12:12:38 [61065] | diagnose the problem, but since we have already crashed, # 2019-11-26T12:12:38 [61065] | something is definitely wrong and this may fail. # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | Server version: 10.5.0-MariaDB-debug-log # 2019-11-26T12:12:38 [61065] | key_buffer_size=134217728 # 2019-11-26T12:12:38 [61065] | read_buffer_size=131072 # 2019-11-26T12:12:38 [61065] | max_used_connections=3 # 2019-11-26T12:12:38 [61065] | max_threads=153 # 2019-11-26T12:12:38 [61065] | thread_count=5 # 2019-11-26T12:12:38 [61065] | It is possible that mysqld could use up to # 2019-11-26T12:12:38 [61065] | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467873 K bytes of memory # 2019-11-26T12:12:38 [61065] | Hope that's ok; if not, decrease some variables in the equation. # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | Thread pointer: 0x7f8218000a98 # 2019-11-26T12:12:38 [61065] | Attempting backtrace. You can use the following information to find out # 2019-11-26T12:12:38 [61065] | where mysqld died. If you see no messages after this, something went # 2019-11-26T12:12:38 [61065] | terribly wrong... # 2019-11-26T12:12:38 [61065] | stack_bottom = 0x7f82682a7eb8 thread_stack 0x49000 # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(my_print_stacktrace+0x40)[0x56390752f0c9] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(handle_fatal_signal+0x3ae)[0x563906c3483f] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libpthread.so.0(+0x11670)[0x7f826943a670] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x9f)[0x7f82685eb77f] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f82685ed37a] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libc.so.6(+0x2db47)[0x7f82685e3b47] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libc.so.6(+0x2dbf2)[0x7f82685e3bf2] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x127d2cf)[0x5639072fa2cf] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x127ddb0)[0x5639072fadb0] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x133b01a)[0x5639073b801a] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x1339d2e)[0x5639073b6d2e] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x131e1f7)[0x56390739b1f7] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x1012ff3)[0x56390708fff3] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_ZN7handler29ha_commit_inplace_alter_tableEP5TABLEP18Alter_inplace_infob+0x157)[0x563906c43c95] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(+0x970344)[0x5639069ed344] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x2040)[0x5639069f3e23] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x91f)[0x563906a965cf] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_Z21mysql_execute_commandP3THD+0xa9de)[0x5639068fd19f] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2d6)[0x5639069033c6] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x11fe)[0x5639068ee461] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_Z10do_commandP3THD+0x796)[0x5639068ecbbb] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(_Z24do_handle_one_connectionP7CONNECTb+0x1d1)[0x563906a8c50e] # 2019-11-26T12:12:38 [61065] | /work/10.5/bld_debug//sql/mysqld(handle_one_connection+0x5b)[0x563906a8c242] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libpthread.so.0(+0x76da)[0x7f82694306da] # 2019-11-26T12:12:38 [61065] | /lib/x86_64-linux-gnu/libc.so.6(clone+0x5f)[0x7f82686bed7f] # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | Trying to get some variables. # 2019-11-26T12:12:38 [61065] | Some pointers may be invalid and cause the dump to abort. # 2019-11-26T12:12:38 [61065] | Query (0x7f8218013980): ALTER TABLE t3 ADD COLUMN IF NOT EXISTS col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) FIRST /* E_R Thread1 QNO 20 CON_ID 12 */ # 2019-11-26T12:12:38 [61065] | Connection ID (thread ID): 12 # 2019-11-26T12:12:38 [61065] | Status: NOT_KILLED # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2019-11-26T12:12:38 [61065] | information that should help you find out what is causing the crash. # 2019-11-26T12:12:38 [61065] | Writing a core file... # 2019-11-26T12:12:38 [61065] | Working directory at /dev/shm/vardir/1574766704/51/1/data # 2019-11-26T12:12:38 [61065] | Resource Limits: # 2019-11-26T12:12:38 [61065] | Limit Soft Limit Hard Limit Units # 2019-11-26T12:12:38 [61065] | Max cpu time unlimited unlimited seconds # 2019-11-26T12:12:38 [61065] | Max file size unlimited unlimited bytes # 2019-11-26T12:12:38 [61065] | Max data size unlimited unlimited bytes # 2019-11-26T12:12:38 [61065] | Max stack size 8388608 unlimited bytes # 2019-11-26T12:12:38 [61065] | Max core file size unlimited unlimited bytes # 2019-11-26T12:12:38 [61065] | Max resident set unlimited unlimited bytes # 2019-11-26T12:12:38 [61065] | Max processes 768201 768201 processes # 2019-11-26T12:12:38 [61065] | Max open files 40960 1048576 files # 2019-11-26T12:12:38 [61065] | Max locked memory 65536 65536 bytes # 2019-11-26T12:12:38 [61065] | Max address space unlimited unlimited bytes # 2019-11-26T12:12:38 [61065] | Max file locks unlimited unlimited locks # 2019-11-26T12:12:38 [61065] | Max pending signals 768201 768201 signals # 2019-11-26T12:12:38 [61065] | Max msgqueue size 819200 819200 bytes # 2019-11-26T12:12:38 [61065] | Max nice priority 0 0 # 2019-11-26T12:12:38 [61065] | Max realtime priority 0 0 # 2019-11-26T12:12:38 [61065] | Max realtime timeout unlimited unlimited us # 2019-11-26T12:12:38 [61065] | Core pattern: |/usr/share/apport/apport %p %s %c %d %P # 2019-11-26T12:12:38 [61065] | # 2019-11-26T12:12:38 [61065] | Aborted (core dumped) # 2019-11-26T12:12:38 [61065] ---------------------------------- # 2019-11-26T12:12:38 [61065] INFO: Reporter 'ErrorLog' ------------------------------ End # 2019-11-26T12:12:38 [61065] error_log is /dev/shm/vardir/1574766704/51/1/data/../mysql.err # 2019-11-26T12:12:38 [61065] pid_file is /dev/shm/vardir/1574766704/51/1/mysql.pid # 2019-11-26T12:12:39 [61065] DEBUG: server pid : 61584 , server_running : 0 # 2019-11-26T12:12:39 [61065] INFO: Reporter 'ServerDead': The process of the DB server 61584 is no more running. Will return STATUS_SERVER_CRASHED. # 2019-11-26T12:12:39 [61065] ERROR: ReporterManager : Reporter 'ServerDead' reported 101 # 2019-11-26T12:12:39 [61065] INFO: The reporters to be run at test end delivered status 101. # 2019-11-26T12:12:39 [61065] Test completed with failure status STATUS_SERVER_CRASHED (101) # 2019-11-26T12:12:39 [61065] GenTest returned status STATUS_SERVER_CRASHED (101) # 2019-11-26T12:12:39 [61065] INFO: RQG GenTest runtime in s : 23 # 2019-11-26T12:12:39 [61065] RESULT: The core of the RQG run ended with status STATUS_SERVER_CRASHED (101) # 2019-11-26T12:12:39 [61065] Stopping server(s)... # 2019-11-26T12:12:39 [61065] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [61584] is already no more running. # 2019-11-26T12:12:39 [61065] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2019-11-26T12:12:39 [61065] RESULT: The RQG run ended with status STATUS_SERVER_CRASHED (101) # 2019-11-26T12:12:39 [61065] Stopping server(s)... # 2019-11-26T12:12:39 [61065] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [61584] is already no more running. # 2019-11-26T12:12:39 [61065] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2019-11-26T12:12:39 [61065] MATCHING: Region end ===================== # 2019-11-26T12:12:39 [61065] INFO: RQG total runtime in s : 26 # 2019-11-26T12:12:39 [61065] MATCHING: STATUS_OK, element ' The RQG run ended with status STATUS_OK' : no match # 2019-11-26T12:12:39 [61065] MATCHING: Stop the run element 'BATCH: Stop the run' : no match # 2019-11-26T12:12:39 [61065] MATCHING: Blacklist statuses, element ' The RQG run ended with status STATUS_OK' : no match # 2019-11-26T12:12:39 [61065] INFO: Blacklist status matching returned : match_no # 2019-11-26T12:12:39 [61065] MATCHING: Blacklist text patterns element 'Possible endless loop in grammar.' : no match # 2019-11-26T12:12:39 [61065] MATCHING: Blacklist text patterns element '\[ERROR\] InnoDB: preallocating .{1,120} with error 28' : no match # 2019-11-26T12:12:39 [61065] MATCHING: Blacklist text patterns element ' is truncated: expected core file size ' : no match # 2019-11-26T12:12:39 [61065] INFO: Blacklist pattern matching returned : match_no # 2019-11-26T12:12:39 [61065] MATCHING: Whitelist statuses, element ' The RQG run ended with status STATUS_SERVER_CRASHED' : match # 2019-11-26T12:12:39 [61065] INFO: Whitelist status matching returned : match_yes # 2019-11-26T12:12:39 [61065] MATCHING: Whitelist text patterns element 'mysqld: .{1,150}btr0pcur.cc:.{1,30} void btr_pcur_store_position.{1,40}: Assertion .index->table->instant. failed.' : no match # 2019-11-26T12:12:39 [61065] MATCHING: Whitelist text patterns element 'mysqld: .{1,150}btr0cur.cc.{1,30}dberr_t btr_cur_instant_init_low.{1,100}' : match # 2019-11-26T12:12:39 [61065] INFO: Whitelist pattern matching returned : match_yes # 2019-11-26T12:12:39 [61065] VERDICT: replay # 2019-11-26T12:12:39 [61065] DEBUG: 'du -sk /dev/shm/vardir/1574766704/51 | cut -f1' exited with value 0 # 2019-11-26T12:12:39 [61065] INFO: vardir_size : 679744 # 2019-11-26T12:12:45 [61065] INFO: Archive '/home/mleich/work/RQG_mleich_N/storage/1574766704/51/archive.tgz' created. # 2019-11-26T12:12:45 [61065] DEBUG: The RQG vardir '/dev/shm/vardir/1574766704/51' was removed. # 2019-11-26T12:12:45 [61065] SUMMARY: Final command line: ->perl /home/mleich/work/RQG_mleich_N/rqg.pl --duration=300 --queries=10000000 --threads=2 --no_mask --gendata=conf/mariadb/table_stress.zz --engine=InnoDB --sqltrace=MarkErrors --rpl_mode=none --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--connect_timeout=60 --mysqld=--lock-wait-timeout=86400 --mysqld=--slave_net_timeout=60 --mysqld=--net_write_timeout=60 --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--log-bin --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--wait_timeout=28800 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--innodb_adaptive_hash_index=off --mysqld=--log-output=none --mysqld=--innodb_stats_persistent=off --mysqld=--transaction-isolation=SERIALIZABLE --mysqld=--net_read_timeout=30 --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--loose-innodb_page_size=4096 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--interactive_timeout=28800 --whitelist_statuses='STATUS_SERVER_CRASHED' --whitelist_patterns='mysqld: .{1,150}btr0pcur.cc:.{1,30} void btr_pcur_store_position.{1,40}: Assertion .index->table->instant. failed.','mysqld: .{1,150}btr0cur.cc.{1,30}dberr_t btr_cur_instant_init_low.{1,100}' --blacklist_statuses='STATUS_OK' --blacklist_patterns='Possible endless loop in grammar.','\[ERROR\] InnoDB: preallocating .{1,120} with error 28',' is truncated: expected core file size ' --reporters=Backtrace,Deadlock1,ErrorLog --validators=None --grammar=/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy --grammar=/home/mleich/work/RQG_mleich_N/storage/1574766704/c00000.yy --workdir=/home/mleich/work/RQG_mleich_N/storage/1574766704/51 --vardir=/dev/shm/vardir/1574766704/51 --mtr-build-thread=980 --basedir1=/work/10.5/bld_debug/ --script_debug=_nix_ --seed=31663<- # 2019-11-26T12:12:45 [61065] SUMMARY: RQG GenData runtime in s : 0 # 2019-11-26T12:12:45 [61065] SUMMARY: RQG GenTest runtime in s : 23 # 2019-11-26T12:12:45 [61065] SUMMARY: RQG total runtime in s : 26 # 2019-11-26T12:12:45 [61065] SUMMARY: RQG verdict : replay # 2019-11-26T12:12:45 [61065] /home/mleich/work/RQG_mleich_N/rqg.pl will exit with exit status STATUS_SERVER_CRASHED(101)