Snowflake Datasource was Invalidated

[nickzombolas]

Description

While using an SQL Worksheet in my Snowflake connection, I will frequently get a notification saying "Datasource has been Invalidated". This causes the window focus to move from the text editor, to the notification, blocking me from typing and preventing autocomplete from working once focus returns to the text. It seems like getting info on my schema (for autocomplete or otherwise) is crashing the connection.

Here are the error logs when this occurs, and the stacktrace for the first error:

Here are also the system logs from launching dbeaver, to typing my query, to failure. After this point, it then tries to read all my databases and fails, but i've left of the logs for databases besides the one i'm interested in.

dbeaver-system-logs.txt

DBeaver Version

24.2.0.202409011755 Community

Operating System

Arch Linux 6.6.47-1-lts

Database and driver

Database: Snowflake Driver: Snowflake JDBC driver

Steps to reproduce

• launch dbeaver (sql worksheet is already open)
• begin to type query select * from <table_name>.<schema>
• usually around the time i'm typing my schema I will get the datasource invalidated notification

Additional context

No response

[Matvey16]

@nickzombolas Does this happen immediately after you open SQL Editor? THis may be working as expected if you left connection open for some time and then returned to it.

Does this also happen two or more times in a row?

[nickzombolas]

@Matvey16 The behavior can occur anytime whether the editor is freshly opened or has been open for an hour or more. I can type whatever I want in the editor, but the moment i'm typing . the connection will invalidate.

And yes it happens multiple times in a row. To type an entire .. the database could invalidate 5 times. It seems like on keystroke a process is run to check my schemas and tables for autocomplete suggestions, but fails, so to type a long schema/table name it will fail multiple times.