Using following scenario:
- Started 5 nodes of 10.3
- Did Rolling Upgrade to 10.4
- Run following SQLs one of the nodes:
CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1;
|
CREATE TABLE Observation (Id int(11) NOT NULL, Place varchar(50) NOT NULL, BirdId int(11) NOT NULL,PRIMARY KEY (Id));
|
INSERT INTO Observation (Id, Place, BirdId) VALUES (NEXT VALUE FOR Seq1_1, 'Helsinki', 10);
|
INSERT INTO Observation (Id, Place, BirdId) VALUES (NEXT VALUE FOR Seq1_1, 'Espoo', 10);
|
INSERT INTO Observation (Id, Place, BirdId) VALUES (NEXT VALUE FOR Seq1_1, 'Kirkkonummi', 10);
|
INSERT INTO Observation (Id, Place, BirdId) VALUES (NEXT VALUE FOR Seq1_1, 'Hanko', 10);
|
drop sequence Seq1_1;
|
CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1;
|
INSERT INTO Observation (Id, Place, BirdId) VALUES (NEXT VALUE FOR Seq1_1, 'Helsinki', 10);
|
The result of last insert:
`ERROR 2013 (HY000): Lost connection to MySQL server during query`
From error log:
mysqld: /home/shako/Galera_Tests/MariaDB/wsrep-lib/src/transaction.cpp:456: int wsrep::transaction::ordered_commit(): Assertion `state() == s_committing' failed.
|
190306 13:21:41 [ERROR] mysqld got signal 6 ;
|
stdlib/abort.c:81(__GI_abort)[0x7fc418e8c801]
|
assert/assert.c:89(__assert_fail_base)[0x7fc418e7c39a]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x30412)[0x7fc418e7c412]
|
/home/shako/Galera_Tests/dbs/maria_10.4/bin/mysqld(_ZN5wsrep11transaction14ordered_commitEv+0x72)[0x555c0ff107ea]
|
src/transaction.cpp:457(wsrep::transaction::ordered_commit())[0x555c0f5ae0ee]
|
wsrep/client_state.hpp:409(wsrep::client_state::ordered_commit())[0x555c0f7c53f5]
|
sql/wsrep_trans_observer.h:291(wsrep_ordered_commit(THD*, bool, wsrep_apply_error const&))[0x555c0f7d9705]
|
sql/log.cc:7689(MYSQL_BIN_LOG::write_transaction_to_binlog_events(MYSQL_BIN_LOG::group_commit_entry*))[0x555c0f7d8d2e]
|
sql/log.cc:7370(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool))[0x555c0f7c8efa]
|
sql/log.cc:1785(binlog_flush_cache(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool))[0x555c0f7c91fc]
|
sql/log.cc:1837(binlog_commit_flush_stmt_cache(THD*, bool, binlog_cache_mngr*))[0x555c0f7c9e7e]
|
sql/log.cc:2109(binlog_rollback(handlerton*, THD*, bool))[0x555c0f6b5c51]
|
sql/handler.cc:1852(ha_rollback_trans(THD*, bool))[0x555c0f4f8521]
|
sql/transaction.cc:573(trans_rollback_stmt(THD*))[0x555c0f378801]
|
sql/sql_parse.cc:6396(mysql_execute_command(THD*))[0x555c0f37d71c]
|
sql/sql_parse.cc:8157(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555c0f37cd92]
|
sql/sql_parse.cc:7980(wsrep_mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555c0f368982]
|
sql/sql_parse.cc:1813(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x555c0f367289]
|
sql/sql_parse.cc:1357(do_command(THD*))[0x555c0f4dfa4b]
|
sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x555c0f4df7af]
|
nptl/pthread_create.c:463(start_thread)[0x7fc419d876db]
|
x86_64/clone.S:97(clone)[0x7fc418f6d88f]
|
With 10.3 cluster there is no such issue -> reusing sequence resulted with duplicated key error as expected.
{"report":{"fcp":628.8999996185303,"ttfb":147.5999994277954,"pageVisibility":"visible","entityId":72988,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"3fe87afe-9bd4-477c-9b6e-e5f9712f7d7f","navigationType":0,"readyForUser":704.0999994277954,"redirectCount":0,"resourceLoadedEnd":623.5999994277954,"resourceLoadedStart":152.80000019073486,"resourceTiming":[{"duration":6,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":152.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":158.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":6.300000190734863,"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":153,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":159.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":62.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":153.0999994277954,"connectEnd":153.0999994277954,"connectStart":153.0999994277954,"domainLookupEnd":153.0999994277954,"domainLookupStart":153.0999994277954,"fetchStart":153.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":153.0999994277954,"responseEnd":215.80000019073486,"responseStart":215.80000019073486,"secureConnectionStart":153.0999994277954},{"duration":145.5,"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":153.30000019073486,"connectEnd":153.30000019073486,"connectStart":153.30000019073486,"domainLookupEnd":153.30000019073486,"domainLookupStart":153.30000019073486,"fetchStart":153.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":153.30000019073486,"responseEnd":298.80000019073486,"responseStart":298.69999980926514,"secureConnectionStart":153.30000019073486},{"duration":141.5999994277954,"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":153.30000019073486,"connectEnd":153.30000019073486,"connectStart":153.30000019073486,"domainLookupEnd":153.30000019073486,"domainLookupStart":153.30000019073486,"fetchStart":153.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":153.30000019073486,"responseEnd":294.8999996185303,"responseStart":294.8999996185303,"secureConnectionStart":153.30000019073486},{"duration":146,"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":153.5,"connectEnd":153.5,"connectStart":153.5,"domainLookupEnd":153.5,"domainLookupStart":153.5,"fetchStart":153.5,"redirectEnd":0,"redirectStart":0,"requestStart":153.5,"responseEnd":299.5,"responseStart":299.5,"secureConnectionStart":153.5},{"duration":145.5999994277954,"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":153.5,"connectEnd":153.5,"connectStart":153.5,"domainLookupEnd":153.5,"domainLookupStart":153.5,"fetchStart":153.5,"redirectEnd":0,"redirectStart":0,"requestStart":153.5,"responseEnd":299.0999994277954,"responseStart":299.0999994277954,"secureConnectionStart":153.5},{"duration":146.4000005722046,"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":153.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":300,"responseStart":0,"secureConnectionStart":0},{"duration":146.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":153.69999980926514,"connectEnd":153.69999980926514,"connectStart":153.69999980926514,"domainLookupEnd":153.69999980926514,"domainLookupStart":153.69999980926514,"fetchStart":153.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":153.69999980926514,"responseEnd":300,"responseStart":300,"secureConnectionStart":153.69999980926514},{"duration":146.69999980926514,"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":153.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":300.5,"responseStart":0,"secureConnectionStart":0},{"duration":146.5999994277954,"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":154,"connectEnd":154,"connectStart":154,"domainLookupEnd":154,"domainLookupStart":154,"fetchStart":154,"redirectEnd":0,"redirectStart":0,"requestStart":154,"responseEnd":300.5999994277954,"responseStart":300.5999994277954,"secureConnectionStart":154},{"duration":448.9000005722046,"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":159.89999961853027,"connectEnd":159.89999961853027,"connectStart":159.89999961853027,"domainLookupEnd":159.89999961853027,"domainLookupStart":159.89999961853027,"fetchStart":159.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":159.89999961853027,"responseEnd":608.8000001907349,"responseStart":608.8000001907349,"secureConnectionStart":159.89999961853027},{"duration":463.5,"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":160.0999994277954,"connectEnd":160.0999994277954,"connectStart":160.0999994277954,"domainLookupEnd":160.0999994277954,"domainLookupStart":160.0999994277954,"fetchStart":160.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":160.0999994277954,"responseEnd":623.5999994277954,"responseStart":623.5999994277954,"secureConnectionStart":160.0999994277954},{"duration":180.5999994277954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","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":613.8999996185303,"responseStart":613.8999996185303,"secureConnectionStart":433.30000019073486},{"duration":21.799999237060547,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":607.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":607.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":629.0999994277954,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":15,"responseStart":147,"responseEnd":159,"domLoading":151,"domInteractive":823,"domContentLoadedEventStart":823,"domContentLoadedEventEnd":868,"domComplete":1678,"loadEventStart":1678,"loadEventEnd":1680,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":802.5999994277954},{"name":"bigPipe.sidebar-id.end","time":803.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":803.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":806.1999998092651},{"name":"activityTabFullyLoaded","time":882.8000001907349}],"measures":[],"correlationId":"5716333df2df09","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":76,"dbReadsTimeInMs":9,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}