Database error, possibly because of bad migrations
Review this checklist before submitting.
-
GitLab issues are for bug reports and feature requests. If this is a help request, post on Gitter. If you have or want paid support, please use the chat widget on https://glitchtip.com. -
Document reproduction steps. Be as detailed as possible. -
If applicable, try to reproduce the problem on https://app.glitchtip.com -
Be considerate of the reviewer of your issue and their time. They are likely unpaid. GlitchTip is open source and comes with absolutely no warranty. -
Check existing issues first. 👍 the issue to show interest. -
Do not open issue related to automated security scanners or other static anaysis tool. We use Renovate and GitLab for this. Instead, ask on Gitter how you can help get involved in the project and make the changes you wish to see.
Description
I haven't opened GlitchTip for a month or more, so I don't know when the issue first occured.
I tried to loom at some reports in my GlitchTip dashboard and the project page loads, just like the login-page, but if I want to click on a specific issue, I get the following log:
glitchtip-postgres-1 | 2023-05-04 13:55:03.573 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.573 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE ("organizations_ext_organizationuser"."user_id" = 1 AND "issues_issue"."id" = 564) GROUP BY "issues_issue"."id", "projects_project"."id" LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.619 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.619 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE "organizations_ext_organizationuser"."user_id" = 1 GROUP BY "issues_issue"."id", "projects_project"."id" ORDER BY "issues_issue"."last_seen" DESC LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.621 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.621 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE "organizations_ext_organizationuser"."user_id" = 1 GROUP BY "issues_issue"."id", "projects_project"."id" ORDER BY "issues_issue"."last_seen" DESC LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.632 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.632 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE "organizations_ext_organizationuser"."user_id" = 1 GROUP BY "issues_issue"."id", "projects_project"."id" ORDER BY "issues_issue"."last_seen" DESC LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.634 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.634 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE "organizations_ext_organizationuser"."user_id" = 1 GROUP BY "issues_issue"."id", "projects_project"."id" ORDER BY "issues_issue"."last_seen" DESC LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.635 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.635 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE "organizations_ext_organizationuser"."user_id" = 1 GROUP BY "issues_issue"."id", "projects_project"."id" ORDER BY "issues_issue"."last_seen" DESC LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.636 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.636 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE ("organizations_ext_organizationuser"."user_id" = 1 AND "issues_issue"."id" = 564) GROUP BY "issues_issue"."id", "projects_project"."id" LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.638 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.638 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE ("organizations_ext_organizationuser"."user_id" = 1 AND "issues_issue"."id" = 564) GROUP BY "issues_issue"."id", "projects_project"."id" LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.639 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.639 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE ("organizations_ext_organizationuser"."user_id" = 1 AND "issues_issue"."id" = 564) GROUP BY "issues_issue"."id", "projects_project"."id" LIMIT 21
glitchtip-postgres-1 | 2023-05-04 13:55:03.641 UTC [68] ERROR: relation "issues_comment" does not exist at character 1128
glitchtip-postgres-1 | 2023-05-04 13:55:03.641 UTC [68] STATEMENT: SELECT "issues_issue"."id", "issues_issue"."created", "issues_issue"."culprit", "issues_issue"."has_seen", "issues_issue"."is_public", "issues_issue"."level", "issues_issue"."metadata", "issues_issue"."project_id", "issues_issue"."title", "issues_issue"."type", "issues_issue"."status", "issues_issue"."short_id", "issues_issue"."count", "issues_issue"."last_seen", COUNT("issues_comment"."id") AS "num_comments", COUNT("user_reports_userreport"."id") AS "user_report_count", "projects_project"."id", "projects_project"."created", "projects_project"."slug", "projects_project"."name", "projects_project"."organization_id", "projects_project"."platform", "projects_project"."first_event", "projects_project"."scrub_ip_addresses" FROM "issues_issue" INNER JOIN "projects_project" ON ("issues_issue"."project_id" = "projects_project"."id") INNER JOIN "organizations_ext_organization" ON ("projects_project"."organization_id" = "organizations_ext_organization"."id") INNER JOIN "organizations_ext_organizationuser" ON ("organizations_ext_organization"."id" = "organizations_ext_organizationuser"."organization_id") LEFT OUTER JOIN "issues_comment" ON ("issues_issue"."id" = "issues_comment"."issue_id") LEFT OUTER JOIN "user_reports_userreport" ON ("issues_issue"."id" = "user_reports_userreport"."issue_id") WHERE ("organizations_ext_organizationuser"."user_id" = 1 AND "issues_issue"."id" = 564) GROUP BY "issues_issue"."id", "projects_project"."id" LIMIT 21
glitchtip-web-1 | Internal Server Error: /api/0/issues/564/
glitchtip-web-1 | Traceback (most recent call last):
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
glitchtip-web-1 | return self.cursor.execute(sql, params)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/psycopg/cursor.py", line 723, in execute
glitchtip-web-1 | raise ex.with_traceback(None)
glitchtip-web-1 | psycopg.errors.UndefinedTable: relation "issues_comment" does not exist
glitchtip-web-1 | LINE 1: ...anizationuser"."organization_id") LEFT OUTER JOIN "issues_co...
glitchtip-web-1 | ^
glitchtip-web-1 |
glitchtip-web-1 | The above exception was the direct cause of the following exception:
glitchtip-web-1 |
glitchtip-web-1 | Traceback (most recent call last):
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
glitchtip-web-1 | response = get_response(request)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
glitchtip-web-1 | response = wrapped_callback(request, *callback_args, **callback_kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/views/decorators/csrf.py", line 56, in wrapper_view
glitchtip-web-1 | return view_func(*args, **kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/viewsets.py", line 125, in view
glitchtip-web-1 | return self.dispatch(request, *args, **kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 509, in dispatch
glitchtip-web-1 | response = self.handle_exception(exc)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 469, in handle_exception
glitchtip-web-1 | self.raise_uncaught_exception(exc)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
glitchtip-web-1 | raise exc
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 506, in dispatch
glitchtip-web-1 | response = handler(request, *args, **kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/mixins.py", line 54, in retrieve
glitchtip-web-1 | instance = self.get_object()
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/generics.py", line 96, in get_object
glitchtip-web-1 | obj = get_object_or_404(queryset, **filter_kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/generics.py", line 19, in get_object_or_404
glitchtip-web-1 | return _get_object_or_404(queryset, *filter_args, **filter_kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/shortcuts.py", line 85, in get_object_or_404
glitchtip-web-1 | return queryset.get(*args, **kwargs)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 633, in get
glitchtip-web-1 | num = len(clone)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 380, in __len__
glitchtip-web-1 | self._fetch_all()
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
glitchtip-web-1 | self._result_cache = list(self._iterable_class(self))
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
glitchtip-web-1 | results = compiler.execute_sql(
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1560, in execute_sql
glitchtip-web-1 | cursor.execute(sql, params)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
glitchtip-web-1 | return self._execute_with_wrappers(
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
glitchtip-web-1 | return executor(sql, params, many, context)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
glitchtip-web-1 | with self.db.wrap_database_errors:
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
glitchtip-web-1 | raise dj_exc_value.with_traceback(traceback) from exc_value
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
glitchtip-web-1 | return self.cursor.execute(sql, params)
glitchtip-web-1 | File "/usr/local/lib/python3.10/site-packages/psycopg/cursor.py", line 723, in execute
glitchtip-web-1 | raise ex.with_traceback(None)
glitchtip-web-1 | django.db.utils.ProgrammingError: relation "issues_comment" does not exist
glitchtip-web-1 | LINE 1: ...anizationuser"."organization_id") LEFT OUTER JOIN "issues_co...I've got automatic updates with Watchtower and I am running the latest version. I am also getting the following error over and over again:
glitchtip-worker-1 | Task glitchtip.uptime.tasks.dispatch_checks[e04a0065-4334-4b89-8408-777e6c01f5fd] received
glitchtip-postgres-1 | 2023-05-04 13:56:34.761 UTC [84] ERROR: column uptime_monitor.timeout does not exist at character 60
glitchtip-postgres-1 | 2023-05-04 13:56:34.761 UTC [84] STATEMENT: SELECT "uptime_monitor"."id", "uptime_monitor"."interval", "uptime_monitor"."timeout", (320 % EXTRACT(epoch FROM "uptime_monitor"."interval")::INTEGER) AS "mod" FROM "uptime_monitor" INNER JOIN "organizations_ext_organization" ON ("uptime_monitor"."organization_id" = "organizations_ext_organization"."id") WHERE ("organizations_ext_organization"."is_accepting_events" AND (320 % EXTRACT(epoch FROM "uptime_monitor"."interval")::INTEGER) < 10 AND NOT ("uptime_monitor"."url" = '' AND NOT ("uptime_monitor"."monitor_type" = 'Heartbeat')))
glitchtip-worker-1 | Task glitchtip.uptime.tasks.dispatch_checks[e04a0065-4334-4b89-8408-777e6c01f5fd] raised unexpected: ProgrammingError('column uptime_monitor.timeout does not exist\nLINE 1: ...ptime_monitor"."id", "uptime_monitor"."interval", "uptime_mo...\n ^')
glitchtip-worker-1 | Traceback (most recent call last):
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
glitchtip-worker-1 | return self.cursor.execute(sql, params)
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/psycopg/cursor.py", line 723, in execute
glitchtip-worker-1 | raise ex.with_traceback(None)
glitchtip-worker-1 | psycopg.errors.UndefinedColumn: column uptime_monitor.timeout does not exist
glitchtip-worker-1 | LINE 1: ...ptime_monitor"."id", "uptime_monitor"."interval", "uptime_mo...
glitchtip-worker-1 | ^
glitchtip-worker-1 |
glitchtip-worker-1 | The above exception was the direct cause of the following exception:
glitchtip-worker-1 |
glitchtip-worker-1 | Traceback (most recent call last):
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 451, in trace_task
glitchtip-worker-1 | R = retval = fun(*args, **kwargs)
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 734, in __protected_call__
glitchtip-worker-1 | return self.run(*args, **kwargs)
glitchtip-worker-1 | File "/code/glitchtip/uptime/tasks.py", line 105, in dispatch_checks
glitchtip-worker-1 | for i, (tick, bucket) in enumerate(bucket_monitors(monitors, tick).items()):
glitchtip-worker-1 | File "/code/glitchtip/uptime/tasks.py", line 51, in bucket_monitors
glitchtip-worker-1 | fast_tick_monitors = [
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 398, in __iter__
glitchtip-worker-1 | self._fetch_all()
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all
glitchtip-worker-1 | self._result_cache = list(self._iterable_class(self))
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
glitchtip-worker-1 | results = compiler.execute_sql(
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1560, in execute_sql
glitchtip-worker-1 | cursor.execute(sql, params)
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute
glitchtip-worker-1 | return self._execute_with_wrappers(
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
glitchtip-worker-1 | return executor(sql, params, many, context)
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
glitchtip-worker-1 | with self.db.wrap_database_errors:
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
glitchtip-worker-1 | raise dj_exc_value.with_traceback(traceback) from exc_value
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute
glitchtip-worker-1 | return self.cursor.execute(sql, params)
glitchtip-worker-1 | File "/usr/local/lib/python3.10/site-packages/psycopg/cursor.py", line 723, in execute
glitchtip-worker-1 | raise ex.with_traceback(None)
glitchtip-worker-1 | django.db.utils.ProgrammingError: column uptime_monitor.timeout does not exist
glitchtip-worker-1 | LINE 1: ...ptime_monitor"."id", "uptime_monitor"."interval", "uptime_mo...Proposed Solution(s)
This seems to be an issue with migrations, which are up-to-date, since I've restarted everything 2 times.