{"action":"closed","issue":{"url":"https://api.github.com/repos/Dev-Mind/e-wall/issues/61","labels_url":"https://api.github.com/repos/Dev-Mind/e-wall/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/Dev-Mind/e-wall/issues/61/comments","events_url":"https://api.github.com/repos/Dev-Mind/e-wall/issues/61/events","html_url":"https://github.com/Dev-Mind/e-wall/issues/61","id":126132271,"number":61,"title":"Bug in production - connection to db","user":{"login":"acrepet","id":544206,"avatar_url":"https://avatars.githubusercontent.com/u/544206?v=3","gravatar_id":"","url":"https://api.github.com/users/acrepet","html_url":"https://github.com/acrepet","followers_url":"https://api.github.com/users/acrepet/followers","following_url":"https://api.github.com/users/acrepet/following{/other_user}","gists_url":"https://api.github.com/users/acrepet/gists{/gist_id}","starred_url":"https://api.github.com/users/acrepet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/acrepet/subscriptions","organizations_url":"https://api.github.com/users/acrepet/orgs","repos_url":"https://api.github.com/users/acrepet/repos","events_url":"https://api.github.com/users/acrepet/events{/privacy}","received_events_url":"https://api.github.com/users/acrepet/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Dev-Mind/e-wall/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-01-12T09:17:16Z","updated_at":"2016-01-14T11:23:26Z","closed_at":"2016-01-14T11:23:26Z","body":"ça m'inquiete un peu, y'a eu plein de déconnexion à la base hier soir/ce matin, d'où les plantage ce matin.\r\nTu saurais pourquoi d'un coup la base mysql n'est plus visible?\r\n\r\n08:31:52 [http-nio-8080-exec-5] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet dispatcherServlet threw exception\r\njava.net.SocketException: Relais brisé (pipe)\r\n        at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_66]\r\n        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) ~[na:1.8.0_66]\r\n        at java.net.SocketOutputStream.write(SocketOutputStream.java:153) ~[na:1.8.0_66]\r\n        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.8.0_66]\r\n        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[na:1.8.0_66]\r\n        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        ... 172 common frames omitted\r\nWrapped by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 38 065 062 milliseconds ago.  The last packet sent successfully to the server was 38 065 062 milliseconds ago. 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.\r\n        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_66]\r\n        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_66]\r\n        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_66]\r\n        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[na:1.8.0_66]\r\n        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4882) ~[mysql-connector-java-5.1.36.jar!/:5.1.36]\r\n        at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) ~[na:na]\r\n        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_66]\r\n        at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_66]\r\n        at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) ~[tomcat-jdbc-8.0.28.jar!/:na]\r\n        at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) ~[tomcat-jdbc-8.0.28.jar!/:na]\r\n        at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) ~[tomcat-jdbc-8.0.28.jar!/:na]\r\n        at com.sun.proxy.$Proxy82.setAutoCommit(Unknown Source) ~[na:na]\r\n        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:72) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n        ... 160 common frames omitted\r\nWrapped by: org.hibernate.TransactionException: JDBC begin transaction failed:\r\n        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:76) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n\r\nat org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:76) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1471) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.jpa.internal.TransactionImpl.begin(TransactionImpl.java:61) ~[hibernate-entitymanager-4.3.11.Final.jar!/:4.3.11.Final]\r\n        ... 157 common frames omitted\r\nWrapped by: javax.persistence.PersistenceException: org.hibernate.TransactionException: JDBC begin transaction failed:\r\n        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) ~[hibernate-entitymanager-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) ~[hibernate-entitymanager-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771) ~[hibernate-entitymanager-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.hibernate.jpa.internal.TransactionImpl.begin(TransactionImpl.java:64) ~[hibernate-entitymanager-4.3.11.Final.jar!/:4.3.11.Final]\r\n        at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:170) ~[spring-orm-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) ~[spring-orm-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        ... 155 common frames omitted\r\nWrapped by: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.TransactionException: JDBC begin transaction failed:\r\n        at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:431) ~[spring-orm-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) ~[spring-tx-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) ~[spring-tx-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:654) ~[spring-aop-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at fr.emse.ewall.service.user.UserService$$EnhancerBySpringCGLIB$$c93a3d0c.findOrCreateUser(<generated>) ~[server.jar!/:na]\r\n        at fr.emse.ewall.security.DevAuthenticationFilter$DevHttpServletRequest.getUserPrincipal(DevAuthenticationFilter.java:49) ~[server.jar!/:na]\r\n        at org.springframework.web.servlet.FrameworkServlet.getUsernameForRequest(FrameworkServlet.java:1091) [spring-webmvc-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.web.servlet.FrameworkServlet.publishRequestHandledEvent(FrameworkServlet.java:1077) [spring-webmvc-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) [spring-webmvc-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) [spring-webmvc-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.0.28.jar!/:8.0.28]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) [spring-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) [spring-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat-embed-core-8.0.28.jar!/:8.0.28]\r\n        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) [spring-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]\r\n\r\n\r\n08:31:52 [http-nio-8080-exec-5] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet dispatcherServlet threw exception\r\norg.hibernate.TransactionException: Already have an associated managed connection\r\n        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:65) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]\r\n\r\n08:31:52 [http-nio-8080-exec-5] WARN  o.h.e.j.s.SqlExceptionHelper - SQL Error: 0, SQLState: 08003\r\n08:31:52 [http-nio-8080-exec-5] ERROR o.h.e.j.s.SqlExceptionHelper - No operations allowed after connection closed.\r\n08:31:52 [http-nio-8080-exec-5] ERROR o.s.t.i.TransactionInterceptor - Application exception overridden by rollback exception\r\njava.net.SocketException: Relais brisé (pipe)\r\n"}}