DB communication issues after upgrade.

[dtidwell1224]

After upgrade from nagios 5.6.14 to 5.7.5 we areseeing connection issues to Mariadb.

Nov 17 22:40:05 ohsemon01 mysqld[4320]: 2020-11-17 22:40:05 9 [Warning] Aborted connection 9 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error reading communication packets)
Nov 17 22:40:08 ohsemon01 mysqld[4320]: 2020-11-17 22:40:08 13 [Warning] Aborted connection 13 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error writing communication packets)
Nov 17 23:41:35 ohsemon01 mysqld[4320]: 2020-11-17 23:41:35 3211 [Warning] Aborted connection 3211 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error reading communication packets)
Nov 17 23:41:41 ohsemon01 mysqld[4320]: 2020-11-17 23:41:41 3212 [Warning] Aborted connection 3212 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error writing communication packets)
Nov 17 23:41:41 ohsemon01 mysqld[4320]: 2020-11-17 23:41:41 3210 [Warning] Aborted connection 3210 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error writing communication packets)
Nov 18 00:41:35 ohsemon01 mysqld[4320]: 2020-11-18 0:41:35 10772 [Warning] Aborted connection 10772 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error reading communication packets)
Nov 18 00:41:40 ohsemon01 mysqld[4320]: 2020-11-18 0:41:40 10776 [Warning] Aborted connection 10776 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error writing communication packets)
Nov 18 00:41:40 ohsemon01 mysqld[4320]: 2020-11-18 0:41:40 10771 [Warning] Aborted connection 10771 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error writing communication packets)
Nov 18 01:41:34 ohsemon01 mysqld[4320]: 2020-11-18 1:41:34 17939 [Warning] Aborted connection 17939 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error reading communication packets)


Last check never gets updated.
Increasing the "open_files_limit" in mysql lest it continue running temporarily, but regardless of how high I set it, it seems to only be a temporary fix.
Any help would be appreciated.

[benjaminsmith]

HI,

Besides those errors, how is the server behaving? Are you getting notifications and are check results being updated in the GUI?

Was the upgrade done on the production server or your test instance?

Please try to add the following entry to your /etc/my.cnf file.

Code: Select all

[mysqld]
max_allowed_packet=256M

Also, follow the steps to optimize the PHP settings to make sure nothing is timing out.
https://support.nagios.com/kb/article/n ... e-611.html

Then restart the database and the Nagios service and then let me know if the errors are still being generated.If they are, please send us your system profile.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.