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 . > 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 21:30:31 WARN NodeValue :: Datatype format exception: "-2700000000-01-01T00:00:00Z"^^xsd:dateTime 21:30:32 WARN NodeValue :: Datatype format exception: "1778-1-10"^^xsd:date 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 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 > > >