Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migration problem with 7.6.2 #1648

Closed
ertrzyiks opened this issue Jul 27, 2015 · 4 comments
Closed

Migration problem with 7.6.2 #1648

ertrzyiks opened this issue Jul 27, 2015 · 4 comments

Comments

@ertrzyiks
Copy link

Hi,

i had fresh (dockerized) installation of sentry 7.6 using postgres and running upgrade command fails with log:

File "/usr/local/lib/python2.7/site-packages/sentry/../south/db/generic.py", line 535, in alter_column
    flatten(values),
  File "/usr/local/lib/python2.7/site-packages/sentry/../south/db/generic.py", line 282, in execute
    cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/site-packages/django/db/utils.py", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column "config" cannot be cast automatically to type jsonb
HINT:  Specify a USING expression to perform the conversion.

Postgres version: 9.4

I downgraded sentry to 7.2.x version and it works well with the same database image.

@dcramer
Copy link
Member

dcramer commented Jul 27, 2015

Is this failing on a migration or on use? If migration can you list which.

@ertrzyiks
Copy link
Author

@dcramer its result of sentry upgrade command run on empty postgres database
when i hit address in browser it says missing project or something like that

it works for sqlite, i dont know how about mysql; i will prepare simple repo to reproduce issue on the evening

@ertrzyiks
Copy link
Author

Example of failing setup: https://github.com/ertrzyiks/sentry-docker

edit:
no such problem with mysql: https://github.com/ertrzyiks/sentry-docker/tree/using-mysql

edit2:
@dcramer it works with postgres 9.2 and 9.3
so problem is with migration 0161_auto__chg_field_authprovider_config on postgres 9.4

@dcramer
Copy link
Member

dcramer commented Jul 28, 2015

pip install django-jsonfield==0.9.13

I'm going to lock it in. I'm not sure why a patch version update breaks things, but either 0.9.14 or 0.9.15 introduced broken behavior.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants