Type:
Bug
Priority:
Major
Resolution:
Duplicate
Affects Version/s:
10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11
10.[89] optimized build goes to hung mode when executing the given test case.
SET @@enforce_storage_engine=MEMORY;
SET sql_mode= '' ;
CREATE TABLE t1 (c1 INT ) ENGINE=InnoDB;
CREATE TEMPORARY TABLE t4 (c1 INT ) ENGINE=InnoDB;
ALTER TABLE t1 ADD COLUMN c2 VARCHAR (20) NULL DEFAULT USER ();
INSERT DELAYED INTO t1 VALUES (1, "b" );
CREATE TRIGGER i5_t1 BEFORE INSERT ON t1 FOR EACH ROW CALL p4;
Leads to:
10.7.4 0a1d9d0681fda7595c0d08038357b56cf3bea9eb (Optimized)
Core was generated by `/test/MD160522-mariadb-10.7.4-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
[Current thread is 1 (Thread 0x1477fcfa2700 (LWP 3318000))]
(gdb) bt
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x0000147815708859 in __GI_abort () at abort.c:79
#2 0x00001478157733ee in __libc_message (action=action@entry=do_abort, fmt=fmt@entry=0x14781589d285 "%s\n") at ../sysdeps/posix/libc_fatal.c:155
#3 0x000014781577b47c in malloc_printerr (str=str@entry=0x14781589f690 "double free or corruption (!prev)") at malloc.c:5347
#4 0x000014781577d12c in _int_free (av=0x1478158ceb80 <main_arena>, p=0x1477c8002fc0, have_lock=<optimized out>) at malloc.c:4317
#5 0x000055ab50a99d75 in root_free (root=0x1477c8002550, size=<optimized out>, ptr=<optimized out>) at /test/10.7_opt/mysys/my_alloc.c:78
#6 free_root (root=root@entry=0x1477c8002550, MyFlags=MyFlags@entry=0) at /test/10.7_opt/mysys/my_alloc.c:501
#7 0x000055ab504997ee in closefrm (table=table@entry=0x1477c8002298) at /test/10.7_opt/sql/table.cc:4538
#8 0x000055ab505717c2 in intern_close_table (table=0x1477c8002298) at /test/10.7_opt/sql/table_cache.cc:220
#9 tc_remove_table (table=0x1477c8002298) at /test/10.7_opt/sql/table_cache.cc:258
#10 tc_release_table (table=0x1477c8002298) at /test/10.7_opt/sql/table_cache.cc:449
#11 0x000055ab5034b643 in close_thread_table (thd=thd@entry=0x1477c4000c58, table_ptr=table_ptr@entry=0x1477c4000d48) at /test/10.7_opt/sql/sql_base.cc:991
#12 0x000055ab5034c87b in close_all_tables_for_name (thd=thd@entry=0x1477c4000c58, share=<optimized out>, extra=extra@entry=HA_EXTRA_NOT_USED, skip_table=skip_table@entry=0x0) at /test/10.7_opt/sql/sql_base.cc:751
#13 0x000055ab50479e49 in mysql_create_or_drop_trigger (thd=thd@entry=0x1477c4000c58, tables=<optimized out>, create=create@entry=true) at /test/10.7_opt/sql/sql_trigger.cc:714
#14 0x000055ab503c1a9f in mysql_execute_command (thd=0x1477c4000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.7_opt/sql/sql_parse.cc:5832
#15 0x000055ab503b0015 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x1477c4000c58) at /test/10.7_opt/sql/sql_parse.cc:8043
#16 mysql_parse (thd=0x1477c4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.7_opt/sql/sql_parse.cc:7965
#17 0x000055ab503bbe82 in dispatch_command (command=COM_QUERY, thd=0x1477c4000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.7_opt/sql/sql_class.h:1360
#18 0x000055ab503bddd8 in do_command (thd=0x1477c4000c58, blocking=blocking@entry=true) at /test/10.7_opt/sql/sql_parse.cc:1407
#19 0x000055ab504d226f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55ab531ad2f8, put_in_cache=put_in_cache@entry=true) at /test/10.7_opt/sql/sql_connect.cc:1418
#20 0x000055ab504d255d in handle_one_connection (arg=0x55ab531ad2f8) at /test/10.7_opt/sql/sql_connect.cc:1312
#21 0x0000147815c17609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#22 0x0000147815805293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
10.9.2 6ec17142dcfb1e9d9f41211ed1b6d82e062d1541 (Debug)
Core was generated by `/test/MD280522-mariadb-10.9.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x000055ec43f79dfc in Virtual_column_info::cleanup_session_expr (
this=0x14945c0161d0) at /test/10.9_dbg/sql/table.cc:3658
[Current thread is 1 (Thread 0x14949c8c5700 (LWP 3275708))]
(gdb) bt
#0 0x000055ec43f79dfc in Virtual_column_info::cleanup_session_expr (this=0x14945c0161d0) at /test/10.9_dbg/sql/table.cc:3658
#1 0x000055ec43f7a199 in TABLE::vcol_cleanup_expr (this=this@entry=0x149460003f48, thd=thd@entry=0x14945c0332e8) at /test/10.9_dbg/sql/table.cc:3752
#2 0x000055ec43dd9772 in close_thread_table (thd=thd@entry=0x14945c0332e8, table_ptr=table_ptr@entry=0x14945c0333d8) at /test/10.9_dbg/sql/sql_base.cc:968
#3 0x000055ec43dd9c9e in close_thread_tables (thd=0x14945c0332e8) at /test/10.9_dbg/sql/sql_base.cc:942
#4 0x000055ec43e22f16 in handle_delayed_insert (arg=0x14945c0332c8) at /test/10.9_dbg/sql/sql_insert.cc:3413
#5 0x00001494b59d2609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#6 0x00001494b55c0293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Bug confirmed present in:
MariaDB: 10.2.44 (dbg), 10.3.36 (dbg), 10.4.26 (dbg), 10.5.17 (dbg), 10.6.9 (dbg), 10.7.4 (opt), 10.7.5 (dbg), 10.8.3 (opt), 10.8.4 (dbg), 10.9.2 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.44 (opt), 10.3.35 (opt), 10.4.25 (opt), 10.5.16 (opt), 10.6.8 (opt)
duplicates
MDEV-29932
Invalid expr in cleanup_session_expr() upon INSERT DELAYED
Closed
{"report":{"fcp":916,"ttfb":256.19999998807907,"pageVisibility":"visible","entityId":112218,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b2db7cb1-73e9-48de-a6a8-1ee5a60a2ecd","navigationType":0,"readyForUser":1003.3000000119209,"redirectCount":0,"resourceLoadedEnd":1027.4000000357628,"resourceLoadedStart":262.80000001192093,"resourceTiming":[{"duration":80.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":262.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":343.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":81.39999997615814,"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":263.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":263.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":344.5,"responseStart":0,"secureConnectionStart":0},{"duration":141,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":263.30000001192093,"connectEnd":263.30000001192093,"connectStart":263.30000001192093,"domainLookupEnd":263.30000001192093,"domainLookupStart":263.30000001192093,"fetchStart":263.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":263.30000001192093,"responseEnd":404.30000001192093,"responseStart":404.30000001192093,"secureConnectionStart":263.30000001192093},{"duration":209.30000001192093,"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":263.5,"connectEnd":263.5,"connectStart":263.5,"domainLookupEnd":263.5,"domainLookupStart":263.5,"fetchStart":263.5,"redirectEnd":0,"redirectStart":0,"requestStart":263.5,"responseEnd":472.80000001192093,"responseStart":472.80000001192093,"secureConnectionStart":263.5},{"duration":213,"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":263.69999998807907,"connectEnd":263.69999998807907,"connectStart":263.69999998807907,"domainLookupEnd":263.69999998807907,"domainLookupStart":263.69999998807907,"fetchStart":263.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":263.69999998807907,"responseEnd":476.69999998807907,"responseStart":476.69999998807907,"secureConnectionStart":263.69999998807907},{"duration":213.89999997615814,"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":263.9000000357628,"connectEnd":263.9000000357628,"connectStart":263.9000000357628,"domainLookupEnd":263.9000000357628,"domainLookupStart":263.9000000357628,"fetchStart":263.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":263.9000000357628,"responseEnd":477.80000001192093,"responseStart":477.80000001192093,"secureConnectionStart":263.9000000357628},{"duration":214.5999999642372,"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":264.10000002384186,"connectEnd":264.10000002384186,"connectStart":264.10000002384186,"domainLookupEnd":264.10000002384186,"domainLookupStart":264.10000002384186,"fetchStart":264.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":264.10000002384186,"responseEnd":478.69999998807907,"responseStart":478.69999998807907,"secureConnectionStart":264.10000002384186},{"duration":284.7000000476837,"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":264.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":264.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":548.9000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":215.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":264.30000001192093,"connectEnd":264.30000001192093,"connectStart":264.30000001192093,"domainLookupEnd":264.30000001192093,"domainLookupStart":264.30000001192093,"fetchStart":264.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":264.30000001192093,"responseEnd":479.60000002384186,"responseStart":479.60000002384186,"secureConnectionStart":264.30000001192093},{"duration":284.5,"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":264.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":264.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":549,"responseStart":0,"secureConnectionStart":0},{"duration":215.60000002384186,"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":264.69999998807907,"connectEnd":264.69999998807907,"connectStart":264.69999998807907,"domainLookupEnd":264.69999998807907,"domainLookupStart":264.69999998807907,"fetchStart":264.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":264.69999998807907,"responseEnd":480.30000001192093,"responseStart":480.30000001192093,"secureConnectionStart":264.69999998807907},{"duration":426.9000000357628,"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":265.5,"connectEnd":265.5,"connectStart":265.5,"domainLookupEnd":265.5,"domainLookupStart":265.5,"fetchStart":265.5,"redirectEnd":0,"redirectStart":0,"requestStart":265.5,"responseEnd":692.4000000357628,"responseStart":692.4000000357628,"secureConnectionStart":265.5},{"duration":593.0999999642372,"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":265.60000002384186,"connectEnd":265.60000002384186,"connectStart":265.60000002384186,"domainLookupEnd":265.60000002384186,"domainLookupStart":265.60000002384186,"fetchStart":265.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":265.60000002384186,"responseEnd":858.6999999880791,"responseStart":858.6999999880791,"secureConnectionStart":265.60000002384186},{"duration":132.89999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":560.6000000238419,"connectEnd":560.6000000238419,"connectStart":560.6000000238419,"domainLookupEnd":560.6000000238419,"domainLookupStart":560.6000000238419,"fetchStart":560.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":560.6000000238419,"responseEnd":693.5,"responseStart":693.5,"secureConnectionStart":560.6000000238419},{"duration":55.19999998807907,"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":817,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":817,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":872.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":205.30000001192093,"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":818.1000000238419,"connectEnd":818.1000000238419,"connectStart":818.1000000238419,"domainLookupEnd":818.1000000238419,"domainLookupStart":818.1000000238419,"fetchStart":818.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":818.1000000238419,"responseEnd":1023.4000000357628,"responseStart":1023.4000000357628,"secureConnectionStart":818.1000000238419},{"duration":209,"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":818.4000000357628,"connectEnd":818.4000000357628,"connectStart":818.4000000357628,"domainLookupEnd":818.4000000357628,"domainLookupStart":818.4000000357628,"fetchStart":818.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":818.4000000357628,"responseEnd":1027.4000000357628,"responseStart":1027.4000000357628,"secureConnectionStart":818.4000000357628},{"duration":220.69999998807907,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":909.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":909.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1130.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":184,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":929.9000000357628,"connectEnd":929.9000000357628,"connectStart":929.9000000357628,"domainLookupEnd":929.9000000357628,"domainLookupStart":929.9000000357628,"fetchStart":929.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":929.9000000357628,"responseEnd":1113.9000000357628,"responseStart":1113.9000000357628,"secureConnectionStart":929.9000000357628}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":73,"responseStart":257,"responseEnd":260,"domLoading":260,"domInteractive":1075,"domContentLoadedEventStart":1075,"domContentLoadedEventEnd":1123,"domComplete":1306,"loadEventStart":1306,"loadEventEnd":1307,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1045.199999988079},{"name":"bigPipe.sidebar-id.end","time":1046},{"name":"bigPipe.activity-panel-pipe-id.start","time":1046.199999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1047.300000011921},{"name":"activityTabFullyLoaded","time":1144.699999988079}],"measures":[],"correlationId":"dc4c6a53ecb8c9","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":26,"dbConnsTimeInMs":35,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}