Worried... Can I change to "Smart Backup Retention" after a year of "Keep all backups"?

A seemingly rare failure. Four forum reports, one solved:

[SOLVED] SQLite error cannot rollback - no transaction is active (NAS)

Please check free space on all partitions, e.g. using df -k.

Normal. You get one entry every time anything happens with a remote file.
Recreate does lots of downloads (Get), of mostly dindex (duplicati-i*).
If it does many dblocks (duplicati-b*) or repeats a file, that’s significant.