ReviewBoard upgrade database migration issue

[From Boston]

Hello,

We are currently at Review Board 3.0.19.2. We are trying to update to the 5.0.6 version.

We were able to install 5.0.6 and make it work following the instructions.

Then we dumped MySQL data from 3 to 5.

Then we used 'rb-site upgrade' command to migrate.

We go following error:

Review Board cannot update your database. There is a discrepancy between the state of your database and what Review Board expects.

    This could be caused by manual changes to your database schema, corruption, an incomplete upgrade, or missing database upgrade history (stored in the django_project_version, django_evolution, and
    django_migrations tables).

upon checking the site-upgrade-failure.log, I see this error:

Database upgrade failure log
Time: 2023-11-02 21:09:17.700299 UTC

Database
========

!! Failed to fetch connection params: '<' not supported between instances of 'type' and 'type'

I would appreciate any help. I really appreciate any help you can provide.

Thanks

[Christian Hammond]

Hi,

You'll need to make sure that you have completely wiped the new database before importing the old database in. If there's any Review Board 5 schema still sitting around when importing Review Board 3, it will fail. You'll want to fully re-create the database prior to import.

The error message unfortunately isn't very helpful, and I'm not sure what's going on there, but there should be errors following that.

Worth noting, we never put out a 3.0.19.2 release, so there may be some in-house customizations involved here that could have affected the upgrade process. It'd help to know what modifications may have been made internally.

If the above guidance doesn't help you get through the upgrade, we do offer database repair services as part of a Premium Support contract, where we'll work with you to resolve any database issues (patching schema or upgrade state as necessary, or providing custom builds) to get you through the upgrade and to help address any other issues that come up. Outside of that, we can't fix any database schema issues, but hopefully the failure is just due to not re-creating the database prior to import.

Christian

--
Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups "Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/1e626ce7-6e28-4364-94e8-beb36069e508n%40googlegroups.com.

--

Christian Hammond

President/CEO of Beanbag

Makers of Review Board