get table meta error:Failed to fetch schema of t_metadata_history

最新推荐文章于 2023-12-13 19:33:29 发布
最新推荐文章于 2023-12-13 19:33:29 发布
阅读量2.4k 收藏
点赞数
分类专栏： 分布式日志收集 链路日志追踪 springcloud 文章标签： java 开发语言
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/poem_2010/article/details/124642491
版权

在使用SEATA做分布式事务的时候，出现以下问题：

2022-05-08 00:58:03.151 [http-nio-2638-exec-2] INFO  org.poem.controller.TMetadataController - TPlatformMetadataController -> saveOrUpdateMetadata {"currentVersion":"version-1","datasourceId":720452110768017408,"maxVersion":1,"metadataColumnVOS":[{"columnNameDelimited":"BIGINT","incrementalColumn":0,"introspectedTable":"xxl_job_user","javaProperty":"java.lang.Long","jdbcTypename":"BIGINT","length":19,"name":"id","nullable":0,"primaryKey":1,"scale":0,"type":"int8"},{"columnNameDelimited":"VARCHAR","incrementalColumn":0,"introspectedTable":"xxl_job_user","javaProperty":"java.lang.String","jdbcTypename":"VARCHAR","length":50,"name":"username","nullable":0,"primaryKey":0,"remarks":"账号","scale":0,"type":"varchar"},{"columnNameDelimited":"VARCHAR","incrementalColumn":0,"introspectedTable":"xxl_job_user","javaProperty":"java.lang.String","jdbcTypename":"VARCHAR","length":50,"name":"password","nullable":0,"primaryKey":0,"remarks":"密码","scale":0,"type":"varchar"},{"columnNameDelimited":"SMALLINT","incrementalColumn":0,"introspectedTable":"xxl_job_user","javaProperty":"java.lang.Short","jdbcTypename":"SMALLINT","length":5,"name":"role","nullable":0,"primaryKey":0,"remarks":"角色：0-普通用户、1-管理员","scale":0,"type":"int2"},{"columnNameDelimited":"VARCHAR","incrementalColumn":0,"introspectedTable":"xxl_job_user","javaProperty":"java.lang.String","jdbcTypename":"VARCHAR","length":255,"name":"permission","nullable":1,"primaryKey":0,"remarks":"权限：执行器ID列表，多个逗号分割","scale":0,"type":"varchar"}],"name":"xxl_job_user","orgCode":1,"schemaName":"xingyuan_db"}
2022-05-08 00:58:03.252 [http-nio-2638-exec-2] ERROR i.s.r.d.sql.struct.cache.AbstractTableMetaCache - get table meta error:Failed to fetch schema of t_metadata_history
java.sql.SQLException: Failed to fetch schema of t_metadata_history
	at io.seata.rm.datasource.sql.struct.cache.PostgresqlTableMetaCache.fetchSchema(PostgresqlTableMetaCache.java:67)
	at io.seata.rm.datasource.sql.struct.cache.AbstractTableMetaCache.lambda$getTableMeta$0(AbstractTableMetaCache.java:61)
	at com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2346)
	at java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1908)
	at com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2344)
	at com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2327)
	at com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108)
	at com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62)
	at io.seata.rm.datasource.sql.struct.cache.AbstractTableMetaCache.getTableMeta(AbstractTableMetaCache.java:59)
	at io.seata.rm.datasource.AbstractConnectionProxy.prepareStatement(AbstractConnectionProxy.java:116)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
	at jdk.internal.reflect.GeneratedMethodAccessor175.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:134)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy229.prepare(Unknown Source)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at jdk.internal.reflect.GeneratedMethodAccessor220.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.SqlExplainInterceptor.intercept(SqlExplainInterceptor.java:65)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy228.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at jdk.internal.reflect.GeneratedMethodAccessor219.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	at com.sun.proxy.$Proxy148.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:68)
	at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64)
	at com.sun.proxy.$Proxy160.insert(Unknown Source)
	at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.save(ServiceImpl.java:105)
	at org.poem.service.impl.TMetadataHistoryServiceImpl.saveDatasourceTableHistory(TMetadataHistoryServiceImpl.java:55)
	at org.poem.service.impl.TMetadataHistoryServiceImpl$$FastClassBySpringCGLIB$$18fad52c.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at org.poem.service.impl.TMetadataHistoryServiceImpl$$EnhancerBySpringCGLIB$$ce2c7b89.saveDatasourceTableHistory(<generated>)
	at org.poem.service.impl.TMetadataServiceImpl.saveOrUpdateMetadata(TMetadataServiceImpl.java:97)
	at org.poem.service.impl.TMetadataServiceImpl$$FastClassBySpringCGLIB$$ae3740ea.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at org.poem.service.impl.TMetadataServiceImpl$$EnhancerBySpringCGLIB$$42ec0583.saveOrUpdateMetadata(<generated>)
	at org.poem.controller.TMetadataController.saveOrUpdateMetadata(TMetadataController.java:156)
	at org.poem.controller.TMetadataController$$FastClassBySpringCGLIB$$abaf142a.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
	at org.poem.controller.TMetadataController$$EnhancerBySpringCGLIB$$9a393b5f.saveOrUpdateMetadata(<generated>)
	at jdk.internal.reflect.GeneratedMethodAccessor187.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.poem.log.core.TraceIdFilter.doFilter(TraceIdFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
	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)
