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: 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%. |
| Notes: |
Was this article helpful?
0 out of 0 found this helpful