Questions tagged [connections]
One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.
57
questions with no upvoted or accepted answers
5
votes
1
answer
4k
views
Very Sporadic Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server
OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection".
Msg 7303, Level 16, State 1, Line 19
Cannot ...
- 115
3
votes
0
answers
698
views
SQL Server Management Studio creates 18456 login error using registered server group
I have been using "Local Server Groups" registration for quite a while now with SQL Server 2008 Management Studio.
I have created a group with 5 registered servers. They are registered using ...
- 4,797
2
votes
0
answers
656
views
Is sp_getapplock recommended for long running locks (> 10 minutes)?
I'm trying to get rid of a Redis dependency in our application.
We notice that is worse for our uptime to have a dependency on both SQL and Redis, above the performance benefits Redis would give us.
...
- 385
2
votes
0
answers
1k
views
How do I do an ODBC connection to ORACLE from SSIS/ Visual studio?
Despite that OLE Db and ADO.NET are newer than ODBC potentially, I've heard that ODBC connections to Oracle are potentially faster within SSIS.
So --- I'm trying to set up a simple ODBC connection to ...
- 1,693
2
votes
0
answers
5k
views
Switching users in PgAdmin
I'm looking for a way to enable switching between users in pgAdmin 4. I'm aware of the possibilty to change user from the properties-dialog before connecting. However this isn't useful when I'm ...
- 133
2
votes
0
answers
1k
views
Keeping MySql connections alive
I'm running a Windows service, which connects to a MySql database via Entity Framework.
Every 10 seconds it issues a query to the database to see if any new records have been added. If it finds any, ...
- 243
2
votes
0
answers
53
views
Unexplained connections from one SQL server to another
I just installed 2 SQL Server 2016 Enterprise and configured a High Availabilty Group. As a test object for the HA-Group I used a database I restored from another server. It's a database called "...
- 61
2
votes
0
answers
729
views
Sybase Adaptive Server Anywhere connection problems
In my work, we have a software system based on Sybase Adaptive Server Anywhere version 6 installed on Windows Server 2008. The system works fine, but after a period of time from system start, problems ...
- 121
2
votes
1
answer
767
views
Mysql 5.7 cannot start again
For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04.
I installed MySQL 5.7, it worked great for a couple of days ...
- 81
2
votes
1
answer
926
views
Connection's MAC address randomly changes on Windows 10, then stops
Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications).
We do ...
- 1,353
1
vote
0
answers
169
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.
...
- 11
1
vote
0
answers
41
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 ...
- 111
1
vote
0
answers
282
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 ...
- 13
1
vote
0
answers
124
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 ...
- 227
1
vote
0
answers
540
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, ...
- 11
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 ...
- 625
1
vote
0
answers
209
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
1
vote
0
answers
1k
views
Aborted connections (Erros reading communication packets)
I set up a new Database Server over a SQL Dump with innoDB MYSQL 5.7 from MYSQL 5.6. The Server running external with many sleeping SMTP connections over 1 Mio a day. I made the server open for ...
- 11
1
vote
1
answer
44
views
Way to check where the MySQL connection was initialized?
Is there a way to identify who created the MySQL connection?
For example:
in file a.php
$conn = mysqli_connect($dbhost, $dbuser, $dbpwd, null, $port, $socket);
I would like to know that this ...
1
vote
1
answer
78
views
MySQL Server :: My C Code can remotely create a database, but not "INSERT INTO" it
I’ve written a C program which does the following when it starts:
Connects to a remote Linux MySQL server over the network
Creates a new, uniquely-named database
Sends a “USE _____” command to ...
- 111
1
vote
1
answer
51
views
Permission errors on insert after schema drop/create (Pg 9.0.23)
We have a web application that allows users to modify data through an API. In order to allow people to run tests, we provide a sandbox area called 'daily'. This sandbox gets refreshed every day from ...
- 21
1
vote
0
answers
614
views
Postgres vacuum drops connections
I receive randomly errors for database connections, like: socket closed.
I observed postgres logs and found suspicious line: database system was interrupted. Can that happen that postgres drops the ...
1
vote
0
answers
2k
views
"must be superuser or have the same role to terminate other server processes" with PostgreSQL
Postgres 9.4.12 locally and 9.4.7 on AWS RDS.
There are two database users: app and untrusted_dev (the latter to mirror AWS RDS: NOSUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION). app is ...
- 454
1
vote
0
answers
7k
views
MySQL can't connect to another server with ERROR 2003 (HY000)
I have two servers:
server1: 192.168.0.2
server2: 192.168.0.3
They are both CentOS 6. I installed MySQL on both two servers.
I can ping server2 from server1
$ ping 192.168.0.3
I can connect MySQL ...
- 343
1
vote
0
answers
2k
views
Suddenly unable to connect to PostgreSQL
I have a simple backend running on a server back at my house while I'm away at college. I had it just sitting there, doing nothing, with daily endpoint tests for about a month, when suddenly yesterday ...
- 111
1
vote
0
answers
1k
views
Excel and Oracle SQL Connection
I am connecting to an Oracle DB and return data with Excel 2010. I have setup the connection in my workbook and my connection string looks as follows,
Provider=OraOLEDB.Oracle.1;Password=jasonpc;...
- 133
1
vote
2
answers
63
views
Is there an easy way to update connection strings to a database moved to a different instance
I have created a new instance of SQL Server 2008 r2 and exported my database to the new instance. Then I realized that the connection string for all of my datasets still point to the original ...
1
vote
0
answers
695
views
SSMS login fail to Linked Server
i have one server with SQL server 2012 standard on cloud environment and one linked server with sql express on remote location connected with VPN , im using transactional replication
every time when ...
- 11
1
vote
2
answers
3k
views
Only one simultaneous connection per user?
I'm currently experiencing some trouble, seemingly because my application refuses to connect to the database if there is already another connection open from the same user (but in a separate process).
...
- 131
0
votes
0
answers
105
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 ...
- 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 ...
- 149
0
votes
0
answers
62
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 ...
- 45
0
votes
0
answers
130
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
190
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
681
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
0
answers
188
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 ...
- 101
0
votes
0
answers
462
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 ...
- 191
0
votes
1
answer
602
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 ...
- 3
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 ...
- 111
0
votes
1
answer
626
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,085
0
votes
1
answer
293
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.
...
- 533
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 ...
- 101
0
votes
1
answer
47
views
how to change the driver of a ole_dbconnection from oracle_32bit to oracle_64bit
i have the connection string of:
connection= new OleDbConnection("Provider=OraOLEDB.Oracle;UserId=userid;Password=password;
Data Source=database;OLEDB.NET=true");
However after Oracle_64bit driver ...
- 47
0
votes
0
answers
267
views
SQL Server DAC - Connection Issue
I am having a strange issue when trying to connect to my SQL Server instance remotely from my client computer. I am able to do this on my other instances by opening up a new Database Engine Query and ...
- 53
0
votes
0
answers
221
views
Adding PostgreSQL data source to excel didn't ask for credentials other than server IP and database
I saw Excel supported using PostgreSQL as a data source. I'm used to using ODBC connections for Access so having direct Postgres support is exciting.
When connecting I entered the Server IP and ...
- 167
0
votes
0
answers
71
views
SQL Mirroring - Application not pointing to new Primary
Im stuck with a connection string issue
this is my connection string.
<add name="APP01" connectionString="Server=10.169.0.2; Failover Partner=10.166.0.2; Initial Catalog=DB2017; Integrated ...
- 1,960
0
votes
1
answer
217
views
Mysql Connections are string when checking from SHOW STATUS LIKE '%onn%';
I have a Mysql db server which seems to be getting slow by time. When i am checking detail from SHOW STATUS LIKE '%onn%'; I get following details
Variable_name Value ...
- 111
0
votes
1
answer
2k
views
"undefined function pg_pconnect()" when connecting to Postgres from CodeIgniter
I just installed Postgresql and pgadmin in my Ubuntu system. I can create a database from the pgadmin interface and everything seems ok, but when I try to connect to the database from my CodeIgniter ...
- 1
0
votes
2
answers
66
views
Connections increasing by 10+ a second with no requests
I'm getting no answers from my host, but I suspect their DB servers are compromised.
I was getting some ridiculous page loads for requests to a standard Wordpress installation - upwards of 30 seconds,...
0
votes
1
answer
30
views
Can't see connexion to Postgresql using php
I have created a php form to connect to a remote postgresql database. It seems that I can log in successfully because my message "connexion succeeded" appears.
But I can't see the corresponding line ...
- 207