CREATE TABLE rivers (
|
origid INT UNSIGNED NOT NULL
|
, destid INT UNSIGNED NOT NULL
|
, name VARCHAR(32)
|
, weight DOUBLE NOT NULL
|
, PRIMARY KEY (origid, destid)
|
, KEY (destid)
|
);
|
|
INSERT INTO rivers (origid, destid, name, weight) VALUES
|
(1,2,'Rhein',1), (2,3,'Rhein',1), (3,4,'Rhein',1), (4,5,'Rhein',1), (2,6,'Rhein',1), (5,6,'Rhein',1)
|
, (6,2,'Thur',2), (7,3,'Glatt',2)
|
, (8,9,'Aare',2), (9,10,'Aare',2), (10,4,'Aare',2)
|
, (11,12,'Reuss',3), (12,10,'Reuss',3), (13,12,'Lorze',4)
|
, (14,15,'Limmat',3), (15,9,'Limmat',3), (16,15,'Reppisch',4)
|
;
|
|
|
CREATE TABLE river_graph (
|
latch VARCHAR(32) NULL
|
, origid BIGINT UNSIGNED NULL
|
, destid BIGINT UNSIGNED NULL
|
, weight DOUBLE NULL
|
, seq BIGINT UNSIGNED NULL
|
, linkid BIGINT UNSIGNED NULL
|
, KEY (latch, origid, destid) USING HASH
|
, KEY (latch, destid, origid) USING HASH
|
) ENGINE=OQGRAPH data_table='rivers' origid='origid' destid='destid' weight='weight'
|
;
|
|
SELECT * FROM river_graph;
|
|
|
SELECT * FROM river_graph WHERE latch="leaves" AND origid=16;
|
alter table rivers drop column name;
|
|
Server version: 10.3.9-MariaDB
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=3
|
max_threads=153
|
thread_count=7
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467396 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f63640009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f63ddbf9e90 thread_stack 0x49000
|
/home/mysql/product/mariadb-10.3/bin/mysqld(my_print_stacktrace+0x2b)[0x55e9829c913b]
|
/home/mysql/product/mariadb-10.3/bin/mysqld(handle_fatal_signal+0x537)[0x55e9824ae837]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f63fb1fb390]
|
linux/raise.c:54(__GI_raise)[0x7f63fa7ca428]
|
stdlib/abort.c:91(__GI_abort)[0x7f63fa7cc02a]
|
ut/ut0rbt.cc:461(rbt_eject_node(ib_rbt_node_t*, ib_rbt_node_t*) [clone .part.4])[0x55e98221e6dd]
|
row/row0merge.cc:4527(row_merge_drop_table(trx_t*, dict_table_t*))[0x55e982703f6c]
|
handler/handler0alter.cc:9980(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55e98266784b]
|
sql/sql_table.cc:7618(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*) [clone .isra.227])[0x55e982212e01]
|
sql/sql_table.cc:9715(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))[0x55e98237e194]
|
sql/sql_alter.cc:495(Sql_cmd_alter_table::execute(THD*))[0x55e9823c82fe]
|
sql/sql_parse.cc:6284(mysql_execute_command(THD*))[0x55e9822f4eb9]
|
sql/sql_class.h:1809(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55e9822fc239]
|
sql/sql_parse.cc:1850(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55e9822fe2b3]
|
sql/sql_parse.cc:1397(do_command(THD*))[0x55e9822fea4e]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55e9823c4f8f]
|
sql/sql_connect.cc:1310(handle_one_connection)[0x55e9823c50b4]
|
perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55e98262644d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f63fb1f16ba]
|
x86_64/clone.S:111(clone)[0x7f63fa89c41d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f63640115f0): alter table rivers drop column name
|
Connection ID (thread ID): 14
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
|
|
{"report":{"fcp":1095.5999999046326,"ttfb":221.39999985694885,"pageVisibility":"visible","entityId":69735,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"caa19c0c-1782-4188-926d-b0c0ccba03a7","navigationType":0,"readyForUser":1170.7999999523163,"redirectCount":0,"resourceLoadedEnd":1289.5,"resourceLoadedStart":227.69999980926514,"resourceTiming":[{"duration":440.10000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":227.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":227.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":667.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":439.7000000476837,"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":228.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":667.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":448.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":228.19999980926514,"connectEnd":228.19999980926514,"connectStart":228.19999980926514,"domainLookupEnd":228.19999980926514,"domainLookupStart":228.19999980926514,"fetchStart":228.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":228.19999980926514,"responseEnd":677.0999999046326,"responseStart":677.0999999046326,"secureConnectionStart":228.19999980926514},{"duration":475.60000014305115,"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":228.19999980926514,"connectEnd":228.19999980926514,"connectStart":228.19999980926514,"domainLookupEnd":228.19999980926514,"domainLookupStart":228.19999980926514,"fetchStart":228.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":228.19999980926514,"responseEnd":703.7999999523163,"responseStart":703.7999999523163,"secureConnectionStart":228.19999980926514},{"duration":479.7999999523163,"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":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":708.0999999046326,"responseStart":708.0999999046326,"secureConnectionStart":228.29999995231628},{"duration":482.2000000476837,"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":228.39999985694885,"connectEnd":228.39999985694885,"connectStart":228.39999985694885,"domainLookupEnd":228.39999985694885,"domainLookupStart":228.39999985694885,"fetchStart":228.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":228.39999985694885,"responseEnd":710.5999999046326,"responseStart":710.5999999046326,"secureConnectionStart":228.39999985694885},{"duration":484.19999980926514,"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":228.5,"connectEnd":228.5,"connectStart":228.5,"domainLookupEnd":228.5,"domainLookupStart":228.5,"fetchStart":228.5,"redirectEnd":0,"redirectStart":0,"requestStart":228.5,"responseEnd":712.6999998092651,"responseStart":712.6999998092651,"secureConnectionStart":228.5},{"duration":485.90000009536743,"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":228.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.5,"responseStart":0,"secureConnectionStart":0},{"duration":485.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":228.79999995231628,"connectEnd":228.79999995231628,"connectStart":228.79999995231628,"domainLookupEnd":228.79999995231628,"domainLookupStart":228.79999995231628,"fetchStart":228.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":228.79999995231628,"responseEnd":714.5,"responseStart":714.5,"secureConnectionStart":228.79999995231628},{"duration":487.2999999523163,"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":228.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":716.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":487.2999999523163,"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":229,"connectEnd":229,"connectStart":229,"domainLookupEnd":229,"domainLookupStart":229,"fetchStart":229,"redirectEnd":0,"redirectStart":0,"requestStart":229,"responseEnd":716.2999999523163,"responseStart":716.2999999523163,"secureConnectionStart":229},{"duration":1050.9000000953674,"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":238.09999990463257,"connectEnd":238.09999990463257,"connectStart":238.09999990463257,"domainLookupEnd":238.09999990463257,"domainLookupStart":238.09999990463257,"fetchStart":238.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":238.09999990463257,"responseEnd":1289,"responseStart":1289,"secureConnectionStart":238.09999990463257},{"duration":1050.1000001430511,"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":239.39999985694885,"connectEnd":239.39999985694885,"connectStart":239.39999985694885,"domainLookupEnd":239.39999985694885,"domainLookupStart":239.39999985694885,"fetchStart":239.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":239.39999985694885,"responseEnd":1289.5,"responseStart":1289.5,"secureConnectionStart":239.39999985694885},{"duration":395,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":890.7999999523163,"connectEnd":890.7999999523163,"connectStart":890.7999999523163,"domainLookupEnd":890.7999999523163,"domainLookupStart":890.7999999523163,"fetchStart":890.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":890.7999999523163,"responseEnd":1285.7999999523163,"responseStart":1285.7999999523163,"secureConnectionStart":890.7999999523163},{"duration":230.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1074.8999998569489,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1074.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1305.3999998569489,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":64,"responseStart":222,"responseEnd":239,"domLoading":226,"domInteractive":1340,"domContentLoadedEventStart":1340,"domContentLoadedEventEnd":1377,"domComplete":2110,"loadEventStart":2110,"loadEventEnd":2112,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1325},{"name":"bigPipe.sidebar-id.end","time":1325.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1328.2999999523163},{"name":"activityTabFullyLoaded","time":1383.2999999523163}],"measures":[],"correlationId":"d272393674e244","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}