10.2.9-MariaDB-debug version, failing assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op()).
test case (from mysql 5.6.37 innodb/innodb-autoinc.test)
CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB
|
AUTO_INCREMENT=10000000000000000000;
|
INSERT INTO t1 VALUES ();
|
Version: '10.2.9-MariaDB-debug' socket: '/tmp/mysql.sock' port: 3322 Source distribution
|
mysqld: /home/alice/git/10.2/sql/sql_error.cc:380: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
|
171005 14:58:37 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.2.9-MariaDB-debug
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=7
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467371 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f9784000a98
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f97ecc3cec0 thread_stack 0x49000
|
/data/bld/10.2/bin/mysqld(my_print_stacktrace+0x38)[0x55d66ef35907]
|
/data/bld/10.2/bin/mysqld(handle_fatal_signal+0x3a3)[0x55d66e7c724a]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f97f0c18390]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f97effd1428]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f97effd302a]
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x7f97effc9bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f97effc9c82]
|
sql/sql_error.cc:385(Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*))[0x55d66e52cd9f]
|
/data/bld/10.2/bin/mysqld(_Z5my_okP3THDyyPKc+0x4e)[0x55d66e4dfca3]
|
/data/bld/10.2/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x17fb)[0x55d66e5352d8]
|
/data/bld/10.2/bin/mysqld(_Z21mysql_execute_commandP3THD+0x436a)[0x55d66e55bde9]
|
/data/bld/10.2/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2a2)[0x55d66e5672d7]
|
/data/bld/10.2/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xfee)[0x55d66e554c75]
|
sql/sql_class.h:4401(my_ok(THD*, unsigned long long, unsigned long long, char const*))[0x55d66e5535e8]
|
sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55d66e6a0768]
|
sql/sql_connect.cc:1261(handle_one_connection)[0x55d66e6a04e8]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f97f0c0e6ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f97f00a33dd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f9784017a00): INSERT INTO t1 VALUES ()
|
Connection ID (thread ID): 8
|
Status: NOT_KILLED
|
stack trace
Thread 1 (Thread 0x7f97ecc3d700 (LWP 32428)):
|
#0 0x00007f97effd1428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#1 0x00007f97effd302a in __GI_abort () at abort.c:89
|
#2 0x00007f97effc9bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55d66efc24e0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x55d66efc2410 "/home/alice/git/10.2/sql/sql_error.cc", line=line@entry=380, function=function@entry=0x55d66efc2840 <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
|
#3 0x00007f97effc9c82 in __GI___assert_fail (assertion=0x55d66efc24e0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x55d66efc2410 "/home/alice/git/10.2/sql/sql_error.cc", line=380, function=0x55d66efc2840 <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
|
#4 0x000055d66e52cd9f in Diagnostics_area::set_ok_status (this=0x7f9784005cb0, affected_rows=1, last_insert_id=10000000000000000000, message=0x0) at /home/alice/git/10.2/sql/sql_error.cc:380
|
#5 0x000055d66e4dfca3 in my_ok (thd=0x7f9784000a98, affected_rows=1, id=10000000000000000000, message=0x0) at /home/alice/git/10.2/sql/sql_class.h:4400
|
#6 0x000055d66e5352d8 in mysql_insert (thd=0x7f9784000a98, table_list=0x7f9784017f60, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /home/alice/git/10.2/sql/sql_insert.cc:1215
|
#7 0x000055d66e55bde9 in mysql_execute_command (thd=0x7f9784000a98) at /home/alice/git/10.2/sql/sql_parse.cc:4411
|
#8 0x000055d66e5672d7 in mysql_parse (thd=0x7f9784000a98, rawbuf=0x7f9784017a00 "INSERT INTO t1 VALUES ()", length=24, parser_state=0x7f97ecc3c240, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:7875
|
#9 0x000055d66e554c75 in dispatch_command (command=COM_QUERY, thd=0x7f9784000a98, packet=0x7f9784007e99 "INSERT INTO t1 VALUES ()", packet_length=24, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:1812
|
#10 0x000055d66e5535e8 in do_command (thd=0x7f9784000a98) at /home/alice/git/10.2/sql/sql_parse.cc:1360
|
#11 0x000055d66e6a0768 in do_handle_one_connection (connect=0x55d6722cedd8) at /home/alice/git/10.2/sql/sql_connect.cc:1354
|
#12 0x000055d66e6a04e8 in handle_one_connection (arg=0x55d6722cedd8) at /home/alice/git/10.2/sql/sql_connect.cc:1260
|
#13 0x00007f97f0c0e6ba in start_thread (arg=0x7f97ecc3d700) at pthread_create.c:333
|
#14 0x00007f97f00a33dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
results in MariaDB 10.0
MariaDB [test]> INSERT INTO t1 VALUES ();
|
Query OK, 1 row affected, 1 warning (0.07 sec)
|
MariaDB [test]> show warnings;
|
+---------+------+-------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-------------------------------------------+
|
| Warning | 1292 | Truncated incorrect INTEGER value: '1e19' |
|
+---------+------+-------------------------------------------+
|
1 row in set (0.00 sec)
|
in 10.2
ERROR 1467 (HY000): Failed to read auto-increment value from storage engine
|
{"report":{"fcp":1874.3999999761581,"ttfb":455.7999999523163,"pageVisibility":"visible","entityId":63497,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"6d313396-2e1c-428a-b054-daffcbc3d6dd","navigationType":0,"readyForUser":2017,"redirectCount":0,"resourceLoadedEnd":2644.100000023842,"resourceLoadedStart":461.60000002384186,"resourceTiming":[{"duration":646.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":461.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":461.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1108.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":646.8999999761581,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":461.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":461.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1108.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":678.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":462,"connectEnd":462,"connectStart":462,"domainLookupEnd":462,"domainLookupStart":462,"fetchStart":462,"redirectEnd":0,"redirectStart":0,"requestStart":462,"responseEnd":1140.7999999523163,"responseStart":1140.7999999523163,"secureConnectionStart":462},{"duration":911.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":462.2999999523163,"connectEnd":462.2999999523163,"connectStart":462.2999999523163,"domainLookupEnd":462.2999999523163,"domainLookupStart":462.2999999523163,"fetchStart":462.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":462.2999999523163,"responseEnd":1374,"responseStart":1374,"secureConnectionStart":462.2999999523163},{"duration":915.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":462.39999997615814,"connectEnd":462.39999997615814,"connectStart":462.39999997615814,"domainLookupEnd":462.39999997615814,"domainLookupStart":462.39999997615814,"fetchStart":462.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":462.39999997615814,"responseEnd":1377.7999999523163,"responseStart":1377.7999999523163,"secureConnectionStart":462.39999997615814},{"duration":934.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":462.60000002384186,"connectEnd":462.60000002384186,"connectStart":462.60000002384186,"domainLookupEnd":462.60000002384186,"domainLookupStart":462.60000002384186,"fetchStart":462.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":462.60000002384186,"responseEnd":1396.8999999761581,"responseStart":1396.7999999523163,"secureConnectionStart":462.60000002384186},{"duration":940,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":462.7000000476837,"connectEnd":462.7000000476837,"connectStart":462.7000000476837,"domainLookupEnd":462.7000000476837,"domainLookupStart":462.7000000476837,"fetchStart":462.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":462.7000000476837,"responseEnd":1402.7000000476837,"responseStart":1402.7000000476837,"secureConnectionStart":462.7000000476837},{"duration":943.3999999761581,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":463,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":463,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1406.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":943.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":463.2000000476837,"connectEnd":463.2000000476837,"connectStart":463.2000000476837,"domainLookupEnd":463.2000000476837,"domainLookupStart":463.2000000476837,"fetchStart":463.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":463.2000000476837,"responseEnd":1406.8999999761581,"responseStart":1406.8999999761581,"secureConnectionStart":463.2000000476837},{"duration":949.4000000953674,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":463.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":463.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1412.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":950,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":463.5,"connectEnd":463.5,"connectStart":463.5,"domainLookupEnd":463.5,"domainLookupStart":463.5,"fetchStart":463.5,"redirectEnd":0,"redirectStart":0,"requestStart":463.5,"responseEnd":1413.5,"responseStart":1413.5,"secureConnectionStart":463.5},{"duration":1100.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":476.89999997615814,"connectEnd":476.89999997615814,"connectStart":476.89999997615814,"domainLookupEnd":476.89999997615814,"domainLookupStart":476.89999997615814,"fetchStart":476.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":476.89999997615814,"responseEnd":1577.2999999523163,"responseStart":1577.2999999523163,"secureConnectionStart":476.89999997615814},{"duration":2164.600000023842,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":477.89999997615814,"connectEnd":477.89999997615814,"connectStart":477.89999997615814,"domainLookupEnd":477.89999997615814,"domainLookupStart":477.89999997615814,"fetchStart":477.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":477.89999997615814,"responseEnd":2642.5,"responseStart":2642.5,"secureConnectionStart":477.89999997615814},{"duration":202.69999992847443,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1312.1000000238419,"connectEnd":1312.1000000238419,"connectStart":1312.1000000238419,"domainLookupEnd":1312.1000000238419,"domainLookupStart":1312.1000000238419,"fetchStart":1312.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1312.1000000238419,"responseEnd":1514.7999999523163,"responseStart":1514.7999999523163,"secureConnectionStart":1312.1000000238419},{"duration":917.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/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":1726.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1726.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2644.100000023842,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":169,"domainLookupEnd":234,"connectStart":234,"connectEnd":258,"secureConnectionStart":242,"requestStart":259,"responseStart":456,"responseEnd":478,"domLoading":459,"domInteractive":2709,"domContentLoadedEventStart":2709,"domContentLoadedEventEnd":2759,"domComplete":4012,"loadEventStart":4012,"loadEventEnd":4012,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2645.2000000476837},{"name":"bigPipe.sidebar-id.end","time":2646},{"name":"bigPipe.activity-panel-pipe-id.start","time":2646.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":2647.7999999523163},{"name":"activityTabFullyLoaded","time":2775.899999976158}],"measures":[],"correlationId":"1c5b1037107d7a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":121,"dbReadsTimeInMs":18,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
10.0 and 10.1 are also affected, with STRICT_ALL_TABLES set: