Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

表无法删除 #139

Open
zhang750211 opened this issue Jan 29, 2023 · 0 comments
Open

表无法删除 #139

zhang750211 opened this issue Jan 29, 2023 · 0 comments

Comments

@zhang750211
Copy link

zhang750211 commented Jan 29, 2023

首先开始发现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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant