[Bug]: sql出现大量的查询超时

[PHK-20]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

83164a1

Commit ID

83164a1

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

常规的业务请求突然出现大量超时

mysql> desc billing.organization_financial_accounts;
+---------------------+---------------+------+------+---------+----------------+---------+
| Field | Type | Null | Key | Default | Extra | Comment |
+---------------------+---------------+------+------+---------+----------------+---------+
| id | BIGINT(64) | NO | PRI | NULL | auto_increment | |
| organization_id | VARCHAR(128) | YES | MUL | NULL | | |
| amount | DECIMAL(18,2) | NO | | 0 | | |
| max_overdraw_amount | DECIMAL(18,2) | NO | | 0 | | |
| account_type | TINYINT(8) | YES | | NULL | | |
| currency | VARCHAR(128) | YES | | NULL | | |
| created_at | DATETIME(0) | YES | | NULL | | |
| updated_at | DATETIME(0) | YES | | NULL | | |
+---------------------+---------------+------+------+---------+----------------+---------+

{"level":"ERROR","time":"2025/01/26 02:17:58.329679 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"93405df2-6aa6-4070-99c4-9cbb5425e079","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.000557081s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-59561' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:21:11.615624 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"45190179-56a0-4b2c-99fa-c571abaccb2d","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.000351761s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-33614' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:27:10.914133 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"ad94dbe3-9880-4b7f-9197-5d3c5e1bc46f","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.001069015s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-31877' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:31:06.662990 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"36d195d8-a919-483c-adf6-9a87a549f219","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.000523069s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-52185' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:31:10.620864 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"24c9557c-3d15-4453-8762-6c0ff402b2fb","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.000268369s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-31877' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:32:28.000874 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"8a7aed37-18cb-4899-90dd-1b4498658bbf","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.001033299s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-52185' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:35:26.789394 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"f383d438-78bb-4d8f-984b-a4b08ae991eb","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.000345852s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-31877' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}
{"level":"ERROR","time":"2025/01/26 02:35:56.728002 +0000","caller":"service/wallet.go:27","msg":"trace","X-Request-ID":"309c3fba-a764-4f32-8482-39328d0a1e59","error":"type:business, code:999, msg:context deadline exceeded, caused by context deadline exceeded","errorVerbose":"type:business, code:999, msg:context deadline exceeded\nCause by context deadline exceeded","elapsed":"3.000773835s","rows":0,"sql":"SELECT * FROM organization_financial_accounts WHERE organization_id = '019-31877' AND account_type = 1 ORDER BY organization_financial_accounts.id LIMIT 1"}

Expected Behavior

No response

Steps to Reproduce

mysql -h freetier-01.cn-hangzhou.cluster.cn-dev.matrixone.tech -P 6001 -u 01935322-5256-757a-bbef-a70ddee5a6b2#admin#accountadmin -p

SELECT * FROM `organization_financial_accounts` WHERE organization_id = '019-59561' AND account_type = 1 ORDER BY `organization_financial_accounts`.`id` LIMIT 1

Additional information

No response

[ouyuanning]

辛苦@xiaoshuwei帮忙确认下，问题是否还存在