It's strange that it's holding a schema lock, it shouldn't On Thu, Jan 12, 2017 at 3:10 PM, Matias Burak <mbu...@gmail.com> wrote:
> Just an index. > > El 12 ene. 2017, a las 11:08, Mattias Persson <matt...@neotechnology.com> > escribió: > > OK cool, and are you creating constraint or just an index? > > On Thu, Jan 12, 2017 at 2:58 PM, Matias Burak <mbu...@gmail.com> 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 <mbu...@gmail.com> >>>>> 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 neo4j+un...@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> > > > -- > Mattias Persson > Neo4j Hacker at Neo Technology > > > -- 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 neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
