Kemp Support, how can we help?

The latest application delivery knowledge and expertise at your fingertips.

SQL STATE fatal error

 

Information

 

Summary:

Top chapter calculation processes in combination with ADS plugin processes may exhaust connections to the database in case of 6+ CPUs appliance and allocated CPU for report computing 50% and more.

Environment:

Product: FOS

Version: FOS 12.2.6 and older

Platform: Any

Question/Problem Description:

GUI is unavailable.

Steps to Reproduce:  
Error Message: In /var/www/log/error.log
[<timestamp>] PDOException: SQLSTATE[08006] [7] FATAL: remaining connection slots are reserved for non-replication superuser connections #<X> in <location>

[@frontend-acf7d9@] It is not possible to obtain configuration of the section "<section_name>" due to the following error: "SQLSTATE[08006] [7] FATAL: remaining connection slots are reserved for non-replication superuser connections". This may lead to displaying outdated data in the user interface and the inability to change some settings. Please check the configuration of this section. If this error keeps showing up, please contact the support.
Defect Number: FLMON-4830
Enhancement Number:  
Cause: Delepted connections to the database.
Resolution: Fix is implemented in FOS 12.3.X version.
Workaround: In Configuration Center -> FMC Configuration -> Reports -> Basic Settings decrease Reserved CPU to 30%.
Notes:  

Was this article helpful?
0 out of 0 found this helpful

Comments