Downgrade sqlite database lock warning to from warning to info level

[aman-coder03]

this change updates the logging so that these expected SQLite lock messages are shown as debug logs instead of warnings, while keeping the warning level unchanged for all other database backends.

this reduces unnecessary noise in the logs and avoids confusing users.

fixes #7112