Hi, I am trying to deploy airbyte on kube and in b...
# ask-community-for-troubleshooting
a
Hi, I am trying to deploy airbyte on kube and in bootloader i am getting below error, can someone help please.
Copy code
CREATE
    INDEX IF NOT EXISTS airbyte_configs_id_idx ON
    AIRBYTE_CONFIGS(config_id);
]; ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
  Detail: Key (typname, typnamespace)=(airbyte_configs_id_seq, 2200) already exists.
	at org.jooq_3.13.4.POSTGRES.debug(Unknown Source)
m
This is the first time are you deploying Airbyte?
a
yes @Marcos Marx (Airbyte)
m
Can you share the complete logs, did it fail initiating Airbyte?
a
yes, when i applied the config, using kubectl apply -k kube/overlays/stable, the booloader was up for few seconds and then failed with below error. @Marcos Marx (Airbyte)
Copy code
]; ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
  Detail: Key (typname, typnamespace)=(airbyte_configs_id_seq, 2200) already exists.
	at org.jooq_3.13.4.POSTGRES.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:2753)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:385)
	at org.jooq.impl.DefaultDSLContext.execute(DefaultDSLContext.java:1139)
	at io.airbyte.db.instance.configs.ConfigsDatabaseInstance.lambda$getAndInitialize$5(ConfigsDatabaseInstance.java:81)
	at io.airbyte.db.Database.lambda$transaction$0(Database.java:37)
	at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$0(DefaultDSLContext.java:564)
	at org.jooq.impl.Tools$12$1.block(Tools.java:4926)
	at java.base/java.util.concurrent.ForkJoinPool.unmanagedBlock(ForkJoinPool.java:3463)
	at java.base/java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3434)
	at org.jooq.impl.Tools$12.get(Tools.java:4923)
	at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:616)
	at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:533)
	at io.airbyte.db.Database.transaction(Database.java:37)
	at io.airbyte.db.ExceptionWrappingDatabase.transaction(ExceptionWrappingDatabase.java:31)
	at io.airbyte.db.instance.configs.ConfigsDatabaseInstance.getAndInitialize(ConfigsDatabaseInstance.java:75)
	at io.airbyte.bootloader.BootloaderApp.getConfigDatabase(BootloaderApp.java:167)
	at io.airbyte.bootloader.BootloaderApp.main(BootloaderApp.java:212)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
  Detail: Key (typname, typnamespace)=(airbyte_configs_id_seq, 2200) already exists.
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:167)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:156)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:453)
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:371)
	... 15 more