Note: I've had this assertion failure during testing for MDEV-11369, and there was a non-deterministic test case. It was assumed to be fixed, and I indeed can't reproduce it anymore with the test case provided in MDEV-11369, but the failure happened on the recent 10.3 at least 3 times: once in travis, once on my machine while I was trying to reproduce, and once on perro while creating a shareable coredump.
10.3 95811f01f34705e
|
mysqld: /data/src/10.3/storage/innobase/include/ut0byte.ic:109: void* ut_align_down(const void*, ulint): Assertion `ptr' failed.
|
180415 5:17:17 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f89c4beeee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000561014e8b12b in ut_align_down (ptr=0x0, align_no=16384) at /data/src/10.3/storage/innobase/include/ut0byte.ic:109
|
#9 0x0000561014eb8b45 in page_align (ptr=0x0) at /data/src/10.3/storage/innobase/include/page0page.h:213
|
#10 0x0000561014ec5d27 in page_rec_check (rec=0x0) at /data/src/10.3/storage/innobase/include/page0page.ic:537
|
#11 0x0000561014ee2c0e in page_rec_is_supremum (rec=0x0) at /data/src/10.3/storage/innobase/include/page0page.ic:296
|
#12 0x000056101511e741 in btr_search_build_page_hash_index (index=0x7f89500b2d28, block=0x7f899fb7e500, ahi_latch=0x561018a56380, n_fields=1, n_bytes=0, left_side=0) at /data/src/10.3/storage/innobase/btr/btr0sea.cc:1445
|
#13 0x000056101511f387 in btr_search_move_or_delete_hash_entries (new_block=0x7f899fb7e500, block=0x7f899fbb3c00) at /data/src/10.3/storage/innobase/btr/btr0sea.cc:1641
|
#14 0x0000561014f793b6 in page_copy_rec_list_start (new_block=0x7f899fb7e500, block=0x7f899fbb3c00, rec=0x7f89a24531e4 "\200", index=0x7f89500b2d28, mtr=0x7f89ad071b50) at /data/src/10.3/storage/innobase/page/page0page.cc:945
|
#15 0x0000561014f7a64e in page_move_rec_list_start (new_block=0x7f899fb7e500, block=0x7f899fbb3c00, split_rec=0x7f89a24531e4 "\200", index=0x7f89500b2d28, mtr=0x7f89ad071b50) at /data/src/10.3/storage/innobase/page/page0page.cc:1403
|
#16 0x00005610150dd960 in btr_page_split_and_insert (flags=0, cursor=0x7f89ad071730, offsets=0x7f89ad0716c8, heap=0x7f89ad0716c0, tuple=0x7f8934148f08, n_ext=0, mtr=0x7f89ad071b50) at /data/src/10.3/storage/innobase/btr/btr0btr.cc:3149
|
#17 0x000056101510077a in btr_cur_pessimistic_insert (flags=0, cursor=0x7f89ad071730, offsets=0x7f89ad0716c8, heap=0x7f89ad0716c0, entry=0x7f8934148f08, rec=0x7f89ad0716d0, big_rec=0x7f89ad0716b8, n_ext=0, thr=0x7f89341768e0, mtr=0x7f89ad071b50) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:3480
|
#18 0x0000561014fd0783 in row_ins_clust_index_entry_low (flags=0, mode=33, index=0x7f89500b2d28, n_uniq=1, entry=0x7f8934148f08, n_ext=0, thr=0x7f89341768e0, dup_chk_only=false) at /data/src/10.3/storage/innobase/row/row0ins.cc:2768
|
#19 0x0000561014fd1f7e in row_ins_clust_index_entry (index=0x7f89500b2d28, entry=0x7f8934148f08, thr=0x7f89341768e0, n_ext=0, dup_chk_only=false) at /data/src/10.3/storage/innobase/row/row0ins.cc:3268
|
#20 0x0000561015056207 in row_upd_clust_rec_by_insert (node=0x7f8934176218, index=0x7f89500b2d28, thr=0x7f89341768e0, referenced=0, foreign=false, mtr=0x7f89ad0726b0) at /data/src/10.3/storage/innobase/row/row0upd.cc:2789
|
#21 0x00005610150576e0 in row_upd_clust_step (node=0x7f8934176218, thr=0x7f89341768e0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3211
|
#22 0x00005610150579ff in row_upd (node=0x7f8934176218, thr=0x7f89341768e0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3282
|
#23 0x0000561015057eee in row_upd_step (thr=0x7f89341768e0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3426
|
#24 0x0000561014ff45d6 in row_update_for_mysql (prebuilt=0x7f8934175698) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1882
|
#25 0x0000561014e9f2e4 in ha_innobase::update_row (this=0x7f8934160188, old_row=0x7f893416edf0 "", new_row=0x7f893416d9a8 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8838
|
#26 0x0000561014b8d1b9 in handler::ha_update_row (this=0x7f8934160188, old_data=0x7f893416edf0 "", new_data=0x7f893416d9a8 "") at /data/src/10.3/sql/handler.cc:6229
|
#27 0x00005610152e8c28 in ha_partition::update_row (this=0x7f893415f0d8, old_data=0x7f893416edf0 "", new_data=0x7f893416d9a8 "") at /data/src/10.3/sql/ha_partition.cc:4364
|
#28 0x0000561014b8d1b9 in handler::ha_update_row (this=0x7f893415f0d8, old_data=0x7f893416edf0 "", new_data=0x7f893416d9a8 "") at /data/src/10.3/sql/handler.cc:6229
|
#29 0x000056101499472f in mysql_update (thd=0x7f8934000b00, table_list=0x7f8934013d10, fields=..., values=..., conds=0x7f8934014b60, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f89ad073720, updated_return=0x7f89ad0737e0) at /data/src/10.3/sql/sql_update.cc:943
|
#30 0x000056101489fd38 in mysql_execute_command (thd=0x7f8934000b00) at /data/src/10.3/sql/sql_parse.cc:4578
|
#31 0x00005610148aaad8 in mysql_parse (thd=0x7f8934000b00, rawbuf=0x7f8934013a28 "UPDATE `view_table100_innodb_key_pk_parts_2_int_autoinc` SET `pk` = REPEAT( _ASCII 0xA, 70 ) WHERE `col_varchar_255_utf8` < REPEAT( _UCS2 0x43, 121 ) /* QNO 2211 CON_ID 20 */", length=175, parser_state=0x7f89ad074620, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001
|
#32 0x00005610148982bb in dispatch_command (command=COM_QUERY, thd=0x7f8934000b00, packet=0x7f893400b261 "UPDATE `view_table100_innodb_key_pk_parts_2_int_autoinc` SET `pk` = REPEAT( _ASCII 0xA, 70 ) WHERE `col_varchar_255_utf8` < REPEAT( _UCS2 0x43, 121 ) /* QNO 2211 CON_ID 20 */ ", packet_length=176, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
|
#33 0x0000561014896cfa in do_command (thd=0x7f8934000b00) at /data/src/10.3/sql/sql_parse.cc:1391
|
#34 0x00005610149f978b in do_handle_one_connection (connect=0x561018df9110) at /data/src/10.3/sql/sql_connect.cc:1402
|
#35 0x00005610149f9518 in handle_one_connection (arg=0x561018df9110) at /data/src/10.3/sql/sql_connect.cc:1308
|
#36 0x00007f89c68c5494 in start_thread (arg=0x7f89ad075700) at pthread_create.c:333
|
#37 0x00007f89c4cab93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
perl ./runall-trials.pl --trials=50 --duration=700 --threads=6 --seed=1523728641 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/data/bld/10.3 --grammar=conf/engines/many_indexes.yy --gendata=conf/engines/many_indexes.zz --engine=InnoDB --vardir=/data/logs/travis1
|
- is caused by
-
MDEV-11369
Instant add column for InnoDB
-
-
Closed
Transition |
Time In Source Status |
Execution Times |
Open |
|
Confirmed |
|
57m 26s
|
1
|
Confirmed |
|
Closed |
|
11h 35m
|
1
|
{"report":{"fcp":885.8000000119209,"ttfb":196.5999999642372,"pageVisibility":"visible","entityId":66851,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"e206e12f-ff0b-4417-972d-318651eeb217","navigationType":0,"readyForUser":968.1999999880791,"redirectCount":0,"resourceLoadedEnd":1192.699999988079,"resourceLoadedStart":202.30000001192093,"resourceTiming":[{"duration":223.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":202.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":425.5999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":223.30000001192093,"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":202.5999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":425.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":234,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":202.80000001192093,"connectEnd":202.80000001192093,"connectStart":202.80000001192093,"domainLookupEnd":202.80000001192093,"domainLookupStart":202.80000001192093,"fetchStart":202.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":202.80000001192093,"responseEnd":436.80000001192093,"responseStart":436.80000001192093,"secureConnectionStart":202.80000001192093},{"duration":278.10000002384186,"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":202.89999997615814,"connectEnd":202.89999997615814,"connectStart":202.89999997615814,"domainLookupEnd":202.89999997615814,"domainLookupStart":202.89999997615814,"fetchStart":202.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":202.89999997615814,"responseEnd":481,"responseStart":481,"secureConnectionStart":202.89999997615814},{"duration":281.5,"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":203.0999999642372,"connectEnd":203.0999999642372,"connectStart":203.0999999642372,"domainLookupEnd":203.0999999642372,"domainLookupStart":203.0999999642372,"fetchStart":203.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":203.0999999642372,"responseEnd":484.5999999642372,"responseStart":484.5999999642372,"secureConnectionStart":203.0999999642372},{"duration":281.5999999642372,"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":203.30000001192093,"connectEnd":203.30000001192093,"connectStart":203.30000001192093,"domainLookupEnd":203.30000001192093,"domainLookupStart":203.30000001192093,"fetchStart":203.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":203.30000001192093,"responseEnd":484.89999997615814,"responseStart":484.89999997615814,"secureConnectionStart":203.30000001192093},{"duration":281.80000001192093,"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":203.5,"connectEnd":203.5,"connectStart":203.5,"domainLookupEnd":203.5,"domainLookupStart":203.5,"fetchStart":203.5,"redirectEnd":0,"redirectStart":0,"requestStart":203.5,"responseEnd":485.30000001192093,"responseStart":485.30000001192093,"secureConnectionStart":203.5},{"duration":371.80000001192093,"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":203.5999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":575.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":282,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":203.69999998807907,"connectEnd":203.69999998807907,"connectStart":203.69999998807907,"domainLookupEnd":203.69999998807907,"domainLookupStart":203.69999998807907,"fetchStart":203.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":203.69999998807907,"responseEnd":485.69999998807907,"responseStart":485.69999998807907,"secureConnectionStart":203.69999998807907},{"duration":371.5,"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":204,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":575.5,"responseStart":0,"secureConnectionStart":0},{"duration":282,"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":204.19999998807907,"connectEnd":204.19999998807907,"connectStart":204.19999998807907,"domainLookupEnd":204.19999998807907,"domainLookupStart":204.19999998807907,"fetchStart":204.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":204.19999998807907,"responseEnd":486.19999998807907,"responseStart":486.19999998807907,"secureConnectionStart":204.19999998807907},{"duration":482.2000000476837,"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":209.5999999642372,"connectEnd":209.5999999642372,"connectStart":209.5999999642372,"domainLookupEnd":209.5999999642372,"domainLookupStart":209.5999999642372,"fetchStart":209.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":209.5999999642372,"responseEnd":691.8000000119209,"responseStart":691.8000000119209,"secureConnectionStart":209.5999999642372},{"duration":983.1000000238419,"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":209.5999999642372,"connectEnd":209.5999999642372,"connectStart":209.5999999642372,"domainLookupEnd":209.5999999642372,"domainLookupStart":209.5999999642372,"fetchStart":209.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":209.5999999642372,"responseEnd":1192.699999988079,"responseStart":1192.699999988079,"secureConnectionStart":209.5999999642372},{"duration":161.69999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":601.8999999761581,"connectEnd":601.8999999761581,"connectStart":601.8999999761581,"domainLookupEnd":601.8999999761581,"domainLookupStart":601.8999999761581,"fetchStart":601.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":601.8999999761581,"responseEnd":763.5999999642372,"responseStart":763.5999999642372,"secureConnectionStart":601.8999999761581},{"duration":406.4000000357628,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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","startTime":840.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":840.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1247.300000011921,"responseStart":0,"secureConnectionStart":0},{"duration":381.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":841.6999999880791,"connectEnd":841.6999999880791,"connectStart":841.6999999880791,"domainLookupEnd":841.6999999880791,"domainLookupStart":841.6999999880791,"fetchStart":841.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":841.6999999880791,"responseEnd":1222.800000011921,"responseStart":1222.800000011921,"secureConnectionStart":841.6999999880791},{"duration":413.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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","startTime":842.0999999642372,"connectEnd":842.0999999642372,"connectStart":842.0999999642372,"domainLookupEnd":842.0999999642372,"domainLookupStart":842.0999999642372,"fetchStart":842.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":842.0999999642372,"responseEnd":1255.800000011921,"responseStart":1255.800000011921,"secureConnectionStart":842.0999999642372}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":8,"responseStart":197,"responseEnd":204,"domLoading":200,"domInteractive":1209,"domContentLoadedEventStart":1209,"domContentLoadedEventEnd":1247,"domComplete":1794,"loadEventStart":1794,"loadEventEnd":1795,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1194.199999988079},{"name":"bigPipe.sidebar-id.end","time":1195},{"name":"bigPipe.activity-panel-pipe-id.start","time":1195.199999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1196},{"name":"activityTabFullyLoaded","time":1261.300000011921}],"measures":[],"correlationId":"7d8f61d0b3a56e","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":123,"dbReadsTimeInMs":18,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}