10.0/sql/sql_class.cc:4088: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
|
151117 21:41:17 [ERROR] mysqld got signal 6 ;
|
|
Stack trace from 10.0 commit 4008a3e55bda76fab622de163b174008d2d58abb
|
#6 0x00007efe3bf22311 in *__GI___assert_fail (assertion=0xf08270 "thd->stmt_arena != thd->progress.arena", file=<optimized out>, line=4088, function=0xf09ee0 "void thd_progress_init(THD*, uint)") at assert.c:81
|
#7 0x0000000000649b98 in thd_progress_init (thd=0x7efe236f9070, max_stage=3) at 10.0/sql/sql_class.cc:4088
|
#8 0x0000000000b00cdc in row_merge_sort (trx=0x7efe234ccb78, dup=0x7efe120b00c0, file=0x7efe234df8f8, block=0x7efe11006000 "\002\033aamzgmngfrmdthtdmdhlxkovjdz", tmpfd=0x7efe0cffedc4) at 10.0/storage/xtradb/row/row0merge.cc:2339
|
#9 0x0000000000adb4ba in fts_parallel_tokenization (arg=0x7efe3b494878) at 10.0/storage/xtradb/row/row0ftsort.cc:854
|
#10 0x00007efe3dd1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#11 0x00007efe3bfd295d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
10.1 also fails, but differently, see MDEV-9129 (10.1 fails both on debug and release builds, while 10.0 only fails on release).
To reproduce, download and unpack ftp://ftp.askmonty.org/public/MDEV-9129_data.gz
create table t1 (groups varchar(255) DEFAULT NULL) ENGINE=InnoDB;
|
load data local infile 't1.data' into table t1;
|
ALTER TABLE t1 ADD FULLTEXT ft_qu_la_contacts_groups (groups);
|
Default server settings are enough.
{"report":{"fcp":747.8999998569489,"ttfb":146.89999985694885,"pageVisibility":"visible","entityId":54227,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"7b19111e-43e3-41c7-8d2b-83b0be473b45","navigationType":0,"readyForUser":811.6999998092651,"redirectCount":0,"resourceLoadedEnd":736.8999998569489,"resourceLoadedStart":152.09999990463257,"resourceTiming":[{"duration":162,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":152.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":314.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":161.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":152.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":314.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":171.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":152.39999985694885,"connectEnd":152.39999985694885,"connectStart":152.39999985694885,"domainLookupEnd":152.39999985694885,"domainLookupStart":152.39999985694885,"fetchStart":152.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":152.39999985694885,"responseEnd":324.19999980926514,"responseStart":324.19999980926514,"secureConnectionStart":152.39999985694885},{"duration":243.5,"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":152.5,"connectEnd":152.5,"connectStart":152.5,"domainLookupEnd":152.5,"domainLookupStart":152.5,"fetchStart":152.5,"redirectEnd":0,"redirectStart":0,"requestStart":152.5,"responseEnd":396,"responseStart":396,"secureConnectionStart":152.5},{"duration":247.09999990463257,"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":152.59999990463257,"connectEnd":152.59999990463257,"connectStart":152.59999990463257,"domainLookupEnd":152.59999990463257,"domainLookupStart":152.59999990463257,"fetchStart":152.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":152.59999990463257,"responseEnd":399.69999980926514,"responseStart":399.69999980926514,"secureConnectionStart":152.59999990463257},{"duration":247.5,"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":152.59999990463257,"connectEnd":152.59999990463257,"connectStart":152.59999990463257,"domainLookupEnd":152.59999990463257,"domainLookupStart":152.59999990463257,"fetchStart":152.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":152.59999990463257,"responseEnd":400.09999990463257,"responseStart":400.09999990463257,"secureConnectionStart":152.59999990463257},{"duration":247.70000004768372,"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":152.79999995231628,"connectEnd":152.79999995231628,"connectStart":152.79999995231628,"domainLookupEnd":152.79999995231628,"domainLookupStart":152.79999995231628,"fetchStart":152.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":152.79999995231628,"responseEnd":400.5,"responseStart":400.5,"secureConnectionStart":152.79999995231628},{"duration":248,"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":152.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":400.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":247.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":153,"connectEnd":153,"connectStart":153,"domainLookupEnd":153,"domainLookupStart":153,"fetchStart":153,"redirectEnd":0,"redirectStart":0,"requestStart":153,"responseEnd":400.7999999523163,"responseStart":400.7999999523163,"secureConnectionStart":153},{"duration":248.09999990463257,"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":153.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":401.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":248.10000014305115,"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":153.19999980926514,"connectEnd":153.19999980926514,"connectStart":153.19999980926514,"domainLookupEnd":153.19999980926514,"domainLookupStart":153.19999980926514,"fetchStart":153.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":153.19999980926514,"responseEnd":401.2999999523163,"responseStart":401.2999999523163,"secureConnectionStart":153.19999980926514},{"duration":555.6999998092651,"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":154,"connectEnd":154,"connectStart":154,"domainLookupEnd":154,"domainLookupStart":154,"fetchStart":154,"redirectEnd":0,"redirectStart":0,"requestStart":154,"responseEnd":709.6999998092651,"responseStart":709.6999998092651,"secureConnectionStart":154},{"duration":582.7999999523163,"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":154.09999990463257,"connectEnd":154.09999990463257,"connectStart":154.09999990463257,"domainLookupEnd":154.09999990463257,"domainLookupStart":154.09999990463257,"fetchStart":154.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":154.09999990463257,"responseEnd":736.8999998569489,"responseStart":736.8999998569489,"secureConnectionStart":154.09999990463257},{"duration":196.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":539.6999998092651,"connectEnd":539.6999998092651,"connectStart":539.6999998092651,"domainLookupEnd":539.6999998092651,"domainLookupStart":539.6999998092651,"fetchStart":539.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":539.6999998092651,"responseEnd":736.5999999046326,"responseStart":736.5999999046326,"secureConnectionStart":539.6999998092651},{"duration":66,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":726.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":726.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":792.2999999523163,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":17,"responseStart":147,"responseEnd":149,"domLoading":150,"domInteractive":906,"domContentLoadedEventStart":906,"domContentLoadedEventEnd":945,"domComplete":1198,"loadEventStart":1198,"loadEventEnd":1199,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":887.6999998092651},{"name":"bigPipe.sidebar-id.end","time":888.3999998569489},{"name":"bigPipe.activity-panel-pipe-id.start","time":888.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":889.3999998569489},{"name":"activityTabFullyLoaded","time":961.3999998569489}],"measures":[],"correlationId":"4ca28fc74cd94b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":77,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
commit 311f0308d04f3a55ad18470ca39e9d44479c4782
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Thu Dec 10 16:41:46 2015 +0200
MDEV-9148: Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_initCalled thd_progress_init() from several threads used for FT-index
creation. For FT-indexes, need better way to report progress,
remove current one for them.