Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.6
origin/10.6, 10.6 74281fe1fb0faf444aec3744b90995156f9f58f9 2021-02-24T15:52:55+02:00
Thread 3 received signal SIGSEGV, Segmentation fault.
[Switching to Thread 2910372.2922937]
0x0000563c4f30c373 in row_create_prebuilt (table=0x618000050d20, mysql_row_len=25) at /Server/10.6M/storage/innobase/row/row0mysql.cc:882
882 ulint type = temp_index->fields[i].col->mtype;
(rr) bt
#0 0x0000563c4f30c373 in row_create_prebuilt (table=0x618000050d20, mysql_row_len=25) at /Server/10.6M/storage/innobase/row/row0mysql.cc:882
#1 0x0000563c4ef6fea6 in ha_innobase::open (this=0x61d0009ba0b8, name=0x61b0000b0450 "./test/t4") at /Server/10.6M/storage/innobase/handler/ha_innodb.cc:5531
#2 0x0000563c4e453dc6 in handler::ha_open (this=0x61d0009ba0b8, table_arg=0x619000506998, name=0x61b0000b0450 "./test/t4", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0) at /Server/10.6M/sql/handler.cc:2984
#3 0x0000563c4df9308d in open_table_from_share (thd=0x62b0000d2218, share=0x61b0000afeb8, alias=0x62b0000cb458, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x619000506998, is_create_table=false, partitions_to_open=0x0) at /Server/10.6M/sql/table.cc:4218
#4 0x0000563c4da9ecb7 in open_table (thd=0x62b0000d2218, table_list=0x62b0000cb410, ot_ctx=0x1ce0235a5320) at /Server/10.6M/sql/sql_base.cc:2001
#5 0x0000563c4daa8a53 in open_and_process_table (thd=0x62b0000d2218, tables=0x62b0000cb410, counter=0x1ce0235a5450, flags=0, prelocking_strategy=0x1ce0235a5580, has_prelocking_list=false, ot_ctx=0x1ce0235a5320) at /Server/10.6M/sql/sql_base.cc:3801
#6 0x0000563c4daab5da in open_tables (thd=0x62b0000d2218, options=..., start=0x1ce0235a5460, counter=0x1ce0235a5450, flags=0, prelocking_strategy=0x1ce0235a5580) at /Server/10.6M/sql/sql_base.cc:4275
#7 0x0000563c4dab01f4 in open_and_lock_tables (thd=0x62b0000d2218, options=..., tables=0x62b0000cb410, derived=true, flags=0, prelocking_strategy=0x1ce0235a5580) at /Server/10.6M/sql/sql_base.cc:5199
#8 0x0000563c4da07f58 in open_and_lock_tables (thd=0x62b0000d2218, tables=0x62b0000cb410, derived=true, flags=0) at /Server/10.6M/sql/sql_base.h:507
#9 0x0000563c4db7c460 in mysql_insert (thd=0x62b0000d2218, table_list=0x62b0000cb410, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /Server/10.6M/sql/sql_insert.cc:756
#10 0x0000563c4dc46982 in mysql_execute_command (thd=0x62b0000d2218) at /Server/10.6M/sql/sql_parse.cc:4519
#11 0x0000563c4dc5ede7 in mysql_parse (thd=0x62b0000d2218, rawbuf=0x62b0000cb238 "INSERT INTO t4 (col1, col_text ) VALUES ( 243, REPEAT(SUBSTR(CAST( 243 AS CHAR),1,1), 100) ) /* E_R Thread2 QNO 371 CON_ID 16 */", length=128, parser_state=0x1ce0235a67c0)
at /Server/10.6M/sql/sql_parse.cc:7972
#12 0x0000563c4dc35829 in dispatch_command (command=COM_QUERY, thd=0x62b0000d2218, packet=0x629000136219 "INSERT INTO t4 (col1, col_text ) VALUES ( 243, REPEAT(SUBSTR(CAST( 243 AS CHAR),1,1), 100) ) /* E_R Thread2 QNO 371 CON_ID 16 */ ", packet_length=129,
blocking=true) at /Server/10.6M/sql/sql_parse.cc:1886
#13 0x0000563c4dc32558 in do_command (thd=0x62b0000d2218, blocking=true) at /Server/10.6M/sql/sql_parse.cc:1397
#14 0x0000563c4e0744f0 in do_handle_one_connection (connect=0x6080000033b8, put_in_cache=true) at /Server/10.6M/sql/sql_connect.cc:1410
#15 0x0000563c4e073e54 in handle_one_connection (arg=0x6080000033b8) at /Server/10.6M/sql/sql_connect.cc:1312
#16 0x0000563c4ed7c05f in pfs_spawn_thread (arg=0x61500000af98) at /Server/10.6M/storage/perfschema/pfs.cc:2201
#17 0x0000000068209609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#18 0x000064e260808293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
(rr)
pluto:/data/Results/1614178707/TBR-D4/dev/shm/vardir/1614178707/89/1/rr
_RR_TRACE_DIR="." rr replay --mark-stdio
RQG
====
git clone https://github.com/mleich1/rqg --branch experimental RQG
perl rqg.pl \
--duration=300 \
--queries=10000000 \
--no_mask \
--seed=random \
--gendata_sql=conf/mariadb/table_stress.sql \
--gendata=conf/mariadb/table_stress.zz \
--rpl_mode=none \
--engine=InnoDB \
--mysqld=--net_write_timeout=60 \
--mysqld=--log-bin \
--mysqld=--connect_timeout=60 \
--mysqld=--loose-idle_transaction_timeout=0 \
--mysqld=--interactive_timeout=28800 \
--mysqld=--net_read_timeout=30 \
--mysqld=--plugin-load-add=file_key_management.so \
--mysqld=--log_bin_trust_function_creators=1 \
--mysqld=--log-output=none \
--mysqld=--file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
--mysqld=--loose-table_lock_wait_timeout=50 \
--mysqld=--innodb_page_size=8K \
--mysqld=--loose-idle_write_transaction_timeout=0 \
--mysqld=--innodb_stats_persistent=on \
--mysqld=--slave_net_timeout=60 \
--mysqld=--innodb-lock-wait-timeout=50 \
--mysqld=--innodb_adaptive_hash_index=on \
--mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \
--mysqld=--loose-idle_readonly_transaction_timeout=0 \
--mysqld=--loose-debug_assert_on_not_freed_memory=0 \
--mysqld=--loose-max-statement-time=30 \
--mysqld=--wait_timeout=28800 \
--mysqld=--lock-wait-timeout=86400 \
--mysqld=--innodb-buffer-pool-size=256M \
--reporters=Backtrace,Deadlock1,ErrorLog \
--validators=None \
--grammar=TBR-D4_min.yy \
--threads=2 \
--workdir=<local settings> \
--vardir=<local settings> \
--mtr-build-thread=<local settings> \
--basedir1=<local settings> \
--script_debug=_nix_ \
--rr=Extended \
--rr_options=--chaos
{"report":{"fcp":1217.2000002861023,"ttfb":409.7000002861023,"pageVisibility":"visible","entityId":97268,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"1aeb0784-3061-498e-a2d7-553c19748b41","navigationType":0,"readyForUser":1343.9000000953674,"redirectCount":0,"resourceLoadedEnd":1513.8000001907349,"resourceLoadedStart":421.6000003814697,"resourceTiming":[{"duration":150.2999997138977,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":421.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":421.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":571.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":150.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":421.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":421.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":572.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":160.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":422,"connectEnd":422,"connectStart":422,"domainLookupEnd":422,"domainLookupStart":422,"fetchStart":422,"redirectEnd":0,"redirectStart":0,"requestStart":422,"responseEnd":582.1000003814697,"responseStart":582.1000003814697,"secureConnectionStart":422},{"duration":220.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":422.2000002861023,"connectEnd":422.2000002861023,"connectStart":422.2000002861023,"domainLookupEnd":422.2000002861023,"domainLookupStart":422.2000002861023,"fetchStart":422.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":422.2000002861023,"responseEnd":642.5,"responseStart":642.5,"secureConnectionStart":422.2000002861023},{"duration":224.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":422.40000009536743,"connectEnd":422.40000009536743,"connectStart":422.40000009536743,"domainLookupEnd":422.40000009536743,"domainLookupStart":422.40000009536743,"fetchStart":422.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":422.40000009536743,"responseEnd":646.9000000953674,"responseStart":646.9000000953674,"secureConnectionStart":422.40000009536743},{"duration":224.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":423.90000009536743,"connectEnd":423.90000009536743,"connectStart":423.90000009536743,"domainLookupEnd":423.90000009536743,"domainLookupStart":423.90000009536743,"fetchStart":423.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":423.90000009536743,"responseEnd":648.4000000953674,"responseStart":648.3000001907349,"secureConnectionStart":423.90000009536743},{"duration":224.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":425.2000002861023,"connectEnd":425.2000002861023,"connectStart":425.2000002861023,"domainLookupEnd":425.2000002861023,"domainLookupStart":425.2000002861023,"fetchStart":425.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":425.2000002861023,"responseEnd":649.3000001907349,"responseStart":649.3000001907349,"secureConnectionStart":425.2000002861023},{"duration":337,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":425.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":425.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":762.5,"responseStart":0,"secureConnectionStart":0},{"duration":224.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":425.6000003814697,"connectEnd":425.6000003814697,"connectStart":425.6000003814697,"domainLookupEnd":425.6000003814697,"domainLookupStart":425.6000003814697,"fetchStart":425.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":425.6000003814697,"responseEnd":650.4000000953674,"responseStart":650.4000000953674,"secureConnectionStart":425.6000003814697},{"duration":337.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":425.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":425.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":763,"responseStart":0,"secureConnectionStart":0},{"duration":225.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":426,"connectEnd":426,"connectStart":426,"domainLookupEnd":426,"domainLookupStart":426,"fetchStart":426,"redirectEnd":0,"redirectStart":0,"requestStart":426,"responseEnd":651.2000002861023,"responseStart":651.2000002861023,"secureConnectionStart":426},{"duration":1079.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":433,"connectEnd":433,"connectStart":433,"domainLookupEnd":433,"domainLookupStart":433,"fetchStart":433,"redirectEnd":0,"redirectStart":0,"requestStart":433,"responseEnd":1512.5,"responseStart":1512.5,"secureConnectionStart":433},{"duration":1080.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":433.1000003814697,"connectEnd":433.1000003814697,"connectStart":433.1000003814697,"domainLookupEnd":433.1000003814697,"domainLookupStart":433.1000003814697,"fetchStart":433.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":433.1000003814697,"responseEnd":1513.8000001907349,"responseStart":1513.8000001907349,"secureConnectionStart":433.1000003814697},{"duration":244.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":875.2000002861023,"connectEnd":875.2000002861023,"connectStart":875.2000002861023,"domainLookupEnd":875.2000002861023,"domainLookupStart":875.2000002861023,"fetchStart":875.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":875.2000002861023,"responseEnd":1119.4000000953674,"responseStart":1119.4000000953674,"secureConnectionStart":875.2000002861023}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":241,"responseStart":410,"responseEnd":412,"domLoading":419,"domInteractive":1538,"domContentLoadedEventStart":1538,"domContentLoadedEventEnd":1588,"domComplete":2566,"loadEventStart":2566,"loadEventEnd":2567,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1518.7000002861023},{"name":"bigPipe.sidebar-id.end","time":1519.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1519.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":1523.1000003814697},{"name":"activityTabFullyLoaded","time":1618.6000003814697}],"measures":[],"correlationId":"a6786e4dadc557","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}