Version Version 2.1-M1 in Debian jessie main repo downgrade DB schema

Started by lucablanc, November 08, 2016, 04:36:25 PM

Previous topic - Next topic

lucablanc

Hi all,
did you expect version 2.1-M1 (still BETA) is in Debian Jessie Main repository?

I upgraded my Debian and now all my client report "Server uses incompatible version of communication protocol" because now my server is running version 2.1-M1

I downgraded to 2.0.6 but now there is a mismatch of DB schema version: current is 415 expected is 404.

How can I fix it?

Thanks


Alex Kirhenshtein

Hello.

No, it was a mistake. I cleaned up repo.

Regarding schema downgrade - we are looking into this.
Do you use table DCIs? (they are converted to new format in 2.1 and will require some efforts to convert them back)

lucablanc

Hi Alex,


I just set the SchemaVersion value to the expected one but it's not enough.
I lost some devices from my maps.


Probably I need to downgrade DCI table.


I can test, if you have some suggestion; my installation is only to evaluate NETXMS, so I can destroy the DB; even if I would like to fix the situation to save my config.


Waiting forward for your suggestions.

Alex Kirhenshtein

It will be really tricky. Possible, but tricky.
I suggest you to keep 2.1-M1, if possible. Despite "beta" state, it's stable and we already have couple of customers running this version in production.

Alex Kirhenshtein

Yes, it's not enough to change version - we need to undo all changes to the schema.

What do you mean, you lost devices from the map? Network map? Do you still have devices in in the system (can you find them in object browser)?

lucablanc