Bug in DataView
With the same split205.xml, I ran several smaller queries in the DataView, and it was fine.
Then I composed this three-path query:
It ran a while and then displayed an error. Right now it's "turning and turning and turning forever". I am not sure what it's doing, considering that the execution failed?
Voici le log de catalina.out
. Au début, tout allait bien.
18:07:56,843 INFO PathToSQLQuery:185 - SELECT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label='PubmedArticleSet' AND e2.source=n1.id AND e2.label='' AND e2.t
arget=n3.id AND n3.label='PubmedArticle'
18:07:56,843 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label='PubmedArticle' AND e2.source=n1.id
AND e2.label='' AND e2.target=n3.id AND n3.label='ArticleTitle' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id
18:07:56,843 INFO PathToSQLQuery:185 - SELECT n1.id as var, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.la
bel='PubmedArticle' AND e2.source=n1.id AND e2.label='' AND e2.target=n3.id AND n3.label='AuthorList' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id AND n5.label='Author' AND e6.so
urce=n5.id AND e6.label='' AND e6.target=n7.id AND n7.label='Name' AND e8.source=n7.id AND e8.label='' AND e8.target=n9.id
18:07:57,113 INFO DataViewServlet:48 - [{joinPredicate=outerjoin, contextPath=PubmedArticleSet$$PubmedArticle, rightVar=var1, type=XML, leftVar=var0}, {joinPredicate=join, contextPath=Pubm
edArticle$$ArticleTitle$$#val, rightVar=var3, type=XML, leftVar=var1}, {joinPredicate=outerjoin, contextPath=PubmedArticle$$AuthorList$$Author$$Name$$#val, rightVar=var4, type=XML, leftVar=
var1}]
18:07:57,113 INFO PathToSQLQuery:185 - SELECT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label='PubmedArticleSet' AND e2.source=n1.id AND e2.label='' AND e2.t
arget=n3.id AND n3.label='PubmedArticle'
18:07:57,113 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label='PubmedArticle' AND e2.source=n1.id
AND e2.label='' AND e2.target=n3.id AND n3.label='ArticleTitle' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id
18:07:57,113 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.l
abel='PubmedArticle' AND e2.source=n1.id AND e2.label='' AND e2.target=n3.id AND n3.label='AuthorList' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id AND n5.label='Author' AND e6.s
ource=n5.id AND e6.label='' AND e6.target=n7.id AND n7.label='Name' AND e8.source=n7.id AND e8.label='' AND e8.target=n9.id
18:08:04,197 INFO DataViewServlet:48 - [{joinPredicate=outerjoin, contextPath=PubmedArticleSet$$PubmedArticle, rightVar=var1, type=XML, leftVar=var0}, {joinPredicate=join, contextPath=Pubm
edArticle$$ArticleTitle$$#val, rightVar=var3, type=XML, leftVar=var1}, {joinPredicate=outerjoin, contextPath=PubmedArticle$$AuthorList$$Author$$Name$$#val, rightVar=var4, type=XML, leftVar=
var1}]
18:08:04,197 INFO PathToSQLQuery:185 - SELECT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label='PubmedArticleSet' AND e2.source=n1.id AND e2.label='' AND e2.t
arget=n3.id AND n3.label='PubmedArticle'
18:08:04,197 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label='PubmedArticle' AND e2.source=n1.id
AND e2.label='' AND e2.target=n3.id AND n3.label='ArticleTitle' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id
18:08:04,197 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.l
abel='PubmedArticle' AND e2.source=n1.id AND e2.label='' AND e2.target=n3.id AND n3.label='AuthorList' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id AND n5.label='Author' AND e6.s
ource=n5.id AND e6.label='' AND e6.target=n7.id AND n7.label='Name' AND e8.source=n7.id AND e8.label='' AND e8.target=n9.id
18:08:44,689 INFO DataViewServlet:48 - [{joinPredicate=outerjoin, contextPath=PubmedArticleSet$$PubmedArticle, rightVar=var1, type=XML, leftVar=var0}, {joinPredicate=join, contextPath=Pubm
edArticle$$ArticleTitle$$#val, rightVar=var3, type=XML, leftVar=var1}, {joinPredicate=outerjoin, contextPath=PubmedArticle$$AuthorList$$Author$$Name$$#val, rightVar=var4, type=XML, leftVar=
var1}]
18:08:44,689 INFO PathToSQLQuery:185 - SELECT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label='PubmedArticleSet' AND e2.source=n1.id AND e2.label='' AND e2.t
arget=n3.id AND n3.label='PubmedArticle'
18:08:44,689 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label='PubmedArticle' AND e2.source=n1.id
AND e2.label='' AND e2.target=n3.id AND n3.label='ArticleTitle' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id
18:08:44,689 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.l
abel='PubmedArticle' AND e2.source=n1.id AND e2.label='' AND e2.target=n3.id AND n3.label='AuthorList' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id AND n5.label='Author' AND e6.s
ource=n5.id AND e6.label='' AND e6.target=n7.id AND n7.label='Name' AND e8.source=n7.id AND e8.label='' AND e8.target=n9.id
18:09:08,080 INFO DataViewServlet:48 - [{joinPredicate=outerjoin, contextPath=PubmedArticleSet$$PubmedArticle, rightVar=var1, type=XML, leftVar=var0}, {joinPredicate=join, contextPath=Pubm
edArticle$$ArticleTitle$$#val, rightVar=var3, type=XML, leftVar=var1}, {joinPredicate=outerjoin, contextPath=PubmedArticle$$AuthorList$$Author$$Name$$#val, rightVar=var4, type=XML, leftVar=
var1}]
18:09:08,080 INFO PathToSQLQuery:185 - SELECT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label='PubmedArticleSet' AND e2.source=n1.id AND e2.label='' AND e2.t
arget=n3.id AND n3.label='PubmedArticle'
18:09:08,080 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label='PubmedArticle' AND e2.source=n1.id
AND e2.label='' AND e2.target=n3.id AND n3.label='ArticleTitle' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id
18:09:08,080 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.l
abel='PubmedArticle' AND e2.source=n1.id AND e2.label='' AND e2.target=n3.id AND n3.label='AuthorList' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id AND n5.label='Author' AND e6.s
ource=n5.id AND e6.label='' AND e6.target=n7.id AND n7.label='Name' AND e8.source=n7.id AND e8.label='' AND e8.target=n9.id
18:09:27,512 INFO DataViewServlet:48 - [{joinPredicate=outerjoin, contextPath=PubmedArticleSet$$PubmedArticle, rightVar=var1, type=XML, leftVar=var0}, {joinPredicate=join, contextPath=Pubm
edArticle$$ArticleTitle$$#val, rightVar=var3, type=XML, leftVar=var1}, {joinPredicate=outerjoin, contextPath=PubmedArticle$$AuthorList$$Author$$Name$$#val, rightVar=var4, type=XML, leftVar=
var1}]
18:09:27,512 INFO PathToSQLQuery:185 - SELECT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label='PubmedArticleSet' AND e2.source=n1.id AND e2.label='' AND e2.t
arget=n3.id AND n3.label='PubmedArticle'
18:09:27,512 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label='PubmedArticle' AND e2.source=n1.id
AND e2.label='' AND e2.target=n3.id AND n3.label='ArticleTitle' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id
18:09:27,512 INFO PathToSQLQuery:185 - SELECT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.label='PubmedArticle' AND e2.source=n1.id AND e2.label='' AND e2.target=n3.id AND n3.label='AuthorList' AND e4.source=n3.id AND e4.label='' AND e4.target=n5.id AND n5.label='Author' AND e6.source=n5.id AND e6.label='' AND e6.target=n7.id AND n7.label='Name' AND e8.source=n7.id AND e8.label='' AND e8.target=n9.id
18:09:44,875 ERROR ConnectionManagerCl:168 - Error executing statement WITH path0 AS ( SELECT DISTINCT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label = 'PubmedArticleSet' AND e2.source = n1.id AND e2.label = '' AND e2.target = n3.id AND n3.label = 'PubmedArticle' ), path1 AS ( SELECT DISTINCT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label = 'PubmedArticle' AND e2.source = n1.id AND e2.label = '' AND e2.target = n3.id AND n3.label = 'ArticleTitle' AND e4.source = n3.id AND e4.label = '' AND e4.target = n5.id ), path2 AS ( SELECT DISTINCT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.label = 'PubmedArticle' AND e2.source = n1.id AND e2.label = '' AND e2.target = n3.id AND n3.label = 'AuthorList' AND e4.source = n3.id AND e4.label = '' AND e4.target = n5.id AND n5.label = 'Author' AND e6.source = n5.id AND e6.label = '' AND e6.target = n7.id AND n7.label = 'Name' AND e8.source = n7.id AND e8.label = '' AND e8.target = n9.id ) SELECT DISTINCT p0.var0, p0.var1, p1.var3, p2.var4 FROM path0 p0 JOIN path1 p1 ON (p0.var1 = p1.var1) LEFT JOIN path2 p2 ON ( p0.var1 = p2.var1 AND p1.var1 = p2.var1 ) ORDER BY p1.var3, p2.var4; on db test_4, with :
java.lang.NullPointerException
at fr.inria.cedar.connectionstudio.webservices.connectionlens.sql.ConnectionManagerCl.executeStatement(ConnectionManagerCl.java:140)
at fr.inria.cedar.connectionstudio.webservices.connectionlens.DataViewServlet.doGet(DataViewServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at fr.inria.cedar.connectionstudio.webservices.connectionlens.util.AppCorsFilter.doFilter(AppCorsFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Any idea @x-SEbel ?
@nbarret @mmohanty have you seen this before?
The query itself:
WITH path0 AS ( SELECT DISTINCT n1.id as var0, n3.id as var1 FROM nodes n1, edges e2, nodes n3 WHERE n1.label = 'PubmedArticleSet' AND e2.source = n1.id AND e2.label = '' AND e2.target = n3.id AND n3.label = 'PubmedArticle' ),
path1 AS ( SELECT DISTINCT n1.id as var1, n5.normalabel as var3 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5 WHERE n1.label = 'PubmedArticle' AND e2.source = n1.id AND e2.label = '' AND e2.target = n3.id AND n3.label = 'ArticleTitle' AND e4.source = n3.id AND e4.label = '' AND e4.target = n5.id ),
path2 AS ( SELECT DISTINCT n1.id as var1, n9.normalabel as var4 FROM nodes n1, edges e2, nodes n3, edges e4, nodes n5, edges e6, nodes n7, edges e8, nodes n9 WHERE n1.label = 'PubmedArticle' AND e2.source = n1.id AND e2.label = '' AND e2.target = n3.id AND n3.label = 'AuthorList' AND e4.source = n3.id AND e4.label = '' AND e4.target = n5.id AND n5.label = 'Author' AND e6.source = n5.id AND e6.label = '' AND e6.target = n7.id AND n7.label = 'Name' AND e8.source = n7.id AND e8.label = '' AND e8.target = n9.id )
SELECT DISTINCT p0.var0, p0.var1, p1.var3, p2.var4
FROM path0 p0 JOIN path1 p1 ON (p0.var1 = p1.var1) LEFT JOIN path2 p2 ON ( p0.var1 = p2.var1 AND p1.var1 = p2.var1 )
ORDER BY p1.var3, p2.var4
is fine (Postgres does not complain).
Mon laptop semble "fumer furieusement" depuis cette erreur...
Est-ce qu'il y a un timeout pour des requêtes? Est-ce qu'il pourrait se manifester comme ça?