In debug mode running a test with --repeat results in an every second run failed like this:
innodb.innodb-change-buffer-recovery 'innodb' [ fail ]
|
Test ended at 2019-04-26 12:23:01
|
|
CURRENT_TEST: innodb.innodb-change-buffer-recovery
|
--- /home/kevg/work/mariadb/mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result 2019-04-26 12:14:05.804197310 +0300
|
+++ /home/kevg/work/mariadb/mysql-test/suite/innodb/r/innodb-change-buffer-recovery.reject 2019-04-26 12:23:01.364749083 +0300
|
@@ -38,7 +38,7 @@
|
ERROR HY000: Lost connection to MySQL server during query
|
disconnect con1;
|
connection default;
|
-FOUND 1 /Wrote log record for ibuf update in place operation/ in my_restart.err
|
+FOUND 2 /Wrote log record for ibuf update in place operation/ in my_restart.err
|
CHECK TABLE t1;
|
Table Op Msg_type Msg_text
|
test.t1 check status OK
|
|
mysqltest: Result content mismatch
|
|
- saving '/home/kevg/work/debug/mysql-test/var/log/innodb.innodb-change-buffer-recovery-innodb/' to '/home/kevg/work/debug/mysql-test/var/log/innodb.innodb-change-buffer-recovery-innodb/'
|
In debug mode with -O2 it sometime crashes like this:
#6 0x00007f4016d55012 in __GI___assert_fail (assertion=0xfadc93 "field != 16 || val", file=0xf9048b "/work/mariadb/storage/innobase/include/page0page.ic", line=176, function=0xfadc3f "void page_header_set_field(ib_page_t *, page_zip_des_t *, ulint, ulint)") at assert.c:101
|
#7 0x0000000000a1bbcb in page_header_set_field (page=<optimized out>, page_zip=0x0, field=16, val=<optimized out>) at page0page.ic:176
|
#8 page_mem_free (page=<optimized out>, page_zip=0x0, rec=<optimized out>, index=<optimized out>, offsets=<optimized out>) at page0page.ic:1047
|
#9 page_cur_delete_rec (cursor=0x7f40106e8d01, index=<optimized out>, offsets=0x7ffe97abb990, mtr=0x7ffe97abc230) at page0cur.cc:2417
|
#10 0x0000000000b79fab in btr_cur_optimistic_delete_func (cursor=0x7ffe97abc760, flags=<optimized out>, mtr=0x7ffe97abc230) at btr0cur.cc:5163
|
#11 0x00000000009c4387 in ibuf_delete_rec (space=4, page_no=27, pcur=0x7ffe97abc760, search_tuple=0x26faf98, mtr=0x7ffe97abc230) at ibuf0ibuf.cc:4261
|
#12 0x00000000009c11de in ibuf_merge_or_delete_for_page (block=0x7f40102526a8, page_id=..., page_size=0x7f40102526b8, update_ibuf_bitmap=1) at ibuf0ibuf.cc:4645
|
#13 0x00000000009fcd6f in mlog_init_t::ibuf_merge (this=<optimized out>, mtr=...) at log0recv.cc:330
|
#14 0x00000000009f44c5 in recv_apply_hashed_log_recs (last_batch=<optimized out>) at log0recv.cc:2516
|
#15 0x0000000000ae989b in innobase_start_or_create_for_mysql () at srv0start.cc:2224
|
#16 0x000000000097d77f in innobase_init (p=<optimized out>) at ha_innodb.cc:4377
|
#17 0x00000000007af955 in ha_initialize_handlerton (plugin=0x2367ca8) at handler.cc:521
|
#18 0x000000000060cc59 in plugin_initialize (tmp_root=0x7ffe97ac26b8, plugin=0x2367ca8, argc=0x15d1f68 <remaining_argc>, argv=0x2225428, options_only=<optimized out>) at sql_plugin.cc:1416
|
#19 0x000000000060c77e in plugin_init (argc=0x15d1f68 <remaining_argc>, argv=0x2225428, flags=2) at sql_plugin.cc:1697
|
#20 0x00000000005525b5 in init_server_components () at mysqld.cc:5311
|
#21 mysqld_main (argc=<optimized out>, argv=0x2225428) at mysqld.cc:5907
|
Adding -mysqld=-debug=d,ib_log_checkpoint_avoid make debug version fail with the same backtrace.
- relates to
-
MDEV-22497
[ERROR] InnoDB: Unable to purge a record
-
-
Closed
- links to
-
{"report":{"fcp":1153,"ttfb":344.69999980926514,"pageVisibility":"visible","entityId":75623,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"f1b0ae85-c14a-4757-84a5-4a522edc69bf","navigationType":0,"readyForUser":1236.5999999046326,"redirectCount":0,"resourceLoadedEnd":1539.3000001907349,"resourceLoadedStart":353.40000009536743,"resourceTiming":[{"duration":327.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":353.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":353.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":680.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":327.2000002861023,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":353.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":353.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":680.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":336.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":354,"connectEnd":354,"connectStart":354,"domainLookupEnd":354,"domainLookupStart":354,"fetchStart":354,"redirectEnd":0,"redirectStart":0,"requestStart":354,"responseEnd":690.4000000953674,"responseStart":690.4000000953674,"secureConnectionStart":354},{"duration":461.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":354.5,"connectEnd":354.5,"connectStart":354.5,"domainLookupEnd":354.5,"domainLookupStart":354.5,"fetchStart":354.5,"redirectEnd":0,"redirectStart":0,"requestStart":354.5,"responseEnd":816.3000001907349,"responseStart":816.3000001907349,"secureConnectionStart":354.5},{"duration":466,"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":354.69999980926514,"connectEnd":354.69999980926514,"connectStart":354.69999980926514,"domainLookupEnd":354.69999980926514,"domainLookupStart":354.69999980926514,"fetchStart":354.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":354.69999980926514,"responseEnd":820.6999998092651,"responseStart":820.6999998092651,"secureConnectionStart":354.69999980926514},{"duration":466.09999990463257,"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":354.90000009536743,"connectEnd":354.90000009536743,"connectStart":354.90000009536743,"domainLookupEnd":354.90000009536743,"domainLookupStart":354.90000009536743,"fetchStart":354.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":354.90000009536743,"responseEnd":821,"responseStart":821,"secureConnectionStart":354.90000009536743},{"duration":466.30000019073486,"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":355.09999990463257,"connectEnd":355.09999990463257,"connectStart":355.09999990463257,"domainLookupEnd":355.09999990463257,"domainLookupStart":355.09999990463257,"fetchStart":355.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":355.09999990463257,"responseEnd":821.4000000953674,"responseStart":821.4000000953674,"secureConnectionStart":355.09999990463257},{"duration":485.2999997138977,"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":355.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":355.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":840.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":466.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":355.40000009536743,"connectEnd":355.40000009536743,"connectStart":355.40000009536743,"domainLookupEnd":355.40000009536743,"domainLookupStart":355.40000009536743,"fetchStart":355.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":355.40000009536743,"responseEnd":821.9000000953674,"responseStart":821.9000000953674,"secureConnectionStart":355.40000009536743},{"duration":485.09999990463257,"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":355.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":355.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":840.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":466.80000019073486,"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":355.69999980926514,"connectEnd":355.69999980926514,"connectStart":355.69999980926514,"domainLookupEnd":355.69999980926514,"domainLookupStart":355.69999980926514,"fetchStart":355.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":355.69999980926514,"responseEnd":822.5,"responseStart":822.5,"secureConnectionStart":355.69999980926514},{"duration":1053.8000001907349,"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":374,"connectEnd":374,"connectStart":374,"domainLookupEnd":374,"domainLookupStart":374,"fetchStart":374,"redirectEnd":0,"redirectStart":0,"requestStart":374,"responseEnd":1427.8000001907349,"responseStart":1427.8000001907349,"secureConnectionStart":374},{"duration":1160.2000002861023,"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":379.09999990463257,"connectEnd":379.09999990463257,"connectStart":379.09999990463257,"domainLookupEnd":379.09999990463257,"domainLookupStart":379.09999990463257,"fetchStart":379.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":379.09999990463257,"responseEnd":1539.3000001907349,"responseStart":1539.3000001907349,"secureConnectionStart":379.09999990463257},{"duration":593.8000001907349,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":852.6999998092651,"connectEnd":852.6999998092651,"connectStart":852.6999998092651,"domainLookupEnd":852.6999998092651,"domainLookupStart":852.6999998092651,"fetchStart":852.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":852.6999998092651,"responseEnd":1446.5,"responseStart":1446.5,"secureConnectionStart":852.6999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":170,"responseStart":345,"responseEnd":379,"domLoading":348,"domInteractive":1563,"domContentLoadedEventStart":1563,"domContentLoadedEventEnd":1607,"domComplete":1969,"loadEventStart":1969,"loadEventEnd":1969,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1541.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1542},{"name":"bigPipe.activity-panel-pipe-id.start","time":1542.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1543.5999999046326},{"name":"activityTabFullyLoaded","time":1621.8000001907349}],"measures":[],"correlationId":"9dcb706ad67fe5","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":105,"dbReadsTimeInMs":21,"dbConnsTimeInMs":30,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
