分布式数据库问题

2018-11-28 03:14:00 -3495319797 [kfScheduler-1] ERROR - Unexpected error occurred in scheduled task. org.springframework.jdbc.UncategorizedSQLException: Exception From Host:[172.16.171.37] ### Error updating database. Cause: java.sql.SQLException: [df016b538800000-3][10.80.110.13:3306][kingfarm_cms]ERR-CODE: [TDDL-4614][ERR_EXECUTE_ON_MYSQL] Error occurs when execute on GROUP 'KINGFARM_CMS_1514128361451ZDQFKINGFARM_CMS_VJRR_0000_RDS' ATOM 'rm-bp1g56gamgkya2134_kingfarm_cms_vjrr_0000_fcxr': Table 'kf_consultation' was locked with a READ lock and can't be updated More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4614] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: update kf_consultation set apply_status = 4 where status = 0 and apply_status = 3 and start_time < now() ### Cause: java.sql.SQLException: [df016b538800000-3][10.80.110.13:3306][kingfarm_cms]ERR-CODE: [TDDL-4614][ERR_EXECUTE_ON_MYSQL] Error occurs when execute on GROUP 'KINGFARM_CMS_1514128361451ZDQFKINGFARM_CMS_VJRR_0000_RDS' ATOM 'rm-bp1g56gamgkya2134_kingfarm_cms_vjrr_0000_fcxr': Table 'kf_consultation' was locked with a READ lock and can't be updated More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4614] ; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1099]; [df016b538800000-3][10.80.110.13:3306][kingfarm_cms]ERR-CODE: [TDDL-4614][ERR_EXECUTE_ON_MYSQL] Error occurs when execute on GROUP 'KINGFARM_CMS_1514128361451ZDQFKINGFARM_CMS_VJRR_0000_RDS' ATOM 'rm-bp1g56gamgkya2134_kingfarm_cms_vjrr_0000_fcxr': Table 'kf_consultation' was locked with a READ lock and can't be updated More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4614]; nested exception is java.sql.SQLException: [df016b538800000-3][10.80.110.13:3306][kingfarm_cms]ERR-CODE: [TDDL-4614][ERR_EXECUTE_ON_MYSQL] Error occurs when execute on GROUP 'KINGFARM_CMS_1514128361451ZDQFKINGFARM_CMS_VJRR_0000_RDS' ATOM 'rm-bp1g56gamgkya2134_kingfarm_cms_vjrr_0000_fcxr': Table 'kf_consultation' was locked with a READ lock and can't be updated More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4614] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2826) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302) at com.taobao.tddl.driver.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:72) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198) at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) at com.sun.proxy.$Proxy65.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) at com.sun.proxy.$Proxy81.publishConsultation(Unknown Source) at com.kingfarm.cms.social.service.ConsultationServiceImpl.publishConsultation(ConsultationServiceImpl.java:361) at com.kingfarm.cms.social.control.ConsultationManagerImpl.publishConsultation(ConsultationManagerImpl.java:80) at sun.reflect.GeneratedMethodAccessor211.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.taobao.hsf.remoting.provider.ReflectInvocationHandler.handleRequest0(ReflectInvocationHandler.java:92) at com.taobao.hsf.remoting.provider.ReflectInvocationHandler.invoke(ReflectInvocationHandler.java:183) at com.taobao.hsf.invocation.filter.RPCFilterBuilder$TailNode.invoke(RPCFilterBuilder.java:266) at com.taobao.hsf2dubbo.context.DubboRPCContextServerFilter.invoke(DubboRPCContextServerFilter.java:26) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.unit.service.impl.UnitServerFilter.invoke(UnitServerFilter.java:59) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.plugins.spas.SpasServerFilter.invoke(SpasServerFilter.java:124) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.edas.tps.component.WhiteListServerFilter.invoke(WhiteListServerFilter.java:67) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.edas.tps.component.TPSServerFilter.invoke(TPSServerFilter.java:67) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.tps.component.TPSServerFilter.invoke(TPSServerFilter.java:68) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.invocation.stats.InvocationStatsServerFilter.invoke(InvocationStatsServerFilter.java:44) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.monitor.log.filter.MonitorLogServerFilter.invoke(MonitorLogServerFilter.java:45) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.profiler.ProfilerServerFilter.invoke(ProfilerServerFilter.java:32) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.plugins.eagleeye.EagleEyeServerFilter.invoke(EagleEyeServerFilter.java:66) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.rpc.server.MethodAbsenceFilter.invoke(MethodAbsenceFilter.java:48) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.rpc.server.EchoFilter.invoke(EchoFilter.java:45) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.rpc.generic.GenericInvocationServerFilter.invoke(GenericInvocationServerFilter.java:105) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.rpc.server.ServiceAbsenceFilter.invoke(ServiceAbsenceFilter.java:47) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.context.RPCContextServerFilter.invoke(RPCContextServerFilter.java:28) at com.taobao.hsf.invocation.filter.RPCFilterNode.invoke(RPCFilterNode.java:71) at com.taobao.hsf.invocation.filter.RPCFilterBuilder$HeadNode.invoke(RPCFilterBuilder.java:232) at com.taobao.hsf.invocation.filter.FilterInvocationHandler.invoke(FilterInvocationHandler.java:28) at com.taobao.hsf.remoting.provider.ServerContextInvocationHandler.invoke(ServerContextInvocationHandler.java:35) at com.taobao.hsf.remoting.provider.ProviderProcessor.handleRequest(ProviderProcessor.java:52) at com.taobao.hsf.io.remoting.hsf.message.HSFServerHandler$1.run(HSFServerHandler.java:99) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)