#3185: Limit connection limit of moved trac instances
----------------------+--------------------------------------
Reporter: robe | Owner: sac-tickets@…
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2024-I
Component: SysAdmin | Keywords:
----------------------+--------------------------------------
trac appears to be suffering from some bot attacks of late eating up
connections.
I think many of these strk observed were to sites no longer used.
For now, I'm going to limit the number of connections of these defunct
site databases to 5 connections max.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/3185>
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.
#3185: Limit connection limit of moved trac instances
----------------------+---------------------------------------
Reporter: robe | Owner: sac-tickets@…
Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2024-I
Component: SysAdmin | Resolution: fixed
Keywords: |
----------------------+---------------------------------------
Changes (by robe):
* status: new => closed
* resolution: => fixed
Comment:
ran this
{{{
ALTER DATABASE trac_csmap WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_fdo WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_gdal WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_mapserver WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_qgis WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_metacrs WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_proj4j WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_proj4js WITH CONNECTION LIMIT = 5;
ALTER DATABASE trac_geos WITH CONNECTION LIMIT = 5;
}}}
there are others but will start with these. At the moment there seem to
be no active connections and inactive connections are as follows:
{{{
SELECT datname, count(*) FROM pg_stat_activity GROUP BY datname;
datname | count
----------------+-------
| 5
gitea | 2
trac_qgis | 5
trac_mapguide | 4
postgres | 1
trac_osgeolive | 3
trac_postgis | 10
trac_mapserver | 2
trac_gdal | 5
trac_osgeo | 13
trac_grass | 1
trac_csmap | 1
trac_osgeo4w | 2
(13 rows)
}}}
--
Ticket URL: <#3185 (Limit connection limit of moved trac instances) – OSGeo;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.