Sentry költöztetés

Adatbázis: SQL, XML DB

Sziasztok

Adott egy szerveren egy régi Sentry 9.1.2 telepítés, snap store-ból, külön postgres DB-vel. 
Ezt el kellene költöztetnem az új self-hosted dockeres rendszerbe egy új szerverre. Régi szerveren pg_dumpall-al kiexportáltam a DB-t, majd az új szerverre a régi 9.1.2-est próbáltam életre kelteni. 
psql -U postgres < backup.sql parancsot próbáltam, látszólag be is megy minden, viszont amint utána indítok egy docker-compose up-ot, vagy nem bír elindulni, mert a db-ben nem talál meg dolgokat. Ha migrationt vagy a ./install.sh-t futtatom le, akkor pedig tisztán indul, mintha be sem importáltam volna.
Ilyet csinált már valaki? Mit ronthatok el?

  • 314 megtekintés
postgres_1   | 2023-04-18 20:11:56.766 UTC [28] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-18 20:11:56.766 UTC [28] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-18 20:11:56.766 UTC [27] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-18 20:11:56.766 UTC [27] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-18 20:11:56.766 UTC [26] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-18 20:11:56.766 UTC [26] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-18 20:11:57.145 UTC [26] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-18 20:11:57.145 UTC [26] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'github.apps-install-url'
postgres_1   | 2023-04-18 20:11:57.145 UTC [28] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-18 20:11:57.145 UTC [28] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'github.apps-install-url'

Ilyeneket kapok docker-compose up után. Előtte a postgres import lefutott hiba nélkül.

Megpróbáltam, sajnos ugyanaz történik így is:

 

