Informix Error -14565: CSS: error reading data.
Cause and resolution
CSS: error reading data.
The database server or client's attempt to receive data to establish Communication Support Services (CSS) context failed.
Probable causes of the error and corrective actions follow:
* This error usually occurs when the CSM option is turned on and the database server or the network is very busy, or when too many clients are trying to connect to the database server at once. The database server might be taking so long to respond to a client that the client's connection request times out before the connection is complete. Or possibly a client terminates its connection attempt before the connection is completely established.
Use the environment variable INFORMIXCONTIME or INFORMIXCONRETRY, or both, on the client side to increase the connection time and the number of retry attempts.
* Either the database server or the client application exits abnormally due to an error condition. The other side which is waiting for data from the failed side would report this error. Check the error on the failed side for the root cause of the problem.
If the problem persists, contact IBM Informix Technical Support or the CSM vendor and have the following information available: CSS configuration files (concsm.cfg) and sqlhosts information for both the client and the database server.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-14565 fires when the database server's or client's attempt to receive data to establish a Communication Support Services (CSS) context fails — per the official guidance.
- The database server or network being very busy, or too many clients connecting at once, per the official guidance — the connection request can time out before the connection completes, or the client can abandon the attempt first.
- The database server or the client application exiting abnormally, per the official guidance — the side waiting for data reports this error when the other side fails.
Solutions / Resolution
- Use the
INFORMIXCONTIMEand/orINFORMIXCONRETRYenvironment variables on the client side to increase the connection time and the number of retry attempts, per the official guidance, if server/network load is the cause. - Check the error on the failed side for the root cause, per the official guidance, if one side exited abnormally.
- If the problem persists, contact IBM Informix Technical Support or the CSM vendor, per
the official guidance, with the CSS configuration files (
concsm.cfg) andsqlhostsinformation for both the client and the database server available.
Examples
Increasing connection time and retries
$ export INFORMIXCONTIME=60
$ export INFORMIXCONRETRY=3
Diagnostic Checks
- Check whether the database server or network was under heavy load at the time of the
error, and consider increasing
INFORMIXCONTIME/INFORMIXCONRETRY. - Check the error reported on the other side of the connection for the root cause if it exited abnormally.
Related Errors / Related Topics
- -14563 — "CSS: error writing data." The mirror-image error, about sending data rather than receiving it.
CSS failed to receive data while establishing its context — likely server/network load or an
abnormal exit on the other side; increase INFORMIXCONTIME/INFORMIXCONRETRY or check the
other side's own error.