Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.9.1 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Error "Got timeout reading communication packets"

Hello OCS community,

we are using OCS Inventory NG  in our company.

Multiple times a day I can experience the following error message in the MySQL Server 5.7 error logs with this pattern:

2021-06-27T23:56:22.342179Z 910027 [Note] Aborted connection 910027 to db: '<ocs_db>' user: '<MySQL_user_forr_ocs>' host: '<our_ocs_server>' (Got timeout reading communication packets)

This only happens in reference with the MySQL database used for OCS. There is no issue with other MySQL databases within the same server.

As to Oracle the reason for this kind of error might likely be related to that OCS is not closing down the database connections properly. The sessions remain open and after the specified timeouts passed ("interactive_timeout" and "wait_timeout) the session are closed by MySQL. This triggers the output in the error logfile.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=457345552799625&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2322952.1&_afrWindowMode=0&_adf.ctrl-state=7t8dq5shl_4
(login needed)

Could this be related to OCS directly ? Application issue ?
Any recommendations ?
Is anyone experiencing this as well ?

I do not know have much knowledge in OCS, please let me know, if additonal information is missing.

Many Thanks

ago in OCS Inventory NG server for Unix by (120 points)

1 Answer

0 votes
ago by (86.3k points)
 
Powered by Question2Answer
...