Repeated data insertion failure

[awrichar]

I somehow got a FireFly node into a state where it's repeatedly attempting (and failing) to insert a piece of data. The logs have rolled since the initial occurrence, but below is one of the repeating failures. Wonder if it gives any clues as to how it got into this state, and whether it should somehow recover?

[2022-02-28T13:27:50.125Z] DEBUG SQL-> insert: INSERT INTO data (id,validator,namespace,datatype_name,datatype_version,hash,created,blob_hash,blob_public,blob_name,blob_size,value_size,value) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)  RETURNING seq dbtx=P8EocnPj pid=1 role=event-manager
[2022-02-28T13:27:50.128Z] ERROR SQL insert failed (conflictEmptyRequested=false): pq: duplicate key value violates unique constraint "data_id" sql=[ INSERT INTO data (id,validator,namespace,datatype_name,datatype_version,hash,created,blob_hash,blob_public,blob_name,blob_size,value_size,value) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)  RETURNING seq ]: pq: duplicate key value violates unique constraint "data_id" dbtx=P8EocnPj pid=1 role=event-manager
[2022-02-28T13:27:50.128Z] DEBUG SQL-> query: SELECT hash FROM data WHERE id = $1 dbtx=P8EocnPj pid=1 role=event-manager
[2022-02-28T13:27:50.129Z] ERROR SQL query failed: pq: current transaction is aborted, commands ignored until end of transaction block sql=[ SELECT hash FROM data WHERE id = $1 ] dbtx=P8EocnPj pid=1 role=event-manager
[2022-02-28T13:27:50.129Z] ERROR Failed to insert data entry 0 in batch 'fc013516-85c4-47ec-ae14-70474119205d': FF10115: Database query failed: pq: current transaction is aborted, commands ignored until end of transaction block dbtx=P8EocnPj pid=1 role=event-manager
[2022-02-28T13:27:50.130Z]  WARN SQL! transaction rollback dbtx=P8EocnPj pid=1 role=event-manager
[2022-02-28T13:27:50.130Z] ERROR persist batch attempt 30898: FF10115: Database query failed: pq: current transaction is aborted, commands ignored until end of transaction block pid=1 role=event-manager