Status: IN
At most one file descriptor is open for WAL writes at any time; `_rotate` closes the old fd before opening the new one.
Source: entries/2026/05/29/write-ahead-log-wal-_rotate.md
self._fd = open(self._current_file, "ab")
# single file descriptor, all writes go through self._fd