Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
10.6 , 10.11 , 11.2(EOL) , 11.4 , 11.6(EOL)
I'm setting it to critical because innodb_snapshot_isolation=ON has been made default in 11.6 which is going GA soon; so, as far as default settings are concerned, it can be considered a regression while technically it is not.
--source include/have_innodb.inc
CREATE TABLE t1 (a INT ) ENGINE=InnoDB;
CREATE TABLE t2 (b INT ) ENGINE=InnoDB;
START TRANSACTION ;
INSERT INTO t1 VALUES (0);
--connect (con1,localhost,root,,)
SET innodb_snapshot_isolation= ON ;
START TRANSACTION ;
SELECT * FROM t2;
SAVEPOINT sp1;
--error ER_CHECKREAD
UPDATE t1 SET a = 1;
SAVEPOINT sp1;
# Cleanup
ROLLBACK ;
--disconnect con1
--connection default
DROP TABLE t1, t2;
10.6 1ed30e08af4780a2b1f6d2b52f91fea89f892ef3
mariadbd: /data/bld/10.6-asan/sql/sql_error.h:1066: uint Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed.
241022 23:31:51 [ERROR] mysqld got signal 6 ;
#9 0x00007fb320253e32 in __GI___assert_fail (assertion=0x55698d59c020 "m_status == DA_ERROR", file=0x55698d59bf60 "/data/bld/10.6-asan/sql/sql_error.h", line=1066, function=0x55698d59c060 "uint Diagnostics_area::sql_errno() const") at ./assert/assert.c:101
#10 0x000055698b1dc274 in Diagnostics_area::sql_errno (this=0x62b0000f41f8) at /data/bld/10.6-asan/sql/sql_error.h:1066
#11 0x000055698b373422 in thd_get_error_number (thd=0x62b0000ee218) at /data/bld/10.6-asan/sql/sql_class.cc:537
#12 0x000055698cd9723f in trx_state_eq (trx=0x7fb31831ff40, state=TRX_STATE_ACTIVE, relaxed=true) at /data/bld/10.6-asan/storage/innobase/include/trx0trx.inl:65
#13 0x000055698cd996de in trx_release_savepoint_for_mysql (trx=0x7fb31831ff40, savepoint_name=0x7fb31005ba00 "127W7W53LC") at /data/bld/10.6-asan/storage/innobase/trx/trx0roll.cc:553
#14 0x000055698c7c0a93 in innobase_release_savepoint (hton=0x615000002398, thd=0x62b0000ee218, savepoint=0x6210000dfd70) at /data/bld/10.6-asan/storage/innobase/handler/ha_innodb.cc:4961
#15 0x000055698bd59c26 in ha_release_savepoint (thd=0x62b0000ee218, sv=0x6210000dfd38) at /data/bld/10.6-asan/sql/handler.cc:3074
#16 0x000055698b973bd7 in trans_savepoint (thd=0x62b0000ee218, name=...) at /data/bld/10.6-asan/sql/transaction.cc:632
#17 0x000055698b4c85bb in mysql_execute_command (thd=0x62b0000ee218, is_called_from_prepared_stmt=false) at /data/bld/10.6-asan/sql/sql_parse.cc:5843
#18 0x000055698b4d79d6 in mysql_parse (thd=0x62b0000ee218, rawbuf=0x62b0000f5238 "SAVEPOINT sp1", length=13, parser_state=0x7fb31005ca30) at /data/bld/10.6-asan/sql/sql_parse.cc:8181
#19 0x000055698b4acee5 in dispatch_command (command=COM_QUERY, thd=0x62b0000ee218, packet=0x6290002cb219 "SAVEPOINT sp1", packet_length=13, blocking=true) at /data/bld/10.6-asan/sql/sql_parse.cc:1897
#20 0x000055698b4a9c19 in do_command (thd=0x62b0000ee218, blocking=true) at /data/bld/10.6-asan/sql/sql_parse.cc:1410
#21 0x000055698b929f4c in do_handle_one_connection (connect=0x6080000147b8, put_in_cache=true) at /data/bld/10.6-asan/sql/sql_connect.cc:1417
#22 0x000055698b929908 in handle_one_connection (arg=0x6080000147b8) at /data/bld/10.6-asan/sql/sql_connect.cc:1319
#23 0x000055698c5a152a in pfs_spawn_thread (arg=0x617000008598) at /data/bld/10.6-asan/storage/perfschema/pfs.cc:2201
#24 0x00007fb3202a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#25 0x00007fb32032861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
On a non-debug build, SAVEPOINT does not produce any error, and the error upon the preceding UPDATE is the same, ER_CHECKREAD .
{"report":{"fcp":1080.5,"ttfb":230.19999998807907,"pageVisibility":"visible","entityId":131315,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"bcc3c6a0-a5c7-4c42-846a-bd66cff95e70","navigationType":0,"readyForUser":1164,"redirectCount":0,"resourceLoadedEnd":833.3999999761581,"resourceLoadedStart":236.19999998807907,"resourceTiming":[{"duration":371.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":236.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":607.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":371.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":236.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":608.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":380.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":236.5999999642372,"connectEnd":236.5999999642372,"connectStart":236.5999999642372,"domainLookupEnd":236.5999999642372,"domainLookupStart":236.5999999642372,"fetchStart":236.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":236.5999999642372,"responseEnd":617.1999999880791,"responseStart":617.1999999880791,"secureConnectionStart":236.5999999642372},{"duration":405.5999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":236.80000001192093,"connectEnd":236.80000001192093,"connectStart":236.80000001192093,"domainLookupEnd":236.80000001192093,"domainLookupStart":236.80000001192093,"fetchStart":236.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":236.80000001192093,"responseEnd":642.3999999761581,"responseStart":642.3999999761581,"secureConnectionStart":236.80000001192093},{"duration":409.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":237.0999999642372,"connectEnd":237.0999999642372,"connectStart":237.0999999642372,"domainLookupEnd":237.0999999642372,"domainLookupStart":237.0999999642372,"fetchStart":237.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":237.0999999642372,"responseEnd":646.3000000119209,"responseStart":646.1999999880791,"secureConnectionStart":237.0999999642372},{"duration":409.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":237.30000001192093,"connectEnd":237.30000001192093,"connectStart":237.30000001192093,"domainLookupEnd":237.30000001192093,"domainLookupStart":237.30000001192093,"fetchStart":237.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":237.30000001192093,"responseEnd":646.6999999880791,"responseStart":646.6999999880791,"secureConnectionStart":237.30000001192093},{"duration":409.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":237.5,"connectEnd":237.5,"connectStart":237.5,"domainLookupEnd":237.5,"domainLookupStart":237.5,"fetchStart":237.5,"redirectEnd":0,"redirectStart":0,"requestStart":237.5,"responseEnd":647,"responseStart":647,"secureConnectionStart":237.5},{"duration":411.30000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":237.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":649,"responseStart":0,"secureConnectionStart":0},{"duration":409.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":237.89999997615814,"connectEnd":237.89999997615814,"connectStart":237.89999997615814,"domainLookupEnd":237.89999997615814,"domainLookupStart":237.89999997615814,"fetchStart":237.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":237.89999997615814,"responseEnd":647.5,"responseStart":647.5,"secureConnectionStart":237.89999997615814},{"duration":411.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":238,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":649.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":409.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":238.19999998807907,"connectEnd":238.19999998807907,"connectStart":238.19999998807907,"domainLookupEnd":238.19999998807907,"domainLookupStart":238.19999998807907,"fetchStart":238.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":238.19999998807907,"responseEnd":648,"responseStart":648,"secureConnectionStart":238.19999998807907},{"duration":447.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":239,"connectEnd":239,"connectStart":239,"domainLookupEnd":239,"domainLookupStart":239,"fetchStart":239,"redirectEnd":0,"redirectStart":0,"requestStart":239,"responseEnd":686.1999999880791,"responseStart":686.1999999880791,"secureConnectionStart":239},{"duration":594.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":239,"connectEnd":239,"connectStart":239,"domainLookupEnd":239,"domainLookupStart":239,"fetchStart":239,"redirectEnd":0,"redirectStart":0,"requestStart":239,"responseEnd":833.3999999761581,"responseStart":833.3999999761581,"secureConnectionStart":239},{"duration":279.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":838.6999999880791,"connectEnd":838.6999999880791,"connectStart":838.6999999880791,"domainLookupEnd":838.6999999880791,"domainLookupStart":838.6999999880791,"fetchStart":838.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":838.6999999880791,"responseEnd":1118.199999988079,"responseStart":1118.199999988079,"secureConnectionStart":838.6999999880791}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":57,"responseStart":230,"responseEnd":234,"domLoading":234,"domInteractive":1224,"domContentLoadedEventStart":1224,"domContentLoadedEventEnd":1271,"domComplete":2030,"loadEventStart":2030,"loadEventEnd":2032,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1206.5},{"name":"bigPipe.sidebar-id.end","time":1207.300000011921},{"name":"bigPipe.activity-panel-pipe-id.start","time":1207.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":1209.800000011921},{"name":"activityTabFullyLoaded","time":1278.3999999761581}],"measures":[],"correlationId":"ac32c02aea5fe9","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":108,"dbReadsTimeInMs":15,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}