xzxiong
commented
1 year ago repro steps:
-
startup mo
-
untar data files mo-data.statement.tgz tar zxfv mo-data.statement.tgz -C {folder_where_mo-service_startup}
-
create table and create view
create database test; use test; CREATE EXTERNAL TABLE IF NOT EXISTS \`statement_info\`( \`statement_id\` varchar(36) DEFAULT "0" COMMENT "statement uniq id", \`transaction_id\` varchar(36) DEFAULT "0" COMMENT "txn uniq id", \`session_id\` varchar(36) DEFAULT "0" COMMENT "session uniq id", \`account\` varchar(1024) NOT NULL COMMENT "account name", \`user\` varchar(1024) NOT NULL COMMENT "user name", \`host\` varchar(1024) NOT NULL COMMENT "user client ip", \`database\` varchar(1024) NOT NULL COMMENT "what database current session stay in.", \`statement\` TEXT NOT NULL COMMENT "sql statement", \`statement_tag\` TEXT NOT NULL COMMENT "note tag in statement(Reserved)", \`statement_fingerprint\` TEXT NOT NULL COMMENT "note tag in statement(Reserved)", \`node_uuid\` varchar(36) DEFAULT "0" COMMENT "node uuid, which node gen this data.", \`node_type\` varchar(64) DEFAULT "node" COMMENT "node type in MO, val in [DN, CN, LOG]", \`request_at\` datetime(6) NOT NULL COMMENT "request accept datetime", \`response_at\` datetime(6) NOT NULL COMMENT "response send datetime", \`duration\` bigint unsigned DEFAULT "0" COMMENT "exec time, unit: ns", \`status\` varchar(32) DEFAULT "Running" COMMENT "sql statement running, enum: Running, Success, Failed", \`err_code\` varchar(1024) DEFAULT "0" COMMENT "", \`error\` TEXT NOT NULL COMMENT "error message", \`exec_plan\` JSON NOT NULL COMMENT "statement execution plan", \`rows_read\` bigint unsigned DEFAULT "0" COMMENT "rows read total", \`bytes_scan\` bigint unsigned DEFAULT "0" COMMENT "bytes scan total" ) infile { "filepath" = './mo-data1/etl/*/*/*/*/*/statement_info/*.csv', "compression" = "none" } FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 0 lines -
exec sql
select statement_id, transaction_id, session_id, user, statement, node_uuid, node_type, request_at, response_at, duration / 1e9 as sec from statement_info where statement = 'show databases' ;
volgariver6
Is there an existing issue for the same bug?
Environment
Actual Behavior
select statement_id, transaction_id, session_id, user, statement, node_uuid, node_type, request_at, response_at, duration / 1e9 as sec from statement_info where statement = 'show databases' ;ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during querylast log output
Expected Behavior
No response
Steps to Reproduce
No response
Additional information
No response