View Issue Details

IDProjectCategoryView StatusLast Update
0000130Pgpool-IIBugpublic2015-04-18 00:06
Reporterarnold_sAssigned ToMuhammad Usama 
Status assignedResolutionopen 
PlatformIntelOSRHELOS Version5
Product Version 
Target VersionFixed in Version 
Summary0000130: failover command triggered, when pg backend reaches max_connections
DescriptionOne of our pgpool-instances triggered the command for automatic failover.
The only error in the Backend PostgreSQL server was
something like "max_connection is reached".

I guess you can adjust pgpool to handle connections,
so that max_connections is not reached, if all connections use pgpool.
But in this case, there are connections to the server, that
are not managed by pgpool.

Maybe we can workaround that by extending failover_command script,
but i.o.O this behaviour in general is not desirable, is it?

Can this be fixed (perhaps by adding a Parameter to consider reaching max_connections as normal)? That would be great.
Additional InformationAlthough a backend pg server is reaching max_connections
it should be considered operational:
 This happens for example, if moodle clients loose SAN connectivity,
 afterwards transactions don't get committed, no connection gets closed,
 but several are opened. However it's a client problem, the DB server is fine.
 Definitely no need to failover. Otherwise we are running out of options in
 a real failover case...
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-02-20 01:03 arnold_s New Issue
2015-04-18 00:06 Muhammad Usama Assigned To => Muhammad Usama
2015-04-18 00:06 Muhammad Usama Status new => assigned