MySQL scheme update issue
Hi, I encountered a Problem while updating the MySQL DB scheme while upgrading from Version 8.4.1.0 to 8.9.15.0.
The scheme update ran fine till version 113 and stopped there, stating that the table TodoUsers is already there.
I reverted my database to the backup I had done before the update. At this point this table wasn't there. So the scheme update creates the table and later on it struggles because it is already there.
I dropped the table TodoUsers after the error occured again and ran the scheme update afterwards and created the table again. The update ran fine than, so I think it should be only an error in the database update script...
Kind regards.
All Comments (3)
I wasn't able to reproduce the error. Started 8.4.1.0, created a new MySQL data base (v1.63), added a few sessions (for fun), closed 8.4.1.0, started 8.9.15, upgrade the database to (v1.116) without issue.
The good news is you got it working on your end.
If someone reproduces the issue please let us know. We will also keep an eye open on our end.
Best regards,
Stéfane Lavergne
Ok, thanks for the answer. Let's hope that it was a special case in our environment... ;)
If possible, please send me your pre-upgraded schema (8.4.1.0), make sure you clear all tables but before double check the value of the DatabaseVersion field of the databaseinfo table (select DatabaseVersion from databaseinfo), the value should be 63.
You can send me the schema via private message or email slavergne @ devolutions.net
If you don't have time, not a big deal. With it I might be able to shed more light on why you had upgrade issues and maybe fix the script for good.
Best regards,
Stéfane Lavergne