Caused by: io.seata.common.exception.ShouldNeverHappenException: Could not found any index in the table: t_metadata_history
	at io.seata.rm.datasource.sql.struct.cache.PostgresqlTableMetaCache.resultSetMetaToSchema(PostgresqlTableMetaCache.java:172)
	at io.seata.rm.datasource.sql.struct.cache.PostgresqlTableMetaCache.fetchSchema(PostgresqlTableMetaCache.java:63)
	... 122 common frames omitted

提取的异常

022-05-08 00:58:03.254 [http-nio-2638-exec-2] ERROR org.poem.config.error.ErrMsgConfiguration - nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement.  Cause: io.seata.common.exception.ShouldNeverHappenException: [xid:192.168.223.1:8091:8061703412593431525]get tablemeta failed
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement.  Cause: io.seata.common.exception.ShouldNeverHappenException: [xid:192.168.223.1:8091:8061703412593431525]get tablemeta failed
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy148.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:68)
	at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64)
	at com.sun.proxy.$Proxy160.insert(Unknown Source)
	at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.save(ServiceImpl.java:105)
	at org.poem.service.impl.TMetadataHistoryServiceImpl.saveDatasourceTableHistory(TMetadataHistoryServiceImpl.java:55)
	at org.poem.service.impl.TMetadataHistoryServiceImpl$$FastClassBySpringCGLIB$$18fad52c.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at org.poem.service.impl.TMetadataHistoryServiceImpl$$EnhancerBySpringCGLIB$$ce2c7b89.saveDatasourceTableHistory(<generated>)
	at org.poem.service.impl.TMetadataServiceImpl.saveOrUpdateMetadata(TMetadataServiceImpl.java:97)
	at org.poem.service.impl.TMetadataServiceImpl$$FastClassBySpringCGLIB$$ae3740ea.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at org.poem.service.impl.TMetadataServiceImpl$$EnhancerBySpringCGLIB$$42ec0583.saveOrUpdateMetadata(<generated>)
	at org.poem.controller.TMetadataController.saveOrUpdateMetadata(TMetadataController.java:156)
	at org.poem.controller.TMetadataController$$FastClassBySpringCGLIB$$abaf142a.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
	at org.poem.controller.TMetadataController$$EnhancerBySpringCGLIB$$9a393b5f.saveOrUpdateMetadata(<generated>)
	at jdk.internal.reflect.GeneratedMethodAccessor187.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.poem.log.core.TraceIdFilter.doFilter(TraceIdFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
	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)
Caused by: org.apache.ibatis.executor.ExecutorException: Error preparing statement.  Cause: io.seata.common.exception.ShouldNeverHappenException: [xid:192.168.223.1:8091:8061703412593431525]get tablemeta failed
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:97)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
	at jdk.internal.reflect.GeneratedMethodAccessor175.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:134)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy229.prepare(Unknown Source)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at jdk.internal.reflect.GeneratedMethodAccessor220.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.SqlExplainInterceptor.intercept(SqlExplainInterceptor.java:65)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy228.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at jdk.internal.reflect.GeneratedMethodAccessor219.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 86 common frames omitted
