10.2 6d51817d2cd79edbc15328bef532a5375f184219
mysqld: /data/src/10.2/storage/innobase/ibuf/ibuf0ibuf.cc:1144: ulint ibuf_page_low(const page_id_t&, const page_size_t&, ulint, const char*, unsigned int, mtr_t*): Assertion `!recv_no_ibuf_operations' failed.
170804 16:14:56 [ERROR] mysqld got signal 6 ;
#7 0x00007f5c32b42ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055b3ae6bcc57 in ibuf_page_low (page_id=..., page_size=..., x_latch=0, file=0x55b3aeca3878 "/data/src/10.2/storage/innobase/ibuf/ibuf0ibuf.cc", line=548, mtr=0x0) at /data/src/10.2/storage/innobase/ibuf/ibuf0ibuf.cc:1144
#9 0x000055b3ae8d1212 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=2, guess=0x0, mode=10, file=0x55b3aeca3878 "/data/src/10.2/storage/innobase/ibuf/ibuf0ibuf.cc", line=548, mtr=0x7ffc538321c0, err=0x0) at /data/src/10.2/storage/innobase/buf/buf0buf.cc:4210
#10 0x000055b3ae6bbc4b in ibuf_init_at_db_start () at /data/src/10.2/storage/innobase/ibuf/ibuf0ibuf.cc:548
#11 0x000055b3ae9061b3 in dict_boot () at /data/src/10.2/storage/innobase/dict/dict0boot.cc:487
#12 0x000055b3ae812260 in innobase_start_or_create_for_mysql () at /data/src/10.2/storage/innobase/srv/srv0start.cc:2233
#13 0x000055b3ae652f99 in innobase_init (p=0x55b3b131a190) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:4422
#14 0x000055b3ae34a1b3 in ha_initialize_handlerton (plugin=0x55b3b12273c0) at /data/src/10.2/sql/handler.cc:512
#15 0x000055b3ae0f49e3 in plugin_initialize (tmp_root=0x7ffc5383a8a0, plugin=0x55b3b12273c0, argc=0x55b3af61e770 <remaining_argc>, argv=0x55b3b10de370, options_only=false) at /data/src/10.2/sql/sql_plugin.cc:1413
#16 0x000055b3ae0f55ec in plugin_init (argc=0x55b3af61e770 <remaining_argc>, argv=0x55b3b10de370, flags=2) at /data/src/10.2/sql/sql_plugin.cc:1695
#17 0x000055b3ae002062 in init_server_components () at /data/src/10.2/sql/mysqld.cc:5255
#18 0x000055b3ae0030e7 in mysqld_main (argc=144, argv=0x55b3b10de370) at /data/src/10.2/sql/mysqld.cc:5845
#19 0x000055b3adff7fc0 in main (argc=22, argv=0x7ffc5383b638) at /data/src/10.2/sql/main.cc:25
Test case is attached, run it with --mem --repeat=N
The assertion started failing in 10.2 tree with this commit:
commit 42f657cd2fab9acb00b15e00c7cc630f64ecc6ec
Author: Marko Mäkelä <marko.makela@mariadb.com>
Date: Fri Jul 7 18:29:31 2017 +0300
MDEV-13267 At startup with crash recovery: mtr_t::commit_checkpoint(lsn_t, bool): Assertion `!recv_no_log_write' failed
Before this commit, the same test case would cause Assertion `!recv_no_log_write' failure.
relates to
MDEV-13452
Assertion `!recv_no_log_write' failed in lsn_t log_reserve_and_open
Closed
made changes -
2017-08-04 13:42
Field
Original Value
New Value
Assignee
Jan Lindström
[ jplindst
]
Marko Mäkelä
[ marko
]
made changes -
2017-08-07 08:21
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
2017-08-07 08:23
Assignee
Marko Mäkelä
[ marko
]
Jan Lindström
[ jplindst
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2017-08-07 08:48
Assignee
Jan Lindström
[ jplindst
]
Marko Mäkelä
[ marko
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2017-08-07 11:00
issue.field.resolutiondate
2017-08-07 11:00:24.0
2017-08-07 11:00:24.589
made changes -
2017-08-07 11:00
Fix Version/s
10.2.8
[ 22544
]
Fix Version/s
10.2
[ 14601
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
made changes -
2021-12-06 21:45
Workflow
MariaDB v3
[ 81911
]
MariaDB v4
[ 152567
]
{"report":{"fcp":1536.0999999046326,"ttfb":454.40000009536743,"pageVisibility":"visible","entityId":62505,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a205a639-5bd0-426d-84ff-d80d955b0eed","navigationType":0,"readyForUser":1622.1999998092651,"redirectCount":0,"resourceLoadedEnd":1903,"resourceLoadedStart":459.59999990463257,"resourceTiming":[{"duration":599.0999999046326,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":459.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":459.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1058.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":599.0999999046326,"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":459.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":459.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1059,"responseStart":0,"secureConnectionStart":0},{"duration":608.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":460,"connectEnd":460,"connectStart":460,"domainLookupEnd":460,"domainLookupStart":460,"fetchStart":460,"redirectEnd":0,"redirectStart":0,"requestStart":460,"responseEnd":1068.4000000953674,"responseStart":1068.4000000953674,"secureConnectionStart":460},{"duration":664.4000000953674,"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":460.19999980926514,"connectEnd":460.19999980926514,"connectStart":460.19999980926514,"domainLookupEnd":460.19999980926514,"domainLookupStart":460.19999980926514,"fetchStart":460.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":460.19999980926514,"responseEnd":1124.5999999046326,"responseStart":1124.5999999046326,"secureConnectionStart":460.19999980926514},{"duration":668.0999999046326,"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":460.5,"connectEnd":460.5,"connectStart":460.5,"domainLookupEnd":460.5,"domainLookupStart":460.5,"fetchStart":460.5,"redirectEnd":0,"redirectStart":0,"requestStart":460.5,"responseEnd":1128.5999999046326,"responseStart":1128.5999999046326,"secureConnectionStart":460.5},{"duration":668.4000000953674,"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":460.69999980926514,"connectEnd":460.69999980926514,"connectStart":460.69999980926514,"domainLookupEnd":460.69999980926514,"domainLookupStart":460.69999980926514,"fetchStart":460.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":460.69999980926514,"responseEnd":1129.0999999046326,"responseStart":1129.0999999046326,"secureConnectionStart":460.69999980926514},{"duration":668.7999997138977,"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":460.80000019073486,"connectEnd":460.80000019073486,"connectStart":460.80000019073486,"domainLookupEnd":460.80000019073486,"domainLookupStart":460.80000019073486,"fetchStart":460.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":460.80000019073486,"responseEnd":1129.5999999046326,"responseStart":1129.5999999046326,"secureConnectionStart":460.80000019073486},{"duration":753.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":461.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":461.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1214.5,"responseStart":0,"secureConnectionStart":0},{"duration":668.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":461.19999980926514,"connectEnd":461.19999980926514,"connectStart":461.19999980926514,"domainLookupEnd":461.19999980926514,"domainLookupStart":461.19999980926514,"fetchStart":461.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":461.19999980926514,"responseEnd":1130.0999999046326,"responseStart":1130.0999999046326,"secureConnectionStart":461.19999980926514},{"duration":753.3999996185303,"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":461.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":461.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1214.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":669,"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":461.5,"connectEnd":461.5,"connectStart":461.5,"domainLookupEnd":461.5,"domainLookupStart":461.5,"fetchStart":461.5,"redirectEnd":0,"redirectStart":0,"requestStart":461.5,"responseEnd":1130.5,"responseStart":1130.5,"secureConnectionStart":461.5},{"duration":884.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":467,"connectEnd":467,"connectStart":467,"domainLookupEnd":467,"domainLookupStart":467,"fetchStart":467,"redirectEnd":0,"redirectStart":0,"requestStart":467,"responseEnd":1351.8000001907349,"responseStart":1351.8000001907349,"secureConnectionStart":467},{"duration":1401.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":467.09999990463257,"connectEnd":467.09999990463257,"connectStart":467.09999990463257,"domainLookupEnd":467.09999990463257,"domainLookupStart":467.09999990463257,"fetchStart":467.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":467.09999990463257,"responseEnd":1868.5999999046326,"responseStart":1868.5999999046326,"secureConnectionStart":467.09999990463257},{"duration":128.2999997138977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1226.3000001907349,"connectEnd":1226.3000001907349,"connectStart":1226.3000001907349,"domainLookupEnd":1226.3000001907349,"domainLookupStart":1226.3000001907349,"fetchStart":1226.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1226.3000001907349,"responseEnd":1354.5999999046326,"responseStart":1354.5999999046326,"secureConnectionStart":1226.3000001907349},{"duration":413.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1489.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1489.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1903,"responseStart":0,"secureConnectionStart":0},{"duration":385.59999990463257,"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&whisper-enabled=true","startTime":1490.0999999046326,"connectEnd":1490.0999999046326,"connectStart":1490.0999999046326,"domainLookupEnd":1490.0999999046326,"domainLookupStart":1490.0999999046326,"fetchStart":1490.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1490.0999999046326,"responseEnd":1875.6999998092651,"responseStart":1875.6999998092651,"secureConnectionStart":1490.0999999046326},{"duration":391.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1490.5,"connectEnd":1490.5,"connectStart":1490.5,"domainLookupEnd":1490.5,"domainLookupStart":1490.5,"fetchStart":1490.5,"redirectEnd":0,"redirectStart":0,"requestStart":1490.5,"responseEnd":1882.1999998092651,"responseStart":1882.1999998092651,"secureConnectionStart":1490.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":267,"responseStart":454,"responseEnd":459,"domLoading":457,"domInteractive":1945,"domContentLoadedEventStart":1945,"domContentLoadedEventEnd":1991,"domComplete":2287,"loadEventStart":2287,"loadEventEnd":2288,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1910.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1911},{"name":"bigPipe.activity-panel-pipe-id.start","time":1911.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1915},{"name":"activityTabFullyLoaded","time":2010.9000000953674}],"measures":[],"correlationId":"38defdd237ea05","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":124,"dbReadsTimeInMs":20,"dbConnsTimeInMs":30,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
This is a debug-only assertion failure. We do not really need to set the ‘is inside change buffer’ flag in the code that only reads the change buffer state at startup.
At this point of execution, change buffer merge must indeed remain prohibited.
diff --git a/storage/innobase/ibuf/ibuf0ibuf.cc b/storage/innobase/ibuf/ibuf0ibuf.ccindex b4cbe7d4480..d021f8c0085 100644--- a/storage/innobase/ibuf/ibuf0ibuf.cc+++ b/storage/innobase/ibuf/ibuf0ibuf.cc@@ -534,7 +534,6 @@ ibuf_init_at_db_start(void)fseg_n_reserved_pages(header_page + IBUF_HEADER + IBUF_TREE_SEG_HEADER,&n_used, &mtr);- ibuf_enter(&mtr);ut_ad(n_used >= 2);@@ -556,7 +555,7 @@ ibuf_init_at_db_start(void)mutex_exit(&ibuf_mutex);ibuf->empty = page_is_empty(root);- ibuf_mtr_commit(&mtr);+ mtr.commit();ibuf->index = dict_mem_index_create(