(JCA PoolFiller:) Unable to fill pool

[wdijkerman]

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

[eklam]

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

[tiagoemerick]

Same error here, but im using JBoss5.

anyone of you solved that?

Thx

[eklam]

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

[tiagoemerick]

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?

[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