Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
34 views

Pgbouncer: got packet 'E' from server when not linked

Does anyone knows what this error below means? We running pgbouncer 1.21 on centos using transaction pooling mode. 2024-04-29 15:00:02.378 CST [9680] WARNING S-0x197b028: db/[email protected]:5432 got ...
mediocre's user avatar
  • 107
0 votes
1 answer
32 views

PostgreSQL & SQLAlchemy: Minimizing Impacts of latency with chatty applications

Are there any ways to minimize the impact of latency between the application and database when running PostgreSQL & SQLAlchemy ORM? Changing loading strategies or preloading properties has been ...
Justin Lowen's user avatar
0 votes
1 answer
19 views

Network utilization maxed out during backup. Is it bad in itself?

We have a cluster of two Oracle DBs. Monitoring software agent is installed on both of the machines and overnight, when backups are happening, we get warnings that network interface utilisation on the ...
Tony Sepia's user avatar
0 votes
1 answer
73 views

PostgreSQL: What's the most accurate way to find the network bandwidth of a Query result set

I have been trying to figure out network bandwidth of a Query output, since PostgreSQL only holds I/O bandwidth of Query I ended up in Octect_length() or pg_column_size(). I found below query from ...
mediocre's user avatar
  • 107
2 votes
0 answers
34 views

MySQL Client taking more than 14 sec to be connected

IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
Basudev Rout's user avatar
0 votes
0 answers
95 views

Cannot connect to PostgreSQL DB over a Virtual IP (VIP)

I am running a PostgreSQL DB Server v12.16 on an Ubuntu 20.04 virtual machine. When I attempt to connect to DB directly from host, it WORKS! When I attempt to connect to DB via the VIP, it DOESN'T ...
user3051574's user avatar
0 votes
0 answers
46 views

Why, MariaDB user allowed host IP address also allows a virtual machine on the host with NAT network adapter

The MariaDB user specifies an allowed IP address in the Host column of the mysql.user table. So, it only allows logging in from the host with the specified IP address. And MySQL has the same design. ...
James's user avatar
  • 149
1 vote
0 answers
60 views

SQL Server unexplained network traffic gaps in traced events

This appears to have started happening a week, maybe two weeks ago. Essentially, we cannot figure out whether it is the server or the client that is periodically pausing between SQL statements. In the ...
孔夫子's user avatar
  • 4,330
0 votes
1 answer
497 views

I can't connect MySQL (on Ubuntu 22.04 Host) connect to remote server (Ubuntu 22.04 on VMWare Guest)

I want to create new MySQL connection to remote Django server that is inside virtual machine on VMWare (located at address 127.0.0.1 on port 33061). The problem is that MySQL shows the message "...
Abstract _42's user avatar
3 votes
1 answer
8k views

Is there any way to pg_upgrade PostgreSQL 12 to 15 over network?

My situation is a little bit complicated. I have an older version of PostgreSQL 12.9 installed on an older Centos Stream 8 machine. There are about five custom databases created under the roof, say ...
cidy.long's user avatar
  • 133
-1 votes
1 answer
83 views

Changing NICs from 1Gb to 10Gb in an availability group

We have a two-node Always On Availability Group set up. Both nodes are on SQL Server 2016 SP3. Primary server has two 1Gb NICs. Secondary has two 10Gb NICs. Both primary and secondary have a default ...
Kris's user avatar
  • 432
0 votes
0 answers
70 views

How to get SQLs per network consumption?

On Db2/Linux_x86 version 11.5.8.0 we have several Db2 instances. With iptraf-ng command sysadmin has noticed that one of this Db2 instance has 20-times more output network traffic then others which is ...
folow's user avatar
  • 339
0 votes
1 answer
145 views

More than 3 Subnets with WFC and Availability Groups

I have a system design where I will have a single WFC node using 2 Server 2016 boxes and a SQL Server 2019 Availability Group. I've followed instructions easily found for setting this up, such as ...
DaveJM's user avatar
  • 3
2 votes
1 answer
841 views

Connecting to a remote SQL named instance with named pipe

I found out that when I connect to a remote SQL named instance (ServerA\instanceA) from SSMS installed on ServerB, it does connect without error, but it uses the Named Pipe protocol. I found that out ...
Dominique Boucher's user avatar
1 vote
0 answers
521 views

Why when a Mongodb second secondary node is unreacheable, the cluster is affected?

