“error“:“Incorrect HTTP method for uri [/_sql?format=json] and method [POST], allowed: [PUT, DELETE,

快来打我* 2023-07-01 05:25 2阅读 0赞

今天公司采购华为云搜索es ，最高版本是7.1的，而官方都更新到7.4+了。然后我就用7.1的先试试兼容性。果然出现了问题。

在通过sql查询的时候，返回了错误，错误提示如下：

logback \[http-nio-5051-exec-9\] INFO  c.c.e.r.ElasticsearchTemplateImpl - \{"query":"SELECT \* FROM log\_index ORDER BY endTime\_UTC limit 5"\}  
\-----------\{"error":"Incorrect HTTP method for uri \[/\_sql?format=json\] and method \[POST\], allowed: \[PUT, DELETE, HEAD, GET\]","status":405\}  
java.lang.NullPointerException  
    at com.cjkj.es.repository.response.EsSqlUtils.esModelToJavaObject(EsSqlUtils.java:44)  
    at com.cjkj.es.repository.response.EsSqlUtils.query(EsSqlUtils.java:31)  
    at com.cjkj.es.repository.ElasticsearchTemplateImpl.queryBySQL(ElasticsearchTemplateImpl.java:454)  
    at com.cjkj.action.service.impl.ApiLogServiceImpl.selectById1(ApiLogServiceImpl.java:143)  
    at com.cjkj.action.service.impl.ApiLogServiceImpl$$FastClassBySpringCGLIB$$7a3b8193.invoke(<generated>)  
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)  
    at com.cjkj.action.service.impl.ApiLogServiceImpl$$EnhancerBySpringCGLIB$$3c5ffcde.selectById1(<generated>)  
    at com.cjkj.action.controller.ApiLogController.getById1(ApiLogController.java:81)  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
    at java.lang.reflect.Method.invoke(Method.java:498)  
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)  
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)  
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)  
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:891)  
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)  
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)  
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)  
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)  
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)  
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:866)  
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)  
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)  
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)  
    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:52)  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
    at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
    at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)  
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
    at com.alibaba.csp.sentinel.adapter.servlet.CommonFilter.doFilter(CommonFilter.java:89)  
    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:198)  
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)  
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)  
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)  
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)  
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)  
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)  
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)  
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)  
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)  
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)  
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)  
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)  
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)  
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
    at java.lang.Thread.run(Thread.java:748)

解决方案：es7.1不支持sql在线查，需要一个第三方的sql插件才行。所以解决办法就是使用第三方的sql插件，注意改插件不建议上生产，第二就是让华为升级es。当然可以自己部署一套es，自己选择版本了。