Closed sfc-gh-pkommini closed 3 years ago
Issue persists. Not sure why the database username that is passed is being used for the database name?
Is dispatch_user
defined in your .env
? I don't see it defined anywhere else so I'm not sure where that value is coming from.
dispatch_user
is passed is via POSTGRES_USER
and also via DATABASE_CREDENTIALS
. But for some reason it says database "dispatch_user" doesn't exist
Seems like a case of this. Let me try this and report if the fix there works.
@kevgliss I believe this is an issue due to this. This issue might have to be moved to the dispatch
repository due to being related to a recent version of python dependency SQLAlchemy-Utils==0.36.8
.
As the sqlalchemy-utils 0.36.8
library onwards seems to have this error. There is a pull to fix it here. But until then the fix is to pin the library version SQLAlchemy-Utils==0.36.7
in requirements-base.txt
.
Towards that, I was wondering is SQLAlchemy-Utils
pulled in transitively? I don't see it in requirements-dev.txt
file.
Hope this helps someone else facing the same error. Two days I'll never get back! 😅
I see it's pulled in transitively due in this library. I'll pin it while building our container for now and that should tape the issue for now.
@kevgliss @mvilanova
So I was able to run an ECS container with the fix above just to run the dispatch database upgrade
command and I got the following logs:
The upgrade itself was successful, but it had a bunch of endpoint related errors that I wanted to understand. Would you know how to resolve them?
DEBUG:Configuring extensions...:/usr/local/lib/python3.8/site-packages/dispatch/extensions.py:configure_extensions:25
--
INFO:Attempting to load plugin: dispatch_basic_auth:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin dispatch_basic_auth:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: dispatch_contact:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin dispatch_contact:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: dispatch_document_resolver:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin dispatch_document_resolver:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: dispatch_participant_resolver:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin dispatch_participant_resolver:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: dispatch_pkce_auth:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin dispatch_pkce_auth:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: dispatch_ticket:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin dispatch_ticket:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: google_calendar_conference:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin google_calendar_conference:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: google_docs_document:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin google_docs_document:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: google_drive_storage:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin google_drive_storage:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: google_drive_task:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin google_drive_task:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: google_gmail_email:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin google_gmail_email:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: google_groups_participants:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin google_groups_participants:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: jira_ticket:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin jira_ticket:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: opsgenie_oncall:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin opsgenie_oncall:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: pagerduty_oncall:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin pagerduty_oncall:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: slack_contact:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin slack_contact:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: slack_conversation:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin slack_conversation:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
INFO:Attempting to load plugin: zoom_conference:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:27
ERROR:Failed to load plugin zoom_conference:Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py", line 29, in install_plugins
plugin = ep.load()
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2446, in load
self.require(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 2469, in require
items = working_set.resolve(reqs, env, installer, extras=self.extras)
File "/usr/local/lib/python3.8/site-packages/pkg_resources/__init__.py", line 775, in resolve
raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (chardet 4.0.0 (/usr/local/lib/python3.8/site-packages), Requirement.parse('chardet<4.0,>=2.0'), {'aiohttp'})
:/usr/local/lib/python3.8/site-packages/dispatch/common/utils/cli.py:install_plugins:39
DEBUG:Available Endpoints
Path Authenticated Methods
------------------------------------------- --------------- ---------
/auth/login False POST
/auth/register False POST
/docs/openapi.json False GET
/docs/ False GET
/healthcheck False GET
/user/ True GET
/user/{user_id} True GET
/user/{user_id} True PUT
/user/me True GET
/documents/ True GET
/documents/{document_id} True GET
/documents/ True POST
/documents/{document_id} True PUT
/documents/{document_id} True DELETE
/tags/ True GET
/tags/{tag_id} True GET
/tags/ True POST
/tags/{tag_id} True PUT
/tags/{tag_id} True DELETE
/tag_types/ True GET
/tag_types/{tag_type_id} True GET
/tag_types/ True POST
/tag_types/{tag_type_id} True PUT
/tag_types/{tag_type_id} True DELETE
/services/ True GET
/services/ True POST
/services/{service_id} True PUT
/services/{service_id} True GET
/services/{service_id} True DELETE
/teams/ True GET
/teams/ True POST
/teams/{team_id} True GET
/teams/{team_contact_id} True PUT
/teams/{team_contact_id} True DELETE
/individuals/ True GET
/individuals/ True POST
/individuals/{individual_contact_id} True GET
/individuals/{individual_contact_id} True PUT
/individuals/{individual_contact_id} True DELETE
/policies/ True GET
/policies/ True POST
/policies/{policy_id} True PUT
/policies/{policy_id} True DELETE
/definitions/ True GET
/definitions/{definition_id} True GET
/definitions/ True POST
/definitions/{definition_id} True PUT
/definitions/{definition_id} True DELETE
/terms/ True GET
/terms/ True POST
/terms/{term_id} True GET
/terms/{term_id} True PUT
/terms/{term_id} True DELETE
/tasks/ True GET
/tasks/ True POST
/tasks/{task_id} True PUT
/tasks/{task_id} True DELETE
/search/ True GET
/incidents/ True GET
/incidents/{incident_id} True GET
/incidents/ True POST
/incidents/{incident_id} True PUT
/incidents/{incident_id}/join True POST
/incidents/{incident_id} True DELETE
/incidents/metric/forecast/{incident_type} True GET
/incident_types/ True GET
/incident_types/ True POST
/incident_types/{incident_type_id} True PUT
/incident_types/{incident_type_id} True GET
/incident_priorities/ True GET
/incident_priorities/ True POST
/incident_priorities/{incident_priority_id} True PUT
/incident_priorities/{incident_priority_id} True GET
/workflows/ True GET
/workflows/{workflow_id} True GET
/workflows/ True POST
/workflows/{workflow_id} True PUT
/workflows/{workflow_id} True DELETE
/plugins/ True GET
/plugins/{plugin_type} True GET
/plugins/{plugin_id} True GET
/plugins/{plugin_id} True PUT
/feedback/ True GET
/feedback/{feedback_id} True GET
/feedback/ True POST
/feedback/{feedback_id} True PUT
/feedback/{feedback_id} True DELETE:/usr/local/lib/python3.8/site-packages/dispatch/main.py:<module>:141
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running stamp_revision -> 1c3f808aa00c
Success.
That issue with sqlalchemy-utils is a good catch (we've always had the database and the user match so we've never encountered it).
The second error regarding ContextualVersionConflict
is typically due to some dependency deciding to pin their version and another library requiring a different incompatible version. In this case it looks like aiohttp is the culprit: https://github.com/aio-libs/aiohttp/pull/5334
In the near term we can pin aiohttp, or attempt to figure out which library is requiring <chardet4.0 and see if they have an upgrade path.
Oh yeah, also wanted to mention, RDS uses dispatch
as a keyword and hence can't have a database with that name. ☹️
So regarding the ContextualVersionConflict
, Is it normal for dispatch.common.utils.cli
's install_plugins
to run during database upgrade?
Running install_plugins
is expected to run during any CLI function. This really only registers the plugins in an internal repository so they can be used. Are you facing issues with it?
@kevgliss @mvilanova Yes. I was able to pin the version and then dispatch database upgrade
worked like a charm, however I'm unable to register a new user. This was the sequence of events.
docker-compose up -d
on ECS which was to spin up the ECS service and that is setup to run the dispatch database upgrade
, upto this point everything worked without any errors.Somehow it seems like the /register
endpoint is not setup.
I'm using the latest code on master to run this and also data dump from the link in install.sh
from this repo.
Not sure what I'm doing wrong. :(
Ah, we recently moved the register url to /auth/register
I've updated the install.sh here: https://github.com/Netflix/dispatch-docker/pull/96
Sorry about the confusion!
@kevgliss Ah. That makes sense. It is auth related. I'm happy to report that I was able to get as deep as setting up the data dump and got the endpoint up and running using ECS and RDS and was going to test integrations next.
I did get a few errors while doing the data dump, I'm not sure how critical they are, but I thought I'd let you know that I'm looking into them and any insights from you will be super useful.
psql:./dispatch-sample-data.dump:548: ERROR: unrecognized configuration parameter "default_table_access_method"
psql:./dispatch-sample-data.dump:2457: ERROR: invalid input syntax for integer: "Post Incident Review Template"
CONTEXT: COPY document, line 4, column id: "Post Incident Review Template"
psql:./dispatch-sample-data.dump:4229: ERROR: insert or update on table "incident_type" violates foreign key constraint "incident_type_template_document_id_fkey"
DETAIL: Key (template_document_id)=(1) is not present in table "document".
@kevgliss The first one seems to be based on the postgres version so is an easy fix. But the 2nd and 3rd errors seem like they could break something.
@kevgliss Like I suspected. The 1st one doesn't occur on local (macOS) run of the install.sh
. But the 2nd and 3rd error happen even on localhost.
I haven't been able to reproduce these errors on the latest example data dump (released today). Closing for now, please create a new issue if you encounter them again.
I get the following error message when I try to setup tables using ECS. The easiest way I found was to do the
dispatch database upgrade
using a separate container and have theweb
andscheduler
containers run only after thatmigrate
container has finished execution.Towards doing the database upgrade, I get the following errors:
Do you think this is a connection issue or is it a table setup issue? Are you familiar with this error?