nohup: ignoring input INFO:__main__:taxonomy-worker: starting continuous loop (idle poll=10s) INFO:app.jobs.master_taxonomy_enqueue:taxonomy-worker: claimed job=905a31b4-ba0d-4d51-bba1-2a4d9b371c89 type=fix_all INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy pipeline [1/10]: Reprocessing master SKU raw payloads INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy step reprocess_master finished in 3396.1s INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy pipeline [2/10]: Pulling Magento and Shopify category/collection registries INFO:app.jobs.magento_baseline_sync:[baseline] Magento API root: https://homesurplus.dsstaging3.com/rest/V1 INFO:app.jobs.magento_baseline_sync:[baseline] Pulling store websites... INFO:app.jobs.magento_baseline_sync:[baseline] Stored 2 store registry entries INFO:app.jobs.magento_baseline_sync:[baseline] Pulling category tree... INFO:app.jobs.magento_baseline_sync:[baseline] Stored 171 category registry entries INFO:app.jobs.magento_baseline_sync:[baseline] Pulling attribute sets... INFO:app.jobs.magento_baseline_sync:[baseline] Stored 1 product attribute sets (entity_type_id=4) INFO:app.jobs.magento_baseline_sync:[baseline] Using default attribute set: Default (id=4) INFO:app.jobs.magento_baseline_sync:[baseline] Pulling attributes for set id=4... INFO:app.jobs.magento_baseline_sync:[baseline] Set has 117 attributes in magento_attribute_set_attributes INFO:app.jobs.magento_baseline_sync:[baseline] Stored 117 attributes, 381 options (default_set_id=4) INFO:app.jobs.magento_baseline_sync:[baseline] MSI sources: 7 → magento_source_registry (['1', '10', '12', '2', '3', '43', 'default']) INFO:app.jobs.magento_baseline_sync:[baseline] MSI stocks: 2, links: 6 (stocks: [(1, 'Default'), (2, 'Home Surplus')]) INFO:app.jobs.magento_baseline_sync:[baseline] Baseline sync completed for connection 1: {'stores': 2, 'categories': 171, 'attribute_sets': 1, 'attributes': 117, 'options': 381, 'default_attribute_set_id': 4, 'inventory_sources': 7, 'inventory_stocks': 2, 'inventory_stock_source_links': 6} INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy step pull_remotes finished in 86.2s INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy pipeline [3/10]: Backfilling taxonomy from master catalog INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy step backfill finished in 35.7s INFO:app.jobs.sync_master_taxonomy_pipeline:Taxonomy pipeline [4/10]: Building taxonomy hierarchy ERROR:app.jobs.master_taxonomy_enqueue:taxonomy-worker: job=905a31b4-ba0d-4d51-bba1-2a4d9b371c89 type=fix_all failed Traceback (most recent call last): File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute cursor.execute(statement, parameters) psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "uq_master_taxonomy_node_path_slug" DETAIL: Key (path_slug)=(kitchen-cabinets/black-rift-white-oak-accessories) already exists. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 100, in run_master_taxonomy_job_once result = _execute(job_type, {**params, "_job_id": job_id}) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 162, in _execute return _execute_fix_all(params) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 298, in _execute_fix_all return run_master_taxonomy_pipeline( File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/sync_master_taxonomy_pipeline.py", line 410, in run_master_taxonomy_pipeline summary["steps"]["build_hierarchy"] = build_hierarchy_from_master_catalog(session, dry_run=dry_run) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_hierarchy.py", line 62, in build_hierarchy_from_master_catalog created = _ensure_node_for_slug(session, slug, node_kind=kind, collection_slugs=collection_slugs) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_hierarchy.py", line 279, in _ensure_node_for_slug session.flush() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 4331, in flush self._flush(objects) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 4466, in _flush 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/orm/session.py", line 4427, in _flush flush_context.execute() File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute rec.execute(self) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute util.preloaded.orm_persistence.save_obj( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj _emit_insert_statements( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements result = connection.execute( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute return meth( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection return connection._execute_clauseelement( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement ret = self._execute_context( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context return self._exec_single_context( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception 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 1967, in _exec_single_context self.dialect.do_execute( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_master_taxonomy_node_path_slug" DETAIL: Key (path_slug)=(kitchen-cabinets/black-rift-white-oak-accessories) already exists. [SQL: INSERT INTO master_taxonomy_node (parent_id, node_kind, code, name, path_slug, collection_registry_id, sort_order, is_active, notes, created_at, updated_at) VALUES (%(parent_id)s, %(node_kind)s, %(code)s, %(name)s, %(path_slug)s, %(collection_registry_id)s, %(sort_order)s, %(is_active)s, %(notes)s, %(created_at)s, %(updated_at)s) RETURNING master_taxonomy_node.id] [parameters: {'parent_id': 1, 'node_kind': 'collection', 'code': 'kitchen-cabinets-black-rift-white-oak-accessories', 'name': 'Kitchen Cabinets / Black Rift White Oak Accessories', 'path_slug': 'kitchen-cabinets/black-rift-white-oak-accessories', 'collection_registry_id': None, 'sort_order': 100, 'is_active': True, 'notes': None, 'created_at': datetime.datetime(2026, 7, 3, 20, 42, 59, 471150), 'updated_at': datetime.datetime(2026, 7, 3, 20, 42, 59, 471154)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) ERROR:__main__:taxonomy-worker: pass failed 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/app/jobs/master_taxonomy_job_worker.py", line 31, in main had_work = run_master_taxonomy_job_once(worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 90, in run_master_taxonomy_job_once job = claim_next_master_taxonomy_job(session, worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_jobs.py", line 84, in claim_next_master_taxonomy_job stale_rows = session.scalars( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2459, in scalars 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) ERROR:__main__:taxonomy-worker: pass failed 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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/app/jobs/master_taxonomy_job_worker.py", line 31, in main had_work = run_master_taxonomy_job_once(worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 90, in run_master_taxonomy_job_once job = claim_next_master_taxonomy_job(session, worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_jobs.py", line 84, in claim_next_master_taxonomy_job stale_rows = session.scalars( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2459, in scalars 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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) ERROR:__main__:taxonomy-worker: pass failed 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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/app/jobs/master_taxonomy_job_worker.py", line 31, in main had_work = run_master_taxonomy_job_once(worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 90, in run_master_taxonomy_job_once job = claim_next_master_taxonomy_job(session, worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_jobs.py", line 84, in claim_next_master_taxonomy_job stale_rows = session.scalars( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2459, in scalars 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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) ERROR:__main__:taxonomy-worker: pass failed 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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/app/jobs/master_taxonomy_job_worker.py", line 31, in main had_work = run_master_taxonomy_job_once(worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 90, in run_master_taxonomy_job_once job = claim_next_master_taxonomy_job(session, worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_jobs.py", line 84, in claim_next_master_taxonomy_job stale_rows = session.scalars( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2459, in scalars 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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) ERROR:__main__:taxonomy-worker: pass failed 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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/app/jobs/master_taxonomy_job_worker.py", line 31, in main had_work = run_master_taxonomy_job_once(worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 90, in run_master_taxonomy_job_once job = claim_next_master_taxonomy_job(session, worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_jobs.py", line 84, in claim_next_master_taxonomy_job stale_rows = session.scalars( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2459, in scalars 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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) ERROR:__main__:taxonomy-worker: pass failed 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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/app/jobs/master_taxonomy_job_worker.py", line 31, in main had_work = run_master_taxonomy_job_once(worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/app/jobs/master_taxonomy_enqueue.py", line 90, in run_master_taxonomy_job_once job = claim_next_master_taxonomy_job(session, worker_id=worker) File "/home2/devpiesol/plytix.dev.piesol.com/db/master_taxonomy_jobs.py", line 84, in claim_next_master_taxonomy_job stale_rows = session.scalars( File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2459, in scalars 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 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home2/devpiesol/plytix.dev.piesol.com/.venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, 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 714, in checkout dbapi_connection = rec.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)