HelioHost Posted June 1 Posted June 1 Username: riskwisper, Server: Tommy, Main domain: riskwisper.helioho.stHi HelioHost Support, I am on the Tommy server. My PostgreSQL database and PHP site are intermittently unavailable. Both my PHP application and Adminer fail with this error: FATAL: remaining connection slots are reserved for non-replication superuser connections Database: riskwisper_risksys Database user: riskwisper_riskadmin Access is intermittent ? Adminer connects sometimes, then fails again with the same connection-slot error. Because Adminer also cannot reliably connect, I cannot run pg_stat_activity or terminate any sessions myself. Can you please check whether PostgreSQL on Tommy has exhausted connection slots, or whether there are stuck/orphaned PostgreSQL sessions for my account/database? Thanks.
Krydos Posted June 2 Posted June 2 Prior to 2021 we ran another control panel, and each of the plans had different database connection limits. If I recall correctly the Johnny plan was only allowed 2 database connections at the same time, and Tommy was 4 or 6 or something slightly higher. Needless to say our forum was covered with posts from people who write bad code that would try to open 100 simultaneous connections, and then they would complain to us that they were getting an error message about it. We got so sick of seeing those same forum posts all the time, that we decided to do an experiment when we switched to the new control panel. We decided to allow unlimited database connections. It worked well for 3 years with MariaDB before a lot of people started abusing it. You can read about it in this news post https://helionet.org/index/topic/59949-mariadb-limits/ The person who was abusing Tommy's unlimited PostgreSQL connections has been suspended, so hopefully you shouldn't get that error anymore. Let us know if you see it again. If multiple people start causing issues over and over we may have to make a limit like MariaDB.
Recommended Posts