slow/blocked fetch, FrontBase?
slow/blocked fetch, FrontBase?
- Subject: slow/blocked fetch, FrontBase?
- From: OC <email@hidden>
- Date: Sun, 22 May 2016 15:41:25 +0200
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