On 01/01/2022 22:04, Jean-Marc Vanel wrote:
Le sam. 1 janv. 2022 à 21:50, Andy Seaborne <a...@apache.org> a écrit :
On 01/01/2022 19:45, Jean-Marc Vanel wrote:
During TDB initialization, I get this warning :
WARN o.apache.jena.sparql.expr.NodeValue - Datatype format exception:
"4,77962"^^xsd:float
But I am unable to detect the incorrect triple , with this query :
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT * WHERE {
?S ?P "4,77962"^^xsd:float .
}
I also tried this:
SELECT * WHERE {
?S ?P ?O.
FILTER ( STR(?O) = "4,77962" )
Try
FILTER ( CONTAINS(STR(?O), "779") )
See result below.
}
This uses the latest jena Version 4.3.2 , with TDB 1 .
I suspect this bad data prevents geosparl queries from getting any
result.
Did it work in a previous version?
Yes, that's an old database that I kept using for maybe 3 years .
Which version?
Did you load the TDB database with 4.3.2?
No.
Does it work with TDB2?
Didn't try .
Does the original data have a comma in a float?
yes it had that; I tried to remove it but it seems that there is still some
bad data present.
It seems that my database is corrupted, the query does not terminate. And
alas I have non recent backup.
If I try to make a backup now it stops with the same error and stack as
below: *AtlasException: Unknown escape: \< *. Happily it produces a partial
dump .
cat test-andy.rq
SELECT * WHERE {
graph ?g {
?S ?P ?O.
FILTER ( CONTAINS(STR(?O), "779") )
}}
$JENA/bin/tdbquery --loc=TDB --query test-andy.rq
That's a lot of junk in the database.
You would have got thos emessages from your queries.
(or have corrupted the database since)
> org.apache.jena.atlas.AtlasException: Unknown escape: \<
at org.apache.jena.atlas.lib.EscapeStr.unescape(EscapeStr.java:249)
No idea.
21:30:31 WARN NodeValue :: Datatype format exception:
"-2700000000-01-01T00:00:00Z"^^xsd:dateTime
jena currently only handles "-2 billion"
21:30:32 WARN NodeValue :: Datatype format exception:
"1778-1-10"^^xsd:date
"1778-01-10"
21:30:32 WARN NodeValue :: Datatype format exception:
"1707-5-23"^^xsd:date
21:30:32 WARN NodeValue :: Datatype format exception:
"2013-6-23"^^xsd:date
21:30:32 WARN NodeValue :: Datatype format exception:
"-287"^^xsd:gYear
21:30:32 WARN NodeValue :: Datatype format exception:
"-371"^^xsd:gYear
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(5.71,None,None)"^^xsd:double
That's not an xsd:double
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(1427,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(6925,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(2012,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(1600,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(45,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(1212.8,None,None)"^^xsd:double
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(167,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(8.48,None,None)"^^xsd:double
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(69278,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(4029,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(1990,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(69730,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(45,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(475,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"1885-9-25"^^xsd:date
21:30:33 WARN NodeValue :: Datatype format exception:
"1810-5-10"^^xsd:date
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(2009,None,None)"^^xsd:integer
21:30:33 WARN NodeValue :: Datatype format exception:
"ParseResult(978,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(35,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(40,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(1933,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(2003,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(83,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"1957-8-30"^^xsd:date
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(15.69,None,None)"^^xsd:double
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(1322,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(4442,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(2012,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(1600,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(45,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(283.1,None,None)"^^xsd:double
21:30:34 WARN NodeValue :: Datatype format exception:
"ParseResult(163,None,None)"^^xsd:integer
21:30:34 WARN NodeValue :: Datatype format exception:
"1853-4-9"^^xsd:date
21:30:37 WARN NodeValue :: Datatype format exception:
"1837-1-29"^^xsd:date
21:30:37 WARN NodeValue :: Datatype format exception:
"1799-5-26"^^xsd:date
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(7.98,None,None)"^^xsd:double
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(38531,None,None)"^^xsd:integer
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(383,None,None)"^^xsd:integer
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(1990,None,None)"^^xsd:integer
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(38620,None,None)"^^xsd:integer
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(45,None,None)"^^xsd:integer
21:30:37 WARN NodeValue :: Datatype format exception:
"ParseResult(48,None,None)"^^xsd:integer
21:30:37 ERROR BindingTDB :: get1(?P)
*org.apache.jena.atlas.AtlasException: Unknown escape: \<*
at org.apache.jena.atlas.lib.EscapeStr.unescape(EscapeStr.java:249)
~[jena-base-4.3.2.jar:4.3.2]
at org.apache.jena.atlas.lib.EscapeStr.unescapeStr(EscapeStr.java:158)
~[jena-base-4.3.2.jar:4.3.2]
at org.apache.jena.atlas.lib.EscapeStr.unescapeStr(EscapeStr.java:154)
~[jena-base-4.3.2.jar:4.3.2]
at org.apache.jena.atlas.lib.StrUtils.unescapeString(StrUtils.java:285)
~[jena-base-4.3.2.jar:4.3.2]
at org.apache.jena.tdb.store.nodetable.NodecSSE.decode(NodecSSE.java:114)
~[jena-tdb-4.3.2.jar:4.3.2]
at org.apache.jena.tdb.lib.NodeLib.decode(NodeLib.java:118)
~[jena-tdb-4.3.2.jar:4.3.2]
at org.apache.jena.tdb.lib.NodeLib.fetchDecode(NodeLib.java:95)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableNative.readNodeFromTable(NodeTableNative.java:182)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableNative._retrieveNodeByNodeId(NodeTableNative.java:108)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableNative.getNodeForNodeId(NodeTableNative.java:67)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableCache._retrieveNodeByNodeId(NodeTableCache.java:128)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableCache.getNodeForNodeId(NodeTableCache.java:82)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableWrapper.getNodeForNodeId(NodeTableWrapper.java:49)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.tdb.store.nodetable.NodeTableInline.getNodeForNodeId(NodeTableInline.java:66)
~[jena-tdb-4.3.2.jar:4.3.2]
at org.apache.jena.tdb.solver.BindingTDB.get1(BindingTDB.java:126)
~[jena-tdb-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.engine.binding.BindingBase.get(BindingBase.java:111)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.engine.binding.BindingBuilder.addAll(BindingBuilder.java:155)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.engine.binding.BindingFactory.copy(BindingFactory.java:137)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.resultset.ResultSetMem.<init>(ResultSetMem.java:90)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.query.ResultSetFactory.makeRewindable(ResultSetFactory.java:312)
~[jena-arq-4.3.2.jar:4.3.2]
at org.apache.jena.query.ResultSet.rewindable(ResultSet.java:90)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.output$(ResultSetWriterText.java:132)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.output(ResultSetWriterText.java:120)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.output(ResultSetWriterText.java:116)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.write(ResultSetWriterText.java:59)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.riot.resultset.rw.ResultsWriter.write(ResultsWriter.java:161)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.riot.resultset.rw.ResultsWriter.write(ResultsWriter.java:131)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.util.QueryExecUtils.outputResultSet(QueryExecUtils.java:153)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.util.QueryExecUtils.doSelectQuery(QueryExecUtils.java:170)
~[jena-arq-4.3.2.jar:4.3.2]
at
org.apache.jena.sparql.util.QueryExecUtils.executeQuery(QueryExecUtils.java:101)
~[jena-arq-4.3.2.jar:4.3.2]
at arq.query.lambda$queryExec$0(query.java:237) ~[jena-cmds-4.3.2.jar:4.3.2]
at org.apache.jena.system.Txn.exec(Txn.java:77) [jena-arq-4.3.2.jar:4.3.2]
at org.apache.jena.system.Txn.executeRead(Txn.java:115)
[jena-arq-4.3.2.jar:4.3.2]
at arq.query.queryExec(query.java:234) [jena-cmds-4.3.2.jar:4.3.2]
at arq.query.exec(query.java:157) [jena-cmds-4.3.2.jar:4.3.2]
at org.apache.jena.cmd.CmdMain.mainMethod(CmdMain.java:92)
[jena-cmds-4.3.2.jar:4.3.2]
at org.apache.jena.cmd.CmdMain.mainRun(CmdMain.java:58)
[jena-cmds-4.3.2.jar:4.3.2]
at org.apache.jena.cmd.CmdMain.mainRun(CmdMain.java:45)
[jena-cmds-4.3.2.jar:4.3.2]
at tdb.tdbquery.main(tdbquery.java:33) [jena-cmds-4.3.2.jar:4.3.2]
Exception
java.lang.NullPointerException: check(?P, null): null node value
at
org.apache.jena.sparql.engine.binding.BindingBuilder.checkAdd(BindingBuilder.java:393)
at
org.apache.jena.sparql.engine.binding.BindingBuilder.add(BindingBuilder.java:145)
at
org.apache.jena.sparql.engine.binding.BindingBuilder.addAll(BindingBuilder.java:156)
at
org.apache.jena.sparql.engine.binding.BindingFactory.copy(BindingFactory.java:137)
at
org.apache.jena.sparql.resultset.ResultSetMem.<init>(ResultSetMem.java:90)
at
org.apache.jena.query.ResultSetFactory.makeRewindable(ResultSetFactory.java:312)
at org.apache.jena.query.ResultSet.rewindable(ResultSet.java:90)
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.output$(ResultSetWriterText.java:132)
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.output(ResultSetWriterText.java:120)
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.output(ResultSetWriterText.java:116)
at
org.apache.jena.riot.resultset.rw.ResultSetWriterText.write(ResultSetWriterText.java:59)
at
org.apache.jena.riot.resultset.rw.ResultsWriter.write(ResultsWriter.java:161)
at
org.apache.jena.riot.resultset.rw.ResultsWriter.write(ResultsWriter.java:131)
at
org.apache.jena.sparql.util.QueryExecUtils.outputResultSet(QueryExecUtils.java:153)
at
org.apache.jena.sparql.util.QueryExecUtils.doSelectQuery(QueryExecUtils.java:170)
at
org.apache.jena.sparql.util.QueryExecUtils.executeQuery(QueryExecUtils.java:101)
at arq.query.lambda$queryExec$0(query.java:237)
at org.apache.jena.system.Txn.exec(Txn.java:77)
at org.apache.jena.system.Txn.executeRead(Txn.java:115)
at arq.query.queryExec(query.java:234)
at arq.query.exec(query.java:157)
at org.apache.jena.cmd.CmdMain.mainMethod(CmdMain.java:92)
at org.apache.jena.cmd.CmdMain.mainRun(CmdMain.java:58)
at org.apache.jena.cmd.CmdMain.mainRun(CmdMain.java:45)
at tdb.tdbquery.main(tdbquery.java:33)
That was querying with Jena 4.3.2 ; same result with 4.0.0
Andy
Jean-Marc Vanel
<
http://semantic-forms.cc:1952/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me
+33 (0)6 89 16 29 52
Twitter: @jmvanel , @jmvanel_fr