Caused by: io.seata.common.exception.ShouldNeverHappenException: [xid:192.168.223.1:8091:8061703412593431525]get tablemeta failed
	at io.seata.rm.datasource.sql.struct.cache.AbstractTableMetaCache.getTableMeta(AbstractTableMetaCache.java:69)
	at io.seata.rm.datasource.AbstractConnectionProxy.prepareStatement(AbstractConnectionProxy.java:116)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
	... 111 common frames omitted

原因是:

cloud项目中使用了seata的分布式事务，其中数据表中没有主键

解决办法：

 

鲁尼的小宝贝
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
Android SDK Manager解决更新时的问题 ：Failed to fetch URL...
09-01
本文主要介绍解决安装使用SDK Manager更新时的问题：Failed to fetch URL...,这里提供了详细的资料及解决问题办法，有需要的小伙伴可以参考下
java.sql.SQLException: Failed to fetch schema of user_xxx_order 问题
xzj80927的博客
12-13 1305
运行spring cloud 的分布式事务时，报如下错误： i.s.r.d.s.s.c.AbstractTableMetaCache : get table meta error:Failed to fetch schema of user_course_order表 java.sql.SQLException: Failed to fetch schema of user_course_order表 原因： 项目中使用了seata的分布式事务，而其中user_course_order表中没有主键 解决
5.分布式事务管理-Seata
LB_bei的博客
08-21 199
由于@Transactional注解只能控制所在服务器A的事务，当方法中调用其他服务器B的方法，当A中该方法出错时，@Transactional只能回滚A中该方法中的SQL，而A调用B的方法中的SQL无法回滚。
Android SDK Manager解决更新时的问题 ：Failed to fetch URL…
01-20
Failed to fectch URl https://dl-ssl.google.com/android/repository/addons_list.xml, reason: Connection to https://dl-ssl.google.com refused        安装使用SDK Manager更新时出现问题 Failed to fetch URL  https://dl-ssl.google.com/android/repository/repository-6.xml, reason:  Connection to https://dl-ssl.google.co
seata 踩坑记录
流离岁月的博客
07-19 1669
seata 踩坑记录 1.seata1.4.2 版本 有个bug，客户端启动时候影响了spring security oauth2的bean初始化 原因：seata1.4.2中io.seata.spring.utilsProxyUtils#findTargetSpringClass中获取代理对象的方法targetSource.getTargetClass()引起的。 在1.4.1 之前，对于TargetSource这个对象， 认为就是静态对象，所以直接取的targetSource.getTargetCl
java.sql.SQLException: Failed to fetch schema of XXXX 问题
weixin_32524367的博客
11-30 3615
报错信息 i.s.r.d.s.s.c.AbstractTableMetaCache : get table meta error:Failed to fetch schema of XXXX表 java.sql.SQLException: Failed to fetch schema of XXXXX表 原因： cloud项目中使用了seata的分布式事务，其中xxx表中没有主键 解决办法： 给xxx表加一个主键ID就可以了 ...
Seata: get tablemeta failed
amadeus_liu2的博客
05-11 1609
一、看看报错的表是否真的存在 二、如果表存在，则需要看表是否加了主键，如果没有，加上主键
seata:get table meta failed, please check whether the table `table_name` exists
weixin_47341383的博客
04-24 1208
个人本次出现问题的原因没有在对应的字段信息上添加主键约束造成如上的错误信息，将主键信息添加后问题得以解决。(1) 、解决方法根据内容提示查看数据库中。信息是否添加，没有添加主键添加主键即可。（2)、如果表格已经存在，查看表格的。
Failed to fetch schema of `order`的解决办法
L1Ha1Y1的博客
09-19 3489
解决办法：只需要在Url里添加useInformationSchema=false 前： jdbc:mysql://localhost:3306/orders 后：jdbc:mysql://localhost:3306/orders?useInformationSchema=false 情景： 1.报错日志 2.在使用分布式事务seata的时候才会出现问题 3.去除注解之后数据库操作正常 百科 Connector/J 5.0.0以后的版本有一个名为useInformationSchema的数据库连接参数
sudo apt-get install ethereum遇到E: Failed to fetch http://ppa.launchpad.net/, Unable to fetch some等
01-08
在Ubuntu上搭建以太坊环境时，每次到sudo apt-get install ethereum这一步都会变得巨卡无比，并且经常遇到这个问题： ... Connection timed out...E: Failed to fetch http://ppa.launchpad.net/ethereum/ethereum/ubuntu
php提示Warning:mysql_fetch_array() expects的解决方法
10-25
主要介绍了php提示Warning:mysql_fetch_array() expects的解决方法,是一个比较典型的php程序错误排查案例,具有一定的参考借鉴价值,需要的朋友可以参考下
seata 使用oracle_seata 使用oracle数据库不同用户下的表 get tablemeta failed
weixin_39958138的博客
12-19 1455
I have searched the issues of this repository and believe that this is not a duplicate.Ⅰ. Issue Descriptionspringcloud项目。使用的是oracle数据库，连接配置的是A用户，通过A用户给B用户的表中插入数据时报错(A用户有访问B用户从权限)Ⅱ. Describe what happe...
mycat seata错误
最新发布
weixin_35433807的博客
12-13 388
jdbc连接的是mycat地址需要加上&useInformationSchema=false，否则报。
分布式的常见问题--数据库篇
cmh17712948365的博客
11-30 821
java.sql.SQLException: Failed to fetch schema of "sql'; @GlobalTransactional Duplicate entry 'xxx' for key 'PRIMARY';
Caused by: io.seata.common.exception.ShouldNeverHappenException: Could not found any index in the ta
hints'blog
10-18 3426
java.sql.SQLException: Failed to fetch schema of tablename Caused by: io.seata.common.exception.ShouldNeverHappenException: Could not found any index in the table: tablename io.seata.common.exception.ShouldNeverHappenException: [xid:10.2.30.38:30109:5676
【Seata】AT模式常见报错及解决
柒杯红酒
11-14 5493
seata 、RmTransactionException:Runtime、ShouldNeverHappenException、RmTransactionException:Response
java.sql.SQLException: Failed to fetch schema of LOG
weixin_50279139的博客
02-27 741
java.sql.SQLException: Failed to fetch schema of LOGjava.sql.SQLException: Failed to fetch schema of LOG解决方法 java.sql.SQLException: Failed to fetch schema of LOG 解决方法 这是由于表缺少主键，加上即可。
java.lang.NoClassDefFoundError: org/springframework/kafka/core/MicrometerProducerListener
poem_2010的博客
04-28 5220
在打架SpringBoot+SpringCloud的架构的时候，使用到了Spring-Kafka的包。 出现了以下的错误 Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.kafka.core.ProducerFactory]: Factory method 'kafkaProducerFactory' threw exception;
js fetch Error: TypeError: Failed to fetch
09-13
这个错误通常在 JavaScript 中使用 Fetch API 发起请求时出现。它指示请求无法成功获取数据，可能是由于网络连接问题、请求的资源不存在或服务器返回了错误状态码等原因。 要解决这个问题，你可以尝试以下几种方法： 1. 检查网络连接：确保你的设备已连接到互联网，并且网络连接正常。 2. 检查请求的 URL：确保你使用的 URL 是正确的，并且能够访问到请求的资源。可以在浏览器中尝试直接访问该 URL，看是否能够获取到数据。 3. 处理错误状态码：当服务器返回错误状态码时（如 404 Not Found、500 Internal Server Error 等），可以根据具体的状态码采取相应的处理方式，例如显示错误信息或尝试其他备用 URL。 4. 处理跨域请求：如果你的请求涉及跨域资源共享（CORS），需要确保服务器已正确配置 CORS，允许你的域名进行跨域请求。 5. 检查请求参数：确保你提供了正确的请求参数，并以正确的格式进行传递。 6. 检查请求头部信息：有些 API 需要特定的请求头部信息才能正常工作，你可以查阅相关文档确保请求头部信息正确配置。 通过以上方法检查和调试，应能解决大部分 Fetch API 报错问题。如果问题仍然存在，可以提供更多的错误信息和代码片段以便更详细地分析和帮助解决问题。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值