Re: ListPage MySQL OutOfMemory
Re: ListPage MySQL OutOfMemory
- Subject: Re: ListPage MySQL OutOfMemory
- From: Ramsey Gurley <email@hidden>
- Date: Thu, 10 May 2012 16:21:13 -0700
Looks like you're using the wrong assignment class and assigning a pageController as a string instead of an instance of a branch delegate.On May 10, 2012, at 1:55 AM, Ron X wrote: that was in debug mode.
in run-mode:
WARN 422.22 MB used/87.72 MB free [WorkerThread3] (ERXNSLogLog4jBridge.java:43) (ListSong) - <er.extensions.appserver.ERXComponentRequestHandler>: Exception occurred while handling request:
java.lang.ClassCastException: java.lang.String cannot be cast to er.directtoweb.delegates.ERDBranchDelegateInterface ERROR 426.75 MB used/83.18 MB free [WorkerThread3] (ERXApplication.java:1786) (ListSong) - Exception caught: java.lang.String cannot be cast to er.directtoweb.delegates.ERDBranchDelegateInterface
ClassCastException: java.lang.String cannot be cast to er.directtoweb.delegates.ERDBranchDelegateInterface at er.directtoweb.pages.ERD2WPage.pageController(ERD2WPage.java:1173) at er.directtoweb.components.buttons.ERDControllerButton.branchDelegate(ERDControllerButton.java:64)
at er.directtoweb.components.buttons.ERDControllerButton.branchChoices(ERDControllerButton.java:136) ... skipped 94 stack elements at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:190)
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 _ignoredPackages:: ( )
2012/5/10 Ron X <email@hidden>
i use Navicat to see the DB
so select * from Song was 0.8 sec.
but in code the same query:
ERROR 150.87 MB used/359.07 MB free [WorkerThread2] (ERXEOAccessUtilities.java:1213) Page: er.modern.look.pages.ERMODQueryEntitiesPage - Configuration: null - "Song"@116895853 _expression_ took 16567 ms:
2012/5/10 Johann Werner <email@hidden>
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