nzsql error, Unexpected protocol character/message - PureData System for Analytics

-

Problem(Abstract)

Error: Unexpected protocol character/message

Symptom

A remote client connecting to the database intermittently displays the following error message:

'SimpleDB::Database::Exception' what(): Error SQLConnect: [unixODBC]Unexpected protocol character/message


Cause

The problem occurs when DNS and/or network response becomes slow which causes an nslookup timeout error on the Netezza side of the remote connection.

Resolving the problem

To prevent this error, do the following:


1. Confirm that the client IP address is listed in the /etc/hosts file on the host; if not, add it.

2. Confirm that the host domain name is listed in the client's /etc/hosts file; if not, add it.

These changes eliminate the need for the reverse lookup over the network.

​Source: http://www-01.ibm.com/support/docview.wss?uid=swg21569232​

Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more