Re: [E] error creating connection pool

["Bauer, Margaret M (Peggy)" <ma...@verizon.com>]

Make sure the backend DB has enough connections.  DB connections total
should be the sum of all your datasurces maxActive connections plus a
couple for good luck.
To me, it appears DB is not permitting enough connections or your maxActive
in your datasource config is set to high.

<Resource
        name="DataSourceName"
        auth="Container"
        url="jdbc:mysql://<FQDN>:3306/xxxxxxxx"
        driverClassName="com.mysql.jdbc.Driver"
        password="XXXXXXXXX"
        username="user"
        type="javax.sql.DataSource"
        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
        testWhileIdle="true"
        testOnBorrow="true"
        testOnReturn="false"
        validationQuery="SELECT 1"
        validationInterval="30000"
      *  maxActive="10"*
        minIdle="10"
        maxWait="10000"
        initialSize="10"
        jmxEnabled="true"
/>


On Tue, Feb 13, 2018 at 9:20 AM, Bruce L. Riddle <
Bruce.L.Riddle@dartmouth.edu> wrote:

> We are running a CDC Application PHIN MS that uses Tomcat 8.5.11.
>
> As the application starts, we are getting a message that says
>
> 'error creating connection pool for dbid.'
>
>
> Our assumption is that the message is coming from TomCat.  Please,
>
> what does the message mean and how to we research a possible
>
> resolution?
>
>
> Thanks.
>
>
> A segment from the LOG:
>
>
> ocalhost-startStop-1|02/13|08:28:35|Processing folderMap:
> C:\PHINMS3.0/config/sender/foldermap.xml|
> localhost-startStop-1|02/13|08:28:35|Loading decryption keystore|
> localhost-startStop-1|02/13|08:28:35|=== Spawning queue 0 ============|
> Thread-6|02/13|08:28:35|Initializing requeue cachepath from
> C:\PHINMS3.0/\shared\requeueCache|
> Thread-6|02/13|08:28:35|Spawning multi database poller 1...|
> Thread-7|02/13|08:28:35|Connection established|
> Thread-7|02/13|08:28:35|Waiting for records ...|
> localhost-startStop-1|02/13|08:28:35|Error creating connection pool for
> dbid: NHSCR_DB|
> localhost-startStop-1|02/13|08:28:35||
>
> Bruce
>
>
>
> Bruce Riddle
> NHSCR / Dartmouth College
> Phone: 603-653-6620
> PO Box 186, Hanover NH 03755
>
> STATEMENT OF CONFIDENTIALITY: This email may contain
> privileged and confidential information and is intended for use only by the
> individual(s) to whom it is addressed.  You are hereby notified
> that any unauthorized distribution or copying of this
> transmission is prohibited. If you have received this message
> in error, please contact the sender immediately and
> delete this electronic message
> and any attachments from your system.
>
>


-- 
*Peggy Bauer*
CAO Production Support
214-770-1782