7,200 questions
2
votes
1
answer
76
views
GridDB Cloud Python client: How to handle connection timeout and auto-reconnect?
I’m using GridDB Cloud with the official Python client to insert real-time IoT data into a time-series container.
The script runs continuously, but after a few hours I get a connection timeout and ...
- 67
0
votes
1
answer
53
views
DB2/LUW How to Perform Cross-database Query Comparison without Federation?
I did some reading and then confirmed with our DBA's that our databases are not federated. So, I figured I could write a stored procedure to connect to the first database and store the query output ...
- 153
0
votes
1
answer
94
views
Why DBContecxt.Database.Exists() becomes extremely slow when data source (IP) is wrong, but still fast when other credentials incorrect? [duplicate]
I am using EF 6 DbContext.Database.Exists() method, i.e. its return value true/false, to detect if a given DB is available. If it is, I pull and process data, if not, I enter a message into the log ...
- 237
0
votes
0
answers
124
views
Connection Pooling Challenges with MongoDB and AWS Lambda
I'm facing an issue related to MongoDB connections while sending push notifications to users three times a day — morning, noon, and evening.
I have a Lambda-based service that uses SQS and MongoDB. A ...
-2
votes
1
answer
46
views
when trying to connect to local MongoDB Server with nodeJS [closed]
first i run on terminal mongod
then i use node app on terminal it show nothing it take too long i waited for it to show an err or any message but nothing
const MongoClient = require('mongodb')....
0
votes
0
answers
166
views
On-premises data gateway
I want to connect my on-premises database with Microsoft Data Fabric to avoid duplication and data migration.
For this, I have successfully installed the Microsoft on-premises data gateway (standard) ...
0
votes
1
answer
31
views
"Access denied" when using PyMySQL with OceanBase in transactional mode, but MySQL client connects fine
Environment
OceanBase Community Edition 4.2.1 (MySQL mode)
Python 3.10
PyMySQL 1.1.0
I'm trying to use PyMySQL to execute transactions on OceanBase, but I'm getting an unexpected "Access denied&...
user30195804
0
votes
0
answers
64
views
How to efficiently manage its connections pool using the mariadb-connector-js package from npm?
I have some interogations about the mariadb connector (and the whole mariadb database's functioning) on connections handling.
In my typescript program (using mariadb-connector v3.4.0 with a mariadb ...
- 1,129
0
votes
1
answer
74
views
How is a scoped DbContext's connection handled?
When I implement an ASP.NET Core application, I may have several middlewares that must interact with the database in order to check something. All of them, and also the final endpoint, share a scoped ...
- 3,892
0
votes
0
answers
47
views
Where does this Mongo stacktrace come from in a Spring Boot app?
I have a Spring Boot 3.4.2 app, which has several databases and services configured, including MongoDB. There are 2 connections to MongoDB, each with their own credentials and database they access.
...
- 18.8k
2
votes
1
answer
47
views
How to use multiple database connections in Django TestCase
I'm writing a testcase to reproduce deadlock in my service. After I use multiprocessing to create a two thread, I found they use the same database connection. So I can't reproduce the deadlock ...
- 43
0
votes
0
answers
46
views
Why is my WordPress database table not available for a connection?
I've been building a site in WordPress currently based on my local hard drives using localhost. But I started receiving an "Error establishing a database connection" message.
The issue has ...
- 21
1
vote
1
answer
270
views
Quarkus Always Tries to Use Docker for PostgreSQL Despite Disabling DevServices
Problem Statement
I am trying to configure my Quarkus application to connect to my local PostgreSQL database, but it always tries to start PostgreSQL using Docker via Dev Services. Even after ...
- 781
0
votes
0
answers
97
views
Python MySQL Connection Hangs Using mysql-connector-python
My Python script hangs when trying to connect my Flask app to a MySQL database using mysql-connector-python. The MySQL server is running because it runs perfectly in VSCode, but I can't connect via ...
0
votes
1
answer
442
views
Why mysql.connector is not working, although pymysql is working to connect database locally?
I tried to connect my MySQL database from a Python script using mysql.connector, but could not be able to connect. Then I tried to connect using pymysql and the db was connected successfully. Why am I ...
- 39
0
votes
1
answer
78
views
Ensure connection has worked
I'm working on a VBA code to get data fro a Sharepoint list, and update it directly from my Excel file.
My code is actually working, and here it is :
Option Explicit
Dim HomeSh As Worksheet
Sub ...
- 301
0
votes
0
answers
80
views
To create multiple cursors with one connection object using context manager in Python for Snowflake
I'm really looking for best practices here, or something I've not thought of.
I have scripts which loop through multiple tables (potentially hundreds) in Snowflake within Snowflake, and do some form ...
- 5
0
votes
1
answer
69
views
How can I properly handle database connections in a Node.js application?
I'm building a Node.js application using Express.js and MongoDB (Mongoose). I want to ensure that my database connections are handled efficiently to avoid memory leaks and connection issues.
Currently,...
1
vote
0
answers
124
views
Facing a 'socket hang up' issue while executing a query on ClickHouse in a Node.js application
I'm experiencing a recurring "socket hang up" error when using ClickHouse with Node.js, and I'm hoping to understand how to reproduce and fix it. Here are the details:
ClickHouse version: 23....
- 11
0
votes
2
answers
111
views
Getting Multiple Connection To the DB (Postgres)
I get multiple connections to my Database, the query says "Rollback" and the connections increase instantaneously. and the duration of those connections are extremely high as compared to the ...
- 33
1
vote
1
answer
94
views
Oracle database newbie about ORA-01045 error [closed]
I can't connect to my brand new empty Oracle database from DBeaver or SQL Developer with just made new DB user.
I just get started to use Oracle Database 23ai, with SQL Plus logged in as SYSTEM and ...
- 19
-1
votes
1
answer
88
views
MongoDB connect ECONNREFUSED error into having my database deleted?
After trying to connect to my MongoDB database while testing my code in Node.js as per usual, I received a connect ECONNREFUSED 127.0.0.1:27017, connect ECONNREFUSED ::1:27017 error message in console....
- 23
0
votes
0
answers
45
views
How to close a sql server db connection for logstash pipeline when elasticsearch is unreachble
I am using Logstash 8.12 My logstash pipeline reads data from sql server and send to Azure ElasticSearch.
It works fine when ES is available. When Elastic search node is unreachable, I get the error ...
- 85
1
vote
0
answers
81
views
Setting the db connection max lifetime in payara micro connection pool (PostgreSQL)
We are using AWS RDS Aurora Cluster with AWS RDS Proxy connected to a Payara Micro Application using PostgreSQL. We are receiving exceptions from time to time in our application ("PSQLException: ...
- 11
-1
votes
1
answer
140
views
Can't connect to my mongdb database using mongoose (nodejs)
Im trying to connect to my database. Its working if i use mongodb compass but then im using mongoose to connect it doesn't work.
I keep getting this error:
Mongoose connection error ...
1
vote
1
answer
52
views
What is the correct term equivalent to "Thread Safe" but with respect to multiple database connections?
Assume you have two database connections. Each are currently open and performing reads and writes. They both read and write to some table entry at approximately the same time but the slightly later ...
- 4,814
2
votes
2
answers
275
views
Does Connection pool also closes associated Session on the Database?
I am reading about uses of Connection Pool in Java based web applications.
https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
I understand that a Connection in the Connection Pool is equivalent ...
- 119
-1
votes
1
answer
84
views
Database Connection Scaling in AWS ECS: Handling Increased Load in a Containerized Spring Boot Application
I have a user_service application that connects to a MySQL database using the following configuration:
datasource:
url: jdbc:mysql://localhost:3306/user_serviceDB
username: root
password: ****
...
0
votes
1
answer
139
views
PySpark; Not being able to connect and read .json from MinIO
I have the problem that I cannot connect to MinIO using spark.
The MinIO endpoint is running on Kubernetes and I forwarded the ports, it is accessible using curl or mc, so the issue must lie somewhere ...
- 1
0
votes
0
answers
115
views
C# .NET 9 application in docker cannot connect to mongo DB instance
I want to execute a console program (.NET application) in a Docker container. It contains a mongo client and functions OK when used as a stand-alone program, however I keep receiving timeout errors ...
- 141
0
votes
0
answers
61
views
Firestore ConnectionState is "ConnectionState.waiting"
This appears to be an issue that has been answered before (e.g. by @MSaudi here). I followed that discussion but it did not solve the problem I am running into. Would appreciate some pointers as I am ...
- 33
0
votes
0
answers
158
views
Connect to multiple postgreql dbs on the same port
I have been searching for a solution to my problem but haven't found anything helpful yet.
I am wondering what the best approach is to tackle this issue without making changes to the configurations.
...
- 23
0
votes
0
answers
27
views
connect to a database on sqlite3 terminal
I opened sqlite3.exe application located in this folder:
C:\Users\myname\AppData\Local\anaconda3\Library\bin
The terminal comes up with the following prompt:
sqlite>
I have my my.db file located in ...
- 211
0
votes
0
answers
120
views
How to track open database connections with Entity Framework Core 8?
I have an ASP.NET Core 8 MVC application. In production the application throws an error
Npgsql.PostgresException (0x80004005): 08P01: no more connections allowed (max_client_conn)
I am using NPGSQL ...
0
votes
0
answers
94
views
Connection error between MicroStrategy and IBM DB2 Cloud
I am facing a connection error when trying to connect to IBM DB2 Cloud via MicroStrategy.
(Database error <5>: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. ...
0
votes
0
answers
30
views
SQLAlchemy connection works but the Flask app crash
I'm writing a simple website that uses postgresql, sqlalchemy, and flask.
I have a server on which my DB is installed, and when I connect to it via this code: the connection is successful.
from ...
0
votes
2
answers
485
views
How to clean up thread-local data after using ThreadPoolExecutor?
I want to use ThreadPoolExecutor to parallelize some (legacy) code with database access. I would like to avoid creating a new database connection for each thread, so I use threading.local() to keep a ...
- 152k
0
votes
1
answer
159
views
Can't connect to postgres database running on docker from spring boot
I am currently learning spring boot. From online example it shows setting up postgress database on docker and connecting with spring boot application running locally in my PC.
my docker-compose.yaml ...
- 2,835
0
votes
0
answers
137
views
Why are there more connections in my RDS database than expected, despite HikariCP's configuration in Spring Boot?
I am using Spring Boot with JPA and HikariCP as the connection pool for my application. My application.properties file is configured as follows:
spring.datasource.driver-class-name=com.mysql.cj.jdbc....
0
votes
0
answers
152
views
OCCI Connection Fails with ORA-01017: Invalid Username/Password; Logon Denied
I’m encountering a persistent issue with the Oracle C++ Call Interface (OCCI) when attempting to connect to an Oracle database. Despite successfully connecting to the database using SQL Plus and ODBC ...
1
vote
0
answers
152
views
JAR file did not connect to SQL Server / Solution found
**
I finally removed the TLSv1 from the "jdk.tls.disabledAlgorithms" list in "the java.security" file.
I found the solution on here, I have tested it and it works perfectly.
Thank ...
0
votes
1
answer
266
views
DB2 ODBC driver not recognized?
I installed a DB2 instance inside a Docker container. Now I'm trying to connect to it from a simple Golang app, using Windows 11 x64, but i get this error:
Error connecting to database: failed to ...
0
votes
2
answers
2k
views
How can I easily read connection string from appsettings.json in .NET 8.0?
First, is this the correct json? Do I need to specify the ProviderName?
"ConnectionStrings": {
"DefaultConnection": {
"ConnectionString": "Data Source=(...
- 1,045
0
votes
1
answer
373
views
Airflow PostgresHook retrieval in dag
I'm using python to test the Airflow DAG. I have environmental variable:
AIRFLOW_CONN_DB="postgresql://postgres:[email protected]:6099/db"
and I use the following command to get the hook to ...
0
votes
1
answer
167
views
AWS PostgreSQL "FATAL: remaining connection slots are reserved for non-replication superuser connections" After Upgrading .NET Version
I'm encountering an issue with my application hosted on AWS after upgrading from .NET 6.0 to .NET 8.0. My application is running in a Docker container.
After the upgrade, I started receiving the ...
- 11
0
votes
0
answers
187
views
MongooseServerSelectionError: Could not connect to any servers in MongoDB Atlas cluster, IP whitelist issue unlikely [duplicate]
I'm encountering an issue while trying to connect my MongoDB Atlas cluster to my Node.js project using Mongoose. Here's a brief breakdown of the problem:
Error:
MongoDB connection error: ...
- 33
2
votes
1
answer
125
views
Powershell pipe psql commands using DB uri
I'm trying to move records from one database to another database using a powershell script with psql, in a single call.
The select query result is copied to stdout, which is used in the second pipe ...
- 65
1
vote
0
answers
209
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
0
votes
2
answers
230
views
Having Error message connection is null while the database is connected [duplicate]
I created a utility class to handle database connections using JDBC. I get the error below in another class, performing actions such as displaying the values from the database:
"Cannot invoke &...
1
vote
1
answer
91
views
What is the correct way to handle multi-db in nestjs with TypeORM?
I have two databases: a master database, which serves as a common database, and another database (dedicated to each tenant/customer) with the same schema. If you have experience with a multi-database ...
- 961