Hi Hugh, The source of the error was a truncated database file on my developer desktop due to disk quota and a problem between my office chair and my desk ;)
Regards, Jerven On 2017-02-06 20:58, Hugh Williams wrote: > Hi Jerven, > > Does the same error occur when the query is run against the /sparql > endpoint or isql ie not via the JDBC Driver ? > > Also, are you able to get the query “profile” or > “sparql_to_sql_text” for the query as detailed at: > > > https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery > > What version of Virtuoso is being used, is it a latest 07.20.3217 > build ? > > 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+ -- MAILSCANNER HAS DETECTED DEFINITE FRAUD IN THE WEBSITE AT > "PLUS.GOOGLE.COM". DO _NOT_ TRUST THIS WEBSITE: > http://plus.google.com/100570109519069333827/ [2] > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology > Providers > >> On 6 Feb 2017, at 16:08, Jerven Tjalling Bolleman >> <jerven.bolleman@sib.swiss> wrote: >> >> Dear Virtuoso users, >> >> I am getting an new error from virtuoso, during development of a new >> >> feature >> >> SPARQL execute failed:[SELECT (COUNT(?target) AS ?targets) { GRAPH >> <http://sparql.uniprot.org/uniprot>{?subject a >> <http://purl.uniprot.org/core/MRNA> . ?target a >> <http://biohackathon.org/resource/faldo#ExactPosition> . ?subject >> <http://purl.uniprot.org/core/author> ?target .}}] >> >> Exception:virtuoso.jdbc4.VirtuosoException: SQ156: Internal >> Optimized >> compiler error : sqlo table has no index in sqldf.c:3777. >> Please report the statement compiled. >> >> Regards, >> Jerven >> >> -- >> Jerven Tjalling Bolleman >> SIB | Swiss Institute of Bioinformatics >> CMU - 1, rue Michel Servet - 1211 Geneva 4 >> t: +41 22 379 58 85 - f: +41 22 379 58 58 >> Jerven.Bolleman@sib.swiss - http://www.sib.swiss >> >> > ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org [1]! http://sdm.link/slashdot >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > Links: > ------ > [1] http://slashdot.org > [2] http://plus.google.com/100570109519069333827/ > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Jerven Tjalling Bolleman SIB | Swiss Institute of Bioinformatics CMU - 1, rue Michel Servet - 1211 Geneva 4 t: +41 22 379 58 85 - f: +41 22 379 58 58 Jerven.Bolleman@sib.swiss - http://www.sib.swiss ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users