Sure will do that later today or tommorow
On Sat, Apr 14, 2018 at 5:52 PM, 'Michael Hunger' via Neo4j < neo4j@googlegroups.com> wrote: > 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. > -- 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.