Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database connection gets dropped #14

Closed
tgrez opened this issue Apr 24, 2014 · 3 comments
Closed

Database connection gets dropped #14

tgrez opened this issue Apr 24, 2014 · 3 comments
Assignees
@tgrez
Milestone
full_text_search_...

Comments

@tgrez
Copy link
Owner

tgrez commented Apr 24, 2014

after some time db connection on AWS server gets dropped and request to REST API gets HTTP 500 as a response.

Stacktrace:

ERROR [2014-04-24 17:35:28,512] com.example.helloworld.resources.DemoNgramResource: aborcja
ERROR [2014-04-24 17:35:28,517] com.yammer.dropwizard.jersey.LoggingExceptionMapper: Error handling a request: 89a537dca3b3f137
! org.jooq.exception.DataAccessException: SQL [select sejmngram.ngrams.id, sejmngram.ngrams.datefrom, sejmngram.ngrams.dateto, sejmngram.ngrams.ngram, sejmngram.ngrams.nrOccurences, sejmngram.ngrams.content from sejmngram.ngrams where sejmngram.ngrams.ngram = ?]; No operations allowed after connection closed.
! at org.jooq.impl.Utils.translate(Utils.java:1288) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:495) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:327) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:330) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2256) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.sejmngram.database.fetcher.connection.MySqlDbConnector.queryDatabase(MySqlDbConnector.java:63) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.sejmngram.database.fetcher.connection.MySqlDbConnector.retrieve(MySqlDbConnector.java:56) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.example.helloworld.factory.NgramProvider.generateNgramResponse(NgramProvider.java:49) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.example.helloworld.resources.DemoNgramResource.sayHello(DemoNgramResource.java:48) ~[rest-server.jar:1.0-SNAPSHOT]
! at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) ~[na:na]
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_51]
! at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_51]
! at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.yammer.metrics.jersey.InstrumentedResourceMethodDispatchProvider$TimedRequestDispatcher.dispatch(InstrumentedResourceMethodDispatchProvider.java:32) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.yammer.dropwizard.jersey.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.ResourceObjectRule.accept(ResourceObjectRule.java:100) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511) [rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442) [rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) [rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) [rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) [rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) [rest-server.jar:1.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) [rest-server.jar:1.0-SNAPSHOT]
! at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1448) [rest-server.jar:1.0-SNAPSHOT]
! at com.yammer.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:29) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [rest-server.jar:1.0-SNAPSHOT]
! at com.yammer.metrics.jetty.InstrumentedHandler.handle(InstrumentedHandler.java:200) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.GzipHandler.handle(GzipHandler.java:264) [rest-server.jar:1.0-SNAPSHOT]
! at com.yammer.dropwizard.jetty.BiDiGzipHandler.handle(BiDiGzipHandler.java:123) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.Server.handle(Server.java:368) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:942) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:640) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.server.nio.BlockingChannelConnector$BlockingChannelEndPoint.run(BlockingChannelConnector.java:298) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) [rest-server.jar:1.0-SNAPSHOT]
! at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) [rest-server.jar:1.0-SNAPSHOT]
! at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51]
Caused by: ! com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
! at sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source) ~[na:na]
! at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_51]
! at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_51]
! at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1304) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1296) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4514) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4479) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.ProviderEnabledConnection.prepareStatement(ProviderEnabledConnection.java:112) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.SettingsEnabledConnection.prepareStatement(SettingsEnabledConnection.java:76) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractResultQuery.prepare(AbstractResultQuery.java:230) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:297) ~[rest-server.jar:1.0-SNAPSHOT]
!... 54 common frames omitted
Caused by: ! com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 65,028,684 milliseconds ago. The last packet sent successfully to the server was 65,028,686 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.
! at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_51]
! at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_51]
! at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_51]
! at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_51]
! at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3941) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:261) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:323) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:330) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2256) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.sejmngram.database.fetcher.connection.MySqlDbConnector.queryDatabase(MySqlDbConnector.java:63) ~[rest-server.jar:1.0-SNAPSHOT]
! at org.sejmngram.database.fetcher.connection.MySqlDbConnector.retrieve(MySqlDbConnector.java:56) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.example.helloworld.factory.NgramProvider.generateNgramResponse(NgramProvider.java:49) ~[rest-server.jar:1.0-SNAPSHOT]
! at com.example.helloworld.resources.DemoNgramResource.sayHello(DemoNgramResource.java:48) ~[rest-server.jar:1.0-SNAPSHOT]
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_51]
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_51]
!... 47 common frames omitted
Caused by: ! java.net.SocketException: Broken pipe
! at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.7.0_51]
! at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113) ~[na:1.7.0_51]
! at java.net.SocketOutputStream.write(SocketOutputStream.java:159) ~[na:1.7.0_51]
! at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.7.0_51]
! at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[na:1.7.0_51]
! at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3922) ~[rest-server.jar:1.0-SNAPSHOT]
!... 63 common frames omitted
127.0.0.1 - - [24/Apr/2014:17:35:28 +0000] "GET /service/api2/ngram/aborcja HTTP/1.0" 500 1498 8 8
@tgrez tgrez added this to the full_text_search_working milestone Apr 24, 2014
@tgrez tgrez self-assigned this Apr 24, 2014
@tgrez tgrez closed this as completed in 8a44996 May 18, 2014
@siemionides siemionides reopened this May 19, 2014
@siemionides
Copy link
Collaborator

