elasticsearch6.7.1数据源连接成功后，刷新不出数据列表

月球漫步 发表于 2021-7-9 16:49
试过了mongodb，是正常的

是同一个驱动吗，建议回复下私信直接电话沟通吧

永洪tech-zxx 发表于 2021-7-9 16:54
是同一个驱动吗，建议回复下私信直接电话沟通吧

https://club.yonghongtech.com/fo ... light=elasticsearch这个说8.8版本之后就支持用api来连接了，但是我用v9版本连接是显示不出数据的，日志提示如下：

[2021-07-09 16:58:30.465] |-[INFO] |-[44ba6766d9b44eadab33cd42d2446710] |-[admin] |-[g5.qry.elasticsearch.ElasticSearchRestExecutor.runESRestRunnable(ElasticSearchRestExecutor.java:436)] |-[QUERY:   g5.qry.elasticsearch.ElasticSearchRestExecutor@77ad27c1 start to init, with params: {_MAX_ROWS_=2, _Get_Meta_=true, _CONN_TIME_OFFSET_=28800000}, by g5.qry.elasticsearch.ElasticSearchRestExecutor$EsRestRunnable@5ea40dc3 [ts=1625821110465, report=null, wts=0, cost=0, qryCost=0, grpCost=0, group=UNKNOWN, query=UNKNOWN, ready=true]][2021-07-09 16:58:30.477] |-[ERROR] |-[44ba6766d9b44eadab33cd42d2446710] |-[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) [?:?]