On 24 June 2010 13:53, Orvalho Augusto <[email protected]> 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 <[email protected]> wrote: >> >> On 23 June 2010 18:00, Orvalho Augusto <[email protected]> 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 <[email protected]> >> > 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 <[email protected]> >> >> 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 <[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 >> >> > >> > >> > >> > > > > > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
