Hi. On an older version of OFBiz (year and ½ old) I
received an error message that it ran out of DB connections. The errors kept
going until I restarted the ofbiz app. It seems like the connection pool was
having problems. The same error occurred again about ½ hour later. I tried looking through the mailing lists, but couldn’t
find a definitive answer. I’m hoping someone could point me in the right
direction. Perhaps there have been code updates that fix the problem, or
perhaps my config needs to be tweaked. It’s using PostgreSQL w/ JOTM. Over a week ago the
database was moved to it’s own server w/ x-over connection to OFBiz app
server. Today was the first time we received the out of connections error. Any guidance would be appreciated. Here is the first error message in the log: 1779574[ JotmFactory.java:99 :ERROR] JOTM is the
configured transaction manager but there was an error getting a database
Connection through JOTM for the localpostgres datasource. Please check your
configuration, class path, etc. java.lang.RuntimeException: No ManagedConnections Available! at
org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:646) at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:359) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:56) at
org.ofbiz.entity.transaction.JotmFactory.getConnection(JotmFactory.java:96) at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:103) at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:53) at
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) at
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:529) at
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:500) at
org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:90) at
org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:592) at
org.ofbiz.entity.GenericDelegator.findByPrimaryKeyCache(GenericDelegator.java:612) at
org.ofbiz.entity.GenericDelegator.findByPrimaryKeyCache(GenericDelegator.java:636) <the rest of trace is BSH, freemarker, etc.> Here is DB part of log when OFBiz first starts: 919 [ Jotm.java:98 :INFO ] JOTM started with
a local transaction factory which is not bound. 919 [ Jotm.java:109:INFO ] CAROL
initialization 1313 [ Log.java:302:INFO ] Starting
Jetty/4.2.18 1333 [ Log.java:302:INFO ] Started
org.mortbay.http.NCSARequestLog@165a3c2 1358 [ Log.java:302:INFO ] Checking Resource
aliases 1491 [ Log.java:302:INFO ] Started
WebApplicationContext[/catalog,Open For Business - Catalog] 1504 [ ContextFilter.java:291:INFO ]
[ContextFilter.init] Getting Entity Engine Delegator with delegator name
default 1532 [ GenericDelegator.java:140:INFO ] Creating new Delegator
with name "default". 2427 [ ModelReader.java:259:INFO ] FINISHED LOADING
ENTITIES - ALL FILES; #Entities=578 #ViewEntities=58 #Fields=5569
#Relationships=2562 2505 [ GenericDelegator.java:159:INFO ] Delegator
"default" initializing helper "localpostgres" for entity
group "org.ofbiz". 2525 [ GenericDelegator.java:178:INFO ] Doing database
check as requested in entityengine.xml with addMissing=true 2552 [ Jotm.java:98 :INFO ] JOTM started with
a local transaction factory which is not bound. 2553 [ Jotm.java:109:INFO ] CAROL
initialization 2727 [ DatabaseUtil.java:622:INFO ] Database Product
Name is PostgreSQL 2728 [ DatabaseUtil.java:623:INFO ] Database Product
Version is 7.4.8 2729 [ DatabaseUtil.java:631:INFO ] Database Driver
Name is PostgreSQL Native Driver 2730 [ DatabaseUtil.java:632:INFO ] Database Driver
Version is PostgreSQL 7.4.5 JDBC3 with SSL (build 216) 2730 [ DatabaseUtil.java:640:INFO ] Database
Setting/Support Information (those with a * should be true): 2731 [ DatabaseUtil.java:641:INFO ] - supports
transactions [true]* 2731 [ DatabaseUtil.java:642:INFO ] - isolation
None [false] 2732 [ DatabaseUtil.java:643:INFO ] - isolation
ReadCommitted [true] 2732 [ DatabaseUtil.java:644:INFO ] - isolation
ReadUncommitted[false] 2733 [ DatabaseUtil.java:645:INFO ] - isolation
RepeatableRead [false] 2733 [ DatabaseUtil.java:646:INFO ] - isolation
Serializable [true] 2734 [ DatabaseUtil.java:647:INFO ] - is case
sensitive [false] 2734 [ DatabaseUtil.java:648:INFO ] - stores
LowerCase [true] 2735 [ DatabaseUtil.java:649:INFO ] - stores
MixedCase [false] 2735 [ DatabaseUtil.java:650:INFO ] - stores UpperCase
[false] 2738 [ DatabaseUtil.java:651:INFO ] - max table name
length [63] 2739 [ DatabaseUtil.java:652:INFO ] - max column name
length [63] 2739 [ DatabaseUtil.java:653:INFO ] - max schema name
length [63] 2740 [ DatabaseUtil.java:654:INFO ] - concurrent
connections [8192] 2740 [ DatabaseUtil.java:655:INFO ] - concurrent
statements [1] 2741 [ DatabaseUtil.java:656:INFO ] - ANSI SQL92
Entry [true] 2741 [ DatabaseUtil.java:657:INFO ] - ANSI SQL92
Itermediate [false] 2742 [ DatabaseUtil.java:658:INFO ] - ANSI SQL92
Full [false] 2742 [ DatabaseUtil.java:659:INFO ] - ODBC SQL Grammar
Core [false] 2743 [ DatabaseUtil.java:660:INFO ] - ODBC SQL Grammar
Extended[false] 2743 [ DatabaseUtil.java:661:INFO ] - ODBC SQL Grammar
Minimum [true] 2744 [ DatabaseUtil.java:662:INFO ] - outer
joins [true]* 2744 [ DatabaseUtil.java:663:INFO ] - limited outer
joins [true] 2745 [ DatabaseUtil.java:664:INFO ] - full outer
joins [true] 2745 [ DatabaseUtil.java:665:INFO ] - group
by [true]* 2746 [ DatabaseUtil.java:666:INFO ] - group by not in
select [true] 2746 [ DatabaseUtil.java:667:INFO ] - column
aliasing [true] 2747 [ DatabaseUtil.java:668:INFO ] - order by not in
select [true] 2747 [ DatabaseUtil.java:670:INFO ] - alter table add
column [true]* 2748 [ DatabaseUtil.java:671:INFO ] - non-nullable
column [true]* 2748 [ DatabaseUtil.java:708:INFO ] Getting Table Info
>From Database 2815 [ DatabaseUtil.java:848:INFO ] Getting Column
Info From Database Thank you much! sterling _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Sterling, This may or may not be good news, but if I remember right there were some bugs in Minerva related to this that were fixed quite a while back. I don't remember the exact triggering conditions, but this is resolved in the newer code. -David On Feb 27, 2006, at 11:50 AM, Sterling Okura wrote: > Hi. On an older version of OFBiz (year and ½ old) I received an > error message that it ran out of DB connections. The errors kept > going until I restarted the ofbiz app. It seems like the > connection pool was having problems. The same error occurred > again about ½ hour later. > > > > I tried looking through the mailing lists, but couldn’t find a > definitive answer. I’m hoping someone could point me in the right > direction. Perhaps there have been code updates that fix the > problem, or perhaps my config needs to be tweaked. > > > > It’s using PostgreSQL w/ JOTM. Over a week ago the database was > moved to it’s own server w/ x-over connection to OFBiz app server. > Today was the first time we received the out of connections error. > > > > Any guidance would be appreciated. > > > > Here is the first error message in the log: > > 1779574[ JotmFactory.java:99 :ERROR] JOTM is the configured > transaction manager but there was an error getting a database > Connection through JOTM for the localpostgres datasource. Please > check your configuration, class path, etc. > > java.lang.RuntimeException: No ManagedConnections Available! > > at org.ofbiz.minerva.pool.ObjectPool.getObject > (ObjectPool.java:646) > > at > org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection > (XAPoolDataSource.java:359) > > at > org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection > (MinervaConnectionFactory.java:56) > > at org.ofbiz.entity.transaction.JotmFactory.getConnection > (JotmFactory.java:96) > > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection > (TransactionFactory.java:103) > > at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection > (ConnectionFactory.java:53) > > at org.ofbiz.entity.jdbc.SQLProcessor.getConnection > (SQLProcessor.java:259) > > at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > (SQLProcessor.java:346) > > at org.ofbiz.entity.datasource.GenericDAO.select > (GenericDAO.java:529) > > at org.ofbiz.entity.datasource.GenericDAO.select > (GenericDAO.java:500) > > at > org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey > (GenericHelperDAO.java:90) > > at org.ofbiz.entity.GenericDelegator.findByPrimaryKey > (GenericDelegator.java:592) > > at org.ofbiz.entity.GenericDelegator.findByPrimaryKeyCache > (GenericDelegator.java:612) > > at org.ofbiz.entity.GenericDelegator.findByPrimaryKeyCache > (GenericDelegator.java:636) > > <the rest of trace is BSH, freemarker, etc.> > > > > Here is DB part of log when OFBiz first starts: > > > > 919 [ Jotm.java:98 :INFO ] JOTM started with a local > transaction factory which is not bound. > > 919 [ Jotm.java:109:INFO ] CAROL initialization > > 1313 [ Log.java:302:INFO ] Starting Jetty/4.2.18 > > 1333 [ Log.java:302:INFO ] Started > org.mortbay.http.NCSARequestLog@165a3c2 > > 1358 [ Log.java:302:INFO ] Checking Resource aliases > > 1491 [ Log.java:302:INFO ] Started > WebApplicationContext[/catalog,Open For Business - Catalog] > > 1504 [ ContextFilter.java:291:INFO ] [ContextFilter.init] > Getting Entity Engine Delegator with delegator name default > > 1532 [ GenericDelegator.java:140:INFO ] Creating new Delegator > with name "default". > > 2427 [ ModelReader.java:259:INFO ] FINISHED LOADING ENTITIES > - ALL FILES; #Entities=578 #ViewEntities=58 #Fields=5569 > #Relationships=2562 > > 2505 [ GenericDelegator.java:159:INFO ] Delegator "default" > initializing helper "localpostgres" for entity group "org.ofbiz". > > 2525 [ GenericDelegator.java:178:INFO ] Doing database check as > requested in entityengine.xml with addMissing=true > > 2552 [ Jotm.java:98 :INFO ] JOTM started with a local > transaction factory which is not bound. > > 2553 [ Jotm.java:109:INFO ] CAROL initialization > > 2727 [ DatabaseUtil.java:622:INFO ] Database Product Name is > PostgreSQL > > 2728 [ DatabaseUtil.java:623:INFO ] Database Product Version > is 7.4.8 > > 2729 [ DatabaseUtil.java:631:INFO ] Database Driver Name is > PostgreSQL Native Driver > > 2730 [ DatabaseUtil.java:632:INFO ] Database Driver Version > is PostgreSQL 7.4.5 JDBC3 with SSL (build 216) > > 2730 [ DatabaseUtil.java:640:INFO ] Database Setting/Support > Information (those with a * should be true): > > 2731 [ DatabaseUtil.java:641:INFO ] - supports > transactions [true]* > > 2731 [ DatabaseUtil.java:642:INFO ] - isolation > None [false] > > 2732 [ DatabaseUtil.java:643:INFO ] - isolation > ReadCommitted [true] > > 2732 [ DatabaseUtil.java:644:INFO ] - isolation > ReadUncommitted[false] > > 2733 [ DatabaseUtil.java:645:INFO ] - isolation > RepeatableRead [false] > > 2733 [ DatabaseUtil.java:646:INFO ] - isolation > Serializable [true] > > 2734 [ DatabaseUtil.java:647:INFO ] - is case > sensitive [false] > > 2734 [ DatabaseUtil.java:648:INFO ] - stores > LowerCase [true] > > 2735 [ DatabaseUtil.java:649:INFO ] - stores > MixedCase [false] > > 2735 [ DatabaseUtil.java:650:INFO ] - stores > UpperCase [false] > > 2738 [ DatabaseUtil.java:651:INFO ] - max table name > length [63] > > 2739 [ DatabaseUtil.java:652:INFO ] - max column name > length [63] > > 2739 [ DatabaseUtil.java:653:INFO ] - max schema name > length [63] > > 2740 [ DatabaseUtil.java:654:INFO ] - concurrent > connections [8192] > > 2740 [ DatabaseUtil.java:655:INFO ] - concurrent > statements [1] > > 2741 [ DatabaseUtil.java:656:INFO ] - ANSI SQL92 > Entry [true] > > 2741 [ DatabaseUtil.java:657:INFO ] - ANSI SQL92 > Itermediate [false] > > 2742 [ DatabaseUtil.java:658:INFO ] - ANSI SQL92 > Full [false] > > 2742 [ DatabaseUtil.java:659:INFO ] - ODBC SQL Grammar > Core [false] > > 2743 [ DatabaseUtil.java:660:INFO ] - ODBC SQL Grammar > Extended[false] > > 2743 [ DatabaseUtil.java:661:INFO ] - ODBC SQL Grammar > Minimum [true] > > 2744 [ DatabaseUtil.java:662:INFO ] - outer > joins [true]* > > 2744 [ DatabaseUtil.java:663:INFO ] - limited outer > joins [true] > > 2745 [ DatabaseUtil.java:664:INFO ] - full outer > joins [true] > > 2745 [ DatabaseUtil.java:665:INFO ] - group > by [true]* > > 2746 [ DatabaseUtil.java:666:INFO ] - group by not in > select [true] > > 2746 [ DatabaseUtil.java:667:INFO ] - column > aliasing [true] > > 2747 [ DatabaseUtil.java:668:INFO ] - order by not in > select [true] > > 2747 [ DatabaseUtil.java:670:INFO ] - alter table add > column [true]* > > 2748 [ DatabaseUtil.java:671:INFO ] - non-nullable > column [true]* > > 2748 [ DatabaseUtil.java:708:INFO ] Getting Table Info >From > Database > > 2815 [ DatabaseUtil.java:848:INFO ] Getting Column Info From > Database > > > > Thank you much! > > sterling > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
David,
I appreciate the prompt reply. Eventually we want to upgrade this OFBiz instance to recent code. I'll go digging around the source archives for updates to entity components. Hopefully, we'll be able to start with just updating the Minerva code to buy us time for a full update. Thank you much sir! sterling -----Original Message----- From: David E. Jones [mailto:[hidden email]] Sent: Monday, February 27, 2006 11:57 AM To: OFBiz Users / Usage Discussion Subject: Re: [OFBiz] Users - No ManagedConnections Available Sterling, This may or may not be good news, but if I remember right there were some bugs in Minerva related to this that were fixed quite a while back. I don't remember the exact triggering conditions, but this is resolved in the newer code. -David On Feb 27, 2006, at 11:50 AM, Sterling Okura wrote: > Hi. On an older version of OFBiz (year and ½ old) I received an > error message that it ran out of DB connections. The errors kept > going until I restarted the ofbiz app. It seems like the > connection pool was having problems. The same error occurred > again about ½ hour later. > > > > I tried looking through the mailing lists, but couldnt find a > definitive answer. Im hoping someone could point me in the right > direction. Perhaps there have been code updates that fix the > problem, or perhaps my config needs to be tweaked. > > > > Its using PostgreSQL w/ JOTM. Over a week ago the database was > moved to its own server w/ x-over connection to OFBiz app server. > Today was the first time we received the out of connections error. > > > > Any guidance would be appreciated. > > > > Here is the first error message in the log: > > 1779574[ JotmFactory.java:99 :ERROR] JOTM is the configured > transaction manager but there was an error getting a database > Connection through JOTM for the localpostgres datasource. Please > check your configuration, class path, etc. > > java.lang.RuntimeException: No ManagedConnections Available! > > at org.ofbiz.minerva.pool.ObjectPool.getObject > (ObjectPool.java:646) > > at > org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection > (XAPoolDataSource.java:359) > > at > org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection > (MinervaConnectionFactory.java:56) > > at org.ofbiz.entity.transaction.JotmFactory.getConnection > (JotmFactory.java:96) > > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection > (TransactionFactory.java:103) > > at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection > (ConnectionFactory.java:53) > > at org.ofbiz.entity.jdbc.SQLProcessor.getConnection > (SQLProcessor.java:259) > > at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > (SQLProcessor.java:346) > > at org.ofbiz.entity.datasource.GenericDAO.select > (GenericDAO.java:529) > > at org.ofbiz.entity.datasource.GenericDAO.select > (GenericDAO.java:500) > > at > org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey > (GenericHelperDAO.java:90) > > at org.ofbiz.entity.GenericDelegator.findByPrimaryKey > (GenericDelegator.java:592) > > at org.ofbiz.entity.GenericDelegator.findByPrimaryKeyCache > (GenericDelegator.java:612) > > at org.ofbiz.entity.GenericDelegator.findByPrimaryKeyCache > (GenericDelegator.java:636) > > <the rest of trace is BSH, freemarker, etc.> > > > > Here is DB part of log when OFBiz first starts: > > > > 919 [ Jotm.java:98 :INFO ] JOTM started with a local > transaction factory which is not bound. > > 919 [ Jotm.java:109:INFO ] CAROL initialization > > 1313 [ Log.java:302:INFO ] Starting Jetty/4.2.18 > > 1333 [ Log.java:302:INFO ] Started > org.mortbay.http.NCSARequestLog@165a3c2 > > 1358 [ Log.java:302:INFO ] Checking Resource aliases > > 1491 [ Log.java:302:INFO ] Started > WebApplicationContext[/catalog,Open For Business - Catalog] > > 1504 [ ContextFilter.java:291:INFO ] [ContextFilter.init] > Getting Entity Engine Delegator with delegator name default > > 1532 [ GenericDelegator.java:140:INFO ] Creating new Delegator > with name "default". > > 2427 [ ModelReader.java:259:INFO ] FINISHED LOADING ENTITIES > - ALL FILES; #Entities=578 #ViewEntities=58 #Fields=5569 > #Relationships=2562 > > 2505 [ GenericDelegator.java:159:INFO ] Delegator "default" > initializing helper "localpostgres" for entity group "org.ofbiz". > > 2525 [ GenericDelegator.java:178:INFO ] Doing database check as > requested in entityengine.xml with addMissing=true > > 2552 [ Jotm.java:98 :INFO ] JOTM started with a local > transaction factory which is not bound. > > 2553 [ Jotm.java:109:INFO ] CAROL initialization > > 2727 [ DatabaseUtil.java:622:INFO ] Database Product Name is > PostgreSQL > > 2728 [ DatabaseUtil.java:623:INFO ] Database Product Version > is 7.4.8 > > 2729 [ DatabaseUtil.java:631:INFO ] Database Driver Name is > PostgreSQL Native Driver > > 2730 [ DatabaseUtil.java:632:INFO ] Database Driver Version > is PostgreSQL 7.4.5 JDBC3 with SSL (build 216) > > 2730 [ DatabaseUtil.java:640:INFO ] Database Setting/Support > Information (those with a * should be true): > > 2731 [ DatabaseUtil.java:641:INFO ] - supports > transactions [true]* > > 2731 [ DatabaseUtil.java:642:INFO ] - isolation > None [false] > > 2732 [ DatabaseUtil.java:643:INFO ] - isolation > ReadCommitted [true] > > 2732 [ DatabaseUtil.java:644:INFO ] - isolation > ReadUncommitted[false] > > 2733 [ DatabaseUtil.java:645:INFO ] - isolation > RepeatableRead [false] > > 2733 [ DatabaseUtil.java:646:INFO ] - isolation > Serializable [true] > > 2734 [ DatabaseUtil.java:647:INFO ] - is case > sensitive [false] > > 2734 [ DatabaseUtil.java:648:INFO ] - stores > LowerCase [true] > > 2735 [ DatabaseUtil.java:649:INFO ] - stores > MixedCase [false] > > 2735 [ DatabaseUtil.java:650:INFO ] - stores > UpperCase [false] > > 2738 [ DatabaseUtil.java:651:INFO ] - max table name > length [63] > > 2739 [ DatabaseUtil.java:652:INFO ] - max column name > length [63] > > 2739 [ DatabaseUtil.java:653:INFO ] - max schema name > length [63] > > 2740 [ DatabaseUtil.java:654:INFO ] - concurrent > connections [8192] > > 2740 [ DatabaseUtil.java:655:INFO ] - concurrent > statements [1] > > 2741 [ DatabaseUtil.java:656:INFO ] - ANSI SQL92 > Entry [true] > > 2741 [ DatabaseUtil.java:657:INFO ] - ANSI SQL92 > Itermediate [false] > > 2742 [ DatabaseUtil.java:658:INFO ] - ANSI SQL92 > Full [false] > > 2742 [ DatabaseUtil.java:659:INFO ] - ODBC SQL Grammar > Core [false] > > 2743 [ DatabaseUtil.java:660:INFO ] - ODBC SQL Grammar > Extended[false] > > 2743 [ DatabaseUtil.java:661:INFO ] - ODBC SQL Grammar > Minimum [true] > > 2744 [ DatabaseUtil.java:662:INFO ] - outer > joins [true]* > > 2744 [ DatabaseUtil.java:663:INFO ] - limited outer > joins [true] > > 2745 [ DatabaseUtil.java:664:INFO ] - full outer > joins [true] > > 2745 [ DatabaseUtil.java:665:INFO ] - group > by [true]* > > 2746 [ DatabaseUtil.java:666:INFO ] - group by not in > select [true] > > 2746 [ DatabaseUtil.java:667:INFO ] - column > aliasing [true] > > 2747 [ DatabaseUtil.java:668:INFO ] - order by not in > select [true] > > 2747 [ DatabaseUtil.java:670:INFO ] - alter table add > column [true]* > > 2748 [ DatabaseUtil.java:671:INFO ] - non-nullable > column [true]* > > 2748 [ DatabaseUtil.java:708:INFO ] Getting Table Info >From > Database > > 2815 [ DatabaseUtil.java:848:INFO ] Getting Column Info From > Database > > > > Thank you much! > > sterling > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Free forum by Nabble | Edit this page |