migrating from 3.0.18 to 4.0.12

[Adam Weremczuk]

Hello,

I have a production server happily running:

Debian 9.13
MySQL 5.7.31
Python 2.7.13
ReviewBoard 3.0.18

I have set up a new machine:

Debian 9.13
MySQL 5.7.34
Python 2.7.13
ReviewBoard 4.0.12

and repeated the initial set up steps. The new site is blank, i.e. has no users' data.

Then I moved the db across as well as the entire /var/www/rb.example.com directory.

Now when I try an upgrade I get:

rb-site upgrade /var/www/rb.example.com

Traceback (most recent call last):
  File "/usr/local/bin/rb-site", line 8, in <module>
    sys.exit(main())
  File "/usr/local/lib/python2.7/dist-packages/reviewboard/cmdline/rbsite.py", line 2995, in main
    command.run(site, options)
  File "/usr/local/lib/python2.7/dist-packages/reviewboard/cmdline/rbsite.py", line 2503, in run
    siteconfig = SiteConfiguration.objects.get_current()
  File "/usr/local/lib/python2.7/dist-packages/djblets/siteconfig/managers.py", line 42, in get_current
    return self.get_for_site_id(Site.objects.get_current().pk)
  File "/usr/local/lib/python2.7/dist-packages/django/contrib/sites/models.py", line 63, in get_current
    return self._get_site_by_id(site_id)
  File "/usr/local/lib/python2.7/dist-packages/django/contrib/sites/models.py", line 35, in _get_site_by_id
    site = self.get(pk=site_id)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 380, in get
    self.model._meta.object_name
django.contrib.sites.models.DoesNotExist: Site matching query does not exist.

Please advise.

Regards,
Adam

[David Trowbridge]

It sounds like perhaps you imported the data from a 3.0.18 database into the database schema of 4.0.2

You'll want to drop the database entirely, import the dump, then run the rb-site upgrade command.

--
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/CALC-DAHCBhJttHmOHVE4abUbjg3x7i81a8JP9QQ%2B_3kr74FLOA%40mail.gmail.com.

[Adam Weremczuk]

Hi David,

No, I dropped the 4.0.12 empty database and imported a dump of 3.0.18

3.0.18 source:

mysqldump -h localhost -u root -p -d reviewboard > /tmp/reviewboard.sql

scp to destination

4.0.12 destination:

sudo mysql -h localhost -u root -p

mysql> DROP DATABASE reviewboard;
Query OK, 82 rows affected (0.26 sec)

mysql> CREATE DATABASE reviewboard;
Query OK, 1 row affected (0.00 sec)

mysql> quit
Bye

sudo mysql -h localhost -u root -p reviewboard < /tmp/reviewboard.sql

mysql> USE reviewboard;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SHOW TABLES;
+------------------------------------------------------+
| Tables_in_reviewboard                                |
+------------------------------------------------------+
| accounts_localsiteprofile                            |
| accounts_profile                                     |
| accounts_profile_starred_groups                      |
| accounts_profile_starred_review_requests             |
| accounts_reviewrequestvisit                          |
| accounts_trophy                                      |
| attachments_fileattachment                           |
| attachments_fileattachmenthistory                    |
| auth_group                                           |
| auth_group_permissions                               |
| auth_permission                                      |
| auth_user                                            |
| auth_user_groups                                     |
| auth_user_user_permissions                           |
| changedescs_changedescription                        |
| corsheaders_corsmodel                                |
| diffviewer_diffset                                   |
| diffviewer_diffsethistory                            |
| diffviewer_filediff                                  |
| diffviewer_filediffdata                              |
| diffviewer_rawfilediffdata                           |
| django_admin_log                                     |
| django_content_type                                  |
| django_evolution                                     |
| django_project_version                               |
| django_session                                       |
| django_site                                          |
| djblets_privacy_storedconsentdata                    |
| extensions_registeredextension                       |
| hostingsvcs_hostingserviceaccount                    |
| integrations_integrationconfig                       |
| notifications_webhooktarget                          |
| notifications_webhooktarget_repositories             |
| oauth2_provider_accesstoken                          |
| oauth2_provider_application                          |
| oauth2_provider_grant                                |
| oauth2_provider_refreshtoken                         |
| reviewboard_oauth_application                        |
| reviews_comment                                      |
| reviews_defaultreviewer                              |
| reviews_defaultreviewer_groups                       |
| reviews_defaultreviewer_people                       |
| reviews_defaultreviewer_repository                   |
| reviews_fileattachmentcomment                        |
| reviews_generalcomment                               |
| reviews_group                                        |
| reviews_group_users                                  |
| reviews_review                                       |
| reviews_review_comments                              |
| reviews_review_file_attachment_comments              |
| reviews_review_general_comments                      |
| reviews_review_screenshot_comments                   |
| reviews_reviewrequest                                |
| reviews_reviewrequest_changedescs                    |
| reviews_reviewrequest_depends_on                     |
| reviews_reviewrequest_file_attachment_histories      |
| reviews_reviewrequest_file_attachments               |
| reviews_reviewrequest_inactive_file_attachments      |
| reviews_reviewrequest_inactive_screenshots           |
| reviews_reviewrequest_screenshots                    |
| reviews_reviewrequest_target_groups                  |
| reviews_reviewrequest_target_people                  |
| reviews_reviewrequestdraft                           |
| reviews_reviewrequestdraft_depends_on                |
| reviews_reviewrequestdraft_file_attachments          |
| reviews_reviewrequestdraft_inactive_file_attachments |
| reviews_reviewrequestdraft_inactive_screenshots      |
| reviews_reviewrequestdraft_screenshots               |
| reviews_reviewrequestdraft_target_groups             |
| reviews_reviewrequestdraft_target_people             |
| reviews_screenshot                                   |
| reviews_screenshotcomment                            |
| reviews_statusupdate                                 |
| scmtools_repository                                  |
| scmtools_repository_review_groups                    |
| scmtools_repository_users                            |
| scmtools_tool                                        |
| site_localsite                                       |
| site_localsite_admins                                |
| site_localsite_users                                 |
| siteconfig_siteconfiguration                         |
| webapi_webapitoken                                   |
+------------------------------------------------------+
82 rows in set (0.00 sec)

Regards,
Adam

To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/CAFS3VNUNrmPpBsenQAe%3DduUU%2B1vPtDAkwpcv_jiBsU1LAY5rCA%40mail.gmail.com.