[ 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
