Help me restore my data

Community
1

Last week, my server unexpectedly lost power, causing a table in the database to be broken. I cannot repair this table. The current situation of this table is that even a simple select query cannot find out a record. Can you help me restore this table? I will pay the corresponding fee. Thank you!

2

Hi @jiaqingqiang ,

Please can you give some more details? I suspect that the table is currently SUSPENDED. Can you check on the web console or with a query like this?

select * from wal_tables() where suspended = true

If a table is suspended, then any new data you ingest will not become visibile. You will need to resume the table: ALTER TABLE RESUME WAL | QuestDB

If the table is resumed and the data not visible, then please share your schema, queries and logs so we can try to debug what is going on!

3

I try this sql,but the query it’s none.There are not suspended tables.It’s look great and work fine,but can not execute anly sql with the table.My bad table name is geo_mark_displacement,I try the sql “select ts from geo_mark_displacement limit 1”,It will be in running status,no result.I tried running it for 1 day, but it didn’t work.Can you help me?I can send the db zip to you,help me repair the table

4

I execute the sql “select * from wal_tables() where suspended = true”.The result is “0 row in 17ms”.The questdb is look fine.Actually,the table is bad.

5

Hi @jiaqingqiang ,

So the table is not suspended. What is the schema and query?

Please also run table_partitions() - do you see the expected data there?

6

Hi @jiaqingqiang , any update?