admin管理员组

文章数量:1287828

I’m trying to delete a DFS database named stock in DolphinDB. According to the documentation, I attempted to use dropTable but encountered an error. Here’s what I did:

Code Executed: db = database("dfs://stock") dropTable(db, "stock") Error Received: RemoteRun[controller8700] getFileBlocksMeta on path '/stock/stock.tbl' failed, reason: path does not exist

I tried to use dropDatabase("dfs://stock"), but received an error 'the database is in RECOVERING state and cannot be deleted'

And i had restarted the DolphinDB cluster, but the issue persists.

DolphinDB version: 2.00.10 Deployment: Multi-machine cluster (1 controller, 2 agents, 2 data nodes) OS: Linux

I’m trying to delete a DFS database named stock in DolphinDB. According to the documentation, I attempted to use dropTable but encountered an error. Here’s what I did:

Code Executed: db = database("dfs://stock") dropTable(db, "stock") Error Received: RemoteRun[controller8700] getFileBlocksMeta on path '/stock/stock.tbl' failed, reason: path does not exist

I tried to use dropDatabase("dfs://stock"), but received an error 'the database is in RECOVERING state and cannot be deleted'

And i had restarted the DolphinDB cluster, but the issue persists.

DolphinDB version: 2.00.10 Deployment: Multi-machine cluster (1 controller, 2 agents, 2 data nodes) OS: Linux

  • dolphindb
  • drop-table
  • drop-database
Share Improve this question asked Feb 24 at 15:08 EA839EA839 281 silver badge7 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 1

First, use dropPartition (or use dropRecoveringPartitions from the ops module) to forcefully remove partitions from each table, and then use dropDatabase to delete the entire database.

本文标签：

版权声明：本文标题：drop table - Unable to delete DolphinDB DFS database due to “RECOVERING state” and missing file path error - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741258029a2367063.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。