[
http://jira.undersunconsulting.com/browse/OFBIZ-875?page=all ]
Jacopo Cappellato closed OFBIZ-875:
-----------------------------------
Resolution: Cannot Reproduce
> Intermittent No Database Connection issues
> ------------------------------------------
>
> Key: OFBIZ-875
> URL:
http://jira.undersunconsulting.com/browse/OFBIZ-875> Project: [OFBiz] Open For Business
> Type: Bug
> Versions: SVN
> Environment: Linux RedHat 4 using MySQL 4.1.16 Standard
> Reporter: Lisa Rawley
> Assignee: Jira Administrator
> Priority: Critical
>
>
> I upgraded from 2.0 Ofbiz to what looked like 3.3 at the time. This was around 11/30/2005. I've looked at our previous logs and have discovered that the problem has existed for a while, but gone unnoticed until now. Now, it is a show stopper.
> My development server has 2GB of memory, but because our production server has 1GB, I've configured things quite small. The data is pretty small with only 265 products. So, our memory is 384MB for heap and for the mysql database.
> Both the application and database server run on the same box. The database seems unbothered and very responsive when the application server becomes slow. Memory is not indicative of this slowness (remember I have another 1GB free). The slowness occurs when in the logs there are "No Database connection" errors. A restart of ofbiz fixes this issue.
> The server is fine for a while and then it craps out again and those connectivity issues crop up again. Once restarted, all is well. The database server never needs a restart and it can be connected to remotely and performs queries fine during this slowness. The suspect is Ofbiz's application server underneath.
> I have verified that I have the latest MySQL connector. When this issue occurs, it often doesn't store the user login in the history table or a server hit. Sometimes it is more critical on not being able to retrieve our data.
> I don't know what causes this and if anyone else has had these issues. I don't know if this is a database connection pooling issue or even where this configuration is. I can't be resetting servers every 8 hours. Please help me figure this out.
> Lisa
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.undersunconsulting.com/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
