Error during Airbyte upgrade from 0.49.23 to 1.0.0

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

The user encountered an error related to SQL schema version compatibility while upgrading Airbyte, indicating that the ‘schema_version’ relation does not exist in the database.


Question

[Fx] PROVIDE	fx.DotGraph &lt;= <http://go.uber.org/fx.(*App).dotGraph-fm()|go.uber.org/fx.(*App).dotGraph-fm()>
[Fx] RUN	supply: stub([]temporal.ServerOption)
[Fx] RUN	provide: <http://go.temporal.io/server/temporal.ServerOptionsProvider()|go.temporal.io/server/temporal.ServerOptionsProvider()>
[Fx] Error returned: received non-nil error from function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".ServerOptionsProvider
	/home/builder/temporal/temporal/fx.go:180:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: airbyte_temporal_dev error: pq: relation "schema_version" does not exist
[Fx] ERROR		Failed to initialize custom logger: could not build arguments for function "<http://go.uber.org/fx|go.uber.org/fx>".(*module).constructCustomLogger.func2
	/go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251:
failed to build fxevent.Logger:
could not build arguments for function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".init.func8
	/home/builder/temporal/temporal/fx.go:1029:
failed to build log.Logger:
received non-nil error from function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".ServerOptionsProvider
	/home/builder/temporal/temporal/fx.go:180:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: airbyte_temporal_dev error: pq: relation "schema_version" does not exist
Unable to create server. Error: could not build arguments for function "<http://go.uber.org/fx|go.uber.org/fx>".(*module).constructCustomLogger.func2 (/go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251): failed to build fxevent.Logger: could not build arguments for function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".init.func8 (/home/builder/temporal/temporal/fx.go:1029): failed to build log.Logger: received non-nil error from function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".ServerOptionsProvider (/home/builder/temporal/temporal/fx.go:180): sql schema version compatibility check failed: unable to read DB schema version keyspace/database: airbyte_temporal_dev error: pq: relation "schema_version" does not exist.```
i am upgrading airbyte version to 1.0.0 from 0.49.23 i am getting the above error can anyone help me out

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

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

<sub>
['airbyte-upgrade', 'sql-schema', 'error', 'schema-version', 'temporal']
</sub>