-
Notifications
You must be signed in to change notification settings - Fork 167
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
SnowflakeLoggedFeatureNotSupportedException being thrown from getObject(int columnIndex, Class<T> type) after driver upgrade #1431
Comments
Hi @itaseskii , I don't see any changes in JDBC driver code that would cause this exception since we never supported Can you do the same test using JDBC 3.13.19 and provide me the log? |
Hi @itaseskii , did you had a chance to re-run the test with 3.13.19 as requested? |
Hey @sfc-gh-spanaite that was my conclusion as well. Making a comparison of the source code between 3.13.19 and 3.13.20 |
Hi @itaseskii , thanks for providing the logs but they only confirm my suspicion: you get exactly the same stack trace on both versions:
{"timestamp":"1687901317779","message":{"type":"client_sql_exception","DriverType":"JDBC","DriverVersion":"3.13.19","SQLState":"0A000","Stacktrace":"net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException\n\t
at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getObject(SnowflakeBaseResultSet.java:1291)\n\t
at com.zaxxer.hikari.pool.HikariProxyResultSet.getObject(HikariProxyResultSet.java)\n\t
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.getObject(AbstractJdbcCompatibleSourceOperations.java:229)\n\t
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.putTimestamp(AbstractJdbcCompatibleSourceOperations.java:135)\n\t
at io.airbyte.db.jdbc.JdbcSourceOperations.copyToJsonField(JdbcSourceOperations.java:60)\n\t
{"timestamp":"1687900297044","message":{"type":"client_sql_exception","DriverType":"JDBC","DriverVersion":"3.13.20","SQLState":"0A000","Stacktrace":"net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException\n\t
at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getObject(SnowflakeBaseResultSet.java:1291)\n\t
at com.zaxxer.hikari.pool.HikariProxyResultSet.getObject(HikariProxyResultSet.java)\n\t
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.getObject(AbstractJdbcCompatibleSourceOperations.java:229)\n\t
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.putTimestampWithTimezone(AbstractJdbcCompatibleSourceOperations.java:239)\n\t
at io.airbyte.db.jdbc.JdbcSourceOperations.copyToJsonField(JdbcSourceOperations.java:61)\n\t To me this looks to be something coming from Airbyte since they use a |
Hey @sfc-gh-spanaite, that isn't the case in the integration tests. the tests with 3.13.19 are passing without any issue or SnowflakeLoggedFeatureNotSupportedException log. Initially I thought that it might be a different code path being executed between the versions but the error log that I have sent you shows the SnowflakeLoggedFeatureNotSupportedException being present in both files... |
@itaseskii Can you maybe give me a sample code of the tests you're running? I've tried reproducing from my side with both 3.13.19 and 3.13.20 and I get exactly the same stack trace and exception and the log looks identical. The only change that I can see in 3.13.20 was to map Without a sample code for the integration test that's failing it will be hard to confirm if this is coming from our JDBC driver. |
@itaseskii Do you still have the issue and if yes can you provide me a sample code? |
Hi @itaseskii , I am closing this issue since I've not received any feedback from you. If you still have the issue feel free to open a new issue and provide a sample code. |
Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!
3.13.30 (Issue starts appearing from 3.13.20 onwards)
Linux Debian x86_64
Java 17
In the Airbyte destination Snowflake connector we have upgraded the driver from 3.13.19 to 3.13.30 and have started getting
net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException
fromresultSet.getObject(index, OffsetDateTime.class)
airbytehq/airbyte#25849
The object being returned as OffsetDateTime as previously without any errors.
snowflake_jdbc0.log
The text was updated successfully, but these errors were encountered: