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":889.1000000238419,"ttfb":236.9000000357628,"pageVisibility":"visible","entityId":97268,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"46d07b7a-7b96-4414-8544-23030750f173","navigationType":0,"readyForUser":982.5,"redirectCount":0,"resourceLoadedEnd":1018.8000000119209,"resourceLoadedStart":242.80000001192093,"resourceTiming":[{"duration":144.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":242.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":387.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":144.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":243.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":243.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":387.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":153.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":243.20000004768372,"connectEnd":243.20000004768372,"connectStart":243.20000004768372,"domainLookupEnd":243.20000004768372,"domainLookupStart":243.20000004768372,"fetchStart":243.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":243.20000004768372,"responseEnd":396.5,"responseStart":396.5,"secureConnectionStart":243.20000004768372},{"duration":213.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":243.4000000357628,"connectEnd":243.4000000357628,"connectStart":243.4000000357628,"domainLookupEnd":243.4000000357628,"domainLookupStart":243.4000000357628,"fetchStart":243.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":243.4000000357628,"responseEnd":456.9000000357628,"responseStart":456.9000000357628,"secureConnectionStart":243.4000000357628},{"duration":220.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":243.5,"connectEnd":243.5,"connectStart":243.5,"domainLookupEnd":243.5,"domainLookupStart":243.5,"fetchStart":243.5,"redirectEnd":0,"redirectStart":0,"requestStart":243.5,"responseEnd":463.7000000476837,"responseStart":463.7000000476837,"secureConnectionStart":243.5},{"duration":221.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":243.70000004768372,"connectEnd":243.70000004768372,"connectStart":243.70000004768372,"domainLookupEnd":243.70000004768372,"domainLookupStart":243.70000004768372,"fetchStart":243.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":243.70000004768372,"responseEnd":465,"responseStart":464.9000000357628,"secureConnectionStart":243.70000004768372},{"duration":223.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":244,"connectEnd":244,"connectStart":244,"domainLookupEnd":244,"domainLookupStart":244,"fetchStart":244,"redirectEnd":0,"redirectStart":0,"requestStart":244,"responseEnd":467.30000001192093,"responseStart":467.30000001192093,"secureConnectionStart":244},{"duration":290.80000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":244.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":534.9000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":225.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":244.30000001192093,"connectEnd":244.30000001192093,"connectStart":244.30000001192093,"domainLookupEnd":244.30000001192093,"domainLookupStart":244.30000001192093,"fetchStart":244.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":244.30000001192093,"responseEnd":469.80000001192093,"responseStart":469.80000001192093,"secureConnectionStart":244.30000001192093},{"duration":290.5999999642372,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":244.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":535,"responseStart":0,"secureConnectionStart":0},{"duration":227.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":244.60000002384186,"connectEnd":244.60000002384186,"connectStart":244.60000002384186,"domainLookupEnd":244.60000002384186,"domainLookupStart":244.60000002384186,"fetchStart":244.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":244.60000002384186,"responseEnd":472.10000002384186,"responseStart":472.10000002384186,"secureConnectionStart":244.60000002384186},{"duration":678.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":250,"connectEnd":250,"connectStart":250,"domainLookupEnd":250,"domainLookupStart":250,"fetchStart":250,"redirectEnd":0,"redirectStart":0,"requestStart":250,"responseEnd":928.5,"responseStart":928.5,"secureConnectionStart":250},{"duration":678.6999999880791,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":250.10000002384186,"connectEnd":250.10000002384186,"connectStart":250.10000002384186,"domainLookupEnd":250.10000002384186,"domainLookupStart":250.10000002384186,"fetchStart":250.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":250.10000002384186,"responseEnd":928.8000000119209,"responseStart":928.8000000119209,"secureConnectionStart":250.10000002384186},{"duration":98.90000003576279,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":545.8000000119209,"connectEnd":545.8000000119209,"connectStart":545.8000000119209,"domainLookupEnd":545.8000000119209,"domainLookupStart":545.8000000119209,"fetchStart":545.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":545.8000000119209,"responseEnd":644.7000000476837,"responseStart":644.7000000476837,"secureConnectionStart":545.8000000119209},{"duration":207.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":811.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":811.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1018.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":264.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":812.3000000119209,"connectEnd":812.3000000119209,"connectStart":812.3000000119209,"domainLookupEnd":812.3000000119209,"domainLookupStart":812.3000000119209,"fetchStart":812.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":812.3000000119209,"responseEnd":1076.5,"responseStart":1076.4000000357628,"secureConnectionStart":812.3000000119209},{"duration":267.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":812.6000000238419,"connectEnd":812.6000000238419,"connectStart":812.6000000238419,"domainLookupEnd":812.6000000238419,"domainLookupStart":812.6000000238419,"fetchStart":812.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":812.6000000238419,"responseEnd":1080.1000000238419,"responseStart":1080.1000000238419,"secureConnectionStart":812.6000000238419}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":13,"responseStart":237,"responseEnd":242,"domLoading":240,"domInteractive":1060,"domContentLoadedEventStart":1060,"domContentLoadedEventEnd":1104,"domComplete":1417,"loadEventStart":1417,"loadEventEnd":1417,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1034.4000000357628},{"name":"bigPipe.sidebar-id.end","time":1036},{"name":"bigPipe.activity-panel-pipe-id.start","time":1036.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1037.7000000476837},{"name":"activityTabFullyLoaded","time":1122.2000000476837}],"measures":[],"correlationId":"b797c8855a0d69","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":137,"dbReadsTimeInMs":35,"dbConnsTimeInMs":46,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}