Data loss after db restore - now, those lost properties can't be updated anymore

Neo4j Graph Platform Server
, ,
1

Hi there,

after a restore of our 4.4.2 database to our test-db, we noticed that many previously filled properties are filled with EmptyString, but not all properties of a label, only a few. That effect is spreaded randomly over several labels and several properties. When trying to update these properties with the original or some other values again, the following error occurs:

Neo4j.DatabaseError.Transaction.TransactionCommitFailed
Unable to complete transaction

This happens even with very simple commands such as e.g.

MATCH (u:User) WHERE (u.Id = "074c09a6-fac2-4496-a6d3-b16efa77df36")
SET u.CreateDateUtc = null

The only change we made yesterday was to increase the disk size in our Azure instance. But there were no errors right after that, they occurred today after the restore.

What could have happened and how can it be solved?

Best,
Reiner

2

UPDATE: After re-restoring the same backup, the problem disappeared and all data is filled like before - but strange anyways.

3

Debug logs would hold clues, but as a blind guess, perhaps some permissions or ownership was off in the restored files, though we would have expected more of a "db doesn't start up at all" situation rather than something piecemeal.