Skip to content
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

Pool/snow 860872 connection pool #913

Closed
wants to merge 8 commits into from

Conversation

sfc-gh-knozderko
Copy link
Collaborator

Description

Please explain the changes you made here.

Checklist

  • Code compiles correctly
  • Code is formatted according to Coding Conventions
  • Created tests which fail without the change (if possible)
  • All tests passing (dotnet test)
  • Extended the README / documentation, if necessary
  • Provide JIRA issue id (if possible) or GitHub issue id in PR name

sfc-gh-mhofman and others added 7 commits November 9, 2023 16:31
### Description
Connection Pool v2
- introduction of connection manager handling multiple pool of sessions
- ability to switch Connection Manager between v1 and v2
- controlling pool settings for each pool independently
- default pool version: v1

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
### Description
Split integration tests for different connection pools.

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
### Description
Connection Pool v2:
- introduction of a counter of busy sessions created by Pool Manager
- pool size counts both: Idle and Busy sessions

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
### Description
SNOW-937190 Wait for idle sessions available if session count exceeds
max count

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
### Description
SNOW-902632 connection string driven pool config

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
### Description
Min pool size

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
### Description
Fix flaky test TestWaitUntilResourceAvailable

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../blob/master/CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
Copy link

codecov bot commented Apr 9, 2024

Codecov Report

Attention: Patch coverage is 94.27609% with 51 lines in your changes are missing coverage. Please review.

Project coverage is 82.49%. Comparing base (22d32dd) to head (7db9d54).
Report is 48 commits behind head on master.

Files Patch % Lines
Snowflake.Data/Core/Session/SessionPool.cs 93.31% 10 Missing and 11 partials ⚠️
...Data/Core/Session/SFSessionHttpClientProperties.cs 90.00% 7 Missing and 3 partials ⚠️
Snowflake.Data/Client/SnowflakeDbConnectionPool.cs 92.85% 2 Missing and 2 partials ⚠️
...flake.Data/Core/Session/SessionOrCreationTokens.cs 82.60% 2 Missing and 2 partials ⚠️
Snowflake.Data/Core/Session/WaitingQueue.cs 92.59% 3 Missing and 1 partial ⚠️
...ion/SessionPropertiesWithDefaultValuesExtractor.cs 96.42% 1 Missing and 2 partials ⚠️
...owflake.Data/Core/Session/ConnectionPoolManager.cs 97.75% 1 Missing and 1 partial ⚠️
...flake.Data/Core/Session/SessionPoolEventHandler.cs 80.00% 2 Missing ⚠️
Snowflake.Data/Core/Session/SFSession.cs 93.75% 0 Missing and 1 partial ⚠️
Additional details and impacted files
@@            Coverage Diff             @@
##           master     #913      +/-   ##
==========================================
- Coverage   83.56%   82.49%   -1.07%     
==========================================
  Files          89      104      +15     
  Lines        9155     9916     +761     
  Branches      837      917      +80     
==========================================
+ Hits         7650     8180     +530     
- Misses       1278     1488     +210     
- Partials      227      248      +21     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

…ol (#912)

### Description
Prevent evicted connections from returning to the pool

### Checklist
- [x] Code compiles correctly
- [x] Code is formatted according to [Coding
Conventions](../blob/master/CodingConventions.md)
- [x] Created tests which fail without the change (if possible)
- [x] All tests passing (`dotnet test`)
- [x] Extended the README / documentation, if necessary
- [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name
@github-actions github-actions bot locked and limited conversation to collaborators Apr 15, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants