Kemp Support, how can we help?

The latest application delivery knowledge and expertise at your fingertips.

SQL STATE fatal error





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.


Product: FOS

Version: 12.2.5 and older

Platform: Any

Question/Problem Description:

In System Messages appeared error [@frontend-acf7d9@] and after a while, GUI was not working.

Steps to Reproduce:  
Error Message: [@frontend-acf7d9@] It is not possible to obtain configuration of the section "Active dashboards" 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: Exhausted connections to the database.
Resolution: It is going to be fixed in the upcoming releases.
Workaround: In Configuration Center -> FMC Configuration -> Reports -> Basic Settings decrease Reserved CPU to 30%.

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