elasticsearch6.7.1数据源连接成功后，刷新不出数据列表
月球漫步
显示全部楼层
发表于 2021-7-9 15:57:30
我换了opendistro-sql-jdbc-1.13.0.0.jar的jdbc驱动，但是报[QUERY: [ErrCode: 0] Failed to list database schemas]
java.lang.NullPointerException: null
空指针异常 |
|
|
|
|
|
|
|
|
_贝贝
显示全部楼层
发表于 2021-7-9 15:58:01
|
|
|
|
|
|
|
|
月球漫步
显示全部楼层
发表于 2021-7-9 16:16:00
|
|
|
|
|
|
|
|
_贝贝
显示全部楼层
发表于 2021-7-9 16:21:58
|
|
|
|
|
|
|
|
月球漫步
显示全部楼层
发表于 2021-7-9 16:28:50
|
|
|
|
|
|
|
|
_贝贝
显示全部楼层
发表于 2021-7-9 16:36:14
|
|
|
|
|
|
|
|
月球漫步
显示全部楼层
发表于 2021-7-9 16:37:01
2021-07-09 16:37:00.073] |-[INFO] |-[38e5a1c7f650421bb55c5c214dbd6e3d] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:105)] |-[OTHER: Succeed to get connection, classloader: YH_ClassLoader_2.]
[2021-07-09 16:37:00.081] |-[INFO] |-[920bedea656c4056b63fa771ff271a05] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:105)] |-[OTHER: Succeed to get connection, classloader: YH_ClassLoader_2.]
[2021-07-09 16:37:00.081] |-[WARN] |-[453df5e19d134b6db34094e315699129] |-[admin] |-[g5.qry.jdbc.JDBCExecutor.schemas(JDBCExecutor.java:558)] |-[QUERY: [ErrCode: 0] Failed to list database schemas]
java.lang.NullPointerException: null
at g5.qry.jdbc.JDBCExecutor.addSchema(JDBCExecutor.java:907) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor.processSchema(JDBCExecutor.java:846) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor.schemas(JDBCExecutor.java:554) ~[product.jar:?]
at g5.qry.jdbc.JDBCQuery.schemas(JDBCQuery.java:699) ~[product.jar:?]
at g5.sv.qry.req.GetQryTablesReq.getSqlQryTables(GetQryTablesReq.java:476) ~[product.jar:?]
at g5.sv.qry.req.GetQryTablesReq.process0(GetQryTablesReq.java:124) ~[product.jar:?]
at g5.sv.Req.process(Req.java:41) ~[product.jar:?]
at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:175) ~[product.jar:?]
at g5.sv.qry.QueryProc.procReq(QueryProc.java:141) ~[product.jar:?]
at g5.sv.qry.QueryProc.service(QueryProc.java:61) ~[product.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:101) ~[product.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:492) ~[product.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[servlet-api-3.1.jar:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1400) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:760) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at g5.sv.XBackupFilter.doFilter(XBackupFilter.java:28) ~[product.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226) ~[websocket-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:536) ~[jetty-security-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1589) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1296) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1559) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1211) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.Server.handle(Server.java:500) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:386) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:560) [jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:378) [jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:268) [jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:367) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:782) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:914) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at java.lang.Thread.run(Thread.java:834) [?:?] |
|
|
|
|
|
|
|
|
月球漫步
显示全部楼层
发表于 2021-7-9 16:37:52
我如果使用API的方式进行连接es，但我无法查看es的索引数据，日志报错为：
[2021-07-09 16:30:32.948] |-[INFO] |-[7614022254274feb883808698bb14e1c] |-[admin] |-[g5.qry.elasticsearch.ElasticSearchRestExecutor.runESRestRunnable(ElasticSearchRestExecutor.java:436)] |-[QUERY: g5.qry.elasticsearch.ElasticSearchRestExecutor@5ee48a69 start to init, with params: {_MAX_ROWS_=2, _Get_Meta_=true, _CONN_TIME_OFFSET_=28800000}, by g5.qry.elasticsearch.ElasticSearchRestExecutor$EsRestRunnable@dc0d52d [ts=1625819432948, report=null, wts=0, cost=0, qryCost=0, grpCost=0, group=UNKNOWN, query=UNKNOWN, ready=true]]
[2021-07-09 16:30:32.962] |-[ERROR] |-[7614022254274feb883808698bb14e1c] |-[admin] |-[g5.qry.comp.DBLeafNode.getQuery0(DBLeafNode.java:255)] |-[QUERY: [ErrCode: 0] Received invalid response! Http Status Code: 405, {"error":"Incorrect HTTP method for uri [/_sql?format=json] and method [POST], allowed: [HEAD, GET, PUT, DELETE]","status":405}]
java.lang.RuntimeException: Received invalid response! Http Status Code: 405, {"error":"Incorrect HTTP method for uri [/_sql?format=json] and method [POST], allowed: [HEAD, GET, PUT, DELETE]","status":405}
at g5.qry.elasticsearch.ElasticSearchRestExecutor.getData(ElasticSearchRestExecutor.java:544) ~[product.jar:?]
at g5.qry.elasticsearch.ElasticSearchRestExecutor.metaCols(ElasticSearchRestExecutor.java:59) ~[product.jar:?]
at g5.qry.sql.SQLQuery.metaCols(SQLQuery.java:72) ~[product.jar:?]
at g5.qry.Query.metaFilterCols(Query.java:114) ~[product.jar:?]
at g5.qry.comp.DBLeafNode.getQuery0(DBLeafNode.java:252) ~[product.jar:?]
at g5.qry.comp.AbsLeafNode.getQuery1(AbsLeafNode.java:815) ~[product.jar:?]
at g5.qry.comp.AbsLeafNode.getQuery(AbsLeafNode.java:446) ~[product.jar:?]
at g5.sv.qry.QueryReq.getAsset(QueryReq.java:156) ~[product.jar:?]
at g5.sv.qry.QueryReq.getQuery(QueryReq.java:131) ~[product.jar:?]
at g5.sv.qry.req.PreviewQryReq.createQryFromTable(PreviewQryReq.java:323) ~[product.jar:?]
at g5.sv.qry.req.PreviewQryReq.access$000(PreviewQryReq.java:43) ~[product.jar:?]
at g5.sv.qry.req.PreviewQryReq$QueryProvider.initQuery(PreviewQryReq.java:438) ~[product.jar:?]
at g5.sv.qry.req.PreviewQryReq$QueryProvider.<init>(PreviewQryReq.java:382) ~[product.jar:?]
at g5.sv.qry.req.PreviewQryReq.process0(PreviewQryReq.java:85) ~[product.jar:?]
at g5.sv.Req.process(Req.java:41) ~[product.jar:?]
at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:175) ~[product.jar:?]
at g5.sv.qry.QueryProc.procReq(QueryProc.java:141) ~[product.jar:?]
at g5.sv.qry.QueryProc.service(QueryProc.java:61) ~[product.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:101) ~[product.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:492) ~[product.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[servlet-api-3.1.jar:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1400) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:760) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at g5.sv.XBackupFilter.doFilter(XBackupFilter.java:28) ~[product.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226) ~[websocket-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:536) ~[jetty-security-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1589) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1296) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485) ~[jetty-servlet-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1559) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1211) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.Server.handle(Server.java:500) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:386) ~[jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:560) [jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:378) [jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:268) [jetty-server-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:367) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:782) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:914) [jetty-util-9.4.21.v20190926.jar:9.4.21.v20190926]
at java.lang.Thread.run(Thread.java:834) [?:?] |
|
|
|
|
|
|
|
|
_贝贝
显示全部楼层
发表于 2021-7-9 16:38:27
|
|
|
|
|
|
|
|
月球漫步
显示全部楼层
发表于 2021-7-9 16:49:20
|
|
|
|
|
|
|
|
