Implement reset() for metadata adapters other than memory

Close #1934
Updated CHANGELOG