Unfortunately, it's still the case:
127.0.0.1 - - [19/May/2014:07:26:35 +0000] "GET /javascripts/diacriticsRemover.js HTTP/1.0" 304 0 1 1
0:0:0:0:0:0:0:1 - - [19/May/2014:07:26:35 +0000] "GET /javascripts/viz.js HTTP/1.0" 304 0 1 1
127.0.0.1 - - [19/May/2014:07:26:35 +0000] "GET /javascripts/gui.js HTTP/1.0" 304 0 2 2
0:0:0:0:0:0:0:1 - - [19/May/2014:07:26:35 +0000] "GET /javascripts/SmoothScroll.js HTTP/1.0" 304 0 2 2
127.0.0.1 - - [19/May/2014:07:26:35 +0000] "GET /images/maciej.png HTTP/1.0" 304 0 2 2
127.0.0.1 - - [19/May/2014:07:26:35 +0000] "GET /images/krzysiek.png HTTP/1.0" 304 0 2 2
0:0:0:0:0:0:0:1 - - [19/May/2014:07:26:35 +0000] "GET /images/michael.png HTTP/1.0" 304 0 2 2
0:0:0:0:0:0:0:1 - - [19/May/2014:07:26:35 +0000] "GET /images/michal.png HTTP/1.0" 304 0 2 2
127.0.0.1 - - [19/May/2014:07:26:35 +0000] "GET /images/tomek.png HTTP/1.0" 304 0 2 2
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 29,365,076 milliseconds ago. The last packet sent successfully to the server was 3 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3673)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4113)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324)
at org.sejmngram.database.fetcher.connection.MySqlFtsDbConnector.queryDatabase(MySqlFtsDbConnector.java:71)
at org.sejmngram.database.fetcher.connection.MySqlFtsDbConnector.retrieve(MySqlFtsDbConnector.java:57)
at com.example.helloworld.factory.NgramFTSProvider.generateNgramResponse(NgramFTSProvider.java:17)
at com.example.helloworld.resources.NgramFTSResource.sayHello(NgramFTSResource.java:31)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.yammer.metrics.jersey.InstrumentedResourceMethodDispatchProvider$TimedRequestDispatcher.dispatch(InstrumentedResourceMethodDispatchProvider.java:32)
at com.yammer.dropwizard.jersey.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceObjectRule.accept(ResourceObjectRule.java:100)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1448)
at com.yammer.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:29)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at com.yammer.metrics.jetty.InstrumentedHandler.handle(InstrumentedHandler.java:200)
at org.eclipse.jetty.server.handler.GzipHandler.handle(GzipHandler.java:264)
at com.yammer.dropwizard.jetty.BiDiGzipHandler.handle(BiDiGzipHandler.java:123)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:368)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53)
at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:942)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:640)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72)
at org.eclipse.jetty.server.nio.BlockingChannelConnector$BlockingChannelEndPoint.run(BlockingChannelConnector.java:298)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Thread.java:745)
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:3119)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3573)
... 59 more
0:0:0:0:0:0:0:1 - - [19/May/2014:07:26:37 +0000] "GET /service/api/ngramfts/deficyt HTTP/1.0" 200 56 15 15

@siemionides
Copy link
Collaborator

Here's the hint (or dozen of them) about this issue:
http://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql

@tgrez tgrez closed this as completed in fc69dfd May 19, 2014
@tgrez
Copy link
Owner Author

tgrez commented May 19, 2014

nowa próba z kompletnie nowym approachem, generalnie powinno lepiej działać.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tgrez tgrez

Labels
None yet
Projects
None yet
Milestone
full_text_search_working
Development

No branches or pull requests
2 participants
@tgrez @siemionides