Potential dataloss in Memos with Cloudron 8.3.0 upgrade?

[NCKNE]

Just a quick observation: after upgrading from Cloudron 8.2.x to 8.3.0, all data in Memos for my OIDC user has vanished. No problem for me as I was just starting to use it and only had some test data in Memos. Could this be related to the database upgrade of postgresql? Unfortunately, I cannot assist in debugging as I migrated Cloudron to a beefier server (always amazing how simple and elegant that ist!) in the meantime and do not have easy access to the old logs / backups / etc.

[girish]

Strange, shouldn't be. I will initiate a test run in our CI in any case.

[NCKNE]

@girish Thanks for testing. I only had data for one user using OIDC. Another reason might be that the OIDC mapping is not working as before?

[girish]

8.3.0 doesn't have anything other than db upgrades. @NCKNE if you have happen to have a backup, would be interesting to see if you can restore to it.

[NCKNE]

I configured access to the old backups and restored one before the upgrade to 8.3.0. All data is back now! Not sure what happened, but if it doesn't occur in your CI testing it might just have been something strange on my system.

[girish]

The CI atleast passed - https://git.cloudron.io/packages/memos-app/-/merge_requests/8

[andreasdueren]

Just fyi upgrading didn't seem to break anything in my installation.

[NCKNE]

Great! Must have been something on my server then - all good, I was able to restore from a previous backup and it was just test data anyways... Thanks for checking!

[plusone-nick]

I had several apps do the same the last couple of days - when i checked the forums I saw all of the app updates for stuff like: ghost, cal and hedgehog - i ended up restoring and the data was there again not sure what the cause was but the logs were pointing at something with postgres in my instance

[fbartels]

Yes, I had the same issue and posted in https://forum.cloudron.io/topic/13412/8.3.0-postgres-upgrade-failure about it. Looking at the Nextcloud database I came to the realisation that all Postgres Databases were lost during the upgrade, but a restore from before brought these apps back.

[NCKNE]

Oh yeah, I had an issue with Nextcloud as well after the upgrade. Forgot to mention that. Same thing, some table (I think it was oc_appinfo) could not be found. A restore of the backup right before the upgrade fixed that for me as well.
Same for Cal, Outline, Documenso, Linkwarden and Formbricks by the way. The app started but with a fresh database. A restore brought all back.
I am very happy with the great backup/restore concept and automated backups before an upgrade. Works so great.