zenmemes

System State

ready

App version bd9d22d20072e804e3ba35822965fb6b46bf971c

git -C state/local_repository rev-parse HEAD

Instance

Name: zenmemes

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

Admin: ilyag , guest , test-user , 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 , 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 bd9d22d20072e804e3ba35822965fb6b46bf971c
git -C state/local_repository rev-parse HEAD
Short head bd9d22d
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 bd9d22d 2026-10-02T01:24:02-07:00 Apply thread tag like to thread-20261001051446-8e4826e6
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 13 / expected 13
SELECT value FROM metadata WHERE key = 'schema_version';
Repository head bd9d22d20072e804e3ba35822965fb6b46bf971c
SELECT value FROM metadata WHERE key = 'repository_head';
Current repository head bd9d22d20072e804e3ba35822965fb6b46bf971c
git -C state/local_repository rev-parse HEAD
Rebuilt at 2026-10-02T08:24:02+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 1319
SELECT COUNT(*) FROM posts;
Threads 697
SELECT COUNT(*) FROM threads;
Profiles 128
SELECT COUNT(*) FROM profiles;
Username routes 47
SELECT COUNT(*) FROM username_routes;
Activity rows 1614
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 123
SELECT COUNT(*) FROM profiles WHERE is_approved = 1;