mdianjun opened a new issue, #2179: URL: https://github.com/apache/age/issues/2179
**Describe the bug** When multiple clients perform merge edges concurrently, there is error reported, "sequence already exists", or "relation already exists". Here is my code: <img width="1062" alt="Image" src="https://github.com/user-attachments/assets/254a6b9a-6a09-473f-9536-54d1cb29d7a2"; /> I try to fix this issue in this PR: https://github.com/apache/age/pull/2178. But the issue still exists. **How are you accessing AGE (Command line, driver, etc.)?** - python driver **What data setup do we need to do?** **What is the necessary configuration info needed?** - [e.g. Installed PostGIS] **What is the command that caused the error?** ```python cq = f""" -- | MATCH (source:{source_node_label} {{doc_id:'{doc_id}'}}) | MATCH (target:{target_node_label} {{doc_id:'{doc_id}'}}) | WITH source, target | MERGE (source)-[r:DIRECTED]->(target) | SET {set_properties} | RETURN r | """ | query = sql.SQL( | f"SELECT * FROM cypher('{self.graph_name}', $$ {cq} $$) as (result agtype)" | ) ``` ``` ERROR: sequence already exists # or relation already exists ``` **Expected behavior** A clear and concise description of what you expected to happen. **Environment (please complete the following information):** - Version: [e.g. 0.4.0] **Additional context** Add any other context about the problem here. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
