5 Replies Latest reply on May 12, 2011 8:59 AM by tiagoemerick

(JCA PoolFiller:) Unable to fill pool

wdijkerman Nov 1, 2010 7:50 AM

Hi,

Last weekend we had the following error:

2010-10-29 17:10:10,987 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (JCA PoolFiller:) Unable to fill pool
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Connection reset)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:512)
        at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Io exception: Connection reset
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
        ... 4 more

I can't find any information why this was happening. Can somebody explain that?

I Couldn't find any information out there on the web ...

Server: Jboss 4.05 GA

Thanks.

Kind regards,

Werner

1. Re: (JCA PoolFiller:) Unable to fill pool

eklam Jan 24, 2011 8:30 AM (in response to wdijkerman)

Hi,

Could you solve this issue ?

Any clue? Getting the same error...

Edit: Same version of JBoss, my problem occurs after 6~7 days after JBoss start, an then I need to restart the server, or else the aplication starts to get slower and slower..

Thansks in advance,

Renan
Actions
2. Re: (JCA PoolFiller:) Unable to fill pool

tiagoemerick May 10, 2011 11:20 AM (in response to eklam)

Same error here, but im using JBoss5.

anyone of you solved that?

Thx
Actions
3. Re: (JCA PoolFiller:) Unable to fill pool

eklam May 10, 2011 3:48 PM (in response to tiagoemerick)

Man! No, I at least could no tsolve the issue... As we got a workaround in that server, that restarts it just in time (for me 6~7 days), just let it as it is (you know... oter priorities)...

Your error begin after some time? Or just in the first moments after the start?

Renan
Actions
4. Re: (JCA PoolFiller:) Unable to fill pool

tiagoemerick May 10, 2011 4:02 PM (in response to eklam)

Thx for your answer.

Actually, my app isnt in production yet. In time, i'm just tunning jboss before that.
so... im using jmeter to stress my aplication and a have to achieve 300 simultaneous access, but for now when it takes 120 the error appears.

Im using 2 JBoss. Each JBoss have 1 instance running. In other server i have 1 Apache Web Server(mod_cluster) and the PostgreSQL.
In my datasources i have a max-pool-size with 500(for each JBoss instance, so i have 1000 connections).

PS: In PostgreSQL, has no limit connection.

Any help?
Actions
5. Re: (JCA PoolFiller:) Unable to fill pool

tiagoemerick May 12, 2011 8:59 AM (in response to tiagoemerick)

Just answering my question for someone in future..

In my case, the DBA said that the Postgresql has no limit connection, but he was wrong.
In fact, the limit was 100. woow.

Just increase this value and... magic!

Thx4all
Actions

Go to original post