Authentication token has expired. The user must authenticate again error

Issue description

When left for a period of time without using it, the snowflake driver seems to throw an “Authentication token has expired. The user must authenticate again” exception the next time you go to use it even on a freshly initialised connection. This goes away when restarting the application. I suspect the currently internal connection pool controls may fix this, but I’m not sure. Is there a way we can re-fetch an Authentication token with the driver currently so a fresh connection is actually a new connection?

Example code

N/A

Error log

If you have an error log, please paste it here.
System.Exception: - Error: Authentication token has expired. The user must authenticate again. SqlState: , VendorCode: 390114, QueryId: - Snowflake.Data.Client.SnowflakeDbException

### Configuration
Version: 2.0.16

Framework Version: Dotnet 6

Issue Analytics

State:
Created a year ago
Comments:8

Top GitHub Comments

3reactions

ehertleincommented, Sep 18, 2022

Unless I am misunderstanding your issues, these are all from the same root problem in that the connection pooling isn’t implemented correctly. We had similar issue and downgraded to 2.0.13 before connection pooling was introduced.

You can see here that your OpenAsync() is really just pulling from the pool and your CloseAsync() is just releasing connections into the pool.

0reactions

garethreptoncommented, Oct 19, 2022

I haven’t seen this error since updating to this version. Combined with others saying this is fixed for them, I think it’s safe to close right now.