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 262 forks source link

表无法删除 #139

Open zhang750211 opened 1 year ago

zhang750211 commented 1 year ago

首先开始发现VACUUM FULL 表的时候,长时间没有反应,怀疑有事务在锁定,用select * from pg_stat_activity查询没发现有对应的表在锁定状态,然后把数据库重启一次,依然如旧,最后决定把表删除了, 结果发现删除语句也是一值处于执行中,无法删除,数据库重启以后现象依旧,我所建的表是分区表,但数据量不大,1000以内。不知道这是什么原因造成的,有什么办法可以删除这个表。等超时后下面的提示 drop table pickup_resources

ERROR: node:dn002, backend_pid:19951, nodename:dn002,backend_pid:19951,message:canceling statement due to statement timeout 用的是版本V2.0