我刚刚又遇到一个错误
ERROR mysql_async::query{mysql_async.connection.id=3222013046 mysql_async.query.sql=“SELECT payIndex(10001000,19905,19936)”}: mysql_async::conn::routines::query: /home/runner/.cargo/registry/src/index.crates.io-6f17d22bba15001f/mysql_async-0.34.1/src/conn/routines/query.rs:57: error=Server error: `ERROR HY000 (4012): Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.’
ERROR re::err: /home/runner/.cargo/registry/src/index.crates.io-6f17d22bba15001f/re-0.1.7/src/err.rs:28: 0: anyhow::error::<impl core::convert::From for anyhow::Error>::from
1: pay::post::{{closure}}
2: <re::msg::FnAny as axum::handler::Handler<(M,T1),S>>::call::{{closure}}
3: <tower::util::map_response::MapResponseFuture<F,N> as core::future::future::Future>::poll
4: <axum::routing::route::RouteFuture as core::future::future::Future>::poll
5: <tower::util::map_response::MapResponseFuture<F,N> as core::future::future::Future>::poll
6: <axum::middleware::from_fn::FromFn<F,S,I,(T1,)> as tower_service::Service<http::request::Request<axum_core::body::Body>>>::call::{{closure}}
7: <tower::util::map_response::MapResponseFuture<F,N> as core::future::future::Future>::poll
8: <axum::routing::route::RouteFuture as core::future::future::Future>::poll
9: <axum::error_handling::HandleError<S,F,()> as tower_service::Service<http::request::Request>>::call::{{closure}}
10: <tower::util::map_response::MapResponseFuture<F,N> as core::future::future::Future>::poll
11: <axum::routing::route::RouteFuture as core::future::future::Future>::poll
12: <tower::util::map_response::MapResponseFuture<F,N> as core::future::future::Future>::poll
13: <axum::routing::route::RouteFuture as core::future::future::Future>::poll
14: <axum::serve::TowerToHyperServiceFuture<S,R> as core::future::future::Future>::poll
15: hyper::proto::h1::dispatch::Dispatcher<D,Bs,I,T>::poll_loop
16: <axum::serve::Serve<M,S> as core::future::into_future::IntoFuture>::into_future::{{closure}}::{{closure}}
17: tokio::runtime::task::raw::poll
18: tokio::runtime::scheduler::multi_thread::worker::Context::run_task
19: tokio::runtime::task::raw::poll
20: std::sys::backtrace::__rust_begin_short_backtrace
21: core::ops::function::FnOnce::call_once{{vtable.shim}}
22: std::sys::pal::unix:
:thread_start
23:
24:
但是慢查询里面也没有啊，怎么排查？从rust报错看是这个sql mysql_async.query.sql=“SELECT payIndex(10001000,19905,19936)”}:
obclient [oceanbase]> select request_id,usec_to_time(request_time),ELAPSED_TIME,QUEUE_TIME,EXECUTE_TIME,query_sql from v$OB_SQL_AUDIT where ELAPSED_TIME > 1000000 limit 10;
±-----------±---------------------------±-------------±-----------±-------------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| request_id | usec_to_time(request_time) | ELAPSED_TIME | QUEUE_TIME | EXECUTE_TIME | query_sql |
±-----------±---------------------------±-------------±-----------±-------------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1639003 | 2024-07-03 19:28:11.545749 | 1190747 | 0 | 1190604 | SELECT unit_id, cast(sum(data_disk_in_use) as signed) required_size, status in (‘MIGRATE IN’, ‘MIGRATE OUT’) is_migrating from __all_virtual_unit where status in (‘NORMAL’, ‘MIGRATE IN’, ‘MIGRATE OUT’) group by unit_id |
| 1642825 | 2024-07-03 19:29:08.253129 | 1181852 | 0 | 1181308 | SELECT unit_id, cast(sum(data_disk_in_use) as signed) required_size, status in (‘MIGRATE IN’, ‘MIGRATE OUT’) is_migrating from __all_virtual_unit where status in (‘NORMAL’, ‘MIGRATE IN’, ‘MIGRATE OUT’) group by unit_id |
| 1642880 | 2024-07-03 19:29:09.436349 | 1074012 | 0 | 1073874 | SELECT unit_id, cast(sum(data_disk_in_use) as signed) required_size, status in (‘MIGRATE IN’, ‘MIGRATE OUT’) is_migrating from __all_virtual_unit where status in (‘NORMAL’, ‘MIGRATE IN’, ‘MIGRATE OUT’) group by unit_id |
| 1374569 | 2024-07-03 19:29:11.789941 | 1027881 | 326 | 1026980 | |
| 774895 | 2024-07-03 19:25:06.003823 | 1548216 | 143 | 1547483 | |
±-----------±---------------------------±-------------±-----------±-------------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.091 sec)
