Hi, we are trying to use neo4j to improve performance of relation database for queries. we insert 5m nodes to database.
and when we execute queries like that match (s:SalesInformation) //where s.week = 7 return s.year, s.week there is no response for a few hours. same qusery with sql server. response time is 46 sec. i change memory configuration like that neostore.nodestore.db.mapped_memory=100M neostore.relationshipstore.db.mapped_memory=800M neostore.propertystore.db.mapped_memory=500M neostore.propertystore.db.strings.mapped_memory=230M neostore.propertystore.db.arrays.mapped_memory=230M wrapper.java.initmemory=512 wrapper.java.maxmemory=1024 but still no response. in log files: Apr 14, 2014 3:35:37 PM com.sun.jersey.server.impl.application.WebApplicationImpl _handleRequest SEVERE: The response of the WebApplicationException cannot be utilized as the response is already committed. Re-throwing to the HTTP container javax.ws.rs.WebApplicationException: javax.ws.rs.WebApplicationException: org.eclipse.jetty.io.EofException at org.neo4j.server.rest.repr.OutputFormat$1.write(OutputFormat.java:174) at com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:71) at com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:57) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1437) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:698) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1506) at org.neo4j.server.rest.security.SecurityFilter.doFilter(SecurityFilter.java:112) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1477) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:211) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1096) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:432) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:175) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1030) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:136) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:445) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:268) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:229) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.run(AbstractConnection.java:358) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:601) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:532) at java.lang.Thread.run(Unknown Source) Caused by: javax.ws.rs.WebApplicationException: org.eclipse.jetty.io.EofException at org.neo4j.server.rest.repr.formats.StreamingJsonFormat$StreamingRepresentationFormat.flush(StreamingJsonFormat.java:401) at org.neo4j.server.rest.repr.formats.StreamingJsonFormat$StreamingRepresentationFormat.complete(StreamingJsonFormat.java:389) at org.neo4j.server.rest.repr.MappingRepresentation.serialize(MappingRepresentation.java:43) at org.neo4j.server.rest.repr.OutputFormat$1.write(OutputFormat.java:160) ... 30 more Caused by: org.eclipse.jetty.io.EofException at org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:186) at org.eclipse.jetty.io.WriteFlusher.write(WriteFlusher.java:335) at org.eclipse.jetty.io.AbstractEndPoint.write(AbstractEndPoint.java:125) at org.eclipse.jetty.server.HttpConnection$ContentCallback.process(HttpConnection.java:784) at org.eclipse.jetty.util.IteratingCallback.iterate(IteratingCallback.java:79) at org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:356) at org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:631) at org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:661) at org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:151) at com.sun.jersey.spi.container.servlet.WebComponent$Writer.flush(WebComponent.java:315) at com.sun.jersey.spi.container.ContainerResponse$CommittingOutputStream.flush(ContainerResponse.java:145) at org.codehaus.jackson.impl.Utf8Generator.flush(Utf8Generator.java:1091) at org.neo4j.server.rest.repr.formats.StreamingJsonFormat$StreamingRepresentationFormat.flush(StreamingJsonFormat.java:397) ... 33 more Caused by: java.io.IOException: An established connection was aborted by the software in your host machine at sun.nio.ch.SocketDispatcher.writev0(Native Method) at sun.nio.ch.SocketDispatcher.writev(Unknown Source) at sun.nio.ch.IOUtil.write(Unknown Source) at sun.nio.ch.SocketChannelImpl.write(Unknown Source) at org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:167) ... 45 more in messafe log: 2014-04-14 12:15:35.611+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 114ms [total block time: 0.114s] 2014-04-14 12:16:40.915+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3229ms [total block time: 3.343s] 2014-04-14 12:16:42.030+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 113ms [total block time: 3.456s] 2014-04-14 12:16:47.983+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3444ms [total block time: 6.9s] 2014-04-14 12:16:49.117+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 134ms [total block time: 7.034s] 2014-04-14 12:16:55.575+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3655ms [total block time: 10.689s] 2014-04-14 12:17:02.690+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3709ms [total block time: 14.398s] 2014-04-14 12:17:03.871+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 181ms [total block time: 14.579s] 2014-04-14 12:17:08.711+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3036ms [total block time: 17.615s] 2014-04-14 12:17:09.919+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 208ms [total block time: 17.823s] 2014-04-14 12:17:14.277+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2955ms [total block time: 20.778s] 2014-04-14 12:17:19.358+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3080ms [total block time: 23.858s] 2014-04-14 12:17:25.428+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3368ms [total block time: 27.226s] 2014-04-14 12:17:27.742+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 304ms [total block time: 27.53s] 2014-04-14 12:17:32.830+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 4988ms [total block time: 32.518s] 2014-04-14 12:17:34.027+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 196ms [total block time: 32.714s] 2014-04-14 12:17:38.696+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3467ms [total block time: 36.181s] 2014-04-14 12:17:39.951+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 254ms [total block time: 36.435s] 2014-04-14 12:17:44.003+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2751ms [total block time: 39.186s] 2014-04-14 12:17:45.324+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 320ms [total block time: 39.506s] 2014-04-14 12:17:49.824+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2999ms [total block time: 42.505s] 2014-04-14 12:17:54.774+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2947ms [total block time: 45.452s] 2014-04-14 12:17:58.511+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3637ms [total block time: 49.089s] 2014-04-14 12:18:02.062+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2750ms [total block time: 51.839s] 2014-04-14 12:18:07.226+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2963ms [total block time: 54.802s] 2014-04-14 12:18:10.646+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2719ms [total block time: 57.521s] 2014-04-14 12:18:16.495+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2948ms [total block time: 60.469s] 2014-04-14 12:18:18.819+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 321ms [total block time: 60.79s] 2014-04-14 12:18:23.217+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 3898ms [total block time: 64.688s] 2014-04-14 12:18:24.411+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 193ms [total block time: 64.881s] 2014-04-14 12:18:28.712+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 2899ms [total block time: 67.78s] 2014-04-14 12:18:29.944+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC Monitor: Application threads blocked for an additional 231ms [total block time: hardware : hp folio 9479m: 4 gb ram i7 368 2.1 gz cpu. 250 gb sdd hdd. how can solve this problem? thanks -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
