mycat未配置对应表导致报错

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: can't find table define in schema T_OTHERSIDE_CLOSED schema:basisdata_ecommerce
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
at com.sun.proxy.$Proxy85.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
at com.sun.proxy.$Proxy106.query(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)
... 44 more
 
at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:108)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:65)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108)
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84)
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170)
at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52)
at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82)
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)
 
DEBUG   2016-12-14 14:24:28.077 [org.spri] (): afterTestClass(): class [com.tree.autotest.ecommerce.EcommerceOtherSideService.getEcommerceOtherSidesClosedTest]
DEBUG   2016-12-14 14:24:28.078 [org.spri] (): After test class: context [DefaultTestContext@12cdcf4 testClass = getEcommerceOtherSidesClosedTest, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [MergedContextConfiguration@5bcea91b testClass = getEcommerceOtherSidesClosedTest, locations = '{classpath:/spring-context.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{}', contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader', parent = [null]]], class annotated with @DirtiesContext [false] with mode [null].
INFO    2016-12-14 14:24:28.079 [com.alib] ():  [DUBBO] Run shutdown hook now., dubbo version: 2.5.3, current host: 192.168.10.68
INFO    2016-12-14 14:24:28.080 [org.spri] (): Closing org.springframework.context.support.GenericApplicationContext@75881071: startup date [Wed Dec 14 14:24:21 CST 2016]; root of context hierarchy
DEBUG   2016-12-14 14:24:28.080 [org.spri] (): Publishing event in org.springframework.context.support.GenericApplicationContext@75881071: org.springframework.context.event.ContextClosedEvent[source=org.springframework.context.support.GenericApplicationContext@75881071: startup date [Wed Dec 14 14:24:21 CST 2016]; root of context hierarchy]
DEBUG   2016-12-14 14:24:28.081 [org.spri] (): Returning cached instance of singleton bean 'lifecycleProcessor'
DEBUG   2016-12-14 14:24:28.081 [org.spri] (): Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@4f74980d: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,com.tree.autotest.jdbc.ManagedSqlUtil#0,dataSource,service-gateway,com.alibaba.dubbo.config.MonitorConfig,com.alibaba.dubbo.config.RegistryConfig,com.alibaba.dubbo.config.ConsumerConfig,appProvider,userLimitService,telSmsSheetService,userTelService,telFamiliarityNumService,telCallSheetService,TelBillService,TelBaseInfoService,OperatorService,OperatorDubboService,ecommerceAddressService,ecommerceBaseInfoService,ecommerceBindedBankCardService,ecommerceCreditService,ecommerceDataMaintenanceService,ecommerceKeywordService,ecommerceOtherSideService,ecommerceTransactionTypeService,genericQueryService,userEcommerceService,cryptUtil,cryptConfig,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.event.internalEventListenerProcessor,org.springframework.context.event.internalEventListenerFactory,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.enhancedConfigurationProcessor]; root of factory hierarchy
INFO    2016-12-14 14:24:28.082 [com.alib] ():  [DUBBO] Close all registries [], dubbo version: 2.5.3, current host: 192.168.10.68
DEBUG   2016-12-14 14:24:28.083 [org.spri] (): Invoking destroy() on bean with name 'userEcommerceService'
INFO    2016-12-14 14:24:28.083 [com.alib] ():  [DUBBO] Close dubbo connect: /192.168.10.68:64193-->/121.43.177.8:20192, dubbo version: 2.5.3, current host: 192.168.10.68
DEBUG   2016-12-14 14:24:28.083 [org.spri] (): Invoking destroy() on bean with name 'genericQueryService'
DEBUG   2016-12-14 14:24:28.084 [org.spri] (): Invoking destroy() on bean with name 'ecommerceTransactionTypeService'
DEBUG   2016-12-14 14:24:28.084 [org.spri] (): Retrieved dependent beans for bean 'ecommerceOtherSideService': [com.tree.autotest.ecommerce.EcommerceOtherSideService.getEcommerceOtherSidesClosedTest]
DEBUG   2016-12-14 14:24:28.084 [org.spri] (): Invoking destroy() on bean with name 'ecommerceOtherSideService'
INFO    2016-12-14 14:24:28.085 [com.alib] ():  [DUBBO] Close netty channel [id: 0x2e6ba49a, /192.168.10.68:64193 => /121.43.177.8:20192], dubbo version: 2.5.3, current host: 192.168.10.68
INFO    2016-12-14 14:24:28.087 [com.alib] ():  [DUBBO] disconected from /121.43.177.8:20192,url:dubbo://121.43.177.8:20192/com.datatrees.basisdata.ecommerce.servicefacade.EcommerceOtherSideService?application=service-gateway&codec=dubbo&default.check=false&dubbo=2.5.3&heartbeat=60000&interface=com.datatrees.basisdata.ecommerce.servicefacade.EcommerceOtherSideService&methods=countEcommerceOtherSides,getEcommerceBehaviorLabel,editEcommerce,getTop20TaobaoRecordByOtherside,countSuspiciousTaobaorecord,getRefUserList,getTransactionTypeRearExpr,getEcommerceTransactionType,testMiner,getBehaviorLableRearExpr,getSuspiciousTaobaorecord,getRefOtherSideIdList,signChecked,getEcommerceOtherSides,updateOtherSideStatus,getEcommerceOtherSidesClosed&pid=35088&revision=3.3.6&side=consumer&timestamp=1481696663751, dubbo version: 2.5.3, current host: 192.168.10.68
INFO    2016-12-14 14:24:28.088 [com.alib] ():  [DUBBO] Close dubbo connect: 192.168.10.68:0-->121.43.177.8:20192, dubbo version: 2.5.3, current host: 192.168.10.68
DEBUG   2016-12-14 14:24:28.088 [org.spri] (): Invoking destroy() on bean with name 'ecommerceKeywordService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'ecommerceDataMaintenanceService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'ecommerceCreditService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'ecommerceBindedBankCardService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'ecommerceBaseInfoService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'ecommerceAddressService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'OperatorDubboService'
DEBUG   2016-12-14 14:24:28.089 [org.spri] (): Invoking destroy() on bean with name 'OperatorService'
DEBUG   2016-12-14 14:24:28.090 [org.spri] (): Invoking destroy() on bean with name 'TelBaseInfoService'
DEBUG   2016-12-14 14:24:28.090 [org.spri] (): Invoking destroy() on bean with name 'TelBillService'
DEBUG   2016-12-14 14:24:28.090 [org.spri] (): Invoking destroy() on bean with name 'telCallSheetService'
DEBUG   2016-12-14 14:24:28.090 [org.spri] (): Invoking destroy() on bean with name 'telFamiliarityNumService'
DEBUG   2016-12-14 14:24:28.090 [org.spri] (): Invoking destroy() on bean with name 'userTelService'
DEBUG   2016-12-14 14:24:28.090 [org.spri] (): Invoking destroy() on bean with name 'telSmsSheetService'
DEBUG   2016-12-14 14:24:28.091 [org.spri] (): Invoking destroy() on bean with name 'userLimitService'
DEBUG   2016-12-14 14:24:28.091 [org.spri] (): Invoking destroy() on bean with name 'appProvider'
 
Process finished with exit code 255
posted @ 2016-12-14 15:08  小学生II  阅读(2745)  评论(0编辑  收藏  举报