• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: ListPage MySQL OutOfMemory
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: ListPage MySQL OutOfMemory


  • Subject: Re: ListPage MySQL OutOfMemory
  • From: Tim Worman <email@hidden>
  • Date: Thu, 10 May 2012 16:14:58 -0700

Ron:

Johann's suggestion was the best course of action. Review the SQL that the app is producing for the request in question. Post back to the list all of the exact queries this single request is executing.

Tim

On May 10, 2012, at 2:22 AM, Ron X <email@hidden> wrote:

> maybe i have troubles with rules?
>
> 2012/5/10 Johann Werner <email@hidden>
>
> Am 10.05.2012 um 10:44 schrieb Ron X:
>
>> 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:
>
> If the fetch takes nearly 17s instead of 0.8s there must be something wrong (or at least different). What is the exact SQL that is sent to the db, you should look at that, perhaps something in your model is wrong?
>
>
>>
>> 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
>>>
>>> 2012/5/10 Johann Werner <email@hidden>
>>> -Xms512m -Xmx1024m
>>>
>>>
>>
>>
>
>
> <rule.png> _______________________________________________
> 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


 _______________________________________________
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

References: 
 >ListPage MySQL OutOfMemory (From: Ron X <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Ramsey Gurley <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Ron X <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Johann Werner <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Ron X <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Johann Werner <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Ron X <email@hidden>)
 >Re: ListPage MySQL OutOfMemory (From: Johann Werner <email@hidden>)

  • Prev by Date: Re: Is WO has HTML5 features....!
  • Next by Date: Re: ListPage MySQL OutOfMemory
  • Previous by thread: Re: ListPage MySQL OutOfMemory
  • Next by thread: ERRest Contextual fields
  • Index(es):
    • Date
    • Thread