Liferay instance node going into hang mode - Failed to validate connection

Issue

• Liferay instance node goes into hang mode and the following error appears:
  

  HikariPool-1 - Failed to validate connection ... (This connection has been closed.)
  ...
  Possibly consider using a shorter maxLifetime value.

Environment

• DXP 7.4
• PostgreSQL

Resolution

• We strongly recommend setting this value, and it should be several seconds shorter than any database or infrastructure imposed connection time limit.
  • The minimum allowed value is 30000ms (30 seconds)

Additional Information

• The maxLifetime property controls the maximum lifetime of a connection in the pool. An in-use connection will never be retired, only when it is closed will it then be removed. On a connection-by-connection basis, minor negative attenuation is applied to avoid mass-extinction in the pool. A value of 0 indicates no maximum lifetime (infinite lifetime), but still subject to the idleTimeout setting.
• References for related to the default values and modifications to the DB connection count and maxLifetime properties:
  • Configuring the Database Connection Pool
  • Tuning Liferay