could not execute query. Программа не видит таблицы

197
01 марта 2017, 19:19

Я проблему свою уже описывал но сейчас сделаю это более конкретно. Программа стоит на сервере, работает день, каждую ночь программа падает. При перезапуска томката опять всё в норме. Утром при выводе содержимого таблицы я получил такие ошибки:

org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
    at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:1518)
    at org.hibernate.loader.Loader.list(Loader.java:1498)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:266)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:788)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
    at DAOImpl.JurnalDAOImpl.getAllJurnal(JurnalDAOImpl.java:34)
    at servlets.JurnalController.performTask(JurnalController.java:45)
    at servlets.AbstractController.doGet(AbstractController.java:14)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 50841 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2874)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2764)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3286)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1852)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1975)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2476)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1583)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1725)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1197)
    at org.hibernate.loader.Loader.doQuery(Loader.java:366)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:206)
    at org.hibernate.loader.Loader.doList(Loader.java:1515)
    ... 26 more
Caused by: java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2330)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2775)
    ... 38 more
org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
    at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:1518)
    at org.hibernate.loader.Loader.list(Loader.java:1498)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:266)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:788)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
    at DAOImpl.RajonDAOImpl.getAllRajon(RajonDAOImpl.java:26)
    at servlets.JurnalController.performTask(JurnalController.java:47)
    at servlets.AbstractController.doGet(AbstractController.java:14)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION ** 
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
MESSAGE: Communications link failure
Last packet sent to the server was 50841 ms ago.
STACKTRACE:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 50841 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2874)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2764)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3286)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1852)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1975)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2476)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1583)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1725)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1197)
    at org.hibernate.loader.Loader.doQuery(Loader.java:366)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:206)
    at org.hibernate.loader.Loader.doList(Loader.java:1515)
    at org.hibernate.loader.Loader.list(Loader.java:1498)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:266)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:788)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
    at DAOImpl.JurnalDAOImpl.getAllJurnal(JurnalDAOImpl.java:34)
    at servlets.JurnalController.performTask(JurnalController.java:45)
    at servlets.AbstractController.doGet(AbstractController.java:14)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2330)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2775)
    ... 38 more

** END NESTED EXCEPTION **

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
    at com.mysql.jdbc.Util.getInstance(Util.java:378)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1102)
    at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:3906)
    at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:3872)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:379)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:320)
    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1089)
    at org.hibernate.loader.Loader.doQuery(Loader.java:365)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:206)
    at org.hibernate.loader.Loader.doList(Loader.java:1515)
    ... 26 more

Подскажите в чём может быть проблема=( И да, на серве 2 программы, написаны по одному принципу. 1 работает, а вторая падает. Заранее спасибо

READ ALSO
Чат Java (по аналогии чата World Of Tanks) [требует правки]
Java

Чат Java (по аналогии чата World Of Tanks) [требует правки]

Кто может дать качественную документацию по созданию чата с хабров и тд

 204
Разделение приложения на сервисы
Java

Разделение приложения на сервисы

Услышал, что современные веб-приложения строятся из независимых сервисовУ меня есть сервер tomcat, java ee и сервер Mysql

 214
Не передаются значения из метода в массив
Java

Не передаются значения из метода в массив

Не могу понять почему метод createArrayOfXValues не заполняет массив значениями y, которые были получены в методе TabulЕсли y статическая переменная,...

 205
Передача ссылки на объект в другую активность Android
Java

Передача ссылки на объект в другую активность Android

Задача: В первой активности Activity1 мы создаем экземпляр класса VeryFatClass:

 210