Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.4(EOL) , 10.5 , 10.6 , 10.11 , 11.0(EOL) , 11.1(EOL) , 11.2(EOL) , 11.3(EOL) , 11.4
CREATE EVENT e ON SCHEDULE EVERY 1 HOUR ENDS ROW(1,2) DO SELECT 1;
Leads to:
11.4.0 9b1ea6904965dd345478dedd80e181ad54c767da (Debug)
mariadbd: /test/11.4_dbg/sql/item_row.cc:32: void Item_row::illegal_method_call(const char*): Assertion `0' failed.
11.4.0 9b1ea6904965dd345478dedd80e181ad54c767da (Debug)
Core was generated by `/test/MD060224-mariadb-11.4.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22640987928128)
at ./nptl/pthread_kill.c:44
[Current thread is 1 (LWP 4072767)]
(gdb) bt
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22640987928128) at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=22640987928128) at ./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=22640987928128, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
#3 0x000014978e642476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#4 0x000014978e6287f3 in __GI_abort () at ./stdlib/abort.c:79
#5 0x000014978e62871b in __assert_fail_base (fmt=0x14978e7dd130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55605d9ff44a "0", file=0x55605d9f3e40 "/test/11.4_dbg/sql/item_row.cc", line=32, function=<optimized out>) at ./assert/assert.c:92
#6 0x000014978e639e96 in __GI___assert_fail (assertion=0x55605d9ff44a "0", file=0x55605d9f3e40 "/test/11.4_dbg/sql/item_row.cc", line=32, function=0x55605d9f3ed8 "void Item_row::illegal_method_call(const char*)") at ./assert/assert.c:101
#7 0x000055605d00dabf in Item_row::illegal_method_call (this=<optimized out>, method=method@entry=0x55605d9f3f08 "get_date") at /test/11.4_dbg/sql/item_row.cc:32
#8 0x000055605d00e1b0 in Item_row::get_date (this=<optimized out>, thd=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/11.4_dbg/sql/item_row.h:92
#9 0x000055605cdaba6c in Event_parse_data::init_ends (this=this@entry=0x149744019098, thd=thd@entry=0x149744000d58) at /test/11.4_dbg/sql/event_parse_data.cc:443
#10 0x000055605cdac27f in Event_parse_data::check_parse_data (this=this@entry=0x149744019098, thd=thd@entry=0x149744000d58) at /test/11.4_dbg/sql/event_parse_data.cc:514
#11 0x000055605cd82013 in Events::create_event (thd=thd@entry=0x149744000d58, parse_data=0x149744019098) at /test/11.4_dbg/sql/events.cc:339
#12 0x000055605cc37b06 in mysql_execute_command (thd=thd@entry=0x149744000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.4_dbg/sql/sql_parse.cc:5049
#13 0x000055605cc3ae39 in mysql_parse (thd=thd@entry=0x149744000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1497840ae1e0) at /test/11.4_dbg/sql/sql_parse.cc:7798
#14 0x000055605cc3d1fc in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x149744000d58, packet=packet@entry=0x14974400b1c9 "CREATE EVENT e ON SCHEDULE EVERY 1 HOUR ENDS ROW(1,2) DO SELECT 1", packet_length=packet_length@entry=65, blocking=blocking@entry=true) at /test/11.4_dbg/sql/sql_class.h:254
#15 0x000055605cc3f333 in do_command (thd=0x149744000d58, blocking=blocking@entry=true) at /test/11.4_dbg/sql/sql_parse.cc:1406
#16 0x000055605cda59fd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55606038c528, put_in_cache=put_in_cache@entry=true) at /test/11.4_dbg/sql/sql_connect.cc:1417
#17 0x000055605cda5cf2 in handle_one_connection (arg=arg@entry=0x55606038c528) at /test/11.4_dbg/sql/sql_connect.cc:1319
#18 0x000055605d1f2e9a in pfs_spawn_thread (arg=0x5560602fd648) at /test/11.4_dbg/storage/perfschema/pfs.cc:2201
#19 0x000014978e694ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#20 0x000014978e726850 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
Bug confirmed present in:
MariaDB: 10.4.33 (dbg), 10.5.24 (dbg), 10.6.17 (dbg), 10.11.7 (dbg), 11.0.5 (dbg), 11.1.4 (dbg), 11.2.3 (dbg), 11.3.2 (dbg), 11.4.0 (dbg)
MySQL: 5.5.62 (dbg), 5.6.51 (dbg), 5.7.44 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.33 (opt), 10.5.24 (opt), 10.6.17 (opt), 10.11.7 (opt), 11.0.5 (opt), 11.1.4 (opt), 11.2.3 (opt), 11.3.2 (opt), 11.4.0 (opt)
MySQL: 5.5.62 (opt), 5.6.51 (opt), 5.7.44 (opt), 8.0.36 (dbg), 8.0.36 (opt)
Btw, MySQL 5.5 fails with
0|SIGABRT|Item_row::illegal_method_call|Item_row::val_int|Item::get_date|Event_parse_data::init_ends
Whereas 5.6 and 5.7 have the same stack as above.
{"report":{"fcp":777.6999998092651,"ttfb":135.59999990463257,"pageVisibility":"visible","entityId":127945,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"493550f9-2d7f-41d8-aba9-3d660a166322","navigationType":0,"readyForUser":841.6999998092651,"redirectCount":0,"resourceLoadedEnd":1031.0999999046326,"resourceLoadedStart":140.89999985694885,"resourceTiming":[{"duration":175.20000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":140.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":140.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":175,"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":141.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":141.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":224.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":141.29999995231628,"connectEnd":141.29999995231628,"connectStart":141.29999995231628,"domainLookupEnd":141.29999995231628,"domainLookupStart":141.29999995231628,"fetchStart":141.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":141.29999995231628,"responseEnd":366.09999990463257,"responseStart":366.09999990463257,"secureConnectionStart":141.29999995231628},{"duration":270.10000014305115,"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":141.39999985694885,"connectEnd":141.39999985694885,"connectStart":141.39999985694885,"domainLookupEnd":141.39999985694885,"domainLookupStart":141.39999985694885,"fetchStart":141.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":141.39999985694885,"responseEnd":411.5,"responseStart":411.5,"secureConnectionStart":141.39999985694885},{"duration":273.69999980926514,"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":141.5,"connectEnd":141.5,"connectStart":141.5,"domainLookupEnd":141.5,"domainLookupStart":141.5,"fetchStart":141.5,"redirectEnd":0,"redirectStart":0,"requestStart":141.5,"responseEnd":415.19999980926514,"responseStart":415.19999980926514,"secureConnectionStart":141.5},{"duration":274.09999990463257,"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":141.59999990463257,"connectEnd":141.59999990463257,"connectStart":141.59999990463257,"domainLookupEnd":141.59999990463257,"domainLookupStart":141.59999990463257,"fetchStart":141.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":141.59999990463257,"responseEnd":415.69999980926514,"responseStart":415.69999980926514,"secureConnectionStart":141.59999990463257},{"duration":274.5,"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":141.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":141.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":416.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":274.2000000476837,"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":141.79999995231628,"connectEnd":141.79999995231628,"connectStart":141.79999995231628,"domainLookupEnd":141.79999995231628,"domainLookupStart":141.79999995231628,"fetchStart":141.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":141.79999995231628,"responseEnd":416,"responseStart":416,"secureConnectionStart":141.79999995231628},{"duration":274.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":141.89999985694885,"connectEnd":141.89999985694885,"connectStart":141.89999985694885,"domainLookupEnd":141.89999985694885,"domainLookupStart":141.89999985694885,"fetchStart":141.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":141.89999985694885,"responseEnd":416.39999985694885,"responseStart":416.39999985694885,"secureConnectionStart":141.89999985694885},{"duration":274.7999999523163,"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":142.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":142.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":416.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":274.80000019073486,"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":142.19999980926514,"connectEnd":142.19999980926514,"connectStart":142.19999980926514,"domainLookupEnd":142.19999980926514,"domainLookupStart":142.19999980926514,"fetchStart":142.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":142.19999980926514,"responseEnd":417,"responseStart":417,"secureConnectionStart":142.19999980926514},{"duration":734.7000000476837,"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":148.59999990463257,"connectEnd":148.59999990463257,"connectStart":148.59999990463257,"domainLookupEnd":148.59999990463257,"domainLookupStart":148.59999990463257,"fetchStart":148.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":148.59999990463257,"responseEnd":883.2999999523163,"responseStart":883.1999998092651,"secureConnectionStart":148.59999990463257},{"duration":880.9000000953674,"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":150.19999980926514,"connectEnd":150.19999980926514,"connectStart":150.19999980926514,"domainLookupEnd":150.19999980926514,"domainLookupStart":150.19999980926514,"fetchStart":150.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":150.19999980926514,"responseEnd":1031.0999999046326,"responseStart":1031.0999999046326,"secureConnectionStart":150.19999980926514},{"duration":449.60000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":581.1999998092651,"connectEnd":581.1999998092651,"connectStart":581.1999998092651,"domainLookupEnd":581.1999998092651,"domainLookupStart":581.1999998092651,"fetchStart":581.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":581.1999998092651,"responseEnd":1030.7999999523163,"responseStart":1030.7999999523163,"secureConnectionStart":581.1999998092651},{"duration":275.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":756.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":756.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1031.6999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":14,"responseStart":136,"responseEnd":150,"domLoading":139,"domInteractive":1069,"domContentLoadedEventStart":1069,"domContentLoadedEventEnd":1105,"domComplete":1618,"loadEventStart":1618,"loadEventEnd":1619,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1037.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1038.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1038.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1041},{"name":"activityTabFullyLoaded","time":1110.7999999523163}],"measures":[],"correlationId":"8a709e530e3ff5","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":65,"dbReadsTimeInMs":9,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}