Backport critical fixes of LmdbStore to 4.x.x

[kenwenzel]

Current Behavior

Critical fixes of the LmdbStore where only merged in develop and need to be backported to 4.x.x

Expected Behavior

Cherry-pick required fixes and merge them to main.

Steps To Reproduce

No response

Version

4.3.11

Are you interested in contributing a solution yourself?

Yes

Anything else?

No response