Start server with --innodb_use_fallocate=ON.
Do anything, e.g. create table t1 (i int).
InnoDB: Assertion failure in thread 140385167947520 in file sync0sync.ic line 166
|
InnoDB: Failing assertion: mutex_own(mutex)
|
#5 0x00007fadf61ac6f0 in *__GI_abort () at abort.c:92
|
#6 0x0000000000d86b7b in mutex_exit_func (mutex=0x7fadf582e678) at 10.0/storage/xtradb/include/sync0sync.ic:166
|
#7 0x0000000000d86d87 in pfs_mutex_exit_func (mutex=0x7fadf582e678) at 10.0/storage/xtradb/include/sync0sync.ic:475
|
#8 0x0000000000d9100c in fil_extend_space_to_desired_size (actual_size=0x7fadf810e1a8, space_id=4, size_after_extend=6) at 10.0/storage/xtradb/fil/fil0fil.cc:4941
|
#9 0x0000000000d98532 in fsp_try_extend_data_file_with_pages (space=4, page_no=5, header=0x7fade0980026 "", mtr=0x7fadf810e540) at 10.0/storage/xtradb/fsp/fsp0fsp.cc:914
|
#10 0x0000000000d9c5a6 in fsp_reserve_free_pages (space=4, space_header=0x7fade0980026 "", size=4, mtr=0x7fadf810e540) at 10.0/storage/xtradb/fsp/fsp0fsp.cc:2712
|
#11 0x0000000000d9c6d7 in fsp_reserve_free_extents (n_reserved=0x7fadf810e328, space=4, n_ext=2, alloc_type=1000000, mtr=0x7fadf810e540) at 10.0/storage/xtradb/fsp/fsp0fsp.cc:2781
|
#12 0x0000000000d9aeb1 in fseg_create_general (space=4, page=3, byte_offset=74, has_done_reservation=0, mtr=0x7fadf810e540) at 10.0/storage/xtradb/fsp/fsp0fsp.cc:2079
|
#13 0x0000000000d9b200 in fseg_create (space=4, page=3, byte_offset=74, mtr=0x7fadf810e540) at 10.0/storage/xtradb/fsp/fsp0fsp.cc:2167
|
#14 0x0000000000cf8d53 in btr_create (type=1, space=4, zip_size=0, index_id=20, index=0x7fadc98a4278, mtr=0x7fadf810e540) at 10.0/storage/xtradb/btr/btr0btr.cc:1628
|
#15 0x0000000000d559e5 in dict_create_index_tree_step (node=0x7fadc98a3af8) at 10.0/storage/xtradb/dict/dict0crea.cc:693
|
#16 0x0000000000d56851 in dict_create_index_step (thr=0x7fadc98d0780) at 10.0/storage/xtradb/dict/dict0crea.cc:1192
|
#17 0x0000000000c1b944 in que_thr_step (thr=0x7fadc98d0780) at 10.0/storage/xtradb/que/que0que.cc:1125
|
#18 0x0000000000c1bac2 in que_run_threads_low (thr=0x7fadc98d0780) at 10.0/storage/xtradb/que/que0que.cc:1177
|
#19 0x0000000000c1bc54 in que_run_threads (thr=0x7fadc98d0780) at 10.0/storage/xtradb/que/que0que.cc:1218
|
#20 0x0000000000c5d250 in row_create_index_for_mysql (index=0x7fadc98a35f8, trx=0x7fadc98cfa78, field_lengths=0x0) at 10.0/storage/xtradb/row/row0mysql.cc:2447
|
#21 0x0000000000b6e5ee in create_clustered_index_when_no_primary (trx=0x7fadc98cfa78, flags=1, table_name=0x7fadf810ec80 "test/t1") at 10.0/storage/xtradb/handler/ha_innodb.cc:9708
|
#22 0x0000000000b6f864 in ha_innobase::create (this=0x7fadc98c6088, name=0x7fadf8111880 "./test/t1", form=0x7fadf810fb90, create_info=0x7fadf8111cb0) at 10.0/storage/xtradb/handler/ha_innodb.cc:10412
|
#23 0x00000000008639ce in handler::ha_create (this=0x7fadc98c6088, name=0x7fadf8111880 "./test/t1", form=0x7fadf810fb90, info=0x7fadf8111cb0) at 10.0/sql/handler.cc:4244
|
#24 0x00000000008648ab in ha_create_table (thd=0x7fadd7fbc070, path=0x7fadf8111880 "./test/t1", db=0x7fadc9813738 "test", table_name=0x7fadc9813128 "t1", create_info=0x7fadf8111cb0, frm=0x7fadf8111a90) at 10.0/sql/handler.cc:4613
|
#25 0x0000000000760856 in rea_create_table (thd=0x7fadd7fbc070, frm=0x7fadf8111a90, path=0x7fadf8111880 "./test/t1", db=0x7fadc9813738 "test", table_name=0x7fadc9813128 "t1", create_info=0x7fadf8111cb0, file=0x7fadc987d088, no_ha_create_table=false) at 10.0/sql/unireg.cc:409
|
#26 0x000000000071dd0b in create_table_impl (thd=0x7fadd7fbc070, db=0x7fadc9813738 "test", table_name=0x7fadc9813128 "t1", path=0x7fadf8111880 "./test/t1", create_info=0x7fadf8111cb0, alter_info=0x7fadf8111c20, create_table_mode=0, is_trans=0x7fadf8111b2f, key_info=0x7fadf8111aa8, key_count=0x7fadf8111aa4, frm=0x7fadf8111a90) at 10.0/sql/sql_table.cc:4706
|
#27 0x000000000071e1db in mysql_create_table_no_lock (thd=0x7fadd7fbc070, db=0x7fadc9813738 "test", table_name=0x7fadc9813128 "t1", create_info=0x7fadf8111cb0, alter_info=0x7fadf8111c20, is_trans=0x7fadf8111b2f, create_table_mode=0) at 10.0/sql/sql_table.cc:4817
|
#28 0x000000000071e3cc in mysql_create_table (thd=0x7fadd7fbc070, create_table=0x7fadc9813160, create_info=0x7fadf8111cb0, alter_info=0x7fadf8111c20) at 10.0/sql/sql_table.cc:4870
|
#29 0x0000000000673c45 in mysql_execute_command (thd=0x7fadd7fbc070) at 10.0/sql/sql_parse.cc:3055
|
#30 0x000000000067cf1f in mysql_parse (thd=0x7fadd7fbc070, rawbuf=0x7fadc9813088 "create table t1 (i int)", length=23, parser_state=0x7fadf8112610) at 10.0/sql/sql_parse.cc:6447
|
#31 0x000000000066fcec in dispatch_command (command=COM_QUERY, thd=0x7fadd7fbc070, packet=0x7fadd82a2071 "create table t1 (i int)", packet_length=23) at 10.0/sql/sql_parse.cc:1308
|
#32 0x000000000066f08e in do_command (thd=0x7fadd7fbc070) at 10.0/sql/sql_parse.cc:1005
|
#33 0x0000000000788ed6 in do_handle_one_connection (thd_arg=0x7fadd7fbc070) at 10.0/sql/sql_connect.cc:1379
|
#34 0x0000000000788c29 in handle_one_connection (arg=0x7fadd7fbc070) at 10.0/sql/sql_connect.cc:1293
|
#35 0x0000000000a2da80 in pfs_spawn_thread (arg=0x7fadd1296170) at 10.0/storage/perfschema/pfs.cc:1853
|
#36 0x00007fadf7d46b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#37 0x00007fadf6251a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
revision-id: elenst@wheezy-64.home-20140315125635-4mv83huc3dntadur
|
date: 2014-03-15 16:56:35 +0400
|
build-date: 2014-03-17 13:20:44 +0400
|
revno: 4055
|
branch-nick: 10.0
|
- relates to
-
MDEV-5746
Slow file extend when innodb_use_fallocate=1 and SSD file storage
-
-
Closed
{"report":{"fcp":992.7000000476837,"ttfb":218.60000014305115,"pageVisibility":"visible","entityId":33102,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"25aac67f-a00f-4b6e-aabf-34c53711576f","navigationType":0,"readyForUser":1058.9000000953674,"redirectCount":0,"resourceLoadedEnd":1647,"resourceLoadedStart":226.60000014305115,"resourceTiming":[{"duration":182.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":226.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":226.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":408.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":182.39999985694885,"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":226.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":226.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":409.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":241.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":227.10000014305115,"connectEnd":227.10000014305115,"connectStart":227.10000014305115,"domainLookupEnd":227.10000014305115,"domainLookupStart":227.10000014305115,"fetchStart":227.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":227.10000014305115,"responseEnd":468.5,"responseStart":468.5,"secureConnectionStart":227.10000014305115},{"duration":314.2000000476837,"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":227.29999995231628,"connectEnd":227.29999995231628,"connectStart":227.29999995231628,"domainLookupEnd":227.29999995231628,"domainLookupStart":227.29999995231628,"fetchStart":227.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":227.29999995231628,"responseEnd":541.5,"responseStart":541.5,"secureConnectionStart":227.29999995231628},{"duration":317.10000014305115,"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":227.5,"connectEnd":227.5,"connectStart":227.5,"domainLookupEnd":227.5,"domainLookupStart":227.5,"fetchStart":227.5,"redirectEnd":0,"redirectStart":0,"requestStart":227.5,"responseEnd":544.6000001430511,"responseStart":544.6000001430511,"secureConnectionStart":227.5},{"duration":317.40000009536743,"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":227.70000004768372,"connectEnd":227.70000004768372,"connectStart":227.70000004768372,"domainLookupEnd":227.70000004768372,"domainLookupStart":227.70000004768372,"fetchStart":227.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":227.70000004768372,"responseEnd":545.1000001430511,"responseStart":545.1000001430511,"secureConnectionStart":227.70000004768372},{"duration":317.7000000476837,"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":227.90000009536743,"connectEnd":227.90000009536743,"connectStart":227.90000009536743,"domainLookupEnd":227.90000009536743,"domainLookupStart":227.90000009536743,"fetchStart":227.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":227.90000009536743,"responseEnd":545.6000001430511,"responseStart":545.5,"secureConnectionStart":227.90000009536743},{"duration":385.60000014305115,"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":228,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":613.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":317.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":228.29999995231628,"connectEnd":228.29999995231628,"connectStart":228.29999995231628,"domainLookupEnd":228.29999995231628,"domainLookupStart":228.29999995231628,"fetchStart":228.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":228.29999995231628,"responseEnd":546,"responseStart":546,"secureConnectionStart":228.29999995231628},{"duration":385.2999999523163,"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":228.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":613.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":317.89999985694885,"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":228.60000014305115,"connectEnd":228.60000014305115,"connectStart":228.60000014305115,"domainLookupEnd":228.60000014305115,"domainLookupStart":228.60000014305115,"fetchStart":228.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":228.60000014305115,"responseEnd":546.5,"responseStart":546.5,"secureConnectionStart":228.60000014305115},{"duration":528.9000000953674,"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":233.5,"connectEnd":233.5,"connectStart":233.5,"domainLookupEnd":233.5,"domainLookupStart":233.5,"fetchStart":233.5,"redirectEnd":0,"redirectStart":0,"requestStart":233.5,"responseEnd":762.4000000953674,"responseStart":762.2999999523163,"secureConnectionStart":233.5},{"duration":1413.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":233.5,"connectEnd":233.5,"connectStart":233.5,"domainLookupEnd":233.5,"domainLookupStart":233.5,"fetchStart":233.5,"redirectEnd":0,"redirectStart":0,"requestStart":233.5,"responseEnd":1647,"responseStart":1647,"secureConnectionStart":233.5},{"duration":153.79999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":628.5,"connectEnd":628.5,"connectStart":628.5,"domainLookupEnd":628.5,"domainLookupStart":628.5,"fetchStart":628.5,"redirectEnd":0,"redirectStart":0,"requestStart":628.5,"responseEnd":782.2999999523163,"responseStart":782.2999999523163,"secureConnectionStart":628.5},{"duration":768.7999999523163,"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":907.5,"connectEnd":907.5,"connectStart":907.5,"domainLookupEnd":907.5,"domainLookupStart":907.5,"fetchStart":907.5,"redirectEnd":0,"redirectStart":0,"requestStart":907.5,"responseEnd":1676.2999999523163,"responseStart":1676.2999999523163,"secureConnectionStart":907.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":39,"responseStart":218,"responseEnd":232,"domLoading":222,"domInteractive":1666,"domContentLoadedEventStart":1666,"domContentLoadedEventEnd":1708,"domComplete":3054,"loadEventStart":3055,"loadEventEnd":3055,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1648.7999999523163},{"name":"bigPipe.sidebar-id.end","time":1649.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1649.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1650.6000001430511},{"name":"activityTabFullyLoaded","time":1723.4000000953674}],"measures":[],"correlationId":"604e86f18f92bc","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":100,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
revno: 4061
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 10.0-win
timestamp: Mon 2014-03-17 15:49:41 +0200
message:
MDEV-5878: Failing assertion: mutex_own(mutex) with innodb_use_fallocate=ON.Analysis: This was merge error on file fil0fil.cc. fil_system mutex was taken twice because of this.
Fix: Remove unnecessary mutex_enter and fixed the issue with slow posix_fallocate usage.