[PERFORM] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

[itishree sukla]

Dear All,

Can any one please help me to fix this issue, i am getting this error from
our application, currently Database is running on 9.2.

2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread
[http-8080-1];  --- getConnection() Exception:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at
com.tenkinfo.b2g.database.ConnectionManager.getConnection(ConnectionManager.java:39)
at
com.tenkinfo.b2g.usermanagement.dao.UserManagementDAOImpl.getSessionData(UserManagementDAOImpl.java:228)
at
com.tenkinfo.mapnsav.common.action.BaseAction.execute(BaseAction.java:156)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)

Do i have to set tcp _keepalive * paramter to less sec, or need to kill the
idle connection ?

Regards,
Itishree

[PERFORM] Check Pointer

[itishree sukla]

Hi all,

In our server Check pointer process is consuming 8 GB of memory, what could
be the possible reason? Can any one please help.

Regards,
Itishree

Re: [PERFORM] Check Pointer

[itishree sukla]

Thanks for the quick response. Below is the out put of Top Commnd.

3971 postgres  20   0 8048m 303m 301m S0  0.9   0:04.34
/usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/main -c
config_file=/etc/postgre
 3972 postgres  20   0 66828 1820  708 S0  0.0   1:36.37 postgres:
logger
process

 3974 postgres  20   0 8054m 7.6g 7.6g S0 24.1   0:56.59 postgres:
checkpointer
process
 3975 postgres  20   0 8051m 895m 891m S0  2.8   0:04.98 postgres:
writer
process

 3976 postgres  20   0 8051m   9m 9072 S0  0.0   0:35.17 postgres: wal
writer
process
 3977 postgres  20   0 70932 3352  716 S0  0.0   0:05.19 postgres:
stats collector
process
1

Postgresql =9.2.3



On Thu, May 30, 2013 at 5:56 PM, Heikki Linnakangas  wrote:

> On 30.05.2013 15:09, itishree sukla wrote:
>
>> In our server Check pointer process is consuming 8 GB of memory, what
>> could
>> be the possible reason? Can any one please help.
>>
>
> Are you sure you're measuring the memory correctly? The RES field in top
> output, for example, includes shared memory, ie. the whole buffer cache.
> Shared memory isn't really "consumed" by the checkpointer process, but
> shared by all postgres processes.
>
> - Heikki
>

Re: [PERFORM] Check Pointer

[itishree sukla]

Can any one give more input, you can see my top out put, in %MEM its taking
24.1.

Regards,
Itishree


On Thu, May 30, 2013 at 6:15 PM, itishree sukla wrote:

> Thanks for the quick response. Below is the out put of Top Commnd.
>
> 3971 postgres  20   0 8048m 303m 301m S0  0.9   0:04.34
> /usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/main -c
> config_file=/etc/postgre
>  3972 postgres  20   0 66828 1820  708 S0  0.0   1:36.37 postgres:
> logger
> process
>
>  3974 postgres  20   0 8054m 7.6g 7.6g S0 24.1   0:56.59 postgres:
> checkpointer
> process
>  3975 postgres  20   0 8051m 895m 891m S0  2.8   0:04.98 postgres:
> writer
> process
>
>  3976 postgres  20   0 8051m   9m 9072 S0  0.0   0:35.17 postgres: wal
> writer
> process
>  3977 postgres  20   0 70932 3352  716 S0  0.0   0:05.19 postgres:
> stats collector
> process
> 1
>
> Postgresql =9.2.3
>
>
>
> On Thu, May 30, 2013 at 5:56 PM, Heikki Linnakangas <
> hlinnakan...@vmware.com> wrote:
>
>> On 30.05.2013 15:09, itishree sukla wrote:
>>
>>> In our server Check pointer process is consuming 8 GB of memory, what
>>> could
>>> be the possible reason? Can any one please help.
>>>
>>
>> Are you sure you're measuring the memory correctly? The RES field in top
>> output, for example, includes shared memory, ie. the whole buffer cache.
>> Shared memory isn't really "consumed" by the checkpointer process, but
>> shared by all postgres processes.
>>
>> - Heikki
>>
>
>