# 2020-06-18T16:33:52 INFO: Logfile for RQG Worker [250] # 2020-06-18T16:33:52 [98616] Using Log::Log4perl # 2020-06-18T16:33:52 [98616] DEBUG: rqg_home might be ->/home/mleich/RQG_mleich<- # 2020-06-18T16:33:52 [98616] 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-18T16:33:52 [98616] INFO: script_debug : '_nix_' # 2020-06-18T16:33:52 [98616] DEBUG: After reading command line options # 2020-06-18T16:33:52 [98616] INFO: The 'rr' invocation type 'Server'. # 2020-06-18T16:33:52 [98616] INFO: rr_options ->--chaos<- # 2020-06-18T16:33:52 [98616] INFO: RQG workdir : '/home/mleich/RQG_mleich/storage/1592496496/250' and infrastructure is prepared. # 2020-06-18T16:33:52 [98616] DEBUG: no_mask is defind. Therefore setting mask_level=0 , mask=0 and no_mask=undef. # 2020-06-18T16:33:52 [98616] Reading grammar from file 'conf/mariadb/functions.yy'. # 2020-06-18T16:33:52 [98616] Reading grammar from file '/home/mleich/RQG_mleich/storage/1592496496/250/tmp_rqg_redefine.yy'. # 2020-06-18T16:33:52 [98616] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2020-06-18T16:33:52 [98616] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2020-06-18T16:33:52 [98616] Starting # 2020-06-18T16:33:52 [98616] # /home/mleich/RQG_mleich/rqg.pl \ # 2020-06-18T16:33:52 [98616] # --redefine=conf/mariadb/general-workarounds.yy \ # 2020-06-18T16:33:52 [98616] # --views \ # 2020-06-18T16:33:52 [98616] # --vcols \ # 2020-06-18T16:33:52 [98616] # --redefine=conf/mariadb/alter_table.yy \ # 2020-06-18T16:33:52 [98616] # --redefine=conf/mariadb/bulk_insert.yy \ # 2020-06-18T16:33:52 [98616] # --redefine=conf/mariadb/xa.yy \ # 2020-06-18T16:33:52 [98616] # --grammar=conf/mariadb/functions.yy \ # 2020-06-18T16:33:52 [98616] # --reporters=Backtrace,Deadlock1,ErrorLog \ # 2020-06-18T16:33:52 [98616] # --validators=TransformerNoComparator \ # 2020-06-18T16:33:52 [98616] # --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice \ # 2020-06-18T16:33:52 [98616] # --mysqld=--innodb_use_native_aio=1 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--innodb_lock_schedule_algorithm=fcfs \ # 2020-06-18T16:33:52 [98616] # --mysqld=--loose-idle_write_transaction_timeout=0 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--loose-idle_transaction_timeout=0 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--connect_timeout=60 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--interactive_timeout=28800 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--slave_net_timeout=60 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--net_read_timeout=30 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--net_write_timeout=60 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--loose-table_lock_wait_timeout=50 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--wait_timeout=28800 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--lock-wait-timeout=86400 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--innodb-lock-wait-timeout=50 \ # 2020-06-18T16:33:52 [98616] # --no-mask \ # 2020-06-18T16:33:52 [98616] # --queries=10000000 \ # 2020-06-18T16:33:52 [98616] # --duration=100 \ # 2020-06-18T16:33:52 [98616] # --seed=random \ # 2020-06-18T16:33:52 [98616] # --mysqld=--log_output=none \ # 2020-06-18T16:33:52 [98616] # --mysqld=--log-bin \ # 2020-06-18T16:33:52 [98616] # --mysqld=--log_bin_trust_function_creators=1 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--loose-max-statement-time=30 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # 2020-06-18T16:33:52 [98616] # --engine=InnoDB \ # 2020-06-18T16:33:52 [98616] # --restart_timeout=120 \ # 2020-06-18T16:33:52 [98616] # --threads=9 \ # 2020-06-18T16:33:52 [98616] # --mysqld=--innodb_page_size=64K \ # 2020-06-18T16:33:52 [98616] # --mysqld=--innodb-buffer-pool-size=24M \ # 2020-06-18T16:33:52 [98616] # --duration=300 \ # 2020-06-18T16:33:52 [98616] # --no_mask \ # 2020-06-18T16:33:52 [98616] # --workdir=/home/mleich/RQG_mleich/storage/1592496496/250 \ # 2020-06-18T16:33:52 [98616] # --vardir=/dev/shm/vardir/1592496496/250 \ # 2020-06-18T16:33:52 [98616] # --mtr-build-thread=979 \ # 2020-06-18T16:33:52 [98616] # --basedir1=/home/mleich/Server_bin/10.2_debug/ \ # 2020-06-18T16:33:52 [98616] # --basedir2=/home/mleich/Server_bin/10.2_debug/ \ # 2020-06-18T16:33:52 [98616] # --script_debug=_nix_ \ # 2020-06-18T16:33:52 [98616] # --rr=Server \ # 2020-06-18T16:33:52 [98616] # --rr_options=--chaos # 2020-06-18T16:33:52 [98616] INFO: build_thread : 979 # 2020-06-18T16:33:52 [98616] INFO: master_port : 29580 slave_port : 29581 ports : 29580 29581 29582 MTR_BUILD_THREAD : 979 # 2020-06-18T16:33:52 [98616] INFO: rpl_mode was not defined or eq '' and therefore set to 'none'. # 2020-06-18T16:33:52 [98616] INFO: Number of servers involved = 1. (0 means unknown) # 2020-06-18T16:33:52 [98616] INFO: Early RQG basedirs : ->undef<-->/home/mleich/Server_bin/10.2_debug/<-->/home/mleich/Server_bin/10.2_debug/<-->undef<- # 2020-06-18T16:33:52 [98616] DEBUG: $basedirs[0] is not defined or eq ''. Setting it to $basedirs[1] '/home/mleich/Server_bin/10.2_debug/'. # 2020-06-18T16:33:52 [98616] WARN: $basedirs[2] is defined and ne ''. Setting it to undef. # 2020-06-18T16:33:52 [98616] INFO: Final RQG basedirs : ->/home/mleich/Server_bin/10.2_debug/<-->/home/mleich/Server_bin/10.2_debug/<-->undef<-->undef<- # 2020-06-18T16:33:52 [98616] INFO: RQG_HOME '/home/mleich/RQG_mleich' ---------- # 2020-06-18T16:33:52 [98616] DEBUG: 'git --version 2>&1' exited with value 0 # 2020-06-18T16:33:52 [98616] INFO: GIT on $rqg_home('/home/mleich/RQG_mleich') HEAD -> experimental, origin/experimental 611a31e38a3bc157392c0748c95991b6a248bb3b 2020-06-09T15:31:46+02:00 # 2020-06-18T16:33:52 [98616] INFO: basedir[0] : /home/mleich/Server_bin/10.2_debug/ ---- # 2020-06-18T16:33:52 [98616] 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-18T16:33:52 [98616] INFO: Protocol of build '/home/mleich/Server_bin/10.2_debug//build.prt' detected. Extracting some data ... # 2020-06-18T16:33:52 [98616] GIT_SHOW: HEAD, origin/10.2 7710f28eecc3e9761d7431ae7ae4e88564d706dd 2020-06-15T09:29:17+03:00 # 2020-06-18T16:33:52 [98616] MD5SUM of bin_arch.tgz: e21f6b0a6f1935756f44aeaf9dd3077e # 2020-06-18T16:33:52 [98616] INFO: basedir[1] : /home/mleich/Server_bin/10.2_debug/ ---- # 2020-06-18T16:33:52 [98616] 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-18T16:33:52 [98616] INFO: Protocol of build '/home/mleich/Server_bin/10.2_debug//build.prt' detected. Extracting some data ... # 2020-06-18T16:33:52 [98616] GIT_SHOW: HEAD, origin/10.2 7710f28eecc3e9761d7431ae7ae4e88564d706dd 2020-06-15T09:29:17+03:00 # 2020-06-18T16:33:52 [98616] MD5SUM of bin_arch.tgz: e21f6b0a6f1935756f44aeaf9dd3077e # 2020-06-18T16:33:52 [98616] INFO: basedir[2] : ------------------------------ # 2020-06-18T16:33:52 [98616] INFO: Final RQG vardirs : ->/dev/shm/vardir/1592496496/250<-->/dev/shm/vardir/1592496496/250/1<- # 2020-06-18T16:33:52 [98616] tmpdir in GenTest ->/dev/shm/vardir/1592496496/250/<- # 2020-06-18T16:33:52 [98616] tmpdir in DBServer ->/dev/shm/vardir/1592496496/250/<- # 2020-06-18T16:33:52 [98616] INFO: Environment variable _RR_TRACE_DIR set to '/dev/shm/vardir/1592496496/250/rr_trace'. # 2020-06-18T16:33:52 [98616] DEBUG: subdir_list : ->sql<-->libexec<-->bin<-->sbin<- # 2020-06-18T16:33:52 [98616] DEBUG: Basedirs : ->/home/mleich/Server_bin/10.2_debug/<-->/home/mleich/Server_bin/10.2_debug/<-->undef<-->undef<- # 2020-06-18T16:33:52 [98616] DEBUG: debug_server : ->undef<-->undef<-->undef<- # 2020-06-18T16:33:52 [98616] DEBUG: Server binary found : '/home/mleich/Server_bin/10.2_debug//bin/mysqld'. # 2020-06-18T16:33:52 [98616] DEBUG: Server binary found : '/home/mleich/Server_bin/10.2_debug//bin/mysqld'. # 2020-06-18T16:33:52 [98616] INFO: seed eq 'random'. Computation. seed : 21007 # 2020-06-18T16:33:52 [98616] INFO: Final command line: ->perl /home/mleich/RQG_mleich/rqg.pl --redefine=conf/mariadb/general-workarounds.yy --views --vcols --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/xa.yy --grammar=conf/mariadb/functions.yy --reporters=Backtrace,Deadlock1,ErrorLog --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --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 --threads=9 --mysqld=--innodb_page_size=64K --mysqld=--innodb-buffer-pool-size=24M --duration=300 --no_mask --workdir=/home/mleich/RQG_mleich/storage/1592496496/250 --vardir=/dev/shm/vardir/1592496496/250 --mtr-build-thread=979 --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=21007<- # 2020-06-18T16:33:52 [98616] MATCHING: Region start ===================== # 2020-06-18T16:33:52 [98616] DEBUG: rpl_mode is 'none' # 2020-06-18T16:33:52 [98616] DEBUG: max_id is 0 # 2020-06-18T16:33:53 [98616] Creating MySQL 10.2.33 database at /dev/shm/vardir/1592496496/250/1/data # 2020-06-18T16:33:53 [98616] Bootstrap command: cat "/dev/shm/vardir/1592496496/250/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/1592496496/250/1/tmp" "--datadir=/dev/shm/vardir/1592496496/250/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_page_size=64K" "--innodb-buffer-pool-size=24M" "--sql-mode=no_engine_substitution" "--skip-log-bin" "--loose-innodb-encrypt-tables=OFF" "--loose-innodb-encrypt-log=OFF" "--bootstrap" # 2020-06-18T16:33:56 [98616] 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/1592496496/250/1/tmp" "--core-file" "--datadir=/dev/shm/vardir/1592496496/250/1/data" "--max-allowed-packet=128Mb" "--port=29580" "--socket=/dev/shm/vardir/1592496496/250/1/mysql.sock" "--pid-file=/dev/shm/vardir/1592496496/250/1/mysql.pid" "--general-log" "--general-log-file=/dev/shm/vardir/1592496496/250/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_page_size=64K" "--innodb-buffer-pool-size=24M" "--sql-mode=no_engine_substitution" --log_warnings=4 # 2020-06-18T16:33:57 [98616] DEBUG: Server pid found in error log: 99366 # 2020-06-18T16:33:59 [98616] MySQL Version: 10.2.33 # 2020-06-18T16:33:59 [98616] Binary: /home/mleich/Server_bin/10.2_debug//bin/mysqld # 2020-06-18T16:33:59 [98616] Type: Debug # 2020-06-18T16:33:59 [98616] Datadir: /dev/shm/vardir/1592496496/250/1/data # 2020-06-18T16:33:59 [98616] Tmpdir: /dev/shm/vardir/1592496496/250/1/tmp # 2020-06-18T16:33:59 [98616] Corefile: /dev/shm/vardir/1592496496/250/1/data/core.99366 # 2020-06-18T16:33:59 [98616] Connecting to 29580 # 2020-06-18T16:33:59 [98616] SVAR: aria_block_size : 8192 # 2020-06-18T16:33:59 [98616] SVAR: aria_checkpoint_interval : 30 # 2020-06-18T16:33:59 [98616] SVAR: aria_checkpoint_log_activity : 1048576 # 2020-06-18T16:33:59 [98616] SVAR: aria_encrypt_tables : OFF # 2020-06-18T16:33:59 [98616] SVAR: aria_force_start_after_recovery_failures : 0 # 2020-06-18T16:33:59 [98616] SVAR: aria_group_commit : none # 2020-06-18T16:33:59 [98616] SVAR: aria_group_commit_interval : 0 # 2020-06-18T16:33:59 [98616] SVAR: aria_log_file_size : 1073741824 # 2020-06-18T16:33:59 [98616] SVAR: aria_log_purge_type : immediate # 2020-06-18T16:33:59 [98616] SVAR: aria_max_sort_file_size : 9223372036853727232 # 2020-06-18T16:33:59 [98616] SVAR: aria_page_checksum : ON # 2020-06-18T16:33:59 [98616] SVAR: aria_pagecache_age_threshold : 300 # 2020-06-18T16:33:59 [98616] SVAR: aria_pagecache_buffer_size : 134217728 # 2020-06-18T16:33:59 [98616] SVAR: aria_pagecache_division_limit : 100 # 2020-06-18T16:33:59 [98616] SVAR: aria_pagecache_file_hash_size : 512 # 2020-06-18T16:33:59 [98616] SVAR: aria_recover_options : BACKUP,QUICK # 2020-06-18T16:33:59 [98616] SVAR: aria_repair_threads : 1 # 2020-06-18T16:33:59 [98616] SVAR: aria_sort_buffer_size : 268434432 # 2020-06-18T16:33:59 [98616] SVAR: aria_stats_method : nulls_unequal # 2020-06-18T16:33:59 [98616] SVAR: aria_sync_log_dir : NEWFILE # 2020-06-18T16:33:59 [98616] SVAR: aria_used_for_temp_tables : ON # 2020-06-18T16:33:59 [98616] SVAR: auto_increment_increment : 1 # 2020-06-18T16:33:59 [98616] SVAR: auto_increment_offset : 1 # 2020-06-18T16:33:59 [98616] SVAR: autocommit : ON # 2020-06-18T16:33:59 [98616] SVAR: automatic_sp_privileges : ON # 2020-06-18T16:33:59 [98616] SVAR: back_log : 80 # 2020-06-18T16:33:59 [98616] SVAR: basedir : /home/mleich/Server_bin/10.2_debug/ # 2020-06-18T16:33:59 [98616] SVAR: big_tables : OFF # 2020-06-18T16:33:59 [98616] SVAR: binlog_annotate_row_events : ON # 2020-06-18T16:33:59 [98616] SVAR: binlog_cache_size : 32768 # 2020-06-18T16:33:59 [98616] SVAR: binlog_checksum : CRC32 # 2020-06-18T16:33:59 [98616] SVAR: binlog_commit_wait_count : 0 # 2020-06-18T16:33:59 [98616] SVAR: binlog_commit_wait_usec : 100000 # 2020-06-18T16:33:59 [98616] SVAR: binlog_direct_non_transactional_updates : OFF # 2020-06-18T16:33:59 [98616] SVAR: binlog_format : MIXED # 2020-06-18T16:33:59 [98616] SVAR: binlog_optimize_thread_scheduling : ON # 2020-06-18T16:33:59 [98616] SVAR: binlog_row_image : FULL # 2020-06-18T16:33:59 [98616] SVAR: binlog_stmt_cache_size : 32768 # 2020-06-18T16:33:59 [98616] SVAR: bulk_insert_buffer_size : 8388608 # 2020-06-18T16:33:59 [98616] SVAR: character_set_client : latin1 # 2020-06-18T16:33:59 [98616] SVAR: character_set_connection : latin1 # 2020-06-18T16:33:59 [98616] SVAR: character_set_database : latin1 # 2020-06-18T16:33:59 [98616] SVAR: character_set_filesystem : binary # 2020-06-18T16:33:59 [98616] SVAR: character_set_results : latin1 # 2020-06-18T16:33:59 [98616] SVAR: character_set_server : latin1 # 2020-06-18T16:33:59 [98616] SVAR: character_set_system : utf8 # 2020-06-18T16:33:59 [98616] SVAR: character_sets_dir : /home/mleich/Server_bin/10.2_debug//share/charsets/ # 2020-06-18T16:33:59 [98616] SVAR: check_constraint_checks : ON # 2020-06-18T16:33:59 [98616] SVAR: collation_connection : latin1_swedish_ci # 2020-06-18T16:33:59 [98616] SVAR: collation_database : latin1_swedish_ci # 2020-06-18T16:33:59 [98616] SVAR: collation_server : latin1_swedish_ci # 2020-06-18T16:33:59 [98616] SVAR: completion_type : NO_CHAIN # 2020-06-18T16:33:59 [98616] SVAR: concurrent_insert : AUTO # 2020-06-18T16:33:59 [98616] SVAR: connect_timeout : 60 # 2020-06-18T16:33:59 [98616] SVAR: core_file : ON # 2020-06-18T16:33:59 [98616] SVAR: datadir : /dev/shm/vardir/1592496496/250/1/data/ # 2020-06-18T16:33:59 [98616] SVAR: date_format : %Y-%m-%d # 2020-06-18T16:33:59 [98616] SVAR: datetime_format : %Y-%m-%d %H:%i:%s # 2020-06-18T16:33:59 [98616] SVAR: deadlock_search_depth_long : 15 # 2020-06-18T16:33:59 [98616] SVAR: deadlock_search_depth_short : 4 # 2020-06-18T16:33:59 [98616] SVAR: deadlock_timeout_long : 50000000 # 2020-06-18T16:33:59 [98616] SVAR: deadlock_timeout_short : 10000 # 2020-06-18T16:33:59 [98616] SVAR: debug : # 2020-06-18T16:33:59 [98616] SVAR: debug_binlog_fsync_sleep : 0 # 2020-06-18T16:33:59 [98616] SVAR: debug_dbug : # 2020-06-18T16:33:59 [98616] SVAR: debug_mutex_deadlock_detector : ON # 2020-06-18T16:33:59 [98616] SVAR: debug_no_thread_alarm : OFF # 2020-06-18T16:33:59 [98616] SVAR: debug_sync : OFF # 2020-06-18T16:33:59 [98616] SVAR: default_master_connection : # 2020-06-18T16:33:59 [98616] SVAR: default_regex_flags : # 2020-06-18T16:33:59 [98616] SVAR: default_storage_engine : InnoDB # 2020-06-18T16:33:59 [98616] SVAR: default_tmp_storage_engine : # 2020-06-18T16:33:59 [98616] SVAR: default_week_format : 0 # 2020-06-18T16:33:59 [98616] SVAR: delay_key_write : ON # 2020-06-18T16:33:59 [98616] SVAR: delayed_insert_limit : 100 # 2020-06-18T16:33:59 [98616] SVAR: delayed_insert_timeout : 300 # 2020-06-18T16:33:59 [98616] SVAR: delayed_queue_size : 1000 # 2020-06-18T16:33:59 [98616] SVAR: div_precision_increment : 4 # 2020-06-18T16:33:59 [98616] SVAR: encrypt_binlog : OFF # 2020-06-18T16:33:59 [98616] SVAR: encrypt_tmp_disk_tables : OFF # 2020-06-18T16:33:59 [98616] SVAR: encrypt_tmp_files : OFF # 2020-06-18T16:33:59 [98616] SVAR: enforce_storage_engine : # 2020-06-18T16:33:59 [98616] SVAR: eq_range_index_dive_limit : 0 # 2020-06-18T16:33:59 [98616] SVAR: error_count : 0 # 2020-06-18T16:33:59 [98616] SVAR: event_scheduler : OFF # 2020-06-18T16:33:59 [98616] SVAR: expensive_subquery_limit : 100 # 2020-06-18T16:33:59 [98616] SVAR: expire_logs_days : 0 # 2020-06-18T16:33:59 [98616] SVAR: explicit_defaults_for_timestamp : OFF # 2020-06-18T16:33:59 [98616] SVAR: external_user : # 2020-06-18T16:33:59 [98616] SVAR: extra_max_connections : 1 # 2020-06-18T16:33:59 [98616] SVAR: extra_port : 0 # 2020-06-18T16:33:59 [98616] SVAR: flush : OFF # 2020-06-18T16:33:59 [98616] SVAR: flush_time : 0 # 2020-06-18T16:33:59 [98616] SVAR: foreign_key_checks : ON # 2020-06-18T16:33:59 [98616] SVAR: ft_boolean_syntax : + -><()~*:""&| # 2020-06-18T16:33:59 [98616] SVAR: ft_max_word_len : 84 # 2020-06-18T16:33:59 [98616] SVAR: ft_min_word_len : 4 # 2020-06-18T16:33:59 [98616] SVAR: ft_query_expansion_limit : 20 # 2020-06-18T16:33:59 [98616] SVAR: ft_stopword_file : (built-in) # 2020-06-18T16:33:59 [98616] SVAR: general_log : ON # 2020-06-18T16:33:59 [98616] SVAR: general_log_file : /dev/shm/vardir/1592496496/250/1/mysql.log # 2020-06-18T16:33:59 [98616] SVAR: group_concat_max_len : 1048576 # 2020-06-18T16:33:59 [98616] SVAR: gtid_binlog_pos : # 2020-06-18T16:33:59 [98616] SVAR: gtid_binlog_state : # 2020-06-18T16:33:59 [98616] SVAR: gtid_current_pos : # 2020-06-18T16:33:59 [98616] SVAR: gtid_domain_id : 0 # 2020-06-18T16:33:59 [98616] SVAR: gtid_ignore_duplicates : OFF # 2020-06-18T16:33:59 [98616] SVAR: gtid_seq_no : 0 # 2020-06-18T16:33:59 [98616] SVAR: gtid_slave_pos : # 2020-06-18T16:33:59 [98616] SVAR: gtid_strict_mode : OFF # 2020-06-18T16:33:59 [98616] SVAR: have_compress : YES # 2020-06-18T16:33:59 [98616] SVAR: have_crypt : YES # 2020-06-18T16:33:59 [98616] SVAR: have_dynamic_loading : YES # 2020-06-18T16:33:59 [98616] SVAR: have_geometry : YES # 2020-06-18T16:33:59 [98616] SVAR: have_openssl : NO # 2020-06-18T16:33:59 [98616] SVAR: have_profiling : YES # 2020-06-18T16:33:59 [98616] SVAR: have_query_cache : YES # 2020-06-18T16:33:59 [98616] SVAR: have_rtree_keys : YES # 2020-06-18T16:33:59 [98616] SVAR: have_ssl : DISABLED # 2020-06-18T16:33:59 [98616] SVAR: have_symlink : YES # 2020-06-18T16:33:59 [98616] SVAR: histogram_size : 0 # 2020-06-18T16:33:59 [98616] SVAR: histogram_type : SINGLE_PREC_HB # 2020-06-18T16:33:59 [98616] SVAR: host_cache_size : 279 # 2020-06-18T16:33:59 [98616] SVAR: hostname : sdp # 2020-06-18T16:33:59 [98616] SVAR: identity : 0 # 2020-06-18T16:33:59 [98616] SVAR: ignore_builtin_innodb : OFF # 2020-06-18T16:33:59 [98616] SVAR: ignore_db_dirs : # 2020-06-18T16:33:59 [98616] SVAR: in_transaction : 0 # 2020-06-18T16:33:59 [98616] SVAR: init_connect : # 2020-06-18T16:33:59 [98616] SVAR: init_file : # 2020-06-18T16:33:59 [98616] SVAR: init_slave : # 2020-06-18T16:33:59 [98616] SVAR: innodb_adaptive_flushing : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_adaptive_flushing_lwm : 10.000000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_adaptive_hash_index : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_adaptive_hash_index_partitions : 8 # 2020-06-18T16:33:59 [98616] SVAR: innodb_adaptive_hash_index_parts : 8 # 2020-06-18T16:33:59 [98616] SVAR: innodb_adaptive_max_sleep_delay : 150000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_autoextend_increment : 64 # 2020-06-18T16:33:59 [98616] SVAR: innodb_autoinc_lock_mode : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_background_drop_list_empty : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_background_scrub_data_check_interval : 3600 # 2020-06-18T16:33:59 [98616] SVAR: innodb_background_scrub_data_compressed : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_background_scrub_data_interval : 604800 # 2020-06-18T16:33:59 [98616] SVAR: innodb_background_scrub_data_uncompressed : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_buf_dump_status_frequency : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_buf_flush_list_now : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_chunk_size : 25165824 # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_dump_at_shutdown : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_dump_now : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_dump_pct : 25 # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_evict : # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_filename : ib_buffer_pool # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_instances : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_load_abort : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_load_at_startup : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_load_now : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_populate : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_buffer_pool_size : 25165824 # 2020-06-18T16:33:59 [98616] SVAR: innodb_change_buffer_dump : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_change_buffer_max_size : 25 # 2020-06-18T16:33:59 [98616] SVAR: innodb_change_buffering : all # 2020-06-18T16:33:59 [98616] SVAR: innodb_change_buffering_debug : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_checksum_algorithm : crc32 # 2020-06-18T16:33:59 [98616] SVAR: innodb_checksums : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_eviction_factor : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_flush_chunk_size : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_free_list_lwm : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_lru_chunk_size : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_lsn_age_factor : DEPRECATED # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_max_flush_time : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_cleaner_max_lru_time : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_cmp_per_index_enabled : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_commit_concurrency : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_compression_algorithm : zlib # 2020-06-18T16:33:59 [98616] SVAR: innodb_compression_default : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_compression_failure_threshold_pct : 5 # 2020-06-18T16:33:59 [98616] SVAR: innodb_compression_level : 6 # 2020-06-18T16:33:59 [98616] SVAR: innodb_compression_pad_pct_max : 50 # 2020-06-18T16:33:59 [98616] SVAR: innodb_concurrency_tickets : 5000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_corrupt_table_action : deprecated # 2020-06-18T16:33:59 [98616] SVAR: innodb_data_file_path : ibdata1:12M:autoextend # 2020-06-18T16:33:59 [98616] SVAR: innodb_data_file_size_debug : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_data_home_dir : # 2020-06-18T16:33:59 [98616] SVAR: innodb_deadlock_detect : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_debug_force_scrubbing : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_default_encryption_key_id : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_default_row_format : dynamic # 2020-06-18T16:33:59 [98616] SVAR: innodb_defragment : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_defragment_fill_factor : 0.900000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_defragment_fill_factor_n_recs : 20 # 2020-06-18T16:33:59 [98616] SVAR: innodb_defragment_frequency : 40 # 2020-06-18T16:33:59 [98616] SVAR: innodb_defragment_n_pages : 7 # 2020-06-18T16:33:59 [98616] SVAR: innodb_defragment_stats_accuracy : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_dict_stats_disabled_debug : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_disable_background_merge : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_disable_resize_buffer_pool_debug : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_disable_sort_file_cache : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_disallow_writes : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_doublewrite : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_doublewrite_batch_size : 120 # 2020-06-18T16:33:59 [98616] SVAR: innodb_empty_free_list_algorithm : DEPRECATED # 2020-06-18T16:33:59 [98616] SVAR: innodb_encrypt_log : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_encrypt_tables : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_encrypt_temporary_tables : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_encryption_rotate_key_age : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_encryption_rotation_iops : 100 # 2020-06-18T16:33:59 [98616] SVAR: innodb_encryption_threads : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_fake_changes : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_fast_shutdown : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_fatal_semaphore_wait_threshold : 600 # 2020-06-18T16:33:59 [98616] SVAR: innodb_fil_make_page_dirty_debug : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_file_format : Barracuda # 2020-06-18T16:33:59 [98616] SVAR: innodb_file_format_check : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_file_format_max : Barracuda # 2020-06-18T16:33:59 [98616] SVAR: innodb_file_per_table : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_fill_factor : 100 # 2020-06-18T16:33:59 [98616] SVAR: innodb_flush_log_at_timeout : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_flush_log_at_trx_commit : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_flush_method : # 2020-06-18T16:33:59 [98616] SVAR: innodb_flush_neighbors : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_flush_sync : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_flushing_avg_loops : 30 # 2020-06-18T16:33:59 [98616] SVAR: innodb_force_load_corrupted : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_force_primary_key : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_force_recovery : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_foreground_preflush : DEPRECATED # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_aux_table : # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_cache_size : 8000000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_enable_diag_print : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_enable_stopword : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_max_token_size : 84 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_min_token_size : 3 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_num_word_optimize : 2000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_result_cache_limit : 2000000000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_server_stopword_table : # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_sort_pll_degree : 2 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_total_cache_size : 640000000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_ft_user_stopword_table : # 2020-06-18T16:33:59 [98616] SVAR: innodb_idle_flush_pct : 100 # 2020-06-18T16:33:59 [98616] SVAR: innodb_immediate_scrub_data_uncompressed : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_instrument_semaphores : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_io_capacity : 200 # 2020-06-18T16:33:59 [98616] SVAR: innodb_io_capacity_max : 2000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_kill_idle_transaction : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_large_prefix : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_limit_optimistic_insert_debug : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_lock_schedule_algorithm : fcfs # 2020-06-18T16:33:59 [98616] SVAR: innodb_lock_wait_timeout : 50 # 2020-06-18T16:33:59 [98616] SVAR: innodb_locking_fake_changes : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_locks_unsafe_for_binlog : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_arch_dir : # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_arch_expire_sec : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_archive : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_block_size : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_buffer_size : 16777216 # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_checkpoint_now : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_checksum_algorithm : DEPRECATED # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_checksums : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_compressed_pages : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_file_size : 50331648 # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_files_in_group : 2 # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_group_home_dir : ./ # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_optimize_ddl : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_log_write_ahead_size : 8192 # 2020-06-18T16:33:59 [98616] SVAR: innodb_lru_scan_depth : 1024 # 2020-06-18T16:33:59 [98616] SVAR: innodb_master_thread_disabled_debug : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_bitmap_file_size : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_changed_pages : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_dirty_pages_pct : 75.000000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_dirty_pages_pct_lwm : 0.000000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_purge_lag : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_purge_lag_delay : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_max_undo_log_size : 41943040 # 2020-06-18T16:33:59 [98616] SVAR: innodb_merge_threshold_set_all_debug : 50 # 2020-06-18T16:33:59 [98616] SVAR: innodb_mirrored_log_groups : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_monitor_disable : # 2020-06-18T16:33:59 [98616] SVAR: innodb_monitor_enable : # 2020-06-18T16:33:59 [98616] SVAR: innodb_monitor_reset : # 2020-06-18T16:33:59 [98616] SVAR: innodb_monitor_reset_all : # 2020-06-18T16:33:59 [98616] SVAR: innodb_mtflush_threads : 8 # 2020-06-18T16:33:59 [98616] SVAR: innodb_old_blocks_pct : 37 # 2020-06-18T16:33:59 [98616] SVAR: innodb_old_blocks_time : 1000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_online_alter_log_max_size : 134217728 # 2020-06-18T16:33:59 [98616] SVAR: innodb_open_files : 2000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_optimize_fulltext_only : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_page_cleaner_disabled_debug : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_page_cleaners : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_page_hash_locks : 16 # 2020-06-18T16:33:59 [98616] SVAR: innodb_page_size : 65536 # 2020-06-18T16:33:59 [98616] SVAR: innodb_prefix_index_cluster_optimization : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_print_all_deadlocks : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_priority_cleaner : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_priority_io : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_priority_master : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_priority_purge : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_purge_batch_size : 300 # 2020-06-18T16:33:59 [98616] SVAR: innodb_purge_rseg_truncate_frequency : 128 # 2020-06-18T16:33:59 [98616] SVAR: innodb_purge_threads : 4 # 2020-06-18T16:33:59 [98616] SVAR: innodb_random_read_ahead : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_read_ahead_threshold : 56 # 2020-06-18T16:33:59 [98616] SVAR: innodb_read_io_threads : 4 # 2020-06-18T16:33:59 [98616] SVAR: innodb_read_only : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_replication_delay : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_rollback_on_timeout : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_rollback_segments : 128 # 2020-06-18T16:33:59 [98616] SVAR: innodb_safe_truncate : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_saved_page_number_debug : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_sched_priority_cleaner : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_sched_priority_io : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_sched_priority_master : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_sched_priority_purge : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_scrub_log : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_scrub_log_speed : 256 # 2020-06-18T16:33:59 [98616] SVAR: innodb_show_locks_held : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_show_verbose_locks : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_simulate_comp_failures : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_sort_buffer_size : 1048576 # 2020-06-18T16:33:59 [98616] SVAR: innodb_spin_wait_delay : 4 # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_auto_recalc : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_include_delete_marked : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_method : nulls_equal # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_modified_counter : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_on_metadata : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_persistent : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_persistent_sample_pages : 20 # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_sample_pages : 8 # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_traditional : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_stats_transient_sample_pages : 8 # 2020-06-18T16:33:59 [98616] SVAR: innodb_status_output : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_status_output_locks : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_strict_mode : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_support_xa : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_sync_array_size : 1 # 2020-06-18T16:33:59 [98616] SVAR: innodb_sync_debug : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_sync_spin_loops : 30 # 2020-06-18T16:33:59 [98616] SVAR: innodb_table_locks : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_temp_data_file_path : ibtmp1:12M:autoextend # 2020-06-18T16:33:59 [98616] SVAR: innodb_thread_concurrency : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_thread_sleep_delay : 10000 # 2020-06-18T16:33:59 [98616] SVAR: innodb_tmpdir : # 2020-06-18T16:33:59 [98616] SVAR: innodb_track_changed_pages : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_track_redo_log_now : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_trx_purge_view_update_only_debug : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_trx_rseg_n_slots_debug : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_undo_directory : ./ # 2020-06-18T16:33:59 [98616] SVAR: innodb_undo_log_truncate : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_undo_logs : 128 # 2020-06-18T16:33:59 [98616] SVAR: innodb_undo_tablespaces : 0 # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_atomic_writes : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_fallocate : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_global_flush_log_at_trx_commit : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_mtflush : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_native_aio : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_stacktrace : OFF # 2020-06-18T16:33:59 [98616] SVAR: innodb_use_trim : ON # 2020-06-18T16:33:59 [98616] SVAR: innodb_version : 5.7.30 # 2020-06-18T16:33:59 [98616] SVAR: innodb_write_io_threads : 4 # 2020-06-18T16:33:59 [98616] SVAR: insert_id : 0 # 2020-06-18T16:33:59 [98616] SVAR: interactive_timeout : 28800 # 2020-06-18T16:33:59 [98616] SVAR: join_buffer_size : 262144 # 2020-06-18T16:33:59 [98616] SVAR: join_buffer_space_limit : 2097152 # 2020-06-18T16:33:59 [98616] SVAR: join_cache_level : 2 # 2020-06-18T16:33:59 [98616] SVAR: keep_files_on_create : OFF # 2020-06-18T16:33:59 [98616] SVAR: key_buffer_size : 134217728 # 2020-06-18T16:33:59 [98616] SVAR: key_cache_age_threshold : 300 # 2020-06-18T16:33:59 [98616] SVAR: key_cache_block_size : 1024 # 2020-06-18T16:33:59 [98616] SVAR: key_cache_division_limit : 100 # 2020-06-18T16:33:59 [98616] SVAR: key_cache_file_hash_size : 512 # 2020-06-18T16:33:59 [98616] SVAR: key_cache_segments : 0 # 2020-06-18T16:33:59 [98616] SVAR: large_files_support : ON # 2020-06-18T16:33:59 [98616] SVAR: large_page_size : 0 # 2020-06-18T16:33:59 [98616] SVAR: large_pages : OFF # 2020-06-18T16:33:59 [98616] SVAR: last_gtid : # 2020-06-18T16:33:59 [98616] SVAR: last_insert_id : 0 # 2020-06-18T16:33:59 [98616] SVAR: lc_messages : en_US # 2020-06-18T16:33:59 [98616] SVAR: lc_messages_dir : /home/mleich/Server_bin/10.2_debug//share # 2020-06-18T16:33:59 [98616] SVAR: lc_time_names : en_US # 2020-06-18T16:33:59 [98616] SVAR: license : GPL # 2020-06-18T16:33:59 [98616] SVAR: local_infile : ON # 2020-06-18T16:33:59 [98616] SVAR: lock_wait_timeout : 86400 # 2020-06-18T16:33:59 [98616] SVAR: locked_in_memory : OFF # 2020-06-18T16:33:59 [98616] SVAR: log_bin : ON # 2020-06-18T16:33:59 [98616] SVAR: log_bin_basename : /dev/shm/vardir/1592496496/250/1/data/mysql-bin # 2020-06-18T16:33:59 [98616] SVAR: log_bin_compress : OFF # 2020-06-18T16:33:59 [98616] SVAR: log_bin_compress_min_len : 256 # 2020-06-18T16:33:59 [98616] SVAR: log_bin_index : /dev/shm/vardir/1592496496/250/1/data/mysql-bin.index # 2020-06-18T16:33:59 [98616] SVAR: log_bin_trust_function_creators : ON # 2020-06-18T16:33:59 [98616] SVAR: log_error : # 2020-06-18T16:33:59 [98616] SVAR: log_output : NONE # 2020-06-18T16:33:59 [98616] SVAR: log_queries_not_using_indexes : OFF # 2020-06-18T16:33:59 [98616] SVAR: log_slave_updates : OFF # 2020-06-18T16:33:59 [98616] SVAR: log_slow_admin_statements : ON # 2020-06-18T16:33:59 [98616] 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-18T16:33:59 [98616] SVAR: log_slow_rate_limit : 1 # 2020-06-18T16:33:59 [98616] SVAR: log_slow_slave_statements : ON # 2020-06-18T16:33:59 [98616] SVAR: log_slow_verbosity : # 2020-06-18T16:33:59 [98616] SVAR: log_tc_size : 24576 # 2020-06-18T16:33:59 [98616] SVAR: log_warnings : 4 # 2020-06-18T16:33:59 [98616] SVAR: long_query_time : 10.000000 # 2020-06-18T16:33:59 [98616] SVAR: low_priority_updates : OFF # 2020-06-18T16:33:59 [98616] SVAR: lower_case_file_system : OFF # 2020-06-18T16:33:59 [98616] SVAR: lower_case_table_names : 0 # 2020-06-18T16:33:59 [98616] SVAR: master_verify_checksum : OFF # 2020-06-18T16:33:59 [98616] SVAR: max_allowed_packet : 134217728 # 2020-06-18T16:33:59 [98616] SVAR: max_binlog_cache_size : 18446744073709547520 # 2020-06-18T16:33:59 [98616] SVAR: max_binlog_size : 1073741824 # 2020-06-18T16:33:59 [98616] SVAR: max_binlog_stmt_cache_size : 18446744073709547520 # 2020-06-18T16:33:59 [98616] SVAR: max_connect_errors : 100 # 2020-06-18T16:33:59 [98616] SVAR: max_connections : 151 # 2020-06-18T16:33:59 [98616] SVAR: max_delayed_threads : 20 # 2020-06-18T16:33:59 [98616] SVAR: max_digest_length : 1024 # 2020-06-18T16:33:59 [98616] SVAR: max_error_count : 64 # 2020-06-18T16:33:59 [98616] SVAR: max_heap_table_size : 16777216 # 2020-06-18T16:33:59 [98616] SVAR: max_insert_delayed_threads : 20 # 2020-06-18T16:33:59 [98616] SVAR: max_join_size : 18446744073709551615 # 2020-06-18T16:33:59 [98616] SVAR: max_length_for_sort_data : 1024 # 2020-06-18T16:33:59 [98616] SVAR: max_long_data_size : 134217728 # 2020-06-18T16:33:59 [98616] SVAR: max_prepared_stmt_count : 16382 # 2020-06-18T16:33:59 [98616] SVAR: max_recursive_iterations : 4294967295 # 2020-06-18T16:33:59 [98616] SVAR: max_relay_log_size : 1073741824 # 2020-06-18T16:33:59 [98616] SVAR: max_seeks_for_key : 4294967295 # 2020-06-18T16:33:59 [98616] SVAR: max_session_mem_used : 9223372036854775807 # 2020-06-18T16:33:59 [98616] SVAR: max_sort_length : 1024 # 2020-06-18T16:33:59 [98616] SVAR: max_sp_recursion_depth : 0 # 2020-06-18T16:33:59 [98616] SVAR: max_statement_time : 30.000000 # 2020-06-18T16:33:59 [98616] SVAR: max_tmp_tables : 32 # 2020-06-18T16:33:59 [98616] SVAR: max_user_connections : 0 # 2020-06-18T16:33:59 [98616] SVAR: max_write_lock_count : 4294967295 # 2020-06-18T16:33:59 [98616] SVAR: metadata_locks_cache_size : 1024 # 2020-06-18T16:33:59 [98616] SVAR: metadata_locks_hash_instances : 8 # 2020-06-18T16:33:59 [98616] SVAR: min_examined_row_limit : 0 # 2020-06-18T16:33:59 [98616] SVAR: mrr_buffer_size : 262144 # 2020-06-18T16:33:59 [98616] SVAR: multi_range_count : 256 # 2020-06-18T16:33:59 [98616] SVAR: myisam_block_size : 1024 # 2020-06-18T16:33:59 [98616] SVAR: myisam_data_pointer_size : 6 # 2020-06-18T16:33:59 [98616] SVAR: myisam_max_sort_file_size : 9223372036853727232 # 2020-06-18T16:33:59 [98616] SVAR: myisam_mmap_size : 18446744073709551615 # 2020-06-18T16:33:59 [98616] SVAR: myisam_recover_options : BACKUP,QUICK # 2020-06-18T16:33:59 [98616] SVAR: myisam_repair_threads : 1 # 2020-06-18T16:33:59 [98616] SVAR: myisam_sort_buffer_size : 134216704 # 2020-06-18T16:33:59 [98616] SVAR: myisam_stats_method : NULLS_UNEQUAL # 2020-06-18T16:33:59 [98616] SVAR: myisam_use_mmap : OFF # 2020-06-18T16:33:59 [98616] SVAR: mysql56_temporal_format : ON # 2020-06-18T16:33:59 [98616] SVAR: net_buffer_length : 16384 # 2020-06-18T16:33:59 [98616] SVAR: net_read_timeout : 30 # 2020-06-18T16:33:59 [98616] SVAR: net_retry_count : 10 # 2020-06-18T16:33:59 [98616] SVAR: net_write_timeout : 60 # 2020-06-18T16:33:59 [98616] SVAR: old : OFF # 2020-06-18T16:33:59 [98616] SVAR: old_alter_table : OFF # 2020-06-18T16:33:59 [98616] SVAR: old_mode : # 2020-06-18T16:33:59 [98616] SVAR: old_passwords : OFF # 2020-06-18T16:33:59 [98616] SVAR: open_files_limit : 10240 # 2020-06-18T16:33:59 [98616] SVAR: optimizer_prune_level : 1 # 2020-06-18T16:33:59 [98616] SVAR: optimizer_search_depth : 62 # 2020-06-18T16:33:59 [98616] SVAR: optimizer_selectivity_sampling_limit : 100 # 2020-06-18T16:33:59 [98616] 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-18T16:33:59 [98616] SVAR: optimizer_use_condition_selectivity : 1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema : OFF # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_accounts_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_digests_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_events_stages_history_long_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_events_stages_history_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_events_statements_history_long_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_events_statements_history_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_events_waits_history_long_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_events_waits_history_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_hosts_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_cond_classes : 80 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_cond_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_digest_length : 1024 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_file_classes : 50 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_file_handles : 32768 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_file_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_mutex_classes : 200 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_mutex_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_rwlock_classes : 40 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_rwlock_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_socket_classes : 10 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_socket_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_stage_classes : 150 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_statement_classes : 188 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_table_handles : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_table_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_thread_classes : 50 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_max_thread_instances : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_session_connect_attrs_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_setup_actors_size : 100 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_setup_objects_size : 100 # 2020-06-18T16:33:59 [98616] SVAR: performance_schema_users_size : -1 # 2020-06-18T16:33:59 [98616] SVAR: pid_file : /dev/shm/vardir/1592496496/250/1/mysql.pid # 2020-06-18T16:33:59 [98616] SVAR: plugin_dir : /home/mleich/Server_bin/10.2_debug/lib/plugin/ # 2020-06-18T16:33:59 [98616] SVAR: plugin_maturity : unknown # 2020-06-18T16:33:59 [98616] SVAR: port : 29580 # 2020-06-18T16:33:59 [98616] SVAR: preload_buffer_size : 32768 # 2020-06-18T16:33:59 [98616] SVAR: profiling : OFF # 2020-06-18T16:33:59 [98616] SVAR: profiling_history_size : 15 # 2020-06-18T16:33:59 [98616] SVAR: progress_report_time : 5 # 2020-06-18T16:33:59 [98616] SVAR: protocol_version : 10 # 2020-06-18T16:33:59 [98616] SVAR: proxy_user : # 2020-06-18T16:33:59 [98616] SVAR: pseudo_slave_mode : OFF # 2020-06-18T16:33:59 [98616] SVAR: pseudo_thread_id : 9 # 2020-06-18T16:33:59 [98616] SVAR: query_alloc_block_size : 16384 # 2020-06-18T16:33:59 [98616] SVAR: query_cache_limit : 1048576 # 2020-06-18T16:33:59 [98616] SVAR: query_cache_min_res_unit : 4096 # 2020-06-18T16:33:59 [98616] SVAR: query_cache_size : 1048576 # 2020-06-18T16:33:59 [98616] SVAR: query_cache_strip_comments : OFF # 2020-06-18T16:33:59 [98616] SVAR: query_cache_type : OFF # 2020-06-18T16:33:59 [98616] SVAR: query_cache_wlock_invalidate : OFF # 2020-06-18T16:33:59 [98616] SVAR: query_prealloc_size : 24576 # 2020-06-18T16:33:59 [98616] SVAR: rand_seed1 : 914251966 # 2020-06-18T16:33:59 [98616] SVAR: rand_seed2 : 627112715 # 2020-06-18T16:33:59 [98616] SVAR: range_alloc_block_size : 4096 # 2020-06-18T16:33:59 [98616] SVAR: read_binlog_speed_limit : 0 # 2020-06-18T16:33:59 [98616] SVAR: read_buffer_size : 131072 # 2020-06-18T16:33:59 [98616] SVAR: read_only : OFF # 2020-06-18T16:33:59 [98616] SVAR: read_rnd_buffer_size : 262144 # 2020-06-18T16:33:59 [98616] SVAR: relay_log : # 2020-06-18T16:33:59 [98616] SVAR: relay_log_basename : # 2020-06-18T16:33:59 [98616] SVAR: relay_log_index : # 2020-06-18T16:33:59 [98616] SVAR: relay_log_info_file : relay-log.info # 2020-06-18T16:33:59 [98616] SVAR: relay_log_purge : ON # 2020-06-18T16:33:59 [98616] SVAR: relay_log_recovery : OFF # 2020-06-18T16:33:59 [98616] SVAR: relay_log_space_limit : 0 # 2020-06-18T16:33:59 [98616] SVAR: replicate_annotate_row_events : ON # 2020-06-18T16:33:59 [98616] SVAR: replicate_do_db : # 2020-06-18T16:33:59 [98616] SVAR: replicate_do_table : # 2020-06-18T16:33:59 [98616] SVAR: replicate_events_marked_for_skip : REPLICATE # 2020-06-18T16:33:59 [98616] SVAR: replicate_ignore_db : # 2020-06-18T16:33:59 [98616] SVAR: replicate_ignore_table : # 2020-06-18T16:33:59 [98616] SVAR: replicate_wild_do_table : # 2020-06-18T16:33:59 [98616] SVAR: replicate_wild_ignore_table : # 2020-06-18T16:33:59 [98616] SVAR: report_host : # 2020-06-18T16:33:59 [98616] SVAR: report_password : # 2020-06-18T16:33:59 [98616] SVAR: report_port : 29580 # 2020-06-18T16:33:59 [98616] SVAR: report_user : # 2020-06-18T16:33:59 [98616] SVAR: rowid_merge_buff_size : 8388608 # 2020-06-18T16:33:59 [98616] SVAR: secure_auth : ON # 2020-06-18T16:33:59 [98616] SVAR: secure_file_priv : # 2020-06-18T16:33:59 [98616] SVAR: server_id : 1 # 2020-06-18T16:33:59 [98616] SVAR: session_track_schema : ON # 2020-06-18T16:33:59 [98616] SVAR: session_track_state_change : OFF # 2020-06-18T16:33:59 [98616] SVAR: session_track_system_variables : # 2020-06-18T16:33:59 [98616] SVAR: session_track_transaction_info : OFF # 2020-06-18T16:33:59 [98616] SVAR: skip_external_locking : ON # 2020-06-18T16:33:59 [98616] SVAR: skip_name_resolve : OFF # 2020-06-18T16:33:59 [98616] SVAR: skip_networking : OFF # 2020-06-18T16:33:59 [98616] SVAR: skip_parallel_replication : OFF # 2020-06-18T16:33:59 [98616] SVAR: skip_replication : OFF # 2020-06-18T16:33:59 [98616] SVAR: skip_show_database : OFF # 2020-06-18T16:33:59 [98616] SVAR: slave_compressed_protocol : OFF # 2020-06-18T16:33:59 [98616] SVAR: slave_ddl_exec_mode : IDEMPOTENT # 2020-06-18T16:33:59 [98616] SVAR: slave_domain_parallel_threads : 0 # 2020-06-18T16:33:59 [98616] SVAR: slave_exec_mode : STRICT # 2020-06-18T16:33:59 [98616] SVAR: slave_load_tmpdir : /dev/shm/vardir/1592496496/250/1/tmp # 2020-06-18T16:33:59 [98616] SVAR: slave_max_allowed_packet : 1073741824 # 2020-06-18T16:33:59 [98616] SVAR: slave_net_timeout : 60 # 2020-06-18T16:33:59 [98616] SVAR: slave_parallel_max_queued : 131072 # 2020-06-18T16:33:59 [98616] SVAR: slave_parallel_mode : conservative # 2020-06-18T16:33:59 [98616] SVAR: slave_parallel_threads : 0 # 2020-06-18T16:33:59 [98616] SVAR: slave_parallel_workers : 0 # 2020-06-18T16:33:59 [98616] SVAR: slave_run_triggers_for_rbr : NO # 2020-06-18T16:33:59 [98616] SVAR: slave_skip_errors : OFF # 2020-06-18T16:33:59 [98616] SVAR: slave_sql_verify_checksum : ON # 2020-06-18T16:33:59 [98616] SVAR: slave_transaction_retries : 10 # 2020-06-18T16:33:59 [98616] SVAR: slave_type_conversions : # 2020-06-18T16:33:59 [98616] SVAR: slow_launch_time : 2 # 2020-06-18T16:33:59 [98616] SVAR: slow_query_log : OFF # 2020-06-18T16:33:59 [98616] SVAR: slow_query_log_file : sdp-slow.log # 2020-06-18T16:33:59 [98616] SVAR: socket : /dev/shm/vardir/1592496496/250/1/mysql.sock # 2020-06-18T16:33:59 [98616] SVAR: sort_buffer_size : 2097152 # 2020-06-18T16:33:59 [98616] SVAR: sql_auto_is_null : OFF # 2020-06-18T16:33:59 [98616] SVAR: sql_big_selects : ON # 2020-06-18T16:33:59 [98616] SVAR: sql_buffer_result : OFF # 2020-06-18T16:33:59 [98616] SVAR: sql_log_bin : ON # 2020-06-18T16:33:59 [98616] SVAR: sql_log_off : OFF # 2020-06-18T16:33:59 [98616] SVAR: sql_mode : NO_ENGINE_SUBSTITUTION # 2020-06-18T16:33:59 [98616] SVAR: sql_notes : ON # 2020-06-18T16:33:59 [98616] SVAR: sql_quote_show_create : ON # 2020-06-18T16:33:59 [98616] SVAR: sql_safe_updates : OFF # 2020-06-18T16:33:59 [98616] SVAR: sql_select_limit : 18446744073709551615 # 2020-06-18T16:33:59 [98616] SVAR: sql_slave_skip_counter : 0 # 2020-06-18T16:33:59 [98616] SVAR: sql_warnings : OFF # 2020-06-18T16:33:59 [98616] SVAR: ssl_ca : # 2020-06-18T16:33:59 [98616] SVAR: ssl_capath : # 2020-06-18T16:33:59 [98616] SVAR: ssl_cert : # 2020-06-18T16:33:59 [98616] SVAR: ssl_cipher : # 2020-06-18T16:33:59 [98616] SVAR: ssl_crl : # 2020-06-18T16:33:59 [98616] SVAR: ssl_crlpath : # 2020-06-18T16:33:59 [98616] SVAR: ssl_key : # 2020-06-18T16:33:59 [98616] SVAR: standard_compliant_cte : ON # 2020-06-18T16:33:59 [98616] SVAR: storage_engine : InnoDB # 2020-06-18T16:33:59 [98616] SVAR: stored_program_cache : 256 # 2020-06-18T16:33:59 [98616] SVAR: strict_password_validation : ON # 2020-06-18T16:33:59 [98616] SVAR: sync_binlog : 0 # 2020-06-18T16:33:59 [98616] SVAR: sync_frm : ON # 2020-06-18T16:33:59 [98616] SVAR: sync_master_info : 10000 # 2020-06-18T16:33:59 [98616] SVAR: sync_relay_log : 10000 # 2020-06-18T16:33:59 [98616] SVAR: sync_relay_log_info : 10000 # 2020-06-18T16:33:59 [98616] SVAR: system_time_zone : UTC # 2020-06-18T16:33:59 [98616] SVAR: table_definition_cache : 400 # 2020-06-18T16:33:59 [98616] SVAR: table_open_cache : 2000 # 2020-06-18T16:33:59 [98616] SVAR: table_open_cache_instances : 2 # 2020-06-18T16:33:59 [98616] SVAR: thread_cache_size : 151 # 2020-06-18T16:33:59 [98616] SVAR: thread_concurrency : 10 # 2020-06-18T16:33:59 [98616] SVAR: thread_handling : one-thread-per-connection # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_idle_timeout : 60 # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_max_threads : 65536 # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_oversubscribe : 3 # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_prio_kickup_timer : 1000 # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_priority : auto # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_size : 6 # 2020-06-18T16:33:59 [98616] SVAR: thread_pool_stall_limit : 500 # 2020-06-18T16:33:59 [98616] SVAR: thread_stack : 299008 # 2020-06-18T16:33:59 [98616] SVAR: time_format : %H:%i:%s # 2020-06-18T16:33:59 [98616] SVAR: time_zone : SYSTEM # 2020-06-18T16:33:59 [98616] SVAR: timed_mutexes : OFF # 2020-06-18T16:33:59 [98616] SVAR: timestamp : 1592498039.328451 # 2020-06-18T16:33:59 [98616] SVAR: tmp_disk_table_size : 18446744073709551615 # 2020-06-18T16:33:59 [98616] SVAR: tmp_memory_table_size : 16777216 # 2020-06-18T16:33:59 [98616] SVAR: tmp_table_size : 16777216 # 2020-06-18T16:33:59 [98616] SVAR: tmpdir : /dev/shm/vardir/1592496496/250/1/tmp # 2020-06-18T16:33:59 [98616] SVAR: transaction_alloc_block_size : 8192 # 2020-06-18T16:33:59 [98616] SVAR: transaction_prealloc_size : 4096 # 2020-06-18T16:33:59 [98616] SVAR: tx_isolation : REPEATABLE-READ # 2020-06-18T16:33:59 [98616] SVAR: tx_read_only : OFF # 2020-06-18T16:33:59 [98616] SVAR: unique_checks : ON # 2020-06-18T16:33:59 [98616] SVAR: updatable_views_with_limit : YES # 2020-06-18T16:33:59 [98616] SVAR: use_stat_tables : NEVER # 2020-06-18T16:33:59 [98616] SVAR: userstat : OFF # 2020-06-18T16:33:59 [98616] SVAR: version : 10.2.33-MariaDB-debug-log # 2020-06-18T16:33:59 [98616] SVAR: version_comment : Source distribution # 2020-06-18T16:33:59 [98616] SVAR: version_compile_machine : x86_64 # 2020-06-18T16:33:59 [98616] SVAR: version_compile_os : Linux # 2020-06-18T16:33:59 [98616] SVAR: version_malloc_library : system # 2020-06-18T16:33:59 [98616] SVAR: version_ssl_library : YaSSL 2.4.4 # 2020-06-18T16:33:59 [98616] SVAR: wait_timeout : 28800 # 2020-06-18T16:33:59 [98616] SVAR: warning_count : 0 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_auto_increment_control : ON # 2020-06-18T16:33:59 [98616] SVAR: wsrep_causal_reads : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_certification_rules : strict # 2020-06-18T16:33:59 [98616] SVAR: wsrep_certify_nonpk : ON # 2020-06-18T16:33:59 [98616] SVAR: wsrep_cluster_address : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_cluster_name : my_wsrep_cluster # 2020-06-18T16:33:59 [98616] SVAR: wsrep_convert_lock_to_trx : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_data_home_dir : /dev/shm/vardir/1592496496/250/1/data/ # 2020-06-18T16:33:59 [98616] SVAR: wsrep_dbug_option : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_debug : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_desync : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_dirty_reads : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_drupal_282555_workaround : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_forced_binlog_format : NONE # 2020-06-18T16:33:59 [98616] SVAR: wsrep_gtid_domain_id : 0 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_gtid_mode : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_load_data_splitting : ON # 2020-06-18T16:33:59 [98616] SVAR: wsrep_log_conflicts : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_max_ws_rows : 0 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_max_ws_size : 2147483647 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_mysql_replication_bundle : 0 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_node_address : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_node_incoming_address : AUTO # 2020-06-18T16:33:59 [98616] SVAR: wsrep_node_name : sdp # 2020-06-18T16:33:59 [98616] SVAR: wsrep_notify_cmd : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_on : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_osu_method : TOI # 2020-06-18T16:33:59 [98616] SVAR: wsrep_patch_version : wsrep_25.24 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_provider : none # 2020-06-18T16:33:59 [98616] SVAR: wsrep_provider_options : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_recover : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_reject_queries : NONE # 2020-06-18T16:33:59 [98616] SVAR: wsrep_replicate_myisam : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_restart_slave : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_retry_autocommit : 1 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_slave_fk_checks : ON # 2020-06-18T16:33:59 [98616] SVAR: wsrep_slave_threads : 1 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_slave_uk_checks : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_sst_auth : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_sst_donor : # 2020-06-18T16:33:59 [98616] SVAR: wsrep_sst_donor_rejects_queries : OFF # 2020-06-18T16:33:59 [98616] SVAR: wsrep_sst_method : rsync # 2020-06-18T16:33:59 [98616] SVAR: wsrep_sst_receive_address : AUTO # 2020-06-18T16:33:59 [98616] SVAR: wsrep_start_position : 00000000-0000-0000-0000-000000000000:-1 # 2020-06-18T16:33:59 [98616] SVAR: wsrep_sync_wait : 0 # 2020-06-18T16:33:59 [98616] DEBUG: dsns[0] defined. # 2020-06-18T16:33:59 [98616] --------------------------------------------------------------- # 2020-06-18T16:33:59 [98616] debug_server => ['undef', 'undef', 'undef'] # 2020-06-18T16:33:59 [98616] dsn => ['dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1'] # 2020-06-18T16:33:59 [98616] duration => 300 # 2020-06-18T16:33:59 [98616] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-06-18T16:33:59 [98616] gendata => # 2020-06-18T16:33:59 [98616] generator => FromGrammar # 2020-06-18T16:33:59 [98616] grammar => /home/mleich/RQG_mleich/storage/1592496496/250/rqg.yy # 2020-06-18T16:33:59 [98616] logfile => /home/mleich/RQG_mleich/storage/1592496496/250/rqg.log # 2020-06-18T16:33:59 [98616] mask => 0 # 2020-06-18T16:33:59 [98616] mask-level => 0 # 2020-06-18T16:33:59 [98616] queries => 10000000 # 2020-06-18T16:33:59 [98616] reporters => ['Backtrace', 'Deadlock1', 'ErrorLog'] # 2020-06-18T16:33:59 [98616] restart-timeout => 120 # 2020-06-18T16:33:59 [98616] rpl_mode => none # 2020-06-18T16:33:59 [98616] rr => 1 # 2020-06-18T16:33:59 [98616] rr_options => "--chaos" # 2020-06-18T16:33:59 [98616] seed => 21007 # 2020-06-18T16:33:59 [98616] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x560972a7eae8)'] # 2020-06-18T16:33:59 [98616] threads => 9 # 2020-06-18T16:33:59 [98616] transformers => ['ExecuteAsCTE', 'ExecuteAsDeleteReturning', 'ExecuteAsExecuteImmediate', 'ExecuteAsInsertSelect', 'ExecuteAsUnion', 'ExecuteAsUpdateDelete', 'ExecuteAsView', 'ExecuteAsPreparedTwice', 'ExecuteAsSPTwice'] # 2020-06-18T16:33:59 [98616] validators => ['TransformerNoComparator'] # 2020-06-18T16:33:59 [98616] vcols => ['', '', ''] # 2020-06-18T16:33:59 [98616] views => ['', '', ''] # 2020-06-18T16:33:59 [98616] --------------------------------------------------------------- # 2020-06-18T16:33:59 [98616] DEBUG: timeoutMultiplier : 1.5<- # 2020-06-18T16:33:59 [98616] ------------------------------- # 2020-06-18T16:33:59 [98616] Configuration # 2020-06-18T16:33:59 [98616] debug_server => ['undef', 'undef', 'undef'] # 2020-06-18T16:33:59 [98616] dsn => ['dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1'] # 2020-06-18T16:33:59 [98616] duration => 300 # 2020-06-18T16:33:59 [98616] engine => ['InnoDB', 'InnoDB', 'InnoDB'] # 2020-06-18T16:33:59 [98616] gendata => # 2020-06-18T16:33:59 [98616] generator => FromGrammar # 2020-06-18T16:33:59 [98616] grammar => /home/mleich/RQG_mleich/storage/1592496496/250/rqg.yy # 2020-06-18T16:33:59 [98616] logfile => /home/mleich/RQG_mleich/storage/1592496496/250/rqg.log # 2020-06-18T16:33:59 [98616] mask => 0 # 2020-06-18T16:33:59 [98616] mask-level => 0 # 2020-06-18T16:33:59 [98616] queries => 10000000 # 2020-06-18T16:33:59 [98616] reporters => ['Backtrace', 'Deadlock1', 'ErrorLog'] # 2020-06-18T16:33:59 [98616] restart-timeout => 120 # 2020-06-18T16:33:59 [98616] rpl_mode => none # 2020-06-18T16:33:59 [98616] rr => 1 # 2020-06-18T16:33:59 [98616] rr_options => "--chaos" # 2020-06-18T16:33:59 [98616] seed => 21007 # 2020-06-18T16:33:59 [98616] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x560972a7eae8)'] # 2020-06-18T16:33:59 [98616] threads => 9 # 2020-06-18T16:33:59 [98616] transformers => ['ExecuteAsCTE', 'ExecuteAsDeleteReturning', 'ExecuteAsExecuteImmediate', 'ExecuteAsInsertSelect', 'ExecuteAsUnion', 'ExecuteAsUpdateDelete', 'ExecuteAsView', 'ExecuteAsPreparedTwice', 'ExecuteAsSPTwice'] # 2020-06-18T16:33:59 [98616] validators => ['TransformerNoComparator'] # 2020-06-18T16:33:59 [98616] vcols => ['', '', ''] # 2020-06-18T16:33:59 [98616] views => ['', '', ''] # 2020-06-18T16:33:59 [98616] INFO: Begin of GenData activity # 2020-06-18T16:33:59 [98616] INFO: Starting GenTest::App::GendataSimple # 2020-06-18T16:33:59 [98616] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:33:59 [98616] Creating MySQL table A, size 0 rows, engine InnoDB . # 2020-06-18T16:33:59 [98616] Creating MySQL table B, size 1 rows, engine InnoDB . # 2020-06-18T16:33:59 [98616] Creating MySQL table C, size 20 rows, engine InnoDB . # 2020-06-18T16:33:59 [98616] Creating MySQL table D, size 100 rows, engine InnoDB . # 2020-06-18T16:34:00 [98616] Creating MySQL table E, size 1000 rows, engine InnoDB . # 2020-06-18T16:34:03 [98616] Creating MySQL table AA, size 0 rows, engine InnoDB . # 2020-06-18T16:34:03 [98616] Creating MySQL table BB, size 1 rows, engine InnoDB . # 2020-06-18T16:34:04 [98616] Creating MySQL table CC, size 20 rows, engine InnoDB . # 2020-06-18T16:34:04 [98616] Creating MySQL table DD, size 100 rows, engine InnoDB . # 2020-06-18T16:34:04 [98616] INFO: End of GenData activity # 2020-06-18T16:34:04 [98616] GenData returned status STATUS_OK (0) # 2020-06-18T16:34:04 [98616] INFO: RQG GenData runtime in s : 5 # 2020-06-18T16:34:04 [98616] INFO: GenTest: Start of running queries : 1592498053 # 2020-06-18T16:34:04 [98616] Reading grammar from file '/home/mleich/RQG_mleich/storage/1592496496/250/rqg.yy'. # 2020-06-18T16:34:04 [98616] Reporters (for Simplifier): ->Backtrace<->Deadlock1<->ErrorLog<->None<->ServerDead<- # 2020-06-18T16:34:05 [98616] INFO: Reporter 'Backtrace' added. # 2020-06-18T16:34:05 [98616] INFO: Reporter 'Deadlock1' added. # 2020-06-18T16:34:05 [98616] INFO: Reporter 'ErrorLog' added. # 2020-06-18T16:34:05 [98616] INFO: Reporter 'ServerDead' added. # 2020-06-18T16:34:05 [98616] Validators (for Simplifier): ->None<->TransformerNoComparator<- # 2020-06-18T16:34:05 [98616] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:05 [98616] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 # 2020-06-18T16:34:10 [98616] Starting 9 processes, 10000000 queries each, duration 300 seconds. # 2020-06-18T16:34:10 [98616] GenTest::ErrorFilter(101916) started # 2020-06-18T16:34:10 [101919] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101919] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101918] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101918] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101921] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101921] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101922] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101922] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101928] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101928] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101920] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101920] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101923] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101923] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101925] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101925] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101926] MLML EXECUTOR_TIMEOUT_MULTIPLIER : 1 # 2020-06-18T16:34:10 [101926] MLML: MIXER_TIMEOUT_MULTIPLIER : 1.5 # 2020-06-18T16:34:10 [101923] INFO: Thread6 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101923] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101918] INFO: Thread1 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101918] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101923] INFO: Thread6 : Mixer created. # 2020-06-18T16:34:10 [101928] INFO: Thread9 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101928] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101919] INFO: Thread2 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101919] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101921] INFO: Thread4 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101918] INFO: Thread1 : Mixer created. # 2020-06-18T16:34:10 [101921] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101922] INFO: Thread5 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101922] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101919] INFO: Thread2 : Mixer created. # 2020-06-18T16:34:10 [101928] INFO: Thread9 : Mixer created. # 2020-06-18T16:34:10 [101920] INFO: Thread3 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101920] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101921] INFO: Thread4 : Mixer created. # 2020-06-18T16:34:10 [101926] INFO: Thread8 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101926] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101922] INFO: Thread5 : Mixer created. # 2020-06-18T16:34:10 [101920] INFO: Thread3 : Mixer created. # 2020-06-18T16:34:10 [101926] INFO: Thread8 : Mixer created. # 2020-06-18T16:34:10 [101925] INFO: Thread7 in Mixer : Validator 'GenTest::Validator::TransformerNoComparator' loaded. # 2020-06-18T16:34:10 [101925] TransformerNoComparator Validator will use the following Transformers: ExecuteAsCTE, ExecuteAsDeleteReturning, ExecuteAsExecuteImmediate, ExecuteAsInsertSelect, ExecuteAsUnion, ExecuteAsUpdateDelete, ExecuteAsView, ExecuteAsPreparedTwice, ExecuteAsSPTwice # 2020-06-18T16:34:10 [101925] INFO: Thread7 : Mixer created. # 2020-06-18T16:34:11 [101917] INFO: Periodic reporting process at begin of activity # 2020-06-18T16:34:11 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-18T16:34:13 [101916] ErrorFilter: Query: # 2020-06-18T16:34:13 [101916] CREATE OR REPLACE TABLE t1 (`col_varchar_key` CHAR NOT NULL, icol8 TINYINT UNSIGNED NOT NULL DEFAULT NULL /*!100201 CHECK (vcol1 = 7) */, icol5 INT ) ROW_FORMAT = REDUNDANT /* E_R Thread6 QNO 41 CON_ID 23 */ failed: 1067 Invalid default value for 'icol%d'. Further errors of this kind will be suppressed. # 2020-06-18T16:34:13 [101916] ErrorFilter: Query: CREATE OR REPLACE TABLE t10 (`col_varchar_nokey` TEXT NOT NULL DEFAULT '' ) ROW_FORMAT COMPRESSED /* E_R Thread6 QNO 42 CON_ID 23 */ failed: 1005 Can't create table `test`.`t%d` (errno: %d "Wrong create options"). Further errors of this kind will be suppressed. # 2020-06-18T16:34:13 [101916] ErrorFilter: Query: # 2020-06-18T16:34:13 [101916] CREATE OR REPLACE TABLE t3 (ncol1 DECIMAL DEFAULT NULL /*!100201 CHECK (`col_varchar_key` NOT LIKE 2) */, geocol7 GEOMETRYCOLLECTION NULL /*!100201 CHECK (`col_datetime_key` NOT LIKE 1) */) ROW_FORMAT = PAGE /* E_R Thread5 QNO 41 CON_ID 20 */ failed: 1054 Unknown column '%s' in 'CHECK'. Further errors of this kind will be suppressed. # 2020-06-18T16:34:13 [101916] ErrorFilter: Query: CREATE OR REPLACE TABLE t9 (icol7 BIGINT AUTO_INCREMENT ) ROW_FORMAT = DEFAULT /* E_R Thread6 QNO 47 CON_ID 23 */ failed: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key. Further errors of this kind will be suppressed. # 2020-06-18T16:34:14 [101916] ErrorFilter: Query: CREATE OR REPLACE TABLE t6 (geocol2 MULTILINESTRING NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)') ) ROW_FORMAT = REDUNDANT /* E_R Thread3 QNO 46 CON_ID 22 */ failed: 1366 Incorrect MULTILINESTRING value: 'POINT(%d %d)' for column ``.``.`geocol%d` at row %d. Further errors of this kind will be suppressed. # 2020-06-18T16:34:14 [101923] GenTest::Executor::MySQL::execute: Thread6 Query: ALTER TABLE t8 /*!100301 WAIT 7 */ CHANGE COLUMN IF EXISTS tcol4 icol8 SMALLINT UNSIGNED NOT NULL /*!100303 INVISIBLE */ /*!100201 CHECK (ecol5 != 9) */, ALGORITHM=INSTANT, LOCK=DEFAULT, ADD CONSTRAINT z CHECK (tcol3 < icol7) /* E_R Thread6 QNO 68 CON_ID 23 */ failed: 1800 Unknown ALGORITHM 'INSTANT' # 2020-06-18T16:34:14 [101916] ErrorFilter: Query: ALTER TABLE t2 /*!100301 WAIT 2 */ DROP CONSTRAINT IF EXISTS z, MODIFY COLUMN IF EXISTS icol5 INT UNSIGNED NULL DEFAULT 0 /*!100303 INVISIBLE */, ALGORITHM=COPY, LOCK=DEFAULT /* E_R Thread6 QNO 69 CON_ID 23 */ failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2020-06-18T16:34:15 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: SELECT DISTINCT '2026-07-26 08:23:38.041482' - NULL AS field1, VAR_SAMP( '2022-02-12 20:53:56.047908' ) AS field2, GROUP_CONCAT( DECODE( NULL, `col_int_key` ), DEGREES( NULL ) ) AS field3, UUID_SHORT() AS field4, `col_int_key` * `col_datetime_key` AS field5, UpdateXML( NULL, '/daaaabcbebdddabee/ddadc/dc/aaecbbc/bead/dcb/cdceda/e/bbebd', -6227915334699974656 ) AS field6, VAR_POP( ( ELT( ( ( ENCRYPT( ( CAST( '2008-07-22 19:20:46.050965' AS TIME ) ) ) ) > ( @A := `col_varchar_key` ) ), 'c', '1991-03-11', ( MD5( `col_datetime_key` ) ), ( VALUE( `col_time_key` ) ), ( FORMAT( `col_datetime_key`, 1, 'en_US' ) ) ) ) ) AS field7 FROM `D` /* E_R Thread5 QNO 58 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_time_key` ) ), ( FORMAT( `col_datetime_key`, 1, 'en_US' ) ) ) ) ) AS f...' at line 1 # 2020-06-18T16:34:15 [101916] ErrorFilter: Query: XA COMMIT 'non_prepared_xid' /* E_R Thread5 QNO 57 CON_ID 20 */ failed: 1397 XAER_NOTA: Unknown XID. Further errors of this kind will be suppressed. # 2020-06-18T16:34:15 [101918] GenTest::Executor::MySQL::execute: Thread1 Query: SELECT DISTINCT NAME_CONST( '', 'wkemritbuhtpgiwwgctxpglbenhxthmazwhqqziqtqqoimvilnjnmvwhvmvwujkfsybeiaxiimezsszhrgdpsmhcjygkbbjbrwyykmwegnefauyugwmwvlydasbkqewlpzptolxkqfkkratzwoifrsfygiy' ) AS field1 FROM `view_DD` GROUP BY RADIANS( `col_int_key` ), ( ( `col_varchar_nokey` OR ( CURRENT_DATE ) ) AND 'kemritbuhtpgiwwgctxpglbenhxthmazwhqqziqtqqoimvilnjnmvwhvmvwujkfsybeiaxiimezsszhrgdpsmhcjygkbbjbrwyykmwegnefauyugwmwvlydasbkqewlpzptolxkqfkkratzwoifrsfygiybggcjyvqkoyvobawktzoocpnyxrdgrffvginkocnifygrlzumewvsbrpqfjgkmfqjtzdthrryddahdsghexotuavo' ) NOT REGEXP ( MONTH( ( CAST( ( VALUE( `col_date_nokey` ) ) AS UNSIGNED ) ) ) ) HAVING TIMESTAMPDIFF( MINUTE, ( RAND() ), ( UpdateXML( -3555591905809006592, '/daaaabcbebdddabee/ddadc/dc/aaecbbc/bead/dcb/cdceda/e/bbebd', -5946158883012608000 ) ) ) ORDER BY FORMAT( ( CAST( `pk` AS CHAR ) ), ( INSTR( `pk`, `col_time_key` ) ), 'en_US' ), 'emritbuhtpgiwwgctxpglbenhxthmazwhqqziqtqqoimvilnjnmvwhvmvwujkfsybeiaxiimezsszhrgdpsmhcjygkbbjbrwyykmwegnefauyugwmwvlydasbkqewlpzptolxkqfkkratzwoifrsfygi' << 'a' /* E_R Thread1 QNO 58 CON_ID 18 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_date_nokey` ) ) AS UNSIGNED ) ) ) ) HAVING TIMESTAMPDIFF( MINUTE, ( RA...' at line 1 # 2020-06-18T16:34:17 [101921] GenTest::Executor::MySQL::execute: Thread4 Query: CREATE TEMPORARY TABLE tmp3 AS SELECT VAR_POP( `col_time_nokey` ) AS field1 FROM `view_E` WHERE GET_FORMAT( DATETIME, 'USA' ) GROUP BY ACOS( `col_date_nokey` ), HEX( 5154651248502243328 ) WITH ROLLUP HAVING VALUE( `col_int_nokey` ) /* E_R Thread4 QNO 76 CON_ID 19 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_int_nokey` ) /* E_R Thread4 QNO 76 CON_ID 19 */' at line 1 # 2020-06-18T16:34:17 [101916] ErrorFilter: Query: /* GenTest::Transform::ExecuteAsCTE */ INSERT `view_A` WITH cte1 AS ( SELECT * FROM `E` /* E_R Thread5 QNO 61 CON_ID 20 */ ) SELECT * FROM cte1 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* E_R Thread5 QNO 62 CON_ID 20 */ failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2020-06-18T16:34:17 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: SELECT DISTINCT VARIANCE( ( UpdateXML( 8707991354497564672, '/ebdae/eaadb/cbbbdda/c/d/eaeab/accdba/aebeae/ededebbbbeddecdebbcdee', -12955 ) ) ) AS field1 FROM `B` WHERE RPAD( ( '22:49:48.026020' <=> `col_time_nokey` ), `col_date_nokey`, ( ~ ( ExtractValue( NULL, '/edad/bbe/cbae/e/acbbe/cba/cedbca/abb' ) ) ) ) GROUP BY TIMESTAMPADD( DAY, `col_date_nokey`, `pk` ), VALUE( `col_date_nokey` ) HAVING ( @A := `col_time_nokey` ) ORDER BY PASSWORD( ( NULL > -2466002270962057216 ) ) LIMIT 81 /* E_R Thread5 QNO 71 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_date_nokey` ) HAVING ( @A := `col_time_nokey` ) ORDER BY PASSWORD( ( N...' at line 1 # 2020-06-18T16:34:17 [101921] GenTest::Executor::MySQL::execute: Thread4 Query: CREATE TABLE tmp4 AS SELECT DISTINCT BIT_XOR( 0 ) AS field1, CURRENT_USER() AS field2, VAR_SAMP( 12977 ) AS field3, GROUP_CONCAT( '00:35:55.017074' ^ `col_varchar_nokey`, '1982-06-27' AND ( @A := `col_varchar_key` ) ) AS field4 FROM `BB` ORDER BY VALUE( `col_time_nokey` ) /* E_R Thread4 QNO 106 CON_ID 19 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_time_nokey` ) /* E_R Thread4 QNO 106 CON_ID 19 */' at line 1 # 2020-06-18T16:34:18 [101916] ErrorFilter: Query: ALTER IGNORE TABLE t10 ADD SPATIAL INDEX(geocol9), LOCK=DEFAULT /* E_R Thread5 QNO 73 CON_ID 20 */ failed: 1072 Key column '%s' doesn't exist in table. Further errors of this kind will be suppressed. # 2020-06-18T16:34:18 [101916] ErrorFilter: Query: EXECUTE stmt /* E_R Thread5 QNO 90 CON_ID 20 */ failed: 1243 Unknown prepared statement handler (%s) given to EXECUTE. Further errors of this kind will be suppressed. # 2020-06-18T16:34:18 [101916] ErrorFilter: Query: DROP TEMPORARY TABLE `ps` /* E_R Thread5 QNO 97 CON_ID 20 */ failed: 1051 Unknown table '%s'. Further errors of this kind will be suppressed. # 2020-06-18T16:34:18 [101922] Ignoring transforms of the type GenTest::Transform::ExecuteAsCTE that fail with an error like: Table '%s' already exists # 2020-06-18T16:34:18 [101916] ErrorFilter: Query: /* GenTest::Transform::ExecuteAsCTE */ CREATE TEMPORARY TABLE tmp1 AS WITH cte1 AS ( SELECT DISTINCT VAR_SAMP( `col_time_key`) AS field1 FROM `DD` GROUP BY LOG( `col_int_nokey`, NULL) WITH ROLLUP LIMIT 161 /* E_R Thread5 QNO 98 CON_ID 20 */ ) SELECT * FROM cte1 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* E_R Thread5 QNO 99 CON_ID 20 */ failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2020-06-18T16:34:18 [101916] ErrorFilter: Query: XA PREPARE 'non_idle_xid' /* E_R Thread5 QNO 111 CON_ID 20 */ failed: 1399 XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state. Further errors of this kind will be suppressed. # 2020-06-18T16:34:18 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: ALTER ONLINE TABLE t9 /*!100301 NOWAIT */ ADD INDEX(ncol8), ALGORITHM=NOCOPY, LOCK=DEFAULT /* E_R Thread5 QNO 114 CON_ID 20 */ failed: 1800 Unknown ALGORITHM 'NOCOPY' # 2020-06-18T16:34:19 [101919] GenTest::Executor::MySQL::execute: Thread2 Query: CREATE TEMPORARY TABLE tmp1 AS SELECT DISTINCT `col_datetime_nokey` IN ( ( MOD( `col_varchar_key`, '1977-11-03' ) ), ( UNIX_TIMESTAMP( -16517 ) ) ) AS field1 FROM `AA` GROUP BY CAST( ( CURRENT_USER() ) AS TIME ), RIGHT( ( ( CONVERT( `col_time_nokey`, UNSIGNED ) ) NOT BETWEEN '2006-08-20 11:03:00.022063' AND `col_int_nokey` ), ( LEAST( NULL, `pk`, `col_time_nokey` ) ) ) ORDER BY CONVERT( `col_datetime_key` USING latin1 ), 'g' + ( POSITION( `col_int_key` IN ( UPPER( ( VALUE( `col_date_nokey` ) ) ) ) ) ) /* E_R Thread2 QNO 91 CON_ID 17 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_date_nokey` ) ) ) ) ) ) /* E_R Thread2 QNO 91 CON_ID 17 */' at line 1 # 2020-06-18T16:34:19 [101926] GenTest::Executor::MySQL::execute: Thread8 Query: SELECT DISTINCT BENCHMARK( 4, @A := NULL ) AS field1, COUNT( CRC32( ( NULLIF( `col_time_key`, 'rgzhuaqcphvcrubxyeiyypysxzkkzgwsahevahnuujefnzbrzgkzzjqtwwpvynyojplmmtqpacpdfnsjhxvlqvxadxigvmcnhbyphgpqhnlibwoyaftohlyj' ) ) ) ) AS field2, CONVERT( `col_time_key`, UNSIGNED ) AS field3, COUNT( 'w' XOR NULL ) AS field4 FROM `view_CC` WHERE `col_int_key` ^ `col_int_key` HAVING INSERT( `col_time_key`, `col_date_nokey`, `col_date_key`, ( VALUE( `col_int_nokey` ) ) ) /* E_R Thread8 QNO 93 CON_ID 25 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_int_nokey` ) ) ) /* E_R Thread8 QNO 93 CON_ID 25 */' at line 1 # 2020-06-18T16:34:19 [101926] GenTest::Executor::MySQL::execute: Thread8 Query: ALTER IGNORE TABLE t6 /*!100301 WAIT 3 */ FORCE, LOCK=NONE, ALGORITHM=INSTANT, DROP INDEX ind7, ADD SPATIAL INDEX(geocol8) /* E_R Thread8 QNO 94 CON_ID 25 */ failed: 1800 Unknown ALGORITHM 'INSTANT' # 2020-06-18T16:34:21 [101916] ErrorFilter: Query: CREATE TABLE t9 LIKE `view_DD` /* E_R Thread9 QNO 97 CON_ID 21 */ failed: 1347 'test.view_DD' is not BASE TABLE. Further errors of this kind will be suppressed. # 2020-06-18T16:34:21 [101926] Ignoring transforms of the type GenTest::Transform::ExecuteAsCTE that fail with an error like: Table '%s' already exists # 2020-06-18T16:34:21 [101920] Ignoring transforms of the type GenTest::Transform::ExecuteAsSPTwice that fail with an error like: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state # 2020-06-18T16:34:21 [101921] GenTest::Executor::MySQL::execute: Thread4 Query: SELECT DISTINCT BIN( `pk` ) AS field1 FROM `view_CC` GROUP BY SQRT( `col_date_nokey` ), VALUE( `col_int_key` ) HAVING @A := `pk` ORDER BY ( - ( SHA( ( EXPORT_SET( `col_varchar_nokey`, `col_int_nokey`, '04:18:57.055548' ) ) ) ) ) % NULL /* E_R Thread4 QNO 142 CON_ID 19 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_int_key` ) HAVING @A := `pk` ORDER BY ( - ( SHA( ( EXPORT_SET( `col_va...' at line 1 # 2020-06-18T16:34:21 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-18T16:34:27 [101916] ErrorFilter: Query: SELECT INET_NTOA( `col_date_key` ) AS field1, STDDEV_SAMP( -8351 ) AS field2, 18018 AND ( '01:06:28.032955' != 'f' ) AS field3 FROM `AA` GROUP BY ( BENCHMARK( 4, BIT_AND( ( 0 MOD 'xksxabsegbwkpihetusptcyorsncrwhoxwrecaasentvrpdfkldmsyvqyvithrmerhrtufyyfpjrpwzikyfhmbcvcrznanfzvgulcvslvboodtlbarstxib' ) ) ) ) DIV `col_varchar_nokey`, RAND() ORDER BY RAND(), IS_FREE_LOCK( 'm' ) /* E_R Thread6 QNO 110 CON_ID 23 */ failed: 1111 Invalid use of group function. Further errors of this kind will be suppressed. # 2020-06-18T16:34:29 [101919] Ignoring transforms of the type GenTest::Transform::ExecuteAsDeleteReturning that fail with an error like: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state # 2020-06-18T16:34:31 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: SELECT STDDEV( `col_datetime_key` ) AS field1, STDDEV( ( VALUE( `col_datetime_nokey` ) ) ) AS field2, CHAR_LENGTH( ( UUID_SHORT() ) ) AS field3 FROM `A` GROUP BY NULLIF( NULL, 'mnhmhqmvsvhnvolghohnrwunllwzgwjsclcuylrjasnvqbchvakziavoymgatcilayoskfgbxgtghokwbylonpblhtedcpkwdcdobokjinkkkzfkwunyhzzyynxwzfdlaqkemgmkuykgbvrkqnxzwappxowasaqlgkbgephchy' ) HAVING LN( '2003-12-19 08:35:15.004816' ) /* E_R Thread5 QNO 160 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_datetime_nokey` ) ) ) AS field2, CHAR_LENGTH( ( UUID_SHORT() ) ) AS fi...' at line 1 # 2020-06-18T16:34:31 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-18T16:34:34 [101928] GenTest::Executor::MySQL::execute: Thread9 Query: PREPARE stmt FROM @stmt_create /* E_R Thread9 QNO 230 CON_ID 21 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_date_key` ), POSITION( ( @A := ( LEAST( 'v', -6889381529970016256, -27...' at line 1 # 2020-06-18T16:34:35 [101928] GenTest::Executor::MySQL::execute: Thread9 Query: PREPARE stmt FROM @stmt_ins /* E_R Thread9 QNO 234 CON_ID 21 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_date_key` ), POSITION( ( @A := ( LEAST( 'v', -6889381529970016256, -27...' at line 1 # 2020-06-18T16:34:36 [101916] ErrorFilter: Query: ALTER ONLINE TABLE t3 /*!100301 NOWAIT */ DROP INDEX ind7 /* E_R Thread9 QNO 240 CON_ID 21 */ failed: 1091 Can't DROP INDEX `ind%d`; check that it exists. Further errors of this kind will be suppressed. # 2020-06-18T16:34:36 [101916] ErrorFilter: Query: SELECT * FROM `DD` INTO OUTFILE 'load_DD' /* E_R Thread1 QNO 180 CON_ID 18 */ failed: 1086 File '%s' already exists. Further errors of this kind will be suppressed. # 2020-06-18T16:34:37 [101928] Ignoring transforms of the type GenTest::Transform::ExecuteAsCTE that fail with an error like: Table '%s' already exists # 2020-06-18T16:34:41 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: PREPARE stmt FROM @stmt_create /* E_R Thread5 QNO 235 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_varchar_nokey` ) HAVING GREATEST( `col_date_nokey`, `col_varchar_key`,...' at line 1 # 2020-06-18T16:34:41 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: PREPARE stmt FROM @stmt_ins /* E_R Thread5 QNO 239 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_varchar_nokey` ) HAVING GREATEST( `col_date_nokey`, `col_varchar_key`,...' at line 1 # 2020-06-18T16:34:41 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-18T16:34:41 [101916] ErrorFilter: Query: CREATE TEMPORARY TABLE tmp5 AS SELECT MIN( @A := `col_time_key` ) AS field1, UTC_TIMESTAMP() AS field2, UNCOMPRESSED_LENGTH( ( GREATEST( ( '18:52:50.036287' OR `col_date_key` ), ( @A := ( LTRIM( `col_date_nokey` ) ) ), ( IFNULL( '2011-11-08 09:05:51.037463', 0 ) ) ) ) ) AS field3, VARIANCE( ( UpdateXML( -15463, '/c/dbcbdc/cbacbeadecc/d/eadd/acbeebecd/cbaabecbdb/d/beedbdcbe/daaa/cacecddd', '18:53:04.015469' ) ) ) AS field4, BIT_XOR( 'g' ) AS field5 FROM `view_DD` GROUP BY @A := ( @A := `col_date_nokey` ), `col_time_key` NOT LIKE ( EXP( 24478 ) ) ORDER BY CURRENT_USER /* E_R Thread9 QNO 294 CON_ID 21 */ failed: 1690 DOUBLE value is out of range in 'exp(%d)'. Further errors of this kind will be suppressed. # 2020-06-18T16:34:42 [101921] Ignoring transforms of the type GenTest::Transform::ExecuteAsSPTwice that fail with an error like: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state # 2020-06-18T16:34:42 [101916] ErrorFilter: Query: SELECT DISTINCT BIT_LENGTH( 'y' ) AS field1, UUID_SHORT() AS field2, CONVERT( 0 USING latin1 ) AS field3, ( IFNULL( 'xpglbenhxthmazwh', `col_date_key` ) ) / ( '13:02:52.036944' + ( SOUNDEX( '2003-05-13 18:09:01.055571' ) ) ) AS field4, TIME( ( '19:40:26.046617' * `col_int_key` ) ) AS field5 FROM `BB` WHERE LOG10( ( FROM_UNIXTIME( ( `col_time_nokey` << ( CURRENT_USER ) ) ) ) ) GROUP BY MATCH( `col_varchar_nokey`, `col_datetime_nokey` ) AGAINST ( 'pglb' IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION ), MID( ( CONVERT( `col_varchar_nokey`, CHAR ) ), ( ExtractValue( '2018-07-18 05:14:46.028733', '/aabcbceaeecbee/cb/e/eaccdcadbeceb/dcaedebaa/caeeec/beadee/edbcc/a/aaaebcd/debcbccda/acbddeaddcdda/cdeeea/cedaddea/dbbe' ) ), -18696 ) WITH ROLLUP HAVING CURRENT_USER() /* E_R Thread1 QNO 243 CON_ID 18 */ failed: 1191 Can't find FULLTEXT index matching the column list. Further errors of this kind will be suppressed. # 2020-06-18T16:34:44 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: SELECT VARIANCE( ( `col_varchar_nokey` * -4885561170766856192 ) ) AS field1 FROM `view_AA` GROUP BY CONVERT( `col_int_nokey`, DATE ) HAVING @A := 'volghohnrwunllwzgwjsclcuylrjasnvqbchvakziavoymgatcilayoskfgbxgtghokwbylonpblhtedcpkwdcdobokjinkkkzfkwunyhzzyynxwzfdlaqkemgmkuykgbvrkqnxzwappxowasaqlgkbgephchywaxnsngybdrylieeszumbldiddafxbodruhsegp' ORDER BY @A := 'b', `col_int_nokey` & ( VALUE( `col_varchar_nokey` ) ) /* E_R Thread5 QNO 344 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_varchar_nokey` ) ) /* E_R Thread5 QNO 344 CON_ID 20 */' at line 1 # 2020-06-18T16:34:50 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: SELECT VAR_POP( '1972-02-18' ) AS field1, INET_ATON( ( VALUE( `col_time_key` ) ) ) AS field2 FROM `AA` WHERE `col_varchar_nokey` GROUP BY ( ENCODE( 0, ( COMPRESS( 25444 ) ) ) ) / '2002-11-20' WITH ROLLUP HAVING ELT( ( NULLIF( 'v', ( ( LN( '1978-03-22' ) ) <= `col_int_nokey` ) ) ), `col_int_key` ) /* E_R Thread5 QNO 389 CON_ID 20 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_time_key` ) ) ) AS field2 FROM `AA` WHERE `col_varchar_nokey` GROUP BY...' at line 1 # 2020-06-18T16:34:51 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-18T16:34:54 [101916] ErrorFilter: Query: SELECT LPAD( '20:40:53.047350', `col_date_nokey`, `pk` ) AS field1 FROM `A` ORDER BY RADIANS( '1998-07-10 10:00:01.060603' ) /* E_R Thread3 QNO 125 CON_ID 22 */ failed: 1969 Query execution was interrupted (max_statement_time exceeded). Further errors of this kind will be suppressed. # 2020-06-18T16:34:54 [101920] GenTest::Executor::MySQL::execute: Thread3 Query: CREATE TABLE tmp1 AS SELECT DISTINCT MASTER_POS_WAIT( 'log', 3925999616, 0.01 ) AS field1 FROM `view_BB` WHERE `pk` NOT BETWEEN `col_int_key` AND `col_int_key` GROUP BY LTRIM( ( VALUE( `col_date_key` ) ) ) WITH ROLLUP HAVING DES_ENCRYPT( '05:57:08.059330', `col_date_nokey` ) LIMIT 161 /* E_R Thread3 QNO 130 CON_ID 22 */ failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( `col_date_key` ) ) ) WITH ROLLUP HAVING DES_ENCRYPT( '05:57:08.059330', `co...' at line 1 # 2020-06-18T16:35:01 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 0 # 2020-06-18T16:35:12 [101926] GenTest::Executor::MySQL::execute: Thread8 Query: ( SELECT DISTINCT MIN( CONNECTION_ID() ) AS field1 FROM `E` GROUP BY CURRENT_USER, ABS( ( UpdateXML( NULL, '/ccdc/e/aa/ecedaa/dbdb/ee', '15:07:11.013075' ) ) ) WITH ROLLUP /* E_R Thread8 QNO 308 CON_ID 25 */ ) UNION ALL ( SELECT DISTINCT MIN( CONNECTION_ID() ) AS field1 FROM `E` GROUP BY CURRENT_USER, ABS( ( UpdateXML( NULL, '/ccdc/e/aa/ecedaa/dbdb/ee', '15:07:11.013075' ) ) ) WITH ROLLUP /* E_R Thread8 QNO 308 CON_ID 25 */ ) /* TRANSFORM_OUTCOME_SUPERSET */ /* E_R Thread8 QNO 329 CON_ID 25 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101919] GenTest::Executor::MySQL::execute: Thread2 Query: EXECUTE stmt /* E_R Thread2 QNO 345 CON_ID 17 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101922] GenTest::Executor::MySQL::execute: Thread5 Query: CREATE TABLE transforms.insert_select_101922 SELECT BIT_XOR( `col_time_nokey` ) AS field1 FROM `C` /* E_R Thread5 QNO 391 CON_ID 20 */ /* E_R Thread5 QNO 400 CON_ID 20 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101918] GenTest::Executor::MySQL::execute: Thread1 Query: EXECUTE stmt /* E_R Thread1 QNO 267 CON_ID 18 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101921] GenTest::Executor::MySQL::execute: Thread4 Query: INSERT INTO `CC` SELECT * FROM `view_A` /* E_R Thread4 QNO 211 CON_ID 19 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101928] GenTest::Executor::MySQL::execute: Thread9 Query: DROP TABLE IF EXISTS tmp7 /* E_R Thread9 QNO 411 CON_ID 21 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 # 2020-06-18T16:35:12 [101923] GenTest::Executor::MySQL::execute: Thread6 Query: CREATE TEMPORARY TABLE tmp3 AS SELECT DISTINCT OLD_PASSWORD( `col_varchar_nokey` ) AS field1, VARIANCE( ( `col_datetime_key` XOR `col_varchar_key` ) ) AS field2, TIMEDIFF( NULL, '05:40:31.056204' ) AS field3, BIT_COUNT( 'v' ) AS field4 FROM `CC` GROUP BY DES_DECRYPT( `col_date_nokey`, ( RAND( `col_time_key` ) ) ), IF( ( '18:16:04.052935' ), ( '1971-11-12 14:59:32.035961' ^ -24914 ), `col_varchar_key` ) ORDER BY LOG10( 'p' ), HOUR( `col_int_key` ) LIMIT 70 /* E_R Thread6 QNO 237 CON_ID 23 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101925] GenTest::Executor::MySQL::execute: Thread7 Query: UPDATE transforms.where_updatedelete_101925 SET `field1` = field1 + 9999 WHERE `field1` NOT IN ( SELECT CONVERT( ( CHAR_LENGTH( -5791347645821747200 ) ) USING latin1 ) AS field1 FROM `view_E` WHERE SQRT( ( `pk` % -7142709009009606656 ) ) GROUP BY RAND(), WEEKDAY( ( ( FROM_UNIXTIME( 0 ) ) && ( ( IS_FREE_LOCK( 'doll' ) ) <= ( ExtractValue( NULL, '/daaaabcbebdddabee/ddadc/dc/aaecbbc/bead/dcb/cdceda/e/bbebd' ) ) ) ) ) WITH ROLLUP HAVING CURRENT_DATE /* E_R Thread7 QNO 56 CON_ID 24 */ ) /* E_R Thread7 QNO 81 CON_ID 24 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:12 [101920] GenTest::Executor::MySQL::execute: Thread3 Query: CREATE TEMPORARY TABLE tmp2 AS SELECT IFNULL( ( MD5( `col_varchar_nokey` ) ), `col_int_key` ) AS field1 FROM `view_CC` WHERE FORMAT( ( INET_NTOA( ( CASE ( INET_ATON( 8963289158374129664 ) ) WHEN '2013-02-25' THEN ( ELT( ( - '1991-06-07' ), `col_time_nokey`, ( CASE ( ( ROUND( NULL ) ) ^ `col_varchar_key` ) WHEN 7130324110034337792 THEN '01:21:23.026873' ELSE '2012-12-14 22:47:59.026373' END ), '1987-05-05', '2005-11-19', 'gneeauzcmsriiccxmhonrpfryykfvnodnfgrrrdeljftvhcmtiufvxnxkwyrtgwovxgaarxqozgmysvtvmutlzsfeogcbgsfhjebkezyrpixgxodahimxl', `col_varchar_key`, ( CHAR( '21:06:46.003410' ) ), 'w', 6585107080145797120 ) ) ELSE '2024-05-23' END ) ) ), 136, 'de_DE' ) GROUP BY UpdateXML( '06:18:38.050525', '/cbb/dcaeecaeddaebda/ca/bbdc/abc/beace/eeeabda/dbd/d/aaceeb/dddeeb/addba/debcdde', 'neeauzcmsriiccxmhonrpfryykfvnodnfgrrrdeljftvhcmtiufvxnxkwyrtgwovxgaarxqozgmysvtvmutlzsfeogcbgsfhjebkezyrpixgxodahimxlndmwbynmghltkvdzbelwfxkmofixoplulctlmyipczjwqtrmrvinhcqofjljsaptclqlodnvlicdgmbmoocduwthaqxyegdx' ), UPPER( ( `col_time_key` <= ( @A := '2023-11-03' ) ) ) WITH ROLLUP ; DROP TABLE IF EXISTS tmp2 /* E_R Thread3 QNO 132 CON_ID 22 */ failed: 2013 Lost connection to MySQL server during query # 2020-06-18T16:35:15 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:18 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:21 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:24 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:27 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:30 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:33 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:36 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:39 [101917] WARN: Reporter 'Deadlock': The connect attempt to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed: Can't connect to MySQL server on '127.0.0.1' (111) # 2020-06-18T16:35:39 [101917] ERROR: Reporter 'Deadlock': All 10 connect attempts to dsn dbi:mysql:host=127.0.0.1:port=29580:user=root:database=test:mysql_local_infile=1 failed. Will return STATUS_SERVER_CRASHED # 2020-06-18T16:35:39 [101917] INFO: GenTest::ReporterManager::monitor: Reporter 'Deadlock1' reported 101 # 2020-06-18T16:35:39 [101917] DEBUG: GenTest::ReporterManager::monitor: Will return the (maximum) status 101 # 2020-06-18T16:35:39 [101917] ERROR: Periodic reporting process: Critical status STATUS_SERVER_CRASHED got. Will exit with that. # 2020-06-18T16:35:39 [101917] GenTest: child 101917 is being stopped with status STATUS_SERVER_CRASHED # 2020-06-18T16:35:40 [98616] Process with pid 101917 for periodic reporter ended with status STATUS_SERVER_CRASHED # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101921... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101923... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101925... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101922... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101920... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101918... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101926... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101928... # 2020-06-18T16:35:40 [98616] Killing (TERM) remaining worker process with pid 101919... # 2020-06-18T16:35:41 [98616] Process with pid 101921 for Thread4 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101923 for Thread6 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101925 for Thread7 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101922 for Thread5 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101920 for Thread3 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101918 for Thread1 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101926 for Thread8 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101928 for Thread9 ended with status STATUS_OK # 2020-06-18T16:35:41 [98616] Process with pid 101919 for Thread2 ended with status STATUS_OK # 2020-06-18T16:35:55 [98616] Kill GenTest::ErrorFilter(101916) # 2020-06-18T16:35:55 [98616] INFO: GenTest: Effective duration in s : 102 # 2020-06-18T16:35:55 [98616] Server crash reported, initiating post-crash analysis... # 2020-06-18T16:35:55 [98616] INFO: Reporter 'Backtrace' ------------------------------ Begin # 2020-06-18T16:35:55 [98616] datadir is /dev/shm/vardir/1592496496/250/1/data/ # 2020-06-18T16:35:55 [98616] binary is /home/mleich/Server_bin/10.2_debug/bin/mysqld # 2020-06-18T16:35:55 [98616] bindir is /home/mleich/Server_bin/10.2_debug/bin # 2020-06-18T16:35:55 [98616] error_log is /dev/shm/vardir/1592496496/250/1/data/../mysql.err # 2020-06-18T16:35:55 [98616] pid_file is /dev/shm/vardir/1592496496/250/1/mysql.pid # 2020-06-18T16:35:56 [98616] INFO: Reporter::Backtrace The pid_file '/dev/shm/vardir/1592496496/250/1/mysql.pid' did not disappear. # 2020-06-18T16:35:56 [98616] ALARM: Reporter::Backtrace 1.00650596618652s waited but the server error_log remains without '... (core dumped)'. # 2020-06-18T16:40:26 [98616] INFO: Even after 270s waiting: The core file name is not defined. # 2020-06-18T16:40:26 [98616] Will return STATUS_SERVER_CRASHED, undef # 2020-06-18T16:40:26 [98616] INFO: Reporter 'Backtrace' ------------------------------ End # 2020-06-18T16:40:26 [98616] ERROR: ReporterManager : Reporter 'Backtrace' reported 101 # 2020-06-18T16:40:26 [98616] INFO: Reporter 'ErrorLog' ------------------------------ Begin # 2020-06-18T16:40:26 [98616] --------- Contents of /dev/shm/vardir/1592496496/250/1/data//../mysql.err ------------- # 2020-06-18T16:40:26 [98616] | [rr 99366 1502]2020-06-18 16:33:56 140471675044352 [Note] /home/mleich/Server_bin/10.2_debug//bin/mysqld (mysqld 10.2.33-MariaDB-debug-log) starting as process 99366 ... # 2020-06-18T16:40:26 [98616] | [rr 99366 1516]2020-06-18 16:33:56 140471675044352 [Warning] Could not increase number of max_open_files to more than 10240 (request: 32188) # 2020-06-18T16:40:26 [98616] | [rr 99366 1563]2020-06-18 16:33:56 140471675044352 [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-18T16:40:26 [98616] | [rr 99366 1633]2020-06-18 16:33:56 140471675044352 [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-18T16:40:26 [98616] | [rr 99366 1681]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: innodb_page_size=65536 # 2020-06-18T16:40:26 [98616] | [rr 99366 1685]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! # 2020-06-18T16:40:26 [98616] | [rr 99366 1689]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins # 2020-06-18T16:40:26 [98616] | [rr 99366 1693]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Uses event mutexes # 2020-06-18T16:40:26 [98616] | [rr 99366 1697]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Compressed tables use zlib 1.2.11 # 2020-06-18T16:40:26 [98616] | [rr 99366 1703]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Number of pools: 1 # 2020-06-18T16:40:26 [98616] | [rr 99366 1709]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Using SSE2 crc32 instructions # 2020-06-18T16:40:26 [98616] | [rr 99366 1739]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M # 2020-06-18T16:40:26 [98616] | [rr 99366 1759]2020-06-18 16:33:56 140471675044352 [Note] InnoDB: Completed initialization of buffer pool # 2020-06-18T16:40:26 [98616] | [rr 99366 2077]2020-06-18 16:33:57 6027331311360 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). # 2020-06-18T16:40:26 [98616] | [rr 99366 2135]2020-06-18 16:33:57 140471675044352 [Note] InnoDB: Highest supported file format is Barracuda. # 2020-06-18T16:40:26 [98616] | [rr 99366 3162]2020-06-18 16:33:57 140471675044352 [Note] InnoDB: 128 out of 128 rollback segments are active. # 2020-06-18T16:40:26 [98616] | [rr 99366 3234]2020-06-18 16:33:57 140471675044352 [Note] InnoDB: Creating shared tablespace for temporary tables # 2020-06-18T16:40:26 [98616] | [rr 99366 3238]2020-06-18 16:33:57 140471675044352 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... # 2020-06-18T16:40:26 [98616] | [rr 99366 3246]2020-06-18 16:33:57 140471675044352 [Note] InnoDB: File './ibtmp1' size is now 12 MB. # 2020-06-18T16:40:26 [98616] | [rr 99366 4101]2020-06-18 16:33:58 140471675044352 [Note] InnoDB: 5.7.30 started; log sequence number 6063971 # 2020-06-18T16:40:26 [98616] | [rr 99366 4137]2020-06-18 16:33:58 116655630395136 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/1592496496/250/1/data/ib_buffer_pool # 2020-06-18T16:40:26 [98616] | [rr 99366 4326]2020-06-18 16:33:58 116655630395136 [Note] InnoDB: Buffer pool(s) load completed at 200618 16:33:58 # 2020-06-18T16:40:26 [98616] | [rr 99366 4474]2020-06-18 16:33:58 140471675044352 [Note] Plugin 'FEEDBACK' is disabled. # 2020-06-18T16:40:26 [98616] | [rr 99366 4478]2020-06-18 16:33:58 140471675044352 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-idle_write_transaction_timeout=0' # 2020-06-18T16:40:26 [98616] | [rr 99366 4482]2020-06-18 16:33:58 140471675044352 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-idle_transaction_timeout=0' # 2020-06-18T16:40:26 [98616] | [rr 99366 4486]2020-06-18 16:33:58 140471675044352 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-idle_readonly_transaction_timeout=0' # 2020-06-18T16:40:26 [98616] | [rr 99366 4490]2020-06-18 16:33:58 140471675044352 [Warning] /home/mleich/Server_bin/10.2_debug//bin/mysqld: unknown variable 'loose-table_lock_wait_timeout=50' # 2020-06-18T16:40:26 [98616] | [rr 99366 4634]2020-06-18 16:33:59 140471675044352 [Note] Server socket created on IP: '::'. # 2020-06-18T16:40:26 [98616] | [rr 99366 5600]2020-06-18 16:33:59 140471675044352 [Note] Reading of all Master_info entries succeeded # 2020-06-18T16:40:26 [98616] | [rr 99366 5604]2020-06-18 16:33:59 140471675044352 [Note] Added new Master_info '' to hash table # 2020-06-18T16:40:26 [98616] | [rr 99366 5610]2020-06-18 16:33:59 140471675044352 [Note] /home/mleich/Server_bin/10.2_debug//bin/mysqld: ready for connections. # 2020-06-18T16:40:26 [98616] | Version: '10.2.33-MariaDB-debug-log' socket: '/dev/shm/vardir/1592496496/250/1/mysql.sock' port: 29580 Source distribution # 2020-06-18T16:40:26 [98616] | [rr 99366 5814]2020-06-18 16:33:59 132917109475072 [Warning] Aborted connection 10 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 24707]2020-06-18 16:34:04 132917109475072 [Warning] Aborted connection 11 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 25083]2020-06-18 16:34:04 132917109475072 [Warning] Aborted connection 12 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 25720]2020-06-18 16:34:05 132917109475072 [Warning] Aborted connection 13 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 26314]2020-06-18 16:34:05 132917109475072 [Warning] Aborted connection 14 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 26649]2020-06-18 16:34:05 132917109475072 [Warning] Aborted connection 15 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 32177]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'ha_blackhole.so' with offset 0x5590c3d73000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32198]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'ha_archive.so' with offset 0x33040db4a000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32218]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'ha_test_sql_discovery.so' with offset 0x5bcf60000000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32238]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'qa_auth_client.so' with offset 0x2e46751f6000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32258]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'ha_federated.so' with offset 0x59a384000000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32278]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'mysql_clear_password.so' with offset 0x7fc2032fe000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32298]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'mypluglib.so' with offset 0x7fc2032fd000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32318]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'auth_socket.so' with offset 0x480408000000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32338]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'wsrep_info.so' with offset 0x186d5521a000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32358]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'qa_auth_server.so' with offset 0x32740dbf8000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32378]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'query_cache_info.so' with offset 0x7fc2032fc000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32398]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'libdaemon_example.so' with offset 0x7caf32d26000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32418]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'ha_example.so' with offset 0x5f346ec65000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32438]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'handlersocket.so' with offset 0x3a27412d4000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32458]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'dialog_examples.so' with offset 0x652d4cac0000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32478]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'file_key_management.so' with offset 0x1c3739b1d000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32500]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'server_audit.so' with offset 0x139268000000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32520]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'locales.so' with offset 0x25a73d491000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32540]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'query_response_time.so' with offset 0x7fc21d0d5000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32560]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'disks.so' with offset 0x17db52abd000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32580]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'auth_0x0100.so' with offset 0x6ed8229b1000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32600]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'simple_password_check.so' with offset 0xa114be63000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32620]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'example_key_management.so' with offset 0x149f190d5000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32640]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'debug_key_management.so' with offset 0x702f6a947000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32660]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'semisync_master.so' with offset 0x5590cc000000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32850]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'caching_sha2_password.so' with offset 0x25a744000000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32888]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'dialog.so' with offset 0x5b71637c8000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32908]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'sql_errlog.so' with offset 0x77987a081000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32928]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'qa_auth_interface.so' with offset 0x79c604da2000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32948]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'metadata_lock_info.so' with offset 0x77d8154c2000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32968]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'auth_ed25519.so' with offset 0x248f6209b000 # 2020-06-18T16:40:26 [98616] | [rr 99366 32988]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'ha_federatedx.so' with offset 0x639368502000 # 2020-06-18T16:40:26 [98616] | [rr 99366 33008]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'auth_test_plugin.so' with offset 0x55f611fc000 # 2020-06-18T16:40:26 [98616] | [rr 99366 33197]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'client_ed25519.so' with offset 0x7fc2032ea000 # 2020-06-18T16:40:26 [98616] | [rr 99366 33235]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'semisync_slave.so' with offset 0x7fc21d0d5000 # 2020-06-18T16:40:26 [98616] | [rr 99366 33255]2020-06-18 16:34:08 132917109475072 [Note] Loaded 'adt_null.so' with offset 0x7fc2032fd000 # 2020-06-18T16:40:26 [98616] | [rr 99366 46033]2020-06-18 16:34:10 132917109475072 [Warning] Aborted connection 16 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 47233]2020-06-18 16:34:11 44462133835520 [Warning] Aborted connection 26 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 112250]2020-06-18 16:34:21 44462133835520 [Warning] Aborted connection 27 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 164779]2020-06-18 16:34:31 44462133835520 [Warning] Aborted connection 28 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 205911]2020-06-18 16:34:41 44462133835520 [Warning] Aborted connection 29 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 218529]2020-06-18 16:34:44 0x5ee21748a700[rr 99366 218532] InnoDB: Assertion failure in file /home/mleich/10.2/storage/innobase/include/page0page.ic line 563 # 2020-06-18T16:40:26 [98616] | [rr 99366 218534]InnoDB: Failing assertion: page_offset(rec) <= page_header_get_field(page, PAGE_HEAP_TOP) # 2020-06-18T16:40:26 [98616] | [rr 99366 218536]InnoDB: We intentionally generate a memory trap. # 2020-06-18T16:40:26 [98616] | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ # 2020-06-18T16:40:26 [98616] | InnoDB: If you get repeated assertion failures or crashes, even # 2020-06-18T16:40:26 [98616] | InnoDB: immediately after the mysqld startup, there may be # 2020-06-18T16:40:26 [98616] | InnoDB: corruption in the InnoDB tablespace. Please refer to # 2020-06-18T16:40:26 [98616] | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ # 2020-06-18T16:40:26 [98616] | InnoDB: about forcing recovery. # 2020-06-18T16:40:26 [98616] | [rr 99366 218554]200618 16:34:44 [rr 99366 218557][ERROR] mysqld got signal 6 ; # 2020-06-18T16:40:26 [98616] | [rr 99366 218559]This could be because you hit a bug. It is also possible that this binary # 2020-06-18T16:40:26 [98616] | or one of the libraries it was linked against is corrupt, improperly built, # 2020-06-18T16:40:26 [98616] | or misconfigured. This error can also be caused by malfunctioning hardware. # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | [rr 99366 218561]To report this bug, see https://mariadb.com/kb/en/reporting-bugs # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | [rr 99366 218563]We will try our best to scrape up some info that will hopefully help # 2020-06-18T16:40:26 [98616] | diagnose the problem, but since we have already crashed, # 2020-06-18T16:40:26 [98616] | something is definitely wrong and this may fail. # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | [rr 99366 218565]Server version: 10.2.33-MariaDB-debug-log # 2020-06-18T16:40:26 [98616] | [rr 99366 218567]key_buffer_size=134217728 # 2020-06-18T16:40:26 [98616] | [rr 99366 218569]read_buffer_size=131072 # 2020-06-18T16:40:26 [98616] | [rr 99366 218571]max_used_connections=11 # 2020-06-18T16:40:26 [98616] | [rr 99366 218573]max_threads=153 # 2020-06-18T16:40:26 [98616] | [rr 99366 218575]thread_count=18 # 2020-06-18T16:40:26 [98616] | [rr 99366 218577]It is possible that mysqld could use up to # 2020-06-18T16:40:26 [98616] | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467327 K bytes of memory # 2020-06-18T16:40:26 [98616] | [rr 99366 218579]Hope that's ok; if not, decrease some variables in the equation. # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | [rr 99366 218581]Thread pointer: 0x2b5438000ce8 # 2020-06-18T16:40:26 [98616] | [rr 99366 218583]Attempting backtrace. You can use the following information to find out # 2020-06-18T16:40:26 [98616] | where mysqld died. If you see no messages after this, something went # 2020-06-18T16:40:26 [98616] | terribly wrong... # 2020-06-18T16:40:26 [98616] | [rr 99366 218587]stack_bottom = 0x5ee217489ea0 thread_stack 0x49000 # 2020-06-18T16:40:26 [98616] | [rr 99366 219156]/home/mleich/Server_bin/10.2_debug//bin/mysqld(my_print_stacktrace+0x38)[0x5590c26eb0bb] # 2020-06-18T16:40:26 [98616] | [rr 99366 219927]/home/mleich/Server_bin/10.2_debug//bin/mysqld(handle_fatal_signal+0x3a3)[0x5590c1f53e70] # 2020-06-18T16:40:26 [98616] | [rr 99366 236263]/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x2d7b24647890] # 2020-06-18T16:40:26 [98616] | [rr 99366 237560]/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x4d07d984e97] # 2020-06-18T16:40:26 [98616] | [rr 99366 237817]/lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x4d07d986801] # 2020-06-18T16:40:26 [98616] | [rr 99366 242037]2020-06-18 16:34:51 94080261920512 [Warning] Aborted connection 22 to db: 'test' user: 'root' host: 'localhost' (KILLED) # 2020-06-18T16:40:26 [98616] | [rr 99366 242047]2020-06-18 16:34:51 44462133835520 [Warning] Aborted connection 30 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 248281]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc6d3fb)[0x5590c235d3fb] # 2020-06-18T16:40:26 [98616] | [rr 99366 248439]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xac60d3)[0x5590c21b60d3] # 2020-06-18T16:40:26 [98616] | [rr 99366 248485]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xad3f5d)[0x5590c21c3f5d] # 2020-06-18T16:40:26 [98616] | [rr 99366 248525]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xcb61c8)[0x5590c23a61c8] # 2020-06-18T16:40:26 [98616] | [rr 99366 248570]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xcd329d)[0x5590c23c329d] # 2020-06-18T16:40:26 [98616] | [rr 99366 248747]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xd6c7a4)[0x5590c245c7a4] # 2020-06-18T16:40:26 [98616] | [rr 99366 248865]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xd6ceff)[0x5590c245ceff] # 2020-06-18T16:40:26 [98616] | [rr 99366 249018]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xd7069b)[0x5590c246069b] # 2020-06-18T16:40:26 [98616] | [rr 99366 249041]ut/ut0new.cc:97(ut_new_boot())[0x5590c245ef4e] # 2020-06-18T16:40:26 [98616] | [rr 99366 249115]include/page0page.ic:564(page_rec_check(unsigned char const*))[0x5590c2358d2f] # 2020-06-18T16:40:26 [98616] | [rr 99366 249212]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc6b1f8)[0x5590c235b1f8] # 2020-06-18T16:40:26 [98616] | [rr 99366 249356]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc6ba63)[0x5590c235ba63] # 2020-06-18T16:40:26 [98616] | [rr 99366 249480]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc49641)[0x5590c2339641] # 2020-06-18T16:40:26 [98616] | [rr 99366 249604]/home/mleich/Server_bin/10.2_debug//bin/mysqld(+0xc9be37)[0x5590c238be37] # 2020-06-18T16:40:26 [98616] | [rr 99366 249652]include/page0page.ic:297(page_rec_is_supremum(unsigned char const*))[0x5590c238c7a4] # 2020-06-18T16:40:26 [98616] | [rr 99366 249717]btr/btr0sea.cc:1212(btr_search_drop_page_hash_index(buf_block_t*))[0x5590c2272718] # 2020-06-18T16:40:26 [98616] | [rr 99366 249783]buf/buf0buf.cc:5619(buf_page_create(page_id_t, page_size_t const&, mtr_t*))[0x5590c2273b83] # 2020-06-18T16:40:26 [98616] | [rr 99366 249851]fsp/fsp0fsp.cc:1309(fsp_page_create(fil_space_t*, unsigned long, page_size_t const&, rw_lock_type_t, mtr_t*, mtr_t*))[0x5590c2273f84] # 2020-06-18T16:40:26 [98616] | [rr 99366 249868]fsp/fsp0fsp.cc:2519(fseg_alloc_free_page_low(fil_space_t*, page_size_t const&, unsigned char*, unsigned long, unsigned char, rw_lock_type_t, mtr_t*, mtr_t*, unsigned long))[0x5590c22744a6] # 2020-06-18T16:40:26 [98616] | [rr 99366 249912]fsp/fsp0fsp.cc:2099(fseg_create_general(unsigned long, unsigned long, unsigned long, unsigned long, mtr_t*))[0x5590c227487c] # 2020-06-18T16:40:26 [98616] | [rr 99366 249952]trx/trx0undo.cc:449(trx_undo_seg_create(trx_rseg_t*, unsigned char*, unsigned long, unsigned long*, unsigned char**, mtr_t*))[0x5590c2274c29] # 2020-06-18T16:40:26 [98616] | [rr 99366 249967]trx/trx0undo.cc:1423(trx_undo_create(trx_t*, trx_rseg_t*, unsigned long, unsigned long, xid_t const*, trx_undo_t**, mtr_t*))[0x5590c22925cb] # 2020-06-18T16:40:26 [98616] | [rr 99366 250034]trx/trx0rec.cc:2071(trx_undo_report_row_operation(que_thr_t*, dict_index_t*, dtuple_t const*, upd_t const*, unsigned long, unsigned char const*, unsigned short const*, unsigned long*))[0x5590c2157851] # 2020-06-18T16:40:26 [98616] | [rr 99366 250091]btr/btr0cur.cc:2968(btr_cur_ins_lock_and_undo(unsigned long, btr_cur_t*, dtuple_t*, que_thr_t*, mtr_t*, unsigned long*))[0x5590c1f63980] # 2020-06-18T16:40:26 [98616] | [rr 99366 250106]btr/btr0cur.cc:3182(btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x5590c1cb8bf2] # 2020-06-18T16:40:26 [98616] | [rr 99366 250121]row/row0ins.cc:3142(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, unsigned long))[0x5590c1cbe112] # 2020-06-18T16:40:26 [98616] | [rr 99366 250139]row/row0ins.cc:3261(row_ins_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x5590c1d4e94f] # 2020-06-18T16:40:26 [98616] | [rr 99366 250152]row/row0ins.cc:3412(row_ins_index_entry_step(ins_node_t*, que_thr_t*))[0x5590c1d4bc48] # 2020-06-18T16:40:26 [98616] | [rr 99366 250167]row/row0ins.cc:3549(row_ins(ins_node_t*, que_thr_t*))[0x5590c1d4b6e7] # 2020-06-18T16:40:26 [98616] | [rr 99366 250200]row/row0mysql.cc:1415(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*))[0x5590c1d4aabb] # 2020-06-18T16:40:26 [98616] | [rr 99366 250313]handler/ha_innodb.cc:8206(ha_innobase::write_row(unsigned char*))[0x5590c1d2469a] # 2020-06-18T16:40:26 [98616] | [rr 99366 250378]sql/handler.cc:6108(handler::ha_write_row(unsigned char*))[0x5590c1d23b52] # 2020-06-18T16:40:26 [98616] | [rr 99366 250436]sql/sql_insert.cc:1941(write_record(THD*, TABLE*, st_copy_info*))[0x5590c1d24d0c] # 2020-06-18T16:40:26 [98616] | [rr 99366 250463]sql/sql_insert.cc:3834(select_insert::send_data(List&))[0x5590c1d18eb3] # 2020-06-18T16:40:26 [98616] | [rr 99366 250555]sql/sql_select.cc:20193(end_send_group(JOIN*, st_join_table*, bool))[0x5590c1cdd631] # 2020-06-18T16:40:26 [98616] | [rr 99366 250568]sql/sql_select.cc:19093(evaluate_join_record(JOIN*, st_join_table*, int))[0x5590c1d06033] # 2020-06-18T16:40:26 [98616] | [rr 99366 250605]sql/sql_select.cc:18417(do_select(JOIN*, Procedure*))[0x5590c1d0456a] # 2020-06-18T16:40:26 [98616] | [rr 99366 250623]sql/sql_select.cc:3638(JOIN::exec_inner())[0x5590c1d02335] # 2020-06-18T16:40:26 [98616] | [rr 99366 250647]sql/sql_select.cc:3434(JOIN::exec())[0x5590c1cdb1ef] # 2020-06-18T16:40:26 [98616] | [rr 99366 250672]sql/sql_select.cc:3835(mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5590c1ce867d] # 2020-06-18T16:40:26 [98616] | [rr 99366 250763]sql/sql_parse.cc:4283(mysql_execute_command(THD*))[0x5590c1cd698a] # 2020-06-18T16:40:26 [98616] | [rr 99366 250819]2020-06-18 16:35:01 44462133835520 [Warning] Aborted connection 31 to db: 'test' user: 'root' host: 'localhost' (CLOSE_CONNECTION) # 2020-06-18T16:40:26 [98616] | [rr 99366 250864]sql/sql_prepare.cc:4842(Prepared_statement::execute(String*, bool))[0x5590c1cd5407] # 2020-06-18T16:40:26 [98616] | [rr 99366 250879]sql/sql_prepare.cc:3380(mysql_sql_stmt_execute(THD*))[0x5590c1e2b28d] # 2020-06-18T16:40:26 [98616] | [rr 99366 250892]sql/sql_parse.cc:7741(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5590c1e2aff8] # 2020-06-18T16:40:26 [98616] | [rr 99366 251069]/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x2d7b2463c6db] # 2020-06-18T16:40:26 [98616] | [rr 99366 253140]2020-06-18 16:35:12 94080261920512 [Warning] Aborted connection 24 to db: 'test' user: 'root' host: 'localhost' (KILLED) # 2020-06-18T16:40:26 [98616] | [rr 99366 253277]/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x4d07da6788f] # 2020-06-18T16:40:26 [98616] | [rr 99366 253279] # 2020-06-18T16:40:26 [98616] | Trying to get some variables. # 2020-06-18T16:40:26 [98616] | Some pointers may be invalid and cause the dump to abort. # 2020-06-18T16:40:26 [98616] | [rr 99366 253281]Query (0x2b5438010890): [rr 99366 253293]I[rr 99366 253295]N[rr 99366 253297]S[rr 99366 253299]E[rr 99366 253301]R[rr 99366 253303]T[rr 99366 253305] [rr 99366 253307]I[rr 99366 253309]N[rr 99366 253311]T[rr 99366 253313]O[rr 99366 253315] [rr 99366 253317]`[rr 99366 253319]p[rr 99366 253321]s[rr 99366 253323]`[rr 99366 253325] [rr 99366 253327] [rr 99366 253329]S[rr 99366 253331]E[rr 99366 253333]L[rr 99366 253335]E[rr 99366 253337]C[rr 99366 253339]T[rr 99366 253341] [rr 99366 253343]([rr 99366 253345] [rr 99366 253347]U[rr 99366 253349]p[rr 99366 253351]d[rr 99366 253353]a[rr 99366 253355]t[rr 99366 253357]e[rr 99366 253359]X[rr 99366 253361]M[rr 99366 253363]L[rr 99366 253365]([rr 99366 253367] [rr 99366 253369]'[rr 99366 253371]j[rr 99366 253373]'[rr 99366 253375],[rr 99366 253377] [rr 99366 253379]'[rr 99366 253381]/[rr 99366 253383]c[rr 99366 253385]/[rr 99366 253387]d[rr 99366 253389]b[rr 99366 253391]c[rr 99366 253393]b[rr 99366 253395]d[rr 99366 253397]c[rr 99366 253399]/[rr 99366 253401]c[rr 99366 253403]b[rr 99366 253405]a[rr 99366 253407]c[rr 99366 253409]b[rr 99366 253411]e[rr 99366 253413]a[rr 99366 253415]d[rr 99366 253417]e[rr 99366 253419]c[rr 99366 253421]c[rr 99366 253423]/[rr 99366 253425]d[rr 99366 253427]/[rr 99366 253429]e[rr 99366 253431]a[rr 99366 253433]d[rr 99366 253435]d[rr 99366 253437]/[rr 99366 253439]a[rr 99366 253441]c[rr 99366 253443]b[rr 99366 253445]e[rr 99366 253447]e[rr 99366 253449]b[rr 99366 253451]e[rr 99366 253453]c[rr 99366 253455]d[rr 99366 253457]/[rr 99366 253459]c[rr 99366 253461]b[rr 99366 253463]a[rr 99366 253465]a[rr 99366 253467]b[rr 99366 253469]e[rr 99366 253471]c[rr 99366 253473]b[rr 99366 253475]d[rr 99366 253477]b[rr 99366 253479]/[rr 99366 253481]d[rr 99366 253483]/[rr 99366 253485]b[rr 99366 253487]e[rr 99366 253489]e[rr 99366 253491]d[rr 99366 253493]b[rr 99366 253495]d[rr 99366 253497]c[rr 99366 253499]b[rr 99366 253501]e[rr 99366 253503]/[rr 99366 253505]d[rr 99366 253507]a[rr 99366 253509]a[rr 99366 253511]a[rr 99366 253513]/[rr 99366 253515]c[rr 99366 253517]a[rr 99366 253519]c[rr 99366 253521]e[rr 99366 253523]c[rr 99366 253525]d[rr 99366 253527]d[rr 99366 253529]d[rr 99366 253531]'[rr 99366 253533],[rr 99366 253535] [rr 99366 253537]'[rr 99366 253539]m[rr 99366 253541]'[rr 99366 253543] [rr 99366 253545])[rr 99366 253547] [rr 99366 253549])[rr 99366 253551] [rr 99366 253553]^[rr 99366 253555] [rr 99366 253557]([rr 99366 253559] [rr 99366 253561]D[rr 99366 253563]A[rr 99366 253565]Y[rr 99366 253567]O[rr 99366 253569]F[rr 99366 253571]W[rr 99366 253573]E[rr 99366 253575]E[rr 99366 253577]K[rr 99366 253579]([rr 99366 253581] [rr 99366 253583]'[rr 99366 253585]g[rr 99366 253587]l[rr 99366 253589]b[rr 99366 253591]e[rr 99366 253593]n[rr 99366 253595]h[rr 99366 253597]x[rr 99366 253599]t[rr 99366 253601]h[rr 99366 253603]m[rr 99366 253605]a[rr 99366 253607]z[rr 99366 253609]w[rr 99366 253611]h[rr 99366 253613]q[rr 99366 253615]q[rr 99366 253617]z[rr 99366 253619]i[rr 99366 253621]q[rr 99366 253623]t[rr 99366 253625]q[rr 99366 253627]q[rr 99366 253629]o[rr 99366 253631]i[rr 99366 253633]m[rr 99366 253635]v[rr 99366 253637]i[rr 99366 253639]l[rr 99366 253641]n[rr 99366 253643]j[rr 99366 253645]n[rr 99366 253647]m[rr 99366 253649]v[rr 99366 253651]w[rr 99366 253653]h[rr 99366 253655]v[rr 99366 253657]m[rr 99366 253659]v[rr 99366 253661]w[rr 99366 253663]u[rr 99366 253665]j[rr 99366 253667]k[rr 99366 253669]f[rr 99366 253671]s[rr 99366 253673]y[rr 99366 253675]b[rr 99366 253677]e[rr 99366 253679]i[rr 99366 253681]a[rr 99366 253683]x[rr 99366 253685]i[rr 99366 253687]i[rr 99366 253689]m[rr 99366 253691]e[rr 99366 253693]z[rr 99366 253695]s[rr 99366 253697]s[rr 99366 253699]z[rr 99366 253701]h[rr 99366 253703]r[rr 99366 253705]g[rr 99366 253707]d[rr 99366 253709]p[rr 99366 253711]s[rr 99366 253713]m[rr 99366 253715]h[rr 99366 253717]c[rr 99366 253719]j[rr 99366 253721]y[rr 99366 253723]g[rr 99366 253725]k[rr 99366 253727]b[rr 99366 253729]b[rr 99366 253731]j[rr 99366 253733]b[rr 99366 253735]r[rr 99366 253737]w[rr 99366 253739]y[rr 99366 253741]y[rr 99366 253743]k[rr 99366 253745]m[rr 99366 253747]w[rr 99366 253749]e[rr 99366 253751]g[rr 99366 253753]n[rr 99366 253755]e[rr 99366 253757]f[rr 99366 253759]a[rr 99366 253761]u[rr 99366 253763]y[rr 99366 253765]u[rr 99366 253767]g[rr 99366 253769]w[rr 99366 253771]m[rr 99366 253773]w[rr 99366 253775]v[rr 99366 253777]l[rr 99366 253779]y[rr 99366 253781]d[rr 99366 253783]a[rr 99366 253785]s[rr 99366 253787]b[rr 99366 253789]k[rr 99366 253791]q[rr 99366 253793]e[rr 99366 253795]w[rr 99366 253797]l[rr 99366 253799]p[rr 99366 253801]z[rr 99366 253803]p[rr 99366 253809]t[rr 99366 253814]o[rr 99366 253816]l[rr 99366 253818]x[rr 99366 253820]k[rr 99366 253822]q[rr 99366 253824]f[rr 99366 253826]k[rr 99366 253828]k[rr 99366 253830]r[rr 99366 253832]a[rr 99366 253834]t[rr 99366 253836]z[rr 99366 253838]w[rr 99366 253840]o[rr 99366 253842]i[rr 99366 253844]f[rr 99366 253846]r[rr 99366 253848]s[rr 99366 253850]f[rr 99366 253852]y[rr 99366 253854]g[rr 99366 253856]i[rr 99366 253858]y[rr 99366 253860]b[rr 99366 253862]g[rr 99366 253864]g[rr 99366 253866]c[rr 99366 253868]j[rr 99366 253870]y[rr 99366 253872]v[rr 99366 253874]q[rr 99366 253876]k[rr 99366 253878]o[rr 99366 253880]y[rr 99366 253882]v[rr 99366 253884]o[rr 99366 253886]b[rr 99366 253888]'[rr 99366 253890] [rr 99366 253892])[rr 99366 253894] [rr 99366 253896])[rr 99366 253898] [rr 99366 253900]A[rr 99366 253902]S[rr 99366 253904] [rr 99366 253906]f[rr 99366 253908]i[rr 99366 253910]e[rr 99366 253912]l[rr 99366 253914]d[rr 99366 253916]1[rr 99366 253918],[rr 99366 253920] [rr 99366 253922]B[rr 99366 253924]I[rr 99366 253926]T[rr 99366 253928]_[rr 99366 253930]X[rr 99366 253932]O[rr 99366 253934]R[rr 99366 253936]([rr 99366 253938] [rr 99366 253940]-[rr 99366 253942]2[rr 99366 253944]8[rr 99366 253946]5[rr 99366 253948]6[rr 99366 253950]6[rr 99366 253952]8[rr 99366 253954]9[rr 99366 253956]5[rr 99366 253958]3[rr 99366 253960]8[rr 99366 253962]6[rr 99366 253964]3[rr 99366 253966]6[rr 99366 253968]4[rr 99366 253970]4[rr 99366 253972]7[rr 99366 253974]7[rr 99366 253976]4[rr 99366 253978]4[rr 99366 253980] [rr 99366 253982])[rr 99366 253984] [rr 99366 253986]A[rr 99366 253988]S[rr 99366 253990] [rr 99366 253992]f[rr 99366 253994]i[rr 99366 253996]e[rr 99366 253998]l[rr 99366 254000]d[rr 99366 254002]2[rr 99366 254004] [rr 99366 254006]F[rr 99366 254008]R[rr 99366 254010]O[rr 99366 254012]M[rr 99366 254014] [rr 99366 254016]`[rr 99366 254018]v[rr 99366 254020]i[rr 99366 254022]e[rr 99366 254024]w[rr 99366 254026]_[rr 99366 254028]E[rr 99366 254030]`[rr 99366 254032] [rr 99366 254034]G[rr 99366 254036]R[rr 99366 254038]O[rr 99366 254040]U[rr 99366 254042]P[rr 99366 254044] [rr 99366 254046]B[rr 99366 254048]Y[rr 99366 254050] [rr 99366 254052]`[rr 99366 254054]c[rr 99366 254056]o[rr 99366 254058]l[rr 99366 254060]_[rr 99366 254062]t[rr 99366 254064]i[rr 99366 254066]m[rr 99366 254068]e[rr 99366 254070]_[rr 99366 254072]n[rr 99366 254074]o[rr 99366 254076]k[rr 99366 254078]e[rr 99366 254080]y[rr 99366 254082]`[rr 99366 254084] [rr 99366 254086]I[rr 99366 254088]S[rr 99366 254090] [rr 99366 254092]U[rr 99366 254094]N[rr 99366 254096]K[rr 99366 254098]N[rr 99366 254100]O[rr 99366 254102]W[rr 99366 254104]N[rr 99366 254106] [rr 99366 254108]W[rr 99366 254110]I[rr 99366 254112]T[rr 99366 254114]H[rr 99366 254116] [rr 99366 254118]R[rr 99366 254120]O[rr 99366 254122]L[rr 99366 254124]L[rr 99366 254126]U[rr 99366 254128]P[rr 99366 254132] # 2020-06-18T16:40:26 [98616] | Connection ID (thread ID): 18 # 2020-06-18T16:40:26 [98616] | [rr 99366 254134]Status: NOT_KILLED # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | [rr 99366 254136]Optimizer switch: [rr 99366 254138]index_merge=on[rr 99366 254140],[rr 99366 254142]index_merge_union=on[rr 99366 254144],[rr 99366 254146]index_merge_sort_union=on[rr 99366 254148],[rr 99366 254150]index_merge_intersection=on[rr 99366 254152],[rr 99366 254154]index_merge_sort_intersection=off[rr 99366 254156],[rr 99366 254158]engine_condition_pushdown=off[rr 99366 254160],[rr 99366 254162]index_condition_pushdown=on[rr 99366 254164],[rr 99366 254166]derived_merge=on[rr 99366 254168],[rr 99366 254170]derived_with_keys=on[rr 99366 254172],[rr 99366 254174]firstmatch=on[rr 99366 254176],[rr 99366 254178]loosescan=on[rr 99366 254180],[rr 99366 254182]materialization=on[rr 99366 254184],[rr 99366 254186]in_to_exists=on[rr 99366 254188],[rr 99366 254190]semijoin=on[rr 99366 254192],[rr 99366 254194]partial_match_rowid_merge=on[rr 99366 254196],[rr 99366 254198]partial_match_table_scan=on[rr 99366 254200],[rr 99366 254202]subquery_cache=on[rr 99366 254204],[rr 99366 254206]mrr=off[rr 99366 254208],[rr 99366 254210]mrr_cost_based=off[rr 99366 254212],[rr 99366 254214]mrr_sort_keys=off[rr 99366 254216],[rr 99366 254218]outer_join_with_cache=on[rr 99366 254220],[rr 99366 254222]semijoin_with_cache=on[rr 99366 254224],[rr 99366 254226]join_cache_incremental=on[rr 99366 254228],[rr 99366 254230]join_cache_hashed=on[rr 99366 254232],[rr 99366 254234]join_cache_bka=on[rr 99366 254236],[rr 99366 254238]optimize_join_buffer_size=off[rr 99366 254240],[rr 99366 254242]table_elimination=on[rr 99366 254244],[rr 99366 254246]extended_keys=on[rr 99366 254248],[rr 99366 254250]exists_to_in=on[rr 99366 254252],[rr 99366 254254]orderby_uses_equalities=on[rr 99366 254256],[rr 99366 254258]condition_pushdown_for_derived=on[rr 99366 254260] # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | [rr 99366 254262]The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains # 2020-06-18T16:40:26 [98616] | information that should help you find out what is causing the crash. # 2020-06-18T16:40:26 [98616] | [rr 99366 254265]Writing a core file... # 2020-06-18T16:40:26 [98616] | Working directory at /dev/shm/vardir/1592496496/250/1/data # 2020-06-18T16:40:26 [98616] | [rr 99366 254275]Resource Limits: # 2020-06-18T16:40:26 [98616] | [rr 99366 254281]Limit Soft Limit Hard Limit Units # 2020-06-18T16:40:26 [98616] | Max cpu time unlimited unlimited seconds # 2020-06-18T16:40:26 [98616] | Max file size unlimited unlimited bytes # 2020-06-18T16:40:26 [98616] | Max data size unlimited unlimited bytes # 2020-06-18T16:40:26 [98616] | Max stack size 8388608 unlimited bytes # 2020-06-18T16:40:26 [98616] | Max core file size 0 0 bytes # 2020-06-18T16:40:26 [98616] | Max resident set unlimited unlimited bytes # 2020-06-18T16:40:26 [98616] | Max processes 1541946 1541946 processes # 2020-06-18T16:40:26 [98616] | Max open files 10240 10240 files # 2020-06-18T16:40:26 [98616] | Max locked memory 16777216 16777216 bytes # 2020-06-18T16:40:26 [98616] | Max address space unlimited unlimited bytes # 2020-06-18T16:40:26 [98616] | Max file locks unlimited unlimited locks # 2020-06-18T16:40:26 [98616] | Max pending signals 1541946 1541946 signals # 2020-06-18T16:40:26 [98616] | Max msgqueue size 819200 819200 bytes # 2020-06-18T16:40:26 [98616] | Max nice priority 0 0 # 2020-06-18T16:40:26 [98616] | Max realtime priority 0 0 # 2020-06-18T16:40:26 [98616] | Max realtime timeout unlimited unlimited us # 2020-06-18T16:40:26 [98616] | [rr 99366 254297]Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E # 2020-06-18T16:40:26 [98616] | # 2020-06-18T16:40:26 [98616] | Aborted # 2020-06-18T16:40:26 [98616] ---------------------------------- # 2020-06-18T16:40:26 [98616] INFO: Reporter 'ErrorLog' ------------------------------ End # 2020-06-18T16:40:26 [98616] error_log is /dev/shm/vardir/1592496496/250/1/data/../mysql.err # 2020-06-18T16:40:26 [98616] pid_file is /dev/shm/vardir/1592496496/250/1/mysql.pid # 2020-06-18T16:40:27 [98616] DEBUG: server pid : 99366 , server_running : 0 # 2020-06-18T16:40:27 [98616] INFO: Reporter 'ServerDead': The process of the DB server 99366 is no more running. Will return STATUS_SERVER_CRASHED. # 2020-06-18T16:40:27 [98616] ERROR: ReporterManager : Reporter 'ServerDead' reported 101 # 2020-06-18T16:40:27 [98616] INFO: The reporters to be run at test end delivered status 101. # 2020-06-18T16:40:27 [98616] Test completed with failure status STATUS_SERVER_CRASHED (101) # 2020-06-18T16:40:27 [98616] GenTest returned status STATUS_SERVER_CRASHED (101) # 2020-06-18T16:40:27 [98616] INFO: RQG GenTest runtime in s : 383 # 2020-06-18T16:40:27 [98616] RESULT: The core of the RQG run ended with status STATUS_SERVER_CRASHED (101) # 2020-06-18T16:40:27 [98616] Killing server(s)... # 2020-06-18T16:40:27 [98616] INFO: DBServer::MySQL::MySQLd::killServer: The server with process [99366] is already no more running. Will return DBSTATUS_OK. # 2020-06-18T16:40:27 [98616] INFO: Any remaining servers were killed. # 2020-06-18T16:40:27 [98616] RESULT: The RQG run ended with status STATUS_SERVER_CRASHED (101) # 2020-06-18T16:40:27 [98616] MATCHING: Region end ===================== # 2020-06-18T16:40:27 [98616] Killing server(s)... # 2020-06-18T16:40:27 [98616] INFO: DBServer::MySQL::MySQLd::killServer: Killing the server process impossible because no server pid found. # 2020-06-18T16:40:27 [98616] INFO: RQG total runtime in s : 395 # 2020-06-18T16:40:27 [98616] DEBUG: 'du -sk /dev/shm/vardir/1592496496/250 | cut -f1' exited with value 0 # 2020-06-18T16:40:27 [98616] INFO: vardir_size : 345256 # 2020-06-18T16:40:27 [98616] SUMMARY: Final command line: ->perl /home/mleich/RQG_mleich/rqg.pl --redefine=conf/mariadb/general-workarounds.yy --views --vcols --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/xa.yy --grammar=conf/mariadb/functions.yy --reporters=Backtrace,Deadlock1,ErrorLog --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --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 --threads=9 --mysqld=--innodb_page_size=64K --mysqld=--innodb-buffer-pool-size=24M --duration=300 --no_mask --workdir=/home/mleich/RQG_mleich/storage/1592496496/250 --vardir=/dev/shm/vardir/1592496496/250 --mtr-build-thread=979 --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=21007<- # 2020-06-18T16:40:27 [98616] SUMMARY: RQG GenData runtime in s : 5 # 2020-06-18T16:40:27 [98616] SUMMARY: RQG GenTest runtime in s : 383 # 2020-06-18T16:40:27 [98616] SUMMARY: RQG total runtime in s : 395 # 2020-06-18T16:40:27 [98616] /home/mleich/RQG_mleich/rqg.pl will exit with exit status STATUS_SERVER_CRASHED(101)