root@sentry:/home/sentry/self-hosted-9.1.2# docker-compose up
Starting self-hosted-912_smtp_1      ... done
Starting self-hosted-912_postgres_1  ... done
Starting self-hosted-912_memcached_1 ... done
Starting self-hosted-912_redis_1     ... done
Starting self-hosted-912_cron_1      ... done
Starting self-hosted-912_worker_1    ... done
Starting self-hosted-912_web_1       ... done
Attaching to self-hosted-912_memcached_1, self-hosted-912_redis_1, self-hosted-912_smtp_1, self-hosted-912_postgres_1, self-hosted-912_cron_1, self-hosted-912_worker_1, self-hosted-912_web_1
redis_1      | 1:C 20 Apr 09:19:03.097 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1      |                 _._
redis_1      |            _.-``__ ''-._
redis_1      |       _.-``    `.  `_.  ''-._           Redis 3.2.12 (00000000/0) 64 bit
redis_1      |   .-`` .-```.  ```\/    _.,_ ''-._
redis_1      |  (    '      ,       .-`  | `,    )     Running in standalone mode
redis_1      |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 6379
redis_1      |  |    `-._   `._    /     _.-'    |     PID: 1
redis_1      |   `-._    `-._  `-./  _.-'    _.-'
redis_1      |  |`-._`-._    `-.__.-'    _.-'_.-'|
redis_1      |  |    `-._`-._        _.-'_.-'    |           http://redis.io
redis_1      |   `-._    `-._`-.__.-'_.-'    _.-'
redis_1      |  |`-._`-._    `-.__.-'    _.-'_.-'|
redis_1      |  |    `-._`-._        _.-'_.-'    |
redis_1      |   `-._    `-._`-.__.-'_.-'    _.-'
redis_1      |       `-._    `-.__.-'    _.-'
redis_1      |           `-._        _.-'
redis_1      |               `-.__.-'
redis_1      |
redis_1      | 1:M 20 Apr 09:19:03.098 # Server started, Redis version 3.2.12
redis_1      | 1:M 20 Apr 09:19:03.098 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1      | 1:M 20 Apr 09:19:03.098 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1      | 1:M 20 Apr 09:19:03.099 * DB loaded from disk: 0.000 seconds
redis_1      | 1:M 20 Apr 09:19:03.099 * The server is now ready to accept connections on port 6379
postgres_1   |
postgres_1   | PostgreSQL Database directory appears to contain a database; Skipping initialization
postgres_1   |
postgres_1   | 2023-04-20 09:19:03.362 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres_1   | 2023-04-20 09:19:03.362 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres_1   | 2023-04-20 09:19:03.364 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
smtp_1       |    10 LOG: MAIN
smtp_1       |    10   exim 4.92 daemon started: pid=10, no queue runs, listening for SMTP on port 25 (IPv6 and IPv4)
postgres_1   | 2023-04-20 09:19:03.376 UTC [26] LOG:  database system was shut down at 2023-04-20 09:18:53 UTC
postgres_1   | 2023-04-20 09:19:03.380 UTC [1] LOG:  database system is ready to accept connections
cron_1       | 09:19:04 [WARNING] sentry.utils.geo: settings.GEOIP_PATH_MMDB not configured.
web_1        | 09:19:04 [WARNING] sentry.utils.geo: settings.GEOIP_PATH_MMDB not configured.
worker_1     | 09:19:04 [WARNING] sentry.utils.geo: settings.GEOIP_PATH_MMDB not configured.
postgres_1   | 2023-04-20 09:19:07.089 UTC [33] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.089 UTC [33] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.118 UTC [34] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.118 UTC [34] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.134 UTC [35] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.134 UTC [35] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.460 UTC [33] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.460 UTC [33] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'github.apps-install-url'
cron_1       | 09:19:07 [INFO] sentry.plugins.github: apps-not-configured
postgres_1   | 2023-04-20 09:19:07.463 UTC [33] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.463 UTC [33] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.486 UTC [33] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.486 UTC [33] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
web_1        | 09:19:07 [INFO] sentry.plugins.github: apps-not-configured
postgres_1   | 2023-04-20 09:19:07.494 UTC [34] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.494 UTC [34] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'github.apps-install-url'
postgres_1   | 2023-04-20 09:19:07.497 UTC [34] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.497 UTC [34] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.519 UTC [35] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.519 UTC [35] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'github.apps-install-url'
worker_1     | 09:19:07 [INFO] sentry.plugins.github: apps-not-configured
postgres_1   | 2023-04-20 09:19:07.520 UTC [34] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.520 UTC [34] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.522 UTC [35] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.522 UTC [35] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
postgres_1   | 2023-04-20 09:19:07.554 UTC [35] ERROR:  relation "sentry_option" does not exist at character 114
postgres_1   | 2023-04-20 09:19:07.554 UTC [35] STATEMENT:  SELECT "sentry_option"."id", "sentry_option"."key", "sentry_option"."value", "sentry_option"."last_updated" FROM "sentry_option" WHERE "sentry_option"."key" = 'system.url-prefix'
web_1        | *** Starting uWSGI 2.0.18 (64bit) on [Thu Apr 20 09:19:07 2023] ***
web_1        | compiled with version: 6.3.0 20170516 on 19 October 2019 09:00:01
web_1        | os: Linux-5.15.0-69-generic #76-Ubuntu SMP Fri Mar 17 17:19:29 UTC 2023
web_1        | nodename: 446e965e6cb1
web_1        | machine: x86_64
web_1        | clock source: unix
web_1        | detected number of CPU cores: 12
web_1        | current working directory: /usr/src/sentry
web_1        | detected binary path: /usr/local/bin/uwsgi
web_1        | !!! no internal routing support, rebuild with pcre support !!!
web_1        | your memory page size is 4096 bytes
web_1        | detected max file descriptor number: 1048576
web_1        | lock engine: pthread robust mutexes
root@sentry:/home/sentry# docker exec -it e251ad8b85aa bash
root@e251ad8b85aa:/# psql -U postgres
psql (10.16 (Debian 10.16-1.pgdg90+1))
Type "help" for help.

postgres=# \dt
Did not find any relations.
postgres=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# \c sentry
You are now connected to database "sentry" as user "postgres".
sentry=# \lt
Invalid command \lt. Try \? for help.
sentry=# \dt
                        List of relations
 Schema |                  Name                  | Type  | Owner
--------+----------------------------------------+-------+-------
 public | auth_authenticator                     | table | root
 public | auth_group                             | table | root
 public | auth_group_permissions                 | table | root
 public | auth_permission                        | table | root
 public | auth_user                              | table | root
 public | django_admin_log                       | table | root
 public | django_content_type                    | table | root
 public | django_session                         | table | root
 public | django_site                            | table | root
 public | jira_ac_tenant                         | table | root
 public | nodestore_node                         | table | root
 public | sentry_activity                        | table | root
 public | sentry_apiapplication                  | table | root
 public | sentry_apiauthorization                | table | root
 public | sentry_apigrant                        | table | root
 public | sentry_apikey                          | table | root
 public | sentry_apitoken                        | table | root
 public | sentry_assistant_activity              | table | root
 public | sentry_auditlogentry                   | table | root
 public | sentry_authidentity                    | table | root
 public | sentry_authprovider                    | table | root
 public | sentry_authprovider_default_teams      | table | root
 public | sentry_broadcast                       | table | root
 public | sentry_broadcastseen                   | table | root
 public | sentry_commit                          | table | root
 public | sentry_commitauthor                    | table | root
 public | sentry_commitfilechange                | table | root
 public | sentry_dashboard                       | table | root
 public | sentry_deletedorganization             | table | root
 public | sentry_deletedproject                  | table | root
 public | sentry_deletedteam                     | table | root
 public | sentry_deploy                          | table | root
 public | sentry_discoversavedquery              | table | root
 public | sentry_discoversavedqueryproject       | table | root
 public | sentry_distribution                    | table | root
 public | sentry_email                           | table | root
 public | sentry_environment                     | table | root
 public | sentry_environmentproject              | table | root
 public | sentry_environmentrelease              | table | root
 public | sentry_eventattachment                 | table | root
 public | sentry_eventmapping                    | table | root
 public | sentry_eventprocessingissue            | table | root
 public | sentry_eventtag                        | table | root
 public | sentry_eventuser                       | table | root
 public | sentry_externalissue                   | table | root
 public | sentry_featureadoption                 | table | root
 public | sentry_file                            | table | root
 public | sentry_fileblob                        | table | root
 public | sentry_fileblobindex                   | table | root
 public | sentry_fileblobowner                   | table | root
 public | sentry_filterkey                       | table | root
 public | sentry_filtervalue                     | table | root
 public | sentry_groupasignee                    | table | root
 public | sentry_groupbookmark                   | table | root
 public | sentry_groupcommitresolution           | table | root
 public | sentry_groupedmessage                  | table | root
 public | sentry_groupemailthread                | table | root
 public | sentry_groupenvironment                | table | root
 public | sentry_grouphash                       | table | root
 public | sentry_grouplink                       | table | root
 public | sentry_groupmeta                       | table | root
 public | sentry_groupredirect                   | table | root
 public | sentry_grouprelease                    | table | root
 public | sentry_groupresolution                 | table | root
 public | sentry_grouprulestatus                 | table | root
 public | sentry_groupseen                       | table | root
 public | sentry_groupshare                      | table | root
 public | sentry_groupsnooze                     | table | root
 public | sentry_groupsubscription               | table | root
 public | sentry_grouptagkey                     | table | root
 public | sentry_grouptombstone                  | table | root
 public | sentry_hipchat_ac_tenant               | table | root
 public | sentry_hipchat_ac_tenant_organizations | table | root
 public | sentry_hipchat_ac_tenant_projects      | table | root
 public | sentry_identity                        | table | root
 public | sentry_identityprovider                | table | root
 public | sentry_integration                     | table | root
 public | sentry_integrationexternalproject      | table | root
 public | sentry_latestrelease                   | table | root
 public | sentry_lostpasswordhash                | table | root
 public | sentry_message                         | table | root
 public | sentry_messagefiltervalue              | table | root
 public | sentry_messageindex                    | table | root
 public | sentry_monitor                         | table | root
 public | sentry_monitorcheckin                  | table | root
 public | sentry_monitorlocation                 | table | root
 public | sentry_option                          | table | root
 public | sentry_organization                    | table | root
 public | sentry_organizationaccessrequest       | table | root
 public | sentry_organizationavatar              | table | root
 public | sentry_organizationintegration         | table | root
 public | sentry_organizationmember              | table | root
 public | sentry_organizationmember_teams        | table | root
 public | sentry_organizationonboardingtask      | table | root
 public | sentry_organizationoptions             | table | root
 public | sentry_platformexternalissue           | table | root
 public | sentry_processingissue                 | table | root
 public | sentry_project                         | table | root
 public | sentry_projectavatar                   | table | root
 public | sentry_projectbookmark                 | table | root
 public | sentry_projectcficachefile             | table | root
 public | sentry_projectcounter                  | table | root
 public | sentry_projectdsymfile                 | table | root
 public | sentry_projectintegration              | table | root
 public | sentry_projectkey                      | table | root
 public | sentry_projectoptions                  | table | root
 public | sentry_projectownership                | table | root
 public | sentry_projectplatform                 | table | root
 public | sentry_projectredirect                 | table | root
 public | sentry_projectsymcachefile             | table | root
 public | sentry_projectteam                     | table | root
 public | sentry_promptsactivity                 | table | root
 public | sentry_pull_request                    | table | root
 public | sentry_pullrequest_commit              | table | root
 public | sentry_rawevent                        | table | root
 public | sentry_recentsearch                    | table | root
 public | sentry_relay                           | table | root
 public | sentry_release                         | table | root
 public | sentry_release_project                 | table | root
 public | sentry_releasecommit                   | table | root
 public | sentry_releasefile                     | table | root
 public | sentry_releaseheadcommit               | table | root
 public | sentry_releaseprojectenvironment       | table | root
 public | sentry_repository                      | table | root
 public | sentry_reprocessingreport              | table | root
 public | sentry_rule                            | table | root
 public | sentry_savedsearch                     | table | root
 public | sentry_savedsearch_userdefault         | table | root
 public | sentry_scheduleddeletion               | table | root
 public | sentry_scheduledjob                    | table | root
 public | sentry_sentryapp                       | table | root
 public | sentry_sentryappavatar                 | table | root
 public | sentry_sentryappcomponent              | table | root
 public | sentry_sentryappinstallation           | table | root
 public | sentry_servicehook                     | table | root
 public | sentry_servicehookproject              | table | root
 public | sentry_team                            | table | root
 public | sentry_teamavatar                      | table | root
 public | sentry_useravatar                      | table | root
 public | sentry_useremail                       | table | root
 public | sentry_userip                          | table | root
 public | sentry_useroption                      | table | root
 public | sentry_userpermission                  | table | root
 public | sentry_userreport                      | table | root
 public | sentry_widget                          | table | root
 public | sentry_widgetdatasource                | table | root
 public | social_auth_usersocialauth             | table | root
 public | south_migrationhistory                 | table | root
 public | tagstore_eventtag                      | table | root
 public | tagstore_grouptagkey                   | table | root
 public | tagstore_grouptagvalue                 | table | root
 public | tagstore_tagkey                        | table | root
 public | tagstore_tagvalue                      | table | root
(153 rows)

sentry=#

Pedig amiket hiányol, azok ott vannak, legalábbis úgy tűnik.

postgres_1   | 2023-04-18 20:11:58.742 UTC [36] ERROR:  relation "sentry_rawevent" does not exist at character 36
postgres_1   | 2023-04-18 20:11:58.742 UTC [36] STATEMENT:  SELECT "sentry_rawevent"."id" FROM "sentry_rawevent" WHERE "sentry_rawevent"."datetime" < '2023-04-08 20:11:58.717191+00:00'  LIMIT 200
worker_1     | celery@de80fb19ff55 ready.
worker_1     | Traceback (most recent call last):
worker_1     |   File "/usr/local/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task
worker_1     |     R = retval = fun(*args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/celery/app/trace.py", line 438, in __protected_call__
worker_1     |     return self.run(*args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry_sdk/integrations/celery.py", line 155, in _inner
worker_1     |     reraise(*exc_info)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry_sdk/integrations/celery.py", line 150, in _inner
worker_1     |     return f(*args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/tasks/base.py", line 54, in _wrapped
worker_1     |     result = func(*args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/tasks/deletion.py", line 30, in run_scheduled_deletions
worker_1     |     for item in queryset:
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 96, in __iter__
worker_1     |     self._fetch_all()
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 857, in _fetch_all
worker_1     |     self._result_cache = list(self.iterator())
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 220, in iterator
worker_1     |     for row in compiler.results_iter():
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 713, in results_iter
worker_1     |     for rows in self.execute_sql(MULTI):
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 786, in execute_sql
worker_1     |     cursor.execute(sql, params)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry_sdk/integrations/django/__init__.py", line 446, in execute
worker_1     |     return real_execute(self, sql, params)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
worker_1     |     return self.cursor.execute(sql, params)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/utils.py", line 99, in __exit__
worker_1     |     six.reraise(dj_exc_type, dj_exc_value, traceback)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute
worker_1     |     return self.cursor.execute(sql, params)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 80, in inner
worker_1     |     raise_the_exception(self.db, e)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 78, in inner
worker_1     |     return func(self, *args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 22, in inner
worker_1     |     return func(self, *args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 101, in inner
worker_1     |     six.reraise(exc_info[0], exc_info[0](msg), exc_info[2])
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/db/postgres/decorators.py", line 94, in inner
worker_1     |     return func(self, sql, *args, **kwargs)
worker_1     |   File "/usr/local/lib/python2.7/site-packages/sentry/db/postgres/base.py", line 74, in execute
worker_1     |     return self.cursor.execute(sql, clean_bad_params(params))
worker_1     | ProgrammingError: ProgrammingError('relation "sentry_scheduleddeletion" does not exist\nLINE 1: ...gress", "sentry_scheduleddeletion"."aborted" FROM "sentry_sc...\n                                                             ^\n',)
worker_1     | SQL: SELECT "sentry_scheduleddeletion"."id", "sentry_scheduleddeletion"."guid", "sentry_scheduleddeletion"."app_label", "sentry_scheduleddeletion"."model_name", "sentry_scheduleddeletion"."object_id", "sentry_scheduleddeletion"."date_added", "sentry_scheduleddeletion"."date_scheduled", "sentry_scheduleddeletion"."actor_id", "sentry_scheduleddeletion"."data", "sentry_scheduleddeletion"."in_progress", "sentry_scheduleddeletion"."aborted" FROM "sentry_scheduleddeletion" WHERE ("sentry_scheduleddeletion"."in_progress" = %s  AND "sentry_scheduleddeletion"."date_scheduled" <= %s  AND "sentry_scheduleddeletion"."aborted" = %s )
worker_1     | 20:11:58 [ERROR] celery.worker.job: Task sentry.tasks.deletion.run_scheduled_deletions[e7612ca2-b452-4ba7-a1f6-c863b088cd91] raised unexpected: ProgrammingError(u'ProgrammingError(\'relation "sentry_scheduleddeletion" does not exist\\nLINE 1: ...gress", "sentry_scheduleddeletion"."aborted" FROM "sentry_sc...\\n                                                             ^\\n\',)\nSQL: SELECT "sentry_scheduleddeletion"."id", "sentry_scheduleddeletion"."guid", "sentry_scheduleddeletion"."app_label", "sentry_scheduleddeletion"."model_name", "sentry_scheduleddeletion"."object_id", "sentry_scheduleddeletion"."date_added", "sentry_scheduleddeletion"."date_scheduled", "sentry_scheduleddeletion"."actor_id", "sentry_scheduleddeletion"."data", "sentry_scheduleddeletion"."in_progress", "sentry_scheduleddeletion"."aborted" FROM "sentry_scheduleddeletion" WHERE ("sentry_scheduleddeletion"."in_progress" = %s  AND "sentry_scheduleddeletion"."date_scheduled" <= %s  AND "sentry_scheduleddeletion"."aborted" = %s )',) (data={u'hostname': 'celery@de80fb19ff55', u'name': 'sentry.tasks.deletion.run_scheduled_deletions', u'args': '[]', u'internal': False, u'kwargs': '{}', u'id': 'e7612ca2-b452-4ba7-a1f6-c863b088cd91'})

( Zsugabubus | 2023. 04. 18., k – 22:26 )

Szerkesztve: 2023. 04. 18., k – 22:50

A dumpban egyáltalán benne vannak ezek a sentry_xxx táblák (option, rawevent, scheduleddeletion). pgsql-lel a db-hez csatlakozva látod őket? (\dt)

Ez a 2.7-es Pythont igénylő sentry verzió hányszáz éves?

( ggallo | 2023. 04. 19., sze – 00:28 )

Nem derül ki egyértelműen az eddigiekből:

Tettél fel Postgres-t külön (akár Docker-be, akár a host-ra), oda importáltad be a DB-t, és ahhoz kapcsolódna a docker-compose-zal életre keltett rendszer, vagy a docker-compose (is) indít egy PortgreSQL példányt (ami meg esetleg üres?)