Hi Quentin,
There have been made updates pushed to the git virtuoso develop/7 branch today
in preparation for an official release update to stable/7, as listed at:
https://github.com/openlink/virtuoso-opensource/compare/d2117b6e08...b9fa391a5a
one of which was for transitive query crashes:
https://github.com/openlink/virtuoso-opensource/commit/f79e14dcdead7dfa1af6712f0b9f761a123d5a7b
Although note the DBpedia binary is from 26 Nov and this has not been updated
since last week ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 4 Dec 2013, at 00:09, Quentin <quent...@clearbluewater.com.au> wrote:
> Testing in my own environment just now, it crashed on that query but after
> applying last night's release to git/develop7, it survives and reports that
> same error.
>
> So it looks like DBPedia and git both received a patch that fixed this
> sometime in the last 16 hours.
>
>
> On 4 December 2013 09:53, Quentin <quent...@clearbluewater.com.au> wrote:
> Interesting, I get that too this morning but last night the server hung for a
> while and then reported that it was unavailable. Perhaps it was a
> coincidence.
>
> Thank you for the documentation link.
>
>
> On 3 December 2013 21:40, Hugh Williams <hwilli...@openlinksw.com> wrote:
> Hi Quentin,
>
> Your (crash) query gives the following error against my local instance (with
> the data loaded) and even against DBpedia:
>
> Virtuoso 37000 Error TR...: T_STEP argument refers to an index 2 of a column
> s that is not in T_IN list (T_DIRECTION is set to 1)
>
> SPARQL query:
> define sql:big-data-const 0
> #output-format:text/html
> define sql:signal-void-variables 1 define input:default-graph-uri
> <http://dbpedia.org> prefix : <http://example.org/ontology/test/>
> with <http://example.org/dataset/test/>
> SELECT
> *
> WHERE
> {
> {
> SELECT ?anchor ?s ?p ?o
> WHERE
> {
> ?anchor ?pred ?s .
> ?s ?p ?o .
> }
> }
> OPTION ( TRANSITIVE,
> t_distinct,
> t_in(?anchor),
> t_out(?s),
> t_min (0),
> t_max (3) ,
> t_no_cycles,
> t_step (?s) as ?link, t_step ('path_id') as ?path,
> t_step ('step_no') as ?dist ) .
> FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
> }
> ORDER BY ?dist
>
> Additional information on transitivity and the t_direction param can be found
> in the Virtuoso SQL documentation, which SPARQL makes use of, at:
>
>
> http://docs.openlinksw.com/virtuoso/transitivityinsQL.html#transitivityinsQL
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 3 Dec 2013, at 07:48, Quentin <quent...@clearbluewater.com.au> wrote:
>
>> Prematurely sent.
>>
>> The query that gets me 'almost' there is:
>> =========================
>> prefix : <http://example.org/ontology/test/>
>> with <http://example.org/dataset/test/>
>> SELECT
>> *
>> WHERE
>> {
>> {
>> SELECT ?anchor ?s ?p ?o
>> WHERE
>> {
>> ?anchor ?anchorPred ?s .
>> ?s ?p ?o .
>> }
>> }
>> OPTION ( TRANSITIVE,
>> t_distinct,
>> t_in(?anchor),
>> t_out(?s),
>> t_min (0),
>> t_max (3) ,
>> t_no_cycles,
>> t_step (?anchor) as ?link, t_step ('path_id') as ?path,
>> t_step ('step_no') as ?dist ) .
>> FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
>> }
>> ORDER BY ?dist
>> =========================
>>
>>
>> On 3 December 2013 18:47, Quentin <quent...@clearbluewater.com.au> wrote:
>>
>> Assuming some data as below:
>> ========================================
>> prefix : <http://example.org/ontology/test/>
>> with <http://example.org/dataset/test/>
>> insert
>> {
>> <http://example.org/data/test/DummyClass_1> a :DummyClass .
>> <http://example.org/data/test/DummyClass_1> :predA "Entity 1" .
>> <http://example.org/data/test/DummyClass_1> :objPred
>> <http://example.org/data/test/DummyClass_2> .
>> <http://example.org/data/test/DummyClass_2> a :DummyClass .
>> <http://example.org/data/test/DummyClass_2> :predA "Entity 2" .
>> <http://example.org/data/test/DummyClass_2> :objPred
>> <http://example.org/data/test/DummyClass_3> .
>> <http://example.org/data/test/DummyClass_3> a :DummyClass .
>> <http://example.org/data/test/DummyClass_3> :predA "Entity 3" .
>> <http://example.org/data/test/DummyClass_3> :objPred
>> <http://example.org/data/test/DummyClass_4> .
>> <http://example.org/data/test/DummyClass_4> a :DummyClass .
>> <http://example.org/data/test/DummyClass_4> :predA "Entity 4" .
>> <http://example.org/data/test/DummyClass_4> :objPred
>> <http://example.org/data/test/DummyClass_1> .
>> }
>> ========================================
>> I want to get some results back that include every triple from some anchor
>> point to a given depth. So, say I start with
>> <http://example.org/data/test/DummyClass_1> and use depth 2, I'd like to get
>> everything for DummyClass_1/DummyClass_2/DummyClass_3 but not DummyClass_4.
>>
>> I figure this might be possible with transitivity and the OPTION clause but
>> I can't seem to get more than about 90% to what I need.
>>
>>
>>
>>
>>
>>
>> Secondly, I got a DB crash doing this query with the below data:
>> ===================================================
>> prefix : <http://example.org/ontology/test/>
>> with <http://example.org/dataset/test/>
>> SELECT
>> *
>> WHERE
>> {
>> {
>> SELECT ?anchor ?s ?p ?o
>> WHERE
>> {
>> ?anchor ?pred ?s .
>> ?s ?p ?o .
>> }
>> }
>> OPTION ( TRANSITIVE,
>> t_distinct,
>> t_in(?anchor),
>> t_out(?s),
>> t_min (0),
>> t_max (3) ,
>> t_no_cycles,
>> t_step (?s) as ?link, t_step ('path_id') as ?path,
>> t_step ('step_no') as ?dist ) .
>> FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
>> }
>> ORDER BY ?dist
>> ===================================================
>> I'm pretty sure this is because I used ?s in the t_step parameter instead of
>> ?anchor but I'm not quite sure why this caused a crash.
>> This seems to occur on DBPedia also (sorry).
>>
>> --
>> Quentin | Clear Blue Water Pty Ltd
>> quent...@clearbluewater.com.au
>>
>>
>>
>> --
>> Quentin | Clear Blue Water Pty Ltd
>> quent...@clearbluewater.com.au
>> ------------------------------------------------------------------------------
>> Rapidly troubleshoot problems before they affect your business. Most IT
>> organizations don't have a clear picture of how application performance
>> affects their revenue. With AppDynamics, you get 100% visibility into your
>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
>> Pro!
>> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
>
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
>
>
>
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
> ------------------------------------------------------------------------------
> Sponsored by Intel(R) XDK
> Develop, test and display web and hybrid apps with a single code base.
> Download it for free now!
> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users