Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 3486 by drzo...@gmail.com: Upgrade 2.0 to 2.0.3 fails
http://code.google.com/p/reviewboard/issues/detail?id=3486

What version are you running?
2.0

What's the URL of the page containing the problem?
All, unable to access after upgrade. See log below.

What steps will reproduce the problem?
1. easy_install --index-url=https://pypi.mycopany.com -U ReviewBoard
2.  rb-site upgrade /srv/reviewboard-env/reviewboard.mycompany/
3.

What is the expected output? What do you see instead?
Expect: no error.

Actual: output of running rb-site upgrade:
Rebuilding directory structure
Updating database. This may take a while.

The log output below, including warnings and errors,
can be ignored unless upgrade fails.

------------------ <begin log output> ------------------
Creating tables ...
Upgrading Review Board from 2.0 to 2.0.3
There are unapplied evolutions for accounts.
There are unapplied evolutions for scmtools.
Project signature has changed - an evolution is required
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
CommandError: Error applying evolution: constraint "scmtools_repository_df00fa5c" of relation "scmtools_repository" does not exist


When Accessing review board I get this:
Traceback (most recent call last):

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/core/handlers/base.py", line 88, in get_response
    response = middleware_method(request)

File "/srv/reviewboard-env/lib/python2.6/site-packages/ReviewBoard-2.0.3-py2.6.egg/reviewboard/accounts/middleware.py", line 14, in process_request
    user = request.user.get_profile()

File "/srv/reviewboard-env/lib/python2.6/site-packages/ReviewBoard-2.0.3-py2.6.egg/reviewboard/accounts/models.py", line 284, in _get_profile
    self._profile = Profile.objects.get(user=self)

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/manager.py", line 151, in get
    return self.get_queryset().get(*args, **kwargs)

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/query.py", line 304, in get
    num = len(clone)

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/query.py", line 77, in __len__
    self._fetch_all()

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/query.py", line 857, in _fetch_all
    self._result_cache = list(self.iterator())

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/query.py", line 220, in iterator
    for row in compiler.results_iter():

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/sql/compiler.py", line 713, in results_iter
    for rows in self.execute_sql(MULTI):

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/models/sql/compiler.py", line 786, in execute_sql
    cursor.execute(sql, params)

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/utils.py", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/usr/lib/python2.6/site-packages/Django-1.6.5-py2.6.egg/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)

ProgrammingError: column accounts_profile.should_send_email does not exist
LINE 1: ..._id", "accounts_profile"."first_time_setup_done", "accounts_...

What operating system are you using? What browser?


Please provide any additional information below.
Some info from our reviewdatabase. The scmtools_repository_df00fa5c constrain is an index, and it seems to exist:


reviewboard=> \dS+ scmtools_repository
Table "public.scmtools_repository" Column | Type | Modifiers | Storage | Stats target | Description
--------------------+------------------------+------------------------------------------------------------------+----------+--------------+-------------
id | integer | not null default nextval('scmtools_repository_id_seq'::regclass) | plain | | name | character varying(64) | not null | extended | | path | character varying(255) | not null | extended | | mirror_path | character varying(255) | not null | extended | | raw_file_url | character varying(255) | not null | extended | | username | character varying(32) | not null | extended | | password | character varying(128) | not null | extended | | tool_id | integer | not null | plain | | bug_tracker | character varying(256) | not null | extended | | encoding | character varying(32) | not null | extended | | visible | boolean | not null | plain | | local_site_id | integer | | plain | | public | boolean | not null | plain | | extra_data | text | | extended | | hosting_account_id | integer | | plain | |
Indexes:
    "scmtools_repository_pkey" PRIMARY KEY, btree (id)
    "scmtools_repository_97c59b73" UNIQUE, btree (name, local_site_id)
    "scmtools_repository_df00fa5c" UNIQUE, btree (path, local_site_id)
    "scmtools_repository_hosting_account_id" btree (hosting_account_id)
    "scmtools_repository_local_site_id" btree (local_site_id)
    "scmtools_repository_tool_id" btree (tool_id)
Foreign-key constraints:
"scmtools_repository_hosting_account_id_fkey" FOREIGN KEY (hosting_account_id) REFERENCES hostingsvcs_hostingserviceaccount(id) DEFERRABLE INITIALLY DEFERRED "scmtools_repository_local_site_id_fkey" FOREIGN KEY (local_site_id) REFERENCES site_localsite(id) DEFERRABLE INITIALLY DEFERRED "scmtools_repository_tool_id_fkey" FOREIGN KEY (tool_id) REFERENCES scmtools_tool(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
TABLE "attachments_fileattachment" CONSTRAINT "attachments_fileattachment_repository_id_fkey" FOREIGN KEY (repository_id) REFERENCES scmtools_repository(id) DEFERRABLE INITIALLY DEFERRED TABLE "scmtools_repository_users" CONSTRAINT "repository_id_refs_id_2600c334" FOREIGN KEY (repository_id) REFERENCES scmtools_repository(id) DEFERRABLE INITIALLY DEFERRED TABLE "diffviewer_diffset" CONSTRAINT "repository_id_refs_id_7acd9d8c" FOREIGN KEY (repository_id) REFERENCES scmtools_repository(id) DEFERRABLE INITIALLY DEFERRED TABLE "reviews_defaultreviewer_repository" CONSTRAINT "repository_id_refs_id_8161d2ae" FOREIGN KEY (repository_id) REFERENCES scmtools_repository(id) DEFERRABLE INITIALLY DEFERRED TABLE "reviews_reviewrequest" CONSTRAINT "repository_id_refs_id_a7582d83" FOREIGN KEY (repository_id) REFERENCES scmtools_repository(id) DEFERRABLE INITIALLY DEFERRED TABLE "scmtools_repository_review_groups" CONSTRAINT "repository_id_refs_id_c6cc1927" FOREIGN KEY (repository_id) REFERENCES scmtools_repository(id) DEFERRABLE INITIALLY DEFERRED
Has OIDs: no

--
You received this message because this project is configured to send all issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

--
You received this message because you are subscribed to the Google Groups 
"reviewboard-issues" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard-issues+unsubscr...@googlegroups.com.
To post to this group, send email to reviewboard-issues@googlegroups.com.
Visit this group at http://groups.google.com/group/reviewboard-issues.
For more options, visit https://groups.google.com/d/optout.

Reply via email to