# 2020-04-25T19:17:05 INFO: Logfile for RQG Worker [1] # 2020-04-25T19:17:05 [2435] Using Log::Log4perl # 2020-04-25T19:17:05 [2435] DEBUG: rqg_home might be ->/home/mleich/RQG_mleich<- # 2020-04-25T19:17:05 [2435] INFO: Environment variable 'RQG_HOME' set to '/home/mleich/RQG_mleich' # DEBUG: $0 ->/home/mleich/RQG_mleich/rqg.pl<- # DEBUG: rqg_home_call ->/home/mleich/RQG_mleich<- # DEBUG: rqg_home_env ->/home/mleich/RQG_mleich<- # DEBUG: start_cwd ->/home/mleich/RQG_mleich<- # 2020-04-25T19:17:05 [2435] INFO: script_debug : '_nix_' # 2020-04-25T19:17:05 [2435] DEBUG: After reading command line options # 2020-04-25T19:17:05 [2435] INFO: The 'rr' invocation type 'Server'. # 2020-04-25T19:17:05 [2435] INFO: RQG workdir : '/home/mleich/RQG_mleich/storage/1587842225/1' and infrastructure is prepared. # 2020-04-25T19:17:05 [2435] DEBUG: no_mask is defind. Therefore setting mask_level=0 , mask=0 and no_mask=undef. # 2020-04-25T19:17:05 [2435] Reading grammar from file '/home/mleich/RQG_mleich/storage/1587842225/c00000.yy'. # 2020-04-25T19:17:05 [2435] INFO: Sqltracing 'MarkErrors' enabled. # 2020-04-25T19:17:05 [2435] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2020-04-25T19:17:05 [2435] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2020-04-25T19:17:05 [2435] Starting # 2020-04-25T19:17:05 [2435] # /home/mleich/RQG_mleich/rqg.pl \ # 2020-04-25T19:17:05 [2435] # --duration=100 \ # 2020-04-25T19:17:05 [2435] # --queries=10000000 \ # 2020-04-25T19:17:05 [2435] # --threads=1 \ # 2020-04-25T19:17:05 [2435] # --no_mask \ # 2020-04-25T19:17:05 [2435] # --seed=random \ # 2020-04-25T19:17:05 [2435] # --engine=InnoDB \ # 2020-04-25T19:17:05 [2435] # --gendata=conf/mariadb/table_stress.zz \ # 2020-04-25T19:17:05 [2435] # --gendata_sql=conf/mariadb/table_stress.sql \ # 2020-04-25T19:17:05 [2435] # --sqltrace=MarkErrors \ # 2020-04-25T19:17:05 [2435] # --rpl_mode=none \ # 2020-04-25T19:17:05 [2435] # --mysqld=--lock-wait-timeout=86400 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose-idle_transaction_timeout=0 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--log-bin \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose-max-statement-time=30 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--interactive_timeout=28800 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose-idle_write_transaction_timeout=0 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--net_write_timeout=60 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--slave_net_timeout=60 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--log_bin_trust_function_creators=1 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--connect_timeout=60 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--log-output=none \ # 2020-04-25T19:17:05 [2435] # --mysqld=--innodb_page_size=4K \ # 2020-04-25T19:17:05 [2435] # --mysqld=--net_read_timeout=30 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--innodb-lock-wait-timeout=50 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--innodb_stats_persistent=off \ # 2020-04-25T19:17:05 [2435] # --mysqld=--wait_timeout=28800 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose-table_lock_wait_timeout=50 \ # 2020-04-25T19:17:05 [2435] # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # 2020-04-25T19:17:05 [2435] # --reporters=Backtrace,CrashRecovery1,Deadlock1,ErrorLog \ # 2020-04-25T19:17:05 [2435] # --validators=None \ # 2020-04-25T19:17:05 [2435] # --grammar=/home/mleich/RQG_mleich/storage/1587842225/c00000.yy \ # 2020-04-25T19:17:05 [2435] # --grammar=/home/mleich/RQG_mleich/storage/1587842225/c00000.yy \ # 2020-04-25T19:17:05 [2435] # --workdir=/home/mleich/RQG_mleich/storage/1587842225/1 \ # 2020-04-25T19:17:05 [2435] # --vardir=/dev/shm/vardir/1587842225/1 \ # 2020-04-25T19:17:05 [2435] # --mtr-build-thread=730 \ # 2020-04-25T19:17:05 [2435] # --basedir1=/home/mleich/Server_bin/10.5_debug \ # 2020-04-25T19:17:05 [2435] # --script_debug=_nix_ \ # 2020-04-25T19:17:05 [2435] # --rr=Server # 2020-04-25T19:17:05 [2435] INFO: build_thread : 730 # 2020-04-25T19:17:05 [2435] INFO: master_port : 24600 slave_port : 24601 ports : 24600 24601 24602 MTR_BUILD_THREAD : 730 # 2020-04-25T19:17:05 [2435] INFO: Number of servers involved = 1. (0 means unknown) # 2020-04-25T19:17:05 [2435] INFO: Early RQG basedirs : ->undef<-->/home/mleich/Server_bin/10.5_debug<-->undef<-->undef<- # 2020-04-25T19:17:05 [2435] DEBUG: $basedirs[0] is not defined or eq ''. Setting it to $basedirs[1] '/home/mleich/Server_bin/10.5_debug'. # 2020-04-25T19:17:05 [2435] INFO: Final RQG basedirs : ->/home/mleich/Server_bin/10.5_debug<-->/home/mleich/Server_bin/10.5_debug<-->undef<-->undef<- # 2020-04-25T19:17:05 [2435] INFO: RQG_HOME '/home/mleich/RQG_mleich' ---------- # 2020-04-25T19:17:05 [2435] DEBUG: 'git --version 2>&1' exited with value 0 # 2020-04-25T19:17:05 [2435] INFO: GIT on $rqg_home('/home/mleich/RQG_mleich') HEAD -> experimental, origin/experimental c1d9d5c134bd37015f087d1f4f520eaf4037a6eb 2020-04-25T18:28:32+02:00 # 2020-04-25T19:17:05 [2435] INFO: basedir[0] : /home/mleich/Server_bin/10.5_debug ---- # 2020-04-25T19:17:05 [2435] INFO: GIT on basedirs[0]('/home/mleich/Server_bin/10.5_debug') fatal: not a git repository (or any of the parent directories): .git # 2020-04-25T19:17:05 [2435] INFO: No protocol of build '/home/mleich/Server_bin/10.5_debugbuild.prt' found. # 2020-04-25T19:17:05 [2435] INFO: basedir[1] : /home/mleich/Server_bin/10.5_debug ---- # 2020-04-25T19:17:05 [2435] INFO: GIT on basedirs[1]('/home/mleich/Server_bin/10.5_debug') fatal: not a git repository (or any of the parent directories): .git # 2020-04-25T19:17:05 [2435] INFO: No protocol of build '/home/mleich/Server_bin/10.5_debugbuild.prt' found. # 2020-04-25T19:17:05 [2435] INFO: basedir[2] : ------------------------------ # 2020-04-25T19:17:05 [2435] INFO: Final RQG vardirs : ->/dev/shm/vardir/1587842225/1<-->/dev/shm/vardir/1587842225/1/1<- # 2020-04-25T19:17:05 [2435] tmpdir in GenTest ->/dev/shm/vardir/1587842225/1/<- # 2020-04-25T19:17:05 [2435] tmpdir in DBServer ->/dev/shm/vardir/1587842225/1/<- # 2020-04-25T19:17:05 [2435] INFO: Environment variable _RR_TRACE_DIR set to '/dev/shm/vardir/1587842225/1/rr_trace'. # 2020-04-25T19:17:05 [2435] DEBUG: subdir_list : ->sql<-->libexec<-->bin<-->sbin<- # 2020-04-25T19:17:05 [2435] DEBUG: Basedirs : ->/home/mleich/Server_bin/10.5_debug<-->/home/mleich/Server_bin/10.5_debug<-->undef<-->undef<- # 2020-04-25T19:17:05 [2435] DEBUG: debug_server : ->undef<-->undef<-->undef<- # 2020-04-25T19:17:05 [2435] DEBUG: Server binary found : '/home/mleich/Server_bin/10.5_debug/bin/mysqld'. # 2020-04-25T19:17:05 [2435] DEBUG: Server binary found : '/home/mleich/Server_bin/10.5_debug/bin/mysqld'. # 2020-04-25T19:17:05 [2435] INFO: seed eq 'random'. Computation. seed : 19918 # 2020-04-25T19:17:05 [2435] INFO: Final command line: ->perl /home/mleich/RQG_mleich/rqg.pl --duration=100 --queries=10000000 --threads=1 --no_mask --engine=InnoDB --gendata=conf/mariadb/table_stress.zz --gendata_sql=conf/mariadb/table_stress.sql --sqltrace=MarkErrors --rpl_mode=none --mysqld=--lock-wait-timeout=86400 --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--log-bin --mysqld=--loose-max-statement-time=30 --mysqld=--interactive_timeout=28800 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--net_write_timeout=60 --mysqld=--slave_net_timeout=60 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--connect_timeout=60 --mysqld=--log-output=none --mysqld=--innodb_page_size=4K --mysqld=--net_read_timeout=30 --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--innodb_stats_persistent=off --mysqld=--wait_timeout=28800 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--loose-idle_readonly_transaction_timeout=0 --reporters=Backtrace,CrashRecovery1,Deadlock1,ErrorLog --validators=None --grammar=/home/mleich/RQG_mleich/storage/1587842225/c00000.yy --grammar=/home/mleich/RQG_mleich/storage/1587842225/c00000.yy --workdir=/home/mleich/RQG_mleich/storage/1587842225/1 --vardir=/dev/shm/vardir/1587842225/1 --mtr-build-thread=730 --basedir1=/home/mleich/Server_bin/10.5_debug --script_debug=_nix_ --rr=Server --seed=19918<- # 2020-04-25T19:17:05 [2435] MATCHING: Region start ===================== # 2020-04-25T19:17:05 [2435] DEBUG: rpl_mode is 'none' # 2020-04-25T19:17:05 [2435] DEBUG: max_id is 0 # 2020-04-25T19:17:06 [2435] Creating MySQL 10.5.3 database at /dev/shm/vardir/1587842225/1/1/data # 2020-04-25T19:17:06 [2435] Bootstrap command: cat "/dev/shm/vardir/1587842225/1/1/boot.sql" | "/home/mleich/Server_bin/10.5_debug/bin/mysqld" "--no-defaults" "--basedir=/home/mleich/Server_bin/10.5_debug" "--lc-messages-dir=/home/mleich/Server_bin/10.5_debug/share" "--character-sets-dir=/home/mleich/Server_bin/10.5_debug/share/charsets" "--tmpdir=/dev/shm/vardir/1587842225/1/1/tmp" "--datadir=/dev/shm/vardir/1587842225/1/1/data" "--lock-wait-timeout=86400" "--loose-idle_transaction_timeout=0" "--log-bin" "--loose-max-statement-time=30" "--interactive_timeout=28800" "--loose-debug_assert_on_not_freed_memory=0" "--loose_innodb_lock_schedule_algorithm=fcfs" "--loose-idle_write_transaction_timeout=0" "--net_write_timeout=60" "--slave_net_timeout=60" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-output=none" "--innodb_page_size=4K" "--net_read_timeout=30" "--innodb-lock-wait-timeout=50" "--innodb_stats_persistent=off" "--wait_timeout=28800" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--sql-mode=no_engine_substitution" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--loose-server-audit-logging=OFF" "--bootstrap" # 2020-04-25T19:17:08 [2435] INFO: Starting MySQL 10.5.3: rr record --mark-stdio "/home/mleich/Server_bin/10.5_debug/bin/mysqld" "--no-defaults" "--basedir=/home/mleich/Server_bin/10.5_debug" "--lc-messages-dir=/home/mleich/Server_bin/10.5_debug/share" "--character-sets-dir=/home/mleich/Server_bin/10.5_debug/share/charsets" "--tmpdir=/dev/shm/vardir/1587842225/1/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1587842225/1/1/data" "--max-allowed-packet=128Mb" "--port=24600" "--socket=/dev/shm/vardir/1587842225/1/1/mysql.sock" "--pid-file=/dev/shm/vardir/1587842225/1/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1587842225/1/1/mysql.log" "--lock-wait-timeout=86400" "--loose-idle_transaction_timeout=0" "--log-bin" "--loose-max-statement-time=30" "--interactive_timeout=28800" "--loose-debug_assert_on_not_freed_memory=0" "--loose_innodb_lock_schedule_algorithm=fcfs" "--loose-idle_write_transaction_timeout=0" "--net_write_timeout=60" "--slave_net_timeout=60" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-output=none" "--innodb_page_size=4K" "--net_read_timeout=30" "--innodb-lock-wait-timeout=50" "--innodb_stats_persistent=off" "--wait_timeout=28800" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--sql-mode=no_engine_substitution" # 2020-04-25T19:17:09 [2435] DEBUG: Server pid found in error log: 3012 # 2020-04-25T19:17:09 [2435] MySQL Version: 10.5.3 # 2020-04-25T19:17:09 [2435] Binary: /home/mleich/Server_bin/10.5_debug/bin/mysqld # 2020-04-25T19:17:09 [2435] Type: Debug # 2020-04-25T19:17:09 [2435] Datadir: /dev/shm/vardir/1587842225/1/1/data # 2020-04-25T19:17:09 [2435] Tmpdir: /dev/shm/vardir/1587842225/1/1/tmp # 2020-04-25T19:17:09 [2435] Corefile: /dev/shm/vardir/1587842225/1/1/data/core.3012 # 2020-04-25T19:17:09 [2435] Connecting to 24600 # 2020-04-25T19:17:09 [2435] SVAR: alter_algorithm : DEFAULT # 2020-04-25T19:17:09 [2435] SVAR: analyze_sample_percentage : 100.000000 # 2020-04-25T19:17:09 [2435] SVAR: aria_block_size : 8192 # 2020-04-25T19:17:09 [2435] SVAR: aria_checkpoint_interval : 30 # 2020-04-25T19:17:09 [2435] SVAR: aria_checkpoint_log_activity : 1048576 # 2020-04-25T19:17:09 [2435] SVAR: aria_encrypt_tables : OFF # 2020-04-25T19:17:09 [2435] SVAR: aria_force_start_after_recovery_failures : 0 # 2020-04-25T19:17:09 [2435] SVAR: aria_group_commit : none # 2020-04-25T19:17:09 [2435] SVAR: aria_group_commit_interval : 0 # 2020-04-25T19:17:09 [2435] SVAR: aria_log_file_size : 1073741824 # 2020-04-25T19:17:09 [2435] SVAR: aria_log_purge_type : immediate # 2020-04-25T19:17:09 [2435] SVAR: aria_max_sort_file_size : 9223372036853727232 # 2020-04-25T19:17:09 [2435] SVAR: aria_page_checksum : ON # 2020-04-25T19:17:09 [2435] SVAR: aria_pagecache_age_threshold : 300 # 2020-04-25T19:17:09 [2435] SVAR: aria_pagecache_buffer_size : 134217728 # 2020-04-25T19:17:09 [2435] SVAR: aria_pagecache_division_limit : 100 # 2020-04-25T19:17:09 [2435] SVAR: aria_pagecache_file_hash_size : 512 # 2020-04-25T19:17:09 [2435] SVAR: aria_recover_options : BACKUP,QUICK # 2020-04-25T19:17:09 [2435] SVAR: aria_repair_threads : 1 # 2020-04-25T19:17:09 [2435] SVAR: aria_sort_buffer_size : 268434432 # 2020-04-25T19:17:09 [2435] SVAR: aria_stats_method : nulls_unequal # 2020-04-25T19:17:09 [2435] SVAR: aria_sync_log_dir : NEWFILE # 2020-04-25T19:17:09 [2435] SVAR: aria_used_for_temp_tables : ON # 2020-04-25T19:17:09 [2435] SVAR: auto_increment_increment : 1 # 2020-04-25T19:17:09 [2435] SVAR: auto_increment_offset : 1 # 2020-04-25T19:17:09 [2435] SVAR: autocommit : ON # 2020-04-25T19:17:09 [2435] SVAR: automatic_sp_privileges : ON # 2020-04-25T19:17:09 [2435] SVAR: back_log : 80 # 2020-04-25T19:17:09 [2435] SVAR: basedir : /home/mleich/Server_bin/10.5_debug # 2020-04-25T19:17:09 [2435] SVAR: big_tables : OFF # 2020-04-25T19:17:09 [2435] SVAR: bind_address : # 2020-04-25T19:17:09 [2435] SVAR: binlog_annotate_row_events : ON # 2020-04-25T19:17:09 [2435] SVAR: binlog_cache_size : 32768 # 2020-04-25T19:17:09 [2435] SVAR: binlog_checksum : CRC32 # 2020-04-25T19:17:09 [2435] SVAR: binlog_commit_wait_count : 0 # 2020-04-25T19:17:09 [2435] SVAR: binlog_commit_wait_usec : 100000 # 2020-04-25T19:17:09 [2435] SVAR: binlog_direct_non_transactional_updates : OFF # 2020-04-25T19:17:09 [2435] SVAR: binlog_file_cache_size : 16384 # 2020-04-25T19:17:09 [2435] SVAR: binlog_format : MIXED # 2020-04-25T19:17:09 [2435] SVAR: binlog_optimize_thread_scheduling : ON # 2020-04-25T19:17:09 [2435] SVAR: binlog_row_image : FULL # 2020-04-25T19:17:09 [2435] SVAR: binlog_row_metadata : NO_LOG # 2020-04-25T19:17:09 [2435] SVAR: binlog_stmt_cache_size : 32768 # 2020-04-25T19:17:09 [2435] SVAR: bulk_insert_buffer_size : 8388608 # 2020-04-25T19:17:09 [2435] SVAR: character_set_client : latin1 # 2020-04-25T19:17:09 [2435] SVAR: character_set_connection : latin1 # 2020-04-25T19:17:09 [2435] SVAR: character_set_database : latin1 # 2020-04-25T19:17:09 [2435] SVAR: character_set_filesystem : binary # 2020-04-25T19:17:09 [2435] SVAR: character_set_results : latin1 # 2020-04-25T19:17:09 [2435] SVAR: character_set_server : latin1 # 2020-04-25T19:17:09 [2435] SVAR: character_set_system : utf8 # 2020-04-25T19:17:09 [2435] SVAR: character_sets_dir : /home/mleich/Server_bin/10.5_debug/share/charsets/ # 2020-04-25T19:17:09 [2435] SVAR: check_constraint_checks : ON # 2020-04-25T19:17:09 [2435] SVAR: collation_connection : latin1_swedish_ci # 2020-04-25T19:17:09 [2435] SVAR: collation_database : latin1_swedish_ci # 2020-04-25T19:17:09 [2435] SVAR: collation_server : latin1_swedish_ci # 2020-04-25T19:17:09 [2435] SVAR: column_compression_threshold : 100 # 2020-04-25T19:17:09 [2435] SVAR: column_compression_zlib_level : 6 # 2020-04-25T19:17:09 [2435] SVAR: column_compression_zlib_strategy : DEFAULT_STRATEGY # 2020-04-25T19:17:09 [2435] SVAR: column_compression_zlib_wrap : OFF # 2020-04-25T19:17:09 [2435] SVAR: completion_type : NO_CHAIN # 2020-04-25T19:17:09 [2435] SVAR: concurrent_insert : AUTO # 2020-04-25T19:17:09 [2435] SVAR: connect_timeout : 60 # 2020-04-25T19:17:09 [2435] SVAR: core_file : ON # 2020-04-25T19:17:09 [2435] SVAR: datadir : /dev/shm/vardir/1587842225/1/1/data/ # 2020-04-25T19:17:09 [2435] SVAR: date_format : %Y-%m-%d # 2020-04-25T19:17:09 [2435] SVAR: datetime_format : %Y-%m-%d %H:%i:%s # 2020-04-25T19:17:09 [2435] SVAR: deadlock_search_depth_long : 15 # 2020-04-25T19:17:09 [2435] SVAR: deadlock_search_depth_short : 4 # 2020-04-25T19:17:09 [2435] SVAR: deadlock_timeout_long : 50000000 # 2020-04-25T19:17:09 [2435] SVAR: deadlock_timeout_short : 10000 # 2020-04-25T19:17:09 [2435] SVAR: debug : # 2020-04-25T19:17:09 [2435] SVAR: debug_binlog_fsync_sleep : 0 # 2020-04-25T19:17:09 [2435] SVAR: debug_dbug : # 2020-04-25T19:17:09 [2435] SVAR: debug_mutex_deadlock_detector : ON # 2020-04-25T19:17:09 [2435] SVAR: debug_no_thread_alarm : OFF # 2020-04-25T19:17:09 [2435] SVAR: debug_sync : OFF # 2020-04-25T19:17:09 [2435] SVAR: default_master_connection : # 2020-04-25T19:17:09 [2435] SVAR: default_password_lifetime : 0 # 2020-04-25T19:17:09 [2435] SVAR: default_regex_flags : # 2020-04-25T19:17:09 [2435] SVAR: default_storage_engine : InnoDB # 2020-04-25T19:17:09 [2435] SVAR: default_tmp_storage_engine : # 2020-04-25T19:17:09 [2435] SVAR: default_week_format : 0 # 2020-04-25T19:17:09 [2435] SVAR: delay_key_write : ON # 2020-04-25T19:17:09 [2435] SVAR: delayed_insert_limit : 100 # 2020-04-25T19:17:09 [2435] SVAR: delayed_insert_timeout : 300 # 2020-04-25T19:17:09 [2435] SVAR: delayed_queue_size : 1000 # 2020-04-25T19:17:09 [2435] SVAR: disconnect_on_expired_password : OFF # 2020-04-25T19:17:09 [2435] SVAR: div_precision_increment : 4 # 2020-04-25T19:17:09 [2435] SVAR: encrypt_binlog : OFF # 2020-04-25T19:17:09 [2435] SVAR: encrypt_tmp_disk_tables : OFF # 2020-04-25T19:17:09 [2435] SVAR: encrypt_tmp_files : OFF # 2020-04-25T19:17:09 [2435] SVAR: enforce_storage_engine : # 2020-04-25T19:17:09 [2435] SVAR: eq_range_index_dive_limit : 200 # 2020-04-25T19:17:09 [2435] SVAR: error_count : 0 # 2020-04-25T19:17:09 [2435] SVAR: event_scheduler : OFF # 2020-04-25T19:17:09 [2435] SVAR: expensive_subquery_limit : 100 # 2020-04-25T19:17:09 [2435] SVAR: expire_logs_days : 0 # 2020-04-25T19:17:09 [2435] SVAR: explicit_defaults_for_timestamp : OFF # 2020-04-25T19:17:09 [2435] SVAR: external_user : # 2020-04-25T19:17:09 [2435] SVAR: extra_max_connections : 1 # 2020-04-25T19:17:09 [2435] SVAR: extra_port : 0 # 2020-04-25T19:17:09 [2435] SVAR: flush : OFF # 2020-04-25T19:17:09 [2435] SVAR: flush_time : 0 # 2020-04-25T19:17:09 [2435] SVAR: foreign_key_checks : ON # 2020-04-25T19:17:09 [2435] SVAR: ft_boolean_syntax : + -><()~*:""&| # 2020-04-25T19:17:09 [2435] SVAR: ft_max_word_len : 84 # 2020-04-25T19:17:09 [2435] SVAR: ft_min_word_len : 4 # 2020-04-25T19:17:09 [2435] SVAR: ft_query_expansion_limit : 20 # 2020-04-25T19:17:09 [2435] SVAR: ft_stopword_file : (built-in) # 2020-04-25T19:17:09 [2435] SVAR: general_log : ON # 2020-04-25T19:17:09 [2435] SVAR: general_log_file : /dev/shm/vardir/1587842225/1/1/mysql.log # 2020-04-25T19:17:09 [2435] SVAR: group_concat_max_len : 1048576 # 2020-04-25T19:17:09 [2435] SVAR: gtid_binlog_pos : # 2020-04-25T19:17:09 [2435] SVAR: gtid_binlog_state : # 2020-04-25T19:17:09 [2435] SVAR: gtid_cleanup_batch_size : 64 # 2020-04-25T19:17:09 [2435] SVAR: gtid_current_pos : # 2020-04-25T19:17:09 [2435] SVAR: gtid_domain_id : 0 # 2020-04-25T19:17:09 [2435] SVAR: gtid_ignore_duplicates : OFF # 2020-04-25T19:17:09 [2435] SVAR: gtid_pos_auto_engines : # 2020-04-25T19:17:09 [2435] SVAR: gtid_seq_no : 0 # 2020-04-25T19:17:09 [2435] SVAR: gtid_slave_pos : # 2020-04-25T19:17:09 [2435] SVAR: gtid_strict_mode : OFF # 2020-04-25T19:17:09 [2435] SVAR: have_compress : YES # 2020-04-25T19:17:09 [2435] SVAR: have_crypt : YES # 2020-04-25T19:17:09 [2435] SVAR: have_dynamic_loading : YES # 2020-04-25T19:17:09 [2435] SVAR: have_geometry : YES # 2020-04-25T19:17:09 [2435] SVAR: have_openssl : NO # 2020-04-25T19:17:09 [2435] SVAR: have_profiling : YES # 2020-04-25T19:17:09 [2435] SVAR: have_query_cache : YES # 2020-04-25T19:17:09 [2435] SVAR: have_rtree_keys : YES # 2020-04-25T19:17:09 [2435] SVAR: have_ssl : DISABLED # 2020-04-25T19:17:09 [2435] SVAR: have_symlink : YES # 2020-04-25T19:17:09 [2435] SVAR: histogram_size : 254 # 2020-04-25T19:17:09 [2435] SVAR: histogram_type : DOUBLE_PREC_HB # 2020-04-25T19:17:09 [2435] SVAR: host_cache_size : 279 # 2020-04-25T19:17:09 [2435] SVAR: hostname : sdp # 2020-04-25T19:17:09 [2435] SVAR: identity : 0 # 2020-04-25T19:17:09 [2435] SVAR: idle_readonly_transaction_timeout : 0 # 2020-04-25T19:17:09 [2435] SVAR: idle_transaction_timeout : 0 # 2020-04-25T19:17:09 [2435] SVAR: idle_write_transaction_timeout : 0 # 2020-04-25T19:17:09 [2435] SVAR: ignore_builtin_innodb : OFF # 2020-04-25T19:17:09 [2435] SVAR: ignore_db_dirs : # 2020-04-25T19:17:09 [2435] SVAR: in_predicate_conversion_threshold : 1000 # 2020-04-25T19:17:09 [2435] SVAR: in_transaction : 0 # 2020-04-25T19:17:09 [2435] SVAR: init_connect : # 2020-04-25T19:17:09 [2435] SVAR: init_file : # 2020-04-25T19:17:09 [2435] SVAR: init_slave : # 2020-04-25T19:17:09 [2435] SVAR: innodb_adaptive_flushing : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_adaptive_flushing_lwm : 10.000000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_adaptive_hash_index : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_adaptive_hash_index_parts : 8 # 2020-04-25T19:17:09 [2435] SVAR: innodb_adaptive_max_sleep_delay : 150000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_autoextend_increment : 64 # 2020-04-25T19:17:09 [2435] SVAR: innodb_autoinc_lock_mode : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_background_drop_list_empty : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_background_scrub_data_check_interval : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_background_scrub_data_compressed : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_background_scrub_data_interval : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_background_scrub_data_uncompressed : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_buf_dump_status_frequency : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_buf_flush_list_now : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_chunk_size : 134217728 # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_dump_at_shutdown : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_dump_now : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_dump_pct : 25 # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_evict : # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_filename : ib_buffer_pool # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_instances : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_load_abort : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_load_at_startup : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_load_now : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_load_pages_abort : 9223372036854775807 # 2020-04-25T19:17:09 [2435] SVAR: innodb_buffer_pool_size : 134217728 # 2020-04-25T19:17:09 [2435] SVAR: innodb_change_buffer_dump : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_change_buffer_max_size : 25 # 2020-04-25T19:17:09 [2435] SVAR: innodb_change_buffering : all # 2020-04-25T19:17:09 [2435] SVAR: innodb_change_buffering_debug : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_checksum_algorithm : full_crc32 # 2020-04-25T19:17:09 [2435] SVAR: innodb_cmp_per_index_enabled : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_commit_concurrency : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_compression_algorithm : zlib # 2020-04-25T19:17:09 [2435] SVAR: innodb_compression_default : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_compression_failure_threshold_pct : 5 # 2020-04-25T19:17:09 [2435] SVAR: innodb_compression_level : 6 # 2020-04-25T19:17:09 [2435] SVAR: innodb_compression_pad_pct_max : 50 # 2020-04-25T19:17:09 [2435] SVAR: innodb_concurrency_tickets : 5000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_data_file_path : ibdata1:12M:autoextend # 2020-04-25T19:17:09 [2435] SVAR: innodb_data_file_size_debug : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_data_home_dir : # 2020-04-25T19:17:09 [2435] SVAR: innodb_deadlock_detect : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_default_encryption_key_id : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_default_row_format : dynamic # 2020-04-25T19:17:09 [2435] SVAR: innodb_defragment : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_defragment_fill_factor : 0.900000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_defragment_fill_factor_n_recs : 20 # 2020-04-25T19:17:09 [2435] SVAR: innodb_defragment_frequency : 40 # 2020-04-25T19:17:09 [2435] SVAR: innodb_defragment_n_pages : 7 # 2020-04-25T19:17:09 [2435] SVAR: innodb_defragment_stats_accuracy : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_dict_stats_disabled_debug : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_disable_resize_buffer_pool_debug : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_disable_sort_file_cache : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_disallow_writes : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_doublewrite : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_doublewrite_batch_size : 120 # 2020-04-25T19:17:09 [2435] SVAR: innodb_encrypt_log : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_encrypt_tables : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_encrypt_temporary_tables : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_encryption_rotate_key_age : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_encryption_rotation_iops : 100 # 2020-04-25T19:17:09 [2435] SVAR: innodb_encryption_threads : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_evict_tables_on_commit_debug : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_fast_shutdown : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_fatal_semaphore_wait_threshold : 600 # 2020-04-25T19:17:09 [2435] SVAR: innodb_fil_make_page_dirty_debug : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_file_format : # 2020-04-25T19:17:09 [2435] SVAR: innodb_file_per_table : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_fill_factor : 100 # 2020-04-25T19:17:09 [2435] SVAR: innodb_flush_log_at_timeout : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_flush_log_at_trx_commit : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_flush_method : fsync # 2020-04-25T19:17:09 [2435] SVAR: innodb_flush_neighbors : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_flush_sync : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_flushing_avg_loops : 30 # 2020-04-25T19:17:09 [2435] SVAR: innodb_force_load_corrupted : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_force_primary_key : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_force_recovery : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_aux_table : # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_cache_size : 8000000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_enable_diag_print : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_enable_stopword : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_max_token_size : 84 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_min_token_size : 3 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_num_word_optimize : 2000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_result_cache_limit : 2000000000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_server_stopword_table : # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_sort_pll_degree : 2 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_total_cache_size : 640000000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_ft_user_stopword_table : # 2020-04-25T19:17:09 [2435] SVAR: innodb_idle_flush_pct : 100 # 2020-04-25T19:17:09 [2435] SVAR: innodb_immediate_scrub_data_uncompressed : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_instant_alter_column_allowed : add_drop_reorder # 2020-04-25T19:17:09 [2435] SVAR: innodb_io_capacity : 200 # 2020-04-25T19:17:09 [2435] SVAR: innodb_io_capacity_max : 2000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_large_prefix : # 2020-04-25T19:17:09 [2435] SVAR: innodb_limit_optimistic_insert_debug : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_lock_schedule_algorithm : fcfs # 2020-04-25T19:17:09 [2435] SVAR: innodb_lock_wait_timeout : 50 # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_buffer_size : 16777216 # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_checkpoint_now : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_checksums : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_compressed_pages : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_file_size : 100663296 # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_files_in_group : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_group_home_dir : ./ # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_optimize_ddl : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_log_write_ahead_size : 4096 # 2020-04-25T19:17:09 [2435] SVAR: innodb_lru_scan_depth : 1024 # 2020-04-25T19:17:09 [2435] SVAR: innodb_master_thread_disabled_debug : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_max_dirty_pages_pct : 75.000000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_max_dirty_pages_pct_lwm : 0.000000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_max_purge_lag : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_max_purge_lag_delay : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_max_undo_log_size : 10485760 # 2020-04-25T19:17:09 [2435] SVAR: innodb_merge_threshold_set_all_debug : 50 # 2020-04-25T19:17:09 [2435] SVAR: innodb_monitor_disable : # 2020-04-25T19:17:09 [2435] SVAR: innodb_monitor_enable : # 2020-04-25T19:17:09 [2435] SVAR: innodb_monitor_reset : # 2020-04-25T19:17:09 [2435] SVAR: innodb_monitor_reset_all : # 2020-04-25T19:17:09 [2435] SVAR: innodb_old_blocks_pct : 37 # 2020-04-25T19:17:09 [2435] SVAR: innodb_old_blocks_time : 1000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_online_alter_log_max_size : 134217728 # 2020-04-25T19:17:09 [2435] SVAR: innodb_open_files : 2000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_optimize_fulltext_only : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_page_cleaner_disabled_debug : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_page_cleaners : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_page_hash_locks : 16 # 2020-04-25T19:17:09 [2435] SVAR: innodb_page_size : 4096 # 2020-04-25T19:17:09 [2435] SVAR: innodb_prefix_index_cluster_optimization : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_print_all_deadlocks : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_purge_batch_size : 300 # 2020-04-25T19:17:09 [2435] SVAR: innodb_purge_rseg_truncate_frequency : 128 # 2020-04-25T19:17:09 [2435] SVAR: innodb_purge_threads : 4 # 2020-04-25T19:17:09 [2435] SVAR: innodb_random_read_ahead : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_read_ahead_threshold : 56 # 2020-04-25T19:17:09 [2435] SVAR: innodb_read_io_threads : 4 # 2020-04-25T19:17:09 [2435] SVAR: innodb_read_only : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_replication_delay : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_rollback_on_timeout : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_saved_page_number_debug : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_scrub_log : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_scrub_log_speed : 256 # 2020-04-25T19:17:09 [2435] SVAR: innodb_simulate_comp_failures : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_sort_buffer_size : 1048576 # 2020-04-25T19:17:09 [2435] SVAR: innodb_spin_wait_delay : 4 # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_auto_recalc : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_include_delete_marked : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_method : nulls_equal # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_modified_counter : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_on_metadata : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_persistent : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_persistent_sample_pages : 20 # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_traditional : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_stats_transient_sample_pages : 8 # 2020-04-25T19:17:09 [2435] SVAR: innodb_status_output : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_status_output_locks : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_strict_mode : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_sync_array_size : 1 # 2020-04-25T19:17:09 [2435] SVAR: innodb_sync_debug : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_sync_spin_loops : 30 # 2020-04-25T19:17:09 [2435] SVAR: innodb_table_locks : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_temp_data_file_path : ibtmp1:12M:autoextend # 2020-04-25T19:17:09 [2435] SVAR: innodb_thread_concurrency : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_thread_sleep_delay : 10000 # 2020-04-25T19:17:09 [2435] SVAR: innodb_tmpdir : # 2020-04-25T19:17:09 [2435] SVAR: innodb_trx_purge_view_update_only_debug : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_trx_rseg_n_slots_debug : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_undo_directory : ./ # 2020-04-25T19:17:09 [2435] SVAR: innodb_undo_log_truncate : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_undo_logs : 128 # 2020-04-25T19:17:09 [2435] SVAR: innodb_undo_tablespaces : 0 # 2020-04-25T19:17:09 [2435] SVAR: innodb_use_atomic_writes : ON # 2020-04-25T19:17:09 [2435] SVAR: innodb_use_native_aio : OFF # 2020-04-25T19:17:09 [2435] SVAR: innodb_version : 10.5.3 # 2020-04-25T19:17:09 [2435] SVAR: innodb_write_io_threads : 4 # 2020-04-25T19:17:09 [2435] SVAR: insert_id : 0 # 2020-04-25T19:17:09 [2435] SVAR: interactive_timeout : 28800 # 2020-04-25T19:17:09 [2435] SVAR: join_buffer_size : 262144 # 2020-04-25T19:17:09 [2435] SVAR: join_buffer_space_limit : 2097152 # 2020-04-25T19:17:09 [2435] SVAR: join_cache_level : 2 # 2020-04-25T19:17:09 [2435] SVAR: keep_files_on_create : OFF # 2020-04-25T19:17:09 [2435] SVAR: key_buffer_size : 134217728 # 2020-04-25T19:17:09 [2435] SVAR: key_cache_age_threshold : 300 # 2020-04-25T19:17:09 [2435] SVAR: key_cache_block_size : 1024 # 2020-04-25T19:17:09 [2435] SVAR: key_cache_division_limit : 100 # 2020-04-25T19:17:09 [2435] SVAR: key_cache_file_hash_size : 512 # 2020-04-25T19:17:09 [2435] SVAR: key_cache_segments : 0 # 2020-04-25T19:17:09 [2435] SVAR: large_files_support : ON # 2020-04-25T19:17:09 [2435] SVAR: large_page_size : 0 # 2020-04-25T19:17:09 [2435] SVAR: large_pages : OFF # 2020-04-25T19:17:09 [2435] SVAR: last_gtid : # 2020-04-25T19:17:09 [2435] SVAR: last_insert_id : 0 # 2020-04-25T19:17:09 [2435] SVAR: lc_messages : en_US # 2020-04-25T19:17:09 [2435] SVAR: lc_messages_dir : /home/mleich/Server_bin/10.5_debug/share # 2020-04-25T19:17:09 [2435] SVAR: lc_time_names : en_US # 2020-04-25T19:17:09 [2435] SVAR: license : GPL # 2020-04-25T19:17:09 [2435] SVAR: local_infile : ON # 2020-04-25T19:17:09 [2435] SVAR: lock_wait_timeout : 86400 # 2020-04-25T19:17:09 [2435] SVAR: locked_in_memory : OFF # 2020-04-25T19:17:09 [2435] SVAR: log_bin : ON # 2020-04-25T19:17:09 [2435] SVAR: log_bin_basename : /dev/shm/vardir/1587842225/1/1/data/mysql-bin # 2020-04-25T19:17:09 [2435] SVAR: log_bin_compress : OFF # 2020-04-25T19:17:09 [2435] SVAR: log_bin_compress_min_len : 256 # 2020-04-25T19:17:09 [2435] SVAR: log_bin_index : /dev/shm/vardir/1587842225/1/1/data/mysql-bin.index # 2020-04-25T19:17:09 [2435] SVAR: log_bin_trust_function_creators : ON # 2020-04-25T19:17:09 [2435] SVAR: log_disabled_statements : sp # 2020-04-25T19:17:09 [2435] SVAR: log_error : # 2020-04-25T19:17:09 [2435] SVAR: log_output : NONE # 2020-04-25T19:17:09 [2435] SVAR: log_queries_not_using_indexes : OFF # 2020-04-25T19:17:09 [2435] SVAR: log_slave_updates : OFF # 2020-04-25T19:17:09 [2435] SVAR: log_slow_admin_statements : ON # 2020-04-25T19:17:09 [2435] SVAR: log_slow_disabled_statements : sp # 2020-04-25T19:17:09 [2435] SVAR: log_slow_filter : admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk # 2020-04-25T19:17:09 [2435] SVAR: log_slow_rate_limit : 1 # 2020-04-25T19:17:09 [2435] SVAR: log_slow_slave_statements : ON # 2020-04-25T19:17:09 [2435] SVAR: log_slow_verbosity : # 2020-04-25T19:17:09 [2435] SVAR: log_tc_size : 24576 # 2020-04-25T19:17:09 [2435] SVAR: log_warnings : 2 # 2020-04-25T19:17:09 [2435] SVAR: long_query_time : 10.000000 # 2020-04-25T19:17:09 [2435] SVAR: low_priority_updates : OFF # 2020-04-25T19:17:09 [2435] SVAR: lower_case_file_system : OFF # 2020-04-25T19:17:09 [2435] SVAR: lower_case_table_names : 0 # 2020-04-25T19:17:09 [2435] SVAR: master_verify_checksum : OFF # 2020-04-25T19:17:09 [2435] SVAR: max_allowed_packet : 134217728 # 2020-04-25T19:17:09 [2435] SVAR: max_binlog_cache_size : 18446744073709547520 # 2020-04-25T19:17:09 [2435] SVAR: max_binlog_size : 1073741824 # 2020-04-25T19:17:09 [2435] SVAR: max_binlog_stmt_cache_size : 18446744073709547520 # 2020-04-25T19:17:09 [2435] SVAR: max_connect_errors : 100 # 2020-04-25T19:17:09 [2435] SVAR: max_connections : 151 # 2020-04-25T19:17:09 [2435] SVAR: max_delayed_threads : 20 # 2020-04-25T19:17:09 [2435] SVAR: max_digest_length : 1024 # 2020-04-25T19:17:09 [2435] SVAR: max_error_count : 64 # 2020-04-25T19:17:09 [2435] SVAR: max_heap_table_size : 16777216 # 2020-04-25T19:17:09 [2435] SVAR: max_insert_delayed_threads : 20 # 2020-04-25T19:17:09 [2435] SVAR: max_join_size : 18446744073709551615 # 2020-04-25T19:17:09 [2435] SVAR: max_length_for_sort_data : 1024 # 2020-04-25T19:17:09 [2435] SVAR: max_password_errors : 4294967295 # 2020-04-25T19:17:09 [2435] SVAR: max_prepared_stmt_count : 16382 # 2020-04-25T19:17:09 [2435] SVAR: max_recursive_iterations : 4294967295 # 2020-04-25T19:17:09 [2435] SVAR: max_relay_log_size : 1073741824 # 2020-04-25T19:17:09 [2435] SVAR: max_rowid_filter_size : 131072 # 2020-04-25T19:17:09 [2435] SVAR: max_seeks_for_key : 4294967295 # 2020-04-25T19:17:09 [2435] SVAR: max_session_mem_used : 9223372036854775807 # 2020-04-25T19:17:09 [2435] SVAR: max_sort_length : 1024 # 2020-04-25T19:17:09 [2435] SVAR: max_sp_recursion_depth : 0 # 2020-04-25T19:17:09 [2435] SVAR: max_statement_time : 30.000000 # 2020-04-25T19:17:09 [2435] SVAR: max_tmp_tables : 32 # 2020-04-25T19:17:09 [2435] SVAR: max_user_connections : 0 # 2020-04-25T19:17:09 [2435] SVAR: max_write_lock_count : 4294967295 # 2020-04-25T19:17:09 [2435] SVAR: metadata_locks_cache_size : 1024 # 2020-04-25T19:17:09 [2435] SVAR: metadata_locks_hash_instances : 8 # 2020-04-25T19:17:09 [2435] SVAR: min_examined_row_limit : 0 # 2020-04-25T19:17:09 [2435] SVAR: mrr_buffer_size : 262144 # 2020-04-25T19:17:09 [2435] SVAR: myisam_block_size : 1024 # 2020-04-25T19:17:09 [2435] SVAR: myisam_data_pointer_size : 6 # 2020-04-25T19:17:09 [2435] SVAR: myisam_max_sort_file_size : 9223372036853727232 # 2020-04-25T19:17:09 [2435] SVAR: myisam_mmap_size : 18446744073709551615 # 2020-04-25T19:17:09 [2435] SVAR: myisam_recover_options : BACKUP,QUICK # 2020-04-25T19:17:09 [2435] SVAR: myisam_repair_threads : 1 # 2020-04-25T19:17:09 [2435] SVAR: myisam_sort_buffer_size : 134216704 # 2020-04-25T19:17:09 [2435] SVAR: myisam_stats_method : NULLS_UNEQUAL # 2020-04-25T19:17:09 [2435] SVAR: myisam_use_mmap : OFF # 2020-04-25T19:17:09 [2435] SVAR: mysql56_temporal_format : ON # 2020-04-25T19:17:09 [2435] SVAR: net_buffer_length : 16384 # 2020-04-25T19:17:09 [2435] SVAR: net_read_timeout : 30 # 2020-04-25T19:17:09 [2435] SVAR: net_retry_count : 10 # 2020-04-25T19:17:09 [2435] SVAR: net_write_timeout : 60 # 2020-04-25T19:17:09 [2435] SVAR: old : OFF # 2020-04-25T19:17:09 [2435] SVAR: old_alter_table : DEFAULT # 2020-04-25T19:17:09 [2435] SVAR: old_mode : # 2020-04-25T19:17:09 [2435] SVAR: old_passwords : OFF # 2020-04-25T19:17:09 [2435] SVAR: open_files_limit : 10240 # 2020-04-25T19:17:09 [2435] SVAR: optimizer_prune_level : 1 # 2020-04-25T19:17:09 [2435] SVAR: optimizer_search_depth : 62 # 2020-04-25T19:17:09 [2435] SVAR: optimizer_selectivity_sampling_limit : 100 # 2020-04-25T19:17:09 [2435] SVAR: 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 # 2020-04-25T19:17:09 [2435] SVAR: optimizer_trace : enabled=off # 2020-04-25T19:17:09 [2435] SVAR: optimizer_trace_max_mem_size : 1048576 # 2020-04-25T19:17:09 [2435] SVAR: optimizer_use_condition_selectivity : 4 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema : OFF # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_accounts_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_digests_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_stages_history_long_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_stages_history_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_statements_history_long_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_statements_history_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_transactions_history_long_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_transactions_history_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_waits_history_long_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_events_waits_history_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_hosts_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_cond_classes : 90 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_cond_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_digest_length : 1024 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_file_classes : 80 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_file_handles : 32768 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_file_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_index_stat : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_memory_classes : 320 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_metadata_locks : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_mutex_classes : 210 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_mutex_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_prepared_statements_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_program_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_rwlock_classes : 50 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_rwlock_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_socket_classes : 10 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_socket_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_sql_text_length : 1024 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_stage_classes : 160 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_statement_classes : 222 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_statement_stack : 10 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_table_handles : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_table_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_table_lock_stat : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_thread_classes : 50 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_max_thread_instances : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_session_connect_attrs_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_setup_actors_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_setup_objects_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: performance_schema_users_size : -1 # 2020-04-25T19:17:09 [2435] SVAR: pid_file : /dev/shm/vardir/1587842225/1/1/mysql.pid # 2020-04-25T19:17:09 [2435] SVAR: plugin_dir : /home/mleich/Server_bin/10.5_debug/lib/plugin/ # 2020-04-25T19:17:09 [2435] SVAR: plugin_maturity : alpha # 2020-04-25T19:17:09 [2435] SVAR: port : 24600 # 2020-04-25T19:17:09 [2435] SVAR: preload_buffer_size : 32768 # 2020-04-25T19:17:09 [2435] SVAR: profiling : OFF # 2020-04-25T19:17:09 [2435] SVAR: profiling_history_size : 15 # 2020-04-25T19:17:09 [2435] SVAR: progress_report_time : 5 # 2020-04-25T19:17:09 [2435] SVAR: protocol_version : 10 # 2020-04-25T19:17:09 [2435] SVAR: proxy_protocol_networks : # 2020-04-25T19:17:09 [2435] SVAR: proxy_user : # 2020-04-25T19:17:09 [2435] SVAR: pseudo_slave_mode : OFF # 2020-04-25T19:17:09 [2435] SVAR: pseudo_thread_id : 4 # 2020-04-25T19:17:09 [2435] SVAR: query_alloc_block_size : 16384 # 2020-04-25T19:17:09 [2435] SVAR: query_cache_limit : 1048576 # 2020-04-25T19:17:09 [2435] SVAR: query_cache_min_res_unit : 4096 # 2020-04-25T19:17:09 [2435] SVAR: query_cache_size : 1048576 # 2020-04-25T19:17:09 [2435] SVAR: query_cache_strip_comments : OFF # 2020-04-25T19:17:09 [2435] SVAR: query_cache_type : OFF # 2020-04-25T19:17:09 [2435] SVAR: query_cache_wlock_invalidate : OFF # 2020-04-25T19:17:09 [2435] SVAR: query_prealloc_size : 24576 # 2020-04-25T19:17:09 [2435] SVAR: rand_seed1 : 136988035 # 2020-04-25T19:17:09 [2435] SVAR: rand_seed2 : 456343124 # 2020-04-25T19:17:09 [2435] SVAR: range_alloc_block_size : 4096 # 2020-04-25T19:17:09 [2435] SVAR: read_binlog_speed_limit : 0 # 2020-04-25T19:17:09 [2435] SVAR: read_buffer_size : 131072 # 2020-04-25T19:17:09 [2435] SVAR: read_only : OFF # 2020-04-25T19:17:09 [2435] SVAR: read_rnd_buffer_size : 262144 # 2020-04-25T19:17:09 [2435] SVAR: relay_log : # 2020-04-25T19:17:09 [2435] SVAR: relay_log_basename : # 2020-04-25T19:17:09 [2435] SVAR: relay_log_index : # 2020-04-25T19:17:09 [2435] SVAR: relay_log_info_file : relay-log.info # 2020-04-25T19:17:09 [2435] SVAR: relay_log_purge : ON # 2020-04-25T19:17:09 [2435] SVAR: relay_log_recovery : OFF # 2020-04-25T19:17:09 [2435] SVAR: relay_log_space_limit : 0 # 2020-04-25T19:17:09 [2435] SVAR: replicate_annotate_row_events : ON # 2020-04-25T19:17:09 [2435] SVAR: replicate_do_db : # 2020-04-25T19:17:09 [2435] SVAR: replicate_do_table : # 2020-04-25T19:17:09 [2435] SVAR: replicate_events_marked_for_skip : REPLICATE # 2020-04-25T19:17:09 [2435] SVAR: replicate_ignore_db : # 2020-04-25T19:17:09 [2435] SVAR: replicate_ignore_table : # 2020-04-25T19:17:09 [2435] SVAR: replicate_wild_do_table : # 2020-04-25T19:17:09 [2435] SVAR: replicate_wild_ignore_table : # 2020-04-25T19:17:09 [2435] SVAR: report_host : # 2020-04-25T19:17:09 [2435] SVAR: report_password : # 2020-04-25T19:17:09 [2435] SVAR: report_port : 24600 # 2020-04-25T19:17:09 [2435] SVAR: report_user : # 2020-04-25T19:17:09 [2435] SVAR: require_secure_transport : OFF # 2020-04-25T19:17:09 [2435] SVAR: rowid_merge_buff_size : 8388608 # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_master_enabled : OFF # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_master_timeout : 10000 # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_master_trace_level : 32 # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_master_wait_no_slave : ON # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_master_wait_point : AFTER_COMMIT # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_slave_delay_master : OFF # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_slave_enabled : OFF # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_slave_kill_conn_timeout : 5 # 2020-04-25T19:17:09 [2435] SVAR: rpl_semi_sync_slave_trace_level : 32 # 2020-04-25T19:17:09 [2435] SVAR: secure_auth : ON # 2020-04-25T19:17:09 [2435] SVAR: secure_file_priv : # 2020-04-25T19:17:09 [2435] SVAR: secure_timestamp : NO # 2020-04-25T19:17:09 [2435] SVAR: server_id : 1 # 2020-04-25T19:17:09 [2435] SVAR: session_track_schema : ON # 2020-04-25T19:17:09 [2435] SVAR: session_track_state_change : OFF # 2020-04-25T19:17:09 [2435] SVAR: session_track_system_variables : autocommit,character_set_client,character_set_connection,character_set_results,time_zone # 2020-04-25T19:17:09 [2435] SVAR: session_track_transaction_info : OFF # 2020-04-25T19:17:09 [2435] SVAR: session_track_user_variables : OFF # 2020-04-25T19:17:09 [2435] SVAR: skip_external_locking : ON # 2020-04-25T19:17:09 [2435] SVAR: skip_name_resolve : OFF # 2020-04-25T19:17:09 [2435] SVAR: skip_networking : OFF # 2020-04-25T19:17:09 [2435] SVAR: skip_parallel_replication : OFF # 2020-04-25T19:17:09 [2435] SVAR: skip_replication : OFF # 2020-04-25T19:17:09 [2435] SVAR: skip_show_database : OFF # 2020-04-25T19:17:09 [2435] SVAR: slave_compressed_protocol : OFF # 2020-04-25T19:17:09 [2435] SVAR: slave_ddl_exec_mode : IDEMPOTENT # 2020-04-25T19:17:09 [2435] SVAR: slave_domain_parallel_threads : 0 # 2020-04-25T19:17:09 [2435] SVAR: slave_exec_mode : STRICT # 2020-04-25T19:17:09 [2435] SVAR: slave_load_tmpdir : /dev/shm/vardir/1587842225/1/1/tmp # 2020-04-25T19:17:09 [2435] SVAR: slave_max_allowed_packet : 1073741824 # 2020-04-25T19:17:09 [2435] SVAR: slave_net_timeout : 60 # 2020-04-25T19:17:09 [2435] SVAR: slave_parallel_max_queued : 131072 # 2020-04-25T19:17:09 [2435] SVAR: slave_parallel_mode : optimistic # 2020-04-25T19:17:09 [2435] SVAR: slave_parallel_threads : 0 # 2020-04-25T19:17:09 [2435] SVAR: slave_parallel_workers : 0 # 2020-04-25T19:17:09 [2435] SVAR: slave_run_triggers_for_rbr : NO # 2020-04-25T19:17:09 [2435] SVAR: slave_skip_errors : OFF # 2020-04-25T19:17:09 [2435] SVAR: slave_sql_verify_checksum : ON # 2020-04-25T19:17:09 [2435] SVAR: slave_transaction_retries : 10 # 2020-04-25T19:17:09 [2435] SVAR: slave_transaction_retry_errors : 1158,1159,1160,1161,1205,1213,1429,2013,12701 # 2020-04-25T19:17:09 [2435] SVAR: slave_transaction_retry_interval : 0 # 2020-04-25T19:17:09 [2435] SVAR: slave_type_conversions : # 2020-04-25T19:17:09 [2435] SVAR: slow_launch_time : 2 # 2020-04-25T19:17:09 [2435] SVAR: slow_query_log : OFF # 2020-04-25T19:17:09 [2435] SVAR: slow_query_log_file : sdp-slow.log # 2020-04-25T19:17:09 [2435] SVAR: socket : /dev/shm/vardir/1587842225/1/1/mysql.sock # 2020-04-25T19:17:09 [2435] SVAR: sort_buffer_size : 2097152 # 2020-04-25T19:17:09 [2435] SVAR: sql_auto_is_null : OFF # 2020-04-25T19:17:09 [2435] SVAR: sql_big_selects : ON # 2020-04-25T19:17:09 [2435] SVAR: sql_buffer_result : OFF # 2020-04-25T19:17:09 [2435] SVAR: sql_if_exists : OFF # 2020-04-25T19:17:09 [2435] SVAR: sql_log_bin : ON # 2020-04-25T19:17:09 [2435] SVAR: sql_log_off : OFF # 2020-04-25T19:17:09 [2435] SVAR: sql_mode : NO_ENGINE_SUBSTITUTION # 2020-04-25T19:17:09 [2435] SVAR: sql_notes : ON # 2020-04-25T19:17:09 [2435] SVAR: sql_quote_show_create : ON # 2020-04-25T19:17:09 [2435] SVAR: sql_safe_updates : OFF # 2020-04-25T19:17:09 [2435] SVAR: sql_select_limit : 18446744073709551615 # 2020-04-25T19:17:09 [2435] SVAR: sql_slave_skip_counter : 0 # 2020-04-25T19:17:09 [2435] SVAR: sql_warnings : OFF # 2020-04-25T19:17:09 [2435] SVAR: ssl_ca : # 2020-04-25T19:17:09 [2435] SVAR: ssl_capath : # 2020-04-25T19:17:09 [2435] SVAR: ssl_cert : # 2020-04-25T19:17:09 [2435] SVAR: ssl_cipher : # 2020-04-25T19:17:09 [2435] SVAR: ssl_crl : # 2020-04-25T19:17:09 [2435] SVAR: ssl_crlpath : # 2020-04-25T19:17:09 [2435] SVAR: ssl_key : # 2020-04-25T19:17:09 [2435] SVAR: standard_compliant_cte : ON # 2020-04-25T19:17:09 [2435] SVAR: storage_engine : InnoDB # 2020-04-25T19:17:09 [2435] SVAR: stored_program_cache : 256 # 2020-04-25T19:17:09 [2435] SVAR: strict_password_validation : ON # 2020-04-25T19:17:09 [2435] SVAR: sync_binlog : 0 # 2020-04-25T19:17:09 [2435] SVAR: sync_frm : ON # 2020-04-25T19:17:09 [2435] SVAR: sync_master_info : 10000 # 2020-04-25T19:17:09 [2435] SVAR: sync_relay_log : 10000 # 2020-04-25T19:17:09 [2435] SVAR: sync_relay_log_info : 10000 # 2020-04-25T19:17:09 [2435] SVAR: system_time_zone : UTC # 2020-04-25T19:17:09 [2435] SVAR: system_versioning_alter_history : ERROR # 2020-04-25T19:17:09 [2435] SVAR: system_versioning_asof : DEFAULT # 2020-04-25T19:17:09 [2435] SVAR: table_definition_cache : 400 # 2020-04-25T19:17:09 [2435] SVAR: table_open_cache : 2000 # 2020-04-25T19:17:09 [2435] SVAR: table_open_cache_instances : 2 # 2020-04-25T19:17:09 [2435] SVAR: tcp_keepalive_interval : 0 # 2020-04-25T19:17:09 [2435] SVAR: tcp_keepalive_probes : 0 # 2020-04-25T19:17:09 [2435] SVAR: tcp_keepalive_time : 0 # 2020-04-25T19:17:09 [2435] SVAR: tcp_nodelay : ON # 2020-04-25T19:17:09 [2435] SVAR: thread_cache_size : 151 # 2020-04-25T19:17:09 [2435] SVAR: thread_handling : one-thread-per-connection # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_dedicated_listener : OFF # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_exact_stats : OFF # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_idle_timeout : 60 # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_max_threads : 65536 # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_oversubscribe : 3 # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_prio_kickup_timer : 1000 # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_priority : auto # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_size : 1 # 2020-04-25T19:17:09 [2435] SVAR: thread_pool_stall_limit : 500 # 2020-04-25T19:17:09 [2435] SVAR: thread_stack : 299008 # 2020-04-25T19:17:09 [2435] SVAR: time_format : %H:%i:%s # 2020-04-25T19:17:09 [2435] SVAR: time_zone : SYSTEM # 2020-04-25T19:17:09 [2435] SVAR: timestamp : 1587842229.787464 # 2020-04-25T19:17:09 [2435] SVAR: tls_version : TLSv1.1,TLSv1.2,TLSv1.3 # 2020-04-25T19:17:09 [2435] SVAR: tmp_disk_table_size : 18446744073709551615 # 2020-04-25T19:17:09 [2435] SVAR: tmp_memory_table_size : 16777216 # 2020-04-25T19:17:09 [2435] SVAR: tmp_table_size : 16777216 # 2020-04-25T19:17:09 [2435] SVAR: tmpdir : /dev/shm/vardir/1587842225/1/1/tmp # 2020-04-25T19:17:09 [2435] SVAR: transaction_alloc_block_size : 8192 # 2020-04-25T19:17:09 [2435] SVAR: transaction_prealloc_size : 4096 # 2020-04-25T19:17:09 [2435] SVAR: tx_isolation : REPEATABLE-READ # 2020-04-25T19:17:09 [2435] SVAR: tx_read_only : OFF # 2020-04-25T19:17:09 [2435] SVAR: unique_checks : ON # 2020-04-25T19:17:09 [2435] SVAR: updatable_views_with_limit : YES # 2020-04-25T19:17:09 [2435] SVAR: use_stat_tables : PREFERABLY_FOR_QUERIES # 2020-04-25T19:17:09 [2435] SVAR: userstat : OFF # 2020-04-25T19:17:09 [2435] SVAR: version : 10.5.3-MariaDB-debug-log # 2020-04-25T19:17:09 [2435] SVAR: version_comment : Source distribution # 2020-04-25T19:17:09 [2435] SVAR: version_compile_machine : x86_64 # 2020-04-25T19:17:09 [2435] SVAR: version_compile_os : Linux # 2020-04-25T19:17:09 [2435] SVAR: version_malloc_library : system # 2020-04-25T19:17:09 [2435] SVAR: version_source_revision : 2b2dcf34f7325872b03534ebca31c396f449330f # 2020-04-25T19:17:09 [2435] SVAR: version_ssl_library : WolfSSL 4.3.0 # 2020-04-25T19:17:09 [2435] SVAR: wait_timeout : 28800 # 2020-04-25T19:17:09 [2435] SVAR: warning_count : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_auto_increment_control : ON # 2020-04-25T19:17:09 [2435] SVAR: wsrep_causal_reads : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_certification_rules : strict # 2020-04-25T19:17:09 [2435] SVAR: wsrep_certify_nonpk : ON # 2020-04-25T19:17:09 [2435] SVAR: wsrep_cluster_address : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_cluster_name : my_wsrep_cluster # 2020-04-25T19:17:09 [2435] SVAR: wsrep_convert_lock_to_trx : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_data_home_dir : /dev/shm/vardir/1587842225/1/1/data/ # 2020-04-25T19:17:09 [2435] SVAR: wsrep_dbug_option : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_debug : NONE # 2020-04-25T19:17:09 [2435] SVAR: wsrep_desync : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_dirty_reads : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_drupal_282555_workaround : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_forced_binlog_format : NONE # 2020-04-25T19:17:09 [2435] SVAR: wsrep_gtid_domain_id : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_gtid_mode : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_gtid_seq_no : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_ignore_apply_errors : 7 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_load_data_splitting : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_log_conflicts : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_max_ws_rows : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_max_ws_size : 2147483647 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_mysql_replication_bundle : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_node_address : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_node_incoming_address : AUTO # 2020-04-25T19:17:09 [2435] SVAR: wsrep_node_name : sdp # 2020-04-25T19:17:09 [2435] SVAR: wsrep_notify_cmd : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_on : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_osu_method : TOI # 2020-04-25T19:17:09 [2435] SVAR: wsrep_patch_version : wsrep_26.22 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_provider : none # 2020-04-25T19:17:09 [2435] SVAR: wsrep_provider_options : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_recover : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_reject_queries : NONE # 2020-04-25T19:17:09 [2435] SVAR: wsrep_replicate_myisam : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_restart_slave : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_retry_autocommit : 1 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_slave_fk_checks : ON # 2020-04-25T19:17:09 [2435] SVAR: wsrep_slave_threads : 1 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_slave_uk_checks : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sr_store : table # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sst_auth : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sst_donor : # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sst_donor_rejects_queries : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sst_method : rsync # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sst_receive_address : AUTO # 2020-04-25T19:17:09 [2435] SVAR: wsrep_start_position : 00000000-0000-0000-0000-000000000000:-1 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_strict_ddl : OFF # 2020-04-25T19:17:09 [2435] SVAR: wsrep_sync_wait : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_trx_fragment_size : 0 # 2020-04-25T19:17:09 [2435] SVAR: wsrep_trx_fragment_unit : bytes # 2020-04-25T19:17:09 [2435] DEBUG: dsns[0] defined. # 2020-04-25T19:17:09 [2435] --------------------------------------------------------------- # 2020-04-25T19:17:09 [2435] debug_server => ['undef', 'undef', 'undef'] # 2020-04-25T19:17:09 [2435] dsn => ['dbi:mysql:host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1'] # 2020-04-25T19:17:09 [2435] duration => 100 # 2020-04-25T19:17:09 [2435] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-04-25T19:17:09 [2435] gendata => /home/mleich/RQG_mleich/storage/1587842225/1/rqg.zz # 2020-04-25T19:17:09 [2435] gendata_sql => ['/home/mleich/RQG_mleich/storage/1587842225/1/rqg.sql'] # 2020-04-25T19:17:09 [2435] generator => FromGrammar # 2020-04-25T19:17:09 [2435] grammar => /home/mleich/RQG_mleich/storage/1587842225/1/rqg.yy # 2020-04-25T19:17:09 [2435] logfile => /home/mleich/RQG_mleich/storage/1587842225/1/rqg.log # 2020-04-25T19:17:09 [2435] mask => 0 # 2020-04-25T19:17:09 [2435] mask-level => 0 # 2020-04-25T19:17:09 [2435] queries => 10000000 # 2020-04-25T19:17:09 [2435] reporters => ['Backtrace', 'CrashRecovery1', 'Deadlock1', 'ErrorLog'] # 2020-04-25T19:17:09 [2435] rpl_mode => none # 2020-04-25T19:17:09 [2435] rr => 1 # 2020-04-25T19:17:09 [2435] seed => 19918 # 2020-04-25T19:17:09 [2435] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x55741f8299c8)'] # 2020-04-25T19:17:09 [2435] sqltrace => MarkErrors # 2020-04-25T19:17:09 [2435] threads => 1 # 2020-04-25T19:17:09 [2435] validators => ['None'] # 2020-04-25T19:17:09 [2435] vcols => ['undef', 'undef', 'undef'] # 2020-04-25T19:17:09 [2435] views => ['undef', 'undef', 'undef'] # 2020-04-25T19:17:09 [2435] --------------------------------------------------------------- # 2020-04-25T19:17:09 [2435] ------------------------------- # 2020-04-25T19:17:09 [2435] Configuration # 2020-04-25T19:17:09 [2435] debug_server => ['undef', 'undef', 'undef'] # 2020-04-25T19:17:09 [2435] dsn => ['dbi:mysql:host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1'] # 2020-04-25T19:17:09 [2435] duration => 100 # 2020-04-25T19:17:09 [2435] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-04-25T19:17:09 [2435] gendata => /home/mleich/RQG_mleich/storage/1587842225/1/rqg.zz # 2020-04-25T19:17:09 [2435] gendata_sql => ['/home/mleich/RQG_mleich/storage/1587842225/1/rqg.sql'] # 2020-04-25T19:17:09 [2435] generator => FromGrammar # 2020-04-25T19:17:09 [2435] grammar => /home/mleich/RQG_mleich/storage/1587842225/1/rqg.yy # 2020-04-25T19:17:09 [2435] logfile => /home/mleich/RQG_mleich/storage/1587842225/1/rqg.log # 2020-04-25T19:17:09 [2435] mask => 0 # 2020-04-25T19:17:09 [2435] mask-level => 0 # 2020-04-25T19:17:09 [2435] queries => 10000000 # 2020-04-25T19:17:09 [2435] reporters => ['Backtrace', 'CrashRecovery1', 'Deadlock1', 'ErrorLog'] # 2020-04-25T19:17:09 [2435] rpl_mode => none # 2020-04-25T19:17:09 [2435] rr => 1 # 2020-04-25T19:17:09 [2435] seed => 19918 # 2020-04-25T19:17:09 [2435] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x55741f8299c8)'] # 2020-04-25T19:17:09 [2435] sqltrace => MarkErrors # 2020-04-25T19:17:09 [2435] threads => 1 # 2020-04-25T19:17:09 [2435] validators => ['None'] # 2020-04-25T19:17:09 [2435] vcols => ['undef', 'undef', 'undef'] # 2020-04-25T19:17:09 [2435] views => ['undef', 'undef', 'undef'] # 2020-04-25T19:17:09 [2435] INFO: Begin of GenData activity # 2020-04-25T19:17:09 [2435] INFO: Starting GenTest::App::Gendata [2435] SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' /* E_R Gendata QNO 1 CON_ID 6 */ ; [2435] SET SQL_MODE= CONCAT(@@sql_mode,',NO_ENGINE_SUBSTITUTION') /* E_R Gendata QNO 2 CON_ID 6 */ ; [2435] SET DEFAULT_STORAGE_ENGINE= 'InnoDB' /* E_R Gendata QNO 3 CON_ID 6 */ ; [2435] CREATE SCHEMA /*!IF NOT EXISTS*/ test /* E_R Gendata QNO 4 CON_ID 6 */ ; [2435] USE test /* E_R Gendata QNO 5 CON_ID 6 */ ; # 2020-04-25T19:17:09 [2435] Creating MySQL table: test.table0_innodb_int; engine: innodb; rows: 0 . [2435] DROP TABLE /*! IF EXISTS*/ table0_innodb_int /* E_R Gendata QNO 6 CON_ID 6 */ ; [2435] CREATE TABLE `table0_innodb_int` ( pk int, `col_int` int, /*Indices*/ primary key (pk)) ENGINE=innodb /* E_R Gendata QNO 7 CON_ID 6 */ ; [2435] ALTER TABLE `table0_innodb_int` DISABLE KEYS /* E_R Gendata QNO 8 CON_ID 6 */ ; [2435] COMMIT /* E_R Gendata QNO 9 CON_ID 6 */ ; [2435] ALTER TABLE `table0_innodb_int` ENABLE KEYS /* E_R Gendata QNO 10 CON_ID 6 */ ; [2435] COMMIT /* E_R Gendata QNO 11 CON_ID 6 */ ; [2435] USE test /* E_R Gendata QNO 12 CON_ID 6 */ ; # 2020-04-25T19:17:09 [2435] INFO: Finishing GenTest::App::Gendata # 2020-04-25T19:17:09 [2435] INFO: Start processing the SQL file '/home/mleich/RQG_mleich/storage/1587842225/1/rqg.sql'. # 2020-04-25T19:17:09 [2435] INFO: Starting GenTest::App::GendataSQL [2435] SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' /* E_R GendataSQL QNO 13 CON_ID 7 */ ; [2435] SET SQL_MODE= CONCAT(@@sql_mode, ',NO_ENGINE_SUBSTITUTION') /* E_R GendataSQL QNO 14 CON_ID 7 */ ; [2435] SET @@max_statement_time = 0 /* E_R GendataSQL QNO 15 CON_ID 7 */ ; # 2020-04-25T19:17:09 [2435] # Copyright (c) 2018, 2019 MariaDB Corporation Ab. # 2020-04-25T19:17:09 [2435] # # 2020-04-25T19:17:09 [2435] # This program is free software; you can redistribute it and/or modify # 2020-04-25T19:17:09 [2435] # it under the terms of the GNU General Public License as published by # 2020-04-25T19:17:09 [2435] # the Free Software Foundation; version 2 of the License. # 2020-04-25T19:17:09 [2435] # # 2020-04-25T19:17:09 [2435] # Bookkeeping for RQG test threads which are allowed to be target of some # 2020-04-25T19:17:09 [2435] # KILL QUERY or KILL issued by the YY grammar. # 2020-04-25T19:17:09 [2435] # # 2020-04-25T19:17:09 [2435] # Concept: # 2020-04-25T19:17:09 [2435] # 1. *.sql creates the container (the table). # 2020-04-25T19:17:09 [2435] # 2. Per YY grammar (usual rule 'thread_connect') all RQG worker # 2020-04-25T19:17:09 [2435] # threads which are allowed to get affected by KILL ... # 2020-04-25T19:17:09 [2435] # - add (first connect) or # 2020-04-25T19:17:09 [2435] # - replace (non first connect) # 2020-04-25T19:17:09 [2435] # their entry in that table. # 2020-04-25T19:17:09 [2435] # 3. Per YY grammar RQG worker threads might manipulate the entries in this table. # 2020-04-25T19:17:09 [2435] # 4. Per YY grammar RQG worker threads (usual rule 'kill_query_or_session_or_release' # 2020-04-25T19:17:09 [2435] # pick a processlist_id following whatever strategy (where condition) from this # 2020-04-25T19:17:09 [2435] # table and "attack" the session via KILL ... # 2020-04-25T19:17:09 [2435] # Notes: # 2020-04-25T19:17:09 [2435] # The content of the table is expected to be imperfect because it cannot # 2020-04-25T19:17:09 [2435] # guaranteed that # 2020-04-25T19:17:09 [2435] # - a DML (INSERT/UPDATE/REPLACE/DELETE) passes # 2020-04-25T19:17:09 [2435] # Transaction related fails are possible but expected to be rare because the # 2020-04-25T19:17:09 [2435] # data modifying statements are rare. Of course the storage engine properties # 2020-04-25T19:17:09 [2435] # will have some impact too. # 2020-04-25T19:17:09 [2435] # - the actual content of that table reflects the current state of the system # 2020-04-25T19:17:09 [2435] # For example the last refresh of the table content might be too long ago. # 2020-04-25T19:17:09 [2435] # A KILL using # 2020-04-25T19:17:09 [2435] # - some processlist_id value of NULL or of some currently not existing id # 2020-04-25T19:17:09 [2435] # will fail like expected but make no further trouble # 2020-04-25T19:17:09 [2435] # - some id belonging to some historic session already gone can never affect # 2020-04-25T19:17:09 [2435] # some other currently existing session (maybe a RQG worker thread, some # 2020-04-25T19:17:09 [2435] # reporter or whatever) because the DB server counts the ids all time up. # 2020-04-25T19:17:09 [2435] # So that KILL ... will fail too. # 2020-04-25T19:17:09 [2435] # # 2020-04-25T19:17:09 [2435] # rqg_id -- id of the RQG worker thread used within RQG # 2020-04-25T19:17:09 [2435] # This allows to identify what this worker is told to do # 2020-04-25T19:17:09 [2435] # per YY grammar content. # 2020-04-25T19:17:09 [2435] # processlist_id -- Processlist id of the RQG worker thread # 2020-04-25T19:17:09 [2435] # The value to be used in KILL ... # 2020-04-25T19:17:09 [2435] # pid -- The process id in the OS. # 2020-04-25T19:17:09 [2435] # Maybe its some day in future useful. # 2020-04-25T19:17:09 [2435] # connect_time -- The time of the last connect. # 2020-04-25T19:17:09 [2435] # The diff between current time and this could be used for # 2020-04-25T19:17:09 [2435] # sophisticated functionality like # 2020-04-25T19:17:09 [2435] # - longer lifetime is required (but not already sufficient) # 2020-04-25T19:17:09 [2435] # for generating bigger transactions # 2020-04-25T19:17:09 [2435] # - less connects and disconnects for some RQG worker thread # 2020-04-25T19:17:09 [2435] # increase the stress on functionality maybe in focus by # 2020-04-25T19:17:09 [2435] # spending less ressources on required activity being # 2020-04-25T19:17:09 [2435] # not or at least less in focus of checking # 2020-04-25T19:17:09 [2435] # # 2020-04-25T19:17:09 [2435] # Picking some good enough ENGINE for test . rqg_sessions: # 2020-04-25T19:17:09 [2435] # There are test variants which invoke killing the server process intentionally, # 2020-04-25T19:17:09 [2435] # restart and go on with whatever. # 2020-04-25T19:17:09 [2435] # 1. In case we would use MyISAM than we would have a serious risk that the table needs to be # 2020-04-25T19:17:09 [2435] # repaired after such a crash. This would disturb to some more or less big extend. # 2020-04-25T19:17:09 [2435] # 2. In case we would use some more robust storage engine like InnoDB than the table should # 2020-04-25T19:17:09 [2435] # survive the crash without trouble on restart etc. # 2020-04-25T19:17:09 [2435] # 3. For whatever engine where the table has survived without damage and proper data # 2020-04-25T19:17:09 [2435] # we might be faced with minor trouble because of the data. # 2020-04-25T19:17:09 [2435] # That all belongs to the previous server uptime. # 2020-04-25T19:17:09 [2435] # So it looks like ENGINE = MEMORY is the optimal choice. # 2020-04-25T19:17:09 [2435] # FIXME: # 2020-04-25T19:17:09 [2435] # Is it necessary to protect the table against grammars and redefines which use # 2020-04-25T19:17:09 [2435] # the YY grammar language builtin '_table' and attack them via DDL or DML? # 2020-04-25T19:17:09 [2435] # [2435] CREATE SCHEMA rqg; /* E_R GendataSQL QNO 16 CON_ID 7 */ ; [2435] CREATE TABLE IF NOT EXISTS rqg . rqg_sessions (rqg_id BIGINT, processlist_id BIGINT, pid BIGINT, connect_time INT, PRIMARY KEY(rqg_id)) ENGINE = MEMORY ; /* E_R GendataSQL QNO 17 CON_ID 7 */ ; [2435] COMMIT /* E_R GendataSQL QNO 18 CON_ID 7 */ ; # 2020-04-25T19:17:09 [2435] INFO: End of GenData activity # 2020-04-25T19:17:09 [2435] GenData returned status STATUS_OK (0) # 2020-04-25T19:17:09 [2435] INFO: RQG GenData runtime in s : 0 # 2020-04-25T19:17:09 [2435] INFO: GenTest: Start of running queries : 1587842230 # 2020-04-25T19:17:09 [2435] Reading grammar from file '/home/mleich/RQG_mleich/storage/1587842225/1/rqg.yy'. # 2020-04-25T19:17:09 [2435] Reporters (for Simplifier): ->Backtrace<->CrashRecovery1<->Deadlock1<->ErrorLog<->None<->ServerDead<- # 2020-04-25T19:17:09 [2435] INFO: Reporter 'Backtrace' added. # 2020-04-25T19:17:09 [2435] INFO: Reporter 'CrashRecovery1' added. # 2020-04-25T19:17:09 [2435] INFO: Reporter 'Deadlock1' added. # 2020-04-25T19:17:10 [2435] INFO: Reporter 'ErrorLog' added. # 2020-04-25T19:17:10 [2435] INFO: Reporter 'ServerDead' added. # 2020-04-25T19:17:10 [2435] Validators (for Simplifier): ->None<- # 2020-04-25T19:17:10 [2435] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1 # 2020-04-25T19:17:12 [2435] Starting 1 processes, 10000000 queries each, duration 100 seconds. # 2020-04-25T19:17:12 [2435] GenTest::ErrorFilter(6169) started [6173] SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' /* E_R Thread1 QNO 21 CON_ID 14 */ ; # 2020-04-25T19:17:12 [6173] INFO: Thread1 : Mixer created. [6173] CREATE TABLE IF NOT EXISTS t1 ( col1 INT, col2 INT, col_int INTEGER, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = Dynamic /* E_R Thread1 QNO 22 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 23 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 24 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 25 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 26 CON_ID 14 */ ; # 2020-04-25T19:17:12 [6171] INFO: Periodic reporting process at begin of activity # 2020-04-25T19:17:12 [6171] INFO: Reporter 'CrashRecovery1': First monitoring [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 27 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 28 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 29 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 30 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 31 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 32 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 33 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 34 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 35 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 36 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 37 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 38 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 39 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 40 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 41 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 42 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 43 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 44 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 45 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 46 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 47 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 48 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 49 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 50 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 51 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 52 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 53 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 54 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 55 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 56 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 57 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 58 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 59 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 60 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 61 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 62 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 63 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 64 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 65 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 66 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 67 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 68 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 69 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 70 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 71 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 72 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 73 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 74 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 75 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 76 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 77 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 78 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 79 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 80 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 81 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 82 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 83 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 84 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 85 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 86 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 87 CON_ID 14 */ ; [6173] ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 88 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 89 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 90 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 91 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 92 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 93 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 94 CON_ID 14 */ ; # 2020-04-25T19:17:30 [6169] ErrorFilter: Query: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 93 CON_ID 14 */ failed: 1069 Too many keys specified; max %d keys allowed. Further errors of this kind will be suppressed. # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 95 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 96 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 97 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 98 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 99 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 100 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 101 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 102 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 103 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 104 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 105 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 106 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 107 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 108 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 109 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 110 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 111 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 112 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 113 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 114 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 115 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 116 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 117 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 118 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 119 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 120 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 121 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 122 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 123 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 124 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 125 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 126 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 127 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 128 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 129 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 130 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 131 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 132 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 133 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 134 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 135 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 136 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 137 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 138 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 139 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 140 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 141 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 142 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 143 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 144 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 145 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 146 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 147 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 148 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 149 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 150 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 151 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 152 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 153 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 154 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 155 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 156 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 157 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 158 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 159 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 160 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 161 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 162 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 163 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 164 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 165 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 166 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 167 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 168 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 169 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 170 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 171 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 172 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 173 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 174 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 175 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 176 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 177 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 178 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 179 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 180 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 181 CON_ID 14 */ ; [6173] TRUNCATE TABLE t1 /* E_R Thread1 QNO 182 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 183 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 184 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 185 CON_ID 14 */ ; # [6173] [sqltrace] ERROR 1069: ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) /* E_R Thread1 QNO 186 CON_ID 14 */ ; # 2020-04-25T19:18:33 [6171] INFO: Reporter 'CrashRecovery1': Sending SIGKILL to server with pid 3012 in order to force a crash. # [6173] [sqltrace] ERROR 2013: TRUNCATE TABLE t1 /* E_R Thread1 QNO 187 CON_ID 14 */ ; # 2020-04-25T19:18:33 [6173] Executor::MySQL::execute: Query: TRUNCATE TABLE t1 /* E_R Thread1 QNO 187 CON_ID 14 */ failed: 2013 Lost connection to MySQL server during query # 2020-04-25T19:18:33 [6171] ERROR: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1 failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 104 after 0.0954658985137939 s. # 2020-04-25T19:18:33 [6171] ERROR: Reporter 'Deadlock': Will return status 101. # 2020-04-25T19:18:33 [6171] ERROR: Periodic reporting process: Critical status STATUS_SERVER_KILLED got. Will exit with that. # 2020-04-25T19:18:33 [6171] GenTest: child 6171 is being stopped with status STATUS_SERVER_KILLED # 2020-04-25T19:18:37 [2435] Process with pid 6171 for periodic reporter ended with status STATUS_SERVER_KILLED # 2020-04-25T19:18:37 [2435] Killing (TERM) remaining worker process with pid 6173... # 2020-04-25T19:18:38 [2435] Process with pid 6173 for Thread1 ended with status STATUS_OK # 2020-04-25T19:18:52 [2435] Kill GenTest::ErrorFilter(6169) # 2020-04-25T19:18:52 [2435] INFO: GenTest: Effective duration in s : 102 DBI connect('host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at lib/GenTest/Reporter/CrashRecovery1.pm line 94. # 2020-04-25T19:18:52 [2435] INFO: Reporter 'CrashRecovery1': Copying datadir... (interrupting the copy operation may cause investigation problems later) # 2020-04-25T19:18:52 [2435] INFO: Reporter 'CrashRecovery1': Attempting database recovery using the server ... # 2020-04-25T19:18:52 [2435] INFO: Starting MySQL 10.5.3: rr record --mark-stdio "/home/mleich/Server_bin/10.5_debug/bin/mysqld" "--no-defaults" "--basedir=/home/mleich/Server_bin/10.5_debug" "--lc-messages-dir=/home/mleich/Server_bin/10.5_debug/share" "--character-sets-dir=/home/mleich/Server_bin/10.5_debug/share/charsets" "--tmpdir=/dev/shm/vardir/1587842225/1/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1587842225/1/1/data" "--max-allowed-packet=128Mb" "--port=24600" "--socket=/dev/shm/vardir/1587842225/1/1/mysql.sock" "--pid-file=/dev/shm/vardir/1587842225/1/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1587842225/1/1/mysql.log" "--lock-wait-timeout=86400" "--loose-idle_transaction_timeout=0" "--log-bin" "--loose-max-statement-time=30" "--interactive_timeout=28800" "--loose-debug_assert_on_not_freed_memory=0" "--loose_innodb_lock_schedule_algorithm=fcfs" "--loose-idle_write_transaction_timeout=0" "--net_write_timeout=60" "--slave_net_timeout=60" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-output=none" "--innodb_page_size=4K" "--net_read_timeout=30" "--innodb-lock-wait-timeout=50" "--innodb_stats_persistent=off" "--wait_timeout=28800" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--sql-mode=no_engine_substitution" "--innodb-buffer-pool-size=24M" # 2020-04-25T19:18:54 [2435] DEBUG: Server pid found in error log: 40350 # 2020-04-25T19:19:04 [2435] --------- Contents of /dev/shm/vardir/1587842225/1/1/mysql.err ------------- # 2020-04-25T19:19:04 [2435] | [rr 40350 1526]2020-04-25 19:18:53 0 [Note] /home/mleich/Server_bin/10.5_debug/bin/mysqld (mysqld 10.5.3-MariaDB-debug-log) starting as process 40350 ... # 2020-04-25T19:19:04 [2435] | [rr 40350 1540]2020-04-25 19:18:53 0 [Warning] Could not increase number of max_open_files to more than 10240 (request: 32183) # 2020-04-25T19:19:04 [2435] | [rr 40350 1654]2020-04-25 19:18:53 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=sdp' or '--log-bin=mysql-bin' to avoid this problem. # 2020-04-25T19:19:04 [2435] | [rr 40350 1769]2020-04-25 19:18:53 0 [Note] InnoDB: innodb_page_size=4096 # 2020-04-25T19:19:04 [2435] | [rr 40350 1773]2020-04-25 19:18:53 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2020-04-25T19:19:04 [2435] | [rr 40350 1777]2020-04-25 19:18:53 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2020-04-25T19:19:04 [2435] | [rr 40350 1781]2020-04-25 19:18:53 0 [Note] InnoDB: Uses event mutexes # 2020-04-25T19:19:04 [2435] | [rr 40350 1785]2020-04-25 19:18:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2020-04-25T19:19:04 [2435] | [rr 40350 1795]2020-04-25 19:18:53 0 [Note] InnoDB: Number of pools: 1 # 2020-04-25T19:19:04 [2435] | [rr 40350 1808]2020-04-25 19:18:53 0 [Note] InnoDB: Using SSE2 crc32 instructions # 2020-04-25T19:19:04 [2435] | [rr 40350 1812]2020-04-25 19:18:53 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/vardir/1587842225/1/1/tmp (disabling future attempts) # 2020-04-25T19:19:04 [2435] | [rr 40350 1845]2020-04-25 19:18:53 0 [Note] InnoDB: Initializing buffer pool, total size = 25165824, chunk size = 25165824 # 2020-04-25T19:19:04 [2435] | [rr 40350 1941]2020-04-25 19:18:53 0 [Note] InnoDB: Completed initialization of buffer pool # 2020-04-25T19:19:04 [2435] | [rr 40350 2000]2020-04-25 19:18:53 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). # 2020-04-25T19:19:04 [2435] | [rr 40350 2019]2020-04-25 19:18:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2754798 # 2020-04-25T19:19:04 [2435] | [rr 40350 2027]2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 83, since the redo log references ./test/t1.ibd with space ID 82. # 2020-04-25T19:19:04 [2435] | [rr 40350 2031]2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 82. Another data file called ./test/#sql-ib97.ibd exists with the same space ID. # 2020-04-25T19:19:04 [2435] | [rr 40350 5206]mysqld: /home/mleich/10.5/storage/innobase/include/btr0btr.h:241: buf_block_t* btr_block_get_func(const dict_index_t&, ulint, ulint, bool, const char*, unsigned int, mtr_t*): Assertion `err == DB_SUCCESS' failed. # 2020-04-25T19:19:04 [2435] | [rr 40350 5229]200425 19:18:54 [rr 40350 5231][ERROR] mysqld got signal 6 ; # 2020-04-25T19:19:04 [2435] | [rr 40350 5233]This could be because you hit a bug. It is also possible that this binary # 2020-04-25T19:19:04 [2435] | or one of the libraries it was linked against is corrupt, improperly built, # 2020-04-25T19:19:04 [2435] | or misconfigured. This error can also be caused by malfunctioning hardware. # 2020-04-25T19:19:04 [2435] | # 2020-04-25T19:19:04 [2435] | [rr 40350 5235]To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2020-04-25T19:19:04 [2435] | # 2020-04-25T19:19:04 [2435] | [rr 40350 5237]We will try our best to scrape up some info that will hopefully help # 2020-04-25T19:19:04 [2435] | diagnose the problem, but since we have already crashed, # 2020-04-25T19:19:04 [2435] | something is definitely wrong and this may fail. # 2020-04-25T19:19:04 [2435] | # 2020-04-25T19:19:04 [2435] | [rr 40350 5239]Server version: 10.5.3-MariaDB-debug-log # 2020-04-25T19:19:04 [2435] | [rr 40350 5241]key_buffer_size=134217728 # 2020-04-25T19:19:04 [2435] | [rr 40350 5243]read_buffer_size=131072 # 2020-04-25T19:19:04 [2435] | [rr 40350 5245]max_used_connections=0 # 2020-04-25T19:19:04 [2435] | [rr 40350 5247]max_threads=153 # 2020-04-25T19:19:04 [2435] | [rr 40350 5249]thread_count=0 # 2020-04-25T19:19:04 [2435] | [rr 40350 5251]It is possible that mysqld could use up to # 2020-04-25T19:19:04 [2435] | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467925 K bytes of memory # 2020-04-25T19:19:04 [2435] | [rr 40350 5253]Hope that's ok; if not, decrease some variables in the equation. # 2020-04-25T19:19:04 [2435] | # 2020-04-25T19:19:04 [2435] | [rr 40350 5255]Thread pointer: 0x0 # 2020-04-25T19:19:04 [2435] | [rr 40350 5257]Attempting backtrace. You can use the following information to find out # 2020-04-25T19:19:04 [2435] | where mysqld died. If you see no messages after this, something went # 2020-04-25T19:19:04 [2435] | terribly wrong... # 2020-04-25T19:19:04 [2435] | [rr 40350 5260]stack_bottom = 0x0 thread_stack 0x49000 # 2020-04-25T19:19:04 [2435] | [rr 40350 5562]/home/mleich/Server_bin/10.5_debug/bin/mysqld(my_print_stacktrace+0x40)[0x556573ac7e76] # 2020-04-25T19:19:04 [2435] | [rr 40350 5702]/home/mleich/Server_bin/10.5_debug/bin/mysqld(handle_fatal_signal+0x3ae)[0x55657316e5b9] # 2020-04-25T19:19:04 [2435] | [rr 40350 6547]/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7fa8bcd88890] # 2020-04-25T19:19:04 [2435] | [rr 40350 6926]/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7fa8bbe80e97] # 2020-04-25T19:19:04 [2435] | [rr 40350 6974]/lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7fa8bbe82801] # 2020-04-25T19:19:04 [2435] | [rr 40350 7027]/lib/x86_64-linux-gnu/libc.so.6(+0x3039a)[0x7fa8bbe7239a] # 2020-04-25T19:19:04 [2435] | [rr 40350 7093]/lib/x86_64-linux-gnu/libc.so.6(+0x30412)[0x7fa8bbe72412] # 2020-04-25T19:19:04 [2435] | [rr 40350 7655]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x11f5bec)[0x556573749bec] # 2020-04-25T19:19:04 [2435] | [rr 40350 7793]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x136d118)[0x5565738c1118] # 2020-04-25T19:19:04 [2435] | [rr 40350 7928]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x13f52ea)[0x5565739492ea] # 2020-04-25T19:19:04 [2435] | [rr 40350 8008]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x13fcb31)[0x556573950b31] # 2020-04-25T19:19:04 [2435] | [rr 40350 8213]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x13fe5af)[0x5565739525af] # 2020-04-25T19:19:04 [2435] | [rr 40350 8249]include/btr0btr.h:242(btr_block_get_func(dict_index_t const&, unsigned long, unsigned long, bool, char const*, unsigned int, mtr_t*))[0x5565739515b7] # 2020-04-25T19:19:04 [2435] | [rr 40350 8316]btr/btr0pcur.cc:474(btr_pcur_move_to_next_page(btr_pcur_t*, mtr_t*))[0x5565739532cb] # 2020-04-25T19:19:04 [2435] | [rr 40350 8384]include/btr0pcur.ic:286(btr_pcur_move_to_next_user_rec(btr_pcur_t*, mtr_t*))[0x556573932ab2] # 2020-04-25T19:19:04 [2435] | [rr 40350 8397]dict/dict0load.cc:2575(dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t))[0x5565739343b2] # 2020-04-25T19:19:04 [2435] | [rr 40350 8408]dict/dict0load.cc:2961(dict_load_table_one(table_name_t const&, dict_err_ignore_t, std::deque >&))[0x556573852c57] # 2020-04-25T19:19:04 [2435] | [rr 40350 8476]dict/dict0dict.cc:222(dict_table_open_on_id_low(unsigned long, dict_err_ignore_t, bool))[0x5565738533bd] # 2020-04-25T19:19:04 [2435] | [rr 40350 8499]dict/dict0dict.cc:937(dict_table_open_on_id(unsigned long, bool, dict_table_op_t, THD*, MDL_ticket**))[0x5565738536c1] # 2020-04-25T19:19:04 [2435] | [rr 40350 8540]trx/trx0trx.cc:615(trx_resurrect_table_locks(trx_t*, trx_undo_t const*))[0x5565737ff439] # 2020-04-25T19:19:04 [2435] | [rr 40350 8564]trx/trx0trx.cc:712(trx_resurrect(trx_undo_t*, trx_rseg_t*, long, unsigned long long, unsigned long*, bool))[0x5565735c9234] # 2020-04-25T19:19:04 [2435] | [rr 40350 8575]trx/trx0trx.cc:772(trx_lists_init_at_db_start())[0x556573172252] # 2020-04-25T19:19:04 [2435] | [rr 40350 8612]srv/srv0start.cc:1559(srv_start(bool))[0x556572e38a96] # 2020-04-25T19:19:04 [2435] | [rr 40350 8699]handler/ha_innodb.cc:4058(innodb_init(void*))[0x556572e39891] # 2020-04-25T19:19:04 [2435] | [rr 40350 8746]sql/handler.cc:584(ha_initialize_handlerton(st_plugin_int*))[0x556572cd939a] # 2020-04-25T19:19:04 [2435] | [rr 40350 8788]sql/sql_plugin.cc:1459(plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool))[0x556572cda5c1] # 2020-04-25T19:19:04 [2435] | [rr 40350 8831]sql/mysqld.cc:4997(init_server_components())[0x556572ccf10a] # 2020-04-25T19:19:04 [2435] | [rr 40350 9168]/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7)[0x7fa8bbe63b97] # 2020-04-25T19:19:04 [2435] | [rr 40350 9539]/home/mleich/Server_bin/10.5_debug/bin/mysqld(_start+0x2a)[0x556572ccf00a] # 2020-04-25T19:19:04 [2435] | [rr 40350 9541]The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2020-04-25T19:19:04 [2435] | information that should help you find out what is causing the crash. # 2020-04-25T19:19:04 [2435] | [rr 40350 9544]Writing a core file... # 2020-04-25T19:19:04 [2435] | Working directory at /dev/shm/vardir/1587842225/1/1/data # 2020-04-25T19:19:04 [2435] | [rr 40350 9548]Resource Limits: # 2020-04-25T19:19:04 [2435] | [rr 40350 9552]Limit Soft Limit Hard Limit Units # 2020-04-25T19:19:04 [2435] | Max cpu time unlimited unlimited seconds # 2020-04-25T19:19:04 [2435] | Max file size unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] | Max data size unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] | Max stack size 8388608 unlimited bytes # 2020-04-25T19:19:04 [2435] | Max core file size unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] | Max resident set unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] | Max processes 1541946 1541946 processes # 2020-04-25T19:19:04 [2435] | Max open files 10240 10240 files # 2020-04-25T19:19:04 [2435] | Max locked memory 16777216 16777216 bytes # 2020-04-25T19:19:04 [2435] | Max address space unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] | Max file locks unlimited unlimited locks # 2020-04-25T19:19:04 [2435] | Max pending signals 1541946 1541946 signals # 2020-04-25T19:19:04 [2435] | Max msgqueue size 819200 819200 bytes # 2020-04-25T19:19:04 [2435] | Max nice priority 0 0 # 2020-04-25T19:19:04 [2435] | Max realtime priority 0 0 # 2020-04-25T19:19:04 [2435] | Max realtime timeout unlimited unlimited us # 2020-04-25T19:19:04 [2435] | [rr 40350 9556]Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E # 2020-04-25T19:19:04 [2435] | # 2020-04-25T19:19:04 [2435] | Aborted # 2020-04-25T19:19:04 [2435] ---------------------------------- # 2020-04-25T19:19:04 [2435] Server disappeared after having started with pid 40350 # 2020-04-25T19:19:04 [2435] ERROR: Reporter 'CrashRecovery1': Status based on server start attempt is 1 # 2020-04-25T19:19:04 [2435] [rr 40350 1526]2020-04-25 19:18:53 0 [Note] /home/mleich/Server_bin/10.5_debug/bin/mysqld (mysqld 10.5.3-MariaDB-debug-log) starting as process 40350 ... # 2020-04-25T19:19:04 [2435] [rr 40350 1540]2020-04-25 19:18:53 0 [Warning] Could not increase number of max_open_files to more than 10240 (request: 32183) # 2020-04-25T19:19:04 [2435] [rr 40350 1654]2020-04-25 19:18:53 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=sdp' or '--log-bin=mysql-bin' to avoid this problem. # 2020-04-25T19:19:04 [2435] [rr 40350 1769]2020-04-25 19:18:53 0 [Note] InnoDB: innodb_page_size=4096 # 2020-04-25T19:19:04 [2435] [rr 40350 1773]2020-04-25 19:18:53 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2020-04-25T19:19:04 [2435] [rr 40350 1777]2020-04-25 19:18:53 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2020-04-25T19:19:04 [2435] [rr 40350 1781]2020-04-25 19:18:53 0 [Note] InnoDB: Uses event mutexes # 2020-04-25T19:19:04 [2435] [rr 40350 1785]2020-04-25 19:18:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2020-04-25T19:19:04 [2435] [rr 40350 1795]2020-04-25 19:18:53 0 [Note] InnoDB: Number of pools: 1 # 2020-04-25T19:19:04 [2435] [rr 40350 1808]2020-04-25 19:18:53 0 [Note] InnoDB: Using SSE2 crc32 instructions # 2020-04-25T19:19:04 [2435] [rr 40350 1812]2020-04-25 19:18:53 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/vardir/1587842225/1/1/tmp (disabling future attempts) # 2020-04-25T19:19:04 [2435] [rr 40350 1845]2020-04-25 19:18:53 0 [Note] InnoDB: Initializing buffer pool, total size = 25165824, chunk size = 25165824 # 2020-04-25T19:19:04 [2435] [rr 40350 1941]2020-04-25 19:18:53 0 [Note] InnoDB: Completed initialization of buffer pool # 2020-04-25T19:19:04 [2435] [rr 40350 2000]2020-04-25 19:18:53 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). # 2020-04-25T19:19:04 [2435] [rr 40350 2019]2020-04-25 19:18:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2754798 # 2020-04-25T19:19:04 [2435] [rr 40350 2027]2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 83, since the redo log references ./test/t1.ibd with space ID 82. # 2020-04-25T19:19:04 [2435] [rr 40350 2031]2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 82. Another data file called ./test/#sql-ib97.ibd exists with the same space ID. # 2020-04-25T19:19:04 [2435] [rr 40350 5206]mysqld: /home/mleich/10.5/storage/innobase/include/btr0btr.h:241: buf_block_t* btr_block_get_func(const dict_index_t&, ulint, ulint, bool, const char*, unsigned int, mtr_t*): Assertion `err == DB_SUCCESS' failed. # 2020-04-25T19:19:04 [2435] [rr 40350 5229]200425 19:18:54 [rr 40350 5231][ERROR] mysqld got signal 6 ; # 2020-04-25T19:19:04 [2435] ERROR: Reporter 'CrashRecovery1': Recovery has apparently crashed. # 2020-04-25T19:19:04 [2435] [rr 40350 5233]This could be because you hit a bug. It is also possible that this binary # 2020-04-25T19:19:04 [2435] or one of the libraries it was linked against is corrupt, improperly built, # 2020-04-25T19:19:04 [2435] WARN: Reporter 'CrashRecovery1': Log message 'or one of the libraries it was linked against is corrupt, improperly built,' might indicate database corruption # 2020-04-25T19:19:04 [2435] or misconfigured. This error can also be caused by malfunctioning hardware. # 2020-04-25T19:19:04 [2435] # 2020-04-25T19:19:04 [2435] [rr 40350 5235]To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2020-04-25T19:19:04 [2435] # 2020-04-25T19:19:04 [2435] [rr 40350 5237]We will try our best to scrape up some info that will hopefully help # 2020-04-25T19:19:04 [2435] diagnose the problem, but since we have already crashed, # 2020-04-25T19:19:04 [2435] WARN: Reporter 'CrashRecovery1': Log message 'diagnose the problem, but since we have already crashed, ' might indicate database corruption # 2020-04-25T19:19:04 [2435] something is definitely wrong and this may fail. # 2020-04-25T19:19:04 [2435] # 2020-04-25T19:19:04 [2435] [rr 40350 5239]Server version: 10.5.3-MariaDB-debug-log # 2020-04-25T19:19:04 [2435] [rr 40350 5241]key_buffer_size=134217728 # 2020-04-25T19:19:04 [2435] [rr 40350 5243]read_buffer_size=131072 # 2020-04-25T19:19:04 [2435] [rr 40350 5245]max_used_connections=0 # 2020-04-25T19:19:04 [2435] [rr 40350 5247]max_threads=153 # 2020-04-25T19:19:04 [2435] [rr 40350 5249]thread_count=0 # 2020-04-25T19:19:04 [2435] [rr 40350 5251]It is possible that mysqld could use up to # 2020-04-25T19:19:04 [2435] key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467925 K bytes of memory # 2020-04-25T19:19:04 [2435] [rr 40350 5253]Hope that's ok; if not, decrease some variables in the equation. # 2020-04-25T19:19:04 [2435] # 2020-04-25T19:19:04 [2435] [rr 40350 5255]Thread pointer: 0x0 # 2020-04-25T19:19:04 [2435] [rr 40350 5257]Attempting backtrace. You can use the following information to find out # 2020-04-25T19:19:04 [2435] where mysqld died. If you see no messages after this, something went # 2020-04-25T19:19:04 [2435] terribly wrong... # 2020-04-25T19:19:04 [2435] [rr 40350 5260]stack_bottom = 0x0 thread_stack 0x49000 # 2020-04-25T19:19:04 [2435] [rr 40350 5562]/home/mleich/Server_bin/10.5_debug/bin/mysqld(my_print_stacktrace+0x40)[0x556573ac7e76] # 2020-04-25T19:19:04 [2435] [rr 40350 5702]/home/mleich/Server_bin/10.5_debug/bin/mysqld(handle_fatal_signal+0x3ae)[0x55657316e5b9] # 2020-04-25T19:19:04 [2435] [rr 40350 6547]/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7fa8bcd88890] # 2020-04-25T19:19:04 [2435] [rr 40350 6926]/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7fa8bbe80e97] # 2020-04-25T19:19:04 [2435] [rr 40350 6974]/lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7fa8bbe82801] # 2020-04-25T19:19:04 [2435] [rr 40350 7027]/lib/x86_64-linux-gnu/libc.so.6(+0x3039a)[0x7fa8bbe7239a] # 2020-04-25T19:19:04 [2435] [rr 40350 7093]/lib/x86_64-linux-gnu/libc.so.6(+0x30412)[0x7fa8bbe72412] # 2020-04-25T19:19:04 [2435] [rr 40350 7655]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x11f5bec)[0x556573749bec] # 2020-04-25T19:19:04 [2435] [rr 40350 7793]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x136d118)[0x5565738c1118] # 2020-04-25T19:19:04 [2435] [rr 40350 7928]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x13f52ea)[0x5565739492ea] # 2020-04-25T19:19:04 [2435] [rr 40350 8008]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x13fcb31)[0x556573950b31] # 2020-04-25T19:19:04 [2435] [rr 40350 8213]/home/mleich/Server_bin/10.5_debug/bin/mysqld(+0x13fe5af)[0x5565739525af] # 2020-04-25T19:19:04 [2435] [rr 40350 8249]include/btr0btr.h:242(btr_block_get_func(dict_index_t const&, unsigned long, unsigned long, bool, char const*, unsigned int, mtr_t*))[0x5565739515b7] # 2020-04-25T19:19:04 [2435] [rr 40350 8316]btr/btr0pcur.cc:474(btr_pcur_move_to_next_page(btr_pcur_t*, mtr_t*))[0x5565739532cb] # 2020-04-25T19:19:04 [2435] [rr 40350 8384]include/btr0pcur.ic:286(btr_pcur_move_to_next_user_rec(btr_pcur_t*, mtr_t*))[0x556573932ab2] # 2020-04-25T19:19:04 [2435] [rr 40350 8397]dict/dict0load.cc:2575(dict_load_indexes(dict_table_t*, mem_block_info_t*, dict_err_ignore_t))[0x5565739343b2] # 2020-04-25T19:19:04 [2435] [rr 40350 8408]dict/dict0load.cc:2961(dict_load_table_one(table_name_t const&, dict_err_ignore_t, std::deque >&))[0x556573852c57] # 2020-04-25T19:19:04 [2435] [rr 40350 8476]dict/dict0dict.cc:222(dict_table_open_on_id_low(unsigned long, dict_err_ignore_t, bool))[0x5565738533bd] # 2020-04-25T19:19:04 [2435] [rr 40350 8499]dict/dict0dict.cc:937(dict_table_open_on_id(unsigned long, bool, dict_table_op_t, THD*, MDL_ticket**))[0x5565738536c1] # 2020-04-25T19:19:04 [2435] [rr 40350 8540]trx/trx0trx.cc:615(trx_resurrect_table_locks(trx_t*, trx_undo_t const*))[0x5565737ff439] # 2020-04-25T19:19:04 [2435] [rr 40350 8564]trx/trx0trx.cc:712(trx_resurrect(trx_undo_t*, trx_rseg_t*, long, unsigned long long, unsigned long*, bool))[0x5565735c9234] # 2020-04-25T19:19:04 [2435] [rr 40350 8575]trx/trx0trx.cc:772(trx_lists_init_at_db_start())[0x556573172252] # 2020-04-25T19:19:04 [2435] [rr 40350 8612]srv/srv0start.cc:1559(srv_start(bool))[0x556572e38a96] # 2020-04-25T19:19:04 [2435] [rr 40350 8699]handler/ha_innodb.cc:4058(innodb_init(void*))[0x556572e39891] # 2020-04-25T19:19:04 [2435] [rr 40350 8746]sql/handler.cc:584(ha_initialize_handlerton(st_plugin_int*))[0x556572cd939a] # 2020-04-25T19:19:04 [2435] [rr 40350 8788]sql/sql_plugin.cc:1459(plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool))[0x556572cda5c1] # 2020-04-25T19:19:04 [2435] [rr 40350 8831]sql/mysqld.cc:4997(init_server_components())[0x556572ccf10a] # 2020-04-25T19:19:04 [2435] [rr 40350 9168]/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7)[0x7fa8bbe63b97] # 2020-04-25T19:19:04 [2435] [rr 40350 9539]/home/mleich/Server_bin/10.5_debug/bin/mysqld(_start+0x2a)[0x556572ccf00a] # 2020-04-25T19:19:04 [2435] [rr 40350 9541]The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2020-04-25T19:19:04 [2435] information that should help you find out what is causing the crash. # 2020-04-25T19:19:04 [2435] [rr 40350 9544]Writing a core file... # 2020-04-25T19:19:04 [2435] Working directory at /dev/shm/vardir/1587842225/1/1/data # 2020-04-25T19:19:04 [2435] [rr 40350 9548]Resource Limits: # 2020-04-25T19:19:04 [2435] [rr 40350 9552]Limit Soft Limit Hard Limit Units # 2020-04-25T19:19:04 [2435] Max cpu time unlimited unlimited seconds # 2020-04-25T19:19:04 [2435] Max file size unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] Max data size unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] Max stack size 8388608 unlimited bytes # 2020-04-25T19:19:04 [2435] Max core file size unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] Max resident set unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] Max processes 1541946 1541946 processes # 2020-04-25T19:19:04 [2435] Max open files 10240 10240 files # 2020-04-25T19:19:04 [2435] Max locked memory 16777216 16777216 bytes # 2020-04-25T19:19:04 [2435] Max address space unlimited unlimited bytes # 2020-04-25T19:19:04 [2435] Max file locks unlimited unlimited locks # 2020-04-25T19:19:04 [2435] Max pending signals 1541946 1541946 signals # 2020-04-25T19:19:04 [2435] Max msgqueue size 819200 819200 bytes # 2020-04-25T19:19:04 [2435] Max nice priority 0 0 # 2020-04-25T19:19:04 [2435] Max realtime priority 0 0 # 2020-04-25T19:19:04 [2435] Max realtime timeout unlimited unlimited us # 2020-04-25T19:19:04 [2435] [rr 40350 9556]Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E # 2020-04-25T19:19:04 [2435] # 2020-04-25T19:19:04 [2435] Aborted # 2020-04-25T19:19:04 [2435] ERROR: Reporter 'CrashRecovery1': Status based on error log checking is 106 DBI connect('host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at lib/GenTest/Reporter/CrashRecovery1.pm line 180. # 2020-04-25T19:19:04 [2435] ERROR: Reporter 'CrashRecovery1': Connect attempt to dsn dbi:mysql:host=127.0.0.1:port=24600:user=root:database=test:mysql_local_infile=1 after restart+recovery failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-04-25T19:19:04 [2435] ERROR: Reporter 'CrashRecovery1': Recovery has failed. Will return status STATUS_DATABASE_CORRUPTION # 2020-04-25T19:19:04 [2435] ERROR: ReporterManager : Reporter 'CrashRecovery1' reported 106 # 2020-04-25T19:19:04 [2435] INFO: The reporters to be run at test end delivered status 106. # 2020-04-25T19:19:04 [2435] Test completed with failure status STATUS_DATABASE_CORRUPTION (106) # 2020-04-25T19:19:04 [2435] GenTest returned status STATUS_DATABASE_CORRUPTION (106) # 2020-04-25T19:19:04 [2435] INFO: RQG GenTest runtime in s : 115 # 2020-04-25T19:19:04 [2435] RESULT: The core of the RQG run ended with status STATUS_DATABASE_CORRUPTION (106) # 2020-04-25T19:19:04 [2435] Killing server(s)... # 2020-04-25T19:19:04 [2435] INFO: DBServer::MySQL::MySQLd::killServer: The server with process [40350] is already no more running. Will return DBSTATUS_OK. # 2020-04-25T19:19:04 [2435] RESULT: The RQG run ended with status STATUS_DATABASE_CORRUPTION (106) # 2020-04-25T19:19:04 [2435] DEBUG: rqg.pl: Entering stopServers with assigned status 106 # 2020-04-25T19:19:04 [2435] Stopping server(s)... # 2020-04-25T19:19:04 [2435] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [] is already no more running. # 2020-04-25T19:19:04 [2435] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2020-04-25T19:19:04 [2435] MATCHING: Region end ===================== # 2020-04-25T19:19:04 [2435] INFO: RQG total runtime in s : 119 # 2020-04-25T19:19:04 [2435] DEBUG: 'du -sk /dev/shm/vardir/1587842225/1 | cut -f1' exited with value 0 # 2020-04-25T19:19:04 [2435] INFO: vardir_size : 789556 # 2020-04-25T19:19:04 [2435] SUMMARY: Final command line: ->perl /home/mleich/RQG_mleich/rqg.pl --duration=100 --queries=10000000 --threads=1 --no_mask --engine=InnoDB --gendata=conf/mariadb/table_stress.zz --gendata_sql=conf/mariadb/table_stress.sql --sqltrace=MarkErrors --rpl_mode=none --mysqld=--lock-wait-timeout=86400 --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--log-bin --mysqld=--loose-max-statement-time=30 --mysqld=--interactive_timeout=28800 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--net_write_timeout=60 --mysqld=--slave_net_timeout=60 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--connect_timeout=60 --mysqld=--log-output=none --mysqld=--innodb_page_size=4K --mysqld=--net_read_timeout=30 --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--innodb_stats_persistent=off --mysqld=--wait_timeout=28800 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--loose-idle_readonly_transaction_timeout=0 --reporters=Backtrace,CrashRecovery1,Deadlock1,ErrorLog --validators=None --grammar=/home/mleich/RQG_mleich/storage/1587842225/c00000.yy --grammar=/home/mleich/RQG_mleich/storage/1587842225/c00000.yy --workdir=/home/mleich/RQG_mleich/storage/1587842225/1 --vardir=/dev/shm/vardir/1587842225/1 --mtr-build-thread=730 --basedir1=/home/mleich/Server_bin/10.5_debug --script_debug=_nix_ --rr=Server --seed=19918<- # 2020-04-25T19:19:04 [2435] SUMMARY: RQG GenData runtime in s : 0 # 2020-04-25T19:19:04 [2435] SUMMARY: RQG GenTest runtime in s : 115 # 2020-04-25T19:19:04 [2435] SUMMARY: RQG total runtime in s : 119 # 2020-04-25T19:19:04 [2435] /home/mleich/RQG_mleich/rqg.pl will exit with exit status STATUS_DATABASE_CORRUPTION(106)