Issue with Airbyte Cluster Deployment on Kubernetes

Slack Knowledge Base Q&A API, Terraform and Other Topics
, , , ,
1

Summary

User is experiencing an internal server error after redeploying Airbyte version 0.63.11 on Kubernetes. The error is related to a SQL query involving a left outer join on the ‘user’ and ‘auth_user’ tables, specifically with the ‘updated_at’ field. The user is inquiring about potential schema changes in the PostgreSQL database and where to find related information in the Airbyte repository.


Question

Hi friends :wave:

I am having an issue with my airbyte cluster deployed on kubernetes. I had 0.63.11 deployed which was working and wanted to upgrade to 1.2.0 - managed to deploy 1.2.0 but had some issues so now trying to redeploy back 0.63.11. I could redeploy 0.63.11 successfully via helm but when I launch the UI, I am now seeing the following error:

"message": "Internal Server Error: SQL [select * from \"public\".\"user\" left outer join \"public\".\"auth_user\" on \"public\".\"user\".\"id\" = \"public\".\"auth_user\".\"user_id\" where \"public\".\"user\".\"id\" = cast(? as uuid)]; Error while reading field: \"public\".\"user\".\"updated_at\", at JDBC index: 11",
    "exceptionClassName": "org.jooq.exception.DataAccessException",
    "exceptionStack": [
      "org.jooq.exception.DataAccessException: SQL [select * from \"public\".\"user\" left outer join \"public\".\"auth_user\" on \"public\".\"user\".\"id\" = \"public\".\"auth_user\".\"user_id\" where \"public\".\"user\".\"id\" = cast(? as uuid)]; Error while reading field: \"public\".\"user\".\"updated_at\", at JDBC index: 11",
      "\tat org.jooq_3.19.7.POSTGRES.debug(Unknown Source)",
      "\tat org.jooq_3.19.7.POSTGRES.debug(Unknown Source)",
[...]```
Any idea on how I can get around this issue?

Is there a schema change applied on deployment on the postgres db tied to my deployment?

If so where can I find it in the airbyte repo so that I can fix my DB manually?

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1732526337697119) if you want
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
['airbyte', 'kubernetes', 'helm', 'postgres', 'sql-error', 'schema-change']
</sub>
2

Yes, bootloader performs database migrations

3

You might check migrations subfolder
https://github.com/airbytehq/airbyte-platform/tree/main/airbyte-db/db-lib/src/main/java/io/airbyte/db/instance/configs/migrations