All day yesterday. Today from 3:29 to 3:35, 4:31, 4:37 (EDT). Its possible its transient and I jumped the gun a bit on crying fail -- I saw concerns (I think @lists.w3.org) about dbpedia bandwidth and crawlers a few weeks ago and just wanted to make sure I wasn't causing the deadlocks or otherwise hurting the endpoint.
I also see transaction errors when I subsequently query the /data/[article].ttl for the updates but I guess my reads are just contending with the updates and I need to wait / try again when I hit a lock / timeout. -- Joe Presbrey On Fri, Jun 11, 2010 at 4:25 PM, Hugh Williams <[email protected]> wrote: > Hi Joe, > > How frequent is frequently, as I have run the query about 20 times and not > hit any deadlocks running it against the dbpedia-live sparql endpoint ie > http://dbpedia-live.openlinksw.com/sparql ? > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 11 Jun 2010, at 20:50, Joe Presbrey wrote: > >> My goal is to stay up to date with graph updates on dbpedia-live. The >> query I'm using below deadlocks all too frequently. Hopefully there's >> something simply wrong with my query or maybe dc:modified needs an >> index? Thanks ahead for any help or suggestions. >> >> 40001 Error SR172: Transaction deadlocked >> >> SPARQL query: >> define input:default-graph-uri <http://dbpedia.org> PREFIX dc: >> <http://purl.org/dc/terms/> >> SELECT * WHERE { >> ?uri dc:modified ?mtime . >> FILTER ( ?mtime >= "2010-06-10T20:23:34Z"^^xsd:dateTime ) >> } >> ORDER BY ASC(?mtime) LIMIT 5000 >> >> -- >> Joe Presbrey >> >> ------------------------------------------------------------------------------ >> ThinkGeek and WIRED's GeekDad team up for the Ultimate >> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the >> lucky parental unit. See the prize list and enter to win: >> http://p.sf.net/sfu/thinkgeek-promo >> _______________________________________________ >> Dbpedia-discussion mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion > > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > Dbpedia-discussion mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion > ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
