sort of solved: slow/blocked fetch, FrontBase?
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