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
1 answer
248 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 ...
  • 1,229
0 votes
0 answers
12 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, ...
-3 votes
0 answers
28 views

Can telnet but cannot connect the SQL instance by SSMS [duplicate]

I can telnet the SQL server from my SSRS server, but it failed when I used the SSMS. Any thoughts to narrow down the root cause? Many thanks, Hi there, Thank you for supporting this and I added the ...
0 votes
0 answers
10 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 ...
  • 101
0 votes
0 answers
88 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 ...
1 vote
3 answers
99 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 ...
0 votes
0 answers
31 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 ...
0 votes
0 answers
15 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 ...
  • 101
0 votes
2 answers
36 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 ...
  • 4,742
4 votes
1 answer
131 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 ...
  • 1,600
3 votes
3 answers
667 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 ... [...
  • 515
-3 votes
2 answers
828 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.
0 votes
0 answers
165 views

Unable to connect to Mongodb database using the Mongodb compass

I have created a mongoDB database on DigitalOcean, then I try to establish a connection to the database using MongoDB Compass. However, when I try to do so, "connect ECONNREFUSED 143.198.217.148:...
  • 1
0 votes
0 answers
73 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 ...
0 votes
1 answer
674 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 ...
  • 111
2 votes
1 answer
934 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 ...
0 votes
1 answer
421 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 ...
0 votes
1 answer
2k 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 ...
  • 2,377
0 votes
2 answers
5k 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 ...
  • 11
0 votes
1 answer
304 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-...
0 votes
0 answers
37 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 ...
  • 151
0 votes
1 answer
217 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 ...
1 vote
1 answer
1k 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 | ...
  • 11
0 votes
1 answer
186 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 ...
  • 111
0 votes
2 answers
79 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 ...
0 votes
1 answer
318 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 | +---...
  • 1,058
0 votes
1 answer
132 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 ...
  • 179
0 votes
1 answer
64 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. ...
  • 437
1 vote
1 answer
35 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 ?
  • 1,413
0 votes
1 answer
507 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 ...
1 vote
0 answers
156 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 ...
  • 23
0 votes
2 answers
75 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 ...
1 vote
2 answers
585 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 ...
0 votes
1 answer
31 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 ...
0 votes
0 answers
629 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 ...
  • 101
0 votes
1 answer
43 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 ...
  • 137
1 vote
1 answer
7k views

How to see unclosed PostgreSQL connection while using psycopg2? [closed]

I run python code: con = psycopg2.connect(some_dsn) cur = con.cursor() cur.execute(some_sql) res = cur.fetchone() #con.close() <-- connection is not closed Then I try: ps auxf | grep postgres ...
  • 121
1 vote
1 answer
618 views

SQL Server Encrypted Connections - Configuration Manager does not see Certificate

My goal is to implement encrypted connections on Test SQL Server instance First, tried to create self-signed certificate in the Certificates snap in (certlm.msc), Personal > All Tasks > Request New ...
1 vote
2 answers
3k views

Queries on large database kill connection to the server, works with LIMIT

I'm trying to run queries on a large-ish database without killing the connection to the server. I'm using Postgres 12.1 on a mac with 16gb of memory, and about 40gb of free disk. The database is ...
1 vote
1 answer
1k views

How many pool connection size should be set for a 1000 users Jira system?

For a Jira system, if use Jira's default connection configuration as below: <?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <...
  • 159
0 votes
1 answer
90 views

SQL*Loader and DC firewall timeout

We are loading a huge dataset using SQLLDR and there are index creation that lasts for a couple hours or even more. Firewall drops this connection as there is no data transfer during index creation ...
0 votes
1 answer
49 views

Remote connection scheme without Windows Authentication/Domain in detail [closed]

There is a legacy C++ system that needs to be "translated", that uses ODBC for connecting to remote SQL Server Database. System is distributed to many different OS and different domains, some always ...
  • 13
1 vote
1 answer
111 views

Audit logins and logouts [duplicate]

I need to trace and monitor client login connections (successful and failure) to our important SQL servers (20 MSSQL Server). What method do you recommend? Note: I think enabling "both failed and ...
  • 111
0 votes
1 answer
1k views

Same session ID(with same SQL text) but 3 different connection ids

I was listing out all sessions open in my sql server 2016 production server. I have issues with slow performance and i have been investigating it. I see that i have several same sessions(session_id) ...
  • 1,295
1 vote
2 answers
1k views

SSMS How do I open a new Query Window using Same Connection Instance of current Window

Coming from Oracle I have discovered that SSMS connects slightly different than Oracle's SQL Developer. Oracle you click ONE connection and then all tabs you open then use that Connection. SSMS ...
3 votes
2 answers
5k views

How to connect using PDB userid on Oracle 18c XE?

I have created a PDB on Oracle 18c XE using following SQL command create pluggable database virlux admin user test1admin identified by test1pwd file_name_convert = ('/pdbseed/', '/test1/') ; Now, I ...
  • 191
3 votes
1 answer
246 views

Record MultiSubnetFailover value at connection?

With AlwaysOn, there are 3 options for the keyword MultiSubnetFailover True (yes) False (no) (example) Not sent/used Not all applications support it's use in connection strings. Not all vendor ...
1 vote
2 answers
1k views

MySQL 5.6 -- How do I tell if I need to increase innodb io thread setting?

I am trying to tune my mysql server for the high end system. We are using 16--32 core hosts with memory > 100GB. I have looked into a bunch of existing setting, but not sure if I need to tune up the ...
2 votes
1 answer
739 views

User connections without a login

I was looking at SQL Server performance and noticed that CPU utilization goes high when the number of connections go high(I believe it is normal).Usually number of connections on an average was ...
  • 1,295
0 votes
1 answer
174 views

ODBC connection with RD Gateway [closed]

here at my company, we use an RD Gateway server. that means when we want to access a server we have to set up the gateway in the connection...something like rdsgw.mycompany.com But, how could I do an ...

1
2 3 4 5