2016-07-03 09:47:26 -3906 [main] ERROR - init datasource error7 Q8 D/ ~ e2 I5 r/ e java.sql.SQLException: Could not retrieve transation read-only status server* O( [1 f: Q/ e+ _$ g
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)* W3 R. S: ~ I
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)1 I5 P1 p4 K3 ^2 ^- r/ F
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) ( A) }( X# B7 ~6 o5 j7 u) h. A( |# G2 ? at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)/ K3 C* ^+ t" }( l2 K4 l
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902), B! O z) f7 z1 G
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892)' ~, b' b7 `5 S2 ^
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607) ; }9 I- ]0 Y, V6 ^2 v1 T4 ^3 y/ G at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)) B6 f3 o+ W( C% M
at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383): U+ f# c( K. J
at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892) ( F" A8 d! l2 h$ D2 i at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380)8 I: Y) r; z& k7 U
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292) 3 {; Z% J; k' |) Z% a at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)7 @: l( U/ v/ a+ ^8 i$ M
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619) . Y* g0 A7 O. E: g s8 k5 E at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915) $ |' Y2 P4 c, m( l5 I- b7 R7 G at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911) ' D( m% G- h3 _ L5 [7 s at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98) 2 Y C: \5 \5 `" J# J1 u at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)6 I/ e# C* q1 L( ]+ g& _ d
at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)5 m- N8 ^2 n4 Z8 l. I$ U
at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49) 5 d6 g% u. r/ x' W+ i- V- B at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445) # d9 E4 |7 }+ T+ t8 ~+ C0 F at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)" I$ @; n, h1 B
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612) 9 B+ }+ q# y' I# n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549) " y$ Y% M J# _8 \8 ^9 r at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)$ w& {9 j5 [6 c S/ u; y: U
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) 3 D; ]. f! i, g$ k) U3 _* x! D) B at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) 3 Z7 [. [) @$ V at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)5 M/ x+ v) H& m# X* X* l' y$ O
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) 3 h! s" G3 \; E% x$ i* ] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) - V9 a9 A9 U8 A' z! x$ _3 c, Y at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328); k! H9 @ r. L9 Z8 Q
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) ! H7 d0 C% r5 e" D3 m: j at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)% x9 q4 k8 ]$ T7 f y
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)) I' E9 [ a4 J5 @
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114); e8 l: d1 f. F1 e' h
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)' b6 W% ~2 B: E* d' N# ^
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)! s6 t. D) p+ F* T# Q2 B1 ~
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)( Q# ]) ~/ P; H0 @, T$ p+ e2 g; M
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) % w. j4 U- z" c: D3 w at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228): |1 j" p1 {# O0 I/ z o5 [- G0 E
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) ( W7 H! N" [. X' Q" U2 g9 c% W) c at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ( n# v; d% j6 x+ p6 R3 ~) p: L at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446) E* ?5 a; y) M7 v5 h( P
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420); {% d0 I2 G8 ^) p4 C* r
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545) 2 I- m& B' W( ]! L h at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155) + z/ t& P7 [* }( v" Z, t0 A at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)9 r8 T8 c) D: {# U2 S
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)" ]' v' `8 h. V" b
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185) * Q4 g0 ?) |4 x) }. O at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) 0 F# m# {9 x. d# G; X/ `8 j7 p S at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)( g4 f! c6 q* O7 _$ m
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)5 O4 l4 w0 f8 @* {+ n& a
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)2 _8 l! s1 O( C/ [- s; ]% z' R/ u
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) % ` Q: m! F, p9 Z! b at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) ) k. Z0 w) v1 S( i, { at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703) - o; f. Z& f F2 n) b0 K7 m at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)0 h- B' X- [' `6 d9 L; v* B. ~! L$ L
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) - ^1 c7 d0 C5 }' M1 R1 r( J% O, b at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403): {/ h& Z' j3 m! _; U( d8 X, V- z
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) $ G7 @% ]3 G7 q' r3 a. a1 j4 _ at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)5 X4 g3 J! _/ a
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)" s) I+ F S1 p: U2 K9 U
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334) . P1 h* u! d% F% E/ S" i& f# ~. e* ^ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)7 }% I: v% V. C+ {
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) 3 {0 v- l2 F6 o5 l& P, P5 ~ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)8 E2 y; g5 n. E& N+ B" m6 D4 F4 }
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)( n5 J8 ]2 |6 [' m& B
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883) 4 D, U/ t& {& l5 C. N# p at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) - o! C9 r8 v) A8 n3 G at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) * [+ T2 X! T/ u& ? at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)# O1 J7 f# ]: o2 f3 _5 U
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) / q6 U7 T t! @! G at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) ' y5 y/ j; G% n$ F at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) $ ? u& \. F* c4 t5 X4 C9 T1 P+ y$ J at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) - N# |. }. o4 g( K8 R at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)8 R) s1 a) Q9 E
at org.apache.catalina.core.StandardService.start(StandardService.java:516)" Y1 S2 x8 a N/ o+ p
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710). i1 |' g: u$ o5 i
at org.apache.catalina.startup.Catalina.start(Catalina.java:566) - \8 N, j: ?1 ~' K' e6 m1 Y! X u at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)6 J' D, u9 q. J! F" F
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) : w+ K1 t/ j5 ~% s at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43). R+ V. N5 t; ~+ c' Q! c& o- Q2 h; ^
at java.lang.reflect.Method.invoke(Method.java:601) 0 y3 k) p4 `6 f at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288), c* m, C1 K! q* J6 u) m
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) 0 b5 k8 W- `% V0 ^" Y5 SCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure 9 P" m- ?' I: ^% S* ]2 z7 O8 M- l6 j- b$ R7 {/ { `
The last packet successfully received from the server was 31 milliseconds ago. The last packet sent successfully to the server was 31 milliseconds ago. 9 a) r% E9 v' `" n! q. f& D0 k } at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)3 K& n! a$ P8 c
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)% z+ A: X, a- `0 u' M* m# @; d! q
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)$ W c# [- W4 B8 p: F4 H0 P
at java.lang.reflect.Constructor.newInstance(Constructor.java:525) , H- g4 S0 B; h- N- T. k6 k) }3 p6 v: n at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)& F5 s- c& p" P8 m
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036) $ y( L. j5 i. U; e) [6 l9 w% V at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)4 g& X4 b* N4 ?5 `5 m6 v
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327) 7 z4 h8 K4 U& o, J at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)6 Q$ @) K- f" P# g! w
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ' ?: L) S. s1 G at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582): l' e5 O2 u3 W$ n& s: V7 j
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) ! s9 i2 K+ e- z" z& b at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)8 E: c3 P6 x8 G! X# r, a$ {
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)* @! h. W+ U; x! s
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)" u& j6 g! _8 G
... 78 more ; h) \ T* C, Q3 c9 ZCaused by: java.net.SocketException: Connection reset* c% ~2 s1 K A; c
at java.net.SocketInputStream.read(SocketInputStream.java:189) + I0 h0 `- x5 U1 ^1 d5 P8 }( T at java.net.SocketInputStream.read(SocketInputStream.java:121)# @- Z8 O$ u6 }! A, i- H6 ]
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)5 D9 m* N, O2 O- @5 N/ E/ I- |
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)! V; x$ K2 @# u+ `1 m
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173) ( d5 Z0 a$ D d+ z' q at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911) 9 X* g+ H+ _. Q- t9 W at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337) - S% X+ {* P7 D, Q( @- } ... 86 more 1 F) m& z6 w S6 N% n7 a