[Neo4j] Problem with graph.db

[gustavoboby]

Hi guy's,

I have a problem when i trie to execute the query above:

http> POST /db/data/cypher { "query": "start x =
node:index_padrao(Tipo='Perfil') WHERE x.Email AND
x.Email='luiz....@grupoec.com.br' return x" }

The exception:

==> 400 Bad Request
==> {
==> "message" : "Position[19500176] requested for high id[19449875],
store is ok[true] recovery[false]",
==> "exception" :
"org.neo4j.kernel.impl.nioneo.store.InvalidRecordException:
Position[19500176] requested for high id[19449875], store is ok[true]
recovery[false]",
==> "stacktrace" :
[ "org.neo4j.kernel.impl.nioneo.store.CommonAbstractStore.acquireWindow(CommonAbstractStore.java:
554)",
"org.neo4j.kernel.impl.nioneo.store.PropertyStore.getLightRecord(PropertyStore.java:
348)",
"org.neo4j.kernel.impl.nioneo.xa.ReadTransaction.getPropertyRecordChain(ReadTransaction.java:
184)",
"org.neo4j.kernel.impl.nioneo.xa.ReadTransaction.loadProperties(ReadTransaction.java:
214)",
"org.neo4j.kernel.impl.nioneo.xa.ReadTransaction.nodeLoadProperties(ReadTransaction.java:
238)",
"org.neo4j.kernel.impl.persistence.PersistenceManager.loadNodeProperties(PersistenceManager.java:
113)",
"org.neo4j.kernel.impl.core.NodeManager.loadProperties(NodeManager.java:
732)",
"org.neo4j.kernel.impl.core.NodeImpl.loadProperties(NodeImpl.java:
121)",
"org.neo4j.kernel.impl.core.Primitive.ensureFullProperties(Primitive.java:
569)",
"org.neo4j.kernel.impl.core.Primitive.hasProperty(Primitive.java:
293)",
"org.neo4j.kernel.impl.core.NodeProxy.hasProperty(NodeProxy.java:
150)", "org.neo4j.cypher.commands.Has.isMatch(Predicate.scala:139)",
"org.neo4j.cypher.commands.And.isMatch(Predicate.scala:43)",
"org.neo4j.cypher.internal.pipes.FilterPipe$$anonfun$createResults
$1.apply(FilterPipe.scala:29)",
"org.neo4j.cypher.internal.pipes.FilterPipe$$anonfun$createResults
$1.apply(FilterPipe.scala:29)", "scala.collection.TraversableLike$
$anonfun$filter$1.apply(TraversableLike.scala:213)",
"scala.collection.LinearSeqOptimized
$class.foreach(LinearSeqOptimized.scala:59)",
"scala.collection.immutable.List.foreach(List.scala:45)",
"scala.collection.TraversableLike$class.filter(TraversableLike.scala:
212)", "scala.collection.immutable.List.filter(List.scala:45)",
"org.neo4j.cypher.internal.pipes.FilterPipe.createResults(FilterPipe.scala:
29)",
"org.neo4j.cypher.internal.pipes.ExtractPipe.createResults(ExtractPipe.scala:
41)",
"org.neo4j.cypher.internal.pipes.ColumnFilterPipe.createResults(ColumnFilterPipe.scala:
33)", "org.neo4j.cypher.internal.ExecutionPlanImpl$$anonfun
$6.apply(ExecutionPlanImpl.scala:120)",
"org.neo4j.cypher.internal.ExecutionPlanImpl$$anonfun
$6.apply(ExecutionPlanImpl.scala:118)",
"org.neo4j.cypher.internal.ExecutionPlanImpl.execute(ExecutionPlanImpl.scala:
34)", "org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:
72)", "org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:
68)",
"org.neo4j.cypher.javacompat.ExecutionEngine.execute(ExecutionEngine.java:
73)",
"org.neo4j.server.rest.web.CypherService.cypher(CypherService.java:
71)", "sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)",
"sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)",
"sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)",
"java.lang.reflect.Method.invoke(Unknown Source)",
"com.sun.jersey.spi.container.JavaMethodInvokerFactory
$1.invoke(JavaMethodInvokerFactory.java:60)",
"com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider
$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:
205)",
"com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:
75)",
"com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:
288)",
"com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:
108)",
"com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:
147)",
"com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:
84)",
"com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:
1469)",
"com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:
1400)",
"com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:
1349)",
"com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:
1339)",
"com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:
416)",
"com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:
537)",
"com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:
699)", "javax.servlet.http.HttpServlet.service(HttpServlet.java:820)",
"org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
511)", "org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1166)",
"org.neo4j.server.statistic.StatisticFilter.doFilter(StatisticFilter.java:
62)", "org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)",
"org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
388)",
"org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)",
"org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
765)",
"org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:
114)",
"org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)", "org.mortbay.jetty.Server.handle(Server.java:326)",
"org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)", "org.mortbay.jetty.HttpConnection
$RequestHandler.content(HttpConnection.java:943)",
"org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)",
"org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)",
"org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)",
"org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
410)", "org.mortbay.thread.QueuedThreadPool
$PoolThread.run(QueuedThreadPool.java:582)" ]
==> }

I believe the problem is when i do a search by index.

I don't know if is here the better place to expose my problem, but i
need tro try =)

Thank's

Gustavo

[gustavoboby]

Anyone can help me?

On 23 fev, 16:05, gustavoboby <gustavob...@gmail.com> wrote:
> Hi guy's,
>
> I have a problem when i trie to execute the query above:
>
> http> POST /db/data/cypher { "query": "start x  =
> node:index_padrao(Tipo='Perfil') WHERE x.Email AND

> x.Email='luiz.bo...@grupoec.com.br' return x" }

[Jim Webber]

Hi Gustavo,

We'd need to see a test case that we can reproduce. Can you package a failing test (and test data) so we can see it?

Jim

[luiz gustavo bosco de oliveira]

Hi Jim,

This problem occurred in the production environment, as much as I can release the graph.db is for you, along with the query that I run that returns this exception.

if you want de graph.db i was post it on dropbox, have you account?

Att
Gustavo

[Jim Webber]

Hi Gustavo,

Hmmm, I don't really want to ask for your production data but that does give me a clue.

I don't think this necessarily indexing - the error is coming from the store layer.

What version of Neo4j are you running, and have you done anything that might have upset the store files?

Jim

[luiz gustavo bosco de oliveira]

1.6 stable version for linux, the stores are done using rest api.


I believe the server rebooted itself

--
Att.
Luiz Gustavo Bosco de Oliveira
Analista Desenvolvedor.

[Jim Webber]

Hi Gustavo,

Before we head off and explore this, can you upgrade to 1.6.1. There were some useful upgrades to the code in that release that deal with the store more sensibly.

Jim

[gustavoboby]

Hi people's,

I've fixed the problem.

There are a non existing node indexed (the node was losed, i dont know
how exactly).

I've deleted the entry on index and my graph.db it's work's again.

Thank's for help me.