qdb

System State

ready

App version d77c1392a7ef60be264d178652cbef491f11b2d0

git -C state/local_repository rev-parse HEAD

Instance

Name: qdb

grep '^Instance-Name:' state/local_repository/records/instance/public.txt

Admin: ilyag , guest

SELECT username_token, MIN(username) AS username FROM profiles WHERE approved_by_label = 'root' GROUP BY username_token ORDER BY username_token ASC;

Repository

Repository local_repository
Repository head d77c1392a7ef60be264d178652cbef491f11b2d0
git -C state/local_repository rev-parse HEAD
Short head d77c139
git -C state/local_repository rev-parse --short HEAD
Git checkout yes
test -d state/local_repository/.git
Records directory yes
test -d state/local_repository/records
Latest commit d77c139 2026-10-31T04:04:07-07:00 Apply thread tag funny to thread-20190409174200-qdb-311668
git -C state/local_repository log -1 --format=%h%x09%cI%x09%s

Read model

Database post_index.sqlite3
Database exists yes
test -f state/cache/post_index.sqlite3
Metadata readable
SELECT key, value FROM metadata;
Schema version 39 / expected 39
SELECT value FROM metadata WHERE key = 'schema_version';
Schema fingerprint c5b0c992323d154efea37e8cdf2e97e4d93b9bff945c94017f3744ee1529f7c8 / expected c5b0c992323d154efea37e8cdf2e97e4d93b9bff945c94017f3744ee1529f7c8
SELECT value FROM metadata WHERE key = 'schema_fingerprint';
Repository head d77c1392a7ef60be264d178652cbef491f11b2d0
SELECT value FROM metadata WHERE key = 'repository_head';
Current repository head d77c1392a7ef60be264d178652cbef491f11b2d0
git -C state/local_repository rev-parse HEAD
Rebuilt at 2026-10-31T11:04:10+00:00
SELECT value FROM metadata WHERE key = 'rebuilt_at';
Rebuild reason write_incremental
SELECT value FROM metadata WHERE key = 'rebuild_reason';
Lock status unlocked
flock -n state/cache/forum-rewrite.lock -c true && echo unlocked || echo locked
Stale marker absent
test -f state/cache/read_model_stale.json
Stale reason none
grep -o ' "reason": "[^"]*"' state/cache/read_model_stale.json
Stale commit none
grep -o ' "commit_sha": "[^"]*"' state/cache/read_model_stale.json

Read-model rows

Posts 20138
SELECT COUNT(*) FROM posts;
Threads 20115
SELECT COUNT(*) FROM threads;
Profiles 5218
SELECT COUNT(*) FROM profiles;
Username routes 2
SELECT COUNT(*) FROM username_routes;
Activity rows 20276
SELECT COUNT(*) FROM activity;
Post analyses 0
SELECT COUNT(*) FROM post_analyses;
Unicode risk rows 0
SELECT COUNT(*) FROM post_unicode_risks;
Generated responses 0
SELECT COUNT(*) FROM post_generated_responses;
Approved profiles 16
SELECT COUNT(*) FROM profiles WHERE is_approved = 1;

Query viewer