hi there. I'm setting up Airbyte <v0.40.33-helm> ...
# replication-troubleshooting
c
hi there. I'm setting up Airbyte v0.40.33-helm on AWS EKS and using an external Aurora Postgres 10.20 for its metadata. However, I'm having issues in the bootlaoder pod failing with . Does anyone knows what might be the issue? or if we need to use a specific RDS PG version?
Copy code
2022-10-27 09:21:09 INFO i.a.c.EnvConfigs(getEnvOrDefault):1079 - Using default value for environment variable RUN_DATABASE_MIGRATION_ON_STARTUP: 'true'
2022-10-27 09:21:09 INFO i.a.b.BootloaderApp(runFlywayMigration):342 - Migrating configs database
2022-10-27 09:21:09 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Flyway Community Edition 7.14.0 by Redgate
2022-10-27 09:21:09 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Successfully validated 27 migrations (execution time 00:00.013s)
2022-10-27 09:21:09 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Current version of schema "public": 0.40.11.002
2022-10-27 09:21:09 INFO o.f.c.i.l.s.Slf4jLog(info):49 - Migrating schema "public" to version "0.40.12.001 - AddWebhookOperationColumns"
2022-10-27 09:21:09 INFO i.a.d.i.c.m.V0_40_12_001__AddWebhookOperationColumns(migrate):22 - Running migration: V0_40_12_001__AddWebhookOperationColumns
2022-10-27 09:21:09 ERROR o.f.c.i.l.s.Slf4jLog(error):57 - Migration of schema "public" to version "0.40.12.001 - AddWebhookOperationColumns" failed! Changes successfully rolled back.
Caused by: org.jooq.exception.DataAccessException: SQL [alter type "operator_type" add value 'webhook']; ERROR: ALTER TYPE ... ADD cannot run inside a transaction block
I tried with an RDS Postgres 14.3 and it worked
issue seems to be limited to the AWS Aurora only
s
Hey there, it's very odd that it's specific to Aurora, we definitely want to look into this. Can you report this in github? Also can you try the latest airbyte in case there was relevant changes, we now have airbyte-0.40.35.tgz