[GH-ISSUE #6772 ] [Bug] Failed to load AppFlowy UI #2986

Owner

Originally created by @Twilightssuperb on GitHub (Nov 12, 2024).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/6772

Originally assigned to: @appflowy on GitHub.

Bug Description

After forced PC reboot (because of blackout) I launched previous v.0.4.9 instance from disk C by accident. Got error, closed it. Then I've started main v.0.7.3 instance on disk F, but get empty UI.

How to fix it? I've tried to delete all files from AppFlowy instance form disk F and set clear instance, but nothing...

How to Reproduce

IDK

Expected Behavior

log_2024-11-10.txt (previous normal launch)
log_2024-11-12.txt

Operating System

Win 8.1 x64

AppFlowy Version(s)

0.7.3

Screenshots

Additional Context

No response

Originally created by @Twilightssuperb on GitHub (Nov 12, 2024). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/6772 Originally assigned to: @appflowy on GitHub. ### Bug Description After forced PC reboot (because of blackout) I launched previous v.0.4.9 instance from disk C by accident. Got error, closed it. Then I've started **main** v.0.7.3 instance on disk F, but get empty UI. How to fix it? I've tried to delete all files from AppFlowy instance form disk F and set clear instance, but nothing... ### How to Reproduce IDK ### Expected Behavior [log_2024-11-10.txt](https://github.com/user-attachments/files/17723063/log_2024-11-10.txt) (previous normal launch) [log_2024-11-12.txt](https://github.com/user-attachments/files/17722984/log_2024-11-12.txt) ### Operating System Win 8.1 x64 ### AppFlowy Version(s) 0.7.3 ### Screenshots ![image](https://github.com/user-attachments/assets/05c9430c-61e0-4669-b4d8-e4abed9ba658) ### Additional Context _No response_

mirror closed this issue

mirror commented

Author

Owner

@LucasXu0 commented on GitHub (Nov 14, 2024):

Hi, @Twilightssuperb. The last version that supports Windows 8 is v0.4.9.

Are you using the local mode? And please try to downgrade to v0.4.9.

@LucasXu0 commented on GitHub (Nov 14, 2024): Hi, @Twilightssuperb. The last version that supports Windows 8 is [v0.4.9](https://github.com/AppFlowy-IO/AppFlowy/releases/tag/0.4.9). Are you using the local mode? And please try to downgrade to v0.4.9.

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Nov 14, 2024):

I use local mode.

All was OK with v.0.7.3 on this PC before my mistake with accidental v.0.4.9 launch. I attached logs.

Maybe the reason is in some C:\users\[...]\AppData\Roaming\io.appflowy files, I don't know. It's not good that AppFlowy isn't completely portable and leaves traces and makes dependencies for standalone instances.

I create third standalone instance for v.0.5.1, but same error again (that for v.0.4.9) — failed to load workspace. Despite no AppFlowy instance is running.

@Twilightssuperb commented on GitHub (Nov 14, 2024): I use local mode. All was OK with v.0.7.3 on this PC before my mistake with accidental v.0.4.9 launch. I attached logs. Maybe the reason is in some `C:\users\[...]\AppData\Roaming\io.appflowy` files, I don't know. It's not good that AppFlowy isn't completely portable and leaves traces and makes dependencies for standalone instances. I create third standalone instance for v.0.5.1, but same error again (that for v.0.4.9) — failed to load workspace. Despite no AppFlowy instance is running. ![image](https://github.com/user-attachments/assets/a139eb28-bac7-405b-9bf1-d36b5f89a17a)

mirror commented

Author

Owner

@LucasXu0 commented on GitHub (Nov 15, 2024):

@Twilightssuperb Can you check if this folder is occupied by another process? In this case, the app can't read any data from the directory, which may cause this error.

C:\users\[...]\AppData\Roaming\io.appflowy

@LucasXu0 commented on GitHub (Nov 15, 2024): @Twilightssuperb Can you check if this folder is occupied by another process? In this case, the app can't read any data from the directory, which may cause this error. ``` C:\users\[...]\AppData\Roaming\io.appflowy ```

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Nov 15, 2024):

Can you check if this folder is occupied by another process?

Resource Monitor says nothing:

@appflowy, please, could you check my logs? 🙏 Sorry for weekend disturbing.

