Troubleshooting & Diagnostics
Common diagnostic steps, error messages, and operational guidance for MagnumDB developers.
Port 5432 is already bound by another process.
If a local PostgreSQL server instance is already running on port 5432, specify a custom port flag when starting Server Mode, e.g. cargo run --bin magnumdb --release -- --port 5433.
Data directory lock file error on database open.
MagnumDB creates a lockfile inside the path directory to prevent concurrent process writes. Ensure previous process instances have closed cleanly or remove stale lockfiles.
Syntax error near FOREIGN KEY.
MagnumDB parses FOREIGN KEY clause syntax for DDL statement validity, but referential constraints are ignored during DML execution.
Transaction rollbacks during uncommitted reads.
Under Read Committed isolation, uncommitted tuple modifications are hidden from concurrent transactions until the writer transaction executes COMMIT.