Would you mind creating a GitHub issue at github.com/neo4j/neo4j sharing
your commands and error message

You didn't share the actual queries that create the ` :12356Person`.

Michael

On Fri, Apr 13, 2018 at 5:38 AM, George & Sherin <lexiafant...@gmail.com>
wrote:

> Already present Constraint create constraint on (n:Tenant) assert n.id is
> unique
>  each of this transaction contain
> Txn1
> create (n:Tenant {id:1234})
> create constraint on (n:1234Person) assert n. <http://n.id/>ssn is unique
> Txn2
> create (n:Tenant {id:12356})
> create constraint on (n:12356Person) assert n. <http://n.id/>ssn is unique
>
> Txn3
> create (n:Tenant {id:12345})
> create constraint on (n:12345Person) assert n. <http://n.id/>ssn is unique
>
> When I look at it the data in any of the transactions are not affected by
> the new constraints added in the transaction.
>
> On Thu, Apr 12, 2018 at 10:34 PM, Lexia Fantasy <lexiafant...@gmail.com>
> wrote:
>
>> Hi all,
>>
>> https://neo4j.com/developer/kb/explanation-of-error-database
>> -constraints-have-changed-txid-84-after-this-transaction-txid-81-started/
>>
>> I ran into this problem
>> I have a constraint on label Tenant  id  is unique
>>
>> create constraint on (n:Tenant) assert n.id is unique
>>
>> Now when I create a  Tenant node with with label Tenant I am trying to
>> create a new unique constraint for another sets on nodes having labels
>> tenantidPersons
>> create constraint on (n:<tenantId>Persons) assert n.ssn is unique
>>
>> I am getting the below error when I try to multiple tenants concurrently
>> where each tenant creation try to create a constraint for its persons
>>
>> org.neo4j.kernel.api.exceptions.TransactionFailureException: Database
>> constraints have changed (txId=3937) after this transaction (txId=3936)
>> started, which is not yet supported. Please retry your transaction to
>> ensure all constraints are executed
>>
>> As per the example the second constraint is only applicable for a person
>> is created in a tenant. But I get the error while creating the tenant
>> itself.
>>
>> Is this bug or expected behavior. IS the option only to retry the
>> transaction which does not sound right.
>>
>>
>> George S
>>
>>
>> --
>> 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.
>>
>
> --
> 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.
>

-- 
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.

Reply via email to