{"record":{"id":"4c669faca8ef31f2","repo":"ruvnet/RuView","slug":"postgresql-connection-failed-and-failsafe-disabled","errorCode":null,"errorMessage":"PostgreSQL connection failed and failsafe disabled: {e}","messagePattern":"PostgreSQL connection failed and failsafe disabled: (.+?)","errorType":"exception","errorClass":"DatabaseConnectionError","httpStatus":null,"severity":"error","filePath":"archive/v1/src/database/connection.py","lineNumber":81,"sourceCode":"        except Exception as e:\n            logger.error(f\"Failed to initialize database connections: {e}\")\n            raise DatabaseConnectionError(f\"Database initialization failed: {e}\")\n    \n    async def _initialize_postgresql(self):\n        \"\"\"Initialize PostgreSQL connections with SQLite failsafe.\"\"\"\n        postgresql_failed = False\n        \n        try:\n            # Try PostgreSQL first\n            await self._initialize_postgresql_primary()\n            logger.info(\"PostgreSQL connections initialized\")\n            return\n        except Exception as e:\n            postgresql_failed = True\n            logger.error(f\"PostgreSQL initialization failed: {e}\")\n            \n            if not self.settings.enable_database_failsafe:\n                raise DatabaseConnectionError(f\"PostgreSQL connection failed and failsafe disabled: {e}\")\n            \n            logger.warning(\"Falling back to SQLite database\")\n        \n        # Fallback to SQLite if PostgreSQL failed and failsafe is enabled\n        if postgresql_failed and self.settings.enable_database_failsafe:\n            await self._initialize_sqlite_fallback()\n            logger.info(\"SQLite fallback database initialized\")\n    \n    async def _initialize_postgresql_primary(self):\n        \"\"\"Initialize primary PostgreSQL connections.\"\"\"\n        # Build database URL\n        if self.settings.database_url and \"postgresql\" in self.settings.database_url:\n            db_url = self.settings.database_url\n            async_db_url = self.settings.database_url.replace(\"postgresql://\", \"postgresql+asyncpg://\")\n        elif self.settings.db_host and self.settings.db_name and self.settings.db_user:\n            db_url = (\n                f\"postgresql://{self.settings.db_user}:{self.settings.db_password}\"\n                f\"@{self.settings.db_host}:{self.settings.db_port}/{self.settings.db_name}\"","sourceCodeStart":63,"sourceCodeEnd":99,"githubUrl":"https://github.com/ruvnet/RuView/blob/4685618388a5e49fad5b3005806f3bdd6a7c25c3/archive/v1/src/database/connection.py#L63-L99","documentation":"Error \"PostgreSQL connection failed and failsafe disabled: {e}\" thrown in ruvnet/RuView.","triggerScenarios":"Thrown at archive/v1/src/database/connection.py:81 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"4685618388a5e49fad5b3005806f3bdd6a7c25c3","analyzedAt":"2026-08-16T06:09:40.886Z","schemaVersion":2},"datasetVersion":"2026-08-16T08:17:34.114Z"}