Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
This is most likely either the same problem as MDEV-476 , or a closely related one. The test case is exactly the same, except that in this bug we execute the flow in the second connection and get the assertion failure; while in MDEV-476 we execute the flow in the first connection, and get the crash. It happens both with MTR and if I start the server and execute the test manually.
With MTR, the flow, according to the general log, is such:
MDEV-476 :
server starts;
connection 1 connects;
connection 1 executes MTR service stuff;
connection 1 quits;
connection 2 connects;
connection 2 executes the test case statements;
server crashes
This bug:
server starts;
connection 1 connects;
connection 1 executes MTR service stuff;
connection 1 quits;
connection 2 connects;
connection 3 connects;
connection 3 executes the test case statements;
assertion fails.
When I execute it manually, I do it even simpler:
MDEV-476 :
start the server;
connection 1 connects;
connection 1 executes the test case statements;
server crashes.
This bug:
start the server;
connection 1 connects;
connection 1 quits;
connection 2 connects;
connection 2 executes the test case statements;
assertion fails.
I find the difference in behavior disturbing, so I'll file it separately just so it doesn't get lost. Please feel free to close it as a duplicate if that's what it is.
mysqld: sql/field.cc:3795: virtual longlong Field_longlong::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
#8 0xb7498014 in __assert_fail () from /lib/libc.so.6
#9 0x083eb8fb in Field_longlong::val_int (this=0x97cf9e0)
at sql/field.cc:3795
#10 0x0859216e in BigintDataConverter::mariadb_to_cassandra(char**, int*) ()
#11 0x08590d12 in ha_cassandra::index_read_map (this=0x97cf580,
buf=0x97cf9a0 "\377", key=0x97d73e8 "\001", keypart_map=1,
find_flag=HA_READ_KEY_EXACT)
at storage/cassandra/ha_cassandra.cc:648
#12 0x085917ad in ha_cassandra::rnd_pos (this=0x97cf580,
buf=0x97cf9a0 "\377", pos=0x97d73e8 "\001")
at storage/cassandra/ha_cassandra.cc:882
#13 0x082651eb in handler::ha_rnd_pos (this=0x97cf580,
buf=0x97cf9a0 "\377", pos=0x97d73e8 "\001")
at sql/sql_class.h:4283
#14 0x0851989b in rr_from_pointers (info=0xacec6714)
at sql/records.cc:529
#15 0x0853b984 in mysql_delete (thd=0x97afe68, table_list=0x97b23e0,
conds=0x0, order_list=0x97b1a20, limit=1, options=0)
at sql/sql_delete.cc:327
#16 0x08278fe7 in mysql_execute_command (thd=0x97afe68)
at sql/sql_parse.cc:3050
#17 0x08280453 in mysql_parse (thd=0x97afe68,
rawbuf=0x97b2320 "DELETE FROM t1 ORDER BY a LIMIT 1", length=33,
parser_state=0xacec6da4)
at sql/sql_parse.cc:5736
#18 0x0827489c in dispatch_command (command=COM_QUERY, thd=0x97afe68,
packet=0x97c6da1 "DELETE FROM t1 ORDER BY a LIMIT 1",
packet_length=33)
at sql/sql_parse.cc:1055
#19 0x08273d61 in do_command (thd=0x97afe68)
at sql/sql_parse.cc:794
#20 0x0835fb11 in do_handle_one_connection (thd_arg=0x97afe68)
at sql/sql_connect.cc:1253
#21 0x0835f65c in handle_one_connection (arg=0x97afe68)
at sql/sql_connect.cc:1168
#22 0x0858bf70 in pfs_spawn_thread (arg=0x97e7d50)
at storage/perfschema/pfs.cc:1015
#23 0xb7811b25 in start_thread () from /lib/libpthread.so.0
revision-id: psergey@askmonty.org-20120821143827-1gfv6fmua0cu29sl
date: 2012-08-21 18:38:27 +0400
build-date: 2012-08-23 00:46:27 +0400
revno: 3492
Test case:
--connect (con1,localhost,root,,)
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA
thrift_host='localhost' keyspace='storage_engine' column_family = 'colfam_t1';
INSERT INTO t1 VALUES (1,1),(2,2);
DELETE FROM t1 ORDER BY a LIMIT 1;
Transition
Time In Source Status
Execution Times
Open
Closed
19h 27m
1
{"report":{"fcp":1035.0999999046326,"ttfb":426.69999980926514,"pageVisibility":"visible","entityId":13819,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"db52da83-c230-465a-8224-3880ce86219f","navigationType":0,"readyForUser":1144,"redirectCount":0,"resourceLoadedEnd":1260.6999998092651,"resourceLoadedStart":432.59999990463257,"resourceTiming":[{"duration":60.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":432.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":432.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":493.5,"responseStart":0,"secureConnectionStart":0},{"duration":61.59999990463257,"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":432.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":432.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":494.5,"responseStart":0,"secureConnectionStart":0},{"duration":130.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":433.09999990463257,"connectEnd":433.09999990463257,"connectStart":433.09999990463257,"domainLookupEnd":433.09999990463257,"domainLookupStart":433.09999990463257,"fetchStart":433.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":433.09999990463257,"responseEnd":563.5,"responseStart":563.5,"secureConnectionStart":433.09999990463257},{"duration":219.39999961853027,"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":433.30000019073486,"connectEnd":433.30000019073486,"connectStart":433.30000019073486,"domainLookupEnd":433.30000019073486,"domainLookupStart":433.30000019073486,"fetchStart":433.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":433.30000019073486,"responseEnd":652.6999998092651,"responseStart":652.6999998092651,"secureConnectionStart":433.30000019073486},{"duration":223.30000019073486,"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":433.5,"connectEnd":433.5,"connectStart":433.5,"domainLookupEnd":433.5,"domainLookupStart":433.5,"fetchStart":433.5,"redirectEnd":0,"redirectStart":0,"requestStart":433.5,"responseEnd":656.8000001907349,"responseStart":656.6999998092651,"secureConnectionStart":433.5},{"duration":223.5,"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":433.69999980926514,"connectEnd":433.69999980926514,"connectStart":433.69999980926514,"domainLookupEnd":433.69999980926514,"domainLookupStart":433.69999980926514,"fetchStart":433.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":433.69999980926514,"responseEnd":657.1999998092651,"responseStart":657.1999998092651,"secureConnectionStart":433.69999980926514},{"duration":223.69999980926514,"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":434,"connectEnd":434,"connectStart":434,"domainLookupEnd":434,"domainLookupStart":434,"fetchStart":434,"redirectEnd":0,"redirectStart":0,"requestStart":434,"responseEnd":657.6999998092651,"responseStart":657.6999998092651,"secureConnectionStart":434},{"duration":274.7000002861023,"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":434.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":434.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":708.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":223.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":434.30000019073486,"connectEnd":434.30000019073486,"connectStart":434.30000019073486,"domainLookupEnd":434.30000019073486,"domainLookupStart":434.30000019073486,"fetchStart":434.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":434.30000019073486,"responseEnd":658.1999998092651,"responseStart":658.1999998092651,"secureConnectionStart":434.30000019073486},{"duration":274.5,"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":434.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":434.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":708.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":224.2000002861023,"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":434.59999990463257,"connectEnd":434.59999990463257,"connectStart":434.59999990463257,"domainLookupEnd":434.59999990463257,"domainLookupStart":434.59999990463257,"fetchStart":434.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":434.59999990463257,"responseEnd":658.8000001907349,"responseStart":658.8000001907349,"secureConnectionStart":434.59999990463257},{"duration":573.5,"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":435.59999990463257,"connectEnd":435.59999990463257,"connectStart":435.59999990463257,"domainLookupEnd":435.59999990463257,"domainLookupStart":435.59999990463257,"fetchStart":435.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":435.59999990463257,"responseEnd":1009.0999999046326,"responseStart":1009.0999999046326,"secureConnectionStart":435.59999990463257},{"duration":825,"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":435.69999980926514,"connectEnd":435.69999980926514,"connectStart":435.69999980926514,"domainLookupEnd":435.69999980926514,"domainLookupStart":435.69999980926514,"fetchStart":435.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":435.69999980926514,"responseEnd":1260.6999998092651,"responseStart":1260.6999998092651,"secureConnectionStart":435.69999980926514},{"duration":298.7999997138977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":720.8000001907349,"connectEnd":720.8000001907349,"connectStart":720.8000001907349,"domainLookupEnd":720.8000001907349,"domainLookupStart":720.8000001907349,"fetchStart":720.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":720.8000001907349,"responseEnd":1019.5999999046326,"responseStart":1019.5999999046326,"secureConnectionStart":720.8000001907349},{"duration":250.89999961853027,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1027.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1027.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1278.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":217,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1069.6999998092651,"connectEnd":1069.6999998092651,"connectStart":1069.6999998092651,"domainLookupEnd":1069.6999998092651,"domainLookupStart":1069.6999998092651,"fetchStart":1069.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1069.6999998092651,"responseEnd":1286.6999998092651,"responseStart":1286.6999998092651,"secureConnectionStart":1069.6999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":257,"responseStart":426,"responseEnd":428,"domLoading":430,"domInteractive":1281,"domContentLoadedEventStart":1281,"domContentLoadedEventEnd":1323,"domComplete":1721,"loadEventStart":1721,"loadEventEnd":1722,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1262.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1263.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1263.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1264.8000001907349},{"name":"activityTabFullyLoaded","time":1336.1999998092651}],"measures":[],"correlationId":"8e437e6f23321a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":100,"dbReadsTimeInMs":14,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}