I have the following MongoDB 4.0.2 cluster with the following information: rs.conf() { IP:192.168.1.26, // Primary, in New York branch priority:10 }, { IP:192.168.1.24, // Second Secondary, in ...
user3637971's user avatar
0 votes
0 answers
42 views

How Turn On Linux Network Port Listeners

I'm on AlmaLinux 9 where I want to host PostgreSQL for the LAN. I've poked a hole in the firewall (firewalld): $ sudo firewall-cmd --zone=public --permanent --add-service=postgresql $ sudo firewall-...
Rich_F's user avatar
  • 131
1 vote
0 answers
937 views

A transport-level error has occurred when receiving results from the server. An existing connection was forcibly closed by the remote host

We have an application in Azure which connects to SQL Server on-premise over hybrid connection Every 4-5 requests from 1000 would fail with error 10054: A transport-level error has occurred when ...
Aleksey Vitsko's user avatar
0 votes
1 answer
185 views

MS Access and multiple users

I'm looking for some help regarding Microsoft Access and database design. I have been developing a database application on Microsoft Access for use in my organisation. I work in a hospital and we have ...
slimn's user avatar
  • 3
0 votes
1 answer
299 views

Is it considered safe to add the public IP of a host to listen_adresses and the pg_hba file?

I have kind of a naive question, but for the moment it's the only way I found to access a local (I mean, located on the host machine) PostgreSQL database from a docker container, so I'm wondering: is ...
s.k's user avatar
  • 372
0 votes
0 answers
38 views

Is it possible to disable DoneInProc tokens in MSSQL Server [duplicate]

I have a PLC library that isn't able to parse the return packet from MSSQL when it includes DoneInProc tokens before the ColumnMetaData and Row data. I've contacted the author of the library, but he ...
Tanj's user avatar
  • 101
1 vote
1 answer
1k views

Does SQL Server require NetBIOS for Named Pipes?

I'm not all that familiar with networking or protocols and couldn't find a similar question here or elsewhere. One of my security people is asking whether SQL Server requires NetBIOS for Named Pipes. ...
DrewCranmer's user avatar
0 votes
1 answer
524 views

RMAN Duplicate PITR without connection to Target database

I would like to understand which network requirements are needed following the least privilege needed policy in order to perform a DUPLICATE DATABASE UNTIL SCN in this scenario My environment is Azure,...
Roberto Hernandez's user avatar
0 votes
1 answer
672 views

Why Federatedx Engine is very slow in MariaDB 10.6 and have to read all the table to get only first 10 rows? [duplicate]

I am trying to get 10 rows from one MariaDB to another MariaDB. However, It takes one and half minute. I have created the table with federated engine pointing to remote MariaDB. Including all the ...
Hector Daniel Bernal Amaya's user avatar
0 votes
0 answers
190 views

mySQL InnoDB tablespace move to network drive

In Windows 10 with mySQL 8.0.26, I am seeking to move a set of rarely used but occasionally necessary tables from my working SSD to another physical device with more space. I have attempted to move ...
wistlo's user avatar
  • 119
1 vote
1 answer
1k views

MariaDB bound to 0.0.0.0, but doesn't appear to be listening to all IPs?

My MariaDB server accepts connections at port 43210 without problems on the public IP address of, we'll say, 123.123.123.123 on eth0. This is on an Ubuntu 18.04 server that also has 192.168.1.10 ...
ylluminate's user avatar
4 votes
2 answers
11k views

Cannot give NT SERVICE\MSSQLSERVER permissions on network drive

I have an SSIS package that I would like to run as a job. The flat file source sits on Server A while the package and job sit on Server B. When I run the job that executes the SSIS package I get an ...
Cody Francis's user avatar
0 votes
1 answer
32 views

VM'd a SQL server, having trouble with external HDDs

First I am not a SQL DB. I inherited an old system and am trying to keep the wheels from falling off. We have an MS SQL 2000 server (running server Win Server 2000) that we performed a P2V migration ...
mcv110's user avatar
  • 75
0 votes
1 answer
756 views

IP Addresses tab is not showing a specific IP Address

I have SQL SERVER 2008 R2 installed on windows Server 2016, it runs smoothly on a LAN network interface. I Added a USB MODEM (4G) to the server and went to the IP Addresses tab in network ...
uramium's user avatar
1 vote
2 answers
5k views

The listener supports no services - 2 databases on oracle linux 7

I'm running two 12c R2 databases on linux oracle 7.9 I've installed the first database (CDB) and also a listener and both of them were running fine. Then, I've installed another 12c R2 database (CDB2) ...
Andrew T's user avatar
0 votes
2 answers
173 views

Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?

(more details/replicate from: https://superuser.com/questions/1612260) Dear all, I'm a total newbie in connecting 2 PCs and making them use the same SQL server DB from one computer ... so please ...
radui's user avatar
  • 101
2 votes
4 answers
678 views

Multi-insert batch executed remotely 5x slower than locally

I am inserting 30.000 rows into a table in one batch using INSERT .. VALUES statement for each row. See the testing environment: Table creation: CREATE TABLE [dbo].[TestInsert]( [Col1] [int] NOT ...
jericzech's user avatar
  • 945
1 vote
1 answer
2k views

Why availability group resource goes offline in WSFC?

Sometimes I find the AG Cluster role in offline state which results the AG in resolving state. It doesn't allow the application to access the databases during this time. And then after sometime it ...
Sree Lekha's user avatar
0 votes
0 answers
102 views

How to increase donor speed on mariadb galera cluster?

hi currently i have database with size 200gb and my every node at 1Gb/s so when 1 node is down and then 2 node will be donor i config mariadb donor with wsrep_sst_method = rsync method. but it's take ...
febry's user avatar
  • 47
2 votes
0 answers
3k views

Sql error number: 1236. Error Message: A transport-level error has occurred when receiving results from the server

I'm getting a SQL Server error: Execution fail against sql server. Sql error number: 1236. Error Message: A transport-level error has occurred when receiving results from the server. (provider: TCP ...
Vuong Nguyen's user avatar
0 votes
1 answer
108 views

Web server accessing the database server in Always on availability group

We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server. ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
901 views

Making an Oracle XE instance network wide available

Im fairly new to Oracle so please bear with me. I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
SweetPotato's user avatar
13 votes
3 answers
5k views

Disconnect from network without stopping the query

I have an opposite problem to Does disconnecting the network stop a query?. I would like to launch a query and disconnect without waiting for results but I don't want the query to stop. Is it possible?...
YuseqYaseq's user avatar
0 votes
1 answer
1k views

How to use BCP Utility queryout in a network path with crededential (login required) for SQL Server

I'm having a hard time figuring out on how can I export my selected table in a network path that requires login credentials. 'bcp "select ''StudentName'' UNION ALL SELECT StudentName AS ...
Lawless16's user avatar
0 votes
1 answer
5k views

What is the max network latency between synchronous-commit AlwaysOn Availability Groups [closed]

Is there a maximum supported network latency (ms) between two synchronous AlwaysOn replica? I need to give this information to network administrators for configuring the link between the two nodes of ...
Gio's user avatar
  • 107
0 votes
1 answer
65 views

MariaDB: Connecting from LAN on Centos

I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN. Out of curiosity, I wanted to revisit how this was made possible. Everything I ...
Manngo's user avatar
  • 2,839
0 votes
2 answers
605 views

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. Replication from leader to follower is configured. Consider that the leader node crashes. Two ...
Pedro Lopes's user avatar
1 vote
1 answer
1k views

PostgreSQL: Save roundtrips / Network performance

For my work I often have to to large selects loading a lot of data. The connection happens with JDBC driver and high fetch size. This is not a problem when working directly on the server of the ...
beginner_'s user avatar
  • 213
3 votes
0 answers
2k views

DNS CNAME for a SQL Managed Instance (Azure)

I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server. I am looking to move this server to an Azure Managed Instance and I want to point the DNS ...
Lickrob's user avatar
  • 84
1 vote
1 answer
857 views

Why changing the order of network protocols does not make any sense?

All I want to do is to connect to SQL Server though Named Pipes without using an explicit way like NP:ServerName because mentioned approach works. I want to connect through Named Pipes using just ...
Rauf Asadov's user avatar
  • 1,273
0 votes
0 answers
308 views

Adding login of a pc on the network - Microsoft SQL Server Management Studio 2014

I have a small office network and I am trying to add new logins for the other PCs on Microsoft SQL Server Management Studio 2014 (all computers are Windows 7). I cannot seem to find the other ...
Geo_explorer's user avatar
-1 votes
1 answer
111 views

Connecting database from another network [closed]

We have a database in our server at work, and we can connect the database if we are connected to same network with server. I want to connect from my home. How can I do this? I have tried couple of ...
ridley13's user avatar
2 votes
1 answer
182 views

Troubleshooting high network traffic between primary and secondary replicas

We have two SQL server hosts. There are about 12 availability groups, where the primary replica is on the "primary" host and the secondary replicas are on the "secondary" host. Now, for one reason or ...
AlexMayle's user avatar
  • 165
0 votes
2 answers
2k views

ASM - How the asm search the disks and where is this parameter from?

I'm a begginer in Oracle ASM and when I will create a diskgroup the ASM shows me this parameter: Where is this parameter from? I don't remember set any parameter with this name. I know that usually ...
Astora's user avatar
  • 723
0 votes
1 answer
733 views

Oracle - Why create several service_name in service_names parameter?

SERVICE_NAMES specifies one or more names by which clients can connect to the instance. The instance registers its service names with the listener. When a client requests a service, the listener ...
Astora's user avatar
  • 723
2 votes
1 answer
829 views

Need SQL Server VLAN advice.. is it best practice to have all SQL Servers under 1 VLAN/network zone? [closed]

Looking at the network placement of my SQL Servers. Looking for answers: Is it a best practice to have all SQL Servers in 1 or 2 VLANs within your businesses network? however, if so, wont there ...
Daniel Nash's user avatar