# 2020-06-15T15:42:38 INFO: Logfile for RQG Worker [127] # 2020-06-15T15:42:38 [54131] Using Log::Log4perl # 2020-06-15T15:42:38 [54131] DEBUG: rqg_home might be ->/home/mleich/RQG_mleich<- # 2020-06-15T15:42:38 [54131] 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-06-15T15:42:38 [54131] INFO: script_debug : '_nix_' # 2020-06-15T15:42:38 [54131] DEBUG: After reading command line options # 2020-06-15T15:42:38 [54131] INFO: The 'rr' invocation type 'Server'. # 2020-06-15T15:42:38 [54131] INFO: rr_options ->--chaos<- # 2020-06-15T15:42:38 [54131] INFO: RQG workdir : '/home/mleich/RQG_mleich/storage/1592234582/127' and infrastructure is prepared. # 2020-06-15T15:42:38 [54131] DEBUG: no_mask is defind. Therefore setting mask_level=0 , mask=0 and no_mask=undef. # 2020-06-15T15:42:38 [54131] Reading grammar from file '/home/mleich/RQG_mleich/conf/engines/many_indexes.yy'. # 2020-06-15T15:42:38 [54131] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2020-06-15T15:42:38 [54131] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2020-06-15T15:42:38 [54131] Starting # 2020-06-15T15:42:38 [54131] # /home/mleich/RQG_mleich/rqg.pl \ # 2020-06-15T15:42:38 [54131] # --gendata=conf/engines/many_indexes1.zz \ # 2020-06-15T15:42:38 [54131] # --grammar=/home/mleich/RQG_mleich/conf/engines/many_indexes.yy \ # 2020-06-15T15:42:38 [54131] # --reporters=Backtrace,Deadlock1,ErrorLog,None \ # 2020-06-15T15:42:38 [54131] # --validators=None \ # 2020-06-15T15:42:38 [54131] # --mysqld=--innodb_use_native_aio=1 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--innodb_lock_schedule_algorithm=fcfs \ # 2020-06-15T15:42:38 [54131] # --mysqld=--loose-idle_write_transaction_timeout=0 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--loose-idle_transaction_timeout=0 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--connect_timeout=60 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--interactive_timeout=28800 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--slave_net_timeout=60 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--net_read_timeout=30 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--net_write_timeout=60 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--loose-table_lock_wait_timeout=50 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--wait_timeout=28800 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--lock-wait-timeout=86400 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--innodb-lock-wait-timeout=50 \ # 2020-06-15T15:42:38 [54131] # --no-mask \ # 2020-06-15T15:42:38 [54131] # --queries=10000000 \ # 2020-06-15T15:42:38 [54131] # --duration=100 \ # 2020-06-15T15:42:38 [54131] # --seed=random \ # 2020-06-15T15:42:38 [54131] # --mysqld=--log_output=none \ # 2020-06-15T15:42:38 [54131] # --mysqld=--log-bin \ # 2020-06-15T15:42:38 [54131] # --mysqld=--log_bin_trust_function_creators=1 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--loose-max-statement-time=30 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2020-06-15T15:42:38 [54131] # --engine=InnoDB \ # 2020-06-15T15:42:38 [54131] # --restart_timeout=120 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--innodb_stats_persistent=on \ # 2020-06-15T15:42:38 [54131] # --threads=1 \ # 2020-06-15T15:42:38 [54131] # --mysqld=--innodb_page_size=4K \ # 2020-06-15T15:42:38 [54131] # --mysqld=--innodb-buffer-pool-size=5M \ # 2020-06-15T15:42:38 [54131] # --duration=300 \ # 2020-06-15T15:42:38 [54131] # --no_mask \ # 2020-06-15T15:42:38 [54131] # --workdir=/home/mleich/RQG_mleich/storage/1592234582/127 \ # 2020-06-15T15:42:38 [54131] # --vardir=/dev/shm/vardir/1592234582/127 \ # 2020-06-15T15:42:38 [54131] # --mtr-build-thread=856 \ # 2020-06-15T15:42:38 [54131] # --basedir1=/home/mleich/Server_bin/10.2_debug/ \ # 2020-06-15T15:42:38 [54131] # --basedir2=/home/mleich/Server_bin/10.2_debug/ \ # 2020-06-15T15:42:38 [54131] # --script_debug=_nix_ \ # 2020-06-15T15:42:38 [54131] # --rr=Server \ # 2020-06-15T15:42:38 [54131] # --rr_options=--chaos # 2020-06-15T15:42:38 [54131] INFO: build_thread : 856 # 2020-06-15T15:42:38 [54131] INFO: master_port : 27120 slave_port : 27121 ports : 27120 27121 27122 MTR_BUILD_THREAD : 856 # 2020-06-15T15:42:38 [54131] INFO: rpl_mode was not defined or eq '' and therefore set to 'none'. # 2020-06-15T15:42:38 [54131] INFO: Number of servers involved = 1. (0 means unknown) # 2020-06-15T15:42:38 [54131] INFO: Early RQG basedirs : ->undef<-->/home/mleich/Server_bin/10.2_debug/<-->/home/mleich/Server_bin/10.2_debug/<-->undef<- # 2020-06-15T15:42:38 [54131] DEBUG: $basedirs[0] is not defined or eq ''. Setting it to $basedirs[1] '/home/mleich/Server_bin/10.2_debug/'. # 2020-06-15T15:42:38 [54131] WARN: $basedirs[2] is defined and ne ''. Setting it to undef. # 2020-06-15T15:42:38 [54131] INFO: Final RQG basedirs : ->/home/mleich/Server_bin/10.2_debug/<-->/home/mleich/Server_bin/10.2_debug/<-->undef<-->undef<- # 2020-06-15T15:42:38 [54131] INFO: RQG_HOME '/home/mleich/RQG_mleich' ---------- # 2020-06-15T15:42:38 [54131] DEBUG: 'git --version 2>&1' exited with value 0 # 2020-06-15T15:42:38 [54131] INFO: GIT on $rqg_home('/home/mleich/RQG_mleich') HEAD -> experimental, origin/experimental 611a31e38a3bc157392c0748c95991b6a248bb3b 2020-06-09T15:31:46+02:00 # 2020-06-15T15:42:38 [54131] INFO: basedir[0] : /home/mleich/Server_bin/10.2_debug/ ---- # 2020-06-15T15:42:38 [54131] INFO: GIT on basedirs[0]('/home/mleich/Server_bin/10.2_debug/') fatal: not a git repository (or any of the parent directories): .git # 2020-06-15T15:42:38 [54131] INFO: Protocol of build '/home/mleich/Server_bin/10.2_debug//build.prt' detected. Extracting some data ... # 2020-06-15T15:42:38 [54131] GIT_SHOW: HEAD, origin/10.2 7710f28eecc3e9761d7431ae7ae4e88564d706dd 2020-06-15T09:29:17+03:00 # 2020-06-15T15:42:38 [54131] MD5SUM of bin_arch.tgz: e21f6b0a6f1935756f44aeaf9dd3077e # 2020-06-15T15:42:38 [54131] INFO: basedir[1] : /home/mleich/Server_bin/10.2_debug/ ---- # 2020-06-15T15:42:38 [54131] INFO: GIT on basedirs[1]('/home/mleich/Server_bin/10.2_debug/') fatal: not a git repository (or any of the parent directories): .git # 2020-06-15T15:42:38 [54131] INFO: Protocol of build '/home/mleich/Server_bin/10.2_debug//build.prt' detected. Extracting some data ... # 2020-06-15T15:42:38 [54131] GIT_SHOW: HEAD, origin/10.2 7710f28eecc3e9761d7431ae7ae4e88564d706dd 2020-06-15T09:29:17+03:00 # 2020-06-15T15:42:38 [54131] MD5SUM of bin_arch.tgz: e21f6b0a6f1935756f44aeaf9dd3077e # 2020-06-15T15:42:38 [54131] INFO: basedir[2] : ------------------------------ # 2020-06-15T15:42:38 [54131] INFO: Final RQG vardirs : ->/dev/shm/vardir/1592234582/127<-->/dev/shm/vardir/1592234582/127/1<- # 2020-06-15T15:42:38 [54131] tmpdir in GenTest ->/dev/shm/vardir/1592234582/127/<- # 2020-06-15T15:42:38 [54131] tmpdir in DBServer ->/dev/shm/vardir/1592234582/127/<- # 2020-06-15T15:42:38 [54131] INFO: Environment variable _RR_TRACE_DIR set to '/dev/shm/vardir/1592234582/127/rr_trace'. # 2020-06-15T15:42:38 [54131] DEBUG: subdir_list : ->sql<-->libexec<-->bin<-->sbin<- # 2020-06-15T15:42:38 [54131] DEBUG: Basedirs : ->/home/mleich/Server_bin/10.2_debug/<-->/home/mleich/Server_bin/10.2_debug/<-->undef<-->undef<- # 2020-06-15T15:42:38 [54131] DEBUG: debug_server : ->undef<-->undef<-->undef<- # 2020-06-15T15:42:38 [54131] DEBUG: Server binary found : '/home/mleich/Server_bin/10.2_debug//bin/mysqld'. # 2020-06-15T15:42:38 [54131] DEBUG: Server binary found : '/home/mleich/Server_bin/10.2_debug//bin/mysqld'. # 2020-06-15T15:42:38 [54131] INFO: seed eq 'random'. Computation. seed : 9249 # 2020-06-15T15:42:38 [54131] INFO: Final command line: ->perl /home/mleich/RQG_mleich/rqg.pl --gendata=conf/engines/many_indexes1.zz --grammar=/home/mleich/RQG_mleich/conf/engines/many_indexes.yy --reporters=Backtrace,Deadlock1,ErrorLog,None --validators=None --mysqld=--innodb_use_native_aio=1 --mysqld=--innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--connect_timeout=60 --mysqld=--interactive_timeout=28800 --mysqld=--slave_net_timeout=60 --mysqld=--net_read_timeout=30 --mysqld=--net_write_timeout=60 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--wait_timeout=28800 --mysqld=--lock-wait-timeout=86400 --mysqld=--innodb-lock-wait-timeout=50 --no-mask --queries=10000000 --duration=100 --mysqld=--log_output=none --mysqld=--log-bin --mysqld=--log_bin_trust_function_creators=1 --mysqld=--loose-max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --engine=InnoDB --restart_timeout=120 --mysqld=--innodb_stats_persistent=on --threads=1 --mysqld=--innodb_page_size=4K --mysqld=--innodb-buffer-pool-size=5M --duration=300 --no_mask --workdir=/home/mleich/RQG_mleich/storage/1592234582/127 --vardir=/dev/shm/vardir/1592234582/127 --mtr-build-thread=856 --basedir1=/home/mleich/Server_bin/10.2_debug/ --basedir2=/home/mleich/Server_bin/10.2_debug/ --script_debug=_nix_ --rr=Server --rr_options=--chaos --seed=9249<- # 2020-06-15T15:42:38 [54131] MATCHING: Region start ===================== # 2020-06-15T15:42:38 [54131] DEBUG: rpl_mode is 'none' # 2020-06-15T15:42:38 [54131] DEBUG: max_id is 0 # 2020-06-15T15:42:39 [54131] Creating MySQL 10.2.33 database at /dev/shm/vardir/1592234582/127/1/data # 2020-06-15T15:42:39 [54131] Bootstrap command: cat "/dev/shm/vardir/1592234582/127/1/boot.sql" | "/home/mleich/Server_bin/10.2_debug//bin/mysqld" "--no-defaults" "--basedir=/home/mleich/Server_bin/10.2_debug/" "--lc-messages-dir=/home/mleich/Server_bin/10.2_debug//share" "--character-sets-dir=/home/mleich/Server_bin/10.2_debug//share/charsets" "--tmpdir=/dev/shm/vardir/1592234582/127/1/tmp" "--datadir=/dev/shm/vardir/1592234582/127/1/data" "--innodb_use_native_aio=1" "--innodb_lock_schedule_algorithm=fcfs" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--loose-idle_readonly_transaction_timeout=0" "--connect_timeout=60" "--interactive_timeout=28800" "--slave_net_timeout=60" "--net_read_timeout=30" "--net_write_timeout=60" "--loose-table_lock_wait_timeout=50" "--wait_timeout=28800" "--lock-wait-timeout=86400" "--innodb-lock-wait-timeout=50" "--log_output=none" "--log-bin" "--log_bin_trust_function_creators=1" "--loose-max-statement-time=30" "--loose-debug_assert_on_not_freed_memory=0" "--innodb_stats_persistent=on" "--innodb_page_size=4K" "--innodb-buffer-pool-size=5M" "--sql-mode=no_engine_substitution" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" # 2020-06-15T15:42:41 [54131] INFO: Starting MySQL 10.2.33: ulimit -c 0; rr record --mark-stdio "--chaos" "/home/mleich/Server_bin/10.2_debug//bin/mysqld" "--no-defaults" "--basedir=/home/mleich/Server_bin/10.2_debug/" "--lc-messages-dir=/home/mleich/Server_bin/10.2_debug//share" "--character-sets-dir=/home/mleich/Server_bin/10.2_debug//share/charsets" "--tmpdir=/dev/shm/vardir/1592234582/127/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1592234582/127/1/data" "--max-allowed-packet=128Mb" "--port=27120" "--socket=/dev/shm/vardir/1592234582/127/1/mysql.sock" "--pid-file=/dev/shm/vardir/1592234582/127/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1592234582/127/1/mysql.log" "--innodb_use_native_aio=1" "--innodb_lock_schedule_algorithm=fcfs" "--loose-idle_write_transaction_timeout=0" "--loose-idle_transaction_timeout=0" "--loose-idle_readonly_transaction_timeout=0" "--connect_timeout=60" "--interactive_timeout=28800" "--slave_net_timeout=60" "--net_read_timeout=30" "--net_write_timeout=60" "--loose-table_lock_wait_timeout=50" "--wait_timeout=28800" "--lock-wait-timeout=86400" "--innodb-lock-wait-timeout=50" "--log_output=none" "--log-bin" "--log_bin_trust_function_creators=1" "--loose-max-statement-time=30" "--loose-debug_assert_on_not_freed_memory=0" "--innodb_stats_persistent=on" "--innodb_page_size=4K" "--innodb-buffer-pool-size=5M" "--sql-mode=no_engine_substitution" --log_warnings=4 # 2020-06-15T15:42:42 [54131] DEBUG: Server pid found in error log: 54799 # 2020-06-15T15:42:43 [54131] MySQL Version: 10.2.33 # 2020-06-15T15:42:43 [54131] Binary: /home/mleich/Server_bin/10.2_debug//bin/mysqld # 2020-06-15T15:42:43 [54131] Type: Debug # 2020-06-15T15:42:43 [54131] Datadir: /dev/shm/vardir/1592234582/127/1/data # 2020-06-15T15:42:43 [54131] Tmpdir: /dev/shm/vardir/1592234582/127/1/tmp # 2020-06-15T15:42:43 [54131] Corefile: /dev/shm/vardir/1592234582/127/1/data/core.54799 # 2020-06-15T15:42:43 [54131] Connecting to 27120 # 2020-06-15T15:42:43 [54131] SVAR: aria_block_size : 8192 # 2020-06-15T15:42:43 [54131] SVAR: aria_checkpoint_interval : 30 # 2020-06-15T15:42:43 [54131] SVAR: aria_checkpoint_log_activity : 1048576 # 2020-06-15T15:42:43 [54131] SVAR: aria_encrypt_tables : OFF # 2020-06-15T15:42:43 [54131] SVAR: aria_force_start_after_recovery_failures : 0 # 2020-06-15T15:42:43 [54131] SVAR: aria_group_commit : none # 2020-06-15T15:42:43 [54131] SVAR: aria_group_commit_interval : 0 # 2020-06-15T15:42:43 [54131] SVAR: aria_log_file_size : 1073741824 # 2020-06-15T15:42:43 [54131] SVAR: aria_log_purge_type : immediate # 2020-06-15T15:42:43 [54131] SVAR: aria_max_sort_file_size : 9223372036853727232 # 2020-06-15T15:42:43 [54131] SVAR: aria_page_checksum : ON # 2020-06-15T15:42:43 [54131] SVAR: aria_pagecache_age_threshold : 300 # 2020-06-15T15:42:43 [54131] SVAR: aria_pagecache_buffer_size : 134217728 # 2020-06-15T15:42:43 [54131] SVAR: aria_pagecache_division_limit : 100 # 2020-06-15T15:42:43 [54131] SVAR: aria_pagecache_file_hash_size : 512 # 2020-06-15T15:42:43 [54131] SVAR: aria_recover_options : BACKUP,QUICK # 2020-06-15T15:42:43 [54131] SVAR: aria_repair_threads : 1 # 2020-06-15T15:42:43 [54131] SVAR: aria_sort_buffer_size : 268434432 # 2020-06-15T15:42:43 [54131] SVAR: aria_stats_method : nulls_unequal # 2020-06-15T15:42:43 [54131] SVAR: aria_sync_log_dir : NEWFILE # 2020-06-15T15:42:43 [54131] SVAR: aria_used_for_temp_tables : ON # 2020-06-15T15:42:43 [54131] SVAR: auto_increment_increment : 1 # 2020-06-15T15:42:43 [54131] SVAR: auto_increment_offset : 1 # 2020-06-15T15:42:43 [54131] SVAR: autocommit : ON # 2020-06-15T15:42:43 [54131] SVAR: automatic_sp_privileges : ON # 2020-06-15T15:42:43 [54131] SVAR: back_log : 80 # 2020-06-15T15:42:43 [54131] SVAR: basedir : /home/mleich/Server_bin/10.2_debug/ # 2020-06-15T15:42:43 [54131] SVAR: big_tables : OFF # 2020-06-15T15:42:43 [54131] SVAR: binlog_annotate_row_events : ON # 2020-06-15T15:42:43 [54131] SVAR: binlog_cache_size : 32768 # 2020-06-15T15:42:43 [54131] SVAR: binlog_checksum : CRC32 # 2020-06-15T15:42:43 [54131] SVAR: binlog_commit_wait_count : 0 # 2020-06-15T15:42:43 [54131] SVAR: binlog_commit_wait_usec : 100000 # 2020-06-15T15:42:43 [54131] SVAR: binlog_direct_non_transactional_updates : OFF # 2020-06-15T15:42:43 [54131] SVAR: binlog_format : MIXED # 2020-06-15T15:42:43 [54131] SVAR: binlog_optimize_thread_scheduling : ON # 2020-06-15T15:42:43 [54131] SVAR: binlog_row_image : FULL # 2020-06-15T15:42:43 [54131] SVAR: binlog_stmt_cache_size : 32768 # 2020-06-15T15:42:43 [54131] SVAR: bulk_insert_buffer_size : 8388608 # 2020-06-15T15:42:43 [54131] SVAR: character_set_client : latin1 # 2020-06-15T15:42:43 [54131] SVAR: character_set_connection : latin1 # 2020-06-15T15:42:43 [54131] SVAR: character_set_database : latin1 # 2020-06-15T15:42:43 [54131] SVAR: character_set_filesystem : binary # 2020-06-15T15:42:43 [54131] SVAR: character_set_results : latin1 # 2020-06-15T15:42:43 [54131] SVAR: character_set_server : latin1 # 2020-06-15T15:42:43 [54131] SVAR: character_set_system : utf8 # 2020-06-15T15:42:43 [54131] SVAR: character_sets_dir : /home/mleich/Server_bin/10.2_debug//share/charsets/ # 2020-06-15T15:42:43 [54131] SVAR: check_constraint_checks : ON # 2020-06-15T15:42:43 [54131] SVAR: collation_connection : latin1_swedish_ci # 2020-06-15T15:42:43 [54131] SVAR: collation_database : latin1_swedish_ci # 2020-06-15T15:42:43 [54131] SVAR: collation_server : latin1_swedish_ci # 2020-06-15T15:42:43 [54131] SVAR: completion_type : NO_CHAIN # 2020-06-15T15:42:43 [54131] SVAR: concurrent_insert : AUTO # 2020-06-15T15:42:43 [54131] SVAR: connect_timeout : 60 # 2020-06-15T15:42:43 [54131] SVAR: core_file : ON # 2020-06-15T15:42:43 [54131] SVAR: datadir : /dev/shm/vardir/1592234582/127/1/data/ # 2020-06-15T15:42:43 [54131] SVAR: date_format : %Y-%m-%d # 2020-06-15T15:42:43 [54131] SVAR: datetime_format : %Y-%m-%d %H:%i:%s # 2020-06-15T15:42:43 [54131] SVAR: deadlock_search_depth_long : 15 # 2020-06-15T15:42:43 [54131] SVAR: deadlock_search_depth_short : 4 # 2020-06-15T15:42:43 [54131] SVAR: deadlock_timeout_long : 50000000 # 2020-06-15T15:42:43 [54131] SVAR: deadlock_timeout_short : 10000 # 2020-06-15T15:42:43 [54131] SVAR: debug : # 2020-06-15T15:42:43 [54131] SVAR: debug_binlog_fsync_sleep : 0 # 2020-06-15T15:42:43 [54131] SVAR: debug_dbug : # 2020-06-15T15:42:43 [54131] SVAR: debug_mutex_deadlock_detector : ON # 2020-06-15T15:42:43 [54131] SVAR: debug_no_thread_alarm : OFF # 2020-06-15T15:42:43 [54131] SVAR: debug_sync : OFF # 2020-06-15T15:42:43 [54131] SVAR: default_master_connection : # 2020-06-15T15:42:43 [54131] SVAR: default_regex_flags : # 2020-06-15T15:42:43 [54131] SVAR: default_storage_engine : InnoDB # 2020-06-15T15:42:43 [54131] SVAR: default_tmp_storage_engine : # 2020-06-15T15:42:43 [54131] SVAR: default_week_format : 0 # 2020-06-15T15:42:43 [54131] SVAR: delay_key_write : ON # 2020-06-15T15:42:43 [54131] SVAR: delayed_insert_limit : 100 # 2020-06-15T15:42:43 [54131] SVAR: delayed_insert_timeout : 300 # 2020-06-15T15:42:43 [54131] SVAR: delayed_queue_size : 1000 # 2020-06-15T15:42:43 [54131] SVAR: div_precision_increment : 4 # 2020-06-15T15:42:43 [54131] SVAR: encrypt_binlog : OFF # 2020-06-15T15:42:43 [54131] SVAR: encrypt_tmp_disk_tables : OFF # 2020-06-15T15:42:43 [54131] SVAR: encrypt_tmp_files : OFF # 2020-06-15T15:42:43 [54131] SVAR: enforce_storage_engine : # 2020-06-15T15:42:43 [54131] SVAR: eq_range_index_dive_limit : 0 # 2020-06-15T15:42:43 [54131] SVAR: error_count : 0 # 2020-06-15T15:42:43 [54131] SVAR: event_scheduler : OFF # 2020-06-15T15:42:43 [54131] SVAR: expensive_subquery_limit : 100 # 2020-06-15T15:42:43 [54131] SVAR: expire_logs_days : 0 # 2020-06-15T15:42:43 [54131] SVAR: explicit_defaults_for_timestamp : OFF # 2020-06-15T15:42:43 [54131] SVAR: external_user : # 2020-06-15T15:42:43 [54131] SVAR: extra_max_connections : 1 # 2020-06-15T15:42:43 [54131] SVAR: extra_port : 0 # 2020-06-15T15:42:43 [54131] SVAR: flush : OFF # 2020-06-15T15:42:43 [54131] SVAR: flush_time : 0 # 2020-06-15T15:42:43 [54131] SVAR: foreign_key_checks : ON # 2020-06-15T15:42:43 [54131] SVAR: ft_boolean_syntax : + -><()~*:""&| # 2020-06-15T15:42:43 [54131] SVAR: ft_max_word_len : 84 # 2020-06-15T15:42:43 [54131] SVAR: ft_min_word_len : 4 # 2020-06-15T15:42:43 [54131] SVAR: ft_query_expansion_limit : 20 # 2020-06-15T15:42:43 [54131] SVAR: ft_stopword_file : (built-in) # 2020-06-15T15:42:43 [54131] SVAR: general_log : ON # 2020-06-15T15:42:43 [54131] SVAR: general_log_file : /dev/shm/vardir/1592234582/127/1/mysql.log # 2020-06-15T15:42:43 [54131] SVAR: group_concat_max_len : 1048576 # 2020-06-15T15:42:43 [54131] SVAR: gtid_binlog_pos : # 2020-06-15T15:42:43 [54131] SVAR: gtid_binlog_state : # 2020-06-15T15:42:43 [54131] SVAR: gtid_current_pos : # 2020-06-15T15:42:43 [54131] SVAR: gtid_domain_id : 0 # 2020-06-15T15:42:43 [54131] SVAR: gtid_ignore_duplicates : OFF # 2020-06-15T15:42:43 [54131] SVAR: gtid_seq_no : 0 # 2020-06-15T15:42:43 [54131] SVAR: gtid_slave_pos : # 2020-06-15T15:42:43 [54131] SVAR: gtid_strict_mode : OFF # 2020-06-15T15:42:43 [54131] SVAR: have_compress : YES # 2020-06-15T15:42:43 [54131] SVAR: have_crypt : YES # 2020-06-15T15:42:43 [54131] SVAR: have_dynamic_loading : YES # 2020-06-15T15:42:43 [54131] SVAR: have_geometry : YES # 2020-06-15T15:42:43 [54131] SVAR: have_openssl : NO # 2020-06-15T15:42:43 [54131] SVAR: have_profiling : YES # 2020-06-15T15:42:43 [54131] SVAR: have_query_cache : YES # 2020-06-15T15:42:43 [54131] SVAR: have_rtree_keys : YES # 2020-06-15T15:42:43 [54131] SVAR: have_ssl : DISABLED # 2020-06-15T15:42:43 [54131] SVAR: have_symlink : YES # 2020-06-15T15:42:43 [54131] SVAR: histogram_size : 0 # 2020-06-15T15:42:43 [54131] SVAR: histogram_type : SINGLE_PREC_HB # 2020-06-15T15:42:43 [54131] SVAR: host_cache_size : 279 # 2020-06-15T15:42:43 [54131] SVAR: hostname : sdp # 2020-06-15T15:42:43 [54131] SVAR: identity : 0 # 2020-06-15T15:42:43 [54131] SVAR: ignore_builtin_innodb : OFF # 2020-06-15T15:42:43 [54131] SVAR: ignore_db_dirs : # 2020-06-15T15:42:43 [54131] SVAR: in_transaction : 0 # 2020-06-15T15:42:43 [54131] SVAR: init_connect : # 2020-06-15T15:42:43 [54131] SVAR: init_file : # 2020-06-15T15:42:43 [54131] SVAR: init_slave : # 2020-06-15T15:42:43 [54131] SVAR: innodb_adaptive_flushing : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_adaptive_flushing_lwm : 10.000000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_adaptive_hash_index : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_adaptive_hash_index_partitions : 8 # 2020-06-15T15:42:43 [54131] SVAR: innodb_adaptive_hash_index_parts : 8 # 2020-06-15T15:42:43 [54131] SVAR: innodb_adaptive_max_sleep_delay : 150000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_autoextend_increment : 64 # 2020-06-15T15:42:43 [54131] SVAR: innodb_autoinc_lock_mode : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_background_drop_list_empty : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_background_scrub_data_check_interval : 3600 # 2020-06-15T15:42:43 [54131] SVAR: innodb_background_scrub_data_compressed : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_background_scrub_data_interval : 604800 # 2020-06-15T15:42:43 [54131] SVAR: innodb_background_scrub_data_uncompressed : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_buf_dump_status_frequency : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_buf_flush_list_now : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_chunk_size : 5242880 # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_dump_at_shutdown : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_dump_now : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_dump_pct : 25 # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_evict : # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_filename : ib_buffer_pool # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_instances : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_load_abort : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_load_at_startup : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_load_now : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_populate : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_buffer_pool_size : 5242880 # 2020-06-15T15:42:43 [54131] SVAR: innodb_change_buffer_dump : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_change_buffer_max_size : 25 # 2020-06-15T15:42:43 [54131] SVAR: innodb_change_buffering : all # 2020-06-15T15:42:43 [54131] SVAR: innodb_change_buffering_debug : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_checksum_algorithm : crc32 # 2020-06-15T15:42:43 [54131] SVAR: innodb_checksums : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_eviction_factor : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_flush_chunk_size : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_free_list_lwm : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_lru_chunk_size : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_lsn_age_factor : DEPRECATED # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_max_flush_time : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_cleaner_max_lru_time : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_cmp_per_index_enabled : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_commit_concurrency : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_compression_algorithm : zlib # 2020-06-15T15:42:43 [54131] SVAR: innodb_compression_default : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_compression_failure_threshold_pct : 5 # 2020-06-15T15:42:43 [54131] SVAR: innodb_compression_level : 6 # 2020-06-15T15:42:43 [54131] SVAR: innodb_compression_pad_pct_max : 50 # 2020-06-15T15:42:43 [54131] SVAR: innodb_concurrency_tickets : 5000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_corrupt_table_action : deprecated # 2020-06-15T15:42:43 [54131] SVAR: innodb_data_file_path : ibdata1:12M:autoextend # 2020-06-15T15:42:43 [54131] SVAR: innodb_data_file_size_debug : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_data_home_dir : # 2020-06-15T15:42:43 [54131] SVAR: innodb_deadlock_detect : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_debug_force_scrubbing : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_default_encryption_key_id : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_default_row_format : dynamic # 2020-06-15T15:42:43 [54131] SVAR: innodb_defragment : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_defragment_fill_factor : 0.900000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_defragment_fill_factor_n_recs : 20 # 2020-06-15T15:42:43 [54131] SVAR: innodb_defragment_frequency : 40 # 2020-06-15T15:42:43 [54131] SVAR: innodb_defragment_n_pages : 7 # 2020-06-15T15:42:43 [54131] SVAR: innodb_defragment_stats_accuracy : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_dict_stats_disabled_debug : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_disable_background_merge : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_disable_resize_buffer_pool_debug : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_disable_sort_file_cache : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_disallow_writes : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_doublewrite : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_doublewrite_batch_size : 120 # 2020-06-15T15:42:43 [54131] SVAR: innodb_empty_free_list_algorithm : DEPRECATED # 2020-06-15T15:42:43 [54131] SVAR: innodb_encrypt_log : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_encrypt_tables : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_encrypt_temporary_tables : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_encryption_rotate_key_age : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_encryption_rotation_iops : 100 # 2020-06-15T15:42:43 [54131] SVAR: innodb_encryption_threads : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_fake_changes : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_fast_shutdown : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_fatal_semaphore_wait_threshold : 600 # 2020-06-15T15:42:43 [54131] SVAR: innodb_fil_make_page_dirty_debug : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_file_format : Barracuda # 2020-06-15T15:42:43 [54131] SVAR: innodb_file_format_check : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_file_format_max : Barracuda # 2020-06-15T15:42:43 [54131] SVAR: innodb_file_per_table : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_fill_factor : 100 # 2020-06-15T15:42:43 [54131] SVAR: innodb_flush_log_at_timeout : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_flush_log_at_trx_commit : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_flush_method : # 2020-06-15T15:42:43 [54131] SVAR: innodb_flush_neighbors : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_flush_sync : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_flushing_avg_loops : 30 # 2020-06-15T15:42:43 [54131] SVAR: innodb_force_load_corrupted : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_force_primary_key : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_force_recovery : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_foreground_preflush : DEPRECATED # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_aux_table : # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_cache_size : 8000000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_enable_diag_print : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_enable_stopword : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_max_token_size : 84 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_min_token_size : 3 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_num_word_optimize : 2000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_result_cache_limit : 2000000000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_server_stopword_table : # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_sort_pll_degree : 2 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_total_cache_size : 640000000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_ft_user_stopword_table : # 2020-06-15T15:42:43 [54131] SVAR: innodb_idle_flush_pct : 100 # 2020-06-15T15:42:43 [54131] SVAR: innodb_immediate_scrub_data_uncompressed : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_instrument_semaphores : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_io_capacity : 200 # 2020-06-15T15:42:43 [54131] SVAR: innodb_io_capacity_max : 2000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_kill_idle_transaction : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_large_prefix : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_limit_optimistic_insert_debug : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_lock_schedule_algorithm : fcfs # 2020-06-15T15:42:43 [54131] SVAR: innodb_lock_wait_timeout : 50 # 2020-06-15T15:42:43 [54131] SVAR: innodb_locking_fake_changes : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_locks_unsafe_for_binlog : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_arch_dir : # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_arch_expire_sec : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_archive : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_block_size : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_buffer_size : 16777216 # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_checkpoint_now : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_checksum_algorithm : DEPRECATED # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_checksums : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_compressed_pages : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_file_size : 50331648 # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_files_in_group : 2 # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_group_home_dir : ./ # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_optimize_ddl : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_log_write_ahead_size : 4096 # 2020-06-15T15:42:43 [54131] SVAR: innodb_lru_scan_depth : 1024 # 2020-06-15T15:42:43 [54131] SVAR: innodb_master_thread_disabled_debug : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_bitmap_file_size : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_changed_pages : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_dirty_pages_pct : 75.000000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_dirty_pages_pct_lwm : 0.000000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_purge_lag : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_purge_lag_delay : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_max_undo_log_size : 10485760 # 2020-06-15T15:42:43 [54131] SVAR: innodb_merge_threshold_set_all_debug : 50 # 2020-06-15T15:42:43 [54131] SVAR: innodb_mirrored_log_groups : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_monitor_disable : # 2020-06-15T15:42:43 [54131] SVAR: innodb_monitor_enable : # 2020-06-15T15:42:43 [54131] SVAR: innodb_monitor_reset : # 2020-06-15T15:42:43 [54131] SVAR: innodb_monitor_reset_all : # 2020-06-15T15:42:43 [54131] SVAR: innodb_mtflush_threads : 8 # 2020-06-15T15:42:43 [54131] SVAR: innodb_old_blocks_pct : 37 # 2020-06-15T15:42:43 [54131] SVAR: innodb_old_blocks_time : 1000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_online_alter_log_max_size : 134217728 # 2020-06-15T15:42:43 [54131] SVAR: innodb_open_files : 2000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_optimize_fulltext_only : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_page_cleaner_disabled_debug : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_page_cleaners : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_page_hash_locks : 16 # 2020-06-15T15:42:43 [54131] SVAR: innodb_page_size : 4096 # 2020-06-15T15:42:43 [54131] SVAR: innodb_prefix_index_cluster_optimization : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_print_all_deadlocks : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_priority_cleaner : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_priority_io : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_priority_master : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_priority_purge : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_purge_batch_size : 300 # 2020-06-15T15:42:43 [54131] SVAR: innodb_purge_rseg_truncate_frequency : 128 # 2020-06-15T15:42:43 [54131] SVAR: innodb_purge_threads : 4 # 2020-06-15T15:42:43 [54131] SVAR: innodb_random_read_ahead : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_read_ahead_threshold : 56 # 2020-06-15T15:42:43 [54131] SVAR: innodb_read_io_threads : 4 # 2020-06-15T15:42:43 [54131] SVAR: innodb_read_only : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_replication_delay : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_rollback_on_timeout : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_rollback_segments : 128 # 2020-06-15T15:42:43 [54131] SVAR: innodb_safe_truncate : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_saved_page_number_debug : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_sched_priority_cleaner : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_sched_priority_io : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_sched_priority_master : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_sched_priority_purge : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_scrub_log : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_scrub_log_speed : 256 # 2020-06-15T15:42:43 [54131] SVAR: innodb_show_locks_held : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_show_verbose_locks : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_simulate_comp_failures : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_sort_buffer_size : 1048576 # 2020-06-15T15:42:43 [54131] SVAR: innodb_spin_wait_delay : 4 # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_auto_recalc : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_include_delete_marked : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_method : nulls_equal # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_modified_counter : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_on_metadata : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_persistent : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_persistent_sample_pages : 20 # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_sample_pages : 8 # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_traditional : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_stats_transient_sample_pages : 8 # 2020-06-15T15:42:43 [54131] SVAR: innodb_status_output : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_status_output_locks : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_strict_mode : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_support_xa : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_sync_array_size : 1 # 2020-06-15T15:42:43 [54131] SVAR: innodb_sync_debug : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_sync_spin_loops : 30 # 2020-06-15T15:42:43 [54131] SVAR: innodb_table_locks : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_temp_data_file_path : ibtmp1:12M:autoextend # 2020-06-15T15:42:43 [54131] SVAR: innodb_thread_concurrency : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_thread_sleep_delay : 10000 # 2020-06-15T15:42:43 [54131] SVAR: innodb_tmpdir : # 2020-06-15T15:42:43 [54131] SVAR: innodb_track_changed_pages : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_track_redo_log_now : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_trx_purge_view_update_only_debug : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_trx_rseg_n_slots_debug : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_undo_directory : ./ # 2020-06-15T15:42:43 [54131] SVAR: innodb_undo_log_truncate : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_undo_logs : 128 # 2020-06-15T15:42:43 [54131] SVAR: innodb_undo_tablespaces : 0 # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_atomic_writes : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_fallocate : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_global_flush_log_at_trx_commit : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_mtflush : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_native_aio : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_stacktrace : OFF # 2020-06-15T15:42:43 [54131] SVAR: innodb_use_trim : ON # 2020-06-15T15:42:43 [54131] SVAR: innodb_version : 5.7.30 # 2020-06-15T15:42:43 [54131] SVAR: innodb_write_io_threads : 4 # 2020-06-15T15:42:43 [54131] SVAR: insert_id : 0 # 2020-06-15T15:42:43 [54131] SVAR: interactive_timeout : 28800 # 2020-06-15T15:42:43 [54131] SVAR: join_buffer_size : 262144 # 2020-06-15T15:42:43 [54131] SVAR: join_buffer_space_limit : 2097152 # 2020-06-15T15:42:43 [54131] SVAR: join_cache_level : 2 # 2020-06-15T15:42:43 [54131] SVAR: keep_files_on_create : OFF # 2020-06-15T15:42:43 [54131] SVAR: key_buffer_size : 134217728 # 2020-06-15T15:42:43 [54131] SVAR: key_cache_age_threshold : 300 # 2020-06-15T15:42:43 [54131] SVAR: key_cache_block_size : 1024 # 2020-06-15T15:42:43 [54131] SVAR: key_cache_division_limit : 100 # 2020-06-15T15:42:43 [54131] SVAR: key_cache_file_hash_size : 512 # 2020-06-15T15:42:43 [54131] SVAR: key_cache_segments : 0 # 2020-06-15T15:42:43 [54131] SVAR: large_files_support : ON # 2020-06-15T15:42:43 [54131] SVAR: large_page_size : 0 # 2020-06-15T15:42:43 [54131] SVAR: large_pages : OFF # 2020-06-15T15:42:43 [54131] SVAR: last_gtid : # 2020-06-15T15:42:43 [54131] SVAR: last_insert_id : 0 # 2020-06-15T15:42:43 [54131] SVAR: lc_messages : en_US # 2020-06-15T15:42:43 [54131] SVAR: lc_messages_dir : /home/mleich/Server_bin/10.2_debug//share # 2020-06-15T15:42:43 [54131] SVAR: lc_time_names : en_US # 2020-06-15T15:42:43 [54131] SVAR: license : GPL # 2020-06-15T15:42:43 [54131] SVAR: local_infile : ON # 2020-06-15T15:42:43 [54131] SVAR: lock_wait_timeout : 86400 # 2020-06-15T15:42:43 [54131] SVAR: locked_in_memory : OFF # 2020-06-15T15:42:43 [54131] SVAR: log_bin : ON # 2020-06-15T15:42:43 [54131] SVAR: log_bin_basename : /dev/shm/vardir/1592234582/127/1/data/mysql-bin # 2020-06-15T15:42:43 [54131] SVAR: log_bin_compress : OFF # 2020-06-15T15:42:43 [54131] SVAR: log_bin_compress_min_len : 256 # 2020-06-15T15:42:43 [54131] SVAR: log_bin_index : /dev/shm/vardir/1592234582/127/1/data/mysql-bin.index # 2020-06-15T15:42:43 [54131] SVAR: log_bin_trust_function_creators : ON # 2020-06-15T15:42:43 [54131] SVAR: log_error : # 2020-06-15T15:42:43 [54131] SVAR: log_output : NONE # 2020-06-15T15:42:43 [54131] SVAR: log_queries_not_using_indexes : OFF # 2020-06-15T15:42:43 [54131] SVAR: log_slave_updates : OFF # 2020-06-15T15:42:43 [54131] SVAR: log_slow_admin_statements : ON # 2020-06-15T15:42:43 [54131] SVAR: log_slow_filter : admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk # 2020-06-15T15:42:43 [54131] SVAR: log_slow_rate_limit : 1 # 2020-06-15T15:42:43 [54131] SVAR: log_slow_slave_statements : ON # 2020-06-15T15:42:43 [54131] SVAR: log_slow_verbosity : # 2020-06-15T15:42:43 [54131] SVAR: log_tc_size : 24576 # 2020-06-15T15:42:43 [54131] SVAR: log_warnings : 4 # 2020-06-15T15:42:43 [54131] SVAR: long_query_time : 10.000000 # 2020-06-15T15:42:43 [54131] SVAR: low_priority_updates : OFF # 2020-06-15T15:42:43 [54131] SVAR: lower_case_file_system : OFF # 2020-06-15T15:42:43 [54131] SVAR: lower_case_table_names : 0 # 2020-06-15T15:42:43 [54131] SVAR: master_verify_checksum : OFF # 2020-06-15T15:42:43 [54131] SVAR: max_allowed_packet : 134217728 # 2020-06-15T15:42:43 [54131] SVAR: max_binlog_cache_size : 18446744073709547520 # 2020-06-15T15:42:43 [54131] SVAR: max_binlog_size : 1073741824 # 2020-06-15T15:42:43 [54131] SVAR: max_binlog_stmt_cache_size : 18446744073709547520 # 2020-06-15T15:42:43 [54131] SVAR: max_connect_errors : 100 # 2020-06-15T15:42:43 [54131] SVAR: max_connections : 151 # 2020-06-15T15:42:43 [54131] SVAR: max_delayed_threads : 20 # 2020-06-15T15:42:43 [54131] SVAR: max_digest_length : 1024 # 2020-06-15T15:42:43 [54131] SVAR: max_error_count : 64 # 2020-06-15T15:42:43 [54131] SVAR: max_heap_table_size : 16777216 # 2020-06-15T15:42:43 [54131] SVAR: max_insert_delayed_threads : 20 # 2020-06-15T15:42:43 [54131] SVAR: max_join_size : 18446744073709551615 # 2020-06-15T15:42:43 [54131] SVAR: max_length_for_sort_data : 1024 # 2020-06-15T15:42:43 [54131] SVAR: max_long_data_size : 134217728 # 2020-06-15T15:42:43 [54131] SVAR: max_prepared_stmt_count : 16382 # 2020-06-15T15:42:43 [54131] SVAR: max_recursive_iterations : 4294967295 # 2020-06-15T15:42:43 [54131] SVAR: max_relay_log_size : 1073741824 # 2020-06-15T15:42:43 [54131] SVAR: max_seeks_for_key : 4294967295 # 2020-06-15T15:42:43 [54131] SVAR: max_session_mem_used : 9223372036854775807 # 2020-06-15T15:42:43 [54131] SVAR: max_sort_length : 1024 # 2020-06-15T15:42:43 [54131] SVAR: max_sp_recursion_depth : 0 # 2020-06-15T15:42:43 [54131] SVAR: max_statement_time : 30.000000 # 2020-06-15T15:42:43 [54131] SVAR: max_tmp_tables : 32 # 2020-06-15T15:42:43 [54131] SVAR: max_user_connections : 0 # 2020-06-15T15:42:43 [54131] SVAR: max_write_lock_count : 4294967295 # 2020-06-15T15:42:43 [54131] SVAR: metadata_locks_cache_size : 1024 # 2020-06-15T15:42:43 [54131] SVAR: metadata_locks_hash_instances : 8 # 2020-06-15T15:42:43 [54131] SVAR: min_examined_row_limit : 0 # 2020-06-15T15:42:43 [54131] SVAR: mrr_buffer_size : 262144 # 2020-06-15T15:42:43 [54131] SVAR: multi_range_count : 256 # 2020-06-15T15:42:43 [54131] SVAR: myisam_block_size : 1024 # 2020-06-15T15:42:43 [54131] SVAR: myisam_data_pointer_size : 6 # 2020-06-15T15:42:43 [54131] SVAR: myisam_max_sort_file_size : 9223372036853727232 # 2020-06-15T15:42:43 [54131] SVAR: myisam_mmap_size : 18446744073709551615 # 2020-06-15T15:42:43 [54131] SVAR: myisam_recover_options : BACKUP,QUICK # 2020-06-15T15:42:43 [54131] SVAR: myisam_repair_threads : 1 # 2020-06-15T15:42:43 [54131] SVAR: myisam_sort_buffer_size : 134216704 # 2020-06-15T15:42:43 [54131] SVAR: myisam_stats_method : NULLS_UNEQUAL # 2020-06-15T15:42:43 [54131] SVAR: myisam_use_mmap : OFF # 2020-06-15T15:42:43 [54131] SVAR: mysql56_temporal_format : ON # 2020-06-15T15:42:43 [54131] SVAR: net_buffer_length : 16384 # 2020-06-15T15:42:43 [54131] SVAR: net_read_timeout : 30 # 2020-06-15T15:42:43 [54131] SVAR: net_retry_count : 10 # 2020-06-15T15:42:43 [54131] SVAR: net_write_timeout : 60 # 2020-06-15T15:42:43 [54131] SVAR: old : OFF # 2020-06-15T15:42:43 [54131] SVAR: old_alter_table : OFF # 2020-06-15T15:42:43 [54131] SVAR: old_mode : # 2020-06-15T15:42:43 [54131] SVAR: old_passwords : OFF # 2020-06-15T15:42:43 [54131] SVAR: open_files_limit : 10240 # 2020-06-15T15:42:43 [54131] SVAR: optimizer_prune_level : 1 # 2020-06-15T15:42:43 [54131] SVAR: optimizer_search_depth : 62 # 2020-06-15T15:42:43 [54131] SVAR: optimizer_selectivity_sampling_limit : 100 # 2020-06-15T15:42:43 [54131] 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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on # 2020-06-15T15:42:43 [54131] SVAR: optimizer_use_condition_selectivity : 1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema : OFF # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_accounts_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_digests_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_events_stages_history_long_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_events_stages_history_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_events_statements_history_long_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_events_statements_history_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_events_waits_history_long_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_events_waits_history_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_hosts_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_cond_classes : 80 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_cond_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_digest_length : 1024 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_file_classes : 50 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_file_handles : 32768 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_file_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_mutex_classes : 200 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_mutex_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_rwlock_classes : 40 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_rwlock_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_socket_classes : 10 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_socket_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_stage_classes : 150 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_statement_classes : 188 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_table_handles : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_table_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_thread_classes : 50 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_max_thread_instances : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_session_connect_attrs_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_setup_actors_size : 100 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_setup_objects_size : 100 # 2020-06-15T15:42:43 [54131] SVAR: performance_schema_users_size : -1 # 2020-06-15T15:42:43 [54131] SVAR: pid_file : /dev/shm/vardir/1592234582/127/1/mysql.pid # 2020-06-15T15:42:43 [54131] SVAR: plugin_dir : /home/mleich/Server_bin/10.2_debug/lib/plugin/ # 2020-06-15T15:42:43 [54131] SVAR: plugin_maturity : unknown # 2020-06-15T15:42:43 [54131] SVAR: port : 27120 # 2020-06-15T15:42:43 [54131] SVAR: preload_buffer_size : 32768 # 2020-06-15T15:42:43 [54131] SVAR: profiling : OFF # 2020-06-15T15:42:43 [54131] SVAR: profiling_history_size : 15 # 2020-06-15T15:42:43 [54131] SVAR: progress_report_time : 5 # 2020-06-15T15:42:43 [54131] SVAR: protocol_version : 10 # 2020-06-15T15:42:43 [54131] SVAR: proxy_user : # 2020-06-15T15:42:43 [54131] SVAR: pseudo_slave_mode : OFF # 2020-06-15T15:42:43 [54131] SVAR: pseudo_thread_id : 9 # 2020-06-15T15:42:43 [54131] SVAR: query_alloc_block_size : 16384 # 2020-06-15T15:42:43 [54131] SVAR: query_cache_limit : 1048576 # 2020-06-15T15:42:43 [54131] SVAR: query_cache_min_res_unit : 4096 # 2020-06-15T15:42:43 [54131] SVAR: query_cache_size : 1048576 # 2020-06-15T15:42:43 [54131] SVAR: query_cache_strip_comments : OFF # 2020-06-15T15:42:43 [54131] SVAR: query_cache_type : OFF # 2020-06-15T15:42:43 [54131] SVAR: query_cache_wlock_invalidate : OFF # 2020-06-15T15:42:43 [54131] SVAR: query_prealloc_size : 24576 # 2020-06-15T15:42:43 [54131] SVAR: rand_seed1 : 838151748 # 2020-06-15T15:42:43 [54131] SVAR: rand_seed2 : 7319967 # 2020-06-15T15:42:43 [54131] SVAR: range_alloc_block_size : 4096 # 2020-06-15T15:42:43 [54131] SVAR: read_binlog_speed_limit : 0 # 2020-06-15T15:42:43 [54131] SVAR: read_buffer_size : 131072 # 2020-06-15T15:42:43 [54131] SVAR: read_only : OFF # 2020-06-15T15:42:43 [54131] SVAR: read_rnd_buffer_size : 262144 # 2020-06-15T15:42:43 [54131] SVAR: relay_log : # 2020-06-15T15:42:43 [54131] SVAR: relay_log_basename : # 2020-06-15T15:42:43 [54131] SVAR: relay_log_index : # 2020-06-15T15:42:43 [54131] SVAR: relay_log_info_file : relay-log.info # 2020-06-15T15:42:43 [54131] SVAR: relay_log_purge : ON # 2020-06-15T15:42:43 [54131] SVAR: relay_log_recovery : OFF # 2020-06-15T15:42:43 [54131] SVAR: relay_log_space_limit : 0 # 2020-06-15T15:42:43 [54131] SVAR: replicate_annotate_row_events : ON # 2020-06-15T15:42:43 [54131] SVAR: replicate_do_db : # 2020-06-15T15:42:43 [54131] SVAR: replicate_do_table : # 2020-06-15T15:42:43 [54131] SVAR: replicate_events_marked_for_skip : REPLICATE # 2020-06-15T15:42:43 [54131] SVAR: replicate_ignore_db : # 2020-06-15T15:42:43 [54131] SVAR: replicate_ignore_table : # 2020-06-15T15:42:43 [54131] SVAR: replicate_wild_do_table : # 2020-06-15T15:42:43 [54131] SVAR: replicate_wild_ignore_table : # 2020-06-15T15:42:43 [54131] SVAR: report_host : # 2020-06-15T15:42:43 [54131] SVAR: report_password : # 2020-06-15T15:42:43 [54131] SVAR: report_port : 27120 # 2020-06-15T15:42:43 [54131] SVAR: report_user : # 2020-06-15T15:42:43 [54131] SVAR: rowid_merge_buff_size : 8388608 # 2020-06-15T15:42:43 [54131] SVAR: secure_auth : ON # 2020-06-15T15:42:43 [54131] SVAR: secure_file_priv : # 2020-06-15T15:42:43 [54131] SVAR: server_id : 1 # 2020-06-15T15:42:43 [54131] SVAR: session_track_schema : ON # 2020-06-15T15:42:43 [54131] SVAR: session_track_state_change : OFF # 2020-06-15T15:42:43 [54131] SVAR: session_track_system_variables : # 2020-06-15T15:42:43 [54131] SVAR: session_track_transaction_info : OFF # 2020-06-15T15:42:43 [54131] SVAR: skip_external_locking : ON # 2020-06-15T15:42:43 [54131] SVAR: skip_name_resolve : OFF # 2020-06-15T15:42:43 [54131] SVAR: skip_networking : OFF # 2020-06-15T15:42:43 [54131] SVAR: skip_parallel_replication : OFF # 2020-06-15T15:42:43 [54131] SVAR: skip_replication : OFF # 2020-06-15T15:42:43 [54131] SVAR: skip_show_database : OFF # 2020-06-15T15:42:43 [54131] SVAR: slave_compressed_protocol : OFF # 2020-06-15T15:42:43 [54131] SVAR: slave_ddl_exec_mode : IDEMPOTENT # 2020-06-15T15:42:43 [54131] SVAR: slave_domain_parallel_threads : 0 # 2020-06-15T15:42:43 [54131] SVAR: slave_exec_mode : STRICT # 2020-06-15T15:42:43 [54131] SVAR: slave_load_tmpdir : /dev/shm/vardir/1592234582/127/1/tmp # 2020-06-15T15:42:43 [54131] SVAR: slave_max_allowed_packet : 1073741824 # 2020-06-15T15:42:43 [54131] SVAR: slave_net_timeout : 60 # 2020-06-15T15:42:43 [54131] SVAR: slave_parallel_max_queued : 131072 # 2020-06-15T15:42:43 [54131] SVAR: slave_parallel_mode : conservative # 2020-06-15T15:42:43 [54131] SVAR: slave_parallel_threads : 0 # 2020-06-15T15:42:43 [54131] SVAR: slave_parallel_workers : 0 # 2020-06-15T15:42:43 [54131] SVAR: slave_run_triggers_for_rbr : NO # 2020-06-15T15:42:43 [54131] SVAR: slave_skip_errors : OFF # 2020-06-15T15:42:43 [54131] SVAR: slave_sql_verify_checksum : ON # 2020-06-15T15:42:43 [54131] SVAR: slave_transaction_retries : 10 # 2020-06-15T15:42:43 [54131] SVAR: slave_type_conversions : # 2020-06-15T15:42:43 [54131] SVAR: slow_launch_time : 2 # 2020-06-15T15:42:43 [54131] SVAR: slow_query_log : OFF # 2020-06-15T15:42:43 [54131] SVAR: slow_query_log_file : sdp-slow.log # 2020-06-15T15:42:43 [54131] SVAR: socket : /dev/shm/vardir/1592234582/127/1/mysql.sock # 2020-06-15T15:42:43 [54131] SVAR: sort_buffer_size : 2097152 # 2020-06-15T15:42:43 [54131] SVAR: sql_auto_is_null : OFF # 2020-06-15T15:42:43 [54131] SVAR: sql_big_selects : ON # 2020-06-15T15:42:43 [54131] SVAR: sql_buffer_result : OFF # 2020-06-15T15:42:43 [54131] SVAR: sql_log_bin : ON # 2020-06-15T15:42:43 [54131] SVAR: sql_log_off : OFF # 2020-06-15T15:42:43 [54131] SVAR: sql_mode : NO_ENGINE_SUBSTITUTION # 2020-06-15T15:42:43 [54131] SVAR: sql_notes : ON # 2020-06-15T15:42:43 [54131] SVAR: sql_quote_show_create : ON # 2020-06-15T15:42:43 [54131] SVAR: sql_safe_updates : OFF # 2020-06-15T15:42:43 [54131] SVAR: sql_select_limit : 18446744073709551615 # 2020-06-15T15:42:43 [54131] SVAR: sql_slave_skip_counter : 0 # 2020-06-15T15:42:43 [54131] SVAR: sql_warnings : OFF # 2020-06-15T15:42:43 [54131] SVAR: ssl_ca : # 2020-06-15T15:42:43 [54131] SVAR: ssl_capath : # 2020-06-15T15:42:43 [54131] SVAR: ssl_cert : # 2020-06-15T15:42:43 [54131] SVAR: ssl_cipher : # 2020-06-15T15:42:43 [54131] SVAR: ssl_crl : # 2020-06-15T15:42:43 [54131] SVAR: ssl_crlpath : # 2020-06-15T15:42:43 [54131] SVAR: ssl_key : # 2020-06-15T15:42:43 [54131] SVAR: standard_compliant_cte : ON # 2020-06-15T15:42:43 [54131] SVAR: storage_engine : InnoDB # 2020-06-15T15:42:43 [54131] SVAR: stored_program_cache : 256 # 2020-06-15T15:42:43 [54131] SVAR: strict_password_validation : ON # 2020-06-15T15:42:43 [54131] SVAR: sync_binlog : 0 # 2020-06-15T15:42:43 [54131] SVAR: sync_frm : ON # 2020-06-15T15:42:43 [54131] SVAR: sync_master_info : 10000 # 2020-06-15T15:42:43 [54131] SVAR: sync_relay_log : 10000 # 2020-06-15T15:42:43 [54131] SVAR: sync_relay_log_info : 10000 # 2020-06-15T15:42:43 [54131] SVAR: system_time_zone : UTC # 2020-06-15T15:42:43 [54131] SVAR: table_definition_cache : 400 # 2020-06-15T15:42:43 [54131] SVAR: table_open_cache : 2000 # 2020-06-15T15:42:43 [54131] SVAR: table_open_cache_instances : 2 # 2020-06-15T15:42:43 [54131] SVAR: thread_cache_size : 151 # 2020-06-15T15:42:43 [54131] SVAR: thread_concurrency : 10 # 2020-06-15T15:42:43 [54131] SVAR: thread_handling : one-thread-per-connection # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_idle_timeout : 60 # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_max_threads : 65536 # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_oversubscribe : 3 # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_prio_kickup_timer : 1000 # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_priority : auto # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_size : 7 # 2020-06-15T15:42:43 [54131] SVAR: thread_pool_stall_limit : 500 # 2020-06-15T15:42:43 [54131] SVAR: thread_stack : 299008 # 2020-06-15T15:42:43 [54131] SVAR: time_format : %H:%i:%s # 2020-06-15T15:42:43 [54131] SVAR: time_zone : SYSTEM # 2020-06-15T15:42:43 [54131] SVAR: timed_mutexes : OFF # 2020-06-15T15:42:43 [54131] SVAR: timestamp : 1592235763.293845 # 2020-06-15T15:42:43 [54131] SVAR: tmp_disk_table_size : 18446744073709551615 # 2020-06-15T15:42:43 [54131] SVAR: tmp_memory_table_size : 16777216 # 2020-06-15T15:42:43 [54131] SVAR: tmp_table_size : 16777216 # 2020-06-15T15:42:43 [54131] SVAR: tmpdir : /dev/shm/vardir/1592234582/127/1/tmp # 2020-06-15T15:42:43 [54131] SVAR: transaction_alloc_block_size : 8192 # 2020-06-15T15:42:43 [54131] SVAR: transaction_prealloc_size : 4096 # 2020-06-15T15:42:43 [54131] SVAR: tx_isolation : REPEATABLE-READ # 2020-06-15T15:42:43 [54131] SVAR: tx_read_only : OFF # 2020-06-15T15:42:43 [54131] SVAR: unique_checks : ON # 2020-06-15T15:42:43 [54131] SVAR: updatable_views_with_limit : YES # 2020-06-15T15:42:43 [54131] SVAR: use_stat_tables : NEVER # 2020-06-15T15:42:43 [54131] SVAR: userstat : OFF # 2020-06-15T15:42:43 [54131] SVAR: version : 10.2.33-MariaDB-debug-log # 2020-06-15T15:42:43 [54131] SVAR: version_comment : Source distribution # 2020-06-15T15:42:43 [54131] SVAR: version_compile_machine : x86_64 # 2020-06-15T15:42:43 [54131] SVAR: version_compile_os : Linux # 2020-06-15T15:42:43 [54131] SVAR: version_malloc_library : system # 2020-06-15T15:42:43 [54131] SVAR: version_ssl_library : YaSSL 2.4.4 # 2020-06-15T15:42:43 [54131] SVAR: wait_timeout : 28800 # 2020-06-15T15:42:43 [54131] SVAR: warning_count : 0 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_auto_increment_control : ON # 2020-06-15T15:42:43 [54131] SVAR: wsrep_causal_reads : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_certification_rules : strict # 2020-06-15T15:42:43 [54131] SVAR: wsrep_certify_nonpk : ON # 2020-06-15T15:42:43 [54131] SVAR: wsrep_cluster_address : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_cluster_name : my_wsrep_cluster # 2020-06-15T15:42:43 [54131] SVAR: wsrep_convert_lock_to_trx : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_data_home_dir : /dev/shm/vardir/1592234582/127/1/data/ # 2020-06-15T15:42:43 [54131] SVAR: wsrep_dbug_option : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_debug : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_desync : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_dirty_reads : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_drupal_282555_workaround : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_forced_binlog_format : NONE # 2020-06-15T15:42:43 [54131] SVAR: wsrep_gtid_domain_id : 0 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_gtid_mode : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_load_data_splitting : ON # 2020-06-15T15:42:43 [54131] SVAR: wsrep_log_conflicts : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_max_ws_rows : 0 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_max_ws_size : 2147483647 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_mysql_replication_bundle : 0 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_node_address : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_node_incoming_address : AUTO # 2020-06-15T15:42:43 [54131] SVAR: wsrep_node_name : sdp # 2020-06-15T15:42:43 [54131] SVAR: wsrep_notify_cmd : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_on : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_osu_method : TOI # 2020-06-15T15:42:43 [54131] SVAR: wsrep_patch_version : wsrep_25.24 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_provider : none # 2020-06-15T15:42:43 [54131] SVAR: wsrep_provider_options : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_recover : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_reject_queries : NONE # 2020-06-15T15:42:43 [54131] SVAR: wsrep_replicate_myisam : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_restart_slave : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_retry_autocommit : 1 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_slave_fk_checks : ON # 2020-06-15T15:42:43 [54131] SVAR: wsrep_slave_threads : 1 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_slave_uk_checks : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_sst_auth : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_sst_donor : # 2020-06-15T15:42:43 [54131] SVAR: wsrep_sst_donor_rejects_queries : OFF # 2020-06-15T15:42:43 [54131] SVAR: wsrep_sst_method : rsync # 2020-06-15T15:42:43 [54131] SVAR: wsrep_sst_receive_address : AUTO # 2020-06-15T15:42:43 [54131] SVAR: wsrep_start_position : 00000000-0000-0000-0000-000000000000:-1 # 2020-06-15T15:42:43 [54131] SVAR: wsrep_sync_wait : 0 # 2020-06-15T15:42:43 [54131] DEBUG: dsns[0] defined. # 2020-06-15T15:42:43 [54131] --------------------------------------------------------------- # 2020-06-15T15:42:43 [54131] debug_server => ['undef', 'undef', 'undef'] # 2020-06-15T15:42:43 [54131] dsn => ['dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1'] # 2020-06-15T15:42:43 [54131] duration => 300 # 2020-06-15T15:42:43 [54131] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-06-15T15:42:43 [54131] gendata => /home/mleich/RQG_mleich/storage/1592234582/127/rqg.zz # 2020-06-15T15:42:43 [54131] generator => FromGrammar # 2020-06-15T15:42:43 [54131] grammar => /home/mleich/RQG_mleich/storage/1592234582/127/rqg.yy # 2020-06-15T15:42:43 [54131] logfile => /home/mleich/RQG_mleich/storage/1592234582/127/rqg.log # 2020-06-15T15:42:43 [54131] mask => 0 # 2020-06-15T15:42:43 [54131] mask-level => 0 # 2020-06-15T15:42:43 [54131] queries => 10000000 # 2020-06-15T15:42:43 [54131] reporters => ['Backtrace', 'Deadlock1', 'ErrorLog', 'None'] # 2020-06-15T15:42:43 [54131] restart-timeout => 120 # 2020-06-15T15:42:43 [54131] rpl_mode => none # 2020-06-15T15:42:43 [54131] rr => 1 # 2020-06-15T15:42:43 [54131] rr_options => "--chaos" # 2020-06-15T15:42:43 [54131] seed => 9249 # 2020-06-15T15:42:43 [54131] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x5600eb1669f8)'] # 2020-06-15T15:42:43 [54131] threads => 1 # 2020-06-15T15:42:43 [54131] validators => ['None'] # 2020-06-15T15:42:43 [54131] vcols => ['undef', 'undef', 'undef'] # 2020-06-15T15:42:43 [54131] views => ['undef', 'undef', 'undef'] # 2020-06-15T15:42:43 [54131] --------------------------------------------------------------- # 2020-06-15T15:42:43 [54131] DEBUG: timeoutMultiplier : 1.5<- # 2020-06-15T15:42:43 [54131] ------------------------------- # 2020-06-15T15:42:43 [54131] Configuration # 2020-06-15T15:42:43 [54131] debug_server => ['undef', 'undef', 'undef'] # 2020-06-15T15:42:43 [54131] dsn => ['dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1'] # 2020-06-15T15:42:43 [54131] duration => 300 # 2020-06-15T15:42:43 [54131] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-06-15T15:42:43 [54131] gendata => /home/mleich/RQG_mleich/storage/1592234582/127/rqg.zz # 2020-06-15T15:42:43 [54131] generator => FromGrammar # 2020-06-15T15:42:43 [54131] grammar => /home/mleich/RQG_mleich/storage/1592234582/127/rqg.yy # 2020-06-15T15:42:43 [54131] logfile => /home/mleich/RQG_mleich/storage/1592234582/127/rqg.log # 2020-06-15T15:42:43 [54131] mask => 0 # 2020-06-15T15:42:43 [54131] mask-level => 0 # 2020-06-15T15:42:43 [54131] queries => 10000000 # 2020-06-15T15:42:43 [54131] reporters => ['Backtrace', 'Deadlock1', 'ErrorLog', 'None'] # 2020-06-15T15:42:43 [54131] restart-timeout => 120 # 2020-06-15T15:42:43 [54131] rpl_mode => none # 2020-06-15T15:42:43 [54131] rr => 1 # 2020-06-15T15:42:43 [54131] rr_options => "--chaos" # 2020-06-15T15:42:43 [54131] seed => 9249 # 2020-06-15T15:42:43 [54131] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x5600eb1669f8)'] # 2020-06-15T15:42:43 [54131] threads => 1 # 2020-06-15T15:42:43 [54131] validators => ['None'] # 2020-06-15T15:42:43 [54131] vcols => ['undef', 'undef', 'undef'] # 2020-06-15T15:42:43 [54131] views => ['undef', 'undef', 'undef'] # 2020-06-15T15:42:43 [54131] INFO: Begin of GenData activity # 2020-06-15T15:42:43 [54131] INFO: Starting GenTest::App::Gendata # 2020-06-15T15:42:43 [54131] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-15T15:42:43 [54131] Creating MySQL table: test.table500_innodb_int_autoinc; engine: innodb; rows: 500 . # 2020-06-15T15:42:48 [54131] INFO: Finishing GenTest::App::Gendata # 2020-06-15T15:42:48 [54131] INFO: End of GenData activity # 2020-06-15T15:42:48 [54131] GenData returned status STATUS_OK (0) # 2020-06-15T15:42:48 [54131] INFO: RQG GenData runtime in s : 5 # 2020-06-15T15:42:48 [54131] INFO: GenTest: Start of running queries : 1592235769 # 2020-06-15T15:42:48 [54131] Reading grammar from file '/home/mleich/RQG_mleich/storage/1592234582/127/rqg.yy'. # 2020-06-15T15:42:48 [54131] Reporters (for Simplifier): ->Backtrace<->Deadlock1<->ErrorLog<->None<- # 2020-06-15T15:42:48 [54131] INFO: Reporter 'Backtrace' added. # 2020-06-15T15:42:48 [54131] INFO: Reporter 'Deadlock1' added. # 2020-06-15T15:42:48 [54131] INFO: Reporter 'ErrorLog' added. # 2020-06-15T15:42:48 [54131] Validators (for Simplifier): ->None<- # 2020-06-15T15:42:48 [54131] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-15T15:42:48 [54131] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 # 2020-06-15T15:42:52 [54131] Starting 1 processes, 10000000 queries each, duration 300 seconds. # 2020-06-15T15:42:52 [54131] GenTest::ErrorFilter(56194) started # 2020-06-15T15:42:52 [56201] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-15T15:42:52 [56201] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-15T15:42:52 [56201] INFO: Thread1 : Mixer created. # 2020-06-15T15:42:52 [56197] INFO: Periodic reporting process at begin of activity # 2020-06-15T15:42:52 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:42:52 [56194] ErrorFilter: Query: INSERT INTO `table500_innodb_int_autoinc` ( `col_set_utf8_key`, `col_enum_utf8_key`, `col_longtext_utf8` ) VALUES ( REPEAT( _UTF8 0x3CE4, 101 ), CONVERT( 'reljiupxmtkkzjwbpyofjqxdlcsnslruxffiocftowrtmtfsxmibvpguruwdqsjjvfgftiiwynluvjoxlgblmkzinqdnxkhhmgueddamdibgjclzmvtgxbsfnebyhowujnysmuhpftugynczichjohalojyrotwbzdleumrieaomakhgmoektjvevrovpnanhfxxfjjrwohzvcrqijoelxu' USING UCS2 ), CONVERT( 'seek' USING ASCII ) ) /* E_R Thread1 QNO 26 CON_ID 16 */ failed: 1300 Invalid %s character string: '%s'. Further errors of this kind will be suppressed. # 2020-06-15T15:42:53 [56194] ErrorFilter: Query: DELETE FROM `table500_innodb_int_autoinc` WHERE `col_char_255_ucs2_key` LIKE CONCAT( CONVERT( 'ministry' USING UTF8 ), '%' ) ORDER BY `pk` LIMIT 1 /* E_R Thread1 QNO 27 CON_ID 16 */ failed: 1267 Illegal mix of collations %s and %s for operation '%s'. Further errors of this kind will be suppressed. # 2020-06-15T15:42:53 [56194] ErrorFilter: Query: DELETE FROM `table500_innodb_int_autoinc` WHERE `col_enum_utf8_key` IN ( CONVERT( 'accessible' USING ASCII ), CONVERT( 'repair' USING UTF8 ), REPEAT( _UCS2 0xA0D6, 35 ), CONVERT( 'iupxmtkkzjwbpyofjqxdlcsnslruxffiocftowrtmtfsxmibvpguruwdqsjjvfgftiiwynluvjoxlgblmkzinqdnxkhhmgueddamdibgjclzmvtgxbsfnebyhowujnysmuhpftugynczichjohalojyrotwbzdleumrieaomakhgmoe' USING UTF8 ), CONVERT( 'upxmtkkzjwbpyofjqxdlcsnslruxffiocftowrtmtfsxmibvpguruwdqsjjvfgftiiwy' USING ASCII ), CONVERT( 'restriction' USING LATIN1 ), CONVERT( 'widow' USING UCS2 ) ) ORDER BY `pk` LIMIT 1 /* E_R Thread1 QNO 41 CON_ID 16 */ failed: 1271 Illegal mix of collations for operation 'in'. Further errors of this kind will be suppressed. # 2020-06-15T15:42:53 [56194] ErrorFilter: Query: UPDATE `table500_innodb_int_autoinc` SET `col_varchar_255_utf8` = CONVERT( 'inevitably' USING UTF8 ) WHERE `col_set_utf8` BETWEEN CONVERT( 'dog' USING LATIN1 ) AND CONVERT( 'zjwbpyofjqxdlcsnslruxffiocftowrtmtfsxmibvpguruwdqsjjvfgftiiwynluvjoxlgblmkzinqdnxkhhmgueddamdibgjclzmvtgxbsfnebyhowujnysmuhpftugynczichjohalojyrotwbzdleumrieaomakhgmoektjvevrovpnanhfxxfjjr' USING UCS2 ) /* E_R Thread1 QNO 48 CON_ID 16 */ failed: 1270 Illegal mix of collations %s, %s, %s for operation '%s'. Further errors of this kind will be suppressed. # 2020-06-15T15:43:02 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:43:03 [56194] ErrorFilter: Query: INSERT INTO `table500_innodb_int_autoinc` ( `col_longtext_utf8_key`, `col_enum_utf8`, `col_longtext_utf8_key` ) VALUES ( REPEAT( _LATIN1 0xAFB0, 195 ), REPEAT( _LATIN1 0xDA, 185 ), REPEAT( _UCS2 0xC2DB, 220 ) ) /* E_R Thread1 QNO 93 CON_ID 16 */ failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed. # 2020-06-15T15:43:12 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:43:22 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:43:33 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:43:43 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:43:53 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:44:03 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:44:13 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:44:23 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-15T15:44:28 [56201] GenTest::Executor::MySQL::execute: Thread1 Query: DELETE FROM `table500_innodb_int_autoinc` WHERE `col_enum_utf8` IS NOT NULL ORDER BY `pk` LIMIT 1 /* E_R Thread1 QNO 365 CON_ID 16 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-15T15:44:33 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:36 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:39 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:42 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:45 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:48 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:51 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:54 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:57 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:44:58 [56201] ERROR: GenTest::Executor::MySQL::get_dbh: ConnectChecker connect to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111). Will return undef # 2020-06-15T15:44:58 [56201] INFO: /* E_R Thread1 QNO 365 CON_ID 16 */ : The server is not connectable. Will return a result containing the status STATUS_CRITICAL_FAILURE(100). # 2020-06-15T15:44:58 [56201] Thread1 in Mixer : Critical failure STATUS_CRITICAL_FAILURE (100), Error 2013 reported at dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 # 2020-06-15T15:44:58 [56201] GenTest: Server crash or critical failure (STATUS_CRITICAL_FAILURE) was reported. # 2020-06-15T15:44:58 [56201] The child process for Thread1 will be stopped. # 2020-06-15T15:44:58 [56201] GenTest: child 56201 is being stopped with status STATUS_CRITICAL_FAILURE # 2020-06-15T15:45:00 [56197] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-15T15:45:00 [56197] ERROR: Reporter 'Deadlock': All 10 connect attempts to dsn dbi:mysql:host=127.0.0.1:port=27120:user=root:database=test:mysql_local_infile=1 failed. Will return STATUS_SERVER_CRASHED # 2020-06-15T15:45:00 [56197] INFO: GenTest::ReporterManager::monitor: Reporter 'Deadlock1' reported 101 # 2020-06-15T15:45:00 [56197] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 101 # 2020-06-15T15:45:00 [56197] ERROR: Periodic reporting process: Critical status STATUS_SERVER_CRASHED got. Will exit with that. # 2020-06-15T15:45:00 [56197] GenTest: child 56197 is being stopped with status STATUS_SERVER_CRASHED # 2020-06-15T15:45:02 [54131] Process with pid 56197 for periodic reporter ended with status STATUS_SERVER_CRASHED # 2020-06-15T15:45:02 [54131] Killing (TERM) remaining worker process with pid 56201... # 2020-06-15T15:45:02 [54131] Process with pid 56201 for Thread1 ended with status STATUS_CRITICAL_FAILURE # 2020-06-15T15:45:17 [54131] Kill GenTest::ErrorFilter(56194) # 2020-06-15T15:45:17 [54131] INFO: GenTest: Effective duration in s : 148 # 2020-06-15T15:45:17 [54131] Server crash reported, initiating post-crash analysis... # 2020-06-15T15:45:17 [54131] INFO: Reporter 'Backtrace' ------------------------------ Begin # 2020-06-15T15:45:17 [54131] datadir is /dev/shm/vardir/1592234582/127/1/data/ # 2020-06-15T15:45:17 [54131] binary is /home/mleich/Server_bin/10.2_debug/bin/mysqld # 2020-06-15T15:45:17 [54131] bindir is /home/mleich/Server_bin/10.2_debug/bin # 2020-06-15T15:45:17 [54131] error_log is /dev/shm/vardir/1592234582/127/1/data/../mysql.err # 2020-06-15T15:45:17 [54131] pid_file is /dev/shm/vardir/1592234582/127/1/mysql.pid # 2020-06-15T15:45:18 [54131] INFO: Reporter::Backtrace The pid_file '/dev/shm/vardir/1592234582/127/1/mysql.pid' did not disappear. # 2020-06-15T15:45:18 [54131] ALARM: Reporter::Backtrace 1.01831197738647s waited but the server error_log remains without '... (core dumped)'. # 2020-06-15T15:49:49 [54131] INFO: Even after 270s waiting: The core file name is not defined. # 2020-06-15T15:49:49 [54131] Will return STATUS_SERVER_CRASHED, undef # 2020-06-15T15:49:49 [54131] INFO: Reporter 'Backtrace' ------------------------------ End # 2020-06-15T15:49:49 [54131] ERROR: ReporterManager : Reporter 'Backtrace' reported 101 # 2020-06-15T15:49:49 [54131] INFO: Reporter 'ErrorLog' ------------------------------ Begin # 2020-06-15T15:49:49 [54131] --------- Contents of /dev/shm/vardir/1592234582/127/1/data//../mysql.err ------------- # 2020-06-15T15:49:49 [54131] | [rr 54799 1366]2020-06-15 15:42:41 121016813339136 [Note] /home/mleich/Server_bin/10.2_debug//bin/mysqld (mysqld 10.2.33-MariaDB-debug-log) starting as process 54799 ... # 2020-06-15T15:49:49 [54131] | [rr 54799 1380]2020-06-15 15:42:41 121016813339136 [Warning] Could not increase number of max_open_files to more than 10240 (request: 32189) # 2020-06-15T15:49:49 [54131] | [rr 54799 1427]2020-06-15 15:42:41 121016813339136 [Warning] setrlimit could not change the size of core files to 'infinity'; We may not be able to generate a core file on signals # 2020-06-15T15:49:49 [54131] | [rr 54799 1497]2020-06-15 15:42:41 121016813339136 [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-06-15T15:49:49 [54131] | [rr 54799 1597]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: innodb_page_size=4096 # 2020-06-15T15:49:49 [54131] | [rr 54799 1601]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2020-06-15T15:49:49 [54131] | [rr 54799 1605]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2020-06-15T15:49:49 [54131] | [rr 54799 1609]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Uses event mutexes # 2020-06-15T15:49:49 [54131] | [rr 54799 1613]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2020-06-15T15:49:49 [54131] | [rr 54799 1621]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Number of pools: 1 # 2020-06-15T15:49:49 [54131] | [rr 54799 1629]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Using SSE2 crc32 instructions # 2020-06-15T15:49:49 [54131] | [rr 54799 1671]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Initializing buffer pool, total size = 5M, instances = 1, chunk size = 5M # 2020-06-15T15:49:49 [54131] | [rr 54799 1703]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Completed initialization of buffer pool # 2020-06-15T15:49:49 [54131] | [rr 54799 1707]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Small buffer pool size (5M), the flst_validate() debug function can cause a deadlock if the buffer pool fills up. # 2020-06-15T15:49:49 [54131] | [rr 54799 2030]2020-06-15 15:42:42 98970710271744 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). # 2020-06-15T15:49:49 [54131] | [rr 54799 2084]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Highest supported file format is Barracuda. # 2020-06-15T15:49:49 [54131] | [rr 54799 3130]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: 128 out of 128 rollback segments are active. # 2020-06-15T15:49:49 [54131] | [rr 54799 3202]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Creating shared tablespace for temporary tables # 2020-06-15T15:49:49 [54131] | [rr 54799 3212]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... # 2020-06-15T15:49:49 [54131] | [rr 54799 3220]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: File './ibtmp1' size is now 12 MB. # 2020-06-15T15:49:49 [54131] | [rr 54799 4125]2020-06-15 15:42:42 121016813339136 [Note] InnoDB: 5.7.30 started; log sequence number 709199 # 2020-06-15T15:49:49 [54131] | [rr 54799 4155]2020-06-15 15:42:42 64102895441664 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/1592234582/127/1/data/ib_buffer_pool # 2020-06-15T15:49:49 [54131] | [rr 54799 4542]2020-06-15 15:42:42 64102895441664 [Note] InnoDB: Buffer pool(s) load completed at 200615 15:42:42 # 2020-06-15T15:49:49 [54131] | [rr 54799 4625]2020-06-15 15:42:42 121016813339136 [Note] Plugin 'FEEDBACK' is disabled. # 2020-06-15T15:49:49 [54131] | [rr 54799 4629]2020-06-15 15:42:42 121016813339136 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-idle_write_transaction_timeout=0' # 2020-06-15T15:49:49 [54131] | [rr 54799 4633]2020-06-15 15:42:42 121016813339136 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-idle_transaction_timeout=0' # 2020-06-15T15:49:49 [54131] | [rr 54799 4637]2020-06-15 15:42:42 121016813339136 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-idle_readonly_transaction_timeout=0' # 2020-06-15T15:49:49 [54131] | [rr 54799 4641]2020-06-15 15:42:42 121016813339136 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-table_lock_wait_timeout=50' # 2020-06-15T15:49:49 [54131] | [rr 54799 4860]2020-06-15 15:42:42 121016813339136 [Note] Server socket created on IP: '::'. # 2020-06-15T15:49:49 [54131] | [rr 54799 5851]2020-06-15 15:42:43 121016813339136 [Note] Reading of all Master_info entries succeeded # 2020-06-15T15:49:49 [54131] | [rr 54799 5855]2020-06-15 15:42:43 121016813339136 [Note] Added new Master_info '' to hash table # 2020-06-15T15:49:49 [54131] | [rr 54799 5861]2020-06-15 15:42:43 121016813339136 [Note] /home/mleich/Server_bin/10.2_debug//bin/mysqld: ready for connections. # 2020-06-15T15:49:49 [54131] | Version: '10.2.33-MariaDB-debug-log' socket: '/dev/shm/vardir/1592234582/127/1/mysql.sock' port: 27120 Source distribution # 2020-06-15T15:49:49 [54131] | [rr 54799 6059]2020-06-15 15:42:43 127892906190592 [Warning] Aborted connection 10 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 34051]2020-06-15 15:42:48 127892906190592 [Warning] Aborted connection 11 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 34234]2020-06-15 15:42:48 127892906190592 [Warning] Aborted connection 12 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 34410]2020-06-15 15:42:48 127892906190592 [Warning] Aborted connection 13 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 34580]2020-06-15 15:42:48 127892906190592 [Warning] Aborted connection 14 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 40992]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'ha_blackhole.so' with offset 0x46e406aa0000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41013]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'ha_archive.so' with offset 0x7f59adedc000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41033]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'ha_test_sql_discovery.so' with offset 0x267c32cb3000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41059]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'qa_auth_client.so' with offset 0x7f59b5f57000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41079]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'ha_federated.so' with offset 0x3cd03235b000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41105]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'mysql_clear_password.so' with offset 0x5a2e5e122000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41125]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'mypluglib.so' with offset 0x437f07a5f000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41145]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'auth_socket.so' with offset 0x29d65dc6000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41165]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'wsrep_info.so' with offset 0x11592dfef000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41185]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'qa_auth_server.so' with offset 0x3cd03235b000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41205]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'query_cache_info.so' with offset 0x7f59adef0000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41225]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'libdaemon_example.so' with offset 0x4f7609abe000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41245]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'ha_example.so' with offset 0x6c92726ed000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41265]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'handlersocket.so' with offset 0x756e27da1000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41285]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'dialog_examples.so' with offset 0x3cd03235b000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41305]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'file_key_management.so' with offset 0x3c04014a5000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41327]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'server_audit.so' with offset 0x78e821b28000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41347]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'locales.so' with offset 0x65e427dfd000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41367]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'query_response_time.so' with offset 0x78e821b33000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41387]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'disks.so' with offset 0x3a671b58f000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41407]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'auth_0x0100.so' with offset 0x7f59adef2000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41427]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'simple_password_check.so' with offset 0x7f59adef1000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41447]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'example_key_management.so' with offset 0x7fff998e0000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41467]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'debug_key_management.so' with offset 0x7fff9addb000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41487]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'semisync_master.so' with offset 0x583f71d26000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41677]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'caching_sha2_password.so' with offset 0x7fff9addb000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41715]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'dialog.so' with offset 0x3cd030f76000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41735]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'sql_errlog.so' with offset 0x14f346722000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41755]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'qa_auth_interface.so' with offset 0x71ff1034f000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41775]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'metadata_lock_info.so' with offset 0x4eed0de67000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41795]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'auth_ed25519.so' with offset 0x6aa63d338000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41815]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'ha_federatedx.so' with offset 0x778a353aa000 # 2020-06-15T15:49:49 [54131] | [rr 54799 41835]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'auth_test_plugin.so' with offset 0x6fdfe000 # 2020-06-15T15:49:49 [54131] | [rr 54799 42024]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'client_ed25519.so' with offset 0x3cd03235b000 # 2020-06-15T15:49:49 [54131] | [rr 54799 42062]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'semisync_slave.so' with offset 0x68200000 # 2020-06-15T15:49:49 [54131] | [rr 54799 42082]2020-06-15 15:42:50 127892906190592 [Note] Loaded 'adt_null.so' with offset 0x51d75f26b000 # 2020-06-15T15:49:49 [54131] | [rr 54799 54653]2020-06-15 15:42:52 127892906190592 [Warning] Aborted connection 15 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 56434]2020-06-15 15:42:52 15188614969088 [Warning] Aborted connection 17 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 137952]2020-06-15 15:43:02 15188614969088 [Warning] Aborted connection 18 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 218262]2020-06-15 15:43:12 15188614969088 [Warning] Aborted connection 19 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 308336]2020-06-15 15:43:22 15188614969088 [Warning] Aborted connection 20 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 392066]2020-06-15 15:43:33 15188614969088 [Warning] Aborted connection 21 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 445332]2020-06-15 15:43:43 15188614969088 [Warning] Aborted connection 22 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 500781]2020-06-15 15:43:53 15188614969088 [Warning] Aborted connection 23 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 546562]2020-06-15 15:44:03 15188614969088 [Warning] Aborted connection 24 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 591806]2020-06-15 15:44:13 15188614969088 [Warning] Aborted connection 25 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 599583]mysqld: /home/mleich/10.2/storage/innobase/buf/buf0buf.cc:4963: ulint buf_page_optimistic_get(ulint, buf_block_t*, ib_uint64_t, const char*, unsigned int, mtr_t*): Assertion `!ibuf_inside(mtr) || ibuf_page_low(block->page.id, block->page.size, (1), "/home/mleich/10.2/storage/innobase/buf/buf0buf.cc", 4963, __null)' failed. # 2020-06-15T15:49:49 [54131] | [rr 54799 599604]200615 15:44:15 [rr 54799 599607][ERROR] mysqld got signal 6 ; # 2020-06-15T15:49:49 [54131] | [rr 54799 599609]This could be because you hit a bug. It is also possible that this binary # 2020-06-15T15:49:49 [54131] | or one of the libraries it was linked against is corrupt, improperly built, # 2020-06-15T15:49:49 [54131] | or misconfigured. This error can also be caused by malfunctioning hardware. # 2020-06-15T15:49:49 [54131] | # 2020-06-15T15:49:49 [54131] | [rr 54799 599611]To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2020-06-15T15:49:49 [54131] | # 2020-06-15T15:49:49 [54131] | [rr 54799 599613]We will try our best to scrape up some info that will hopefully help # 2020-06-15T15:49:49 [54131] | diagnose the problem, but since we have already crashed, # 2020-06-15T15:49:49 [54131] | something is definitely wrong and this may fail. # 2020-06-15T15:49:49 [54131] | # 2020-06-15T15:49:49 [54131] | [rr 54799 599615]Server version: 10.2.33-MariaDB-debug-log # 2020-06-15T15:49:49 [54131] | [rr 54799 599617]key_buffer_size=134217728 # 2020-06-15T15:49:49 [54131] | [rr 54799 599619]read_buffer_size=131072 # 2020-06-15T15:49:49 [54131] | [rr 54799 599621]max_used_connections=3 # 2020-06-15T15:49:49 [54131] | [rr 54799 599623]max_threads=153 # 2020-06-15T15:49:49 [54131] | [rr 54799 599625]thread_count=10 # 2020-06-15T15:49:49 [54131] | [rr 54799 599627]It is possible that mysqld could use up to # 2020-06-15T15:49:49 [54131] | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467327 K bytes of memory # 2020-06-15T15:49:49 [54131] | [rr 54799 599629]Hope that's ok; if not, decrease some variables in the equation. # 2020-06-15T15:49:49 [54131] | # 2020-06-15T15:49:49 [54131] | [rr 54799 599631]Thread pointer: 0x0 # 2020-06-15T15:49:49 [54131] | [rr 54799 599633]Attempting backtrace. You can use the following information to find out # 2020-06-15T15:49:49 [54131] | where mysqld died. If you see no messages after this, something went # 2020-06-15T15:49:49 [54131] | terribly wrong... # 2020-06-15T15:49:49 [54131] | [rr 54799 599637]stack_bottom = 0x0 thread_stack 0x49000 # 2020-06-15T15:49:49 [54131] | [rr 54799 599987]/home/mleich/Server_bin/10.2_debug//bin/mysqld(my_print_stacktrace+0x38)[0x5626d139c0bb] # 2020-06-15T15:49:49 [54131] | [rr 54799 600235]/home/mleich/Server_bin/10.2_debug//bin/mysqld(handle_fatal_signal+0x3a3)[0x5626d0c04e70] # 2020-06-15T15:49:49 [54131] | [rr 54799 601201]/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x3cd03198c890] # 2020-06-15T15:49:49 [54131] | [rr 54799 601681]/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x2cc7430e2e97] # 2020-06-15T15:49:49 [54131] | [rr 54799 601978]/lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x2cc7430e4801] # 2020-06-15T15:49:49 [54131] | [rr 54799 602398]/lib/x86_64-linux-gnu/libc.so.6(+0x3039a)[0x2cc7430d439a] # 2020-06-15T15:49:49 [54131] | [rr 54799 602621]/lib/x86_64-linux-gnu/libc.so.6(+0x30412)[0x2cc7430d4412] # 2020-06-15T15:49:49 [54131] | [rr 54799 606977]2020-06-15 15:44:23 15188614969088 [Warning] Aborted connection 26 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-15T15:49:49 [54131] | [rr 54799 607078]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xcd129d)[0x5626d107229d] # 2020-06-15T15:49:49 [54131] | [rr 54799 607313]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc95a54)[0x5626d1036a54] # 2020-06-15T15:49:49 [54131] | [rr 54799 607362]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xcab576)[0x5626d104c576] # 2020-06-15T15:49:49 [54131] | [rr 54799 607412]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xad05f2)[0x5626d0e715f2] # 2020-06-15T15:49:49 [54131] | [rr 54799 607439]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xad1e34)[0x5626d0e72e34] # 2020-06-15T15:49:49 [54131] | [rr 54799 607458]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xcd4b4f)[0x5626d1075b4f] # 2020-06-15T15:49:49 [54131] | [rr 54799 607548]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xd5b9b0)[0x5626d10fc9b0] # 2020-06-15T15:49:49 [54131] | [rr 54799 607625]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc0e7e2)[0x5626d0faf7e2] # 2020-06-15T15:49:49 [54131] | [rr 54799 608043]/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x3cd0319816db] # 2020-06-15T15:49:49 [54131] | [rr 54799 608679]/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x2cc7431c588f] # 2020-06-15T15:49:49 [54131] | [rr 54799 608681]The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2020-06-15T15:49:49 [54131] | information that should help you find out what is causing the crash. # 2020-06-15T15:49:49 [54131] | [rr 54799 608684]Writing a core file... # 2020-06-15T15:49:49 [54131] | Working directory at /dev/shm/vardir/1592234582/127/1/data # 2020-06-15T15:49:49 [54131] | [rr 54799 608701]Resource Limits: # 2020-06-15T15:49:49 [54131] | [rr 54799 608712]Fatal signal 11 while backtracing # 2020-06-15T15:49:49 [54131] | Segmentation fault # 2020-06-15T15:49:49 [54131] ---------------------------------- # 2020-06-15T15:49:49 [54131] INFO: Reporter 'ErrorLog' ------------------------------ End # 2020-06-15T15:49:49 [54131] INFO: The reporters to be run at test end delivered status 101. # 2020-06-15T15:49:49 [54131] Test completed with failure status STATUS_SERVER_CRASHED (101) # 2020-06-15T15:49:49 [54131] GenTest returned status STATUS_SERVER_CRASHED (101) # 2020-06-15T15:49:49 [54131] INFO: RQG GenTest runtime in s : 421 # 2020-06-15T15:49:49 [54131] RESULT: The core of the RQG run ended with status STATUS_SERVER_CRASHED (101) # 2020-06-15T15:49:49 [54131] Killing server(s)... # 2020-06-15T15:49:49 [54131] INFO: DBServer::MySQL::MySQLd::killServer: The server with process [54799] is already no more running. Will return DBSTATUS_OK. # 2020-06-15T15:49:49 [54131] INFO: Any remaining servers were killed. # 2020-06-15T15:49:49 [54131] RESULT: The RQG run ended with status STATUS_SERVER_CRASHED (101) # 2020-06-15T15:49:49 [54131] MATCHING: Region end ===================== # 2020-06-15T15:49:49 [54131] Killing server(s)... # 2020-06-15T15:49:49 [54131] INFO: DBServer::MySQL::MySQLd::killServer: Killing the server process impossible because no server pid found. # 2020-06-15T15:49:49 [54131] INFO: RQG total runtime in s : 431 # 2020-06-15T15:49:49 [54131] DEBUG: 'du -sk /dev/shm/vardir/1592234582/127 | cut -f1' exited with value 0 # 2020-06-15T15:49:49 [54131] INFO: vardir_size : 228356 # 2020-06-15T15:49:49 [54131] SUMMARY: Final command line: ->perl /home/mleich/RQG_mleich/rqg.pl --gendata=conf/engines/many_indexes1.zz --grammar=/home/mleich/RQG_mleich/conf/engines/many_indexes.yy --reporters=Backtrace,Deadlock1,ErrorLog,None --validators=None --mysqld=--innodb_use_native_aio=1 --mysqld=--innodb_lock_schedule_algorithm=fcfs --mysqld=--loose-idle_write_transaction_timeout=0 --mysqld=--loose-idle_transaction_timeout=0 --mysqld=--loose-idle_readonly_transaction_timeout=0 --mysqld=--connect_timeout=60 --mysqld=--interactive_timeout=28800 --mysqld=--slave_net_timeout=60 --mysqld=--net_read_timeout=30 --mysqld=--net_write_timeout=60 --mysqld=--loose-table_lock_wait_timeout=50 --mysqld=--wait_timeout=28800 --mysqld=--lock-wait-timeout=86400 --mysqld=--innodb-lock-wait-timeout=50 --no-mask --queries=10000000 --duration=100 --mysqld=--log_output=none --mysqld=--log-bin --mysqld=--log_bin_trust_function_creators=1 --mysqld=--loose-max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --engine=InnoDB --restart_timeout=120 --mysqld=--innodb_stats_persistent=on --threads=1 --mysqld=--innodb_page_size=4K --mysqld=--innodb-buffer-pool-size=5M --duration=300 --no_mask --workdir=/home/mleich/RQG_mleich/storage/1592234582/127 --vardir=/dev/shm/vardir/1592234582/127 --mtr-build-thread=856 --basedir1=/home/mleich/Server_bin/10.2_debug/ --basedir2=/home/mleich/Server_bin/10.2_debug/ --script_debug=_nix_ --rr=Server --rr_options=--chaos --seed=9249<- # 2020-06-15T15:49:49 [54131] SUMMARY: RQG GenData runtime in s : 5 # 2020-06-15T15:49:49 [54131] SUMMARY: RQG GenTest runtime in s : 421 # 2020-06-15T15:49:49 [54131] SUMMARY: RQG total runtime in s : 431 # 2020-06-15T15:49:49 [54131] /home/mleich/RQG_mleich/rqg.pl will exit with exit status STATUS_SERVER_CRASHED(101)