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
