Skip to main content

Questions tagged [connections]

One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.

Filter by
Sorted by
Tagged with
-2 votes
3 answers
96 views

Why does killing a SQL Connection allow a reconnect with SSMS

I would like to kill connections for individuals using certain sql auth logins in SSMS that are reserved for our apps. They should have to go out of their way to reauthenticate into sql and at least ...
Laura Pilon's user avatar
0 votes
0 answers
21 views

Is there a way to prove whether a connection used the MultiSubnetFailover argument? [duplicate]

I know that consulting sys.dm_exec_connections can show whether a connection is using an AOAG listener or was made directly to the instance. And I know that if a connection is successful that it was ...
Alex Pixley's user avatar
0 votes
0 answers
116 views

Aurora RDS - difference between ConnectionAttempts and DatabaseConnections

So I have read this a few times about these two metrics: ConnectionAttempts and DatabaseConnections. Based on the above, is RDS rejecting lots of connections? Here are the graphs of these two metrics. ...
Abs's user avatar
  • 1
1 vote
0 answers
39 views

What could be a reason for MySQL stop receiving new connections?

I'm running a production MySQL on linux whose max connection is configured to 7000. Among 7000, approximately 3500 connections were used by application, serving user requests. A malicious user tried ...
pepsi's user avatar
  • 111
0 votes
0 answers
80 views

How to check current connection information on MongoDB?

Very new to MongoDB, I mean really, really new. I want to be able to confirm my connection details when I login to the database, similar to PostgreSQL where I just run conninfo or in Oracle where I do ...
benbart's user avatar
  • 31
0 votes
0 answers
7 views

How to consult the number of connections from specifics clients or ips in my secondary nodes

I need to know how to consult the number of connections from specifics clients or ips in my secondary nodes, I have a replica set composed of 3 nodes (one primary node and two secondary nodes), the ...
miguel ramires's user avatar
0 votes
1 answer
86 views

Hanging Sessions in SQL server with NULL values Blocking other processes

My customer has noticed that there are connections that are opened but they never closed and as a result, API requests are getting timed out since they are getting blocked by a "Ghost" ...
Vasileios G's user avatar
1 vote
0 answers
253 views

macos ventura postgres 15 remote connections server closed the connection unexpectedly

macos ventura 13.5.1 postgresql (15.4 (Homebrew)) Remote connections for the server are closed "unexpectedly". I have done all the steps that are needed for postgres to be happy with remote ...
boar's user avatar
  • 13
0 votes
0 answers
124 views

Aborted connection to db: user: host: 'localhost' (Got an error reading communication packets)

For some time now I'm getting said error from a WooCommerce installation of mine. Since the answers I found to this problem are not applicable or very old I opened my own topic. The WooCommerce ...
rcc_daniel's user avatar
0 votes
2 answers
716 views

Should I re-use a database connection or create new collections while closing old ones? social media

this is for a social media with constant requests for new posts, checking is someone is following, getting comments, ect. i wont specify which language as it doesnt really matter but, currently in my ...
Corie LeClair's user avatar
2 votes
2 answers
590 views

Does having a specific database for each user in a web app good design?

I have a client who's insisting in a SaaS application to have one table for all users, and then for each user to have a separate database on which we perform CRUD operations based on an authentication ...
Samir Ahmane's user avatar
0 votes
0 answers
59 views

Can't connect to database - The specific error code is 1006

Yesterday I entered data into databases - it was several million records. Everything went ok, I was happy. But today, when I want to connect to the database, I get this error. The problem now is that ...
Jan Kůst's user avatar
1 vote
2 answers
2k views

run mariadb (mysql) on multiple cpu core

How can I make MariaDB on Debian 11 use all cores equally? Currently, my configuration is using version 10.5.18-MariaDB-0+deb11u1-log on a server with 12th Gen Intel(R) Core(TM) i9-12900K 24 core CPU ...
Sam Wiki's user avatar
1 vote
1 answer
61 views

Unknown, Un-encryted Connections [duplicate]

We have SSL enabled on our SQL servers and our monitoring tool is alerting that there are unencrypted connections. The check that monitors this runs every minute and uses the following query to check: ...
SE1986's user avatar
  • 2,000
1 vote
0 answers
110 views

Persistent problems connecting MySQL Workbench to an AWS RDS DB

I started off my attempt to figure out how to connect my local MySQL Workbench (8.0.32) client/application to an RDS Database on my analytics team's AWS Account by asking Bing AI and this is what it ...
Marlen's user avatar
  • 227
0 votes
1 answer
1k views

Using two transactions at the same time without getting Lock wait timeout exceeded

I use MySQL 5.6 I'm trying to make a test framework on PHPunit, I use two different db connections (from two different systems it has to be 2 different db connections not a choice). By default many ...
Steve Moretz's user avatar
3 votes
1 answer
2k views

How much resources does a sleeping connection require in SQL Server?

