[Poolman-user] Problems with Poolman and Informix 7

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi All --

I am using poolman and love it, except that I am having problems with 
Informix (v 7).  

I'm running a webapp (under tomcat) using poolman which, after several 
minutes of use, suffers severe brain damage and hangs the database.  
The webapp itself hangs, tomcat won't respond to a control c, and 
another webapp in a different tomcat, not using connection pooling, on 
a different machine, but accessing the same database, hangs too.  
dbAccess (the command line viewer) can't connect to the database.  
However, in the midst of all of this, I was able to get a simple java 
app that opens a connection and executes a query to work properly... 
I'm very confused.

I tested this same app with poolman for 2 days straight under postgres 
at home and had no such problems.

The DBA here said that there are 10 connections open and that each of 
those has spawned several threads.  There are 10 distinct session 
numbers, which seems to jive with my poolman.xml file.

If anyone has any ideas, or has experienced something similar, I'd love 
to hear from you.  Included below are my poolman.xml and the log file.

Thanks,
Anne

-------------------------------------------------
  poolman.xml
-------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>

<poolman>

  <management-mode>local</management-mode>

  <datasource>

    <dbname>informix</dbname>
    <jndiName>jndi-informix</jndiName>
    <driver>com.informix.jdbc.IfxDriver</driver>
    <url>jdbc:informix-sqli://eagle:1912/trans:INFORMIXSERVER=oltp</url>

    <username>bstwall</username>
    <password>twoby8</password>

    <minimumSize>0</minimumSize>
    <maximumSize>10</maximumSize>
    <initialConnections>2</initialConnections>
    <logFile>/home/bstwall/logs/testdb.log</logFile>
    <debugging>true</debugging>

    <maximumSoft>false</maximumSoft>

    <connectionTimeout>300</connectionTimeout>

    <userTimeout>10</userTimeout>

    <skimmerFrequency>100</skimmerFrequency>

    <shrinkBy>2</shrinkBy>

   </datasource>

</poolman>

-------------------------------------------------
  logfile
-------------------------------------------------

Creating 2 initial objects in pool informix
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 1 Objects Available: 0 
Objects In Use: 1 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 2 Objects Available: 0 
Objects In Use: 2 }
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 2 Objects Available: 1 
Objects In Use: 1 }
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 2 Objects Available: 2 
Objects In Use: 0 }
Completed creation of initial objects
Starting PoolSkimmer, which will expire objects after the 
<skimmerFrequency> element (currently set to 100 seconds)
Starting LifeGuard, which will return checked-out objects to their 
pools if they are held longer than the <userTimeout> element (currently 
set to 10 seconds)
DataSource bound to JNDI under name jndi-informix
PoolMan Local Pool Deployer: Created JDBC Connection Pool named: 
informix
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 2 Objects Available: 1 
Objects In Use: 1 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 2 Objects Available: 0 
Objects In Use: 2 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 3 Objects Available: 0 
Objects In Use: 3 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 4 Objects Available: 0 
Objects In Use: 4 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 5 Objects Available: 0 
Objects In Use: 5 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 6 Objects Available: 0 
Objects In Use: 6 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 7 Objects Available: 0 
Objects In Use: 7 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 8 Objects Available: 0 
Objects In Use: 8 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 9 Objects Available: 0 
Objects In Use: 9 }
PoolMan ObjectPool: created a new object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 0 
Objects In Use: 10 }
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 10 
Objects In Use: 0 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 0 
Objects In Use: 10 }
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 10 
Objects In Use: 0 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
JDBCPool received a ConnectionClosed Event, returning connection to pool
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
JDBCPool received a ConnectionClosed Event, returning connection to pool
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 0 
Objects In Use: 10 }
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 0 
Objects In Use: 10 }
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
PoolMan ObjectPool: No available objects and maximum pool size hard 
limit reached... waiting for an object to be checked in
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 1 
Objects In Use: 9 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 2 
Objects In Use: 8 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
JDBCPool received a ConnectionClosed Event, returning connection to pool
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
JDBCPool received a ConnectionClosed Event, returning connection to pool
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
JDBCPool received a ConnectionClosed Event, returning connection to pool
PoolMan ObjectPool metrics after returning object:
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
PoolSkimmer cleaning objects from the pool that have exceeded their 
allotted lifespan, has 3 pooled objects to evaluate...
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 10 
Objects In Use: 0 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 9 
Objects In Use: 1 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 8 
Objects In Use: 2 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 7 
Objects In Use: 3 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
PoolMan ObjectPool: returned existing pooled object for request
	Pool Name: informix { Total Objects: 10 Objects Available: 3 
Objects In Use: 7 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 4 
Objects In Use: 6 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 5 
Objects In Use: 5 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout
	Pool Name: informix { Total Objects: 10 Objects Available: 6 
Objects In Use: 4 }
LifeGuard returning an object to pool informix that had exceeded its 
user timeout