SET @@max_statement_time=0.0001;
|
PREPARE p FROM 'CALL sys.statement_performance_analyzer(NULL,NULL,NULL);'; # Repeat till crash is seen (~5-10 tries)
|
Leads to:
11.5.0 e4afa610539ae01164485554e2de839bea9de816 (Debug)
|
mariadbd: /test/11.5_dbg/sql/sql_error.cc:335: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
|
11.5.0 e4afa610539ae01164485554e2de839bea9de816 (Debug)
|
Core was generated by `/test/MD170524-mariadb-11.5.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=<optimized out>)at ./nptl/pthread_kill.c:44
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
[Current thread is 1 (LWP 3010602)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x0000152a69042866 in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000152a690268b7 in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x0000152a690267db in __assert_fail_base (fmt=0x152a691c5168 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x561398b26cf0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x561398b26bd0 "/test/11.5_dbg/sql/sql_error.cc", line=line@entry=335, function=function@entry=0x561398b26d28 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at ./assert/assert.c:92
|
#6 0x0000152a69039186 in __assert_fail (assertion=0x561398b26cf0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x561398b26bd0 "/test/11.5_dbg/sql/sql_error.cc", line=335, function=0x561398b26d28 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at ./assert/assert.c:101
|
#7 0x0000561397e5b802 in Diagnostics_area::set_ok_status (this=0x152a1c006e90, affected_rows=affected_rows@entry=0, last_insert_id=last_insert_id@entry=0, message=message@entry=0x561398abd303 "Statement prepared")at /test/11.5_dbg/sql/sql_error.cc:335
|
#8 0x0000561397edb71a in my_ok (message=0x561398abd303 "Statement prepared", id=0, affected_rows_arg=0, thd=0x152a1c000d58)at /test/11.5_dbg/sql/sql_class.h:4665
|
#9 mysql_sql_stmt_prepare (thd=thd@entry=0x152a1c000d58)at /test/11.5_dbg/sql/sql_prepare.cc:2834
|
#10 0x0000561397ea877d in mysql_execute_command (thd=thd@entry=0x152a1c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.5_dbg/sql/sql_parse.cc:3953
|
#11 0x0000561397eaf0a5 in mysql_parse (thd=thd@entry=0x152a1c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x152a4c368230)at /test/11.5_dbg/sql/sql_parse.cc:7815
|
#12 0x0000561397eb1593 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x152a1c000d58, packet=packet@entry=0x152a1c00b1e9 "PREPARE p FROM 'CALL sys.statement_performance_analyzer(NULL,NULL,NULL);'", packet_length=packet_length@entry=73, blocking=blocking@entry=true) at /test/11.5_dbg/sql/sql_class.h:254
|
#13 0x0000561397eb3861 in do_command (thd=0x152a1c000d58, blocking=blocking@entry=true) at /test/11.5_dbg/sql/sql_parse.cc:1405
|
#14 0x00005613980281ce in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56139bcd2678, put_in_cache=put_in_cache@entry=true)at /test/11.5_dbg/sql/sql_connect.cc:1445
|
#15 0x00005613980284ce in handle_one_connection (arg=arg@entry=0x56139bcd2678)at /test/11.5_dbg/sql/sql_connect.cc:1347
|
#16 0x000056139846c980 in pfs_spawn_thread (arg=0x56139bc527e8)at /test/11.5_dbg/storage/perfschema/pfs.cc:2201
|
#17 0x0000152a69097ada in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:444
|
#18 0x0000152a6912847c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
- relates to
-
MDEV-25460
Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status in my_ok from mysql_sql_stmt_prepare
-
-
Closed
{"report":{"fcp":689.9000000953674,"ttfb":164.5,"pageVisibility":"visible","entityId":129603,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"1b53f164-6c51-4fb6-987e-9a884a98cc56","navigationType":0,"readyForUser":750,"redirectCount":0,"resourceLoadedEnd":257.2000000476837,"resourceLoadedStart":169.5,"resourceTiming":[{"duration":5.900000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":169.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":175.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":6.200000047683716,"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":169.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":176,"responseStart":0,"secureConnectionStart":0},{"duration":75.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":169.79999995231628,"connectEnd":169.79999995231628,"connectStart":169.79999995231628,"domainLookupEnd":169.79999995231628,"domainLookupStart":169.79999995231628,"fetchStart":169.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":179,"responseEnd":245.40000009536743,"responseStart":212.5,"secureConnectionStart":169.79999995231628},{"duration":87.29999995231628,"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":169.90000009536743,"connectEnd":169.90000009536743,"connectStart":169.90000009536743,"domainLookupEnd":169.90000009536743,"domainLookupStart":169.90000009536743,"fetchStart":169.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":179.5,"responseEnd":257.2000000476837,"responseStart":209.29999995231628,"secureConnectionStart":169.90000009536743},{"duration":50.80000019073486,"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":170.09999990463257,"connectEnd":170.09999990463257,"connectStart":170.09999990463257,"domainLookupEnd":170.09999990463257,"domainLookupStart":170.09999990463257,"fetchStart":170.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":180.40000009536743,"responseEnd":220.90000009536743,"responseStart":220.5,"secureConnectionStart":170.09999990463257},{"duration":38.299999952316284,"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":170.29999995231628,"connectEnd":170.29999995231628,"connectStart":170.29999995231628,"domainLookupEnd":170.29999995231628,"domainLookupStart":170.29999995231628,"fetchStart":170.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":181.5,"responseEnd":208.59999990463257,"responseStart":208.09999990463257,"secureConnectionStart":170.29999995231628},{"duration":38.799999952316284,"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":170.40000009536743,"connectEnd":170.40000009536743,"connectStart":170.40000009536743,"domainLookupEnd":170.40000009536743,"domainLookupStart":170.40000009536743,"fetchStart":170.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":184.70000004768372,"responseEnd":209.20000004768372,"responseStart":208.70000004768372,"secureConnectionStart":170.40000009536743},{"duration":11.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":170.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182,"responseStart":0,"secureConnectionStart":0},{"duration":49.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":170.59999990463257,"connectEnd":170.59999990463257,"connectStart":170.59999990463257,"domainLookupEnd":170.59999990463257,"domainLookupStart":170.59999990463257,"fetchStart":170.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":185.40000009536743,"responseEnd":220.40000009536743,"responseStart":219.90000009536743,"secureConnectionStart":170.59999990463257},{"duration":14.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":170.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":185.20000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":55.39999985694885,"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":170.90000009536743,"connectEnd":170.90000009536743,"connectStart":170.90000009536743,"domainLookupEnd":170.90000009536743,"domainLookupStart":170.90000009536743,"fetchStart":170.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":187.29999995231628,"responseEnd":226.29999995231628,"responseStart":225.70000004768372,"secureConnectionStart":170.90000009536743},{"duration":36,"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":183,"connectEnd":183,"connectStart":183,"domainLookupEnd":183,"domainLookupStart":183,"fetchStart":183,"redirectEnd":0,"redirectStart":0,"requestStart":196.09999990463257,"responseEnd":219,"responseStart":217.70000004768372,"secureConnectionStart":183},{"duration":33.700000047683716,"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":183.09999990463257,"connectEnd":194.5,"connectStart":194.5,"domainLookupEnd":194.5,"domainLookupStart":194.5,"fetchStart":183.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":194.90000009536743,"responseEnd":216.79999995231628,"responseStart":215.09999990463257,"secureConnectionStart":194.5},{"duration":151.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":455.40000009536743,"connectEnd":455.40000009536743,"connectStart":455.40000009536743,"domainLookupEnd":455.40000009536743,"domainLookupStart":455.40000009536743,"fetchStart":455.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":576.9000000953674,"responseEnd":606.5,"responseStart":605.7999999523163,"secureConnectionStart":455.40000009536743},{"duration":153.20000004768372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":665,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":665,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":818.2000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":38,"responseStart":164,"responseEnd":182,"domLoading":168,"domInteractive":805,"domContentLoadedEventStart":805,"domContentLoadedEventEnd":846,"domComplete":1513,"loadEventStart":1513,"loadEventEnd":1514,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":785.7000000476837},{"name":"bigPipe.sidebar-id.end","time":786.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":786.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":789.2999999523163},{"name":"activityTabFullyLoaded","time":853.5999999046326}],"measures":[],"correlationId":"81db1621279bb7","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}