111 questions
0
votes
1
answer
101
views
Connection pool issue in hibernate 6 spring boot 3 [closed]
I recently migrated my application from Spring Boot 2 with Hibernate 5 to Spring Boot 3 with Hibernate 6 in a testing environment. Since the migration, I encounter issues during high load (overload ...
- 21
0
votes
0
answers
151
views
ConnectionError: SERVER_CLOSED_CONNECTION_ERROR when connecting to multiple Redis hosts
I am trying to connect to multiple Redis hosts using Python's redis-py library. Here’s the code I am using:
import redis
self.redis_client = redis.Redis(
host=self.host,
port=int(self.port),
...
0
votes
1
answer
468
views
psycopg_pool.ConnectionPool conninfo WARNING error connecting in 'pool-1': [Errno -2] Name or service not known
with ConnectionPool(
conninfo = app.config["POSTGRESQL_DATABASE_URI"],
max_size = app.config["DB_MAX_CONNECTIONS"],
kwargs = connection_kwargs,
) as pool:
With a ...
- 4,366
1
vote
0
answers
252
views
Pgbouncer Sidecar: Addressing connection pooling and load balancing issues
I'm currently using TypeORM with RDS Aurora PostgreSQL, and I'm considering introducing PgBouncer to address the following two issues:
The node-postgres library used by TypeORM doesn't support the ...
- 11
1
vote
1
answer
895
views
Connection to HTTPSConnectionPool broken by ReadTimeoutError (Retrying)
When executed, the code below takes a long time.
for index,row in d_airbnb.iterrows(): #Loop for para varrer cada linha.
latitude = row['latitude']
longitude = row['longitude']
location = ...
1
vote
1
answer
811
views
Random Npgsql Connection Timeout in .net6 Application
I have this piece of code in program.cs to initialize my pool with 5 connections in my .net6 application using postgres and Npgsql.
List<NpgsqlConnection> connections = new List<...
- 11
4
votes
2
answers
5k
views
Apache HttpClient 5 pool without timeout
We're upgrading from Apache HttpClient 4.5 to 5.2, and it seems there's been a significant change to how the pool timeout works. We want the pool configured so it has some fixed number of connections ...
- 51.1k
-1
votes
1
answer
176
views
How to improve simple connection pool to be less blocking
I have this simple connection pool, which seems to work fine, but it will block all readers of the method if there is a disconnect for any of the connections:
type RabbitMQConnectionPool struct {
...
- 102k
0
votes
0
answers
241
views
Can I using springboot application with hikariCP on JBoss WAS?
I implemented springboot application using hikari CP for database connection pooling. And now I need to deploy the application to the Jboss EAP server which has datasources configuration with ...
1
vote
0
answers
539
views
Creating a connection pool using all nodes in AWS opensearch cluster
I am using OpenSearch.Net client to connect to AWS opensearch. I want to use multiple nodes in a connection pool by following the example in this doc, but I would like to get the nodes through the /...
- 3,132
0
votes
0
answers
72
views
Changes needed in tomat configuration to avoid JDBC Connection pool exhaustion
We occasionaly hit org.apache.tomcat.jdbc.pool.PoolExhaustedException when threads are holding connections for too long or are going into a deadlock state.
Any recomendation to tweak in Tomcat's DB ...
- 3
0
votes
0
answers
201
views
DBCP connection property name issue
I am making a simple program using MyBatis.
At this time, I am having difficulty applying DBCP to the configuration file(mybatis-config.xml) containg DB connection information.
<property name="...
- 1
1
vote
1
answer
3k
views
Is it okay to use both connection pools in AWS RDS proxy and mysql connection pool in lambda?
I am now moving my website from EC2 to lambda+RDS and I don't have much experience in RDS. As you know, AWS RDS supports a proxy to provide a connection pool and the lambda MySQL node.js module also ...
- 92
1
vote
1
answer
3k
views
connect oracle apex application to multiple databases
is there any simple way to connect an oracle apex application to another database other than apex admin database (like using WebLogic data source).
I read this but there are a lot of problem with ...
1
vote
2
answers
196
views
Tomcat: Creating a connection pool for cloud API services
A Tomcat server worker thread replying to an incoming request must access at least one of several possible cloud API services (Google Cloud Storage in particular; non-modifying, that is, only ...
- 2,819
0
votes
1
answer
56
views
DataFormatException happened in OkHttpClient
I implementing the OkHttpClient in my service. When I hit 150+ connections in a connectionPool in the okHttpClient at a time, the below exception has been thrown. Any one aware of this exception. How ...
0
votes
1
answer
927
views
asyncpg Connection pool with aiohttp raise asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress
When I try to reproduce example with aiohttp from documentation
I get the error:
asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress
Exception raises ...
- 2,019
0
votes
0
answers
264
views
Java Jee getting a Connection pool configured in context.xml
I'm making a webapp using JSP and MYSQL.
I have set up a connection pool and used it in a Servlet, but I cannot access it.
I had to create manually the "lib" folder inside WEB-INF to put the ...
- 23
3
votes
0
answers
729
views
Sharing a connection pool for all Rails uses of Redis
Summary: I'm using a single Redis instance for the Rails cache, actioncable and (non-cache) use in my rails code. Should all these uses share a single connection pool and if so how can I config this ...
- 3,125
4
votes
2
answers
4k
views
When does a Hikari pool connections work? - Spring/Spring Boot
I have the below doubts on the Hikari or any database pooling concept.
When does the connection pool gets created?
Suppose if I have mentioned spring.datasource.hikari.maximum-pool-size=50
Will it ...
- 59
6
votes
1
answer
5k
views
How to avoid database connection pool from being exhausted when using FastAPI in threaded mode ( with `def` instead of `async def`)
I use FastAPI for a production application that uses asyncio almost entirely except when hitting the database. The database still relies on synchronous SQLAlchemy as the async version was still in ...
- 6,264
2
votes
0
answers
124
views
No connection pool for XX - ActiveRecord Error in Ruby on Rails
I created a method called connect_and_do_something like below;
What this method does is:
①to connect SampleModel with various databases passed as an argument db_name
②do something by using SampleModel
...
1
vote
1
answer
2k
views
What is the difference between pooling at Entity Framework vs SQL Server level?
I have a .NET 6 Web API that is hosted on server A. SQL Server is on server B. Both servers are in the same network.
Each endpoint of the Web API makes use of the Entity Framework to query data from ...
- 9,925
0
votes
1
answer
808
views
How to test Connection Pooling in nodeJS using mogoDB Database?
How to test Connection Pooling in NodeJS using MongoDB Database?
0
votes
1
answer
811
views
Testing Connection pool in Tomcat
I have a JDBC connection pool setup in tomcat server.
Code 1 takes more time than Code 2. My question is that if connection pool is working. Then it should parallelly open other connections and it ...
- 65
4
votes
2
answers
12k
views
Springboot JPA Repository not releasing Hikari DB Connection
I have a rest API in Springboot using Hikari for connection pooling. Hikari is used with default configurations (10 connections in the pool, 30 sec timeout waiting for a connection). The API itself is ...
- 349
1
vote
0
answers
468
views
python manage.py takes too much time to run in Django
I am working on Python rest framework and after setting up python 3.8.12 on my mac, when I tried to up the server with python manage.py runserver command for Django, it takes around 2 minutes and in-...
1
vote
1
answer
3k
views
how to fix Keystore was tampered with, or password was incorrect on glassfish server
i'm trying to create a connection pool and JDBC Resource to deploy a java application on glassfish server, however, I couldn't deploy the project, and this is what it said:
Error occurred during ...
2
votes
0
answers
120
views
Database Connection Pool Size
if you were hitting the ceiling on the max number of connections on your DB, what is peoples thoughts on having a smaller connection pool size than the number of threads * workers.
If you didn't want ...
- 615
0
votes
0
answers
151
views
Active connections on Oracle from app hosted on Glassfish 3.1.2
We have 3 app servers behind load balancer and each app server is connected to Oracle database.
We have setup connection pool of minimum 8 size and max 32 size.
Everytime I query database to see ...
1
vote
1
answer
6k
views
Is IIS running out of connections?
Our IIS website has its Maximum Concurrent Connections set to 4294967295. Our Web API application is logging all the requests it serves to Application Insights and the two do not appear to match up. A ...
- 12.7k
2
votes
3
answers
5k
views
How can I specify the current schema on quarkus datasource?
Hi I am trying to configure the quarkus to connect to a oracle database. With the current configuration I am able to connect to the database, but I cannot specify the current schema.
I followed the ...
0
votes
0
answers
561
views
Is it feasible to use database-per-tenant with 1000 tenants?
I would like to build a multi tenant Spring Boot application. I prefer persisting the data for every tenant in a separate database.
This approach implies the usage of a data source (and a connection ...
- 493
1
vote
2
answers
5k
views
Multiple DB connections using a connection pool vs Single connection with multiple statements
I am developing a server working with MySQL, and I have been trying to understand advantage of working with a connection pool vs a single connection that is kept open, and being passed down to the ...
- 31
2
votes
1
answer
1k
views
Database connection object is not callable exception thrown with Python Django SQL Alchemy database pooling. Why?
What I'm trying to achieve
Create a database connection pool in Django. The connection pool is connected to a PostgreSQL database by using SQLAlchemy's connection pooling with django-postgrespool2.
...
- 1,080
1
vote
1
answer
343
views
Add Configurations to a Singleton Object in Scala
I am trying to set up a connection pool to Redis in a Singleton Scala Object so that I can read/write to Redis while mapping partitions of a DF. I want to be able to configure the host, along with ...
- 207
1
vote
0
answers
253
views
Shared native connection in Redis
What is the shared native connection in Redis? How to understand it?
Thank you.
- 11
2
votes
1
answer
367
views
How wildfly resets properties set on connection when returned to connection pool
I am doing jndi lookup for datasource configured in JBOSS
DataSource dataSource = (DataSource) new InitialContext().lookup(dataSourceStr);
return dataSource.getConnection();
Connection is closed by ...
- 553
1
vote
1
answer
3k
views
Mysql Connection vs Connection Pool
I have 4 separate tables in the same database. Would it be better to use mysql2.createConnection() or mysql2.createPool to bulk insert into each table? I'd like to run the inserts asynchronously.
The ...
- 1,884
0
votes
0
answers
18
views
Spring boot, Tomcat connection pool when multiple spring boot applications are in same external tomcat container [duplicate]
Let's consider I have two Spring boot applications.
And say each configures 50 max-active connections.
Say that both are deployed to external Tomcat container and embedded Tomcat container is disabled ...
- 302
0
votes
0
answers
201
views
Why mysql_init(nullptr) leads to segmentation fault in the following code?
My code is as follow:
main.cc
int main(void){
int port, sqlPort, ConnectionNum, threadNum;
string sqlUser, sqlPwd, DBName;
try{
Config Settings("./config.ini");
...
- 390
0
votes
0
answers
92
views
I have connectionpool class which is a singleton. when i try to call it in my DBDAO classes something go wrong and it create 2 instances
im writing a coupon system project and I have a problem with my connectionpool.
I made it singleton and it should create 10 connections and print "Creating connection #num" 10 times when i ...
-1
votes
2
answers
472
views
dbConn.Open inside using
using (IDbConnection dbConn = new System.Data.SqlClient.SqlConnection(ConnectionString))
{
dbConn.Open();
...
return result;
}
Will the dbConn.Open() inside the using will use a different ...
- 15
1
vote
1
answer
996
views
Mysql connector - How to use connection pool with multiple databases?
I have more than 30 databases and I want to use connection pool in my python code.
conn = mysql.connector.connect(
host=MYSQL_HOST,
user=MYSQL_USERNAME,
passwd=MYSQL_PASSWORD,
...
- 104
1
vote
0
answers
313
views
Neo4j Java Driver - Connection Pool
I'm using Neo4j Java Driver and I was trying to create a connection pool. This is the driver that I added:
<dependency>
<groupId>org.neo4j.driver</groupId>
<...
1
vote
0
answers
406
views
Implement pool queue selenium grid
In automation test single Cucumber TestNG runner is assigning threads to grid properly. However when we have multiple jobs accessing same hub url, it's causing time out. If we implement a pool queue, ...
- 183
1
vote
0
answers
302
views
How to implement pool for selenium hub requests
We have recently created a job with cucumber selenium grid on aws, which will scale pods on fly up to 100. Cucumber has inbuilt parallel feature for testNg in latest version.
If we have 100 nodes and ...
- 183
0
votes
1
answer
35
views
nodejs mysql - How to implement pooledConnection in a realworld project?
I am working on nodejs with mysql(8.x). I have intalled mysql library from npm.
I wrote some code like below.
File A - connection.js
const pooledConInfo = {
host: 'localhost',
user: 'user',...
- 7,754
4
votes
0
answers
10k
views
HikariPool-2 - Failed to validate connection
I am new to spring boot so doesn't know much about configuration in application.properties or pom.xml . I'm trying to do a CRUD operation in MySQL DB hosted in Azure VM. Once I start my spring-boot ...
- 103
0
votes
0
answers
571
views
Node postgres - (node:43028) UnhandledPromiseRejectionWarning: error: sorry, too many clients already
I am trying to add data to my databases. There are multiple entries in an array
dataArryay.forEach((element) => {
queryData(elementData)
}
The function is called multiple times
async ...
- 1,043