[destination-postgres] java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: numeric field overflow Detail: A field with precision 38, scale 9 must round to an absolute value less than 10^29.

[shellking4]

Connector Name

destination-postgres

Connector Version

2.0.9

What step the error happened?

During the sync

Relevant information

java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: numeric field overflow Detail: A field with precision 38, scale 9 must round to an absolute value less than 10^29.

Relevant log output

java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: numeric field overflow   Detail: A field with precision 38, scale 9 must round to an absolute value less than 10^29.

Contribute

• Yes, I want to contribute

[marcosmarxm]

@shellking4 what source are you using? It can help replicate the issue to fix them. I added the issue to the destination team backlog for further investigation.

[shellking4]

Hey @marcosmarxm
I'm using CoingMarketCap source

[oramaz]

faced the same issue with postgres-postgres replication
any updates?

[WallucePinkham]

Any updates, please?

2024-11-08 10:22:17 destination > ERROR type-and-dedupe i.a.c.i.d.j.t.JdbcDestinationHandler(execute):180 Sql af48b873-7348-41e5-b2d9-d9242044e30d-1997affd-6203-4328-9830-334dae5d6e14 failed org.postgresql.util.PSQLException: ERROR: numeric field overflow
Detail: A field with precision 38, scale 9 must round to an absolute value less than 10^29.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:356) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:341) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:317) ~[postgresql-42.7.4.jar:42.7.4]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:312) ~[postgresql-42.7.4.jar:42.7.4]
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-5.1.0.jar:?]
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-5.1.0.jar:?]
at io.airbyte.cdk.db.jdbc.JdbcDatabase.executeWithinTransaction$lambda$1(JdbcDatabase.kt:67) ~[airbyte-cdk-core-0.46.0.jar:?]
at io.airbyte.cdk.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.kt:30) ~[airbyte-cdk-core-0.46.0.jar:?]
at io.airbyte.cdk.db.jdbc.JdbcDatabase.executeWithinTransaction(JdbcDatabase.kt:61) ~[airbyte-cdk-core-0.46.0.jar:?]
at io.airbyte.cdk.db.jdbc.JdbcDatabase.executeWithinTransaction$default(JdbcDatabase.kt:60) ~[airbyte-cdk-core-0.46.0.jar:?]
at io.airbyte.cdk.integrations.destination.jdbc.typing_deduping.JdbcDestinationHandler.execute(JdbcDestinationHandler.kt:178) ~[airbyte-cdk-db-destinations-0.46.0.jar:?]
at io.airbyte.integrations.destination.postgres.typing_deduping.PostgresDestinationHandler.execute(PostgresDestinationHandler.kt:78) ~[io.airbyte.airbyte-integrations.connectors-destination-postgres.jar:?]
at io.airbyte.integrations.base.destination.typing_deduping.TyperDeduperUtil.executeTypeAndDedupe(TyperDeduperUtil.kt:219) ~[airbyte-cdk-typing-deduping-0.46.0.jar:?]
at io.airbyte.integrations.base.destination.typing_deduping.DefaultTyperDeduper.typeAndDedupeTask$lambda$5(DefaultTyperDeduper.kt:288) ~[airbyte-cdk-typing-deduping-0.46.0.jar:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.base/java.lang.Thread.run(Thread.java:1583) [?:?]

I am using Postgres 13, if that helps.