Ayush
05/11/2022, 10:55 AMCREATE
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)
Marcos Marx (Airbyte)
05/11/2022, 10:58 AMAyush
05/11/2022, 11:01 AMMarcos Marx (Airbyte)
05/11/2022, 11:05 AMAyush
05/11/2022, 11:06 AM]; 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