問題
Djangoでウェブアプリを開発し、Herokuにデプロイしました。そしてマイグレートするも以下のメッセージが表示されました。検索するとPostgreSQLに問題があるようです。何が問題なのかも見当がつきません。これまでデプロイしたことは何度かあるのですが、このようなエラーを見たのは初めてで戸惑っています。どうするべきでしょうか?
PS C:\Users\detec\myblog\myblog> heroku run python manage.py migrate » Warning: heroku update available from 7.53.0 to 7.60.1. Running python manage.py migrate on ⬢ myblog4649... up, run.1307 (Free) Traceback (most recent call last): File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection self.connect() File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 225, in connect self.connection = self.get_new_connection(conn_params) File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 203, in get_new_connection connection = Database.connect(**conn_params) File "/app/.heroku/python/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/manage.py", line 10, in <module> execute_from_command_line(sys.argv) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line utility.execute() File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/__init__.py", line 440, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/base.py", line 414, in run_from_argv self.execute(*args, **cmd_options) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/base.py", line 460, in execute output = self.handle(*args, **options) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/base.py", line 98, in wrapped res = handle_func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 91, in handle self.check(databases=[database]) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/management/base.py", line 487, in check all_issues = checks.run_checks( File "/app/.heroku/python/lib/python3.9/site-packages/django/core/checks/registry.py", line 88, in run_checks new_errors = check(app_configs=app_configs, databases=databases) File "/app/.heroku/python/lib/python3.9/site-packages/django/core/checks/model_checks.py", line 36, in check_all_models errors.extend(model.check(**kwargs)) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/models/base.py", line 1461, in check *cls._check_indexes(databases), File "/app/.heroku/python/lib/python3.9/site-packages/django/db/models/base.py", line 1864, in _check_indexes connection.features.supports_covering_indexes File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/functional.py", line 49, in __get__ res = instance.__dict__[self.name] = self.func(instance) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/postgresql/features.py", line 84, in is_postgresql_11 return self.connection.pg_version >= 110000 File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/functional.py", line 49, in __get__ res = instance.__dict__[self.name] = self.func(instance) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 354, in pg_version with self.temporary_connection(): File "/app/.heroku/python/lib/python3.9/contextlib.py", line 119, in __enter__ return next(self.gen) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 639, in temporary_connection with self.cursor() as cursor: File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 284, in cursor return self._cursor() File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 260, in _cursor self.ensure_connection() File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection self.connect() File "/app/.heroku/python/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection self.connect() File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/base/base.py", line 225, in connect self.connection = self.get_new_connection(conn_params) File "/app/.heroku/python/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/app/.heroku/python/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 203, in get_new_connection connection = Database.connect(**conn_params) File "/app/.heroku/python/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) django.db.utils.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket?
heroku
1#log 2 32022-05-20T02:12:04.127178+00:00 heroku[web.1]: Process exited with status 127 4 52022-05-20T02:12:04.187060+00:00 heroku[web.1]: State changed from starting to crashed 6 72022-05-20T02:12:10.986659+00:00 heroku[run.5864]: Process exited with status 1 8 92022-05-20T02:12:11.044613+00:00 heroku[run.5864]: State changed from up to complete 10 112022-05-20T02:51:07.988809+00:00 app[api]: Starting process with command `python manage.py migrate` by user kazy3776@gmail.com 12 132022-05-20T02:51:14.960969+00:00 heroku[run.1307]: Awaiting client 14 152022-05-20T02:51:14.978831+00:00 heroku[run.1307]: Starting process with command `python manage.py migrate` 16 172022-05-20T02:51:15.017092+00:00 heroku[run.1307]: State changed from starting to up 18 192022-05-20T02:51:21.552977+00:00 heroku[run.1307]: Process exited with status 1 20 212022-05-20T02:51:21.637467+00:00 heroku[run.1307]: State changed from up to complete
試したこと
pg_ctl -D "C:\Program Files\PostgreSQL\13\data" start pg_ctl -D "C:\Program Files\PostgreSQL\13\data" stop pg_ctl -D "C:\Program Files\PostgreSQL\13\data" restart
再起動はされましたが、デプロイ先には特に影響はなく、同じ問題が出ています。
回答1件
あなたの回答
tips
プレビュー