@Twilightssuperb commented on GitHub (Nov 15, 2024): > Can you check if this folder is occupied by another process? Resource Monitor says nothing: ![io appflowy search at Resource Monitor](https://github.com/user-attachments/assets/271fadcb-f624-4f27-aa15-6aeff17fce1e) @appflowy, please, could you check my logs? 🙏 Sorry for weekend disturbing.

mirror commented

Author

Owner

@appflowy commented on GitHub (Nov 16, 2024):

Hi @Twilightssuperb . No problem, I will check it. Thanks for your logs

@appflowy commented on GitHub (Nov 16, 2024): Hi @Twilightssuperb . No problem, I will check it. Thanks for your logs

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Nov 29, 2024):

Any news? Sorry for tricky troubleshooting, IDK how it happened.

Should I better manually backup my data folder, delete it from main location and restore DB from file (https://docs.appflowy.io/docs/appflowy/product/data-storage#restore-specific-local-user-data-manually)?

@Twilightssuperb commented on GitHub (Nov 29, 2024): Any news? Sorry for tricky troubleshooting, IDK how it happened. Should I better manually backup my data folder, delete it from main location and restore DB from file (https://docs.appflowy.io/docs/appflowy/product/data-storage#restore-specific-local-user-data-manually)?

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Jan 2, 2025):

Well, seems data folder is damaged. I backuped it and tried to make clear AppFlowy instance, then pressed "Import data", but got error. Then I tried to edit .db-files (cache.db and flowy-database.db), but blank page at start appeared again.

@appflowy, I attached data ZIP backup there with no password etc., please, mention me after downloading, I will delete it. IDK what to do now, 'cause there are some important notes in my DB, it's hard to lost it. Sorry for incovenience.

@Twilightssuperb commented on GitHub (Jan 2, 2025): Well, seems data folder is damaged. I backuped it and tried to make clear AppFlowy instance, then pressed "Import data", but got error. Then I tried to edit .db-files (`cache.db` and `flowy-database.db`), but blank page at start appeared again. @appflowy, I attached data ZIP backup [there](https://dropmefiles.com/XzkTy) with no password etc., please, mention me after downloading, I will delete it. IDK what to do now, 'cause there are some important notes in my DB, it's hard to lost it. Sorry for incovenience.

mirror commented

Author

Owner

@annieappflowy commented on GitHub (Jan 2, 2025):

@Twilightssuperb , we'll take a look and reach out tomorrow

@annieappflowy commented on GitHub (Jan 2, 2025): @Twilightssuperb , we'll take a look and reach out tomorrow

mirror commented

Author

Owner

@appflowy commented on GitHub (Jan 3, 2025):

Hi @Twilightssuperb I need a password to open it.

@appflowy commented on GitHub (Jan 3, 2025): Hi @Twilightssuperb I need a password to open it. <img width="435" alt="image" src="https://github.com/user-attachments/assets/1730837b-fdfd-4d54-b6a6-ea1d0aed22a7" />

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Jan 3, 2025):

@appflowy, try password 123.

@Twilightssuperb commented on GitHub (Jan 3, 2025): @appflowy, try password `123`.

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Feb 9, 2025):

No reply month later... C'mon, please, help me restore my database anyway, at least as DB-file, it doesn't matter, I still have no access to some important notes from AppFlowy. I know, it's my big fault and I shouldn't launch versions >0.4.9 on Win 8.1, but... 😢

@Twilightssuperb commented on GitHub (Feb 9, 2025): No reply month later... C'mon, please, help me restore my database anyway, at least as DB-file, it doesn't matter, I still have no access to some important notes from AppFlowy. I know, it's my big fault and I shouldn't launch versions >0.4.9 on Win 8.1, but... 😢

mirror commented

Author

Owner

@candideu commented on GitHub (Feb 9, 2025):

@Twilightssuperb are you using the Cloud sync, by any chance?

@candideu commented on GitHub (Feb 9, 2025): @Twilightssuperb are you using the Cloud sync, by any chance?

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Feb 9, 2025):

@candideu, nope, only local account. My data was damaged by my ridiculous mistake.

@Twilightssuperb commented on GitHub (Feb 9, 2025): @candideu, nope, only local account. My data was damaged by my ridiculous mistake.

mirror commented

Author

Owner

@candideu commented on GitHub (Feb 9, 2025):

That's too bad... I faced a similar issue with Windows 10 (see: https://github.com/AppFlowy-IO/AppFlowy/issues/6979#issuecomment-2571743828) was only able to recover my data because it was backed up using the free sync account.

