--source include/have_innodb.inc
|
CREATE SEQUENCE a ENGINE=InnoDB ;
|
CREATE TEMPORARY SEQUENCE b ENGINE=InnoDB;
|
ALTER SEQUENCE IF EXISTS a RESTART WITH 0;
|
10.3 86b941703
|
mysqld: /data/src/10.3/storage/innobase/row/row0undo.cc:196: bool row_undo_search_clust_to_pcur(undo_node_t*): Assertion `row_get_rec_trx_id(rec, clust_index, offsets) == node->trx->id' failed.
|
170607 10:32:53 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f0e5573aee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005605799f323a in row_undo_search_clust_to_pcur (node=0x7f0dfc036c38) at /data/src/10.3/storage/innobase/row/row0undo.cc:195
|
#9 0x0000560579be29b3 in row_undo_ins_parse_undo_rec (node=0x7f0dfc036c38, dict_locked=0) at /data/src/10.3/storage/innobase/row/row0uins.cc:372
|
#10 0x0000560579be2d23 in row_undo_ins (node=0x7f0dfc036c38, thr=0x7f0dfc036a80) at /data/src/10.3/storage/innobase/row/row0uins.cc:474
|
#11 0x00005605799f3638 in row_undo (node=0x7f0dfc036c38, thr=0x7f0dfc036a80) at /data/src/10.3/storage/innobase/row/row0undo.cc:296
|
#12 0x00005605799f3785 in row_undo_step (thr=0x7f0dfc036a80) at /data/src/10.3/storage/innobase/row/row0undo.cc:342
|
#13 0x0000560579952a0b in que_thr_step (thr=0x7f0dfc036a80) at /data/src/10.3/storage/innobase/que/que0que.cc:1051
|
#14 0x0000560579952c25 in que_run_threads_low (thr=0x7f0dfc036a80) at /data/src/10.3/storage/innobase/que/que0que.cc:1115
|
#15 0x0000560579952dce in que_run_threads (thr=0x7f0dfc036a80) at /data/src/10.3/storage/innobase/que/que0que.cc:1155
|
#16 0x0000560579a54abe in trx_rollback_to_savepoint_low (trx=0x7f0e4b3fe8c8, savept=0x0) at /data/src/10.3/storage/innobase/trx/trx0roll.cc:118
|
#17 0x0000560579a54e28 in trx_rollback_for_mysql_low (trx=0x7f0e4b3fe8c8) at /data/src/10.3/storage/innobase/trx/trx0roll.cc:180
|
#18 0x0000560579a55112 in trx_rollback_low (trx=0x7f0e4b3fe8c8) at /data/src/10.3/storage/innobase/trx/trx0roll.cc:212
|
#19 0x0000560579a55449 in trx_rollback_for_mysql (trx=0x7f0e4b3fe8c8) at /data/src/10.3/storage/innobase/trx/trx0roll.cc:288
|
#20 0x000056057985d77b in innobase_rollback (hton=0x56057b9b4a00, thd=0x7f0dfc000b00, rollback_trx=false) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4816
|
#21 0x00005605795532ae in ha_rollback_trans (thd=0x7f0dfc000b00, all=false) at /data/src/10.3/sql/handler.cc:1662
|
#22 0x00005605793ff43c in trans_rollback_stmt (thd=0x7f0dfc000b00) at /data/src/10.3/sql/transaction.cc:566
|
#23 0x00005605792ab048 in mysql_execute_command (thd=0x7f0dfc000b00) at /data/src/10.3/sql/sql_parse.cc:6275
|
#24 0x00005605792af860 in mysql_parse (thd=0x7f0dfc000b00, rawbuf=0x7f0dfc0148c8 "ALTER SEQUENCE IF EXISTS a RESTART WITH 0", length=41, parser_state=0x7f0e48345200, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7927
|
#25 0x000056057929d518 in dispatch_command (command=COM_QUERY, thd=0x7f0dfc000b00, packet=0x7f0dfc08f811 "ALTER SEQUENCE IF EXISTS a RESTART WITH 0", packet_length=41, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1817
|
#26 0x000056057929bec1 in do_command (thd=0x7f0dfc000b00) at /data/src/10.3/sql/sql_parse.cc:1380
|
#27 0x00005605793e93f4 in do_handle_one_connection (connect=0x56057bfc1a60) at /data/src/10.3/sql/sql_connect.cc:1354
|
#28 0x00005605793e9181 in handle_one_connection (arg=0x56057bfc1a60) at /data/src/10.3/sql/sql_connect.cc:1260
|
#29 0x0000560579845a8d in pfs_spawn_thread (arg=0x56057bf086f0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#30 0x00007f0e57474494 in start_thread (arg=0x7f0e48346700) at pthread_create.c:333
|
#31 0x00007f0e557f793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Also reproducible on bb-10.2-ext 3d428e017d.
- relates to
-
MDEV-13016
Testing SEQUENCE object phase 2
-
-
Closed
{"report":{"fcp":1007.2999999523163,"ttfb":209.09999990463257,"pageVisibility":"visible","entityId":61700,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"9b0452d4-e1ab-451d-88bc-061e7dea3399","navigationType":0,"readyForUser":1094.3999998569489,"redirectCount":0,"resourceLoadedEnd":1403.2999999523163,"resourceLoadedStart":215.59999990463257,"resourceTiming":[{"duration":156.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":215.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":215.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":156.79999995231628,"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":215.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":215.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":214.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":216,"connectEnd":216,"connectStart":216,"domainLookupEnd":216,"domainLookupStart":216,"fetchStart":216,"redirectEnd":0,"redirectStart":0,"requestStart":216,"responseEnd":430.89999985694885,"responseStart":430.89999985694885,"secureConnectionStart":216},{"duration":300,"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":216.09999990463257,"connectEnd":216.09999990463257,"connectStart":216.09999990463257,"domainLookupEnd":216.09999990463257,"domainLookupStart":216.09999990463257,"fetchStart":216.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":216.09999990463257,"responseEnd":516.0999999046326,"responseStart":516.0999999046326,"secureConnectionStart":216.09999990463257},{"duration":303.7000000476837,"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":216.29999995231628,"connectEnd":216.29999995231628,"connectStart":216.29999995231628,"domainLookupEnd":216.29999995231628,"domainLookupStart":216.29999995231628,"fetchStart":216.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":216.29999995231628,"responseEnd":520,"responseStart":520,"secureConnectionStart":216.29999995231628},{"duration":304.5,"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":216.39999985694885,"connectEnd":216.39999985694885,"connectStart":216.39999985694885,"domainLookupEnd":216.39999985694885,"domainLookupStart":216.39999985694885,"fetchStart":216.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":216.39999985694885,"responseEnd":520.8999998569489,"responseStart":520.8999998569489,"secureConnectionStart":216.39999985694885},{"duration":304.10000014305115,"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":216.39999985694885,"connectEnd":216.39999985694885,"connectStart":216.39999985694885,"domainLookupEnd":216.39999985694885,"domainLookupStart":216.39999985694885,"fetchStart":216.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":216.39999985694885,"responseEnd":520.5,"responseStart":520.5,"secureConnectionStart":216.39999985694885},{"duration":310.2000000476837,"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":216.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":216.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":304.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":216.59999990463257,"connectEnd":216.59999990463257,"connectStart":216.59999990463257,"domainLookupEnd":216.59999990463257,"domainLookupStart":216.59999990463257,"fetchStart":216.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":216.59999990463257,"responseEnd":521.3999998569489,"responseStart":521.3999998569489,"secureConnectionStart":216.59999990463257},{"duration":310,"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":216.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":216.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":305.2000000476837,"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":216.89999985694885,"connectEnd":216.89999985694885,"connectStart":216.89999985694885,"domainLookupEnd":216.89999985694885,"domainLookupStart":216.89999985694885,"fetchStart":216.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":216.89999985694885,"responseEnd":522.0999999046326,"responseStart":522.0999999046326,"secureConnectionStart":216.89999985694885},{"duration":549.9000000953674,"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":225.79999995231628,"connectEnd":225.79999995231628,"connectStart":225.79999995231628,"domainLookupEnd":225.79999995231628,"domainLookupStart":225.79999995231628,"fetchStart":225.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":225.79999995231628,"responseEnd":775.7000000476837,"responseStart":775.7000000476837,"secureConnectionStart":225.79999995231628},{"duration":1177.4000000953674,"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":225.89999985694885,"connectEnd":225.89999985694885,"connectStart":225.89999985694885,"domainLookupEnd":225.89999985694885,"domainLookupStart":225.89999985694885,"fetchStart":225.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":225.89999985694885,"responseEnd":1403.2999999523163,"responseStart":1403.2999999523163,"secureConnectionStart":225.89999985694885},{"duration":732.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":670,"connectEnd":670,"connectStart":670,"domainLookupEnd":670,"domainLookupStart":670,"fetchStart":670,"redirectEnd":0,"redirectStart":0,"requestStart":670,"responseEnd":1402.7999999523163,"responseStart":1402.7999999523163,"secureConnectionStart":670},{"duration":421.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":983.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":983.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1404.5999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":83,"responseStart":209,"responseEnd":222,"domLoading":214,"domInteractive":1437,"domContentLoadedEventStart":1437,"domContentLoadedEventEnd":1475,"domComplete":2121,"loadEventStart":2121,"loadEventEnd":2122,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1413.2999999523163},{"name":"bigPipe.sidebar-id.end","time":1416},{"name":"bigPipe.activity-panel-pipe-id.start","time":1416.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1419.3999998569489},{"name":"activityTabFullyLoaded","time":1482.5999999046326}],"measures":[],"correlationId":"4c600b95fc432c","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}