why not shut down ofbiz
Locked
 
|
when the DB is not able to be connected to?
[ DatabaseUtil.java:1059:ERROR] Unable to establish a connection with the database... Error was:java.sql.SQLException: Unable to acquire a new connection from the pool is there a reason not to shut down ofbiz at this point? -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator. |
|
|
If that error shows up a few times and goes away then it just means the server is busy (or that you haven't configured a big enough connection pool to handle the HTTP request thread pool size). If that error shows up for all requests and no user can get in, then it probably means your connection pool is full of stale connections. You can look at the connection list for your database to verify this. This shouldn't happen much in newer versions of OFBiz using DBCP, and was more of a problem with the old Minerva stuff. -David On Jun 28, 2009, at 9:22 AM, BJ Freeman wrote: > when the DB is not able to be connected to? > [ DatabaseUtil.java:1059:ERROR] Unable to establish a connection with > the database... Error was:java.sql.SQLException: Unable to acquire a > new > connection from the pool > > > is there a reason not to shut down ofbiz at this point? > > > -- > BJ Freeman > http://www.businessesnetwork.com/automation > http://bjfreeman.elance.com > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > Systems Integrator. > |
|
|
In reply to this post by BJ Freeman
this is 9.04 and is because it can not connect to the postmaster of
postresql sorry I was not clear enough. But I can see from your comments this would not be the appropriate place to shut down ofbiz. David E Jones sent the following on 6/28/2009 8:41 AM: > > If that error shows up a few times and goes away then it just means the > server is busy (or that you haven't configured a big enough connection > pool to handle the HTTP request thread pool size). > > If that error shows up for all requests and no user can get in, then it > probably means your connection pool is full of stale connections. You > can look at the connection list for your database to verify this. This > shouldn't happen much in newer versions of OFBiz using DBCP, and was > more of a problem with the old Minerva stuff. > > -David > > > On Jun 28, 2009, at 9:22 AM, BJ Freeman wrote: > >> when the DB is not able to be connected to? >> [ DatabaseUtil.java:1059:ERROR] Unable to establish a connection with >> the database... Error was:java.sql.SQLException: Unable to acquire a new >> connection from the pool >> >> >> is there a reason not to shut down ofbiz at this point? >> >> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> >> Systems Integrator. >> > > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator. |
|
|
Well, no, it might be a good reason to shut it down, but you still don't have enough details to say for sure. If it can't connect at all on startup there are 2 likely reasons: 1. the database is not running or there is a firewall or other network issue preventing access 2. the database setup in OFBiz is incorrect If the problem is #1 then shutting down OFBiz won't do any good, unless you want to keep people from accessing the site while you fix it. If the problem is #2 then you absolutely need to shut down and restart OFBiz after making the configuration corrections. -David On Jun 28, 2009, at 9:54 AM, BJ Freeman wrote: > this is 9.04 and is because it can not connect to the postmaster of > postresql > sorry I was not clear enough. > But I can see from your comments this would not be the appropriate > place > to shut down ofbiz. > > > > David E Jones sent the following on 6/28/2009 8:41 AM: >> >> If that error shows up a few times and goes away then it just means >> the >> server is busy (or that you haven't configured a big enough >> connection >> pool to handle the HTTP request thread pool size). >> >> If that error shows up for all requests and no user can get in, >> then it >> probably means your connection pool is full of stale connections. You >> can look at the connection list for your database to verify this. >> This >> shouldn't happen much in newer versions of OFBiz using DBCP, and was >> more of a problem with the old Minerva stuff. >> >> -David >> >> >> On Jun 28, 2009, at 9:22 AM, BJ Freeman wrote: >> >>> when the DB is not able to be connected to? >>> [ DatabaseUtil.java:1059:ERROR] Unable to establish a connection >>> with >>> the database... Error was:java.sql.SQLException: Unable to acquire >>> a new >>> connection from the pool >>> >>> >>> is there a reason not to shut down ofbiz at this point? >>> >>> >>> -- >>> BJ Freeman >>> http://www.businessesnetwork.com/automation >>> http://bjfreeman.elance.com >>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>> >>> Systems Integrator. >>> >> >> > > -- > BJ Freeman > http://www.businessesnetwork.com/automation > http://bjfreeman.elance.com > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > Systems Integrator. > |
|
|
In reply to this post by BJ Freeman
My thought was that if ofbiz can not connect permanently there is no
reason to have ofbiz running. users will get all sorts of errors starting at login. so just have ofbiz shut down. That way the ajp will give the 503 error. David E Jones sent the following on 6/28/2009 9:00 AM: > > Well, no, it might be a good reason to shut it down, but you still don't > have enough details to say for sure. If it can't connect at all on > startup there are 2 likely reasons: > > 1. the database is not running or there is a firewall or other network > issue preventing access > 2. the database setup in OFBiz is incorrect > > If the problem is #1 then shutting down OFBiz won't do any good, unless > you want to keep people from accessing the site while you fix it. > > If the problem is #2 then you absolutely need to shut down and restart > OFBiz after making the configuration corrections. > > -David > > > On Jun 28, 2009, at 9:54 AM, BJ Freeman wrote: > >> this is 9.04 and is because it can not connect to the postmaster of >> postresql >> sorry I was not clear enough. >> But I can see from your comments this would not be the appropriate place >> to shut down ofbiz. >> >> >> >> David E Jones sent the following on 6/28/2009 8:41 AM: >>> >>> If that error shows up a few times and goes away then it just means the >>> server is busy (or that you haven't configured a big enough connection >>> pool to handle the HTTP request thread pool size). >>> >>> If that error shows up for all requests and no user can get in, then it >>> probably means your connection pool is full of stale connections. You >>> can look at the connection list for your database to verify this. This >>> shouldn't happen much in newer versions of OFBiz using DBCP, and was >>> more of a problem with the old Minerva stuff. >>> >>> -David >>> >>> >>> On Jun 28, 2009, at 9:22 AM, BJ Freeman wrote: >>> >>>> when the DB is not able to be connected to? >>>> [ DatabaseUtil.java:1059:ERROR] Unable to establish a connection with >>>> the database... Error was:java.sql.SQLException: Unable to acquire a >>>> new >>>> connection from the pool >>>> >>>> >>>> is there a reason not to shut down ofbiz at this point? >>>> >>>> >>>> -- >>>> BJ Freeman >>>> http://www.businessesnetwork.com/automation >>>> http://bjfreeman.elance.com >>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>>> >>>> >>>> Systems Integrator. >>>> >>> >>> >> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> >> Systems Integrator. >> > > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |