error creating connection pool

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

error creating connection pool

Bruce L. Riddle
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.

Reply | Threaded
Open this post in threaded view
|

Re: [E] error creating connection pool

Bauer, Margaret M (Peggy)
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 <
[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: error creating connection pool

Felix Schumacher
In reply to this post by Bruce L. Riddle


Am 13. Februar 2018 15:20:00 MEZ schrieb "Bruce L. Riddle" <[hidden email]>:

>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?

Have you looked in other log files for error messages? I can only guess some possible misinformed from the given one (which I believe is a message generated by the app and not tomcat)

Check that
 * you have configured a database resource
 * the DB resource has the correct name (equal to the one configured in your app)
 * you have placed the db driver jar in a directory the app or rather tomcat expects it

Regards,
Felix

>
>
>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.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]