Transactionfailure issue

Neo4j Graph Platform
1

Hi all,
I am trying to run a query
CALL apoc.periodic.iterate(
"MATCH (row:Landing) WHERE row.id is null RETURN row",
"delete row",
{batchSize:1000,iterateList:true,parallel:false});

but it seems this query is erroring out with the below error
"2024-02-12T10:31:50"
batches, total, timeTaken, committedOperations, failedOperations, failedBatches, retries, errorMessages, batch, operations, wasTerminated, failedParams
1, 21, 246, 0, 0, 1, 0, {}, {total: 1, committed: 0, failed: 1, errors: {org.neo4j.graphdb.TransactionFailureException: Transaction was marked as successful, but unable to commit transaction so rolled back.: 1}}, {total: 21, committed: 0, failed: 0, errors: {}}, FALSE, {}

I am unable to guess the reason so.

2

Do these nodes have relationships? If so, change to detach delete row

3

No they don't have any relationships. I am using 3.5v

4

It’s difficult to identify, since you are using a very old version that is no longer supported.

Let’s go back to basics to see if we can learn something that may help.

Can you run this several times? Does it work?

MATCH (row:Landing) 
WHERE row.id is null 
WITH row
LIMIT 1000
DELETE row