nohup: ignoring input INFO:__main__:magento-worker: starting continuous loop (idle poll=60s) ERROR:__main__:magento-worker: unexpected error: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (Background on this error at: https://sqlalche.me/e/20/e3q8) Traceback (most recent call last): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1311, in _checkout raise exc.InvalidatePoolError() sqlalchemy.exc.InvalidatePoolError: () During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 143, in __init__ self._dbapi_connection = engine.raw_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3309, in raw_connection return self.pool.connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 447, in connect return _ConnectionFairy._checkout(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1345, in _checkout with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1342, in _checkout fairy._connection_record.get_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 836, in get_connection self.__connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 899, in __connect with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 895, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 661, in connect return dialect.connect(*cargs, **cparams) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 630, in connect return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501 File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home2/devpiesol/plytix.dev.piesol.com/magento_worker.py", line 41, in main had_work = run_one() File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/magento_sync_worker.py", line 120, in run_one recovered = queue_repo.reset_stale_running(stale_minutes=120) File "/home2/devpiesol/plytix.dev.piesol.com/db/magento_repositories.py", line 2200, in reset_stale_running rows = self._session.execute(stmt).scalars().all() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2351, in execute return self._execute_internal( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2239, in _execute_internal conn = self._connection_for_bind(bind) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2108, in _connection_for_bind return trans._connection_for_bind(engine, execution_options) File "", line 2, in _connection_for_bind File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/state_changes.py", line 137, in _go ret_value = fn(self, *arg, **kw) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1187, in _connection_for_bind conn = bind.connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3285, in connect return self._connection_cls(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__ Connection._handle_dbapi_exception_noconnection( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2448, in _handle_dbapi_exception_noconnection raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 143, in __init__ self._dbapi_connection = engine.raw_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3309, in raw_connection return self.pool.connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 447, in connect return _ConnectionFairy._checkout(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1345, in _checkout with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1342, in _checkout fairy._connection_record.get_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 836, in get_connection self.__connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 899, in __connect with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 895, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 661, in connect return dialect.connect(*cargs, **cparams) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 630, in connect return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501 File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (Background on this error at: https://sqlalche.me/e/20/e3q8) es/sqlalchemy/pool/base.py", line 1345, in _checkout with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1342, in _checkout fairy._connection_record.get_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 836, in get_connection self.__connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 899, in __connect with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 895, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 661, in connect return dialect.connect(*cargs, **cparams) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 630, in connect return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501 File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home2/devpiesol/plytix.dev.piesol.com/magento_worker.py", line 41, in main had_work = run_one() File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/magento_sync_worker.py", line 120, in run_one recovered = queue_repo.reset_stale_running(stale_minutes=120) File "/home2/devpiesol/plytix.dev.piesol.com/db/magento_repositories.py", line 2200, in reset_stale_running rows = self._session.execute(stmt).scalars().all() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2351, in execute return self._execute_internal( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2239, in _execute_internal conn = self._connection_for_bind(bind) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2108, in _connection_for_bind return trans._connection_for_bind(engine, execution_options) File "", line 2, in _connection_for_bind File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/state_changes.py", line 137, in _go ret_value = fn(self, *arg, **kw) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1187, in _connection_for_bind conn = bind.connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3285, in connect return self._connection_cls(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__ Connection._handle_dbapi_exception_noconnection( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2448, in _handle_dbapi_exception_noconnection raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 143, in __init__ self._dbapi_connection = engine.raw_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3309, in raw_connection return self.pool.connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 447, in connect return _ConnectionFairy._checkout(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1345, in _checkout with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1342, in _checkout fairy._connection_record.get_connection() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 836, in get_connection self.__connect() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 899, in __connect with util.safe_reraise(): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 895, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 661, in connect return dialect.connect(*cargs, **cparams) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 630, in connect return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501 File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (Background on this error at: https://sqlalche.me/e/20/e3q8)