SNOW-976424: Getting no active warehouse in the session, when trying to query warehouse.

[akshaysasidrn]

1. What version of NodeJS driver are you using?
   v1.6.23

2. What operating system and processor architecture are you using?
   node:18.3.0-buster image for x86

3. What version of NodeJS are you using?
   18.3.0

4. What are the component versions in the environment (npm list)?
   @types/snowflake-sdk@^1.6.12
   snowflake-sdk@^1.6.23

5.Server version:* E.g. 1.90.1
You may get the server version by running a query:

SELECT CURRENT_VERSION();

CURRENT_VERSION(): "7.41.0"

6. What did you do?

I'm creating a connection with explicitly mentioned warehouse to snowflake. This connection is then stored in memory.
https://github.com/ToolJet/ToolJet/blob/develop/plugins/packages/snowflake/lib/index.ts#L70
After a certain point of time, the connection gets no active warehouse in the session error.

What we have tried so far:

• Tried using use warehouse xyz when the connection loses active warehouse. But we get the same not active warehouse error.
• Tried recreating a new connection to the warehouse. Then tried running a query with the newly created connection to find it also has no active warehouse in connection error.

7. What did you expect to see?
   Given that warehouse is explicitly mentioned, did not expect to see active warehouse error

8. Can you set logging to DEBUG and collect the logs?
   No I don't have access to do that.

9. What is your Snowflake account identifier, if any? (Optional)

[sfc-gh-dszmolka]

hi and thank you for submitting this issue ! given that couple of releases are already after 1.6.23 with bugfixes, could you please as a first step upgrade to 1.9.1 and see if it still reproduces the issue for you ?

if it does, kindly please try to:

1. use session keepalive or connection eviction (if you're using pooled connections) and see if it helps. See the Snowflake documentation or connection pool does not seem to evict closed connections #336 (comment) for configuration details

2. if the issue is still there with 1.9.1 and session keepalive/idle connection eviction, please provide a repro script and scenario which when run, leads to this situation you're experiencing.
   thank you so much in advance !

[akshaysasidrn]

Thanks for the suggestion.
We had already kept clientSessionKeepAlive as true but not clientSessionKeepAliveHeartbeatFrequency.
Let me upgrade the SDK version and put reduced heartbeat frequency in too.

[sfc-gh-dszmolka]

closing this issue as there was no response for two weeks. If you still need assistance, let us know please and i can reopen if necessary.