[Semediawiki-user] smw {1.20.5, master}, virtuoso-master Error: Query refused - HTTP response code: 500

[stelios <ss...@gm...>]

Hello,

Manually loading rdf files that are produced from #ask inline queries to
virtuoso,
is working ok.
But when I try to load semantic data from mediawiki to virtuoso using
the SMW_refreshData.php maintenance script,
I get the following response:

$ php SMW_refreshData.php -v
Refreshing all semantic data in the
database!

---

 Some versions of PHP suffer from memory leaks in long-running
scripts.

 If your machine gets very slow after many pages (typically more
than

 1000) were refreshed, please abort with CTRL-C and resume this
script

 at the last processed page id using the parameter -s (use -v to
display

 page ids during refresh). Continue this until all pages were
refreshed.

---

Processing all IDs from 1 to last ID
...

(0) Processing ID 1
...

Unexpected non-MediaWiki exception encountered, of type
"SMWSparqlDatabaseError"

exception 'SMWSparqlDatabaseError' with message 'A SPARQL query error has
occurred

Query: PREFIX wiki: <
http://taiyou.c-gaia.gr/gaiapedia-master/index.php/%CE%95%CE%B9%CE%B4%CE%B9%CE%BA%CF%8C:URIResolver/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX owl: <http://www.w3.org/2002/07/owl#>

PREFIX swivt: <http://semantic-mediawiki.org/swivt/1.0#>

PREFIX property: <
http://taiyou.c-gaia.gr/gaiapedia-master/index.php/%CE%95%CE%B9%CE%B4%CE%B9%CE%BA%CF%8C:URIResolver/Property-3A>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
DELETE FROM <http://localhost:8890/sparql> { ?s ?p ?o } WHERE { ?s
swivt:masterPage wiki:GAIApedia . ?s ?p ?o
}
Error: Query
refused

Endpoint: http://localhost:8890/sparql/

HTTP response code:
500

' in
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/sparql/SMW_SparqlDatabase.php:592

Stack
trace:

#0
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/sparql/SMW_SparqlDatabaseVirtuoso.php(151):
SMWSparqlDatabase->throwSparqlErrors('http://localhos...', 'PREFIX wiki:
<h...')
#1
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/sparql/SMW_SparqlDatabaseVirtuoso.php(63):
SMWSparqlDatabaseVirtuoso->doUpdate('PREFIX wiki: <h...')
#2
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/sparql/SMW_SparqlDatabase.php(371):
SMWSparqlDatabaseVirtuoso->delete('?s ?p ?o', '?s swivt:master...', Array)
#3
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/storage/SMW_SparqlStore.php(355):
SMWSparqlDatabase->deleteContentByValue('swivt:masterPag...',
'wiki:GAIApedia', Array)
#4
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/storage/SMW_SparqlStore.php(151):
SMWSparqlStore->deleteSparqlData(Object(SMWExpNsResource))
#5
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/storage/SMW_Store.php(234):
SMWSparqlStore->doDataUpdate(Object(SMWSemanticData))

#6
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/SMW_ParseData.php(374):
SMWStore->updateData(Object(SMWSemanticData))

#7
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/jobs/SMW_UpdateJob.php(64):
SMWParseData::storeData(Object(ParserOutput), Object(Title), false)
#8
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3_SetupHandlers.php(445):
SMWUpdateJob->run()
#9
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3.php(404):
SMWSQLStore3SetupHandlers->refreshData(1, 1, false, false)
#10
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/includes/storage/SMW_SparqlStore.php(446):
SMWSQLStore3->refreshData(1, 1, false, false)
#11
/home/primeuser/public_html/gaiapedia-master/extensions/SemanticMediaWiki/maintenance/SMW_refreshData.php(147):
SMWSparqlStore->refreshData(1, 1, false, false)
#12 {main}

and the stack trace is shown twice.
For some reason the curl_errno call in SMWSparqlDatabaseVirtuoso::doUpdate
instead of 0, returns code 22

Similarly this error occurs in case a property [[masterPage::20| ]] is
declared
in a page.

Also executing the query from isql, results in error:
SQL> sparql DELETE FROM <http://localhost:8890/sparql> { ?s ?p ?o } WHERE {
?s swivt:masterPage wiki:GAIApedia . ?s ?p ?o };

*** Error 37000: [Virtuoso Driver][Virtuoso Server]SQ074: Line 1: SP030:
SPARQL compiler, line 1: Undefined namespace prefix at 'swivt' before
'wiki:GAIApedia'

Is the error related to the wrapper functions in SMW_SparqlDatabase.php?

Virtuoso definitions In LocalSettings are as follows:
$smwgDefaultStore = 'SMWSparqlStore';
# using Virtuoso as connector
$smwgSparqlDatabase = 'SMWSparqlDatabaseVirtuoso';
# location of query service
$smwgSparqlQueryEndpoint = 'http://localhost:8890/sparql/';
# location of update service
$smwgSparqlUpdateEndpoint = 'http://localhost:8890/sparql/';
# location of SPARQL over HTTP service
# optional value; leave as is in case of problems
$smwgSparqlDataEndpoint = '';
# name of default graph
$smwgSparqlDefaultGraph = 'http://localhost:8890/sparql';

thanks,
Stelios