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 SQLExecDirectYou'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 <http://dhlab.epfl.ch/>EPFL CDH DHLAB / CM 2 271 Station 10 / CH-1015 Lausanne Tel. +41 21 693 02 46 <tel:%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 awards http://p.sf.net/sfu/Bonitasoft _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ 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
