Hi Seb, Are you trying to just transfer the database from one server to another, or are you trying to convert from one type of database to another?
If the former, you'll want to just use your database's standard SQL dump/load commands. For the latter, dumpdb/loaddb just isn't really that useful or reliable these days, and will be going away. Instead, we'll be providing a new tool as part of Power Pack that can export data from your database and import into another, handling different versions of Review Board and different types of databases. It's still in beta testing, so it's not out yet. Christian On Mon, Aug 7, 2017 at 5:31 PM, Sebastian Unger <[email protected]> wrote: > Hi, > > I'm trying to load a DB dump into a new instance of RB, but it's failing. > Here are the steps I'm executing (reproduced with 2.5.14): > > On old machine: > >> >> >> *cd /home/reviewboard/reviewboard.taitradio.net >> <http://reviewboard.taitradio.net>~/.venv/bin/rb-site manage >> ~/reviewboard.taitradio.net <http://reviewboard.taitradio.net> -- dumpdb >> >reviewboard.dump* > > > On new machine (with the .venv having been re-created from a freeze): > >> >> *.venv/bin/rb-site install \ * >> * --noinput \ * >> *--opt-out-support-data \* >> *--domain-name=reviewboard.taitradio.net >> <http://reviewboard.taitradio.net> \* >> *--company=Tait \* >> *--site-root=/ \* >> *--db-type=sqlite3 \* >> *--db-name=reviewboard.db \* >> *--cache-type=memcached \* >> *--cache-info=127.0.0.1:11211 <http://127.0.0.1:11211> \* >> *--web-server-type=lighttpd \* >> *--web-server-port=80 \* >> *--admin-user=ungers \* *--admin-email=reviewboard.admins**<AT>* >> *taitradio.com <http://taitradio.com> \* >> *--sitelist=/home/reviewboard/.sitelist \* >> */home/reviewboard/reviewboard.taitradio.net >> <http://reviewboard.taitradio.net>* > > I believe these options are close to or identical to the ones used to > originally create the site on old machine. > This produces a flurry of activity with no errors (that I can spot). > > Restore media and subversion credentials (from old machine to new machine): > >> >> *rsync -avt --delete >> /home/reviewboard/reviewboard.taitradio.net/htdocs/media/ >> <http://reviewboard.taitradio.net/htdocs/media/> >> reviewboard@testrb:/home/reviewboard/reviewboard.taitradio.net/htdocs/media/ >> <http://reviewboard.taitradio.net/htdocs/media/>**rsync -avt --delete >> /home/reviewboard/reviewboard.taitradio.net/data/.subversion/ >> <http://reviewboard.taitradio.net/data/.subversion/> >> reviewboard@testrb:/home/reviewboard/reviewboard.taitradio.net/data/.subversion/ >> <http://reviewboard.taitradio.net/data/.subversion/>* > > > Then on new machine: > >> >> *cd /home/reviewboard/reviewboard.taitradio.net >> <http://reviewboard.taitradio.net>**~/.venv/bin/rb-site manage >> ~/reviewboard.taitradio.net <http://reviewboard.taitradio.net> -- loaddb >> ~/reviewboard.dump* > > with reviewboard.dump being the file produces on old machine of course. > > This asks me for confirmation and after I type 'yes', produces the > following output (the red highlight is by me): > >> >> *Type 'yes' to continue, or 'no' to cancel: yes* >> *sh: 1: ./reviewboard/manage.py: not found* >> *Importing new style dump format (v1)* >> * [0%]* >> *Error: UNIQUE constraint failed: auth_permission.content_type_id, >> auth_permission.codename* >> *Line 313: '{"pk": 115, "model": "auth.permission", "fields": >> {"codename": "add_registeredextension", "name": "Can add registered >> extension", "content_type": 8}}* >> *'* >> *Error: UNIQUE constraint failed: auth_permission.content_type_id, >> auth_permission.codename* >> *Line 315: '{"pk": 116, "model": "auth.permission", "fields": >> {"codename": "change_registeredextension", "name": "Can change registered >> extension", "content_type": 8}}* >> *'* >> *Error: UNIQUE constraint failed: auth_permission.content_type_id, >> auth_permission.codename* >> *Line 317: '{"pk": 117, "model": "auth.permission", "fields": >> {"codename": "delete_registeredextension", "name": "Can delete registered >> extension", "content_type": 8}}* >> *'* >> *Error: UNIQUE constraint failed: auth_permission.content_type_id, >> auth_permission.codename* >> *Line 400: '{"pk": 112, "model": "auth.permission", "fields": >> {"codename": "add_session", "name": "Can add session", "content_type": 7}}* >> *'* >> *Error: UNIQUE constraint failed: auth_permission.content_type_id, >> auth_permission.codename* >> *Line 402: '{"pk": 113, "model": "auth.permission", "fields": >> {"codename": "change_session", "name": "Can change session", >> "content_type": 7}}* >> *'* >> *Error: UNIQUE constraint failed: auth_permission.content_type_id, >> auth_permission.codename* >> *Line 404: '{"pk": 114, "model": "auth.permission", "fields": >> {"codename": "delete_session", "name": "Can delete session", >> "content_type": 7}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 585: '{"pk": 40, "model": "contenttypes.contenttype", "fields": >> {"model": "webapitoken", "name": "Web API token", "app_label": "webapi"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 586: '{"pk": 14, "model": "contenttypes.contenttype", "fields": >> {"model": "changedescription", "name": "change description", "app_label": >> "changedescs"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 587: '{"pk": 22, "model": "contenttypes.contenttype", "fields": >> {"model": "comment", "name": "comment", "app_label": "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 588: '{"pk": 34, "model": "contenttypes.contenttype", "fields": >> {"model": "contenttype", "name": "content type", "app_label": >> "contenttypes"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 589: '{"pk": 21, "model": "contenttypes.contenttype", "fields": >> {"model": "defaultreviewer", "name": "default reviewer", "app_label": >> "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 590: '{"pk": 17, "model": "contenttypes.contenttype", "fields": >> {"model": "diffset", "name": "diff set", "app_label": "diffviewer"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 591: '{"pk": 18, "model": "contenttypes.contenttype", "fields": >> {"model": "diffsethistory", "name": "diff set history", "app_label": >> "diffviewer"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 592: '{"pk": 33, "model": "contenttypes.contenttype", "fields": >> {"model": "evolution", "name": "evolution", "app_label": >> "django_evolution"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 593: '{"pk": 13, "model": "contenttypes.contenttype", "fields": >> {"model": "fileattachment", "name": "file attachment", "app_label": >> "attachments"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 594: '{"pk": 23, "model": "contenttypes.contenttype", "fields": >> {"model": "fileattachmentcomment", "name": "file attachment comment", >> "app_label": "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 595: '{"pk": 36, "model": "contenttypes.contenttype", "fields": >> {"model": "fileattachmenthistory", "name": "file attachment history", >> "app_label": "attachments"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 596: '{"pk": 16, "model": "contenttypes.contenttype", "fields": >> {"model": "filediff", "name": "file diff", "app_label": "diffviewer"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 599: '{"pk": 19, "model": "contenttypes.contenttype", "fields": >> {"model": "hostingserviceaccount", "name": "hosting service account", >> "app_label": "hostingsvcs"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 600: '{"pk": 37, "model": "contenttypes.contenttype", "fields": >> {"model": "legacyfilediffdata", "name": "legacy file diff data", >> "app_label": "diffviewer"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 601: '{"pk": 31, "model": "contenttypes.contenttype", "fields": >> {"model": "localsite", "name": "local site", "app_label": "site"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 607: '{"pk": 38, "model": "contenttypes.contenttype", "fields": >> {"model": "rawfilediffdata", "name": "raw file diff data", "app_label": >> "diffviewer"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 609: '{"pk": 30, "model": "contenttypes.contenttype", "fields": >> {"model": "repository", "name": "repository", "app_label": "scmtools"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 610: '{"pk": 27, "model": "contenttypes.contenttype", "fields": >> {"model": "review", "name": "review", "app_label": "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 611: '{"pk": 20, "model": "contenttypes.contenttype", "fields": >> {"model": "group", "name": "review group", "app_label": "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 612: '{"pk": 25, "model": "contenttypes.contenttype", "fields": >> {"model": "reviewrequest", "name": "review request", "app_label": >> "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 613: '{"pk": 28, "model": "contenttypes.contenttype", "fields": >> {"model": "reviewrequestdraft", "name": "review request draft", >> "app_label": "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 615: '{"pk": 24, "model": "contenttypes.contenttype", "fields": >> {"model": "screenshot", "name": "screenshot", "app_label": "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 616: '{"pk": 26, "model": "contenttypes.contenttype", "fields": >> {"model": "screenshotcomment", "name": "screenshot comment", "app_label": >> "reviews"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 620: '{"pk": 29, "model": "contenttypes.contenttype", "fields": >> {"model": "tool", "name": "tool", "app_label": "scmtools"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 621: '{"pk": 35, "model": "contenttypes.contenttype", "fields": >> {"model": "trophy", "name": "trophy", "app_label": "accounts"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 623: '{"pk": 32, "model": "contenttypes.contenttype", "fields": >> {"model": "version", "name": "version", "app_label": "django_evolution"}}* >> *'* >> *Error: UNIQUE constraint failed: django_content_type.app_label, >> django_content_type.model* >> *Line 624: '{"pk": 39, "model": "contenttypes.contenttype", "fields": >> {"model": "webhooktarget", "name": "webhook", "app_label": >> "notifications"}}**'* > > It then goes on counting up to 100% without further errors. However, when > I go to one of my reviews (not all of them; the one that is failing is > working fine on old machine), I get this response in my browser: > >> Something broke! (Error 500) >> It appears something broke when you tried to go to here. This is either a >> bug in Review Board or a server configuration error. Please report this to >> your administrator. > > and an email with the following > >> Subject: [Review Board] ERROR (EXTERNAL IP): Internal Server Error: >> /r/4441/ > > Body: >> *Traceback (most recent call last):* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/django/core/handlers/base.py", >> line 112, in get_response** response = wrapped_callback(request, >> *callback_args, **callback_kwargs)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/accounts/decorators.py", >> line 23, in _check** return login_required(view_func)(*args, **kwargs)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py", >> line 22, in _wrapped_view** return view_func(request, *args, **kwargs)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/site/decorators.py", >> line 35, in _check** return view_func(request, local_site=local_site, >> *args, **kwargs)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/reviews/views.py", >> line 781, in review_detail** 'screenshots': screenshots,* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/reviews/context.py", >> line 99, in make_review_request_context** upload_diff_form = >> UploadDiffForm(review_request, request=request)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/reviews/forms.py", >> line 127, in __init__** data, *args, **kwargs)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/diffviewer/forms.py", >> line 41, in __init__** if >> self.repository.get_scmtool().get_diffs_use_absolute_paths():* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/scmtools/models.py", >> line 231, in get_scmtool** return cls(self)* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/scmtools/svn/__init__.py", >> line 69, in __init__** credentials = repository.get_credentials()* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/scmtools/models.py", >> line 284, in get_credentials** password = self.password* >> >> * File >> "/home/reviewboard/.venv/local/lib/python2.7/site-packages/reviewboard/scmtools/models.py", >> line 217, in _get_password** password = >> decrypt_password(password).decode('utf-8')* >> >> * File "/home/reviewboard/.venv/lib/python2.7/encodings/utf_8.py", line >> 16, in decode** return codecs.utf_8_decode(input, errors, True)* >> *UnicodeDecodeError: 'utf8' codec can't decode byte 0x9c in position 1: >> invalid start byte* >> >> >> *<WSGIRequest* >> *path:/r/4441/,* >> *GET:<QueryDict: {}>,* >> *POST:<QueryDict: {}>,* >> *COOKIES:{'_ga': 'GA1.2.1235266689.1499048514',* >> * 'collapsediffs': 'True',* >> * 'csrftoken': '8pm9t2P5xPX9ldMTwjLvPQlzIAQrnueP',* >> * 'rbsessionid': 'xmmblawetns741llcq5yap31tf8l557p'},* >> *META:{'CONTENT_LENGTH': '',* >> * 'CONTENT_TYPE': '',* >> * 'DOCUMENT_ROOT': '/home/reviewboard/reviewboard.taitradio.net/htdocs >> <http://reviewboard.taitradio.net/htdocs>',* >> * 'DOCUMENT_URI': '/r/4441/',* >> * 'GATEWAY_INTERFACE': 'CGI/1.1',* >> * 'HTTP_ACCEPT': >> 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8',* >> * 'HTTP_ACCEPT_ENCODING': 'gzip, deflate',* >> * 'HTTP_ACCEPT_LANGUAGE': >> 'en-GB,en;q=0.8,en-US;q=0.6,de-DE;q=0.4,de;q=0.2',* >> * 'HTTP_CACHE_CONTROL': 'max-age=0',* >> * 'HTTP_CONNECTION': 'keep-alive',* >> * 'HTTP_COOKIE': '_ga=GA1.2.1235266689.1499048514; collapsediffs=True; >> csrftoken=8pm9t2P5xPX9ldMTwjLvPQlzIAQrnueP; >> rbsessionid=xmmblawetns741llcq5yap31tf8l557p',* >> * 'HTTP_HOST': 'testrb.terminals.taitradio.net >> <http://testrb.terminals.taitradio.net>',* >> * 'HTTP_REFERER': >> 'http://testrb.terminals.taitradio.net/account/login/?next=/r/4441/ >> <http://testrb.terminals.taitradio.net/account/login/?next=/r/4441/>',* >> * 'HTTP_UPGRADE_INSECURE_REQUESTS': '1',* >> * 'HTTP_USER_AGENT': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 >> (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36',* >> * 'HTTP_VIA': '1.1 squida.taitradio.net <http://squida.taitradio.net> >> (squid/3.3.8)',* >> * 'HTTP_X_FORWARDED_FOR': '172.16.182.9',* >> * u'LOCAL_SITE': None,* >> * 'PATH_INFO': u'/r/4441/',* >> * 'QUERY_STRING': '',* >> * 'REDIRECT_STATUS': '200',* >> * 'REMOTE_ADDR': '172.25.47.1',* >> * 'REMOTE_PORT': '47212',* >> * 'REQUEST_METHOD': 'GET',* >> * 'REQUEST_SCHEME': 'http',* >> * 'REQUEST_URI': '/r/4441/',* >> * 'SCRIPT_NAME': u'',* >> * 'SERVER_ADDR': '172.26.156.160',* >> * 'SERVER_NAME': 'testrb.terminals.taitradio.net >> <http://testrb.terminals.taitradio.net>',* >> * 'SERVER_PORT': '80',* >> * 'SERVER_PROTOCOL': 'HTTP/1.1',* >> * 'SERVER_SOFTWARE': 'nginx/1.10.3',* >> * u'USERNAME': u'ungers',** u'USER_EMAIL': u'sebastian.unger**<AT>* >> *taitradio.com <http://taitradio.com>',* >> * 'wsgi.errors': <flup.server.fcgi_base.OutputStream object at >> 0x7fbf8fcd5ad0>,* >> * 'wsgi.input': <flup.server.fcgi_base.InputStream object at >> 0x7fbf8fcd55d0>,* >> * 'wsgi.multiprocess': False,* >> * 'wsgi.multithread': True,* >> * 'wsgi.run_once': False,* >> * 'wsgi.url_scheme': 'http',** 'wsgi.version': (1, 0)}>* > > > Any ideas? > > Cheers, > Seb > > -- > 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 > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Christian Hammond President/CEO of Beanbag <https://www.beanbaginc.com/> Makers of Review Board <https://www.reviewboard.org/> -- 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 "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
