Questions tagged [connections]
One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.
205
questions
0
votes
1answer
23 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 ...
1
vote
1answer
45 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
1answer
36 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
1answer
58 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 ...
0
votes
0answers
33 views
postgres pg_basebackup terminating connection
I am unable to successfully use pg_basebackup with my database.
system details:
virtual Ubuntu server 20.04
4 cores
32GB memory
storing postgres data to a virtual drive mount (3.5TB capacity)
postgres ...
0
votes
2answers
792 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 ...
0
votes
1answer
58 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
0answers
19 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 ...
0
votes
1answer
55 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 ...
0
votes
1answer
113 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 | ...
0
votes
0answers
15 views
DB2 for i setting connection specific collation
I read an answer to a question that said you can set connection-specific collation for a DB2 for i connection. However, my Google skills are failing me and I can't find anything about it.
Specifically,...
0
votes
1answer
17 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 ...
0
votes
2answers
42 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
1answer
150 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 |
+---...
0
votes
1answer
46 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 ...
0
votes
1answer
37 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.
...
1
vote
1answer
27 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 ?
0
votes
1answer
247 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
0answers
107 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 ...
0
votes
2answers
63 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
2answers
299 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
1answer
22 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
0answers
222 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 ...
0
votes
1answer
38 views
Why would the user matter 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 ...
1
vote
1answer
4k 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
...
1
vote
1answer
457 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
2answers
1k 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
1answer
724 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>
<...
0
votes
1answer
58 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
1answer
46 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 ...
1
vote
1answer
73 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 ...
0
votes
1answer
881 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
vote
2answers
822 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 ...
2
votes
2answers
4k 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 ...
3
votes
1answer
215 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
2answers
744 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
1answer
387 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 ...
0
votes
1answer
113 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 ...
0
votes
1answer
24 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 ...
1
vote
0answers
865 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 ...
0
votes
1answer
52 views
Is It Okay to Leave the Connection Open and Set CommandTimeout for Long Durations?
I have to process daily files and it's a long process that deletes, imports and updates processes. Like literally 20 to 30 minutes per file for several files a day.
** EDIT: I also have some ...
1
vote
0answers
190 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.
...
2
votes
2answers
203 views
MSSQL over the internet but we connect over RDP
We connect throguh RDP to our ERP solution which uses MSSQL 2008, right now I can see on windows logs and SQL logs that we have a HUGE amount of connection attempts to sa user and results in slow ...
0
votes
1answer
45 views
What is a connection in MySQL Workbench?
I've searched so much and still found no answer to what exactly a connection is. I'm a beginner and don't know how connecting to databases/servers works, so I can't move forward yet.
What does the ...
1
vote
1answer
26 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 ...
0
votes
0answers
65 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 ...
0
votes
0answers
66 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 ...
0
votes
0answers
36 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 ...
0
votes
1answer
95 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 ...
1
vote
1answer
52 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 ...
