Some SPARQL queries throw a strange error, which I cannot get rid of (shown below), also it lets virtuoso "hang". When restarting virtuoso through windows service manager I receive an error and I have to kill it through the task manager, then delete transaction log to be able to start it again. What does this error mean? Any suggestion on how to fix it? I have attached ini and log file - though the log does not seem to have anything after virtuoso is started.
I have set a timeout of 600 seconds on the SQL server, which I suspect might timeout for some of my queries. I am running my SPARQL through RDF views/mappings. However, most of my SPARQL queries times out "nicely" after 10 minutes, not crashing virtuoso etc. *** Error S1T00: [Virtuoso Driver]CL066: Virtuoso Communications Link Failure (timeout) in lines 2-13 of Top-Level: #line 2 "(console)" sparql SELECT ?crop COUNT(*) as ?cnt FROM <http://172.25.11.87:8890/materialized_data/agriculture> WHERE { ?field agri:produces ?crop . ?field wgs:long ?long . ?field wgs:lat ?lat . FILTER(?long > 11 && ?long < 12 && ?lat > 55 && ?lat < 56) . } GROUP BY ?crop -- Best Regards Alex Bondo Andersen
virtuoso.ini
Description: Binary data
Thu Dec 12 2013
13:59:07 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
13:59:07 WikiV version 0.6 from OpenLink Software
13:59:07 Support functions for WikiV collaboration tool
13:59:07 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
13:59:07 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
13:59:07 MediaWiki version 0.1 from OpenLink Software
13:59:07 Support functions for MediaWiki collaboration tool
13:59:07 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
13:59:07 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
13:59:07 CreoleWiki version 0.1 from OpenLink Software
13:59:07 Support functions for CreoleWiki collaboration tool
13:59:07 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
13:59:07 { Loading plugin 4: Type `plain', file `im' in `../hosting'
13:59:07 IM version 0.6 from OpenLink Software
13:59:07 Support functions for Image Magick 6.6.7
13:59:07 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
13:59:08 OpenLink Virtuoso Universal Server
13:59:08 Version 07.00.3203-threads for Win64 as of Aug 3 2013
13:59:08 uses parts of OpenSSL, PCRE, Html Tidy
13:59:08 Database version 3126
13:59:08 SQL Optimizer enabled (max 1000 layouts)
13:59:09 Compiler unit is timed at 0.000174 msec
13:59:10 View 'Linked_data.agri_view.application' is owned by unknown user 'agri_view'
13:59:10 View 'Linked_data.agri_view.crop' is owned by unknown user 'agri_view'
13:59:11 View 'Linked_data.agri_view.field' is owned by unknown user 'agri_view'
13:59:11 View 'Linked_data.agri_view.field_fieldblock' is owned by unknown user 'agri_view'
13:59:12 View 'Linked_data.agri_view.field_organicfield' is owned by unknown user 'agri_view'
13:59:12 View 'Linked_data.agri_view.fieldblock' is owned by unknown user 'agri_view'
13:59:12 View 'Linked_data.agri_view.organicfield' is owned by unknown user 'agri_view'
13:59:12 View 'Linked_data.busi_view.activity' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.address' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.addressfeature' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.businessformat' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.company' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.municipality' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.participant' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.productionunit' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.temp.address' is owned by unknown user 'temp'
13:59:13 View 'Linked_data.temp.addressfeature' is owned by unknown user 'temp'
13:59:13 View 'Linked_data.agri_view.application' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.agri_view.crop' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.agri_view.field' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.agri_view.field_fieldblock' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.agri_view.field_organicfield' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.agri_view.fieldblock' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.agri_view.organicfield' is owned by unknown user 'agri_view'
13:59:13 View 'Linked_data.busi_view.activity' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.address' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.addressfeature' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.businessformat' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.company' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.municipality' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.participant' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.busi_view.productionunit' is owned by unknown user 'busi_view'
13:59:13 View 'Linked_data.temp.address' is owned by unknown user 'temp'
13:59:13 View 'Linked_data.temp.addressfeature' is owned by unknown user 'temp'
13:59:15 Error executing a server init statement : 42001: VEC..: id to iri vectored is not defined -- rdf_schema_ld ()
13:59:15 built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST" overruled by the RDBMS
13:59:15 built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH" overruled by the RDBMS
13:59:15 built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI" overruled by the RDBMS
13:59:15 built-in procedure "repl_undot_name" overruled by the RDBMS
13:59:15 Roll forward started
13:59:15 Roll forward complete
13:59:16 Checkpoint started
13:59:16 Checkpoint finished, log reused
13:59:17 HTTP/WebDAV server online at 8890
13:59:17 Server online at 1111 (pid 3620)
------------------------------------------------------------------------------ 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=84349831&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
