dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #06503
Re: Troubles with database communication
I do not know what to do. I have found this:
http://dev.mysql.com/doc/refman/5.1/en/connector-j-usagenotes-troubleshooting.html
And what makes me feel really bad is:
"*22.3.5.3.4: ** I have a servlet/application that works fine for a day, and
then stops working overnight * MySQL closes connections after 8 hours of
inactivity. You either need to use a connection pool that handles stale
connections or use the "autoReconnect" parameter"
and
"The autoReconnect facility is deprecated, and may be removed in a future
release. "
So what we do?
Caveman
On Mon, Jun 28, 2010 at 12:59 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>wrote:
> Hi
>
> It looks like the driver is handing out a connection to be used from
> the pool which is broken ie the socket is no longer in a connected
> state.
>
> Hopefully autoReconnect=true might fix it.
>
> If not I would take a look at tuning c3po pool parameters. There are
> parameters like idleTestperiod for example, which can be set to
> periodically check all your pooled but idle connections.
>
> Regards
> Bob
>
> On 28 June 2010 04:32, Orvalho Augusto <orvaquim@xxxxxxxxx> wrote:
> > I have waited and now I have got this:
> >
> > org.springframework.transaction.CannotCreateTransactionException: Could
> not
> > open Hibernate Session for transaction; nested exception is
> > org.hibernate.TransactionException: JDBC begin failed:
> >
> >
> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599)
> >
> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
> >
> >
> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
> >
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
> >
> >
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> > $Proxy72.loadUserByUsername(Unknown Source)
> >
> >
> org.springframework.security.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:83)
> >
> org.springframework.security.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:121)
> >
> >
> org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:188)
> >
> org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:46)
> >
> org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:82)
> >
> >
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:259)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> >
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
> >
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
> >
> >
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> >
> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
> >
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> >
> > root cause
> >
> > org.hibernate.TransactionException: JDBC begin failed:
> >
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)
> >
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
> >
> >
> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
> >
> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
> >
> >
> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
> >
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
> >
> >
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> > $Proxy72.loadUserByUsername(Unknown Source)
> >
> >
> org.springframework.security.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:83)
> >
> org.springframework.security.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:121)
> >
> >
> org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:188)
> >
> org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:46)
> >
> org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:82)
> >
> >
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:259)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> >
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
> >
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
> >
> >
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> >
> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
> >
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> >
> > root cause
> >
> > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet
> > successfully received from the server was229878 seconds ago.The last
> packet
> > sent successfully to the server was 229878 seconds ago, which is longer
> > than the server configured value of 'wait_timeout'. You should consider
> > either expiring and/or testing connection validity before use in your
> > application, increasing the server configured values for client timeouts,
> or
> > using the Connector/J connection property 'autoReconnect=true' to avoid
> this
> > problem.
> >
> > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> >
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> >
> > java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> > com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> >
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
> > com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
> >
> > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
> > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> >
> com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4874)
> >
> >
> com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
> >
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
> >
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
> >
> >
> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
> >
> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
> >
> >
> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
> >
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
> >
> >
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> > $Proxy72.loadUserByUsername(Unknown Source)
> >
> >
> org.springframework.security.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:83)
> >
> org.springframework.security.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:121)
> >
> >
> org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:188)
> >
> org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:46)
> >
> org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:82)
> >
> >
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:259)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> >
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
> >
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
> >
> >
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> >
> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
> >
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> >
> > root cause
> >
> > java.net.SocketException: Broken pipe
> > java.net.SocketOutputStream.socketWrite0(Native Method)
> >
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
> > java.net.SocketOutputStream.write(SocketOutputStream.java:153)
> >
> >
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
> > java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
> > com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3227)
> > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
> >
> > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> >
> com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4874)
> >
> com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
> >
> >
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
> >
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
> >
> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
> >
> >
> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
> >
> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
> >
> >
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
> >
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >
> >
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> > $Proxy72.loadUserByUsername(Unknown Source)
> >
> org.springframework.security.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:83)
> >
> >
> org.springframework.security.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:121)
> >
> org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:188)
> >
> >
> org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:46)
> >
> org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:82)
> >
> >
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:259)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> >
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
> >
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >
> >
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
> >
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
> >
> >
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> >
> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
> >
> >
> >
> >
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> >
> >
> >
> > I will place the autoReconnect=true on the URL. I must confess I have
> > another DHIS running without these troubles and I am using openJDK (java
> > from Sun/Oracle) on both.
> >
> > Thanks
> > Caveman
> >
> >
> >
> > On Thu, Jun 24, 2010 at 3:48 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
> wrote:
> >>
> >> On 24 June 2010 13:53, Orvalho Augusto <orvaquim@xxxxxxxxx> wrote:
> >> > Thanks for these very clarifying answers. I have googled and actually
> >> > there
> >> > are lot of people with this.
> >> >
> >> > And one of the suggestions to cope, it was exactly the 127.0.0.1
> thing.
> >>
> >> Don't believe everything you read on google :-) The simple fact is
> >> that a jdbc connection will always use tcp and never use unix domain
> >> sockets. So I think the locahost vs 127.0.0.1 thing is probably
> >> another red herring.
> >>
> >> >Yes
> >> > I had two versions of JDBC driver for MySQL, one inside de java_home
> and
> >> > another on lib of DHIS2. I removed this one. And now I am waiting for
> >> > the
> >> > famous error.
> >>
> >> Now that sounds more interesting. Please let us know how the
> >> consequences of this turn out.
> >>
> >> Regards
> >> Bob
> >>
> >> >
> >> > Caveman
> >> >
> >> >
> >> > On Wed, Jun 23, 2010 at 7:29 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
> >> > wrote:
> >> >>
> >> >> On 23 June 2010 18:00, Orvalho Augusto <orvaquim@xxxxxxxxx> wrote:
> >> >> > Sorry for my laziness on this.
> >> >> >
> >> >> > My hibernate.properties
> >> >> >
> >> >> > hibernate.dialect = org.hibernate.dialect.MySQLDialect
> >> >> > hibernate.connection.driver_class = com.mysql.jdbc.Driver
> >> >> > ##hibernate.connection.url =
> >> >> >
> >> >> >
> jdbc:mysql://localhost/dhis2_pub?useUnicode=true&characterEncoding=UTF-8
> >> >> > hibernate.connection.url =
> >> >> >
> >> >> >
> jdbc:mysql://localhost/dhis204?useUnicode=true&characterEncoding=UTF-8
> >> >> > hibernate.connection.username = dhis
> >> >> > hibernate.connection.password = dhis
> >> >> > hibernate.hbm2ddl.auto = update
> >> >> >
> >> >> > By this you are right. I am using unix socket when setting with
> >> >> > localhost on
> >> >> > URL. I must write 127.0.0.1.
> >> >> >
> >> >> > I have changed and I am waiting to see it again.
> >> >>
> >> >> The unix domain socket is a bit of a distraction as java does not
> >> >> support unix domain sockets so the hibernate connection will always
> be
> >> >> tcp anyway. So waiting will not help :-)
> >> >>
> >> >> >
> >> >> > This happened not only with importing and etc... it happened on the
> >> >> > login
> >> >> > too.
> >> >>
> >> >> I have seen reports of certain mixtures of jdbc drivers and versions
> >> >> causing problems. You might want to check that against other
> >> >> experiences on google.
> >> >>
> >> >> Regards
> >> >> Bob
> >> >>
> >> >> >
> >> >> > Thank you
> >> >> > Caveman
> >> >> >
> >> >> >
> >> >> > On Wed, Jun 23, 2010 at 9:01 AM, Bob Jolliffe <
> bobjolliffe@xxxxxxxxx>
> >> >> > wrote:
> >> >> >>
> >> >> >> I can see from the status message that unix domain sockets are
> being
> >> >> >> used by the mysql client. Your hibernate connection will use
> >> >> >> tcp/ip.
> >> >> >>
> >> >> >> The problem seems definitely to be with the transport layer -
> >> >> >> "Expected to read 4 bytes, read 0 bytes before connection was
> >> >> >> unexpectedly lost". So the socket channel definitely goes bad on
> >> >> >> you
> >> >> >> :-(
> >> >> >>
> >> >> >> Orvalho is this problem completely random or can you think is
> there
> >> >> >> any pattern to it? For example I have seen a problem with mysql
> if
> >> >> >> you are doing a very large import and the size of the mysql packet
> >> >> >> (with all the multiple inserts) exceeds a hard limit - there is a
> >> >> >> setting to increase this. But from what you are saying (from time
> >> >> >> to
> >> >> >> time) I don't think this is the case here.
> >> >> >>
> >> >> >> Is the mysql server on the same machine as the dhis web server?
> >> >> >>
> >> >> >> What is the server os and version?
> >> >> >>
> >> >> >> Regards
> >> >> >> Bob
> >> >> >>
> >> >> >> On 23 June 2010 07:09, Jason Pickering <
> jason.p.pickering@xxxxxxxxx>
> >> >> >> wrote:
> >> >> >> > Can you send your hibernate.properties file (otherwise
> privately)?
> >> >> >> >
> >> >> >> > Is you MySQL TCP/IP sockets available on 127.0.0.1 (not Unix
> >> >> >> > pipes)?
> >> >> >> >
> >> >> >> > Regards,
> >> >> >> > Jason
> >> >> >> >
> >> >> >> >
> >> >> >> > On Wed, Jun 23, 2010 at 5:32 AM, Orvalho Augusto
> >> >> >> > <orvaquim@xxxxxxxxx>
> >> >> >> > wrote:
> >> >> >> >> >From time to time my DHIS stalls and report me this:
> >> >> >> >> =========================================================
> >> >> >> >> Jun 23, 2010 5:15:53 AM
> >> >> >> >> org.apache.catalina.core.StandardWrapperValve
> >> >> >> >> invoke
> >> >> >> >> SEVERE: Servlet.service() for servlet default threw exception
> >> >> >> >>
> org.springframework.transaction.CannotCreateTransactionException:
> >> >> >> >> Could
> >> >> >> >> not
> >> >> >> >> open Hibernate Session for transaction; nested exception is
> >> >> >> >> org.hibernate.TransactionException: JDBC beg
> >> >> >> >> in failed:
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> >> >> >> >> at $Proxy72.loadUserByUsername(Unknown Source)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:83)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:121)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:188)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:46)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:82)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:259)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> >> >> >> >> at java.lang.Thread.run(Thread.java:636)
> >> >> >> >> Caused by: org.hibernate.TransactionException: JDBC begin
> failed:
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
> >> >> >> >> ... 36 more
> >> >> >> >> Caused by:
> >> >> >> >> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> >> >> >> >> Communications link failure
> >> >> >> >>
> >> >> >> >> Last packet sent to the server was 0 ms ago.
> >> >> >> >> at
> >> >> >> >> sun.reflect.GeneratedConstructorAccessor151.newInstance(Unknown
> >> >> >> >> Source)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> >> >> >> >> at
> >> >> >> >> java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> >> >> >> >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
> >> >> >> >> at
> >> >> >> >> com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985)
> >> >> >> >> at
> >> >> >> >> com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)
> >> >> >> >> at
> >> >> >> >> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)
> >> >> >> >> at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> >> >> >> >> at
> >> >> >> >> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> >> >> >> >> at
> >> >> >> >> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4874)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
> >> >> >> >> at
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
> >> >> >> >> ... 38 more
> >> >> >> >> Caused by: java.io.EOFException: Can not read response from
> >> >> >> >> server.
> >> >> >> >> Expected
> >> >> >> >> to read 4 bytes, read 0 bytes before connection was
> unexpectedly
> >> >> >> >> lost.
> >> >> >> >> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2431)
> >> >> >> >> at
> >> >> >> >> com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)
> >> >> >> >> ... 46 more
> >> >> >> >>
> >> >> >> >> =========================================================
> >> >> >> >>
> >> >> >> >> And without any action it starts to work by itself.
> >> >> >> >>
> >> >> >> >> MySQL is fine. I have checked it with dhis user and in fact
> there
> >> >> >> >> is
> >> >> >> >> a
> >> >> >> >> dhis
> >> >> >> >> user connected:
> >> >> >> >>
> >> >> >> >> =========================================================
> >> >> >> >> [root@DhisServer tomcat6]# mysql -u dhis -p
> >> >> >> >>
> >> >> >> >> Welcome to the MySQL monitor. Commands end with ; or \g.
> >> >> >> >> Your MySQL connection id is 1346
> >> >> >> >> Server version: 5.1.30-log MySQL Community Server (GPL)
> >> >> >> >>
> >> >> >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >> >> >> >>
> >> >> >> >> mysql> status
> >> >> >> >> --------------
> >> >> >> >> mysql Ver 14.14 Distrib 5.1.30, for unknown-linux-gnu (x86_64)
> >> >> >> >> using
> >> >> >> >> readline 5.1
> >> >> >> >>
> >> >> >> >> Connection id: 1346
> >> >> >> >> Current database:
> >> >> >> >> Current user: dhis@localhost
> >> >> >> >> SSL: Not in use
> >> >> >> >> Current pager: stdout
> >> >> >> >> Using outfile: ''
> >> >> >> >> Using delimiter: ;
> >> >> >> >> Server version: 5.1.30-log MySQL Community Server (GPL)
> >> >> >> >> Protocol version: 10
> >> >> >> >> Connection: Localhost via UNIX socket
> >> >> >> >> Server characterset: utf8
> >> >> >> >> Db characterset: utf8
> >> >> >> >> Client characterset: latin1
> >> >> >> >> Conn. characterset: latin1
> >> >> >> >> UNIX socket: /var/lib/mysql/mysql.sock
> >> >> >> >> Uptime: 10 days 18 hours 4 min 44 sec
> >> >> >> >>
> >> >> >> >> Threads: 3 Questions: 141592 Slow queries: 0 Opens: 1220
> >> >> >> >> Flush
> >> >> >> >> tables:
> >> >> >> >> 1 Open tables: 511 Queries per second avg: 0.152
> >> >> >> >> --------------
> >> >> >> >>
> >> >> >> >> mysql> show processlist;
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> +------+------+-----------------+---------+---------+------+-------+------------------+
> >> >> >> >> | Id | User | Host | db | Command | Time |
> >> >> >> >> State |
> >> >> >> >> Info |
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> +------+------+-----------------+---------+---------+------+-------+------------------+
> >> >> >> >> | 1341 | dhis | localhost:58090 | dhis204 | Sleep | 540
> >> >> >> >> | |
> >> >> >> >> NULL |
> >> >> >> >> | 1342 | dhis | localhost:41792 | dhis204 | Sleep | 540
> >> >> >> >> | |
> >> >> >> >> NULL |
> >> >> >> >> | 1346 | dhis | localhost | NULL | Query | 0 |
> >> >> >> >> NULL |
> >> >> >> >> show
> >> >> >> >> processlist |
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> +------+------+-----------------+---------+---------+------+-------+------------------+
> >> >> >> >> 3 rows in set (0.00 sec)
> >> >> >> >>
> >> >> >> >> ===================================================
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> I am using the last stable DHIS war file (2.0.4).
> >> >> >> >> My JAVA_OPTS="-Xms128m -Xmx700m -XX:MaxPermSize=256m"
> >> >> >> >>
> >> >> >> >> I am on Fedora Linux: Fedora release 10 (Cambridge)
> >> >> >> >> And Tomcat 6.0.18.
> >> >> >> >>
> >> >> >> >> Can you help me guys?
> >> >> >> >>
> >> >> >> >> Caveman
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> _______________________________________________
> >> >> >> >> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> >> >> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> >> >> More help : https://help.launchpad.net/ListHelp
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > --
> >> >> >> > --
> >> >> >> > Jason P. Pickering
> >> >> >> > email: jason.p.pickering@xxxxxxxxx
> >> >> >> > tel:+260968395190
> >> >> >> >
> >> >> >> > _______________________________________________
> >> >> >> > Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> >> > Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >> >> > Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> >> >> > More help : https://help.launchpad.net/ListHelp
> >> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >
> >> >
> >> >
> >> >
> >
> >
> >
> >
>
Follow ups
References
