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":1274.7000002861023,"ttfb":382.40000009536743,"pageVisibility":"visible","entityId":75623,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"bac975d0-b9e7-4724-9c40-469653638a53","navigationType":0,"readyForUser":1371,"redirectCount":0,"resourceLoadedEnd":1687,"resourceLoadedStart":387.90000009536743,"resourceTiming":[{"duration":304.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":387.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":387.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":692.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":305,"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":388.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":388.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":693.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":314.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":388.30000019073486,"connectEnd":388.30000019073486,"connectStart":388.30000019073486,"domainLookupEnd":388.30000019073486,"domainLookupStart":388.30000019073486,"fetchStart":388.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":388.30000019073486,"responseEnd":702.8000001907349,"responseStart":702.8000001907349,"secureConnectionStart":388.30000019073486},{"duration":343.19999980926514,"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":388.6000003814697,"connectEnd":388.6000003814697,"connectStart":388.6000003814697,"domainLookupEnd":388.6000003814697,"domainLookupStart":388.6000003814697,"fetchStart":388.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":388.6000003814697,"responseEnd":731.8000001907349,"responseStart":731.8000001907349,"secureConnectionStart":388.6000003814697},{"duration":347.5,"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":388.90000009536743,"connectEnd":388.90000009536743,"connectStart":388.90000009536743,"domainLookupEnd":388.90000009536743,"domainLookupStart":388.90000009536743,"fetchStart":388.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":388.90000009536743,"responseEnd":736.4000000953674,"responseStart":736.4000000953674,"secureConnectionStart":388.90000009536743},{"duration":347.7999997138977,"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":389.1000003814697,"connectEnd":389.1000003814697,"connectStart":389.1000003814697,"domainLookupEnd":389.1000003814697,"domainLookupStart":389.1000003814697,"fetchStart":389.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":389.1000003814697,"responseEnd":736.9000000953674,"responseStart":736.9000000953674,"secureConnectionStart":389.1000003814697},{"duration":348,"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":389.30000019073486,"connectEnd":389.30000019073486,"connectStart":389.30000019073486,"domainLookupEnd":389.30000019073486,"domainLookupStart":389.30000019073486,"fetchStart":389.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":389.30000019073486,"responseEnd":737.3000001907349,"responseStart":737.3000001907349,"secureConnectionStart":389.30000019073486},{"duration":542.4000000953674,"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":389.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":389.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":931.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":348.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":389.6000003814697,"connectEnd":389.6000003814697,"connectStart":389.6000003814697,"domainLookupEnd":389.6000003814697,"domainLookupStart":389.6000003814697,"fetchStart":389.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":389.6000003814697,"responseEnd":737.8000001907349,"responseStart":737.8000001907349,"secureConnectionStart":389.6000003814697},{"duration":542.1999998092651,"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":389.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":389.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":932,"responseStart":0,"secureConnectionStart":0},{"duration":348.40000009536743,"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":390,"connectEnd":390,"connectStart":390,"domainLookupEnd":390,"domainLookupStart":390,"fetchStart":390,"redirectEnd":0,"redirectStart":0,"requestStart":390,"responseEnd":738.4000000953674,"responseStart":738.4000000953674,"secureConnectionStart":390},{"duration":771.4000000953674,"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":395.40000009536743,"connectEnd":395.40000009536743,"connectStart":395.40000009536743,"domainLookupEnd":395.40000009536743,"domainLookupStart":395.40000009536743,"fetchStart":395.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":395.40000009536743,"responseEnd":1166.8000001907349,"responseStart":1166.8000001907349,"secureConnectionStart":395.40000009536743},{"duration":1291.5,"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":395.5,"connectEnd":395.5,"connectStart":395.5,"domainLookupEnd":395.5,"domainLookupStart":395.5,"fetchStart":395.5,"redirectEnd":0,"redirectStart":0,"requestStart":395.5,"responseEnd":1687,"responseStart":1687,"secureConnectionStart":395.5},{"duration":349.3999996185303,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":962.1000003814697,"connectEnd":962.1000003814697,"connectStart":962.1000003814697,"domainLookupEnd":962.1000003814697,"domainLookupStart":962.1000003814697,"fetchStart":962.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":962.1000003814697,"responseEnd":1311.5,"responseStart":1311.4000000953674,"secureConnectionStart":962.1000003814697}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":196,"responseStart":382,"responseEnd":389,"domLoading":385,"domInteractive":1707,"domContentLoadedEventStart":1707,"domContentLoadedEventEnd":1752,"domComplete":3162,"loadEventStart":3162,"loadEventEnd":3164,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1688.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1689.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1689.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1692.3000001907349},{"name":"activityTabFullyLoaded","time":1761.2000002861023}],"measures":[],"correlationId":"c28b1135efbf62","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":10,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}