API missing data after upgrading from 0.5.5 to 0.8.0 #2104
-
|
Hi, We've been using Ory kratos 0.5.5 version in QA Env and Prod. Everything was working fine after some tweaks. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 14 replies
-
|
Thank you for reaching out and I'm so sorry to hear that! This is not normal behaviour from Kratos and should never be a problem. I will investigate and get back to you as soon as possible. There shouldn't be any destructive actions with doing the migrations. The best thing to do is to always have a backup of your database which you can restore from when this happens. Try in your testing environment to upgrade from v0.5.5 to the next major release, e.g. v0.6.x all the way until v0.8.x. |
Beta Was this translation helpful? Give feedback.
-
|
Thank you so much for such a quick reply. Yeah, we lost data in QA, Prod is still fine. |
Beta Was this translation helpful? Give feedback.
-
|
yes in the case of such a major problem. Kratos v0.8 should do the migrations, but if for whatever reason it does not, then doing a manual upgrade might show you which version has a problem or introduced this bug. |
Beta Was this translation helpful? Give feedback.
-
|
Ok, I will try this stair case upgrade in my local and let you know in case I find anything. Thank you |
Beta Was this translation helpful? Give feedback.
-
|
Hello, that sounds horrific! Can you confirm that the database tables are really empty? Or are the APIs returning empty lists? We have a lot of very stable tests that ensure that this can not happen! It is important though that you have never made manual changes to the database. Please also, always when upgrading, read for every version the changelog with immense care: https://github.com/ory/kratos/blob/master/CHANGELOG.md My hunch says that you might have forgotten to run the kratos migrate sql command. Unless your database is truly empty, the data should still be safe & sound! Hope this helps :) |
Beta Was this translation helpful? Give feedback.
-
|
@vinckr can you maybe write an upgrade guide and add it to the docs? |
Beta Was this translation helpful? Give feedback.
-
|
Upgrade guide would be awesome |
Beta Was this translation helpful? Give feedback.
-
|
I added something in this PR #2132 |
Beta Was this translation helpful? Give feedback.
-
|
Awesome. |
Beta Was this translation helpful? Give feedback.
-
|
@vinckr Obviously, you guys are the pros, looks like you covered everything |
Beta Was this translation helpful? Give feedback.
Hello, that sounds horrific! Can you confirm that the database tables are really empty? Or are the APIs returning empty lists? We have a lot of very stable tests that ensure that this can not happen! It is important though that you have never made manual changes to the database.
Please also, always when upgrading, read for every version the changelog with immense care: https://github.com/ory/kratos/blob/master/CHANGELOG.md
My hunch says that you might have forgotten to run the kratos migrate sql command.
Unless your database is truly empty, the data should still be safe & sound! Hope this helps :)