Just an index. > El 12 ene. 2017, a las 11:08, Mattias Persson <[email protected]> > escribió: > > OK cool, and are you creating constraint or just an index? > > On Thu, Jan 12, 2017 at 2:58 PM, Matias Burak <[email protected] > <mailto:[email protected]>> wrote: > Hi Mattias, it looks like it, this is the kind of exceptions we are getting: > > org.springframework.transaction.HeuristicCompletionException: Heuristic > completion: outcome state is rolled back; nested exception is > org.neo4j.driver.v1.exceptions.TransientException: LockClient[7068] can't > wait on resource RWLock[SCHEMA(0), hash=192551521] since => LockClient[7068] > <-[:HELD_BY]- RWLock[SCHEMA(0), hash=192551521] <-[:WAITING_FOR]- > LockClient[5626] <-[:HELD_BY]- RWLock[SCHEMA(0), hash=192551521] > > > El jueves, 12 de enero de 2017, 3:39:54 (UTC-3), Mattias Persson escribió: > CREATE INDEX shouldn't keep a schema lock during the duration of population > of the index. Is that what you're seeing here? > > Perhaps are you creating constraints? > > On Wednesday, January 11, 2017 at 9:07:42 PM UTC+1, Matias Burak wrote: > Hi Michael, we might have a lot of operations running at the same time, like > CREATE, MERGE and some might write thousands of records in a single > transaction. There can be several concurrent of these but i guess not more > than 5...10 at most. And yes, they might be creating/updating nodes for that > label. > > El miércoles, 11 de enero de 2017, 15:56:57 (UTC-3), Michael Hunger escribió: > Matias, > > can you describe the other kinds of queries that are running (reads, writes, > do they also touch the :User label?) how many of them and how concurrent? > > Michael > > On Tue, Jan 10, 2017 at 11:32 PM, Matias Burak <[email protected] <>> wrote: > Hi guys, > > Is there a way to create indexes safely while running an application? > We need to create indexes on a remote Neo4j server dinamically while the > system is running, so it might be doing other calls to Neo4j server. > Right now we create them by running a query like "CREATE INDEX ON > :User(name)" but that is looking the whole database, and sometimes we are > getting deadlocks and eventually the server stops responding. > > Is there something we can do to avoid this behavior? > We are running the latest 3.1 version. > > Thanks, > Matias. > > -- > 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 > <https://groups.google.com/d/optout>. > > > > > -- > Mattias Persson > Neo4j Hacker at Neo Technology
-- 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.
