【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】OB4.0社区版
【问题描述】
【复现路径】问题出现前后相关操作
【问题现象及影响】
kill 进程无响应，长时间处于SESSION_KILLED状态
*************************** 7. row ***************************
id: 3221525535
user: ob_mysql
tenant: mysql
host: 10.101.0.188:30380
db: NULL
command: Query
sql_id: 342DB72195D5C27656AFFD03DCD63EC4
time: 2209
state: SESSION_KILLED
info: KILL 3221528435
svr_ip: 10.101.0.121
svr_port: 2882
sql_port: 2881
proxy_sessid: NULL
master_sessid: NULL
user_client_ip: 10.101.0.188
user_host: %
trans_id: 0
thread_id: 36168
ssl_cipher: NULL
trace_id: YB420A650079-0005F671FFA76A17-0-0
trans_state:
total_time: 2209
retry_cnt: 0
retry_info: 0
action:
module:
client_info:
sql_trace: 1
对应线程的pstack
Thread 1 (process 36168):
#0 0x00007f1f224dde29 in syscall () from /lib64/libc.so.6
#1 0x000000000b635b85 in int oceanbase::common::ObLatchWaitQueue::waitoceanbase::common::ObLatch::LowTryWRLock(oceanbase::common::ObWaitProc&, unsigned int, unsigned int, oceanbase::common::ObLatch::LowTryWRLock&, oceanbase::common::ObLatch::LowTryWRLock&, long) ()
#2 0x00000000038fdd75 in oceanbase::common::ObLatch::wrlock(unsigned int, long, unsigned int const*) ()
#3 0x0000000008651430 in oceanbase::sql::ObSQLSessionMgr::kill_session(oceanbase::sql::ObSQLSessionInfo&) ()
#4 0x0000000006bbce10 in oceanbase::sql::ObKillSession::kill_session(oceanbase::sql::ObKillSessionArg const&, oceanbase::sql::ObSQLSessionMgr&) ()
#5 0x0000000006bbc45e in oceanbase::sql::ObKillExecutor::execute(oceanbase::sql::ObExecContext&, oceanbase::sql::ObKillStmt&) ()
#6 0x0000000006954d49 in oceanbase::sql::ObCmdExecutor::execute(oceanbase::sql::ObExecContext&, oceanbase::sql::ObICmd&)::$_100::operator() ()
#7 0x0000000003a6ff63 in oceanbase::sql::ObCmdExecutor::execute(oceanbase::sql::ObExecContext&, oceanbase::sql::ObICmd&) ()
#8 0x00000000039c2583 in oceanbase::sql::ObResultSet::open_cmd() ()
#9 0x000000000394f5c7 in oceanbase::sql::ObResultSet::execute() ()
#10 0x0000000003945b32 in oceanbase::sql::ObResultSet::open() ()
#11 0x00000000039e09e6 in oceanbase::observer::ObSyncCmdDriver::response_result(oceanbase::observer::ObMySQLResultSet&) ()
#12 0x00000000039137eb in oceanbase::observer::ObMPQuery::process_single_stmt(oceanbase::sql::ObMultiStmtItem const&, oceanbase::sql::ObSQLSessionInfo&, bool, bool, bool&, bool&) ()
#13 0x000000000390eb08 in oceanbase::observer::ObMPQuery::process() ()
#14 0x000000000390c66a in oceanbase::rpc::frame::ObSqlProcessor::run() ()
#15 0x000000000390ab41 in oceanbase::omt::ObWorkerProcessor::process(oceanbase::rpc::ObRequest&) ()
#16 0x00000000045eb379 in oceanbase::omt::ObThWorker::process_request(oceanbase::rpc::ObRequest&) ()
#17 0x0000000003902f24 in oceanbase::omt::ObThWorker::worker(long&, long&, int&) ()
#18 0x00000000045eb917 in non-virtual thunk to oceanbase::omt::ObThWorker::run(long) ()
#19 0x000000000b5ffbb7 in std::_Function_handler<void (), oceanbase::lib::Threads::start()::$_144>::_M_invoke ()
#20 0x000000000b5fa7ea in oceanbase::lib:
:__th_start(void*) ()
#21 0x00007f1f227baea5 in start_thread () from /lib64/libpthread.so.0
#22 0x00007f1f224e3b0d in clone () from /lib64/libc.so.6
【附件】