Error deploying Airbyte 1.0.0 on Kubernetes with external Postgres

Slack Knowledge Base Q&A Platform Questions
, , , ,
1

Summary

Error initializing temporal server pods due to SQL schema version mismatch in Airbyte deployment on Kubernetes with external Postgres.


Question

Hello. I’m facing an issue deploying Airbyte 1.0.0 on kubernetes using an external Postgres. The temporal server pods keeps failing to initialize. This is the error:

        /home/builder/temporal/temporal/fx.go:180:
sql schema version compatibility check failed: version mismatch for keyspace/database: "temporal". Expected version: 1.11 cannot be greater than Actual version: 0.0```
I also configured some vaaribles on temporal section:
```temporal:
  enabled: true
  replicaCount: 1
  extraEnv:
    - name: POSTGRES_TLS_ENABLED
      value: "true"
    - name: POSTGRES_TLS_DISABLE_HOST_VERIFICATION
      value: "true"
    - name: SQL_TLS_ENABLED
      value: "true"
    - name: SQL_TLS_DISABLE_HOST_VERIFICATION
      value: "true"```

<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/p1727964735406459) if you want 
to access the original thread.

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

<sub>
["airbyte-platform", "kubernetes", "external-postgres", "temporal-server", "sql-schema", "version-mismatch"]
</sub>