--source include/have_innodb.inc
|
CREATE TABLE t5 (i1 int, v1 varchar(1), KEY v1 (v1,i1), FULLTEXT KEY v1_2 (v1)) ENGINE=InnoDB ;
|
ALTER TABLE t5 ADD FOREIGN KEY x (v1) REFERENCES t5 (vcol2) ;
|
10.4 f545e3cfa9fcc6b706a6e0ee6f2af2124e514e18
|
10.4/storage/innobase/row/row0mysql.cc:3481: dberr_t row_drop_table_for_mysql(const char*, trx_t*, enum_sql_command, bool, bool): Assertion `lock_trx_has_sys_table_locks(trx) == 0' failed.
|
181012 11:06:31 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.0-MariaDB-debug-log
|
linux/raise.c:54(__GI_raise)[0x7fad04548428]
|
stdlib/abort.c:91(__GI_abort)[0x7fad0454a02a]
|
assert/assert.c:92(__assert_fail_base)[0x7fad04540bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fad04540c82]
|
row/row0mysql.cc:3484(row_drop_table_for_mysql(char const*, trx_t*, enum_sql_command, bool, bool))[0x555c100c01d6]
|
row/row0mysql.cc:2693(row_table_add_foreign_constraints(trx_t*, char const*, unsigned long, char const*, bool))[0x555c100bc626]
|
handler/ha_innodb.cc:12389(create_table_info_t::create_table(bool))[0x555c0fe3bfae]
|
handler/ha_innodb.cc:12585(ha_innobase::create(char const*, TABLE*, HA_CREATE_INFO*, bool, trx_t*))[0x555c0fe67a38]
|
handler/ha_innodb.cc:12632(ha_innobase::create(char const*, TABLE*, HA_CREATE_INFO*))[0x555c0fe3ce14]
|
sql/handler.cc:4595(handler::ha_create(char const*, TABLE*, HA_CREATE_INFO*))[0x555c0f6161d0]
|
sql/handler.cc:4969(ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, st_mysql_const_unsigned_lex_string*))[0x555c0f618fef]
|
sql/sql_table.cc:9760(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x555c0f1395dd]
|
sql/sql_alter.cc:497(Sql_cmd_alter_table::execute(THD*))[0x555c0f277208]
|
sql/sql_parse.cc:6288(mysql_execute_command(THD*))[0x555c0ef30b73]
|
sql/sql_parse.cc:8087(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555c0ef3b389]
|
sql/sql_parse.cc:1852(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x555c0ef1629b]
|
sql/sql_parse.cc:1395(do_command(THD*))[0x555c0ef13433]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x555c0f26869a]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x555c0f268077]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x555c1057412b]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fad051856ba]
|
x86_64/clone.S:111(clone)[0x7fad0461a41d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x62b00007e288): ALTER TABLE t5 ADD FOREIGN KEY x (v1) REFERENCES t5 (vcol2)
|
Connection ID (thread ID): 9
|
Status: NOT_KILLED
|
- relates to
-
MDEV-17859
Operating system errors in file operations after failed CREATE
-
-
Closed
{"report":{"fcp":827.7000000476837,"ttfb":214.40000009536743,"pageVisibility":"visible","entityId":70245,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"97bcd140-df8b-4dc3-965b-2c0f09ead355","navigationType":0,"readyForUser":904.5,"redirectCount":0,"resourceLoadedEnd":1217,"resourceLoadedStart":219.40000009536743,"resourceTiming":[{"duration":153.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":219.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":153,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":219.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":217.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":219.79999995231628,"connectEnd":219.79999995231628,"connectStart":219.79999995231628,"domainLookupEnd":219.79999995231628,"domainLookupStart":219.79999995231628,"fetchStart":219.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":219.79999995231628,"responseEnd":437,"responseStart":437,"secureConnectionStart":219.79999995231628},{"duration":301.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":220,"connectEnd":220,"connectStart":220,"domainLookupEnd":220,"domainLookupStart":220,"fetchStart":220,"redirectEnd":0,"redirectStart":0,"requestStart":220,"responseEnd":521.0999999046326,"responseStart":521,"secureConnectionStart":220},{"duration":304.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":220.09999990463257,"connectEnd":220.09999990463257,"connectStart":220.09999990463257,"domainLookupEnd":220.09999990463257,"domainLookupStart":220.09999990463257,"fetchStart":220.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":220.09999990463257,"responseEnd":524.7999999523163,"responseStart":524.7999999523163,"secureConnectionStart":220.09999990463257},{"duration":305,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":220.20000004768372,"connectEnd":220.20000004768372,"connectStart":220.20000004768372,"domainLookupEnd":220.20000004768372,"domainLookupStart":220.20000004768372,"fetchStart":220.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":220.20000004768372,"responseEnd":525.2000000476837,"responseStart":525.2000000476837,"secureConnectionStart":220.20000004768372},{"duration":305.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":220.20000004768372,"connectEnd":220.20000004768372,"connectStart":220.20000004768372,"domainLookupEnd":220.20000004768372,"domainLookupStart":220.20000004768372,"fetchStart":220.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":220.20000004768372,"responseEnd":525.7000000476837,"responseStart":525.7000000476837,"secureConnectionStart":220.20000004768372},{"duration":305.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":220.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":306.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":220.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":305.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":220.5,"connectEnd":220.5,"connectStart":220.5,"domainLookupEnd":220.5,"domainLookupStart":220.5,"fetchStart":220.5,"redirectEnd":0,"redirectStart":0,"requestStart":220.5,"responseEnd":526.2000000476837,"responseStart":526.2000000476837,"secureConnectionStart":220.5},{"duration":306.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":220.70000004768372,"connectEnd":220.70000004768372,"connectStart":220.70000004768372,"domainLookupEnd":220.70000004768372,"domainLookupStart":220.70000004768372,"fetchStart":220.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":220.70000004768372,"responseEnd":526.7999999523163,"responseStart":526.7999999523163,"secureConnectionStart":220.70000004768372},{"duration":990.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":226.09999990463257,"connectEnd":226.09999990463257,"connectStart":226.09999990463257,"domainLookupEnd":226.09999990463257,"domainLookupStart":226.09999990463257,"fetchStart":226.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":226.09999990463257,"responseEnd":1216.5,"responseStart":1216.5,"secureConnectionStart":226.09999990463257},{"duration":990.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":226.09999990463257,"connectEnd":226.09999990463257,"connectStart":226.09999990463257,"domainLookupEnd":226.09999990463257,"domainLookupStart":226.09999990463257,"fetchStart":226.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":226.09999990463257,"responseEnd":1217,"responseStart":1217,"secureConnectionStart":226.09999990463257},{"duration":515.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":591.5,"connectEnd":591.5,"connectStart":591.5,"domainLookupEnd":591.5,"domainLookupStart":591.5,"fetchStart":591.5,"redirectEnd":0,"redirectStart":0,"requestStart":591.5,"responseEnd":1107.2999999523163,"responseStart":1107.2999999523163,"secureConnectionStart":591.5},{"duration":430.39999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":821.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":821.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1251.5999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":75,"responseStart":214,"responseEnd":222,"domLoading":217,"domInteractive":1237,"domContentLoadedEventStart":1237,"domContentLoadedEventEnd":1276,"domComplete":1884,"loadEventStart":1884,"loadEventEnd":1884,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1222},{"name":"bigPipe.sidebar-id.end","time":1222.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1222.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1223.9000000953674},{"name":"activityTabFullyLoaded","time":1288.4000000953674}],"measures":[],"correlationId":"aecc1ade36585d","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":83,"dbReadsTimeInMs":19,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}