search

Tencent / TBase

TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
Other
1.38k stars 261 forks source link

vacuumdb错误 #77

Closed ludongyuan closed 3 weeks ago

ludongyuan commented 4 years ago

vacuumdb: vacuuming of database failed: ERROR: node:dn002, backend_pid:107225, nodename:dn003,backend_pid:49855,message:deadlock detected DETAIL: Process 49855 waits for AccessShareLock on relation 2601 of database 16394; blocked by process 49933. Process 49933 waits for RowExclusiveLock on relation 2619 of database 16394; blocked by process 49855.

JennyJennyChen commented 4 years ago

按照上面的错误描述，已经知道是49855和49933进程出现了死锁，可通过调用 select pg_terminate_backend(49855)，或者 select pg_terminate_backend(49933)终止掉其中一个进程。