Re: ListPage MySQL OutOfMemory
Re: ListPage MySQL OutOfMemory
- Subject: Re: ListPage MySQL OutOfMemory
- From: Johann Werner <email@hidden>
- Date: Thu, 10 May 2012 10:42:21 +0200
Your fetch is taking too long. What is the SQL that is sent to your db? How big is the resultset you are expecting? Perhaps your indexes are broken (you have indexes, don't you)?
jw
Am 10.05.2012 um 10:37 schrieb Ron X: ESs-Mac:~ user$ top
5340 java 94.2 01:40.99 42/1 1 370 393 487M+ 9124K 525M+
RuntimeException: Statement running too long
at er.extensions.eof.ERXEOAccessUtilities.logExpression(ERXEOAccessUtilities.java:1213)
at er.extensions.eof.ERXAdaptorChannelDelegate.adaptorChannelDidEvaluateExpression(ERXAdaptorChannelDelegate.java:81)
... skipped 5 stack elements
at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223)
at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:163)
... skipped 6 stack elements
at er.extensions.eof.ERXDatabaseContext._objectsWithFetchSpecificationEditingContext(ERXDatabaseContext.java:66)
... skipped 1 stack elements
at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1302)
... skipped 1 stack elements
at com.legalsounds.MainNavigationController.mostDownloadedAction(MainNavigationController.java:77)
... skipped 15 stack elements
at er.extensions.appserver.navigation.ERXNavigationMenuItem.menuItemSelected(ERXNavigationMenuItem.java:137)
... skipped 64 stack elements
at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:157)
at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235)
at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268)
at er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302)
at er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:374)
... skipped 6 stack elements
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden