SET @cmd:="SET @@SESSION.SQL_MODE=(SELECT 'a')";
|
SET @@SESSION.OPTIMIZER_SWITCH="materialization=OFF";
|
SET @@SESSION.OPTIMIZER_SWITCH="in_to_exists=OFF";
|
PREPARE stmt FROM @cmd;
|
Leads to:
mysqld: /data/git/10.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.
|
Core was generated by `/data/MD180320-mariadb-10.5.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
57 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
|
[Current thread is 1 (Thread 0x7f2b2c7c8700 (LWP 24499))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x0000560dec9ba7d4 in my_write_core (sig=sig@entry=6)
|
at /data/git/10.5_dbg/mysys/stacktrace.c:518
|
#2 0x0000560dec163b5f in handle_fatal_signal (sig=6) at /data/git/10.5_dbg/sql/signal_handler.cc:325
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x00007f2b2af0c801 in __GI_abort () at abort.c:79
|
#6 0x00007f2b2aefc39a in __assert_fail_base (
|
fmt=0x7f2b2b0837d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
|
assertion=assertion@entry=0x560decb292e0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x560decb29280 "/data/git/10.5_dbg/sql/sql_error.cc", line=line@entry=335,
|
function=function@entry=0x560decb29e00 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
|
#7 0x00007f2b2aefc412 in __GI___assert_fail (
|
assertion=assertion@entry=0x560decb292e0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x560decb29280 "/data/git/10.5_dbg/sql/sql_error.cc", line=line@entry=335,
|
function=function@entry=0x560decb29e00 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
|
#8 0x0000560debe723c3 in Diagnostics_area::set_ok_status (this=0x7f2affc1ab70,
|
affected_rows=affected_rows@entry=0, last_insert_id=last_insert_id@entry=0,
|
message=message@entry=0x560decb39602 "Statement prepared")
|
at /data/git/10.5_dbg/sql/sql_error.cc:335
|
#9 0x0000560debee19dc in my_ok (message=0x560decb39602 "Statement prepared", id=0,
|
affected_rows_arg=0, thd=0x7f2affc15088) at /data/git/10.5_dbg/sql/sql_class.h:5155
|
#10 mysql_sql_stmt_prepare (thd=thd@entry=0x7f2affc15088)
|
at /data/git/10.5_dbg/sql/sql_prepare.cc:2887
|
#11 0x0000560debebc36b in mysql_execute_command (thd=thd@entry=0x7f2affc15088)
|
at /data/git/10.5_dbg/sql/sql_parse.cc:3910
|
#12 0x0000560debec97a5 in mysql_parse (thd=thd@entry=0x7f2affc15088, rawbuf=<optimized out>,
|
length=<optimized out>, parser_state=parser_state@entry=0x7f2b2c7c7450,
|
is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)
|
at /data/git/10.5_dbg/sql/sql_parse.cc:7926
|
#13 0x0000560debeb5664 in dispatch_command (command=command@entry=COM_QUERY,
|
thd=thd@entry=0x7f2affc15088, packet=packet@entry=0x7f2affc67089 "PREPARE stmt FROM @cmd",
|
packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false,
|
is_next_command=is_next_command@entry=false) at /data/git/10.5_dbg/sql/sql_parse.cc:1839
|
#14 0x0000560debeb3eaf in do_command (thd=0x7f2affc15088) at /data/git/10.5_dbg/sql/sql_parse.cc:1358
|
#15 0x0000560dec00da09 in do_handle_one_connection (connect=<optimized out>,
|
connect@entry=0x7f2b08e2b3a8, put_in_cache=put_in_cache@entry=true)
|
at /data/git/10.5_dbg/sql/sql_connect.cc:1422
|
#16 0x0000560dec00dd38 in handle_one_connection (arg=arg@entry=0x7f2b08e2b3a8)
|
at /data/git/10.5_dbg/sql/sql_connect.cc:1319
|
#17 0x0000560dec46acfc in pfs_spawn_thread (arg=0x7f2b2a445888)
|
at /data/git/10.5_dbg/storage/perfschema/pfs.cc:2201
|
#18 0x00007f2b2bbef6db in start_thread (arg=0x7f2b2c7c8700) at pthread_create.c:463
|
#19 0x00007f2b2afed88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.2.32 (dbg), 10.3.23 (dbg), 10.4.13 (dbg), 10.5.2 (dbg)
Bug confirmed not present in:
MariaDB: 10.1.45 (dbg), 10.1.45 (opt), 10.2.32 (opt), 10.3.23 (opt), 10.4.13 (opt), 10.5.2 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)
- 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":1114.1000000014901,"ttfb":161.5,"pageVisibility":"visible","entityId":84676,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"9d3170ac-4f19-488e-aeba-b8cea5481ba3","navigationType":0,"readyForUser":1187.800000000745,"redirectCount":0,"resourceLoadedEnd":744.4000000022352,"resourceLoadedStart":166.80000000074506,"resourceTiming":[{"duration":330.19999999925494,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":166.80000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":497,"responseStart":0,"secureConnectionStart":0},{"duration":329.8999999985099,"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":167.10000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":497,"responseStart":0,"secureConnectionStart":0},{"duration":338.9000000022352,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":167.19999999925494,"connectEnd":167.19999999925494,"connectStart":167.19999999925494,"domainLookupEnd":167.19999999925494,"domainLookupStart":167.19999999925494,"fetchStart":167.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":167.19999999925494,"responseEnd":506.1000000014901,"responseStart":506.1000000014901,"secureConnectionStart":167.19999999925494},{"duration":384.69999999925494,"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":167.30000000074506,"connectEnd":167.30000000074506,"connectStart":167.30000000074506,"domainLookupEnd":167.30000000074506,"domainLookupStart":167.30000000074506,"fetchStart":167.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":167.30000000074506,"responseEnd":552,"responseStart":552,"secureConnectionStart":167.30000000074506},{"duration":388.0999999977648,"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":167.40000000223517,"connectEnd":167.40000000223517,"connectStart":167.40000000223517,"domainLookupEnd":167.40000000223517,"domainLookupStart":167.40000000223517,"fetchStart":167.40000000223517,"redirectEnd":0,"redirectStart":0,"requestStart":167.40000000223517,"responseEnd":555.5,"responseStart":555.5,"secureConnectionStart":167.40000000223517},{"duration":388.6000000014901,"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":167.5,"connectEnd":167.5,"connectStart":167.5,"domainLookupEnd":167.5,"domainLookupStart":167.5,"fetchStart":167.5,"redirectEnd":0,"redirectStart":0,"requestStart":167.5,"responseEnd":556.1000000014901,"responseStart":556.1000000014901,"secureConnectionStart":167.5},{"duration":390.8999999985099,"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":167.60000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":558.5,"responseStart":0,"secureConnectionStart":0},{"duration":389.5999999977648,"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":167.60000000149012,"connectEnd":167.60000000149012,"connectStart":167.60000000149012,"domainLookupEnd":167.60000000149012,"domainLookupStart":167.60000000149012,"fetchStart":167.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":167.60000000149012,"responseEnd":557.1999999992549,"responseStart":557.1999999992549,"secureConnectionStart":167.60000000149012},{"duration":391.6000000014901,"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":167.69999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":559.3000000007451,"responseStart":0,"secureConnectionStart":0},{"duration":390.80000000074506,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":167.69999999925494,"connectEnd":167.69999999925494,"connectStart":167.69999999925494,"domainLookupEnd":167.69999999925494,"domainLookupStart":167.69999999925494,"fetchStart":167.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":167.69999999925494,"responseEnd":558.5,"responseStart":558.5,"secureConnectionStart":167.69999999925494},{"duration":391.3999999985099,"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":167.90000000223517,"connectEnd":167.90000000223517,"connectStart":167.90000000223517,"domainLookupEnd":167.90000000223517,"domainLookupStart":167.90000000223517,"fetchStart":167.90000000223517,"redirectEnd":0,"redirectStart":0,"requestStart":167.90000000223517,"responseEnd":559.3000000007451,"responseStart":559.3000000007451,"secureConnectionStart":167.90000000223517},{"duration":530.8000000007451,"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":173.10000000149012,"connectEnd":173.10000000149012,"connectStart":173.10000000149012,"domainLookupEnd":173.10000000149012,"domainLookupStart":173.10000000149012,"fetchStart":173.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":173.10000000149012,"responseEnd":703.9000000022352,"responseStart":703.9000000022352,"secureConnectionStart":173.10000000149012},{"duration":571.3000000007451,"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":173.10000000149012,"connectEnd":173.10000000149012,"connectStart":173.10000000149012,"domainLookupEnd":173.10000000149012,"domainLookupStart":173.10000000149012,"fetchStart":173.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":173.10000000149012,"responseEnd":744.4000000022352,"responseStart":744.4000000022352,"secureConnectionStart":173.10000000149012}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":30,"responseStart":162,"responseEnd":167,"domLoading":165,"domInteractive":1256,"domContentLoadedEventStart":1256,"domContentLoadedEventEnd":1298,"domComplete":2999,"loadEventStart":2999,"loadEventEnd":3001,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1229.1000000014901},{"name":"bigPipe.sidebar-id.end","time":1229.800000000745},{"name":"bigPipe.activity-panel-pipe-id.start","time":1230},{"name":"bigPipe.activity-panel-pipe-id.end","time":1232.5},{"name":"activityTabFullyLoaded","time":1309.300000000745}],"measures":[],"correlationId":"440b0db1b91ce","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}