postgresql – 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 a query that is executed through an ODBC connection in a Powershell 5.1 script. I use the Fill() method to retreive about 3500 records daily. When the script works, it takes 2-5 minutes to execute and retrieve data when it works.
Problem is that the script “fails” half of the time approx. When this occurs, the Powershell script does stop only after 2h and 30 seconds.

We double checked the postgres logs and when this occurs, we see that the query successfully completed within 6 minutes always. I don’t know what to look for. any Idea?

Below is the error got:

Executed as user: NT ServiceSQLSERVERAGENT. A job step received an error at line 94 in a PowerShell script. The corresponding line is ‘(New-Object system.Data.odbc.odbcDataAdapter($cmd)).fill($ds) | out-null ‘. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Exception calling “Fill” with “1” argument(s): “The connection has been disabled.” ‘. Process Exit Code -1.

Not too familiar with postgreSQL.

Thanks!

Up To 30% OFF Recurring VPS – 1Gbps Connection – DDOS Protection – 24/7 Free support | Proxies-free

HostSailor has established itself as a trusted provider of high-quality VPS Hosting, Shared Hosting, Dedicated servers, Domains, and SSL Certificates with top-notch support and impeccable reputation and also offers some of the most competitive pricing, without sacrificing the quality of the products and services.
HostSailor is based in Dubai, UAE, and the services are physically located in the Netherlands, all servers are HP and 100% owned, we do not resell any of our VPS services.
Operating systems: ( CentOS, Debian, Fedora, Scientific, Suse, and Ubuntu ) If we don’t have it, we can install it for you! or you can request us to mount your own image.

—————————————

VPS :

—————————————

15% OFF Recurring, Monthly ===>> Coupon: MAY21VPS
—————————————————————-
20% OFF Recurring, Quarterly ===>> Coupon: MAY4VPS2021
—————————————————————-
25% OFF Recurring, Semi-Annually ===>> Coupon: MAY25VPS
—————————————————————-
30% OFF Recurring, Annually ===>> Coupon: ANN2021MAY
—————————————————————-
20% OFF Recurring , Mini Sailor Only “Annually” ===>> Coupon: MINI2021MAY
—————————————————————-

Linux SSD OpenVZ:

Sailor:

512 Guaranteed RAM
512 VSwap RAM
15 GB SSD
1 Core
1 Gbit Port
512 GB Bandwidth
1 IPV4 address
Unlimited IPv6
SolusVM Control Panel
Hosted in the Netherlands
(size=18pt)
* $2.99 USD/month(/size)

To check all our SSD OpenVZ plans or place an order go to http://hostsailor.com/vps-hosting/openvz-ssd-vps/

=====================================

Linux XEN & KVM:

Sailor:

512 Guaranteed RAM
512 SWAP
15 GB HDD
2 Cores
1 Gbit Port
512 GB Bandwidth
1 IPV4 address
Unlimited IPv6
SolusVM Control Panel
Hosted in Netherlands ( KVM & XEN )
Hosted in Romania ( KVM )

(size=18pt)* $3.99 USD/month(/size)

To check all our XEN plans or place an order go to http://hostsailor.com/vps-hosting/xen-vps

To check all our KVM plans or place an order go to http://hostsailor.com/vps-hosting/kvm-vps

=====================================

Operating systems: ( Windows 2008 server datacenter R2 and Windows 2012 server datacenter R2 )

Windows KVM:

Seaman:

512 Guaranteed RAM
30 GB HDD
2 Cores
1 Gbit Port
512 GB Bandwidth
1 IPV4 address
Unlimited IPv6
SolusVM Control Panel
Hosted in the Netherlands

(size=18pt)*$5.99 for month(/size)

To check all our Windows plans or place an order go to http://hostsailor.com/vps-hosting/kvm-vps/windows-vps/

=====================================================================:
=====================================================================:

Payment methods:

BTC & ALT, PayPal, Perfect Money, WebMoney, Bank Transfer.
Western Union, BANCODOBRASIL, CREDIT/BANK CARD.

please check Here https://hostsailor.com/payment-methods/
=====================================

Features:

