# 2020-04-03T08:56:36 INFO: Logfile for RQG Worker [208] # 2020-04-03T08:56:36 [109746] Using Log::Log4perl # 2020-04-03T08:56:36 [109746] DEBUG: rqg_home might be ->/home/mleich/RQG_RR<- # 2020-04-03T08:56:36 [109746] INFO: Environment variable 'RQG_HOME' set to '/home/mleich/RQG_RR' # DEBUG: $0 ->/home/mleich/RQG_RR/rqg.pl<- # DEBUG: rqg_home_call ->/home/mleich/RQG_RR<- # DEBUG: rqg_home_env ->/home/mleich/RQG_RR<- # DEBUG: start_cwd ->/home/mleich/RQG_RR<- # 2020-04-03T08:56:36 [109746] INFO: script_debug : '_nix_' # 2020-04-03T08:56:36 [109746] DEBUG: After reading command line options # 2020-04-03T08:56:36 [109746] INFO: The 'rr' invocation type 'Server'. # 2020-04-03T08:56:36 [109746] INFO: RQG workdir : '/home/mleich/RQG_RR/storage/1585903801/208' and infrastructure is prepared. # 2020-04-03T08:56:36 [109746] DEBUG: no_mask is defind. Therefore setting mask_level=0 , mask=0 and no_mask=undef. # 2020-04-03T08:56:36 [109746] Reading grammar from file '/home/mleich/RQG_RR/storage/1585903801/c00000.yy'. # 2020-04-03T08:56:36 [109746] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2020-04-03T08:56:36 [109746] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2020-04-03T08:56:36 [109746] Starting # 2020-04-03T08:56:36 [109746] # /home/mleich/RQG_RR/rqg.pl \ # 2020-04-03T08:56:36 [109746] # --duration=120 \ # 2020-04-03T08:56:36 [109746] # --queries=10000000 \ # 2020-04-03T08:56:36 [109746] # --threads=1 \ # 2020-04-03T08:56:36 [109746] # --no_mask \ # 2020-04-03T08:56:36 [109746] # --seed=random \ # 2020-04-03T08:56:36 [109746] # --engine=InnoDB \ # 2020-04-03T08:56:36 [109746] # --gendata=conf/engines/many_indexes.zz \ # 2020-04-03T08:56:36 [109746] # --rpl_mode=none \ # 2020-04-03T08:56:36 [109746] # --mysqld=--innodb_page_size=32K \ # 2020-04-03T08:56:36 [109746] # --mysqld=--net_read_timeout=30 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--lock-wait-timeout=86400 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose-table_lock_wait_timeout=50 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--innodb-lock-wait-timeout=50 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--net_write_timeout=60 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--wait_timeout=28800 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--log_bin_trust_function_creators=1 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--connect_timeout=60 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--log-bin \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose-idle_write_transaction_timeout=0 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose-idle_transaction_timeout=0 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--interactive_timeout=28800 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose_innodb_use_native_aio=1 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--slave_net_timeout=60 \ # 2020-04-03T08:56:36 [109746] # --mysqld=--innodb_stats_persistent=off \ # 2020-04-03T08:56:36 [109746] # --mysqld=--log-output=none \ # 2020-04-03T08:56:36 [109746] # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \ # 2020-04-03T08:56:36 [109746] # --reporters=CrashRecovery1,Deadlock1,ErrorLog,None,ServerDead \ # 2020-04-03T08:56:36 [109746] # --validators=None \ # 2020-04-03T08:56:36 [109746] # --grammar=/home/mleich/RQG_RR/storage/1585903801/c00000.yy \ # 2020-04-03T08:56:36 [109746] # --grammar=/home/mleich/RQG_RR/storage/1585903801/c00000.yy \ # 2020-04-03T08:56:36 [109746] # --workdir=/home/mleich/RQG_RR/storage/1585903801/208 \ # 2020-04-03T08:56:36 [109746] # --vardir=/dev/shm/vardir/1585903801/208 \ # 2020-04-03T08:56:36 [109746] # --mtr-build-thread=937 \ # 2020-04-03T08:56:36 [109746] # --basedir1=/home/mleich/10.5_ori/bld_debug/ \ # 2020-04-03T08:56:36 [109746] # --script_debug=_nix_ \ # 2020-04-03T08:56:36 [109746] # --rr=Server # 2020-04-03T08:56:36 [109746] INFO: build_thread : 937 # 2020-04-03T08:56:36 [109746] INFO: master_port : 28740 slave_port : 28741 ports : 28740 28741 28742 MTR_BUILD_THREAD : 937 # 2020-04-03T08:56:36 [109746] INFO: Number of servers involved = 1. (0 means unknown) # 2020-04-03T08:56:36 [109746] INFO: Early RQG basedirs : ->undef<-->/home/mleich/10.5_ori/bld_debug/<-->undef<-->undef<- # 2020-04-03T08:56:36 [109746] DEBUG: $basedirs[0] is not defined or eq ''. Setting it to $basedirs[1] '/home/mleich/10.5_ori/bld_debug/'. # 2020-04-03T08:56:36 [109746] INFO: Final RQG basedirs : ->/home/mleich/10.5_ori/bld_debug/<-->/home/mleich/10.5_ori/bld_debug/<-->undef<-->undef<- # 2020-04-03T08:56:36 [109746] DEBUG: 'git --version 2>&1' exited with value 0 # 2020-04-03T08:56:36 [109746] GIT: $rqg_home('/home/mleich/RQG_RR') HEAD -> experimental, origin/experimental d417497b476e263428422b4640cf63b8e9d16afe 2020-03-30T17:17:54+02:00 # 2020-04-03T08:56:36 [109746] GIT: $basedirs[0]('/home/mleich/10.5_ori/bld_debug/') HEAD, origin/HEAD, origin/10.5 0870b75af7d01f2e8132278aeb0873dd6c65d1be 2020-04-03T08:50:46+03:00 # 2020-04-03T08:56:36 [109746] GIT: $basedirs[1]('/home/mleich/10.5_ori/bld_debug/') HEAD, origin/HEAD, origin/10.5 0870b75af7d01f2e8132278aeb0873dd6c65d1be 2020-04-03T08:50:46+03:00 # 2020-04-03T08:56:36 [109746] INFO: Final RQG vardirs : ->/dev/shm/vardir/1585903801/208<-->/dev/shm/vardir/1585903801/208/1<- # 2020-04-03T08:56:36 [109746] tmpdir in GenTest ->/dev/shm/vardir/1585903801/208/<- # 2020-04-03T08:56:36 [109746] tmpdir in DBServer ->/dev/shm/vardir/1585903801/208/<- # 2020-04-03T08:56:36 [109746] DEBUG: subdir_list : ->sql<-->libexec<-->bin<-->sbin<- # 2020-04-03T08:56:36 [109746] DEBUG: Basedirs : ->/home/mleich/10.5_ori/bld_debug/<-->/home/mleich/10.5_ori/bld_debug/<-->undef<-->undef<- # 2020-04-03T08:56:36 [109746] DEBUG: debug_server : ->undef<-->undef<-->undef<- # 2020-04-03T08:56:36 [109746] DEBUG: Server binary found : '/home/mleich/10.5_ori/bld_debug//sql/mysqld'. # 2020-04-03T08:56:36 [109746] DEBUG: Server binary found : '/home/mleich/10.5_ori/bld_debug//sql/mysqld'. # 2020-04-03T08:56:36 [109746] INFO: seed eq 'random'. Computation. seed : 29825 # 2020-04-03T08:56:36 [109746] INFO: Final command line: ->perl /home/mleich/RQG_RR/rqg.pl --duration=120 --queries=10000000 --threads=1 --no_mask --engine=InnoDB --gendata=conf/engines/many_indexes.zz --rpl_mode=none --mysqld=--innodb_page_size=32K --mysqld=--net_read_timeout=30 --mysqld=--lock-wait-timeout=86400 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--net_write_timeout=60 --mysqld=--wait_timeout=28800 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--connect_timeout=60 --mysqld=--log-bin --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--interactive_timeout=28800 --mysqld=--loose_innodb_use_native_aio=1 --mysqld=--slave_net_timeout=60 --mysqld=--innodb_stats_persistent=off --mysqld=--log-output=none --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --reporters=CrashRecovery1,Deadlock1,ErrorLog,None,ServerDead --validators=None --grammar=/home/mleich/RQG_RR/storage/1585903801/c00000.yy --grammar=/home/mleich/RQG_RR/storage/1585903801/c00000.yy --workdir=/home/mleich/RQG_RR/storage/1585903801/208 --vardir=/dev/shm/vardir/1585903801/208 --mtr-build-thread=937 --basedir1=/home/mleich/10.5_ori/bld_debug/ --script_debug=_nix_ --rr=Server --seed=29825<- # 2020-04-03T08:56:36 [109746] MATCHING: Region start ===================== # 2020-04-03T08:56:36 [109746] MLML the rr_trace_dir '/dev/shm/vardir/1585903801/208/rr_trace' exists. # 2020-04-03T08:56:36 [109746] DEBUG: rpl_mode is 'none' # 2020-04-03T08:56:36 [109746] DEBUG: max_id is 0 # 2020-04-03T08:56:36 [109746] Found source directory at /home/mleich/10.5_ori # 2020-04-03T08:56:36 [109746] Creating MySQL 10.5.3 database at /dev/shm/vardir/1585903801/208/1/data # 2020-04-03T08:56:36 [109746] Bootstrap command: rr record cat "/dev/shm/vardir/1585903801/208/1/boot.sql" | "/home/mleich/10.5_ori/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/home/mleich/10.5_ori/bld_debug/" "--lc-messages-dir=/home/mleich/10.5_ori/bld_debug//sql/share" "--character-sets-dir=/home/mleich/10.5_ori/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1585903801/208/1/tmp" "--datadir=/dev/shm/vardir/1585903801/208/1/data" "--innodb_page_size=32K" "--net_read_timeout=30" "--lock-wait-timeout=86400" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--innodb-lock-wait-timeout=50" "--loose-debug_assert_on_not_freed_memory=0" "--net_write_timeout=60" "--wait_timeout=28800" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-bin" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--interactive_timeout=28800" "--loose_innodb_use_native_aio=1" "--slave_net_timeout=60" "--innodb_stats_persistent=off" "--log-output=none" "--loose_innodb_lock_schedule_algorithm=fcfs" "--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-03T08:56:38 [109746] MLML2 ->rr record --mark-stdio "/home/mleich/10.5_ori/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/home/mleich/10.5_ori/bld_debug/" "--lc-messages-dir=/home/mleich/10.5_ori/bld_debug//sql/share" "--character-sets-dir=/home/mleich/10.5_ori/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1585903801/208/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1585903801/208/1/data" "--max-allowed-packet=128Mb" "--port=28740" "--socket=/dev/shm/vardir/1585903801/208/1/mysql.sock" "--pid-file=/dev/shm/vardir/1585903801/208/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1585903801/208/1/mysql.log" "--innodb_page_size=32K" "--net_read_timeout=30" "--lock-wait-timeout=86400" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--innodb-lock-wait-timeout=50" "--loose-debug_assert_on_not_freed_memory=0" "--net_write_timeout=60" "--wait_timeout=28800" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-bin" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--interactive_timeout=28800" "--loose_innodb_use_native_aio=1" "--slave_net_timeout=60" "--innodb_stats_persistent=off" "--log-output=none" "--loose_innodb_lock_schedule_algorithm=fcfs" "--sql-mode=no_engine_substitution"<- # 2020-04-03T08:56:38 [109746] INFO: Starting MySQL 10.5.3: rr record --mark-stdio "/home/mleich/10.5_ori/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/home/mleich/10.5_ori/bld_debug/" "--lc-messages-dir=/home/mleich/10.5_ori/bld_debug//sql/share" "--character-sets-dir=/home/mleich/10.5_ori/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1585903801/208/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1585903801/208/1/data" "--max-allowed-packet=128Mb" "--port=28740" "--socket=/dev/shm/vardir/1585903801/208/1/mysql.sock" "--pid-file=/dev/shm/vardir/1585903801/208/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1585903801/208/1/mysql.log" "--innodb_page_size=32K" "--net_read_timeout=30" "--lock-wait-timeout=86400" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--innodb-lock-wait-timeout=50" "--loose-debug_assert_on_not_freed_memory=0" "--net_write_timeout=60" "--wait_timeout=28800" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-bin" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--interactive_timeout=28800" "--loose_innodb_use_native_aio=1" "--slave_net_timeout=60" "--innodb_stats_persistent=off" "--log-output=none" "--loose_innodb_lock_schedule_algorithm=fcfs" "--sql-mode=no_engine_substitution" # 2020-04-03T08:56:39 [109746] DEBUG: Server pid found in error log: 110871 # 2020-04-03T08:56:41 [109746] MySQL Version: 10.5.3 # 2020-04-03T08:56:41 [109746] Binary: /home/mleich/10.5_ori/bld_debug//sql/mysqld # 2020-04-03T08:56:41 [109746] Type: Debug # 2020-04-03T08:56:41 [109746] Datadir: /dev/shm/vardir/1585903801/208/1/data # 2020-04-03T08:56:41 [109746] Tmpdir: /dev/shm/vardir/1585903801/208/1/tmp # 2020-04-03T08:56:41 [109746] Corefile: /dev/shm/vardir/1585903801/208/1/data/core.110871 # 2020-04-03T08:56:41 [109746] Connecting to 28740 # 2020-04-03T08:56:41 [109746] SVAR: alter_algorithm : DEFAULT # 2020-04-03T08:56:41 [109746] SVAR: analyze_sample_percentage : 100.000000 # 2020-04-03T08:56:41 [109746] SVAR: aria_block_size : 8192 # 2020-04-03T08:56:41 [109746] SVAR: aria_checkpoint_interval : 30 # 2020-04-03T08:56:41 [109746] SVAR: aria_checkpoint_log_activity : 1048576 # 2020-04-03T08:56:41 [109746] SVAR: aria_encrypt_tables : OFF # 2020-04-03T08:56:41 [109746] SVAR: aria_force_start_after_recovery_failures : 0 # 2020-04-03T08:56:41 [109746] SVAR: aria_group_commit : none # 2020-04-03T08:56:41 [109746] SVAR: aria_group_commit_interval : 0 # 2020-04-03T08:56:41 [109746] SVAR: aria_log_file_size : 1073741824 # 2020-04-03T08:56:41 [109746] SVAR: aria_log_purge_type : immediate # 2020-04-03T08:56:41 [109746] SVAR: aria_max_sort_file_size : 9223372036853727232 # 2020-04-03T08:56:41 [109746] SVAR: aria_page_checksum : ON # 2020-04-03T08:56:41 [109746] SVAR: aria_pagecache_age_threshold : 300 # 2020-04-03T08:56:41 [109746] SVAR: aria_pagecache_buffer_size : 134217728 # 2020-04-03T08:56:41 [109746] SVAR: aria_pagecache_division_limit : 100 # 2020-04-03T08:56:41 [109746] SVAR: aria_pagecache_file_hash_size : 512 # 2020-04-03T08:56:41 [109746] SVAR: aria_recover_options : BACKUP,QUICK # 2020-04-03T08:56:41 [109746] SVAR: aria_repair_threads : 1 # 2020-04-03T08:56:41 [109746] SVAR: aria_sort_buffer_size : 268434432 # 2020-04-03T08:56:41 [109746] SVAR: aria_stats_method : nulls_unequal # 2020-04-03T08:56:41 [109746] SVAR: aria_sync_log_dir : NEWFILE # 2020-04-03T08:56:41 [109746] SVAR: aria_used_for_temp_tables : ON # 2020-04-03T08:56:41 [109746] SVAR: auto_increment_increment : 1 # 2020-04-03T08:56:41 [109746] SVAR: auto_increment_offset : 1 # 2020-04-03T08:56:41 [109746] SVAR: autocommit : ON # 2020-04-03T08:56:41 [109746] SVAR: automatic_sp_privileges : ON # 2020-04-03T08:56:41 [109746] SVAR: back_log : 80 # 2020-04-03T08:56:41 [109746] SVAR: basedir : /home/mleich/10.5_ori/bld_debug/ # 2020-04-03T08:56:41 [109746] SVAR: big_tables : OFF # 2020-04-03T08:56:41 [109746] SVAR: bind_address : # 2020-04-03T08:56:41 [109746] SVAR: binlog_annotate_row_events : ON # 2020-04-03T08:56:41 [109746] SVAR: binlog_cache_size : 32768 # 2020-04-03T08:56:41 [109746] SVAR: binlog_checksum : CRC32 # 2020-04-03T08:56:41 [109746] SVAR: binlog_commit_wait_count : 0 # 2020-04-03T08:56:41 [109746] SVAR: binlog_commit_wait_usec : 100000 # 2020-04-03T08:56:41 [109746] SVAR: binlog_direct_non_transactional_updates : OFF # 2020-04-03T08:56:41 [109746] SVAR: binlog_file_cache_size : 16384 # 2020-04-03T08:56:41 [109746] SVAR: binlog_format : MIXED # 2020-04-03T08:56:41 [109746] SVAR: binlog_optimize_thread_scheduling : ON # 2020-04-03T08:56:41 [109746] SVAR: binlog_row_image : FULL # 2020-04-03T08:56:41 [109746] SVAR: binlog_row_metadata : NO_LOG # 2020-04-03T08:56:41 [109746] SVAR: binlog_stmt_cache_size : 32768 # 2020-04-03T08:56:41 [109746] SVAR: bulk_insert_buffer_size : 8388608 # 2020-04-03T08:56:41 [109746] SVAR: character_set_client : latin1 # 2020-04-03T08:56:41 [109746] SVAR: character_set_connection : latin1 # 2020-04-03T08:56:41 [109746] SVAR: character_set_database : latin1 # 2020-04-03T08:56:41 [109746] SVAR: character_set_filesystem : binary # 2020-04-03T08:56:41 [109746] SVAR: character_set_results : latin1 # 2020-04-03T08:56:41 [109746] SVAR: character_set_server : latin1 # 2020-04-03T08:56:41 [109746] SVAR: character_set_system : utf8 # 2020-04-03T08:56:41 [109746] SVAR: character_sets_dir : /home/mleich/10.5_ori/sql/share/charsets/ # 2020-04-03T08:56:41 [109746] SVAR: check_constraint_checks : ON # 2020-04-03T08:56:41 [109746] SVAR: collation_connection : latin1_swedish_ci # 2020-04-03T08:56:41 [109746] SVAR: collation_database : latin1_swedish_ci # 2020-04-03T08:56:41 [109746] SVAR: collation_server : latin1_swedish_ci # 2020-04-03T08:56:41 [109746] SVAR: column_compression_threshold : 100 # 2020-04-03T08:56:41 [109746] SVAR: column_compression_zlib_level : 6 # 2020-04-03T08:56:41 [109746] SVAR: column_compression_zlib_strategy : DEFAULT_STRATEGY # 2020-04-03T08:56:41 [109746] SVAR: column_compression_zlib_wrap : OFF # 2020-04-03T08:56:41 [109746] SVAR: completion_type : NO_CHAIN # 2020-04-03T08:56:41 [109746] SVAR: concurrent_insert : AUTO # 2020-04-03T08:56:41 [109746] SVAR: connect_timeout : 60 # 2020-04-03T08:56:41 [109746] SVAR: core_file : ON # 2020-04-03T08:56:41 [109746] SVAR: datadir : /dev/shm/vardir/1585903801/208/1/data/ # 2020-04-03T08:56:41 [109746] SVAR: date_format : %Y-%m-%d # 2020-04-03T08:56:41 [109746] SVAR: datetime_format : %Y-%m-%d %H:%i:%s # 2020-04-03T08:56:41 [109746] SVAR: deadlock_search_depth_long : 15 # 2020-04-03T08:56:41 [109746] SVAR: deadlock_search_depth_short : 4 # 2020-04-03T08:56:41 [109746] SVAR: deadlock_timeout_long : 50000000 # 2020-04-03T08:56:41 [109746] SVAR: deadlock_timeout_short : 10000 # 2020-04-03T08:56:41 [109746] SVAR: debug : # 2020-04-03T08:56:41 [109746] SVAR: debug_binlog_fsync_sleep : 0 # 2020-04-03T08:56:41 [109746] SVAR: debug_dbug : # 2020-04-03T08:56:41 [109746] SVAR: debug_mutex_deadlock_detector : ON # 2020-04-03T08:56:41 [109746] SVAR: debug_no_thread_alarm : OFF # 2020-04-03T08:56:41 [109746] SVAR: debug_sync : OFF # 2020-04-03T08:56:41 [109746] SVAR: default_master_connection : # 2020-04-03T08:56:41 [109746] SVAR: default_password_lifetime : 0 # 2020-04-03T08:56:41 [109746] SVAR: default_regex_flags : # 2020-04-03T08:56:41 [109746] SVAR: default_storage_engine : InnoDB # 2020-04-03T08:56:41 [109746] SVAR: default_tmp_storage_engine : # 2020-04-03T08:56:41 [109746] SVAR: default_week_format : 0 # 2020-04-03T08:56:41 [109746] SVAR: delay_key_write : ON # 2020-04-03T08:56:41 [109746] SVAR: delayed_insert_limit : 100 # 2020-04-03T08:56:41 [109746] SVAR: delayed_insert_timeout : 300 # 2020-04-03T08:56:41 [109746] SVAR: delayed_queue_size : 1000 # 2020-04-03T08:56:41 [109746] SVAR: disconnect_on_expired_password : OFF # 2020-04-03T08:56:41 [109746] SVAR: div_precision_increment : 4 # 2020-04-03T08:56:41 [109746] SVAR: encrypt_binlog : OFF # 2020-04-03T08:56:41 [109746] SVAR: encrypt_tmp_disk_tables : OFF # 2020-04-03T08:56:41 [109746] SVAR: encrypt_tmp_files : OFF # 2020-04-03T08:56:41 [109746] SVAR: enforce_storage_engine : # 2020-04-03T08:56:41 [109746] SVAR: eq_range_index_dive_limit : 200 # 2020-04-03T08:56:41 [109746] SVAR: error_count : 0 # 2020-04-03T08:56:41 [109746] SVAR: event_scheduler : OFF # 2020-04-03T08:56:41 [109746] SVAR: expensive_subquery_limit : 100 # 2020-04-03T08:56:41 [109746] SVAR: expire_logs_days : 0 # 2020-04-03T08:56:41 [109746] SVAR: explicit_defaults_for_timestamp : OFF # 2020-04-03T08:56:41 [109746] SVAR: external_user : # 2020-04-03T08:56:41 [109746] SVAR: extra_max_connections : 1 # 2020-04-03T08:56:41 [109746] SVAR: extra_port : 0 # 2020-04-03T08:56:41 [109746] SVAR: flush : OFF # 2020-04-03T08:56:41 [109746] SVAR: flush_time : 0 # 2020-04-03T08:56:41 [109746] SVAR: foreign_key_checks : ON # 2020-04-03T08:56:41 [109746] SVAR: ft_boolean_syntax : + -><()~*:""&| # 2020-04-03T08:56:41 [109746] SVAR: ft_max_word_len : 84 # 2020-04-03T08:56:41 [109746] SVAR: ft_min_word_len : 4 # 2020-04-03T08:56:41 [109746] SVAR: ft_query_expansion_limit : 20 # 2020-04-03T08:56:41 [109746] SVAR: ft_stopword_file : (built-in) # 2020-04-03T08:56:41 [109746] SVAR: general_log : ON # 2020-04-03T08:56:41 [109746] SVAR: general_log_file : /dev/shm/vardir/1585903801/208/1/mysql.log # 2020-04-03T08:56:41 [109746] SVAR: group_concat_max_len : 1048576 # 2020-04-03T08:56:41 [109746] SVAR: gtid_binlog_pos : # 2020-04-03T08:56:41 [109746] SVAR: gtid_binlog_state : # 2020-04-03T08:56:41 [109746] SVAR: gtid_cleanup_batch_size : 64 # 2020-04-03T08:56:41 [109746] SVAR: gtid_current_pos : # 2020-04-03T08:56:41 [109746] SVAR: gtid_domain_id : 0 # 2020-04-03T08:56:41 [109746] SVAR: gtid_ignore_duplicates : OFF # 2020-04-03T08:56:41 [109746] SVAR: gtid_pos_auto_engines : # 2020-04-03T08:56:41 [109746] SVAR: gtid_seq_no : 0 # 2020-04-03T08:56:41 [109746] SVAR: gtid_slave_pos : # 2020-04-03T08:56:41 [109746] SVAR: gtid_strict_mode : OFF # 2020-04-03T08:56:41 [109746] SVAR: have_compress : YES # 2020-04-03T08:56:41 [109746] SVAR: have_crypt : YES # 2020-04-03T08:56:41 [109746] SVAR: have_dynamic_loading : YES # 2020-04-03T08:56:41 [109746] SVAR: have_geometry : YES # 2020-04-03T08:56:41 [109746] SVAR: have_openssl : NO # 2020-04-03T08:56:41 [109746] SVAR: have_profiling : YES # 2020-04-03T08:56:41 [109746] SVAR: have_query_cache : YES # 2020-04-03T08:56:41 [109746] SVAR: have_rtree_keys : YES # 2020-04-03T08:56:41 [109746] SVAR: have_ssl : DISABLED # 2020-04-03T08:56:41 [109746] SVAR: have_symlink : YES # 2020-04-03T08:56:41 [109746] SVAR: histogram_size : 254 # 2020-04-03T08:56:41 [109746] SVAR: histogram_type : DOUBLE_PREC_HB # 2020-04-03T08:56:41 [109746] SVAR: host_cache_size : 279 # 2020-04-03T08:56:41 [109746] SVAR: hostname : sdp # 2020-04-03T08:56:41 [109746] SVAR: identity : 0 # 2020-04-03T08:56:41 [109746] SVAR: idle_readonly_transaction_timeout : 0 # 2020-04-03T08:56:41 [109746] SVAR: idle_transaction_timeout : 0 # 2020-04-03T08:56:41 [109746] SVAR: idle_write_transaction_timeout : 0 # 2020-04-03T08:56:41 [109746] SVAR: ignore_builtin_innodb : OFF # 2020-04-03T08:56:41 [109746] SVAR: ignore_db_dirs : # 2020-04-03T08:56:41 [109746] SVAR: in_predicate_conversion_threshold : 1000 # 2020-04-03T08:56:41 [109746] SVAR: in_transaction : 0 # 2020-04-03T08:56:41 [109746] SVAR: init_connect : # 2020-04-03T08:56:41 [109746] SVAR: init_file : # 2020-04-03T08:56:41 [109746] SVAR: init_slave : # 2020-04-03T08:56:41 [109746] SVAR: innodb_adaptive_flushing : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_adaptive_flushing_lwm : 10.000000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_adaptive_hash_index : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_adaptive_hash_index_parts : 8 # 2020-04-03T08:56:41 [109746] SVAR: innodb_adaptive_max_sleep_delay : 150000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_autoextend_increment : 64 # 2020-04-03T08:56:41 [109746] SVAR: innodb_autoinc_lock_mode : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_background_drop_list_empty : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_background_scrub_data_check_interval : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_background_scrub_data_compressed : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_background_scrub_data_interval : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_background_scrub_data_uncompressed : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_buf_dump_status_frequency : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_buf_flush_list_now : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_chunk_size : 134217728 # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_dump_at_shutdown : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_dump_now : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_dump_pct : 25 # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_evict : # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_filename : ib_buffer_pool # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_instances : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_load_abort : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_load_at_startup : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_load_now : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_load_pages_abort : 9223372036854775807 # 2020-04-03T08:56:41 [109746] SVAR: innodb_buffer_pool_size : 134217728 # 2020-04-03T08:56:41 [109746] SVAR: innodb_change_buffer_dump : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_change_buffer_max_size : 25 # 2020-04-03T08:56:41 [109746] SVAR: innodb_change_buffering : all # 2020-04-03T08:56:41 [109746] SVAR: innodb_change_buffering_debug : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_checksum_algorithm : full_crc32 # 2020-04-03T08:56:41 [109746] SVAR: innodb_cmp_per_index_enabled : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_commit_concurrency : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_compression_algorithm : zlib # 2020-04-03T08:56:41 [109746] SVAR: innodb_compression_default : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_compression_failure_threshold_pct : 5 # 2020-04-03T08:56:41 [109746] SVAR: innodb_compression_level : 6 # 2020-04-03T08:56:41 [109746] SVAR: innodb_compression_pad_pct_max : 50 # 2020-04-03T08:56:41 [109746] SVAR: innodb_concurrency_tickets : 5000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_data_file_path : ibdata1:12M:autoextend # 2020-04-03T08:56:41 [109746] SVAR: innodb_data_file_size_debug : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_data_home_dir : # 2020-04-03T08:56:41 [109746] SVAR: innodb_deadlock_detect : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_default_encryption_key_id : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_default_row_format : dynamic # 2020-04-03T08:56:41 [109746] SVAR: innodb_defragment : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_defragment_fill_factor : 0.900000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_defragment_fill_factor_n_recs : 20 # 2020-04-03T08:56:41 [109746] SVAR: innodb_defragment_frequency : 40 # 2020-04-03T08:56:41 [109746] SVAR: innodb_defragment_n_pages : 7 # 2020-04-03T08:56:41 [109746] SVAR: innodb_defragment_stats_accuracy : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_dict_stats_disabled_debug : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_disable_resize_buffer_pool_debug : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_disable_sort_file_cache : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_disallow_writes : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_doublewrite : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_doublewrite_batch_size : 120 # 2020-04-03T08:56:41 [109746] SVAR: innodb_encrypt_log : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_encrypt_tables : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_encrypt_temporary_tables : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_encryption_rotate_key_age : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_encryption_rotation_iops : 100 # 2020-04-03T08:56:41 [109746] SVAR: innodb_encryption_threads : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_evict_tables_on_commit_debug : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_fast_shutdown : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_fatal_semaphore_wait_threshold : 600 # 2020-04-03T08:56:41 [109746] SVAR: innodb_fil_make_page_dirty_debug : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_file_format : # 2020-04-03T08:56:41 [109746] SVAR: innodb_file_per_table : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_fill_factor : 100 # 2020-04-03T08:56:41 [109746] SVAR: innodb_flush_log_at_timeout : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_flush_log_at_trx_commit : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_flush_method : fsync # 2020-04-03T08:56:41 [109746] SVAR: innodb_flush_neighbors : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_flush_sync : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_flushing_avg_loops : 30 # 2020-04-03T08:56:41 [109746] SVAR: innodb_force_load_corrupted : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_force_primary_key : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_force_recovery : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_aux_table : # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_cache_size : 8000000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_enable_diag_print : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_enable_stopword : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_max_token_size : 84 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_min_token_size : 3 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_num_word_optimize : 2000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_result_cache_limit : 2000000000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_server_stopword_table : # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_sort_pll_degree : 2 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_total_cache_size : 640000000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_ft_user_stopword_table : # 2020-04-03T08:56:41 [109746] SVAR: innodb_idle_flush_pct : 100 # 2020-04-03T08:56:41 [109746] SVAR: innodb_immediate_scrub_data_uncompressed : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_instant_alter_column_allowed : add_drop_reorder # 2020-04-03T08:56:41 [109746] SVAR: innodb_io_capacity : 200 # 2020-04-03T08:56:41 [109746] SVAR: innodb_io_capacity_max : 2000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_large_prefix : # 2020-04-03T08:56:41 [109746] SVAR: innodb_limit_optimistic_insert_debug : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_lock_schedule_algorithm : fcfs # 2020-04-03T08:56:41 [109746] SVAR: innodb_lock_wait_timeout : 50 # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_buffer_size : 16777216 # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_checkpoint_now : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_checksums : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_compressed_pages : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_file_size : 100663296 # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_files_in_group : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_group_home_dir : ./ # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_optimize_ddl : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_log_write_ahead_size : 8192 # 2020-04-03T08:56:41 [109746] SVAR: innodb_lru_scan_depth : 1024 # 2020-04-03T08:56:41 [109746] SVAR: innodb_master_thread_disabled_debug : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_max_dirty_pages_pct : 75.000000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_max_dirty_pages_pct_lwm : 0.000000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_max_purge_lag : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_max_purge_lag_delay : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_max_undo_log_size : 20971520 # 2020-04-03T08:56:41 [109746] SVAR: innodb_merge_threshold_set_all_debug : 50 # 2020-04-03T08:56:41 [109746] SVAR: innodb_monitor_disable : # 2020-04-03T08:56:41 [109746] SVAR: innodb_monitor_enable : # 2020-04-03T08:56:41 [109746] SVAR: innodb_monitor_reset : # 2020-04-03T08:56:41 [109746] SVAR: innodb_monitor_reset_all : # 2020-04-03T08:56:41 [109746] SVAR: innodb_old_blocks_pct : 37 # 2020-04-03T08:56:41 [109746] SVAR: innodb_old_blocks_time : 1000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_online_alter_log_max_size : 134217728 # 2020-04-03T08:56:41 [109746] SVAR: innodb_open_files : 2000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_optimize_fulltext_only : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_page_cleaner_disabled_debug : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_page_cleaners : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_page_hash_locks : 16 # 2020-04-03T08:56:41 [109746] SVAR: innodb_page_size : 32768 # 2020-04-03T08:56:41 [109746] SVAR: innodb_prefix_index_cluster_optimization : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_print_all_deadlocks : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_purge_batch_size : 300 # 2020-04-03T08:56:41 [109746] SVAR: innodb_purge_rseg_truncate_frequency : 128 # 2020-04-03T08:56:41 [109746] SVAR: innodb_purge_threads : 4 # 2020-04-03T08:56:41 [109746] SVAR: innodb_random_read_ahead : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_read_ahead_threshold : 56 # 2020-04-03T08:56:41 [109746] SVAR: innodb_read_io_threads : 4 # 2020-04-03T08:56:41 [109746] SVAR: innodb_read_only : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_replication_delay : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_rollback_on_timeout : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_saved_page_number_debug : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_scrub_log : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_scrub_log_speed : 256 # 2020-04-03T08:56:41 [109746] SVAR: innodb_simulate_comp_failures : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_sort_buffer_size : 1048576 # 2020-04-03T08:56:41 [109746] SVAR: innodb_spin_wait_delay : 4 # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_auto_recalc : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_include_delete_marked : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_method : nulls_equal # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_modified_counter : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_on_metadata : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_persistent : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_persistent_sample_pages : 20 # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_traditional : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_stats_transient_sample_pages : 8 # 2020-04-03T08:56:41 [109746] SVAR: innodb_status_output : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_status_output_locks : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_strict_mode : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_sync_array_size : 1 # 2020-04-03T08:56:41 [109746] SVAR: innodb_sync_debug : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_sync_spin_loops : 30 # 2020-04-03T08:56:41 [109746] SVAR: innodb_table_locks : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_temp_data_file_path : ibtmp1:12M:autoextend # 2020-04-03T08:56:41 [109746] SVAR: innodb_thread_concurrency : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_thread_sleep_delay : 10000 # 2020-04-03T08:56:41 [109746] SVAR: innodb_tmpdir : # 2020-04-03T08:56:41 [109746] SVAR: innodb_trx_purge_view_update_only_debug : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_trx_rseg_n_slots_debug : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_undo_directory : ./ # 2020-04-03T08:56:41 [109746] SVAR: innodb_undo_log_truncate : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_undo_logs : 128 # 2020-04-03T08:56:41 [109746] SVAR: innodb_undo_tablespaces : 0 # 2020-04-03T08:56:41 [109746] SVAR: innodb_use_atomic_writes : ON # 2020-04-03T08:56:41 [109746] SVAR: innodb_use_native_aio : OFF # 2020-04-03T08:56:41 [109746] SVAR: innodb_version : 10.5.3 # 2020-04-03T08:56:41 [109746] SVAR: innodb_write_io_threads : 4 # 2020-04-03T08:56:41 [109746] SVAR: insert_id : 0 # 2020-04-03T08:56:41 [109746] SVAR: interactive_timeout : 28800 # 2020-04-03T08:56:41 [109746] SVAR: join_buffer_size : 262144 # 2020-04-03T08:56:41 [109746] SVAR: join_buffer_space_limit : 2097152 # 2020-04-03T08:56:41 [109746] SVAR: join_cache_level : 2 # 2020-04-03T08:56:41 [109746] SVAR: keep_files_on_create : OFF # 2020-04-03T08:56:41 [109746] SVAR: key_buffer_size : 134217728 # 2020-04-03T08:56:41 [109746] SVAR: key_cache_age_threshold : 300 # 2020-04-03T08:56:41 [109746] SVAR: key_cache_block_size : 1024 # 2020-04-03T08:56:41 [109746] SVAR: key_cache_division_limit : 100 # 2020-04-03T08:56:41 [109746] SVAR: key_cache_file_hash_size : 512 # 2020-04-03T08:56:41 [109746] SVAR: key_cache_segments : 0 # 2020-04-03T08:56:41 [109746] SVAR: large_files_support : ON # 2020-04-03T08:56:41 [109746] SVAR: large_page_size : 0 # 2020-04-03T08:56:41 [109746] SVAR: large_pages : OFF # 2020-04-03T08:56:41 [109746] SVAR: last_gtid : # 2020-04-03T08:56:41 [109746] SVAR: last_insert_id : 0 # 2020-04-03T08:56:41 [109746] SVAR: lc_messages : en_US # 2020-04-03T08:56:41 [109746] SVAR: lc_messages_dir : /home/mleich/10.5_ori/bld_debug//sql/share # 2020-04-03T08:56:41 [109746] SVAR: lc_time_names : en_US # 2020-04-03T08:56:41 [109746] SVAR: license : GPL # 2020-04-03T08:56:41 [109746] SVAR: local_infile : ON # 2020-04-03T08:56:41 [109746] SVAR: lock_wait_timeout : 86400 # 2020-04-03T08:56:41 [109746] SVAR: locked_in_memory : OFF # 2020-04-03T08:56:41 [109746] SVAR: log_bin : ON # 2020-04-03T08:56:41 [109746] SVAR: log_bin_basename : /dev/shm/vardir/1585903801/208/1/data/mysql-bin # 2020-04-03T08:56:41 [109746] SVAR: log_bin_compress : OFF # 2020-04-03T08:56:41 [109746] SVAR: log_bin_compress_min_len : 256 # 2020-04-03T08:56:41 [109746] SVAR: log_bin_index : /dev/shm/vardir/1585903801/208/1/data/mysql-bin.index # 2020-04-03T08:56:41 [109746] SVAR: log_bin_trust_function_creators : ON # 2020-04-03T08:56:41 [109746] SVAR: log_disabled_statements : sp # 2020-04-03T08:56:41 [109746] SVAR: log_error : # 2020-04-03T08:56:41 [109746] SVAR: log_output : NONE # 2020-04-03T08:56:41 [109746] SVAR: log_queries_not_using_indexes : OFF # 2020-04-03T08:56:41 [109746] SVAR: log_slave_updates : OFF # 2020-04-03T08:56:41 [109746] SVAR: log_slow_admin_statements : ON # 2020-04-03T08:56:41 [109746] SVAR: log_slow_disabled_statements : sp # 2020-04-03T08:56:41 [109746] 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-03T08:56:41 [109746] SVAR: log_slow_rate_limit : 1 # 2020-04-03T08:56:41 [109746] SVAR: log_slow_slave_statements : ON # 2020-04-03T08:56:41 [109746] SVAR: log_slow_verbosity : # 2020-04-03T08:56:41 [109746] SVAR: log_tc_size : 24576 # 2020-04-03T08:56:41 [109746] SVAR: log_warnings : 2 # 2020-04-03T08:56:41 [109746] SVAR: long_query_time : 10.000000 # 2020-04-03T08:56:41 [109746] SVAR: low_priority_updates : OFF # 2020-04-03T08:56:41 [109746] SVAR: lower_case_file_system : OFF # 2020-04-03T08:56:41 [109746] SVAR: lower_case_table_names : 0 # 2020-04-03T08:56:41 [109746] SVAR: master_verify_checksum : OFF # 2020-04-03T08:56:41 [109746] SVAR: max_allowed_packet : 134217728 # 2020-04-03T08:56:41 [109746] SVAR: max_binlog_cache_size : 18446744073709547520 # 2020-04-03T08:56:41 [109746] SVAR: max_binlog_size : 1073741824 # 2020-04-03T08:56:41 [109746] SVAR: max_binlog_stmt_cache_size : 18446744073709547520 # 2020-04-03T08:56:41 [109746] SVAR: max_connect_errors : 100 # 2020-04-03T08:56:41 [109746] SVAR: max_connections : 151 # 2020-04-03T08:56:41 [109746] SVAR: max_delayed_threads : 20 # 2020-04-03T08:56:41 [109746] SVAR: max_digest_length : 1024 # 2020-04-03T08:56:41 [109746] SVAR: max_error_count : 64 # 2020-04-03T08:56:41 [109746] SVAR: max_heap_table_size : 16777216 # 2020-04-03T08:56:41 [109746] SVAR: max_insert_delayed_threads : 20 # 2020-04-03T08:56:41 [109746] SVAR: max_join_size : 18446744073709551615 # 2020-04-03T08:56:41 [109746] SVAR: max_length_for_sort_data : 1024 # 2020-04-03T08:56:41 [109746] SVAR: max_password_errors : 4294967295 # 2020-04-03T08:56:41 [109746] SVAR: max_prepared_stmt_count : 16382 # 2020-04-03T08:56:41 [109746] SVAR: max_recursive_iterations : 4294967295 # 2020-04-03T08:56:41 [109746] SVAR: max_relay_log_size : 1073741824 # 2020-04-03T08:56:41 [109746] SVAR: max_rowid_filter_size : 131072 # 2020-04-03T08:56:41 [109746] SVAR: max_seeks_for_key : 4294967295 # 2020-04-03T08:56:41 [109746] SVAR: max_session_mem_used : 9223372036854775807 # 2020-04-03T08:56:41 [109746] SVAR: max_sort_length : 1024 # 2020-04-03T08:56:41 [109746] SVAR: max_sp_recursion_depth : 0 # 2020-04-03T08:56:41 [109746] SVAR: max_statement_time : 0.000000 # 2020-04-03T08:56:41 [109746] SVAR: max_tmp_tables : 32 # 2020-04-03T08:56:41 [109746] SVAR: max_user_connections : 0 # 2020-04-03T08:56:41 [109746] SVAR: max_write_lock_count : 4294967295 # 2020-04-03T08:56:41 [109746] SVAR: metadata_locks_cache_size : 1024 # 2020-04-03T08:56:41 [109746] SVAR: metadata_locks_hash_instances : 8 # 2020-04-03T08:56:41 [109746] SVAR: min_examined_row_limit : 0 # 2020-04-03T08:56:41 [109746] SVAR: mrr_buffer_size : 262144 # 2020-04-03T08:56:41 [109746] SVAR: myisam_block_size : 1024 # 2020-04-03T08:56:41 [109746] SVAR: myisam_data_pointer_size : 6 # 2020-04-03T08:56:41 [109746] SVAR: myisam_max_sort_file_size : 9223372036853727232 # 2020-04-03T08:56:41 [109746] SVAR: myisam_mmap_size : 18446744073709551615 # 2020-04-03T08:56:41 [109746] SVAR: myisam_recover_options : BACKUP,QUICK # 2020-04-03T08:56:41 [109746] SVAR: myisam_repair_threads : 1 # 2020-04-03T08:56:41 [109746] SVAR: myisam_sort_buffer_size : 134216704 # 2020-04-03T08:56:41 [109746] SVAR: myisam_stats_method : NULLS_UNEQUAL # 2020-04-03T08:56:41 [109746] SVAR: myisam_use_mmap : OFF # 2020-04-03T08:56:41 [109746] SVAR: mysql56_temporal_format : ON # 2020-04-03T08:56:41 [109746] SVAR: net_buffer_length : 16384 # 2020-04-03T08:56:41 [109746] SVAR: net_read_timeout : 30 # 2020-04-03T08:56:41 [109746] SVAR: net_retry_count : 10 # 2020-04-03T08:56:41 [109746] SVAR: net_write_timeout : 60 # 2020-04-03T08:56:41 [109746] SVAR: old : OFF # 2020-04-03T08:56:41 [109746] SVAR: old_alter_table : DEFAULT # 2020-04-03T08:56:41 [109746] SVAR: old_mode : # 2020-04-03T08:56:41 [109746] SVAR: old_passwords : OFF # 2020-04-03T08:56:41 [109746] SVAR: open_files_limit : 10240 # 2020-04-03T08:56:41 [109746] SVAR: optimizer_prune_level : 1 # 2020-04-03T08:56:41 [109746] SVAR: optimizer_search_depth : 62 # 2020-04-03T08:56:41 [109746] SVAR: optimizer_selectivity_sampling_limit : 100 # 2020-04-03T08:56:41 [109746] 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-03T08:56:41 [109746] SVAR: optimizer_trace : enabled=off # 2020-04-03T08:56:41 [109746] SVAR: optimizer_trace_max_mem_size : 1048576 # 2020-04-03T08:56:41 [109746] SVAR: optimizer_use_condition_selectivity : 4 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema : OFF # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_accounts_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_digests_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_stages_history_long_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_stages_history_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_statements_history_long_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_statements_history_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_transactions_history_long_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_transactions_history_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_waits_history_long_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_events_waits_history_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_hosts_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_cond_classes : 90 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_cond_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_digest_length : 1024 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_file_classes : 80 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_file_handles : 32768 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_file_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_index_stat : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_memory_classes : 320 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_metadata_locks : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_mutex_classes : 210 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_mutex_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_prepared_statements_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_program_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_rwlock_classes : 50 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_rwlock_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_socket_classes : 10 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_socket_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_sql_text_length : 1024 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_stage_classes : 160 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_statement_classes : 222 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_statement_stack : 10 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_table_handles : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_table_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_table_lock_stat : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_thread_classes : 50 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_max_thread_instances : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_session_connect_attrs_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_setup_actors_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_setup_objects_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: performance_schema_users_size : -1 # 2020-04-03T08:56:41 [109746] SVAR: pid_file : /dev/shm/vardir/1585903801/208/1/mysql.pid # 2020-04-03T08:56:41 [109746] SVAR: plugin_dir : /home/mleich/10.5_ori/bld_debug/lib/plugin/ # 2020-04-03T08:56:41 [109746] SVAR: plugin_maturity : alpha # 2020-04-03T08:56:41 [109746] SVAR: port : 28740 # 2020-04-03T08:56:41 [109746] SVAR: preload_buffer_size : 32768 # 2020-04-03T08:56:41 [109746] SVAR: profiling : OFF # 2020-04-03T08:56:41 [109746] SVAR: profiling_history_size : 15 # 2020-04-03T08:56:41 [109746] SVAR: progress_report_time : 5 # 2020-04-03T08:56:41 [109746] SVAR: protocol_version : 10 # 2020-04-03T08:56:41 [109746] SVAR: proxy_protocol_networks : # 2020-04-03T08:56:41 [109746] SVAR: proxy_user : # 2020-04-03T08:56:41 [109746] SVAR: pseudo_slave_mode : OFF # 2020-04-03T08:56:41 [109746] SVAR: pseudo_thread_id : 4 # 2020-04-03T08:56:41 [109746] SVAR: query_alloc_block_size : 16384 # 2020-04-03T08:56:41 [109746] SVAR: query_cache_limit : 1048576 # 2020-04-03T08:56:41 [109746] SVAR: query_cache_min_res_unit : 4096 # 2020-04-03T08:56:41 [109746] SVAR: query_cache_size : 1048576 # 2020-04-03T08:56:41 [109746] SVAR: query_cache_strip_comments : OFF # 2020-04-03T08:56:41 [109746] SVAR: query_cache_type : OFF # 2020-04-03T08:56:41 [109746] SVAR: query_cache_wlock_invalidate : OFF # 2020-04-03T08:56:41 [109746] SVAR: query_prealloc_size : 24576 # 2020-04-03T08:56:41 [109746] SVAR: rand_seed1 : 900735240 # 2020-04-03T08:56:41 [109746] SVAR: rand_seed2 : 768954918 # 2020-04-03T08:56:41 [109746] SVAR: range_alloc_block_size : 4096 # 2020-04-03T08:56:41 [109746] SVAR: read_binlog_speed_limit : 0 # 2020-04-03T08:56:41 [109746] SVAR: read_buffer_size : 131072 # 2020-04-03T08:56:41 [109746] SVAR: read_only : OFF # 2020-04-03T08:56:41 [109746] SVAR: read_rnd_buffer_size : 262144 # 2020-04-03T08:56:41 [109746] SVAR: relay_log : # 2020-04-03T08:56:41 [109746] SVAR: relay_log_basename : # 2020-04-03T08:56:41 [109746] SVAR: relay_log_index : # 2020-04-03T08:56:41 [109746] SVAR: relay_log_info_file : relay-log.info # 2020-04-03T08:56:41 [109746] SVAR: relay_log_purge : ON # 2020-04-03T08:56:41 [109746] SVAR: relay_log_recovery : OFF # 2020-04-03T08:56:41 [109746] SVAR: relay_log_space_limit : 0 # 2020-04-03T08:56:41 [109746] SVAR: replicate_annotate_row_events : ON # 2020-04-03T08:56:41 [109746] SVAR: replicate_do_db : # 2020-04-03T08:56:41 [109746] SVAR: replicate_do_table : # 2020-04-03T08:56:41 [109746] SVAR: replicate_events_marked_for_skip : REPLICATE # 2020-04-03T08:56:41 [109746] SVAR: replicate_ignore_db : # 2020-04-03T08:56:41 [109746] SVAR: replicate_ignore_table : # 2020-04-03T08:56:41 [109746] SVAR: replicate_wild_do_table : # 2020-04-03T08:56:41 [109746] SVAR: replicate_wild_ignore_table : # 2020-04-03T08:56:41 [109746] SVAR: report_host : # 2020-04-03T08:56:41 [109746] SVAR: report_password : # 2020-04-03T08:56:41 [109746] SVAR: report_port : 28740 # 2020-04-03T08:56:41 [109746] SVAR: report_user : # 2020-04-03T08:56:41 [109746] SVAR: require_secure_transport : OFF # 2020-04-03T08:56:41 [109746] SVAR: rowid_merge_buff_size : 8388608 # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_master_enabled : OFF # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_master_timeout : 10000 # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_master_trace_level : 32 # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_master_wait_no_slave : ON # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_master_wait_point : AFTER_COMMIT # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_slave_delay_master : OFF # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_slave_enabled : OFF # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_slave_kill_conn_timeout : 5 # 2020-04-03T08:56:41 [109746] SVAR: rpl_semi_sync_slave_trace_level : 32 # 2020-04-03T08:56:41 [109746] SVAR: secure_auth : ON # 2020-04-03T08:56:41 [109746] SVAR: secure_file_priv : # 2020-04-03T08:56:41 [109746] SVAR: secure_timestamp : NO # 2020-04-03T08:56:41 [109746] SVAR: server_id : 1 # 2020-04-03T08:56:41 [109746] SVAR: session_track_schema : ON # 2020-04-03T08:56:41 [109746] SVAR: session_track_state_change : OFF # 2020-04-03T08:56:41 [109746] SVAR: session_track_system_variables : autocommit,character_set_client,character_set_connection,character_set_results,time_zone # 2020-04-03T08:56:41 [109746] SVAR: session_track_transaction_info : OFF # 2020-04-03T08:56:41 [109746] SVAR: session_track_user_variables : OFF # 2020-04-03T08:56:41 [109746] SVAR: skip_external_locking : ON # 2020-04-03T08:56:41 [109746] SVAR: skip_name_resolve : OFF # 2020-04-03T08:56:41 [109746] SVAR: skip_networking : OFF # 2020-04-03T08:56:41 [109746] SVAR: skip_parallel_replication : OFF # 2020-04-03T08:56:41 [109746] SVAR: skip_replication : OFF # 2020-04-03T08:56:41 [109746] SVAR: skip_show_database : OFF # 2020-04-03T08:56:41 [109746] SVAR: slave_compressed_protocol : OFF # 2020-04-03T08:56:41 [109746] SVAR: slave_ddl_exec_mode : IDEMPOTENT # 2020-04-03T08:56:41 [109746] SVAR: slave_domain_parallel_threads : 0 # 2020-04-03T08:56:41 [109746] SVAR: slave_exec_mode : STRICT # 2020-04-03T08:56:41 [109746] SVAR: slave_load_tmpdir : /dev/shm/vardir/1585903801/208/1/tmp # 2020-04-03T08:56:41 [109746] SVAR: slave_max_allowed_packet : 1073741824 # 2020-04-03T08:56:41 [109746] SVAR: slave_net_timeout : 60 # 2020-04-03T08:56:41 [109746] SVAR: slave_parallel_max_queued : 131072 # 2020-04-03T08:56:41 [109746] SVAR: slave_parallel_mode : optimistic # 2020-04-03T08:56:41 [109746] SVAR: slave_parallel_threads : 0 # 2020-04-03T08:56:41 [109746] SVAR: slave_parallel_workers : 0 # 2020-04-03T08:56:41 [109746] SVAR: slave_run_triggers_for_rbr : NO # 2020-04-03T08:56:41 [109746] SVAR: slave_skip_errors : OFF # 2020-04-03T08:56:41 [109746] SVAR: slave_sql_verify_checksum : ON # 2020-04-03T08:56:41 [109746] SVAR: slave_transaction_retries : 10 # 2020-04-03T08:56:41 [109746] SVAR: slave_transaction_retry_errors : 1158,1159,1160,1161,1205,1213,1429,2013,12701 # 2020-04-03T08:56:41 [109746] SVAR: slave_transaction_retry_interval : 0 # 2020-04-03T08:56:41 [109746] SVAR: slave_type_conversions : # 2020-04-03T08:56:41 [109746] SVAR: slow_launch_time : 2 # 2020-04-03T08:56:41 [109746] SVAR: slow_query_log : OFF # 2020-04-03T08:56:41 [109746] SVAR: slow_query_log_file : sdp-slow.log # 2020-04-03T08:56:41 [109746] SVAR: socket : /dev/shm/vardir/1585903801/208/1/mysql.sock # 2020-04-03T08:56:41 [109746] SVAR: sort_buffer_size : 2097152 # 2020-04-03T08:56:41 [109746] SVAR: sql_auto_is_null : OFF # 2020-04-03T08:56:41 [109746] SVAR: sql_big_selects : ON # 2020-04-03T08:56:41 [109746] SVAR: sql_buffer_result : OFF # 2020-04-03T08:56:41 [109746] SVAR: sql_if_exists : OFF # 2020-04-03T08:56:41 [109746] SVAR: sql_log_bin : ON # 2020-04-03T08:56:41 [109746] SVAR: sql_log_off : OFF # 2020-04-03T08:56:41 [109746] SVAR: sql_mode : NO_ENGINE_SUBSTITUTION # 2020-04-03T08:56:41 [109746] SVAR: sql_notes : ON # 2020-04-03T08:56:41 [109746] SVAR: sql_quote_show_create : ON # 2020-04-03T08:56:41 [109746] SVAR: sql_safe_updates : OFF # 2020-04-03T08:56:41 [109746] SVAR: sql_select_limit : 18446744073709551615 # 2020-04-03T08:56:41 [109746] SVAR: sql_slave_skip_counter : 0 # 2020-04-03T08:56:41 [109746] SVAR: sql_warnings : OFF # 2020-04-03T08:56:41 [109746] SVAR: ssl_ca : # 2020-04-03T08:56:41 [109746] SVAR: ssl_capath : # 2020-04-03T08:56:41 [109746] SVAR: ssl_cert : # 2020-04-03T08:56:41 [109746] SVAR: ssl_cipher : # 2020-04-03T08:56:41 [109746] SVAR: ssl_crl : # 2020-04-03T08:56:41 [109746] SVAR: ssl_crlpath : # 2020-04-03T08:56:41 [109746] SVAR: ssl_key : # 2020-04-03T08:56:41 [109746] SVAR: standard_compliant_cte : ON # 2020-04-03T08:56:41 [109746] SVAR: storage_engine : InnoDB # 2020-04-03T08:56:41 [109746] SVAR: stored_program_cache : 256 # 2020-04-03T08:56:41 [109746] SVAR: strict_password_validation : ON # 2020-04-03T08:56:41 [109746] SVAR: sync_binlog : 0 # 2020-04-03T08:56:41 [109746] SVAR: sync_frm : ON # 2020-04-03T08:56:41 [109746] SVAR: sync_master_info : 10000 # 2020-04-03T08:56:41 [109746] SVAR: sync_relay_log : 10000 # 2020-04-03T08:56:41 [109746] SVAR: sync_relay_log_info : 10000 # 2020-04-03T08:56:41 [109746] SVAR: system_time_zone : UTC # 2020-04-03T08:56:41 [109746] SVAR: system_versioning_alter_history : ERROR # 2020-04-03T08:56:41 [109746] SVAR: system_versioning_asof : DEFAULT # 2020-04-03T08:56:41 [109746] SVAR: table_definition_cache : 400 # 2020-04-03T08:56:41 [109746] SVAR: table_open_cache : 2000 # 2020-04-03T08:56:41 [109746] SVAR: table_open_cache_instances : 2 # 2020-04-03T08:56:41 [109746] SVAR: tcp_keepalive_interval : 0 # 2020-04-03T08:56:41 [109746] SVAR: tcp_keepalive_probes : 0 # 2020-04-03T08:56:41 [109746] SVAR: tcp_keepalive_time : 0 # 2020-04-03T08:56:41 [109746] SVAR: tcp_nodelay : ON # 2020-04-03T08:56:41 [109746] SVAR: thread_cache_size : 151 # 2020-04-03T08:56:41 [109746] SVAR: thread_handling : one-thread-per-connection # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_dedicated_listener : OFF # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_exact_stats : OFF # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_idle_timeout : 60 # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_max_threads : 65536 # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_oversubscribe : 3 # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_prio_kickup_timer : 1000 # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_priority : auto # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_size : 1 # 2020-04-03T08:56:41 [109746] SVAR: thread_pool_stall_limit : 500 # 2020-04-03T08:56:41 [109746] SVAR: thread_stack : 299008 # 2020-04-03T08:56:41 [109746] SVAR: time_format : %H:%i:%s # 2020-04-03T08:56:41 [109746] SVAR: time_zone : SYSTEM # 2020-04-03T08:56:41 [109746] SVAR: timestamp : 1585904201.423481 # 2020-04-03T08:56:41 [109746] SVAR: tls_version : TLSv1.1,TLSv1.2,TLSv1.3 # 2020-04-03T08:56:41 [109746] SVAR: tmp_disk_table_size : 18446744073709551615 # 2020-04-03T08:56:41 [109746] SVAR: tmp_memory_table_size : 16777216 # 2020-04-03T08:56:41 [109746] SVAR: tmp_table_size : 16777216 # 2020-04-03T08:56:41 [109746] SVAR: tmpdir : /dev/shm/vardir/1585903801/208/1/tmp # 2020-04-03T08:56:41 [109746] SVAR: transaction_alloc_block_size : 8192 # 2020-04-03T08:56:41 [109746] SVAR: transaction_prealloc_size : 4096 # 2020-04-03T08:56:41 [109746] SVAR: tx_isolation : REPEATABLE-READ # 2020-04-03T08:56:41 [109746] SVAR: tx_read_only : OFF # 2020-04-03T08:56:41 [109746] SVAR: unique_checks : ON # 2020-04-03T08:56:41 [109746] SVAR: updatable_views_with_limit : YES # 2020-04-03T08:56:41 [109746] SVAR: use_stat_tables : PREFERABLY_FOR_QUERIES # 2020-04-03T08:56:41 [109746] SVAR: userstat : OFF # 2020-04-03T08:56:41 [109746] SVAR: version : 10.5.3-MariaDB-debug-log # 2020-04-03T08:56:41 [109746] SVAR: version_comment : Source distribution # 2020-04-03T08:56:41 [109746] SVAR: version_compile_machine : x86_64 # 2020-04-03T08:56:41 [109746] SVAR: version_compile_os : Linux # 2020-04-03T08:56:41 [109746] SVAR: version_malloc_library : system # 2020-04-03T08:56:41 [109746] SVAR: version_source_revision : 0870b75af7d01f2e8132278aeb0873dd6c65d1be # 2020-04-03T08:56:41 [109746] SVAR: version_ssl_library : WolfSSL 4.3.0 # 2020-04-03T08:56:41 [109746] SVAR: wait_timeout : 28800 # 2020-04-03T08:56:41 [109746] SVAR: warning_count : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_auto_increment_control : ON # 2020-04-03T08:56:41 [109746] SVAR: wsrep_causal_reads : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_certification_rules : strict # 2020-04-03T08:56:41 [109746] SVAR: wsrep_certify_nonpk : ON # 2020-04-03T08:56:41 [109746] SVAR: wsrep_cluster_address : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_cluster_name : my_wsrep_cluster # 2020-04-03T08:56:41 [109746] SVAR: wsrep_convert_lock_to_trx : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_data_home_dir : /dev/shm/vardir/1585903801/208/1/data/ # 2020-04-03T08:56:41 [109746] SVAR: wsrep_dbug_option : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_debug : NONE # 2020-04-03T08:56:41 [109746] SVAR: wsrep_desync : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_dirty_reads : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_drupal_282555_workaround : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_forced_binlog_format : NONE # 2020-04-03T08:56:41 [109746] SVAR: wsrep_gtid_domain_id : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_gtid_mode : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_gtid_seq_no : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_ignore_apply_errors : 7 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_load_data_splitting : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_log_conflicts : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_max_ws_rows : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_max_ws_size : 2147483647 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_mysql_replication_bundle : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_node_address : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_node_incoming_address : AUTO # 2020-04-03T08:56:41 [109746] SVAR: wsrep_node_name : sdp # 2020-04-03T08:56:41 [109746] SVAR: wsrep_notify_cmd : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_on : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_osu_method : TOI # 2020-04-03T08:56:41 [109746] SVAR: wsrep_patch_version : wsrep_26.22 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_provider : none # 2020-04-03T08:56:41 [109746] SVAR: wsrep_provider_options : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_recover : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_reject_queries : NONE # 2020-04-03T08:56:41 [109746] SVAR: wsrep_replicate_myisam : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_restart_slave : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_retry_autocommit : 1 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_slave_fk_checks : ON # 2020-04-03T08:56:41 [109746] SVAR: wsrep_slave_threads : 1 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_slave_uk_checks : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sr_store : table # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sst_auth : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sst_donor : # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sst_donor_rejects_queries : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sst_method : rsync # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sst_receive_address : AUTO # 2020-04-03T08:56:41 [109746] SVAR: wsrep_start_position : 00000000-0000-0000-0000-000000000000:-1 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_strict_ddl : OFF # 2020-04-03T08:56:41 [109746] SVAR: wsrep_sync_wait : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_trx_fragment_size : 0 # 2020-04-03T08:56:41 [109746] SVAR: wsrep_trx_fragment_unit : bytes # 2020-04-03T08:56:41 [109746] DEBUG: dsns[0] defined. # 2020-04-03T08:56:41 [109746] --------------------------------------------------------------- # 2020-04-03T08:56:41 [109746] debug_server => ['undef', 'undef', 'undef'] # 2020-04-03T08:56:41 [109746] dsn => ['dbi:mysql:host=127.0.0.1:port=28740:user=root:database=test:mysql_local_infile=1'] # 2020-04-03T08:56:41 [109746] duration => 120 # 2020-04-03T08:56:41 [109746] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-04-03T08:56:41 [109746] gendata => /home/mleich/RQG_RR/storage/1585903801/208/rqg.zz # 2020-04-03T08:56:41 [109746] generator => FromGrammar # 2020-04-03T08:56:41 [109746] grammar => /home/mleich/RQG_RR/storage/1585903801/208/rqg.yy # 2020-04-03T08:56:41 [109746] logfile => /home/mleich/RQG_RR/storage/1585903801/208/rqg.log # 2020-04-03T08:56:41 [109746] mask => 0 # 2020-04-03T08:56:41 [109746] mask-level => 0 # 2020-04-03T08:56:41 [109746] queries => 10000000 # 2020-04-03T08:56:41 [109746] reporters => ['CrashRecovery1', 'Deadlock1', 'ErrorLog', 'None', 'ServerDead'] # 2020-04-03T08:56:41 [109746] rpl_mode => none # 2020-04-03T08:56:41 [109746] rr => 1 # 2020-04-03T08:56:41 [109746] seed => 29825 # 2020-04-03T08:56:41 [109746] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x558176959040)'] # 2020-04-03T08:56:41 [109746] threads => 1 # 2020-04-03T08:56:41 [109746] validators => ['None'] # 2020-04-03T08:56:41 [109746] vcols => ['undef', 'undef', 'undef'] # 2020-04-03T08:56:41 [109746] views => ['undef', 'undef', 'undef'] # 2020-04-03T08:56:41 [109746] --------------------------------------------------------------- # 2020-04-03T08:56:41 [109746] ------------------------------- # 2020-04-03T08:56:41 [109746] Configuration # 2020-04-03T08:56:41 [109746] debug_server => ['undef', 'undef', 'undef'] # 2020-04-03T08:56:41 [109746] dsn => ['dbi:mysql:host=127.0.0.1:port=28740:user=root:database=test:mysql_local_infile=1'] # 2020-04-03T08:56:41 [109746] duration => 120 # 2020-04-03T08:56:41 [109746] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-04-03T08:56:41 [109746] gendata => /home/mleich/RQG_RR/storage/1585903801/208/rqg.zz # 2020-04-03T08:56:41 [109746] generator => FromGrammar # 2020-04-03T08:56:41 [109746] grammar => /home/mleich/RQG_RR/storage/1585903801/208/rqg.yy # 2020-04-03T08:56:41 [109746] logfile => /home/mleich/RQG_RR/storage/1585903801/208/rqg.log # 2020-04-03T08:56:41 [109746] mask => 0 # 2020-04-03T08:56:41 [109746] mask-level => 0 # 2020-04-03T08:56:41 [109746] queries => 10000000 # 2020-04-03T08:56:41 [109746] reporters => ['CrashRecovery1', 'Deadlock1', 'ErrorLog', 'None', 'ServerDead'] # 2020-04-03T08:56:41 [109746] rpl_mode => none # 2020-04-03T08:56:41 [109746] rr => 1 # 2020-04-03T08:56:41 [109746] seed => 29825 # 2020-04-03T08:56:41 [109746] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x558176959040)'] # 2020-04-03T08:56:41 [109746] threads => 1 # 2020-04-03T08:56:41 [109746] validators => ['None'] # 2020-04-03T08:56:41 [109746] vcols => ['undef', 'undef', 'undef'] # 2020-04-03T08:56:41 [109746] views => ['undef', 'undef', 'undef'] # 2020-04-03T08:56:41 [109746] INFO: Begin of GenData activity # 2020-04-03T08:56:41 [109746] INFO: Starting GenTest::App::Gendata # 2020-04-03T08:56:41 [109746] Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 . # 2020-04-03T08:56:44 [109746] Creating MySQL table: test.table100_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 100 . # 2020-04-03T08:56:45 [109746] INFO: Finishing GenTest::App::Gendata # 2020-04-03T08:56:45 [109746] INFO: End of GenData activity # 2020-04-03T08:56:45 [109746] GenData returned status STATUS_OK (0) # 2020-04-03T08:56:45 [109746] INFO: RQG GenData runtime in s : 4 # 2020-04-03T08:56:45 [109746] INFO: GenTest: Start of running queries : 1585904206 # 2020-04-03T08:56:45 [109746] Reading grammar from file '/home/mleich/RQG_RR/storage/1585903801/208/rqg.yy'. # 2020-04-03T08:56:45 [109746] Reporters (for Simplifier): ->CrashRecovery1<->Deadlock1<->ErrorLog<->None<->ServerDead<- # 2020-04-03T08:56:45 [109746] INFO: Reporter 'CrashRecovery1' added. # 2020-04-03T08:56:45 [109746] INFO: Reporter 'Deadlock1' added. # 2020-04-03T08:56:45 [109746] INFO: Reporter 'ErrorLog' added. # 2020-04-03T08:56:45 [109746] INFO: Reporter 'ServerDead' added. # 2020-04-03T08:56:45 [109746] Validators (for Simplifier): ->None<- # 2020-04-03T08:56:45 [109746] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=28740:user=root:database=test:mysql_local_infile=1 # 2020-04-03T08:56:49 [109746] Starting 1 processes, 10000000 queries each, duration 120 seconds. # 2020-04-03T08:56:49 [109746] GenTest::ErrorFilter(1627) started # 2020-04-03T08:56:49 [1631] INFO: Thread1 : Mixer created. # 2020-04-03T08:56:49 [1628] INFO: Periodic reporting process at begin of activity # 2020-04-03T08:56:49 [1628] INFO: Reporter 'CrashRecovery1': First monitoring # 2020-04-03T08:56:50 [1627] ErrorFilter: Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_varchar_255_ucs2`, `col_enum_ucs2`, `col_varchar_255_ucs2` ) VALUES ( CONVERT( 'ntdrqyashjdouoabybnoofpiaofbritdhdkdfokixjhxzdpdddgysymtlbfikcwzmgasmelhgucszwdtlngrkrcobmgpfzzaignyhvuvutbgumzhrnddaudbqctszhjfcdukznuxysbfbyaobbzdxrwnsrnwvrxpjfczptksoixyeqmswfnvavwejvwlpxksgwkyrjrjtyacbgudxkdbcwoizcplmnbkxhhisalpdlwijmrkre' USING ASCII ), CONVERT( 'meantime' USING ASCII ), REPEAT( 0x8CA, 80 ) ) /* E_R Thread1 QNO 46 CON_ID 12 */ failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2020-04-03T08:58:29 [1628] INFO: Reporter 'CrashRecovery1': Sending SIGKILL to server with pid 110871 in order to force a crash. # 2020-04-03T08:58:29 [1628] ERROR: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=28740:user=root:database=test:mysql_local_infile=1 failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 104 after 0.0291690826416016 s. # 2020-04-03T08:58:29 [1631] Executor::MySQL::execute: Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_enum_ucs2_key`, `col_longtext_ucs2`, `col_enum_utf8_key` ) VALUES ( REPEAT( 0x5, 219 ), REPEAT( 0xF4E0, 156 ), CONVERT( 'bpedbyemyudcpfnrwxdzqwgujcjyvcckg' USING ASCII ) ) /* E_R Thread1 QNO 1484 CON_ID 12 */ failed: 2013 Lost connection to MySQL server during query # 2020-04-03T08:58:29 [1628] ERROR: Reporter 'Deadlock': Will return status 101. # 2020-04-03T08:58:29 [1628] ERROR: Periodic reporting process: Critical status STATUS_SERVER_KILLED got. Will exit with that. # 2020-04-03T08:58:29 [1628] GenTest: child 1628 is being stopped with status STATUS_SERVER_KILLED # 2020-04-03T08:58:34 [109746] Process with pid 1628 for periodic reporter ended with status STATUS_SERVER_KILLED # 2020-04-03T08:58:34 [109746] Killing (TERM) remaining worker process with pid 1631... # 2020-04-03T08:58:35 [109746] Process with pid 1631 for Thread1 ended with status STATUS_OK # 2020-04-03T08:58:49 [109746] Kill GenTest::ErrorFilter(1627) # 2020-04-03T08:58:49 [109746] INFO: GenTest: Effective duration in s : 123 DBI connect('host=127.0.0.1:port=28740: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-03T08:58:49 [109746] INFO: Reporter 'CrashRecovery1': Copying datadir... (interrupting the copy operation may cause investigation problems later) # 2020-04-03T08:58:49 [109746] INFO: Reporter 'CrashRecovery1': Attempting database recovery using the server ... # 2020-04-03T08:58:49 [109746] MLML2 ->rr record --mark-stdio "/home/mleich/10.5_ori/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/home/mleich/10.5_ori/bld_debug/" "--lc-messages-dir=/home/mleich/10.5_ori/bld_debug//sql/share" "--character-sets-dir=/home/mleich/10.5_ori/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1585903801/208/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1585903801/208/1/data" "--max-allowed-packet=128Mb" "--port=28740" "--socket=/dev/shm/vardir/1585903801/208/1/mysql.sock" "--pid-file=/dev/shm/vardir/1585903801/208/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1585903801/208/1/mysql.log" "--innodb_page_size=32K" "--net_read_timeout=30" "--lock-wait-timeout=86400" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--innodb-lock-wait-timeout=50" "--loose-debug_assert_on_not_freed_memory=0" "--net_write_timeout=60" "--wait_timeout=28800" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-bin" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--interactive_timeout=28800" "--loose_innodb_use_native_aio=1" "--slave_net_timeout=60" "--innodb_stats_persistent=off" "--log-output=none" "--loose_innodb_lock_schedule_algorithm=fcfs" "--sql-mode=no_engine_substitution"<- # 2020-04-03T08:58:49 [109746] INFO: Starting MySQL 10.5.3: rr record --mark-stdio "/home/mleich/10.5_ori/bld_debug//sql/mysqld" "--no-defaults" "--basedir=/home/mleich/10.5_ori/bld_debug/" "--lc-messages-dir=/home/mleich/10.5_ori/bld_debug//sql/share" "--character-sets-dir=/home/mleich/10.5_ori/sql/share/charsets" "--tmpdir=/dev/shm/vardir/1585903801/208/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1585903801/208/1/data" "--max-allowed-packet=128Mb" "--port=28740" "--socket=/dev/shm/vardir/1585903801/208/1/mysql.sock" "--pid-file=/dev/shm/vardir/1585903801/208/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1585903801/208/1/mysql.log" "--innodb_page_size=32K" "--net_read_timeout=30" "--lock-wait-timeout=86400" "--loose-table_lock_wait_timeout=50" "--loose-idle_readonly_transaction_timeout=0" "--innodb-lock-wait-timeout=50" "--loose-debug_assert_on_not_freed_memory=0" "--net_write_timeout=60" "--wait_timeout=28800" "--log_bin_trust_function_creators=1" "--connect_timeout=60" "--log-bin" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--interactive_timeout=28800" "--loose_innodb_use_native_aio=1" "--slave_net_timeout=60" "--innodb_stats_persistent=off" "--log-output=none" "--loose_innodb_lock_schedule_algorithm=fcfs" "--sql-mode=no_engine_substitution" # 2020-04-03T08:58:50 [109746] DEBUG: Server pid found in error log: 70661 # 2020-04-03T08:58:50 [109746] --------- Contents of /dev/shm/vardir/1585903801/208/1/mysql.err ------------- # 2020-04-03T08:58:50 [109746] | [rr 70661 3122]2020-04-03 8:58:49 0 [Note] /home/mleich/10.5_ori/bld_debug//sql/mysqld (mysqld 10.5.3-MariaDB-debug-log) starting as process 70661 ... # 2020-04-03T08:58:50 [109746] | [rr 70661 3136]2020-04-03 8:58:49 0 [Warning] Could not increase number of max_open_files to more than 10240 (request: 32183) # 2020-04-03T08:58:50 [109746] | [rr 70661 3250]2020-04-03 8:58:49 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-03T08:58:50 [109746] | [rr 70661 3365]2020-04-03 8:58:49 0 [Note] InnoDB: innodb_page_size=32768 # 2020-04-03T08:58:50 [109746] | [rr 70661 3369]2020-04-03 8:58:49 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2020-04-03T08:58:50 [109746] | [rr 70661 3373]2020-04-03 8:58:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2020-04-03T08:58:50 [109746] | [rr 70661 3377]2020-04-03 8:58:49 0 [Note] InnoDB: Uses event mutexes # 2020-04-03T08:58:50 [109746] | [rr 70661 3381]2020-04-03 8:58:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2020-04-03T08:58:50 [109746] | [rr 70661 3391]2020-04-03 8:58:49 0 [Note] InnoDB: Number of pools: 1 # 2020-04-03T08:58:50 [109746] | [rr 70661 3404]2020-04-03 8:58:49 0 [Note] InnoDB: Using SSE2 crc32 instructions # 2020-04-03T08:58:50 [109746] | [rr 70661 3408]2020-04-03 8:58:49 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/vardir/1585903801/208/1/tmp (disabling future attempts) # 2020-04-03T08:58:50 [109746] | [rr 70661 3441]2020-04-03 8:58:49 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 # 2020-04-03T08:58:50 [109746] | [rr 70661 3531]2020-04-03 8:58:49 0 [Note] InnoDB: Completed initialization of buffer pool # 2020-04-03T08:58:50 [109746] | [rr 70661 3588]2020-04-03 8:58:49 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-03T08:58:50 [109746] | [rr 70661 3607]2020-04-03 8:58:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=117659470 # 2020-04-03T08:58:50 [109746] | [rr 70661 6634]2020-04-03 8:58:49 0 [Note] InnoDB: Transaction 2264 was in the XA prepared state. # 2020-04-03T08:58:50 [109746] | [rr 70661 6728]2020-04-03 8:58:49 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo # 2020-04-03T08:58:50 [109746] | [rr 70661 6732]2020-04-03 8:58:49 0 [Note] InnoDB: Trx id counter is 2265 # 2020-04-03T08:58:50 [109746] | [rr 70661 6736]2020-04-03 8:58:49 0 [Note] InnoDB: Starting final batch to recover 133 pages from redo log. # 2020-04-03T08:58:50 [109746] | [rr 70661 8441]2020-04-03 8:58:50 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=68] # 2020-04-03T08:58:50 [109746] | [rr 70661 8445]2020-04-03 8:58:50 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. # 2020-04-03T08:58:50 [109746] | [rr 70661 9325]2020-04-03 8:58:50 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1574] with error Data structure corruption # 2020-04-03T08:58:50 [109746] | [rr 70661 9940]2020-04-03 8:58:50 0 [Note] InnoDB: Starting shutdown... # 2020-04-03T08:58:50 [109746] | [rr 70661 10134]2020-04-03 8:58:50 0 [ERROR] Plugin 'InnoDB' init function returned error. # 2020-04-03T08:58:50 [109746] | [rr 70661 10138]2020-04-03 8:58:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. # 2020-04-03T08:58:50 [109746] | [rr 70661 10142]2020-04-03 8:58:50 0 [Note] Plugin 'FEEDBACK' is disabled. # 2020-04-03T08:58:50 [109746] | [rr 70661 10194]2020-04-03 8:58:50 0 [Warning] /home/mleich/10.5_ori/bld_debug//sql/mysqld: unknown variable 'loose-table_lock_wait_timeout=50' # 2020-04-03T08:58:50 [109746] | [rr 70661 10201]2020-04-03 8:58:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB # 2020-04-03T08:58:50 [109746] | [rr 70661 10205]2020-04-03 8:58:50 0 [ERROR] Aborting # 2020-04-03T08:58:50 [109746] ---------------------------------- # 2020-04-03T08:58:50 [109746] Server disappeared after having started with pid 70661 # 2020-04-03T08:58:50 [109746] ERROR: Reporter 'CrashRecovery1': Status based on server start attempt is 1 # 2020-04-03T08:58:50 [109746] [rr 70661 3122]2020-04-03 8:58:49 0 [Note] /home/mleich/10.5_ori/bld_debug//sql/mysqld (mysqld 10.5.3-MariaDB-debug-log) starting as process 70661 ... # 2020-04-03T08:58:50 [109746] [rr 70661 3136]2020-04-03 8:58:49 0 [Warning] Could not increase number of max_open_files to more than 10240 (request: 32183) # 2020-04-03T08:58:50 [109746] [rr 70661 3250]2020-04-03 8:58:49 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-03T08:58:50 [109746] [rr 70661 3365]2020-04-03 8:58:49 0 [Note] InnoDB: innodb_page_size=32768 # 2020-04-03T08:58:50 [109746] [rr 70661 3369]2020-04-03 8:58:49 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2020-04-03T08:58:50 [109746] [rr 70661 3373]2020-04-03 8:58:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2020-04-03T08:58:50 [109746] [rr 70661 3377]2020-04-03 8:58:49 0 [Note] InnoDB: Uses event mutexes # 2020-04-03T08:58:50 [109746] [rr 70661 3381]2020-04-03 8:58:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2020-04-03T08:58:50 [109746] [rr 70661 3391]2020-04-03 8:58:49 0 [Note] InnoDB: Number of pools: 1 # 2020-04-03T08:58:50 [109746] [rr 70661 3404]2020-04-03 8:58:49 0 [Note] InnoDB: Using SSE2 crc32 instructions # 2020-04-03T08:58:50 [109746] [rr 70661 3408]2020-04-03 8:58:49 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/vardir/1585903801/208/1/tmp (disabling future attempts) # 2020-04-03T08:58:50 [109746] [rr 70661 3441]2020-04-03 8:58:49 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 # 2020-04-03T08:58:50 [109746] [rr 70661 3531]2020-04-03 8:58:49 0 [Note] InnoDB: Completed initialization of buffer pool # 2020-04-03T08:58:50 [109746] [rr 70661 3588]2020-04-03 8:58:49 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-03T08:58:50 [109746] [rr 70661 3607]2020-04-03 8:58:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=117659470 # 2020-04-03T08:58:50 [109746] [rr 70661 6634]2020-04-03 8:58:49 0 [Note] InnoDB: Transaction 2264 was in the XA prepared state. # 2020-04-03T08:58:50 [109746] [rr 70661 6728]2020-04-03 8:58:49 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo # 2020-04-03T08:58:50 [109746] [rr 70661 6732]2020-04-03 8:58:49 0 [Note] InnoDB: Trx id counter is 2265 # 2020-04-03T08:58:50 [109746] [rr 70661 6736]2020-04-03 8:58:49 0 [Note] InnoDB: Starting final batch to recover 133 pages from redo log. # 2020-04-03T08:58:50 [109746] [rr 70661 8441]2020-04-03 8:58:50 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=68] # 2020-04-03T08:58:50 [109746] WARN: Reporter 'CrashRecovery1': Log message '[rr 70661 8441]2020-04-03 8:58:50 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=68]' might indicate database corruption # 2020-04-03T08:58:50 [109746] [rr 70661 8445]2020-04-03 8:58:50 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. # 2020-04-03T08:58:50 [109746] WARN: Reporter 'CrashRecovery1': Log message '[rr 70661 8445]2020-04-03 8:58:50 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.' might indicate database corruption # 2020-04-03T08:58:50 [109746] [rr 70661 9325]2020-04-03 8:58:50 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1574] with error Data structure corruption # 2020-04-03T08:58:50 [109746] WARN: Reporter 'CrashRecovery1': Log message '[rr 70661 9325]2020-04-03 8:58:50 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1574] with error Data structure corruption' might indicate database corruption # 2020-04-03T08:58:50 [109746] [rr 70661 9940]2020-04-03 8:58:50 0 [Note] InnoDB: Starting shutdown... # 2020-04-03T08:58:50 [109746] [rr 70661 10134]2020-04-03 8:58:50 0 [ERROR] Plugin 'InnoDB' init function returned error. # 2020-04-03T08:58:50 [109746] [rr 70661 10138]2020-04-03 8:58:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. # 2020-04-03T08:58:50 [109746] ERROR: Reporter 'CrashRecovery1': Storage engine registration failed # 2020-04-03T08:58:50 [109746] [rr 70661 10142]2020-04-03 8:58:50 0 [Note] Plugin 'FEEDBACK' is disabled. # 2020-04-03T08:58:50 [109746] [rr 70661 10194]2020-04-03 8:58:50 0 [Warning] /home/mleich/10.5_ori/bld_debug//sql/mysqld: unknown variable 'loose-table_lock_wait_timeout=50' # 2020-04-03T08:58:50 [109746] [rr 70661 10201]2020-04-03 8:58:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB # 2020-04-03T08:58:50 [109746] [rr 70661 10205]2020-04-03 8:58:50 0 [ERROR] Aborting # 2020-04-03T08:58:50 [109746] ERROR: Reporter 'CrashRecovery1': Status based on error log checking is 106 DBI connect('host=127.0.0.1:port=28740: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 175. # 2020-04-03T08:58:50 [109746] ERROR: Reporter 'CrashRecovery1': Connect attempt to dsn dbi:mysql:host=127.0.0.1:port=28740: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-03T08:58:50 [109746] ERROR: Reporter 'CrashRecovery1': Recovery has failed. Will return status STATUS_DATABASE_CORRUPTION # 2020-04-03T08:58:50 [109746] ERROR: ReporterManager : Reporter 'CrashRecovery1' reported 106 # 2020-04-03T08:58:50 [109746] INFO: The reporters to be run at test end delivered status 106. # 2020-04-03T08:58:50 [109746] Test completed with failure status STATUS_DATABASE_CORRUPTION (106) # 2020-04-03T08:58:50 [109746] GenTest returned status STATUS_DATABASE_CORRUPTION (106) # 2020-04-03T08:58:50 [109746] INFO: RQG GenTest runtime in s : 125 # 2020-04-03T08:58:50 [109746] RESULT: The core of the RQG run ended with status STATUS_DATABASE_CORRUPTION (106) # 2020-04-03T08:58:50 [109746] DEBUG: rqg.pl: Entering stopServers with assigned status 106 # 2020-04-03T08:58:50 [109746] Stopping server(s)... # 2020-04-03T08:58:50 [109746] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [70661] is already no more running. # 2020-04-03T08:58:50 [109746] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2020-04-03T08:58:50 [109746] RESULT: The RQG run ended with status STATUS_DATABASE_CORRUPTION (106) # 2020-04-03T08:58:50 [109746] DEBUG: rqg.pl: Entering stopServers with assigned status 106 # 2020-04-03T08:58:50 [109746] Stopping server(s)... # 2020-04-03T08:58:50 [109746] DEBUG: DBServer::MySQL::MySQLd::stopServer: The server with process [70661] is already no more running. # 2020-04-03T08:58:50 [109746] DEBUG: Omitting shutdown attempt, but will clean up and return DBSTATUS_OK. # 2020-04-03T08:58:50 [109746] MATCHING: Region end ===================== # 2020-04-03T08:58:50 [109746] INFO: RQG total runtime in s : 134 # 2020-04-03T08:58:50 [109746] DEBUG: 'du -sk /dev/shm/vardir/1585903801/208 | cut -f1' exited with value 0 # 2020-04-03T08:58:50 [109746] INFO: vardir_size : 568788 # 2020-04-03T08:58:50 [109746] SUMMARY: Final command line: ->perl /home/mleich/RQG_RR/rqg.pl --duration=120 --queries=10000000 --threads=1 --no_mask --engine=InnoDB --gendata=conf/engines/many_indexes.zz --rpl_mode=none --mysqld=--innodb_page_size=32K --mysqld=--net_read_timeout=30 --mysqld=--lock-wait-timeout=86400 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--net_write_timeout=60 --mysqld=--wait_timeout=28800 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--connect_timeout=60 --mysqld=--log-bin --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--interactive_timeout=28800 --mysqld=--loose_innodb_use_native_aio=1 --mysqld=--slave_net_timeout=60 --mysqld=--innodb_stats_persistent=off --mysqld=--log-output=none --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs --reporters=CrashRecovery1,Deadlock1,ErrorLog,None,ServerDead --validators=None --grammar=/home/mleich/RQG_RR/storage/1585903801/c00000.yy --grammar=/home/mleich/RQG_RR/storage/1585903801/c00000.yy --workdir=/home/mleich/RQG_RR/storage/1585903801/208 --vardir=/dev/shm/vardir/1585903801/208 --mtr-build-thread=937 --basedir1=/home/mleich/10.5_ori/bld_debug/ --script_debug=_nix_ --rr=Server --seed=29825<- # 2020-04-03T08:58:50 [109746] SUMMARY: RQG GenData runtime in s : 4 # 2020-04-03T08:58:50 [109746] SUMMARY: RQG GenTest runtime in s : 125 # 2020-04-03T08:58:50 [109746] SUMMARY: RQG total runtime in s : 134 # 2020-04-03T08:58:50 [109746] /home/mleich/RQG_RR/rqg.pl will exit with exit status STATUS_DATABASE_CORRUPTION(106)