I've faced the same issue with another local-only app a while back (Focalboard), where the app wouldn't load my data after an upgrade. The devs did their best, but were unable to assist. Since then, I try to use local-apps with cloud sync features (or File History, if it's markdown based).

What I did manage to do with that other app was to open my db file in a SQLite editor like SQLiteStudio and DB Browser for SQLite. I was able to export the table which contained my data as a .csv, then imported it into Airtable. It was challenging, but I was able to salvage my data.

Appflowy's data structure seems to be a little more nebulous, though.... I have zero clue where my notes are stored on the computer, and which app I could use to open and recover them....

https://github.com/AppFlowy-IO/AppFlowy/discussions/455
https://github.com/AppFlowy-IO/AppFlowy/issues/2504#issuecomment-1543623178
https://github.com/AppFlowy-IO/AppFlowy/issues/3334
https://www.reddit.com/r/AppFlowy/comments/1ewcifu/ensuring_data_integrity/
Tried reading through this doc page, but it didn't offer much guidance: https://docs.appflowy.io/docs/appflowy/product/data-storage

Do you happen to have access to another Windows machine (like Windows 10 or 11), which you could use to (potentially) import your data, and allow you to export everything?

@candideu commented on GitHub (Feb 9, 2025): That's too bad... I faced a similar issue with Windows 10 (see: https://github.com/AppFlowy-IO/AppFlowy/issues/6979#issuecomment-2571743828) was only able to recover my data because it was backed up using the free sync account. I've faced the same issue with another local-only app a while back (Focalboard), where the app wouldn't load my data after an upgrade. The devs did their best, but were unable to assist. Since then, I try to use local-apps with cloud sync features (or File History, if it's markdown based). What I *did* manage to do with that other app was to open my db file in a SQLite editor like [SQLiteStudio](https://sqlitestudio.pl/) and [DB Browser for SQLite](https://sqlitebrowser.org/). I was able to export the table which contained my data as a .csv, then imported it into Airtable. It was challenging, but I was able to salvage my data. Appflowy's data structure seems to be a little more nebulous, though.... I have zero clue where my notes are stored on the computer, and which app I could use to open and recover them.... - https://github.com/AppFlowy-IO/AppFlowy/discussions/455 - https://github.com/AppFlowy-IO/AppFlowy/issues/2504#issuecomment-1543623178 - https://github.com/AppFlowy-IO/AppFlowy/issues/3334 - https://www.reddit.com/r/AppFlowy/comments/1ewcifu/ensuring_data_integrity/ - Tried reading through this doc page, but it didn't offer much guidance: https://docs.appflowy.io/docs/appflowy/product/data-storage Do you happen to have access to another Windows machine (like Windows 10 or 11), which you could use to (potentially) import your data, and allow you to export everything?

mirror commented

Author

Owner

@khorshuheng commented on GitHub (Feb 10, 2025):

@Twilightssuperb Sorry for the delay, @appflowy is on leave at the moment so I can't reach him immediately to get the current status.

Apologize again for the inconvenience, could you send us the file again? I will get some other colleague/myself to see if we can recover the database.

@khorshuheng commented on GitHub (Feb 10, 2025): @Twilightssuperb Sorry for the delay, @appflowy is on leave at the moment so I can't reach him immediately to get the current status. Apologize again for the inconvenience, could you send us the file again? I will get some other colleague/myself to see if we can recover the database.

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Feb 10, 2025):

@khorshuheng, https://dropmefiles.com/tpCS7 default password is 123

@Twilightssuperb commented on GitHub (Feb 10, 2025): @khorshuheng, https://dropmefiles.com/tpCS7 default password is `123`

mirror commented

Author

Owner

@khorshuheng commented on GitHub (Feb 10, 2025):

@Twilightssuperb Thanks. I have downloaded the file, you may remove the link now.

@khorshuheng commented on GitHub (Feb 10, 2025): @Twilightssuperb Thanks. I have downloaded the file, you may remove the link now.

mirror commented

Author

Owner

@khorshuheng commented on GitHub (Feb 10, 2025):

Based on the file, it appears that the RocksDB data is corrupted - the .sst file is missing. I will research if there are ways to repair the database.

EDITED: In the collab_db_backup there are backup with the .sst file intact. Unfortunately, they can't really be read as database since there is no manifest file. Checking if i can directly read the sst file using RockDB API.

