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 <[email protected]> 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: > > ========================================================= > [r...@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: d...@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 > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- -- Jason P. Pickering email: [email protected] tel:+260968395190 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
