Hi,
In our ODWek REST api we are getting the following response: No availble connections to pool <poolname>
RequestHTTP request to /cmod-rest/v1/ping
Header includes key / pair
- Authorization = CMODSharedKey <connection_poolname-connection_poolkey>
ResponseHTTP Code = 408
Reponse body = No availble connections to pool <poolname>
I have tried to increase the max poolsize in odwek-rest.war even. Any idea what is going on here?
This happends in our test environment - production is fine.
Do the logs in the web server software give any indication as to where the problem might be? There should be other error messages around the time of your request that might shine some light on the issue. :)
-JD.
My guess is the pool is not starting correctly. Stop and start the REST application and then look at the arsrestapi.log. It will give you the information you need to verify this.
Hi, thanks for reply
Our problem was firewall related. ODWek REST not able to connect to CMOD Library Server.
Solved by opening in firewall
Hi Everyone,
I may not original forum owner, but I was founded same issue. (Error 408: No availble connections to pool odpool)
Unfortunely, I have no issue on firewall/connectivity. (WAS/CMODREST/CMODSERVER on same server!)
================
My arsrestapi.log:
2025-Apr-11 13:10:58.728 PM [] INFO SecurityPropertyReader:provideServerPropertiesMap - Number of keys stored: 2
2025-Apr-11 13:10:58.729 PM [] INFO PoolPropertyReader:provideServerPropertiesMap - Reading pool properties from -> poolConfig.properties
2025-Apr-11 13:10:58.730 PM [] INFO PropertyMapReader:provideServerPropertiesMap - Reading pools from -> /opt/ibm/ondemand/V10.5/restcfgdir/pools
2025-Apr-11 13:10:58.730 PM [] INFO PropertyMapReader:provideServerPropertiesMap - Pool configuration: /opt/ibm/ondemand/V10.5/restcfgdir/pools/odpool.conn
2025-Apr-11 13:10:58.733 PM [] INFO StartupListener:init - Starting pool: odpool
2025-Apr-11 13:10:58.759 PM [] FATAL StartupListener:init - Trace directory does not exist!
2025-Apr-11 13:12:40.619 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] INFO LogFilter:filter - GET request to path v1/ping has been made wih authorizaion header CMODSharedKey odpool-{access-id}
2025-Apr-11 13:12:40.627 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] INFO SignatureRequiredFilter:filter - Security is currently disabled. Please note, this is intended for debug/development purposes only. This is not advised for production environements.
2025-Apr-11 13:12:40.651 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] ERROR PingServiceImpl:getpingInfo - Trace directory does not exist!
2025-Apr-11 13:12:40.652 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] ERROR PingService:ping - Server busy... Maximum pool size reached, no available connections!
2025-Apr-11 13:12:40.658 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] INFO LogFilter:filter - GET response from path v1/ping has been made
===================
My cmodtest.tmpl:
#OD Server Settings
odHost=192.168.40.102
odPort=1445
odUser=admin
odPassword={my-password}
odInstance=archive
transformXML=/opt/ibm/ondemand/V10.5/config/arsxform.xml
secureAPI=False
language=ENU
maxHits=100
tempDir=/tmp
traceDir=/tmp/traceDir
traceLevel=1
odInstallDir=
odCachedFolderList=
odEncryptionKey=
odSetKeyBeforeLogin=
mime-txt=text/plain
mime-pdf=application/pdf
# Pool
minIdlePerPool=3
maxIdlePerPool=10
maxTotalPerPool=10
maxTotal=40
maxWaitMillis=5000
#SSL Settings
USE_SSL=FALSE
SSL_KEYRINGFILE=
SSL_KEYRINGSTASH=
====
/opt/IBM/WebSphere/AppServer/profiles/AppSrv01/installedApps/{MyServer}Node01Cell/cmod-rest_war.ear/cmod-rest.war/WEB-INF/classes/poolConfig.properties :
#Connection Pool Settings
# minIdlePerPool:
#
# The target for the minimum number of idle connections to maintain in each of the Pooled sub-pools
# Also used when instantiating the number of server connections created at startup for a given pool
minIdlePerPool=3
# maxIdlePerPool:
#
# The cap on the number of "idle" server connections per Pool
maxIdlePerPool=10
# maxTotalPerPool:
#
# The limit on the number of connections allocated by the pool (checked out or idle), per Pool
maxTotalPerPool=10
# maxTotal:
#
# The cap on the total number of connections managed by the pool. Negative values mean that
# there is no limit to the number of connections allocated by the pool
maxTotal=100
# maxWaitMillis:
#
# The maximum amount of time (in milliseconds) the borrowObject() method should block before
# throwing an exception when the pool is exhausted and getBlockWhenExhausted() is true. When
# less than 0, the borrowObject() method may block indefinitely.
maxWaitMillis=5000
===
Related Files/Folders:
# pwd
/opt/ibm/ondemand/V10.5/restcfgdir
# find .
.
./keys
./keys/MyAccessID.ksf
./cmodtest.tmpl
./pools
./pools/odpool.conn
Can anyone found same issue?