@khorshuheng commented on GitHub (Feb 10, 2025): Based on the file, it appears that the RocksDB data is corrupted - the .sst file is missing. I will research if there are ways to repair the database. EDITED: In the collab_db_backup there are backup with the .sst file intact. Unfortunately, they can't really be read as database since there is no manifest file. Checking if i can directly read the sst file using RockDB API.

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Feb 10, 2025):

@khorshuheng, should I search on PC and attach another files? How to find this manifest file, e.g.?

P.S. Well, there is MANIFEST-000012 file inside collab_db folder.

@Twilightssuperb commented on GitHub (Feb 10, 2025): @khorshuheng, should I search on PC and attach another files? How to find this manifest file, e.g.? P.S. Well, there is `MANIFEST-000012` file inside `collab_db` folder.

mirror commented

Author

Owner

@khorshuheng commented on GitHub (Feb 10, 2025):

@Twilightssuperb While the manifest file exists inside collab_db folder, it can't be used for the data in backup. I tried that, hoping that it would work, but failed.

It's not that you forgot to attach the file, in all likelihood the file wasn't created due to some error / was removed.

In any case, I can find the historical document updates (based on the data on 10th November 2024) in the .sst files in collab_db_backup, and is able to dump the content (in binary format) using the sst_dump tools. Though I will still need to figure out how to read the data via API and reconstruct the document in JSON, if possible. Will need to consult my other colleagues on this.

@khorshuheng commented on GitHub (Feb 10, 2025): @Twilightssuperb While the manifest file exists inside collab_db folder, it can't be used for the data in backup. I tried that, hoping that it would work, but failed. It's not that you forgot to attach the file, in all likelihood the file wasn't created due to some error / was removed. In any case, I can find the historical document updates (based on the data on 10th November 2024) in the .sst files in collab_db_backup, and is able to dump the content (in binary format) using the sst_dump tools. Though I will still need to figure out how to read the data via API and reconstruct the document in JSON, if possible. Will need to consult my other colleagues on this.

mirror commented

Author

Owner

@Twilightssuperb commented on GitHub (Feb 10, 2025):

I can attach something from C:\users\[...]\AppData\Roaming\io.appflowy backup, but I'm not sure that it could clear.

@Twilightssuperb commented on GitHub (Feb 10, 2025): I can attach something from `C:\users\[...]\AppData\Roaming\io.appflowy` backup, but I'm not sure that it could clear.

mirror commented

Author

Owner

@khorshuheng commented on GitHub (Feb 11, 2025):

@Twilightssuperb I was able to recover some documents in it's raw json format, but since i don't understand the language the document is written in, i am not too sure which one is worth recovering and which one aren't. Are you able to join our official discord? I can send you what i have recovered so far, and i will continue trying to see if i can convert them into a more readable format, like markdown/csv.

@khorshuheng commented on GitHub (Feb 11, 2025): @Twilightssuperb I was able to recover some documents in it's raw json format, but since i don't understand the language the document is written in, i am not too sure which one is worth recovering and which one aren't. Are you able to join our official discord? I can send you what i have recovered so far, and i will continue trying to see if i can convert them into a more readable format, like markdown/csv.

mirror commented

Author

Owner

@khorshuheng commented on GitHub (Feb 11, 2025):

@candideu The raw data is stored on the client's machine in RocksDB. If the database is not corrupted, we can use RocksDB API to read the key and values, otherwise, we will need to use sst_dump to get the key and values (or sst reader API, if you know the C language/using a RockDB binding that supports the SST reader API).

The values are in yjs/yrs binary format, which can then be printed as json file - that is the raw format that AppFlowy is using, though it can be converted to markdown/csv/etc .

If i can recover the data for @Twilightssuperb without issue, i will provide the script that i used to recover the data.

@khorshuheng commented on GitHub (Feb 11, 2025): @candideu The raw data is stored on the client's machine in RocksDB. If the database is not corrupted, we can use RocksDB API to read the key and values, otherwise, we will need to use sst_dump to get the key and values (or sst reader API, if you know the C language/using a RockDB binding that supports the SST reader API). The values are in yjs/yrs binary format, which can then be printed as json file - that is the raw format that AppFlowy is using, though it can be converted to markdown/csv/etc . If i can recover the data for @Twilightssuperb without issue, i will provide the script that i used to recover the data.

mirror commented