System State
ready
Instance
Name: zenmemes
grep '^Instance-Name:' state/local_repository/records/instance/public.txtAdmin: ilyag , guest , test-user , claude , chatgpt , onthebus , chrome , win10 , mouse , nicenice , sasha , pathdowntothewater , ak , bhavna_boo , j , lila , testingwithchrome , paul , shoesoffbytheriver , andrew-test , cia , console.log-hello , guest2 , iilyag , lucas , mitbtchax , mykull , notenoughentropy , ppsqqk , release-check , release-check-20261001184219 , release-check-20261001184516 , rishi , scj643 , testingwithsafari , zentest , zurcd , reply-agent , gabe-m , righter , gojosatoru , ilag , marlene_louisa , or-1-1 , owen-karmel , owijeowij , reedo321 , rumeza , teddy
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 |
f37cfc3ea404059fce4859bd5fa68928cab66522
git -C state/local_repository rev-parse HEAD |
| Short head |
f37cfc3
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 |
f37cfc3 2026-10-27T15:51:44-07:00 Issue invitation invite-ed1da6570152f1a39b449997 by openpgp:b2d12875604b3844b7dd79695f7410d23f1c777b
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 |
31 / expected 31
SELECT value FROM metadata WHERE key = 'schema_version';
|
| Schema fingerprint |
117496140c88e3530843019983c30f12b653f838eff6fc1dc8c63f24fb1370d2 / expected 117496140c88e3530843019983c30f12b653f838eff6fc1dc8c63f24fb1370d2
SELECT value FROM metadata WHERE key = 'schema_fingerprint';
|
| Repository head |
f37cfc3ea404059fce4859bd5fa68928cab66522
SELECT value FROM metadata WHERE key = 'repository_head';
|
| Current repository head |
f37cfc3ea404059fce4859bd5fa68928cab66522
git -C state/local_repository rev-parse HEAD |
| Rebuilt at |
2026-10-27T22:51:44+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 |
1773
SELECT COUNT(*) FROM posts;
|
|---|---|
| Threads |
925
SELECT COUNT(*) FROM threads;
|
| Profiles |
163
SELECT COUNT(*) FROM profiles;
|
| Username routes |
54
SELECT COUNT(*) FROM username_routes;
|
| Activity rows |
2167
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 |
152
SELECT COUNT(*) FROM profiles WHERE is_approved = 1;
|