CMSTier3Log47 < CmsTier3

Tags: view all tags

<!-- keep this as a security measure:
   #uncomment if the subject should only be modifiable by the listed groups 
   * Set ALLOWTOPICCHANGE = Main.TWikiAdminGroup,Main.CMSAdminGroup
   * Set ALLOWTOPICRENAME = Main.TWikiAdminGroup,Main.CMSAdminGroup
   #uncomment this if you want the page only be viewable by the listed groups
   # * Set ALLOWTOPICVIEW = Main.TWikiAdminGroup,Main.CMSAdminGroup
-->

%TOC%

%ICON{arrowleft}% Go to [[CMSTier3LogXX][previous page]] / [[CMSTier3LogXX][next page]] of Tier3 site log %M%

---+ 11. 06. 2013 Constantly more than 250 PG DB connections
Today I'm trying to understand why there are so many PG DB connections to asses if this is somehow expected or not in dCache. 

According to [[https://t3nagios.psi.ch/pnp4nagios/graph?host=t3dcachedb03&srv=PostgreSQL_TOT_active_connections&start=1366485108&end=1370950260][this pnp4nagios plot]] they were always pretty few, especially in the last weeks ( 28th March 2013 ) when we migrated dCache from =1.9.12= to =2.2=; so I would raise them of *50 slots*:</br>
<img src="%ATTACHURLPATH%/TOT_POSTGRESQL_CONNECTIONS_early2013.png" alt="TOT_POSTGRESQL_CONNECTIONS_early2013.png" width="581" height="229" />

To dump the actual connections:
<pre>
[root@t3dcachedb03 ~]# psql -U postgres -H -c "SELECT * FROM pg_stat_activity order by datname;" -o </pre>[[%ATTACHURL%/pg_stat_activity.html][/tmp/table.html]]

----------------

%ICON{arrowleft}% Go to [[CMSTier3LogXX][previous page]] / [[CMSTier3LogXX][next page]] of Tier3 site log %M%

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
png	TOT_POSTGRESQL_CONNECTIONS_early2013.png	r1	manage	28.8 K	2013-06-11 - 11:33	FabioMartinelli	Tot_postgresql_connections_up_to_June_2013
html	pg_stat_activity.html	r1	manage	189.5 K	2013-06-11 - 09:23	FabioMartinelli	pg_stat_activity

Topic revision: r2 - 2013-06-11 - FabioMartinelli

CmsTier3

User Pages
Main Page
Policies

Physics Groups
Steering Board Meetings

Admin Pages
AdminArea
Cluster Specs