Page MenuHomeSoftware Heritage

"swh-web-cron" container errors because it can't connect to postgres
Closed, MigratedEdits Locked

Description

I don't recall touching anything related to this, but I keep getting this error in my docker logs:

swh-web-cron_1                      | Tue Nov 16 12:46:41 UTC 2021
swh-web-cron_1                      | Traceback (most recent call last):
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
swh-web-cron_1                      |     self.connect()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 195, in connect
swh-web-cron_1                      |     self.connection = self.get_new_connection(conn_params)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
swh-web-cron_1                      |     connection = Database.connect(**conn_params)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/psycopg2/__init__.py", line 127, in connect
swh-web-cron_1                      |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
swh-web-cron_1                      | psycopg2.OperationalError: fe_sendauth: no password supplied
swh-web-cron_1                      | 
swh-web-cron_1                      | 
swh-web-cron_1                      | The above exception was the direct cause of the following exception:
swh-web-cron_1                      | 
swh-web-cron_1                      | Traceback (most recent call last):
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/bin/django-admin", line 8, in <module>
swh-web-cron_1                      |     sys.exit(execute_from_command_line())
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
swh-web-cron_1                      |     utility.execute()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/core/management/__init__.py", line 375, in execute
swh-web-cron_1                      |     self.fetch_command(subcommand).run_from_argv(self.argv)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/core/management/base.py", line 323, in run_from_argv
swh-web-cron_1                      |     self.execute(*args, **cmd_options)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/core/management/base.py", line 364, in execute
swh-web-cron_1                      |     output = self.handle(*args, **options)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/web/common/management/commands/refresh_savecodenow_statuses.py", line 27, in handle
swh-web-cron_1                      |     refreshed_statuses = refresh_save_origin_request_statuses()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/web/common/origin_save.py", line 633, in refresh_save_origin_request_statuses
swh-web-cron_1                      |     if save_requests.count() > 0
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/models/query.py", line 392, in count
swh-web-cron_1                      |     return self.query.get_count(using=self.db)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/models/sql/query.py", line 504, in get_count
swh-web-cron_1                      |     number = obj.get_aggregation(using, ['__count'])['__count']
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/models/sql/query.py", line 489, in get_aggregation
swh-web-cron_1                      |     result = compiler.execute_sql(SINGLE)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1140, in execute_sql
swh-web-cron_1                      |     cursor = self.connection.cursor()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 256, in cursor
swh-web-cron_1                      |     return self._cursor()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 233, in _cursor
swh-web-cron_1                      |     self.ensure_connection()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
swh-web-cron_1                      |     self.connect()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/utils.py", line 89, in __exit__
swh-web-cron_1                      |     raise dj_exc_value.with_traceback(traceback) from exc_value
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
swh-web-cron_1                      |     self.connect()
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 195, in connect
swh-web-cron_1                      |     self.connection = self.get_new_connection(conn_params)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
swh-web-cron_1                      |     connection = Database.connect(**conn_params)
swh-web-cron_1                      |   File "/srv/softwareheritage/venv/lib/python3.7/site-packages/psycopg2/__init__.py", line 127, in connect
swh-web-cron_1                      |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
swh-web-cron_1                      | django.db.utils.OperationalError: fe_sendauth: no password supplied
swh-web-cron_1                      |