Questions tagged [connection-pooling]
In software engineering, a connection pool is a cache of connections maintained so that the connections can be reused when future requests to the resource are required.
connection-pooling
3,298
questions
-1
votes
0
answers
16
views
HikariCP Read timed out
I've been getting the following stack track in my production logs, but haven't been able to determine a process to reproduce the errors or a reason why the error is occurring. Any clues regarding the ...
- 951
0
votes
0
answers
21
views
2024-07-16 21:26:40,575 - WARNING - Connection pool is full, discarding connection: storage.googleapis.com
I'm working on a Python script that downloads images from an Amazon S3 bucket and uploads them to Google Cloud Storage (GCS) using the google-cloud-storage library. The script processes a large ...
- 2,545
0
votes
0
answers
38
views
Connection Pool turns slow at the first call after an inactivity period(15 Mins)
I've set a connection pool with Java and MySQL, also with SQL Server, using 'org.apache.commons.dbcp2'. once the connection pool is connected to the server everything works perfect, the pool responses ...
0
votes
0
answers
56
views
NullReferenceException at C# SqlConnection Open
From time to time at my Windows 10 system background program in C#, I get a NullReferenceException at this.connection.Open().
My class:
private SqlConnection connection;
private string ...
0
votes
1
answer
36
views
HikariCP keep alive query leaking Google Spanner Sessions
I have a spring boot application using HikariCP. The app connects to a google spanner db. I am seeing the following session leak exception caused by HikariCP keep alive queries
at com.google.cloud....
- 113
0
votes
0
answers
32
views
How to handle connection pooling in multitenant app (multiple app server and tenant per db)?
We are trying to build a multi-tenant app(using spring boot) with single db per tenant. We currently have less than 100 tenants but we expect around 1000 in 2-3 years.
We have multiple app server ...
- 1
1
vote
0
answers
29
views
Single database connection vs database connection pool
My understanding of a connection pool is that multiple connections to the database hang around and a client application can use them in order to send queries to the database, without having to go ...
- 11
0
votes
3
answers
92
views
Apache HttpClient PoolingHttpClientConnectionManager - allocated to maximum
I have set up PoolingHttpClientConnectionManager (with ssl):
private PoolingHttpClientConnectionManager getConnManager(
Registry<ConnectionSocketFactory> socketFactoryRegistry) {
...
- 11
1
vote
2
answers
87
views
How does connection pooling work in python multiprocessing?
With python multiprocessing, Let's assume, I'm creating 10 processes by forking the main process. We know that child process inherit the state of the parent process in its own memory space.
I have a ...
- 63
0
votes
0
answers
19
views
java.net.SocketTimeoutException retrofit
We are using a Retrofit 2.6 client to call a partner server, but for some calls, we are getting a socket connection timeout exception. We also have a Step Functions activity poller implemented within ...
0
votes
0
answers
16
views
Hystric Thread Pool is creating new database connection for each DB requests
I am using springboot application talking to mysql database. I have also enabled hystrix threadpool in it.
1 API requests is making 10 db requests.
Now since i have hystrix threadpool enabled, 1 http ...
0
votes
0
answers
27
views
Why are connections not being stored in the pool when using psycopg2 with ThreadedConnectionPool?
I'm using psycopg2 with ThreadedConnectionPool in a Python script to manage PostgreSQL database connections. However, it seems like the connections are not being stored in the pool as expected. Below ...
- 125
0
votes
0
answers
25
views
Is unwrapped connection returned to Hikari connection pool in springboot (spring-data-jpa)
I have a spring-boot REST API which calls Stored Procedure from Oracle database. I have implemented Hikari connection pooling and specified JDBC connection credentials in application.properties.
The ...
- 11
0
votes
1
answer
92
views
How are connections handled by SQLAlchemy internally
Context
Hello, I mostly use Django for my main backend monolith. In Django, you do not need to handle db connections on your own, this is abstracted (because Django uses the Active Record pattern ...
- 2,013
0
votes
0
answers
56
views
MySQL2 Connection Pooling
I am trying to connect to my database using a connection pool. The rest api uses node and express and I'm using mysql/promise for the connection pool but when I run the code I get an error
this is my ...
- 1