One of our DBAs complained to our team that he noticed about a dozen sleeping connections are virtually permanent. Each of them indicates a very short query (a single record from a single record was ...
Alexei's user avatar
  • 1,271
1 vote
0 answers
511 views

mongodb connections current vs active

When I use the command 'db.serverStatus().connections' I don't understand the meaning of 'current'. The documentation defines it as 'The number of incoming connections'. Doc My application is a chat, ...
TomYJerry's user avatar
0 votes
0 answers
129 views

What is the endpoint for an Azure SQL database for using in a REST get request?

I am new to Azure SQL database and was hoping that I would get some help on how to address the database as an endpoint in a http request I am doing from an apex callout in Salesforce. Normally in ...
Brigetta's user avatar
  • 101
1 vote
0 answers
3k views

postgres 11: remaining connection slots are reserved for non-replication superuser connections

I've run into the following problem. From time to time, my app receives remaining connection slots are reserved for non-replication superuser connections from postgres. It lasts for quite noticeable ...
Vadim Samokhin's user avatar
1 vote
3 answers
389 views

Find which IP added a specific record to a table in SQL Server

Let's say I have an SQL Server running on Azure and multiple applications add records to it. The problem is that some records come from an unknown application. Is there a nice way of finding which IP ...
Dimitrios Arampatzis's user avatar
0 votes
0 answers
176 views

Mariadb equivalent to MySQL CONNECTION_CONTROL

MySQL introduced a security plugin library in version 5.7.17 including the plugin CONNECTION_CONTROL, which checks incoming connection attempts and adds a delay to server responses as a result of ...
Jon Godden's user avatar
0 votes
0 answers
638 views

How can I keep the connecton to the database alive in pgAdmin 4?

I am constantly seeing this message: ERROR: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. server closed ...
Rokit's user avatar
  • 101
1 vote
2 answers
86 views

How can I create a brand new alarm based on a verification not listed by default on SQL Server?

I want to create an alert like the ones from Brent Ozar's How to Configure SQL Server Agent Alerts, but I couldn't find a message related to the error I want to monitor on sys.messages as the ...
Ronaldo's user avatar
  • 5,636
4 votes
1 answer
915 views

SET SINGLE_USER WITH ROLLBACK IMMEDIATE only disconnects sessions when account is a database user

The following code creates a user that is able to restore a database: CREATE LOGIN RestoreUser WITH PASSWORD = 'MyPassword' ALTER SERVER ROLE dbcreator ADD MEMBER RestoreUser This works fine and the ...
SE1986's user avatar
  • 2,000
3 votes
3 answers
2k views

Can connect to virtual MySql instance using 127.0.0.1, but not localhost

Running MySql 5.7.33 on a local VirtualBox instance. I have forwarded port 3306 from the virtual server to be accessible locally. On my virtual host, I have this in my /etc/mysql/my.cnf file ... [...
Dave's user avatar
  • 723
-2 votes
2 answers
5k views

Change max_connections Postgresql

how i can change max_connections on Postgresql.conf without restart service Postgresql? Systemctl reload postgresql.service not work with this conf.
Tsunani's user avatar
0 votes
0 answers
174 views

Datagrip connecting to databases on launch

I'm using Jetbrains Datagrip to connect to Mysql servers. My problem is that Datagrip connects to the various databases I created as soon as I launch it. That's not a problem with development ...
Alexis Dufrenoy's user avatar
0 votes
1 answer
4k views

PostgreSQL 12 dropped replication slot but standby is still trying to contact the primary

We have recently decommissioned a standby that was experiencing some hardware issues from our streaming replication cluster. We were able to successfully stop the PID on the primary and then drop the ...
Diane's user avatar
  • 151
2 votes
1 answer
2k views

Azure Data studio - connection to server in the same network - Error: The received certificate has expired

I am trying to connect to SQL server on my network with Azure Data Studio, and I am getting error: A connection was successfully established with the server, but then an error occurred during the ...
Marko Skokovic's user avatar
0 votes
1 answer
5k views

How to forcefully drop all active connections off a database?

On one server I have a Postgresql database and there're many clients on other servers accross the internet that connect to it. I want to drop all the active connections on demand, they should be ...
Nilcale's user avatar
4 votes
1 answer
11k views

PostgreSQL: Using the .pgpass file

I have been reading up on the .pgpass file, but I can’t get it working for me. My .pgpass file looks something like this: 127.0.0.1:5432:accounts:fred:p@55w0rd I set the privilege to 0600 (this is on ...
Manngo's user avatar
  • 2,849
0 votes
2 answers
13k views

Test connection failed because of an error in initializing provider. DBNETLIB ConnectionOpen SecDoClientHandshake SSL security error

I'm running all Windows 2016 Servers. I've got MS SQL 2016 installed on one. For whatever reason, we cannot connect to the SQL Server unless we enable TLS 1.0 which is obviously not cool. I found ...
Steven's user avatar
  • 11
1 vote
1 answer
802 views

When a thread/process crashes on acquired DB locks, how does DB detects that and releases the lock?

Take MySQL as an example, say a thread run SELECT ... FOR UPDATE crashes before committing the update, how does MySQL detect the crash and release the lock? I assume most RMDBS will have some keep-...
Qiulang 邱朗's user avatar
0 votes
0 answers
449 views

postgresql, connection limit for different roles

Is possible setup in postgresql.conf connection limit for specified role globally (in some .conf file) or individually? For example, I have 3 roles and max_connections = 600. Need to setup max 10 ...
genderbee's user avatar
  • 191
0 votes
1 answer
560 views

ODBC Calling Fill - Unexpected closed connection after 2 hours

Using PostgreSQL 12.3 (Ubuntu 12.3-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit I use driver PostgresSQL Unicode(x64) version 13.00.00.00 I have ...
Actarus's user avatar
1 vote
1 answer
4k views

many "unauthenticated user" on MySQL Processlist

In show processlist I have (from time to time) lot of unauthenticated user. How it looks like? | 187743 | unauthenticated user | connecting host | NULL | Connect | 39173 | ...
PSS's user avatar
  • 11
0 votes
1 answer
1k views

Identifying processes that open MySQL connections

I need to identify which application process issues a large number of MySQL connections on a Linux system. The show processlist sql command or tools like innotop do not really help, as they only show ...
mvw's user avatar
  • 111
0 votes
2 answers
182 views

Nested Stored Procedure Connections

I have a Stored procedure that simply looks for Imported files through a set of other processes. The main SP runs every 5 mins and looks for new files in a directory and imports them into a staging ...
DBA_Kyle's user avatar
0 votes
1 answer
604 views

Why is MySQL not connecting when reading from mylogin.cnf?

On Ubuntu 20.04, I can log into a server by specifying the log credentials on the CLI: $ mysql -h172.30.0.2 -uroot -p bar -e "SELECT id FROM users LIMIT 1;" Enter password: +----+ | id | +---...
dotancohen's user avatar
  • 1,085
0 votes
1 answer
642 views

MultiSubnetFailover=true for DBMSes besides SQL Server

A connection string for SQL Server can contain MultiSubnetFailover=true, to handle multiple DNS A records, letting the client try to connect to every IP address of a domain (or subdomain) name, to ...
uncaged's user avatar
  • 189
0 votes
1 answer
272 views

Unknown source of high number of connections

In MySQL/Aurora I see from time to time a spike in connections number (from about 100 to 4000): MySQL doc says: Connections The number of connection attempts (successful or not) to the MySQL server. ...
Nir's user avatar
  • 533
1 vote
1 answer
43 views

SQL Server Identifying Connections that are utilising SQL from an application

Is it possible to identify connections in SQL Server 2014 that are utilising SQL that is passed from an application as opposed to calling an SP ?
armitage's user avatar
  • 1,402
0 votes
1 answer
1k views

Warning message: invalid value for parameter "default_tablespace" in postgres

I create a new tablespace using the following script: CREATE SCHEMA semiarido; CREATE ROLE semiarido PASSWORD 'senha'; GRANT CREATE ON SCHEMA semiarido TO semiarido; GRANT USAGE ON SCHEMA semiarido ...
Mauro Assis's user avatar
1 vote
0 answers
206 views

2020-07-29T07:44:29.817503Z 108716 [Note] Aborted connection 108716 to db:

We are getting continuously logs in mysql error logs 2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets) we ...
devops's user avatar
  • 23
0 votes
2 answers
284 views

How Are SQL Server Clients Connecting?

I am asking two questions in this post. If I see activity in netstat with port 1433 for an unnamed instance, whose tcp addresses are not enabled, what does that mean? What is the preferred way to ...
octopusgrabbus's user avatar
3 votes
2 answers
1k views

Why would I download CA certificate when starting a managed Postgres cluster on DigitalOcean?

I am trying for the first time a Postgres cluster provided as a managed service by DigitalOcean.com. As part of configuring the new cluster, their web interface gives me a user name, password, port ...
Basil Bourque's user avatar
0 votes
1 answer
40 views

Why do I have 2 connections when im using 1 client?

The command: select * from pg_stat_activity shows all currently active connections. The database is hosted by AWS RDS and I am accessing the database with pgAdmin 4, thus I expect one other ...
SweetPotato's user avatar
0 votes
0 answers
2k views

Postgres memory usage grows over time, resets when clients restarted

I have a Postgres DB running on the same small server as some applications that use it. Immediately after restarting the applications, Postgres uses <100 MB memory. After a few days without ...
rlms's user avatar
  • 101
0 votes
1 answer
95 views

Why would the user matter for performance when running a query?

I have a web page with a database lookup that contains multiple optional parameters. When I select a couple of parameters and run the query, it returns in less than two seconds. However, when another ...
Tom A's user avatar
  • 137

1
2 3 4 5