[bug] Slow DB locks caused compaction to stop, resulting in many slow queries.

[bigdata-kuxingseng]

version:3.2.12,shard_data
fe log：
2025-02-24 04:39:44.486+08:00 INFO (DeadlockChecker|44) [LockChecker.checkSlowLocks():109] slow db locks: [{“lockState”:“readLocked”,“slowReadLockCount”:1,“dumpThreads”:“lockHoldTime: 2327990 ms;dump thread: StarMgrMetaSyncer, id: 50\n [email protected]/jdk.internal.misc.Unsafe.park(Native Method)\n [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:211)\n app//io.grpc.stub.ClientCalls$ThreadlessExecutor.waitAndDrain(ClientCalls.java:717)\n app//io.grpc.stub.ClientCalls.blockingUnaryCall(ClientCalls.java:159)\n app//com.staros.proto.StarManagerGrpc$StarManagerBlockingStub.listShard(StarManagerGrpc.java:2117)\n app//com.staros.client.StarClient.lambda$listShard$21(StarClient.java:521)\n app//com.staros.client.StarClient$$Lambda$2162/0x00000008018ff338.call(Unknown Source)\n app//com.staros.client.StarClient.internalRpcCall(StarClient.java:770)\n app//com.staros.client.StarClient.listShard(StarClient.java:521)\n app//com.starrocks.lake.StarOSAgent.listShard(StarOSAgent.java:499)\n app//com.starrocks.lake.StarMgrMetaSyncer.syncTableMetaInternal(StarMgrMetaSyncer.java:301)\n app//com.starrocks.lake.StarMgrMetaSyncer.syncTableMetaAndColocationInfoInternal(StarMgrMetaSyncer.java:365)\n app//com.starrocks.lake.StarMgrMetaSyncer.syncTableMetaAndColocationInfo(StarMgrMetaSyncer.java:262)\n app//com.starrocks.lake.StarMgrMetaSyncer.runAfterCatalogReady(StarMgrMetaSyncer.java:376)\n app//com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)\n app//com.starrocks.common.util.Daemon.run(Daemon.java:107)\n;”,“lockDbName”:“sl_attribution_preview”,“lockWaiters”:[{“threadId”:6540484,“threadName”:“thrift-server-pool-227883”},{“threadId”:6467634,“threadName”:“thrift-server-pool-227276”},{“threadId”:6536163,“threadName”:“starrocks-mysql-nio-pool-106760”},{“threadId”:6535726,“threadName”:“starrocks-mysql-nio-pool-106759”},{“threadId”:6538262,“threadName”:“thrift-server-pool-227860”},{“threadId”:6507676,“threadName”:“thrift-server-pool-227620”},{“threadId”:48,“threadName”:“DynamicPartitionScheduler”},{“threadId”:28,“threadName”:“UpdateDbUsedDataQuota”},{“threadId”:56,“threadName”:“MemoryUsageTracker”},{“threadId”:24,“threadName”:“consistency checker”},{“threadId”:98,“threadName”:“COMPACTION_DISPATCH”},{“threadId”:54,“threadName”:“autovacuum”},{“threadId”:33,“threadName”:“tablet stat mgr”}]}]

[starrocks-xupeng]

what's the last start time of this FE

[starrocks-xupeng]

it's been fixed in 3.3.9.
and if you using 3.2 version, this problem only appears when FE doesn't restart for a long time(like several months), so you can restart for now and upgrade in some time.

[bigdata-kuxingseng]

the last start time of this FE is :2025-01-09, could you please send me the PR,thanks

[kevincai]

the last start time of this FE is :2025-01-09, could you please send me the PR,thanks

#54063