1. Gig connections to every VPS
2. IPV4 and IPV6 enabled VPS
3. Hardware RAID 10 for optimum disk performance
4. Weekly backups
5. Managed services
6. SolusVM Control Panel
7. Flexible Upgrading / easy scalability
8. VPS located in Netherlands
9. Reverse DNS
10. Instant Setup
11. Free incoming bandwidth
12. No Setup fees
13. No contracts
14. Money back guarantee within 14 days

=====================================
(size=36pt)Host Sailor:(/size)

To know more about us visit Our company
To check our terms of use please click on TOS
We offer an amazing service level agreement at SLA
For our Acceptable use policy check AUP
To get more info about our data center check Our data center

=====================================

FAQ and Support:

Please check our FAQ
To get in touch with us via email please use contact us
To get in touch with us via LiveChat, please visit our site at HostSailor and we’ll be happy to help!

=====================================

Our Social Media Pages:

to visit our Facebook page please click here
to visit our Instagram page please click here
to visit our Twitter page please click here
to visit our Telegram channel please click here ​

connection pooling – Cost of Increasing max pool size in SQL Server

We have a public front website that run fine most of the time. But we sometimes experience peaks of connections (like after a mailing campaign) and we were getting error like :

Timeout expired. The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use and max pool size was reached

We are pretty sure that all our connections are closed properly (no connection leak).

So we decided to increase the number of connection allowed in the pool (which is 100 by default).

We increased it to 1000 (max pool size=1000; in our connection string), and now our site can handle most peaks of connections. (I precise the site run on a dedicated server)

My question is : What may be the negative effects of the increase of the max connections pool ?

magento2 – Magento 2.4.0 – Getting Error Could not validate a connection to Elasticsearch. No alive nodes found in your cluster

I have installed Elasticsearch in my Linux Mint & It’s working fine. Here is the steps.

Run the below command to Install Elasticsearch In locally.

Download and install the public signing key :

wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo apt-key add -

Installing from the APT repositoryedit

You may need to install the apt-transport-https package on Debian before proceeding :

sudo apt-get install apt-transport-https

Save the repository definition to /etc/apt/sources.list.d/elastic-7.x.list :

echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | sudo tee /etc/apt/sources.list.d/elastic-7.x.list

You can install the Elasticsearch Debian package with :

sudo apt-get update && sudo apt-get install elasticsearch

Elasticsearch is not started automatically after installation. How to start and stop Elasticsearch depends on whether your system uses SysV init or systemd (used by newer distributions).

ps -p 1

Running Elasticsearch with SysV init : Use the update-rc.d command to configure Elasticsearch to start automatically when the system boots up :

sudo update-rc.d elasticsearch defaults 95 10

Elasticsearch can be started and stopped using the service command :

sudo -i service elasticsearch start

sudo -i service elasticsearch stop

Configure Apache and Elasticsearch : Set up a proxy (Set up a proxy for Apache 2.4)

Enable mod_proxy as follows :

a2enmod proxy_http or sudo a2enmod proxy_http

Use a text editor to open /etc/apache2/sites-available/000-default.conf

Add the following directive at the top of the file :

Listen 8080

Add the following at the bottom of the file :

<VirtualHost *:8080>
    ProxyPass "/" "http://localhost:9200/"
    ProxyPassReverse "/" "http://localhost:9200/"
</VirtualHost>

Restart Apache :

service apache2 restart or sudo service apache2 restart

Verify the proxy works by entering the following command :

For example, if your proxy uses port 8080:

curl -i http://localhost:8080/_cluster/health

If curl request success then messages display like below :

HTTP/1.1 200 OK
Date: Sun, 23 Aug 2020 06:05:56 GMT
Server: Apache/2.4.18 (Ubuntu)
content-type: application/json; charset=UTF-8
content-length: 389

