mirror of
https://github.com/AppFlowy-IO/AppFlowy.git
synced 2026-03-24 04:46:56 +00:00
[GH-ISSUE #7872] [Bug] data lost after launching 0.9.0 #3452
Labels
No labels
2024
2025
2026
acct mgmt
AI
automation
bug
calendar
ci
CJK
cloud
code-block
collaboration
copy-paste
database
data migration
data sync
deploy
desktop
develop
develop
documentation
duplicate
editor
editor-plugin
emoji
export
files
flutter-only
follow-up
formula
good first issue for devs
good first issue for experienced devs
grid
hacktoberfest
HACKTOBERFEST-ACCEPTED
help wanted
i18n
icons
images
importer
improvements
infra
install
integrations
IR
kanban board
login
look and joy
mentorship
mobile
mobile
needs design
new feature
new feature
non-coding
notes
notifications
onboarding
organization
P0+
permission
platform-linux
platform-mac
platform-windows
plugins
program
pull-request
Q1 25
Q1 26
Q2 24
Q2 25
Q3 24
Q3 25
Q4 24
Q4 25
react
regression
rust
rust
Rust-only
Rust-only
Rust-starter
Rust-starter
self-hosted
shortcuts
side panel
slash-menu
sync v2
table
tablet
task
tauri
templates
tests
themes
translation
v0.5.6
v0.5.8
v0.5.9
v0.6.0
v0.6.1
v0.6.4
v0.6.7
v0.6.8
v0.7.1
v0.7.4
v0.7.4
v0.7.5
v0.7.6
v0.7.7
v0.7.8
v0.8.0
v0.8.4
v0.8.5
v0.8.9
web
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
AppFlowy-IO/AppFlowy#3452
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @alyvusal on GitHub (Apr 30, 2025).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7872
Bug Description
After opening new version, in data folder new fodler created 453927902086434816, but old fodler was 347750474297905152. Can not use my data, looks I lost it. help to resolve it please
How to Reproduce
use new version
Expected Behavior
open existing data
Operating System
ubuntu 24.10
AppFlowy Version(s)
0.9.0
Screenshots
No response
Additional Context
No response
@Thrilleratplay commented on GitHub (May 1, 2025):
Same. I am unable to import data from the existing AppFlowy data directory and when trying to switch the data directory, it creates two directories called
AppFlowyDataDoNotRenameandAppFlowyDataDoNotRename_beta.appflowy.cloud@ancion commented on GitHub (May 1, 2025):
same problem
@jay7x commented on GitHub (May 1, 2025):
Got the same behavior. I'd suggest to backup your data directory immediately just in case. I don't believe your data is lost (yet).
@annieappflowy commented on GitHub (May 1, 2025):
We're looking into this issue. As long as you have these data folders, your data is safe and can be recovered.
@jay7x commented on GitHub (May 1, 2025):
⚠ Do not try this until asked by developers!!! ⚠
@annieappflowy FYI, I was able got get access to my data once by switching to Local in the Cloud Settings and restarting the app (on MacOS). Though, cannot reproduce it again after restoring from backup.
@appflowy commented on GitHub (May 1, 2025):
@jay7x Thanks. I will try to reproduce
@jay7x commented on GitHub (May 1, 2025):
⚠ Do not try this until asked by developers!!! ⚠
@appflowy reproduced! See the steps below.
NOTES:
Steps:
349...in my case).@alyvusal commented on GitHub (May 1, 2025):
already tried it, it always fails. tried to import for root fodler of data folder, also from AppFlowyDataDoNotRename and also from 347750474297905152, all fails
also tried suggested by @jay7x, cannot restore data
@LucasXu0 commented on GitHub (May 1, 2025):
@alyvusal Did you backup your original data?
@alyvusal commented on GitHub (May 1, 2025):
yes fortunately, my data folder name inside AppFlowyDataDoNotRename fodler is 347750474297905152, but app creates new one
@LucasXu0 commented on GitHub (May 1, 2025):
We've addressed the issue and will release version v0.9.1.
If you have the original data folder 347750474297905152 and the cache.db file, we can help you recover your data. By the way, could you share your cache.db file with me so I can check the session key inside it? @alyvusal
@LucasXu0 commented on GitHub (May 1, 2025):
Could you compress your data folder and email it to me(lucas.xu@appflowy.io)? I'll modify the cache.db file and send it back.
@alyvusal commented on GitHub (May 1, 2025):
data folder contains sensitive data, cache.db attached already (deleted attached file after restore was successfull)
I tried to restore from session backup table but not worked.
@alyvusal commented on GitHub (May 1, 2025):
After opening and closing many times, try restore, this time opened new UI and showed to use anonymous mode. I imported from that windows and set my data folder, now it is ok, I see my data. But I did not got how this resolved
@Dialga commented on GitHub (May 1, 2025):
same problem, following
@alyvusal commented on GitHub (May 2, 2025):
did not observe this issue on 0.9.1
@khorshuheng commented on GitHub (May 2, 2025):
For users who are affected by this issue, install version 0.9.1, then execute the following SQL script on cache.db (directly under the data folder, which should be in the form of <data_......>, before running the application.
This database is in sqlite3 format. So you will need to install sqlite3, before you can run the above script, either using the command line (run sqlite3 cache.db in the terminal, after navigating to the directory) or some graphical tools for sqlite3.
Once the change has been executed, verify that the database row has been updated. Then run AppFlowy 0.9.1.
@daiyongqiang commented on GitHub (May 2, 2025):
Please help me! I lost data also. I have sent an email to you. I hope for your replay.
@ancion commented on GitHub (May 3, 2025):
How to recover my data! I updated 0.9.1, still show me a new workspace.
@tio-trom commented on GitHub (May 3, 2025):
In the meantime if you can restore to 0.8.8-1 and restore your app settings folder and database folder. That is what I did to get back my notes. The solution @khorshuheng posted did not work for me...
@khorshuheng commented on GitHub (May 3, 2025):
If you have upgraded to 0.9.0 before, you need to follow this guide to restore your data, on top of downloading 0.9.1:
https://github.com/AppFlowy-IO/AppFlowy/issues/7872#issuecomment-2847238877
@khorshuheng commented on GitHub (May 3, 2025):
Are there any issue if you upgrade from 0.8.8-1 to 0.9.1 directly? (Just in case, keep a backup of the entire data directory)
@tio-trom commented on GitHub (May 3, 2025):
Unfortunately yes same issues...
Had to restore to 0.8.8-1.
And after doing that I had to remove then replace both folders for the app's settings and database. So a complete restore. Else same issue....I guess the new versions of the app are modifying files in both the storage folder and the app settings.
@khorshuheng commented on GitHub (May 3, 2025):
Upgrading from 0.8.x to 0.9.0 does cause this issue, and can only be fixed by upgrading to 0.9.1 and also execute the SQL script above before launching 0.9.1.
0.8.x to be 0.9.1 (not 0.9.0) direct upgrade should be fine, however, without the need of executing the SQL script. If that is not the case, do let us know.
@tio-trom commented on GitHub (May 3, 2025):
I see, I may give that another try. Do you think this can be fixed upstream and we can upgrade without having to manually do this database tweak? I suppose most users of this app will be very confused by manually having to fix the database.
@khorshuheng commented on GitHub (May 3, 2025):
That's true, though at the same time, we have not been able to find a good way to do so. (Eg. The script above should not be executed for users who upgrade directly from 0.8.x to 0.9.1. Also not applicable for users who don't use anonymous mode) If we are able to, we will include this upstream. For the time being, do give the above SQL script a try. And for users who are still not able to fix this, they can send their data directory (or just cache.db, which doesn't contain the actual data) to us.
@ancion commented on GitHub (May 3, 2025):
which cache
It must be first launch 0.9.1 ? I had already launched 0.9.1 and generate new data fold, which
cache.dbfile should be use d to execute sql.@khorshuheng commented on GitHub (May 3, 2025):
The cache.db that is at the same directory as the log files. The other cache.db are generated when you try to run the import function but failed.
@Thrilleratplay commented on GitHub (May 4, 2025):
I was able to recover my data with version 0.9.1with copying/moving directories and importing. This was attempting various suggestions commented here and to see how the new directory structure worked verse a copy I made after upgrading to 0.9.0, because this was random trial and error, I am not sure how to reproduce this.
@tio-trom commented on GitHub (May 5, 2025):
Updated from 0.8.8-1 to 0.9.1-2. Did the SQL command. Opened Appflowy same issue. Had to restore...
@naheux commented on GitHub (May 6, 2025):
I updated to 0.9.1 directly from 0.8+(forgot exact version) and met this issue after launching, solved it with sqlite3 script. Save my life!!!
@gzsombor commented on GitHub (May 6, 2025):
I upgraded from 0.8.8 to 0.9.1 and all of my pages are disappeared. I had to run this query on a couple of cache.db file and switch between various folders until I noticed that I had to pick
$HOME/Documents/AppFlowyas the file storage folder and not$HOME/Documents/AppFlowy/AppFlowyDataDoNotRename_aHR0cHM6Ly9iZXRhLmFwcGZsb3d5LmNsb3Vk/AppFlowyDataDoNotRename_beta.appflowy.cloud/455963427169374208where my fixed cache.db was originally. Most confusing is that now AppFlowy displays this long path as a storage folder (even though I set to the short one).It would be nice to see an explanation how this folder is actually used and why it is updated, etc
@henri9813 commented on GitHub (May 6, 2025):
Hello,
now we have the auto-updater which works nicely, why doesn’t prevent direct version upgrade but force all intermediate version to avoid upgrade which can « skip » important migrations, at this time, we talk about 0.8.8 to 0.9.1, but what will happen when a user will move from 0.9.1 to 0.1350.0 with potentially breaking change ? it will make the maintenance harder to maintain all upgrade way.
For example, i think gitlab’s way is great, you must follow all intermediate upgrade to ensure all migrations works nicely and avoid weird operations.
@mikawudi commented on GitHub (May 7, 2025):
same problem(0.8.8->0.9.1)....and any easy way to record my data?
@LucasXu0 commented on GitHub (May 8, 2025):
@mikawudi did you customize the storage path or keep using the default path?
@annieappflowy commented on GitHub (Jun 12, 2025):
Feel free to reopen if you need further assistance for this bug.