• 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
sort of solved: slow/blocked fetch, FrontBase?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

sort of solved: slow/blocked fetch, FrontBase?


  • Subject: sort of solved: slow/blocked fetch, FrontBase?
  • From: OC <email@hidden>
  • Date: Sun, 22 May 2016 18:04:30 +0200

It looks like a restart of FBExec did help. Quadruple weird: I thought as soon one connects successfully to a particular database, all the subsequent communication is managed by the separate FronBase processes (which I did restart multiple times without any gain), and FBExec has nothing to do with that, but well -- far as it works, I do not complain :)

All the best,
OC

On 22. 5. 2016, at 15:41, OC <email@hidden> wrote:

> Hello there,
>
> my application runs well up to one fetch; I have added these logs
>
> ===
> println "AAAAAAAAAA fetching ${self.simpleName} $fs..."
>            found=editingContext.objectsWithFetchSpecification(fs)
> println "... fetched $found.count objects: $found"
> ===
>
> and am getting this output:
>
> ===
> AAAAAAAAAA fetching DBRecord <class com.webobjects.eocontrol.EOFetchSpecification(entityName=DBRecord,
> qualifier=(uid < 100000),
> isDeep=true, usesDistinct=false,
> sortOrdering=null,
> hints=null,
> _prefetchingRelationshipKeyPaths = null)>...
> 15:16:34.921 DEBUG  === Begin Internal Transaction       //log:NSLog [main]
> 15:16:34.921 DEBUG  evaluateExpression: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT t0."C_CREATION_DATE", t0."C_CREATOR_ID", t0."C_DF_CONTENT_DATA", t0."C_IMPORT_ID", t0."C_UID" FROM "T_RECORD" t0 WHERE t0."C_UID" < 100000" withBindings: >       //log:NSLog [main]
> ===
>
> Now, the obvious reasons I have excluded:
>
> (a) this is by far not the first fetch; up to this point, a number of them was made (with different entities/tables) and they worked perfectly
> (b) if I copy/paste the SQL verbatim to FBManager, I get the result (which is an empty rowset, which is the proper result) in about 300 us
>
> Nevertheless, although (a) and (b) look like it is not possible, still, it _is_ blocked inside the communication with the server: if I go to FBManager and stop the database, the blocking ends and my application immediately reports
>
> ===
> 15:37:24.253 INFO  Database Exception occured: Database - SBERDAT2 - is not runningat com.frontbase.jdbc.FBJConnection.createConnection(Unknown Source)
> at com.frontbase.jdbc.FBJConnection.reconnect(Unknown Source)
> at com.frontbase.jdbc.FBJConnection.fbX(Unknown Source)
> at com.frontbase.jdbc.FBJConnection.execute(Unknown Source)
> ...
> ===
>
> I would be very grateful for any advice how to find and isolate the problem -- myself, I am outta ideas :(
>
> Thanks and all the best,
> OC
>
>
> _______________________________________________
> 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: 
 >slow/blocked fetch, FrontBase? (From: OC <email@hidden>)

  • Prev by Date: slow/blocked fetch, FrontBase?
  • Next by Date: Re: Modern Deployment presentation
  • Previous by thread: slow/blocked fetch, FrontBase?
  • Next by thread: WO VM Images?
  • Index(es):
    • Date
    • Thread