{"cluster_name":"elasticsearch","status":"yellow","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":1,"active_shards":1,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":1,"delayed_unassigned_shards":0,"number_of_pending_tasks":0,"number_of_in_flight_fetch":0,"task_max_waiting_in_queue_millis":0,"active_shards_percent_as_number":50.0}

Go to Admin Panel -> Stores -> Settings -> Configuration -> Catalog -> Catalog Search. Change the settings like below.

Search Engine : Search Engine7

Elasticsearch Server Hostname : localhost

Elasticsearch Server Port : 8080

Elasticsearch Index Prefix : magento2

Enable Elasticsearch HTTP Auth : No

Elasticsearch Server Timeout : 15

Now save the configuration & run below cache clean command.

php bin/magento cache:clean

Now click on Test Connection button.

After successful you will receive Successful! Test again? in Test Connection button.

Ref : Dev Docs & Elasticsearch

For More Click here

Ubuntu 20.10 Wifi Connection Drops

We have setup an Ubuntu 20.10 Server having an Intel Wireless Card, the WiFi extremely shaky with frequent disconnections, almost once every minute. The details are as follows:
Ubuntu Version:

Distributor ID: Ubuntu
Description:    Ubuntu 20.10
Release:    20.10
Codename:   groovy

The Linux Kernel is:

5.8.0-43-generic

The hardware version is as follows:

00:14.3 Network controller: Intel Corporation Wireless-AC 9462

The syslog has the following errors:

Apr 28 20:49:37 wpa_supplicant(916): wlp0s20f3: CTRL-EVENT-BEACON-LOSS
Apr 28 20:49:37 wpa_supplicant(916): message repeated 2 times: ( wlp0s20f3: CTRL-EVENT-BEACON-LOSS )
Apr 28 20:49:37 wpa_supplicant(916): wlp0s20f3: CTRL-EVENT-DISCONNECTED bssid=e4:c3:2a:21:6b:49 reason=4 locally_generated=1
Apr 28 20:49:38 ntpd(1153): Deleting interface #82 wlp0s20f3, 192.168.1.22#123, interface stats: received=1, sent=1, dropped=0, active_time=83 secs
Apr 28 20:49:38 ntpd(1153): Deleting interface #83 wlp0s20f3, fe80::46af:28ff:fe0a:9c9f%3#123, interface stats: received=0, sent=0, dropped=0, active_time=83 secs
Apr 28 20:49:38 wpa_supplicant(916): wlp0s20f3: SME: Trying to authenticate with e4:c3:2a:21:6b:49 (SSID='test' freq=2412 MHz)
Apr 28 20:49:38 kernel: ( 4105.452210) wlp0s20f3: authenticate with e4:c3:2a:21:6b:49
Apr 28 20:49:38 kernel: ( 4105.457695) wlp0s20f3: send auth to e4:c3:2a:21:6b:49 (try 1/3)
Apr 28 20:49:38 wpa_supplicant(916): wlp0s20f3: Trying to associate with e4:c3:2a:21:6b:49 (SSID='test' freq=2412 MHz)
Apr 28 20:49:38 kernel: ( 4105.561893) wlp0s20f3: send auth to e4:c3:2a:21:6b:49 (try 2/3)
Apr 28 20:49:38 kernel: ( 4105.564522) wlp0s20f3: authenticated
Apr 28 20:49:38 kernel: ( 4105.565689) wlp0s20f3: associate with e4:c3:2a:21:6b:49 (try 1/3)
Apr 28 20:49:38 kernel: ( 4105.570818) wlp0s20f3: RX AssocResp from e4:c3:2a:21:6b:49 (capab=0x431 status=0 aid=5)
Apr 28 20:49:38 wpa_supplicant(916): wlp0s20f3: Associated with e4:c3:2a:21:6b:49
Apr 28 20:49:38 wpa_supplicant(916): wlp0s20f3: CTRL-EVENT-SUBNET-STATUS-UPDATE status=0
Apr 28 20:49:38 kernel: ( 4105.574803) wlp0s20f3: associated
Apr 28 20:49:38 wpa_supplicant(916): wlp0s20f3: WPA: Key negotiation completed with e4:c3:2a:21:6b:49 (PTK=CCMP GTK=TKIP)
Apr 28 20:49:38 wpa_supplicant(916): wlp0s20f3: CTRL-EVENT-CONNECTED - Connection to e4:c3:2a:21:6b:49 completed (id=0 id_str=)

The above syslog appears continously almost every minute.

The startup has the following error related to the driver:

(    6.028328) iwlwifi 0000:00:14.3: Direct firmware load for iwlwifi-QuZ-a0-hr-b0-56.ucode failed with error -2
(    6.032948) iwlwifi 0000:00:14.3: loaded firmware version 55.d9698065.0 QuZ-a0-hr-b0-55.ucode op_mode iwlmvm
(    6.032975) iwlwifi 0000:00:14.3: Direct firmware load for iwl-debug-yoyo.bin failed with error -2

If anyone has faced a similar issues and have been able to resolve, please do let me know.
We have disabled the default netplan and are using ifupdown+wpa_supplicant
Cheers!

networking – No network connection after fresh debian install

Today I built a new PC, installed debian, during installation it was downloading additional packages from deb.debian.org mirror, so connection to internet must have been fine, however after installation my debian is not connected to the network at all.

The command ip a shows only “lo” device. In /etc/network/interfaces I can see a device: enx3c18a002d1c5. If I try to do ifup enx3c18a002d1c5 then is says:

Cannot find device "enx3c18a002d1c5"
Failed to get interface index: No such device

virtual machine – Connect Azure VM to site to site with vpn connection, on premise server had f5 big-ip

I have a problem I want to connect an Azure virtual machine (Windows server 2019) to an on premise virtual machine (Windows server 2019) with a site to site connection, but the on premise server uses f5 Big-ip authentication. How can I make those 2 server talk to each other and I tried to search multiple guides couldn’t find any that describe my problem. The f5 configuration on premise is fully setup for azure.

networking – How to block outgoing connection to external website with ufw?

I’m using debian10 ufw, command as next:

ufw deny out to 10.192.225.199 port 80

And the status as next:

# ufw status
Status: active

To                         Action      From
--                         ------      ----
22/tcp                     ALLOW       Anywhere
22/tcp (v6)                ALLOW       Anywhere (v6)

10.192.225.199 80          DENY OUT    Anywhere

But after that, I still could visit external web successfully:

 curl http://10.192.225.199

What happened? Further more, how to block all outgoing traffic to all external website (Just 80 port of other site), not just 10.192.225.199?

macos – Bluetooth Headset (AirPods Pro) Not Activated After Connection

macos – Bluetooth Headset (AirPods Pro) Not Activated After Connection – Ask Different

networking – No Bandwidth on long custom lan cable or no connection at all

i have two CAT7 SFTP cable (around 40m long) and two problems. First Cable (12):

Router 
 |
 v
1gbps switch --> cat8.1 patch cable --> cat6A keystone jack --> ~40m cat7 SFTP cable --> cat6A keystone jack --> cat8.2 patch cable --> wifi6 AP

Switch says: cable is OK – Estimated cable length is 27.00 – 51.00 m

Bandwidth:
100mbps HDX  --> ~80 mbps down / ~90 mbps up / ping ~7ms
100mbps FDX  --> ~20 mbps down / ~20 mbps up / ping ~10ms   (connected, a lot of drops and errors like 1000 errors per min on 80mbps)
1gbps   FDX  --> ~ 0 mbps down / ~0  mbps up / ping ~9999ms (no connection, no drops, no errors)

I checked the cable today with a HT Quicklan 6055 and connections a OK.

Two days ago i had an old POE+ AP running on 1gbps (3W, no drops, no errors) on this connection / cable. I changed it to the new wifi6 AP first with POE+ ~7W and it didn’t want to connect with 1gbps. I changed back to the old AP and it didn’t work on 1gbps since then.

I will change the cable to Cat 8.1 SFTP and the keystone jacks to cat8 ones. I wired the cable every time
according to 568 A.

Its a duplex cable, the other one is connected with my computer (same connector types) and it works with 1gbps. The AP connected directly to the switch with one short Cat7 cable delivers 350mbps with no problem.

Could it be an twisted pair wiring problem?
And is there a difference in bandwidth between POE+ (on / off) on this cable length?
Is it recommended to keep POE+ off and use a power adapter where possible?

I am grateful for any ideas!

For my second cable (13):

Same setup as mentioned above, except for the end. There is a adaptor like this one. I checked the cable with the HT Quicklan 6055 and the cable is OK. But switch says:

cable is not OK
Failure is located approximately 7.00 - 28.00 m from the switch.
        Pair A          Pair B          Pair C          Pair D
Length  7.00 - 27.00 m  8.00 - 28.00 m  7.00 - 27.00 m  8.00 - 28.00 m
State   ✗               ✗               ✗               ✗

Same wire was running with passiv poe for two years. Changed to new AP with 1gbps POE+, a new connector (as linked) at the end of Cat7 SFTP and the leds on the switch remains off.

What could be the reason that the cable are connected properly but the switch sees an error on every cable?

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive Proxies-free.com New Proxy Lists Every Day Proxies123