Timeout errors with MySQL 5.7

[corkyman]

We are in the process of migrating from standalone MySQL 5.5 to the enterprise MySQL 5.7 db. We have migrated the dev and preproduction environments and the DBA started seeing the following errors repeating in the log that were no in 5.5:

2017-01-31T01:49:51.596360Z 6105558 [Note] Aborted connection 6105558 to db: 'nagios' user: 'ndoutils' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-31T01:49:51.599303Z 6105559 [Note] Aborted connection 6105559 to db: 'nagiosql' user: 'nagiosql' host: '10.5.197.39' (Got timeout reading communication packets)
2017-01-31T01:49:51.599429Z 6105557 [Note] Aborted connection 6105557 to db: 'nagiosxi' user: 'nagiosxi' host: '10.5.197.39' (Got timeout reading communication packets)

She is asking the following questions:
1. Does NAGIOSXI use connection pooling?
2. Are connections getting closed properly?
3. DO you want to check with NAGIOS support if you want to increase wait_timeout or interactive_timeout values?

[rkennedy]

Before we dive into the issue at hand, I do have to ask about your environment. Are you still running two XI systems into the same database in a HA type setup? This would definitely impact what's going to happen all around.

We'll need as much information about it as you can provide, so we can further understand what's going on here.

I do believe this is also related - https://support.nagios.com/forum/viewto ... 91#p211091

[corkyman]

Yes, we run 2 nagios XI servers against one remote MySQL db but only one server has nagios and ndo2db processes running at a time. Usually it is a primary server but when the backup server detects that nagios process is not running on te primary it initiates the failover and stops/starts processes as needed.

[tmcdonald]

A few questions:

• Does this error show up only when failing over from the primary to the backup, or is it consistent?
• Can you please describe the steps taken when the failover occurs? Include any scripts or commands that are run.
• Is this database used for anything else?

I will say that we generally don't get too terribly involved with HA setups ourselves. We typically point people to LinBit for architecting that sort of thing, since it isn't something we have support for out of the box.

I'll need to check with a developer for your numbered questions in your first post.

[corkyman]

Please close this incident. My DBA says there is a new option in MySQL 5.7 that allows them to control the verbosity of messages. When she adjusted it to show only errors and warnings these msgs stopped filling up the logs and she said we should not worry about it. Thank you.