@kapa.ai I got http 409 fail to access database after testing the source

The HTTP 409 "Failed to access database" error after testing a source in Airbyte is a known issue, especially in the context of recent upgrades or changes to the Airbyte platform or its database. The logs and user reports indicate that this error is often accompanied by messages like:

Failed to access database. Check the server logs for more information exceptionClassName: io.airbyte.commons.server.errors.ConflictException

and sometimes by SQL errors such as:

Cannot cast to boolean: "4c36dc56-dd7c-4722-accf-0559f08ad4f3"

This can be caused by: - Database schema mismatches or corruption: For example, a field expected to be a boolean contains a string/UUID, possibly due to failed or partial migrations. - Version incompatibility: The Airbyte application may be running against a PostgreSQL version or schema that is not fully compatible, as indicated by warnings like "Version mismatch: Database version is older than what dialect POSTGRES supports". - Upgrade/downgrade issues: Rolling back or upgrading Airbyte or its Helm chart without proper database migration can leave the schema in an inconsistent state, leading to these errors. - External database configuration issues: Some users reported this when using an external PostgreSQL database. Potential solutions mentioned by users: - Upgrading Airbyte to a newer version (e.g., from 1.3.1 to 1.5.1) resolved the issue for some users. - Ensuring that the database schema is fully migrated and matches the expected version for your Airbyte deployment. - Double-checking your PostgreSQL version and compatibility with your Airbyte version. Note: Simply rolling back to an older version may not resolve the issue if the database schema has already been changed by a newer version. Always ensure your database migrations are complete and compatible with your Airbyte version before and after upgrades or downgrades. For more details and user experiences, see the discussion in this issue: ["Cannot cast to boolean" and "Failed to access database" DB errors + HTTP 409 error](https://github.com/airbytehq/airbyte/issues/54150).

@kapa.ai Airbyte version is 1.5.1 and the database is PostgreSQL 13, are they compatible with each other?

A message from kapa.ai