[Developers] query timeouts

[brendan]

it's working on freebase right now.

http://tinyurl.com/btnmuf

I looked up your original request (by looking in our logs for the  
"transaction_id") and can see that a graph query timed out.   My  
recent attempt did incur about 2.5 seconds in the graph request (db  
timeout threshold is 8 sec.)

I have opened a bug, however, because, I am able to reproduce the  
timeout on sandbox as well as some of our test graphs. Someone will  
get back to you on this list to answer your question.

Brendan

On Mar 2, 2009, at 4:18 PM, augusto callejas wrote:

> hi-
>
> i'm getting a consistent query timeout.
> my query is for the /type/link history for /people/person nodes
> that have been added since a certain time (and whose target
> type's are from a certain set).
>
> is there anything i can do to avoid the query timeout?
> perhaps change the limit size when i cursor? will that
> reduce the amount of time spent on the query?
> or is query time based on other factors that are
> query independent, but data size dependent?
>
> thanks,
> augusto.
>
>
> ----
> {
>   "q":{
>     "code":"/api/status/error",
>     "messages":[
>       {
>         "info":{
>           "host":"graph04.p01.sjc1.metaweb.com",
>           "detail":[
>             "timed out"
>           ],
>           "timeout":8.0,
>           "port":8100
>         },
>         "message":"Query timeout",
>         "code":"/api/status/error/mql/timeout"
>       }
>     ]
>   },
>   "status":"200 OK",
>   "code":"/api/status/ok",
>   "transaction_id":"cache;cache01.p01.sjc1:8101;2009-03-03T00:10:14Z;
> 0046"
> }
> ====
> {
>   "q" : {
>     "cursor" : "eNqVkNtOwzAMhl-
> nE6lmO47jWAjxHtUuSsukirJOHSAeH491FUjjAktRvvicv3ufT9NsvT5FayZLALvmYKhJY5JEu_bQ2x0qsxYUrteARavacbQboU01DoeX09v0o9Dm-qEaTq3BNS8mG-_rymf7qdeKGNcEsfmuEFCrHTAACONe4Zd13nU_fD73RmAoASVjYJEYMKesIHkBhQsgafD-DL7oAhoXKItHIH8DE5Xga5TCqhdIeAWmIAmoFCxnYEHR4Gu7IzokwSKUgqqmzJkDEpGz0satee0Ndjd1Gv_Q6WM4GmbICP9W6KzHOrM5zpPfW58oXIri9lEKIOK-Ky3571tEUH_zF_Lkfys=",
>     "query" : [
>       {
>         "master_property" : null,
>         "operation" : null,
>         "sort" : "timestamp",
>         "source" : {
>           "guid" : null,
>           "type|=" : [
>             "/people/person"
>           ]
>         },
>         "target" : {
>           "guid" : null,
>           "id" : null,
>           "type" : [],
>           "type|=" : [
>             "/organization/organization",
>             "/organization/organization_membership",
>             "/tv/tv_actor",
>             "/tv/regular_tv_appearance",
>             "/tv/tv_program",
>             "/people/person",
>             "/film/actor",
>             "/film/performance",
>             "/film/film",
>             "/music/album",
>             "/music/artist",
>             "/music/musical_group",
>             "/music/group_membership",
>             "/music/group_member",
>             "/dining/restaurant",
>             "/people/marriage",
>             "/location/location",
>             "/religion/religion",
>             "/business/company",
>             "/type/type"
>           ]
>         },
>         "timestamp" : null,
>         "timestamp>=" : "2009-02-28T04:33:59.275Z",
>         "type" : "/type/link",
>         "valid" : null
>       }
>     ]
>   }
> }
> ----
> _______________________________________________
> Developers mailing list
> Developers at freebase.com
> http://lists.freebase.com/mailman/listinfo/developers

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freebase.com/pipermail/developers/attachments/20090303/4f10d825/attachment.htm