OnDemand Users Group

Support Forums => ODWEK, Java and REST APIs => Topic started by: Andreas Baaserud Hauge on February 01, 2024, 08:58:32 AM

Title: ODWek REST - response HTTP 408 - No availble connections to pool <poolname>
Post by: Andreas Baaserud Hauge on February 01, 2024, 08:58:32 AM
Hi,

In our ODWek REST api we are getting the following response: No availble connections to pool <poolname>

Request
HTTP request to /cmod-rest/v1/ping
Header includes key / pair

Response
HTTP 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.
Title: Re: ODWek REST - response HTTP 408 - No availble connections to pool <poolname>
Post by: Justin Derrick on February 01, 2024, 02:39:32 PM
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.
Title: Re: ODWek REST - response HTTP 408 - No availble connections to pool <poolname>
Post by: rjrussel on February 01, 2024, 04:22:30 PM
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.
Title: Re: ODWek REST - response HTTP 408 - No availble connections to pool <poolname>
Post by: Andreas Baaserud Hauge on February 12, 2024, 07:54:31 AM
 Hi, thanks for reply

Our problem was firewall related. ODWek REST not able to connect to CMOD Library Server.
Solved by opening in firewall
Title: Re: ODWek REST - response HTTP 408 - No availble connections to pool <poolname>
Post by: teera_aoo on April 11, 2025, 06:16:59 AM
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?