https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
o

Osinachi Chukwujama

09/08/2021, 6:36 AM
Just to add When new sync occurs, the table are created on Snowflake, but no data transfer occurs.
1
d

Davin Chia (Airbyte)

09/08/2021, 6:42 AM
I see this error:
Copy code
permission denied for table new_users_2021_09_03
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.integrations.source.relationaldb.AbstractRelationalDbSource.lambda$queryTable$15(AbstractRelationalDbSource.java:451)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.commons.util.LazyAutoCloseableIterator.computeNext(LazyAutoCloseableIterator.java:57)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.TransformedIterator.hasNext(TransformedIterator.java:42)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:58)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.TransformedIterator.hasNext(TransformedIterator.java:42)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:58)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.commons.util.CompositeIterator.computeNext(CompositeIterator.java:83)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:58)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at java.base/java.util.Iterator.forEachRemaining(Iterator.java:132)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:139)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.integrations.source.postgres.PostgresSource.main(PostgresSource.java:266)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: permission denied for table new_users_2021_09_03
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.db.jdbc.StreamingJdbcDatabase.query(StreamingJdbcDatabase.java:114)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.db.jdbc.JdbcDatabase.query(JdbcDatabase.java:140)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.integrations.source.relationaldb.AbstractRelationalDbSource.lambda$queryTable$15(AbstractRelationalDbSource.java:448)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	... 20 more
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for table new_users_2021_09_03
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	at io.airbyte.db.jdbc.StreamingJdbcDatabase.query(StreamingJdbcDatabase.java:104)
2021-09-08 05:25:31 ERROR () LineGobbler(voidCall):85 - 	... 22 more
are the right permissions assigned?
g

George Claireaux (Airbyte)

09/08/2021, 8:48 AM
since this is the same issue (https://airbytehq.slack.com/archives/C021JANJ6TY/p1631079036240300) let's keep it in this thread
o

Osinachi Chukwujama

09/08/2021, 9:01 PM
Yes, it has been resolved now
👍 1
2 Views