To reproduce, just start 10.3 or 10.4 with all defaults on a freshly bootstrapped 10.1 or 10.0 datadir:
10.3 8e3d85e1
|
2019-10-12 16:35:18 0 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; LSN=1616717
|
2019-10-12 16:35:18 0 [Note] InnoDB: Starting to delete and rewrite log files.
|
2019-10-12 16:35:18 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
|
2019-10-12 16:35:18 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
|
2019-10-12 16:35:18 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
|
2019-10-12 16:35:18 0 [Note] InnoDB: New log files created, LSN=1616717
|
mysqld: /data/src/10.3/storage/innobase/rem/rem0rec.cc:745: void rec_init_offsets(const rec_t*, const dict_index_t*, bool, ulint*): Assertion `index->is_instant()' failed.
|
191012 16:35:18 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f10e70ddf12 in __GI___assert_fail (assertion=0x5606e33ff04f "index->is_instant()", file=0x5606e33fed70 "/data/src/10.3/storage/innobase/rem/rem0rec.cc", line=745, function=0x5606e3400a20 <rec_init_offsets(unsigned char const*, dict_index_t const*, bool, unsigned long*)::__PRETTY_FUNCTION__> "void rec_init_offsets(const rec_t*, const dict_index_t*, bool, ulint*)") at assert.c:101
|
#8 0x00005606e2c0e5d8 in rec_init_offsets (rec=0x7f10c401008c "", index=0x5606e67798b8, leaf=true, offsets=0x7ffd8f428290) at /data/src/10.3/storage/innobase/rem/rem0rec.cc:745
|
#9 0x00005606e2c0edeb in rec_get_offsets_func (rec=0x7f10c401008c "", index=0x5606e67798b8, offsets=0x7ffd8f428290, leaf=true, n_fields=18446744073709551615, file=0x5606e342de60 "/data/src/10.3/storage/innobase/row/row0sel.cc", line=1802, heap=0x7ffd8f4281f0) at /data/src/10.3/storage/innobase/rem/rem0rec.cc:867
|
#10 0x00005606e2ca7bb6 in row_sel (node=0x5606e6823a98, thr=0x5606e6825cd0) at /data/src/10.3/storage/innobase/row/row0sel.cc:1801
|
#11 0x00005606e2ca90be in row_sel_step (thr=0x5606e6825cd0) at /data/src/10.3/storage/innobase/row/row0sel.cc:2341
|
#12 0x00005606e2bfe215 in que_thr_step (thr=0x5606e6825cd0) at /data/src/10.3/storage/innobase/que/que0que.cc:1013
|
#13 0x00005606e2bfe65b in que_run_threads_low (thr=0x5606e6825cd0) at /data/src/10.3/storage/innobase/que/que0que.cc:1099
|
#14 0x00005606e2bfe8ab in que_run_threads (thr=0x5606e6825cd0) at /data/src/10.3/storage/innobase/que/que0que.cc:1139
|
#15 0x00005606e2bfeb54 in que_eval_sql (info=0x0, sql=0x5606e3412ba0 <row_merge_drop_temp_indexes()::sql> "PROCEDURE DROP_TEMP_INDEXES_PROC () IS\nixid CHAR;\nfound INT;\nDECLARE CURSOR index_cur IS\n SELECT ID FROM SYS_INDEXES\n WHERE SUBSTR(NAME,0,1)='\377'\nFOR UPDATE;\nBEGIN\nfound := 1;\nOPEN index_cur;\nWHILE fou"..., reserve_dict_mutex=0, trx=0x7f10d18de0f0) at /data/src/10.3/storage/innobase/que/que0que.cc:1216
|
#16 0x00005606e2c56bc9 in row_merge_drop_temp_indexes () at /data/src/10.3/storage/innobase/row/row0merge.cc:4065
|
#17 0x00005606e2b9be32 in recv_recovery_rollback_active () at /data/src/10.3/storage/innobase/log/log0recv.cc:3951
|
#18 0x00005606e2cf243f in srv_start (create_new_db=false) at /data/src/10.3/storage/innobase/srv/srv0start.cc:2292
|
#19 0x00005606e2ac80cf in innodb_init (p=0x5606e5c25ce0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4262
|
#20 0x00005606e28a1a77 in ha_initialize_handlerton (plugin=0x5606e5c16b10) at /data/src/10.3/sql/handler.cc:549
|
#21 0x00005606e25a2f59 in plugin_initialize (tmp_root=0x7ffd8f42f4b0, plugin=0x5606e5c16b10, argc=0x5606e3dca370 <remaining_argc>, argv=0x5606e5bb0d78, options_only=false) at /data/src/10.3/sql/sql_plugin.cc:1433
|
#22 0x00005606e25a3ce5 in plugin_init (argc=0x5606e3dca370 <remaining_argc>, argv=0x5606e5bb0d78, flags=2) at /data/src/10.3/sql/sql_plugin.cc:1715
|
#23 0x00005606e245fa8a in init_server_components () at /data/src/10.3/sql/mysqld.cc:5417
|
#24 0x00005606e2460c49 in mysqld_main (argc=11, argv=0x5606e5bb0d78) at /data/src/10.3/sql/mysqld.cc:6024
|
#25 0x00005606e2455220 in main (argc=11, argv=0x7ffd8f42fce8) at /data/src/10.3/sql/main.cc:25
|
Same upon upgrade from 5.5, MySQL 5.6.
It started happening very recently, I assume after this commit:
commit 01f45becd1b71433e240959228e35266f271bba1
|
Author: Marko Mäkelä
|
Date: Thu Oct 10 20:40:26 2019 +0300
|
|
MDEV-19783: Add more assertions
|
although I didn't check to confirm.
An example of a freshly bootstrapped 10.1 datadir is attached as data.tar.gz
.
{"report":{"fcp":1732.8000001907349,"ttfb":210.30000019073486,"pageVisibility":"visible","entityId":79677,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"53330866-1b29-442d-943c-3f67122f9209","navigationType":0,"readyForUser":2002,"redirectCount":0,"resourceLoadedEnd":1402,"resourceLoadedStart":219.5,"resourceTiming":[{"duration":172.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":219.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":392.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":188.40000009536743,"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":219.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":408.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":698.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":220.09999990463257,"connectEnd":410.7000002861023,"connectStart":410.7000002861023,"domainLookupEnd":410.7000002861023,"domainLookupStart":410.7000002861023,"fetchStart":220.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":412.09999990463257,"responseEnd":918.2000002861023,"responseStart":423.40000009536743,"secureConnectionStart":410.7000002861023},{"duration":1181.0999999046326,"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":220.90000009536743,"connectEnd":220.90000009536743,"connectStart":220.90000009536743,"domainLookupEnd":220.90000009536743,"domainLookupStart":220.90000009536743,"fetchStart":220.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":414.7000002861023,"responseEnd":1402,"responseStart":440,"secureConnectionStart":220.90000009536743},{"duration":226.80000019073486,"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":221.09999990463257,"connectEnd":221.09999990463257,"connectStart":221.09999990463257,"domainLookupEnd":221.09999990463257,"domainLookupStart":221.09999990463257,"fetchStart":221.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":416.7000002861023,"responseEnd":447.90000009536743,"responseStart":438.09999990463257,"secureConnectionStart":221.09999990463257},{"duration":237.69999980926514,"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":221.30000019073486,"connectEnd":221.30000019073486,"connectStart":221.30000019073486,"domainLookupEnd":221.30000019073486,"domainLookupStart":221.30000019073486,"fetchStart":221.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":417.30000019073486,"responseEnd":459,"responseStart":440.7000002861023,"secureConnectionStart":221.30000019073486},{"duration":238.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":221.5,"connectEnd":221.5,"connectStart":221.5,"domainLookupEnd":221.5,"domainLookupStart":221.5,"fetchStart":221.5,"redirectEnd":0,"redirectStart":0,"requestStart":417.5,"responseEnd":459.80000019073486,"responseStart":453.80000019073486,"secureConnectionStart":221.5},{"duration":190.80000019073486,"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":221.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":221.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":412.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":238.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":221.80000019073486,"connectEnd":221.80000019073486,"connectStart":221.80000019073486,"domainLookupEnd":221.80000019073486,"domainLookupStart":221.80000019073486,"fetchStart":221.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":417.7000002861023,"responseEnd":460.09999990463257,"responseStart":454.80000019073486,"secureConnectionStart":221.80000019073486},{"duration":190.5,"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":222,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":222,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":412.5,"responseStart":0,"secureConnectionStart":0},{"duration":253.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":222.09999990463257,"connectEnd":222.09999990463257,"connectStart":222.09999990463257,"domainLookupEnd":222.09999990463257,"domainLookupStart":222.09999990463257,"fetchStart":222.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":417.80000019073486,"responseEnd":475.90000009536743,"responseStart":460.5,"secureConnectionStart":222.09999990463257},{"duration":1020.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":224.40000009536743,"connectEnd":224.40000009536743,"connectStart":224.40000009536743,"domainLookupEnd":224.40000009536743,"domainLookupStart":224.40000009536743,"fetchStart":224.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":512.2000002861023,"responseEnd":1244.8000001907349,"responseStart":1237.7000002861023,"secureConnectionStart":224.40000009536743},{"duration":1174.4000000953674,"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":224.5,"connectEnd":224.5,"connectStart":224.5,"domainLookupEnd":224.5,"domainLookupStart":224.5,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":569.0999999046326,"responseEnd":1398.9000000953674,"responseStart":1245.2000002861023,"secureConnectionStart":224.5},{"duration":365.7999997138977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1080.7000002861023,"connectEnd":1080.7000002861023,"connectStart":1080.7000002861023,"domainLookupEnd":1080.7000002861023,"domainLookupStart":1080.7000002861023,"fetchStart":1080.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1239,"responseEnd":1446.5,"responseStart":1441.5999999046326,"secureConnectionStart":1080.7000002861023},{"duration":534.2000002861023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1651.0999999046326,"connectEnd":1651.0999999046326,"connectStart":1651.0999999046326,"domainLookupEnd":1651.0999999046326,"domainLookupStart":1651.0999999046326,"fetchStart":1651.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":2153.300000190735,"responseEnd":2185.300000190735,"responseStart":2184.5999999046326,"secureConnectionStart":1651.0999999046326},{"duration":529.2999997138977,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1708.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1708.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2238.0999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":45,"responseStart":210,"responseEnd":221,"domLoading":214,"domInteractive":2170,"domContentLoadedEventStart":2171,"domContentLoadedEventEnd":2238,"domComplete":2727,"loadEventStart":2727,"loadEventEnd":2728,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2120.800000190735},{"name":"bigPipe.sidebar-id.end","time":2121.800000190735},{"name":"bigPipe.activity-panel-pipe-id.start","time":2122},{"name":"bigPipe.activity-panel-pipe-id.end","time":2122.9000000953674},{"name":"activityTabFullyLoaded","time":2261.2000002861023}],"measures":[],"correlationId":"fa384048e4a0db","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":87,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The assertion that validated records of ROW_FORMAT=REDUNDANT tables would fail for accessing the SYS_INDEXES table. The column MERGE_THRESHOLD was instantly added in MySQL 5.7 and MariaDB 10.2 to that table, but is_instant() does not hold for the clustered index of that table. The assertion was relaxed.