[Bug] After software update on windows, all subscriptions topic are gone

[darkodavidovic]

What did I do

Updated the software to 1.9.6

What happened

All topics bellow button "+ New Subscription" are gone

Expected

To stay after update

Environment

• OS: Windows 10 Pro, x64, 22H2
• MQTTX version: v1.9.6

[ysfscream]

@darkodavidovic Thank you for your feedback!

During my testing from upgrading from 1.9.5 to 1.9.6, I was not able to replicate this issue. However, I noticed a similar issue when upgrading from the older 1.9.3 version to 1.9.6. We suspect this might have happened due to an error with the database migration script which utilized TypeORM in an intermediate version.

To help us analyze and resolve this issue more efficiently, could you please share your MQTTX.db file with us?

We are very sorry for the inconvenience this has caused you. Currently, the only solution is to manually re-subscribe to the lost topics. We are working diligently to fix this issue to prevent such problems in future updates.

Thank you again for your feedback, and we look forward to hearing from you.

[darkodavidovic]

@darkodavidovic Thank you for your feedback!

During my testing from upgrading from 1.9.5 to 1.9.6, I was not able to replicate this issue. However, I noticed a similar issue when upgrading from the older 1.9.3 version to 1.9.6. We suspect this might have happened due to an error with the database migration script which utilized TypeORM in an intermediate version.

To help us analyze and resolve this issue more efficiently, could you please share your MQTTX.db file with us?

We are very sorry for the inconvenience this has caused you. Currently, the only solution is to manually re-subscribe to the lost topics. We are working diligently to fix this issue to prevent such problems in future updates.

Thank you again for your feedback, and we look forward to hearing from you.

Hi... :-) So, my suggestion is to store all topics in some xml file or json before you start the upgrade. Those are just list of strings to be imported back in that section. I cant share the db, its empty inside settings. I am doing some refactoring, all topics are removed.

[ysfscream]

I am very sorry to hear that you experienced this issue 😢. Moving forward, we will remind users in the release notes to manually back up their data through the settings before upgrading, as we cannot change already released versions.

We are seriously considering implementing a feature to facilitate the backup of such data in the next release, 1.9.7, to avoid this issue.