BYK
commented
4 years ago Unfortunately we no longer support MySQL and won't be able to help you resolve this issue.
Closed tzq582905 closed 4 years ago
BYK
commented
4 years ago Unfortunately we no longer support MySQL and won't be able to help you resolve this issue.
Important Details
How are you running Sentry?
On-Premise w/ Docker, version 18.09.0
sentry : 9.1.2-onbuild
Description
docker run -it --rm -e SENTRY_SECRET_KEY=${SECRET_KEY} --link mysql:mysql --link sentry-redis-sql1:redis mysentry upgrade 08:32:37 [WARNING] sentry.utils.geo: settings.GEOIP_PATH_MMDB not configured. 08:32:40 [INFO] sentry.plugins.github: apps-not-configured
Unknown config option found: 'slack.legacy-app' Syncing... Creating tables ... Creating table django_admin_log Creating table auth_permission Creating table auth_group_permissions Creating table auth_group Creating table django_content_type Creating table django_session Creating table django_site Creating table south_migrationhistory Installing custom SQL ... Installing indexes ... Installed 0 object(s) from 0 fixture(s) Migrating... Running migrations for sentry:
! Since you have a database that does not support running ! schema-altering statements in transactions, we have had ! to leave it in an interim state between migrations.
! You might be able to recover with: = DROP TABLE
sentry_sentryappinstallationCASCADE; [] = DROP TABLEsentry_sentryappCASCADE; []no dry run output for delete_foreign_key() due to dynamic DDL, sorry = ALTER TABLE
auth_userDROP COLUMNis_sentry_appCASCADE; []! The South developers regret this has happened, and would ! like to gently persuade you to consider a slightly ! easier-to-deal-with DBMS (one that supports DDL transactions) ! NOTE: The error which caused the migration to fail is further up. Error in migration: sentry:0426_autoadd_sentryappinstallation__add_sentryappadd_field_user_is_sent Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/sentry/receivers/core.py", line 31, in wrapped return func(*args, kwargs) File "/usr/local/lib/python2.7/site-packages/sentry/receivers/core.py", line 50, in create_default_projects verbosity=verbosity, File "/usr/local/lib/python2.7/site-packages/sentry/receivers/core.py", line 96, in create_default_project kwargs File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py", line 157, in create return self.get_queryset().create(*kwargs) File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 322, in create obj.save(force_insert=True, using=self.db) File "/usr/local/lib/python2.7/site-packages/sentry/models/project.py", line 151, in save super(Project, self).save(args, kwargs) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 545, in save force_update=force_update, update_fields=update_fields) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 582, in save_base update_fields=update_fields, raw=raw, using=using) File "/usr/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 185, in send response = receiver(signal=self, sender=sender, named) File "/usr/local/lib/python2.7/site-packages/sentry/receivers/savedsearch.py", line 14, in create_default_saved_searches SavedSearch.objects.create(project=instance, search_kwargs) File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py", line 157, in create return self.get_queryset().create(kwargs) File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 322, in create obj.save(force_insert=True, using=self.db) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 545, in save force_update=force_update, update_fields=update_fields) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 573, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 654, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 687, in _do_insert using=using, raw=raw) File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py", line 232, in _insert return insert_query(self.model, objs, fields, **kwargs) File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 1514, in insert_query return query.get_compiler(using=using).execute_sql(return_id) File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 903, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/sentry_sdk/integrations/django/init.py", line 446, in execute return real_execute(self, 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) File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute return self.cursor.execute(query, args) File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/local/lib/python2.7/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) OperationalError: (1054, u"Unknown column 'organization_id' in 'field list'") 08:36:25 [ERROR] root: Failed processing signal create_default_projects
Steps to Reproduce
执行docker run -it --rm mysentry upgrade