Hi !
Any news on this ?
Thanks !
Olivier
2014-06-25 14:48 GMT+02:00 Rumi <rtsek...@openlinksw.com>:
> Hi Oliver,
>
>
> On 25-Jun-14 12:28 PM, Olivier Dalang wrote:
>
> Hi !
>
> I'm encountering a very strange error.
>
> I have a query which works well with two different FILTER clauses, but
> when I use both FILTER at the same time (simply combining them with AND), I
> get the following error :
>
> SQL error: [unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso
>> Server]SQ200: Stack Overflow in cost model, SQL state 37000 in SQLExecDirect
>
>
> You'll find the whole query below (as well as on
> http://pastebin.com/CuBQk0xX ). I've been asking on irc #swig, and they
> thought it may be a Virtuoso bug...
>
> Virtuoso version (I need the dev version because of that "No table
> rdf_obj" bug in stable) :
>
>> Virtuoso Open Source Edition (Column Store) (multi threaded)
>> Version 7.1.1-dev.3210-pthreads as of Jun 23 2014
>> Compiled for Linux (x86_64-unknown-linux-gnu)
>
>
> Is it indeed a bug ? Or am I doing something wrong ? Do you see a
> workaround ?
>
> Thanks a lot !
>
>
> I've been able to reproduce the issue and we are looking into the cause of
> the error.
> Will report back ..
>
>
> Best Regards,
> Rumi Kocis
>
>
> Olivier Dalang
> ---
> Digital Humanities Lab (DHLAB) - http://dhlab.epfl.ch
> EPFL CDH DHLAB / CM 2 271
> Station 10 / CH-1015 Lausanne
> Tel. +41 21 693 02 46 <%2B41%2021%20693%2002%2046>
>
>
>
>
>
> 1. ##### THE FOLLOWING QUERY GIVES ME THIS ERROR :
> 2. # Warning: odbc_exec(): SQL error: [unixODBC][OpenLink][Virtuoso
> iODBC Driver][Virtuoso Server]SQ200: Stack Overflow in cost model, SQL
> state 37000 in SQLExecDirect in
> /var/www/html/ontowiki-scripts/model_the_source-virtuoso_to_webmap.php on
> line 20
> 3.
> 4. ##### BUT IT WORKS IF I COMMENT OUT (in the FILTER clause)
> 5. # AND
> 6. # bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(<?=$xmin?>
> <?=$ymin?>, <?=$xmax?> <?=$ymax?>)") )
> 7.
> 8. ##### AND IT ALSO WORKS IF I COMMENT OUT (in the FILTER clause)
> 9. # ?min_zoom <= "<?=$zoom?>"^^xsd:integer
> 10. # AND
> 11. # ?max_zoom >= "<?=$zoom?>"^^xsd:integer
> 12. # AND
> 13.
> 14. ##### SO IT'S ONLY WHEN I COMBINE BOTH THAT I GET THE ERROR ?!?!
> 15.
> 16. PREFIX geo: <http://www.opengis.net/ont/geosparql#>
> 17. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
> 18. PREFIX : <http://dhlabpc2.epfl.ch/OntoWiki/vtm/#>
> 19.
> 20. SELECT *
> 21. FROM <http://dhlabpc2.epfl.ch/OntoWiki/vtm/>
> 22.
> 23. WHERE{
> 24. # select the entity
> 25. ?entity a ?class .
> 26.
> 27. # whose class is a subclass of :class_entity
> 28. ?class rdfs:subClassOf :class_entity .
> 29.
> 30. # get details for the subclass
> 31. ?class rdfs:label ?subclass_label .
> 32. ?class :zindex ?zindex .
> 33. ?class :min_zoom ?min_zoom .
> 34. ?class :max_zoom ?max_zoom .
> 35.
> 36. # that have a defined shape
> 37. ?entity :shape_defined_by ?geometry_defining_entity .
> 38. ?geometry_defining_entity geo:geometry ?geom .
> 39.
> 40. FILTER (
> 41. ?min_zoom <= 19
> 42. AND
> 43. ?max_zoom >= 19
> 44. AND
> 45. bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(12.3352
> 45.4382, 12.33521 45.43821)") )
> 46. )
> 47.
> 48. }
> 49. ORDER BY ?entity
> 50.
> 51. LIMIT 500
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awardshttp://p.sf.net/sfu/Bonitasoft
>
>
>
> _______________________________________________
> Virtuoso-users mailing
> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
