Also filed for percona-server as https://bugs.launchpad.net/percona-server/+bug/1017192
#3 <signal handler called>
|
#4 0x000000000069b900 in add_identifier (thd=0x3b8ab70, to_p=0x7f79b461afd9 "\260a\264y\177", end_p=0x7f79b461b0b0 "#sql-7de_2#P#p0", name=0x7f79b461b0bd "p0", name_len=4294967293) at sql/sql_table.cc:96
|
#5 0x000000000069c55f in explain_filename (thd=0x3b8ab70, from=0x7f79b461b0b0 "#sql-7de_2#P#p0", to=0x7f79b461afb0 "`#sql-7de_2#P#p0` /* Temporary Partition \260a\264y\177", to_length=256, explain_mode=EXPLAIN_PARTITIONS_AS_COMMENT) at sql/sql_table.cc:348
|
#6 0x0000000000a10e6f in innobase_convert_identifier (buf=0x7f79b461b267 "`t1` /* P", buflen=569, id=0x3ca6ad5 "#sql-7de_2#P#p0", idlen=15, thd=0x3b8ab70, file_id=1) at storage/xtradb/handler/ha_innodb.cc:2204
|
#7 0x0000000000a111a3 in innobase_convert_name (buf=0x7f79b461b260 "`test`.`t1` /* P", buflen=576, id=0x3ca6ad0 "test/#sql-7de_2#P#p0", idlen=20, thd=0x3b8ab70, table_id=1) at storage/xtradb/handler/ha_innodb.cc:2290
|
#8 0x0000000000aa8984 in ut_print_namel (f=0x37fd600, trx=0x3cd49b8, table_id=1, name=0x3ca6ad0 "test/#sql-7de_2#P#p0", namelen=20) at storage/xtradb/ut/ut0ut.c:544
|
#9 0x0000000000aa88fa in ut_print_name (f=0x37fd600, trx=0x3cd49b8, table_id=1, name=0x3ca6ad0 "test/#sql-7de_2#P#p0") at storage/xtradb/ut/ut0ut.c:520
|
#10 0x0000000000b73dfe in lock_table_print (file=0x37fd600, lock=0x3cccd48) at storage/xtradb/lock/lock0lock.c:4319
|
#11 0x0000000000b74c24 in lock_print_info_all_transactions (file=0x37fd600) at storage/xtradb/lock/lock0lock.c:4680
|
#12 0x0000000000a6e82d in srv_printf_innodb_monitor (file=0x37fd600, nowait=0, trx_start=0x7f79b461bc40, trx_end=0x7f79b461bc48) at storage/xtradb/srv/srv0srv.c:2246
|
#13 0x0000000000a202ea in innodb_show_status (hton=0x2ecbbc0, thd=0x3ca7c30, stat_print=0x7c89d6 <stat_print(THD*, char const*, uint, char const*, uint, char const*, uint)>) at storage/xtradb/handler/ha_innodb.cc:10494
|
#14 0x0000000000a20e1e in innobase_show_status (hton=0x2ecbbc0, thd=0x3ca7c30, stat_print=0x7c89d6 <stat_print(THD*, char const*, uint, char const*, uint, char const*, uint)>, stat_type=HA_ENGINE_STATUS) at storage/xtradb/handler/ha_innodb.cc:10734
|
#15 0x00000000007c8d38 in ha_show_status (thd=0x3ca7c30, db_type=0x2ecbbc0, stat=HA_ENGINE_STATUS) at sql/handler.cc:4793
|
#16 0x000000000060d128 in mysql_execute_command (thd=0x3ca7c30) at sql/sql_parse.cc:2364
|
#17 0x00000000006166fd in mysql_parse (thd=0x3ca7c30, rawbuf=0x3cb5248 "SHOW ENGINE INNODB STATUS", length=25, parser_state=0x7f79b461c500) at sql/sql_parse.cc:5736
|
#18 0x0000000000609f73 in dispatch_command (command=COM_QUERY, thd=0x3ca7c30, packet=0x3cacb21 "", packet_length=25) at sql/sql_parse.cc:1055
|
#19 0x000000000060922a in do_command (thd=0x3ca7c30) at sql/sql_parse.cc:794
|
#20 0x000000000070a4ef in do_handle_one_connection (thd_arg=0x3ca7c30) at sql/sql_connect.cc:1253
|
#21 0x0000000000709eda in handle_one_connection (arg=0x3ca7c30) at sql/sql_connect.cc:1168
|
#22 0x0000000000bffb0f in pfs_spawn_thread (arg=0x3de9940) at storage/perfschema/pfs.cc:1015
|
#23 0x00007f79c5f22efc in start_thread (arg=0x7f79b461d700) at pthread_create.c:304
|
#24 0x00007f79c529559d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
bzr version-info
|
revision-id: knielsen@knielsen-hq.org-20120622084255-u53u21xv3w7sqxms
|
date: 2012-06-22 10:42:55 +0200
|
build-date: 2012-06-24 20:32:59 +0400
|
revno: 3456
|
Also reproducible on 5.5.25 release binaries. Could not reproduce on 5.5.24 or on 5.3.
MTR test case:
|
--source include/have_partition.inc
|
--source include/have_xtradb.inc
|
|
CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (1),(2),(3),(4);
|
|
--connect (con1,localhost,root,,)
|
--let $run = 100
|
|
while ($run)
|
{
|
--connection default
|
--send ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4
|
--connection con1
|
--let $show = 300
|
while ($show)
|
{
|
SHOW ENGINE INNODB STATUS;
|
--dec $show
|
}
|
--connection default
|
--reap
|
--dec $run
|
}
|
|
DROP TABLE t1;
|
|
If the MTR test case does not work, try the RQG grammar:
query_init:
|
CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB
|
; INSERT INTO t1 VALUES (1),(2),(3),(4);
|
|
thread1:
|
SHOW ENGINE INNODB STATUS;
|
|
query:
|
ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4 ;
|
|
Run it as
perl ./runall.pl \
|
--threads=2 \
|
--queries=100M \
|
--duration=300 \
|
--skip-gendata \
|
--grammar=1.yy \
|
--basedir=<your basedir>
|
{"report":{"fcp":1114.9000000953674,"ttfb":313.30000019073486,"pageVisibility":"visible","entityId":12212,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"168106d8-5a25-4260-8b25-15222c0ad698","navigationType":0,"readyForUser":1201.5,"redirectCount":0,"resourceLoadedEnd":1237.2000002861023,"resourceLoadedStart":319.40000009536743,"resourceTiming":[{"duration":218.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":319.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":319.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":538.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":218.7999997138977,"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":319.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":319.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":538.5,"responseStart":0,"secureConnectionStart":0},{"duration":227.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":319.90000009536743,"connectEnd":319.90000009536743,"connectStart":319.90000009536743,"domainLookupEnd":319.90000009536743,"domainLookupStart":319.90000009536743,"fetchStart":319.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":319.90000009536743,"responseEnd":547.8000001907349,"responseStart":547.8000001907349,"secureConnectionStart":319.90000009536743},{"duration":290.59999990463257,"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":320,"connectEnd":320,"connectStart":320,"domainLookupEnd":320,"domainLookupStart":320,"fetchStart":320,"redirectEnd":0,"redirectStart":0,"requestStart":320,"responseEnd":610.5999999046326,"responseStart":610.5999999046326,"secureConnectionStart":320},{"duration":294.3999996185303,"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":320.2000002861023,"connectEnd":320.2000002861023,"connectStart":320.2000002861023,"domainLookupEnd":320.2000002861023,"domainLookupStart":320.2000002861023,"fetchStart":320.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":320.2000002861023,"responseEnd":614.5999999046326,"responseStart":614.5999999046326,"secureConnectionStart":320.2000002861023},{"duration":294.80000019073486,"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":320.5,"connectEnd":320.5,"connectStart":320.5,"domainLookupEnd":320.5,"domainLookupStart":320.5,"fetchStart":320.5,"redirectEnd":0,"redirectStart":0,"requestStart":320.5,"responseEnd":615.3000001907349,"responseStart":615.3000001907349,"secureConnectionStart":320.5},{"duration":295.3999996185303,"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":320.7000002861023,"connectEnd":320.7000002861023,"connectStart":320.7000002861023,"domainLookupEnd":320.7000002861023,"domainLookupStart":320.7000002861023,"fetchStart":320.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":320.7000002861023,"responseEnd":616.0999999046326,"responseStart":616.0999999046326,"secureConnectionStart":320.7000002861023},{"duration":378.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":320.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":320.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":699.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":296,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":321,"connectEnd":321,"connectStart":321,"domainLookupEnd":321,"domainLookupStart":321,"fetchStart":321,"redirectEnd":0,"redirectStart":0,"requestStart":321,"responseEnd":617,"responseStart":617,"secureConnectionStart":321},{"duration":378.69999980926514,"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":321.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":321.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":699.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":296.5,"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":321.40000009536743,"connectEnd":321.40000009536743,"connectStart":321.40000009536743,"domainLookupEnd":321.40000009536743,"domainLookupStart":321.40000009536743,"fetchStart":321.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":321.40000009536743,"responseEnd":617.9000000953674,"responseStart":617.9000000953674,"secureConnectionStart":321.40000009536743},{"duration":435.7999997138977,"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":322.2000002861023,"connectEnd":322.2000002861023,"connectStart":322.2000002861023,"domainLookupEnd":322.2000002861023,"domainLookupStart":322.2000002861023,"fetchStart":322.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":322.2000002861023,"responseEnd":758,"responseStart":758,"secureConnectionStart":322.2000002861023},{"duration":532.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":322.30000019073486,"connectEnd":322.30000019073486,"connectStart":322.30000019073486,"domainLookupEnd":322.30000019073486,"domainLookupStart":322.30000019073486,"fetchStart":322.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":322.30000019073486,"responseEnd":854.7000002861023,"responseStart":854.7000002861023,"secureConnectionStart":322.30000019073486},{"duration":93.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":724.0999999046326,"connectEnd":724.0999999046326,"connectStart":724.0999999046326,"domainLookupEnd":724.0999999046326,"domainLookupStart":724.0999999046326,"fetchStart":724.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":724.0999999046326,"responseEnd":818,"responseStart":818,"secureConnectionStart":724.0999999046326},{"duration":211.7000002861023,"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":1025.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1025.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1237.2000002861023,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":150,"responseStart":313,"responseEnd":317,"domLoading":317,"domInteractive":1275,"domContentLoadedEventStart":1276,"domContentLoadedEventEnd":1328,"domComplete":1791,"loadEventStart":1791,"loadEventEnd":1792,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1245.7000002861023},{"name":"bigPipe.sidebar-id.end","time":1246.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1246.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1248.4000000953674},{"name":"activityTabFullyLoaded","time":1357.5}],"measures":[],"correlationId":"69eb87f8610782","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":94,"dbReadsTimeInMs":10,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Patch proposal:
http://pastebin.com/BXdazYud
I didn't find a way to simplify the test case.