============================================================
RESTIC GESAMTPRÜFUNG
Start: 2026-08-13T18:45:54+00:00
============================================================
=== 1. SNAPSHOT-LISTE ===
ID Time Host Tags Paths
----------------------------------------------------------------------------------------------------------------------------------
cbca7e22 2026-08-13 12:09:45 ubuntu obsidian /opt/obsidian-vault
bba732f7 2026-08-13 12:17:50 ubuntu cron /var/lib/hermes/carlo/cron/jobs.json
34aaf8c8 2026-08-13 12:20:10 ubuntu kanban /tmp/restic-stage/kanban/kanban.db
13c7bb0e 2026-08-13 12:24:14 ubuntu sma /tmp/restic-stage/sma/signals.db
4d052153 2026-08-13 12:27:02 ubuntu n8n /tmp/restic-stage/n8n/database.sqlite
/var/lib/docker/volumes/n8n_n8n_data/_data/config
/var/lib/docker/volumes/n8n_n8n_data/_data/nodes/package.json
8f1d4f17 2026-08-13 12:42:31 ubuntu graphiti /opt/struktur/graphiti/request-data/processing-events.jsonl
/opt/struktur/graphiti/request-data/requests.db
/tmp/restic-stage/graphiti/neo4j.dump
95a57838 2026-08-13 12:54:22 ubuntu mirofish /tmp/restic-stage/mirofish/neo4j.dump
/tmp/restic-stage/mirofish/uploads
43070023 2026-08-13 13:01:21 ubuntu couchdb /tmp/restic-stage/couchdb/obsidian-carlo.json
/tmp/restic-stage/couchdb/obsidian-cm.json
56ca305d 2026-08-13 13:04:27 ubuntu vento /tmp/restic-stage/vento/vento.db
aaea505e 2026-08-13 13:17:51 ubuntu lead-engine /tmp/restic-stage/lead-engine
11fb7f73 2026-08-13 14:52:01 ubuntu hermes-skills /tmp/restic-stage/hermes-skills
4c2c3db3 2026-08-13 15:13:30 ubuntu hermes-prompts-scripts /tmp/restic-stage/hermes-prompts-scripts
6f84f8e7 2026-08-13 15:22:07 ubuntu hermes-workstates /tmp/restic-stage/hermes-workstates
e017a3f4 2026-08-13 15:34:30 ubuntu knowledge-databases /tmp/restic-stage/knowledge-databases
dc37c090 2026-08-13 16:21:22 ubuntu project-core /tmp/restic-stage/project-core
eb5d2561 2026-08-13 16:23:11 ubuntu courses /opt/struktur/ki-kurse
/opt/struktur/kurse
e35f24e5 2026-08-13 17:26:43 ubuntu social-media /opt/struktur/social-media-agent
/opt/struktur/social-media-agent-v2
/opt/struktur/social-media-radar
abb6bfb9 2026-08-13 17:37:18 ubuntu research-apps /tmp/restic-stage/research-apps
3b95c8b7 2026-08-13 17:50:25 ubuntu reports-reference /tmp/restic-stage/reports-reference
a6ed70a1 2026-08-13 17:57:22 ubuntu worker-watcher /tmp/restic-stage/worker-watcher
42a2b280 2026-08-13 18:03:39 ubuntu solar-wirtschaftlichkeit /tmp/restic-stage/solar-wirtschaftlichkeit
b054da41 2026-08-13 18:04:11 ubuntu telefon-agent /opt/struktur/telefon-agent
feff007a 2026-08-13 18:04:41 ubuntu the-donna /opt/struktur/the-donna
45100dc8 2026-08-13 18:36:19 ubuntu vps-admin-reference /tmp/restic-stage/vps-admin-reference
----------------------------------------------------------------------------------------------------------------------------------
24 snapshots
=== 2. RESTIC REPOSITORY CHECK --read-data ===
using temporary cache in /tmp/restic-check-cache-1303923699
create exclusive lock for repository
load indexes
check all packs
check snapshots, trees and blobs
[0:18] 100.00% 24 / 24 snapshots
read all data
[10:58] 100.00% 121 / 121 packs
no errors were found
[OK] Restic Repository inklusive gespeicherter Datenblöcke
=== 3. ALLE SNAPSHOTS RESTAURIEREN ===
--- worker-watcher / a6ed70a1 ---
restoring <Snapshot a6ed70a1 of [/tmp/restic-stage/worker-watcher] at 2026-08-13 17:57:22.857009352 +0000 UTC by root@ubuntu> to /tmp/restic-verify/worker-watcher
Summary: Restored 77 files/dirs (782.618 MiB) in 0:14
[OK] worker-watcher restauriert: 62 Dateien, 820634078 Bytes
--- sma / 13c7bb0e ---
restoring <Snapshot 13c7bb0e of [/tmp/restic-stage/sma/signals.db] at 2026-08-13 12:24:14.264699645 +0000 UTC by root@ubuntu> to /tmp/restic-verify/sma
Summary: Restored 4 files/dirs (7.137 MiB) in 0:01
[OK] sma restauriert: 1 Dateien, 7483392 Bytes
--- mirofish / 95a57838 ---
restoring <Snapshot 95a57838 of [/tmp/restic-stage/mirofish/neo4j.dump /tmp/restic-stage/mirofish/uploads] at 2026-08-13 12:54:22.201143727 +0000 UTC by root@ubuntu> to /tmp/restic-verify/mirofish
Summary: Restored 127 files/dirs (2.298 MiB) in 0:00
[OK] mirofish restauriert: 86 Dateien, 2409422 Bytes
--- courses / eb5d2561 ---
restoring <Snapshot eb5d2561 of [/opt/struktur/kurse /opt/struktur/ki-kurse] at 2026-08-13 16:23:11.80604295 +0000 UTC by root@ubuntu> to /tmp/restic-verify/courses
Summary: Restored 436 files/dirs (963.282 MiB) in 7:46
[OK] courses restauriert: 330 Dateien, 1010074065 Bytes
--- n8n / 4d052153 ---
restoring <Snapshot 4d052153 of [/tmp/restic-stage/n8n/database.sqlite /var/lib/docker/volumes/n8n_n8n_data/_data/config /var/lib/docker/volumes/n8n_n8n_data/_data/nodes/package.json] at 2026-08-13 12:27:02.641054 +0000 UTC by root@ubuntu> to /tmp/restic-verify/n8n
Summary: Restored 13 files/dirs (1.859 MiB) in 0:00
[OK] n8n restauriert: 3 Dateien, 1949824 Bytes
--- graphiti / 8f1d4f17 ---
restoring <Snapshot 8f1d4f17 of [/tmp/restic-stage/graphiti/neo4j.dump /opt/struktur/graphiti/request-data/processing-events.jsonl /opt/struktur/graphiti/request-data/requests.db] at 2026-08-13 12:42:31.0962247 +0000 UTC by root@ubuntu> to /tmp/restic-verify/graphiti
Summary: Restored 10 files/dirs (115.397 MiB) in 0:54
[OK] graphiti restauriert: 3 Dateien, 121002531 Bytes
--- obsidian / cbca7e22 ---
restoring <Snapshot cbca7e22 of [/opt/obsidian-vault] at 2026-08-13 12:09:45.708638502 +0000 UTC by root@ubuntu> to /tmp/restic-verify/obsidian
Summary: Restored 2314 files/dirs (27.308 MiB) in 0:05
[OK] obsidian restauriert: 2181 Dateien, 28634835 Bytes
--- kanban / 34aaf8c8 ---
restoring <Snapshot 34aaf8c8 of [/tmp/restic-stage/kanban/kanban.db] at 2026-08-13 12:20:10.269399532 +0000 UTC by root@ubuntu> to /tmp/restic-verify/kanban
Summary: Restored 4 files/dirs (148.000 KiB) in 0:00
[OK] kanban restauriert: 1 Dateien, 151552 Bytes
--- project-core / dc37c090 ---
restoring <Snapshot dc37c090 of [/tmp/restic-stage/project-core] at 2026-08-13 16:21:22.816130726 +0000 UTC by root@ubuntu> to /tmp/restic-verify/project-core
Summary: Restored 99 files/dirs (235.964 MiB) in 0:16
[OK] project-core restauriert: 93 Dateien, 247426507 Bytes
--- cron / bba732f7 ---
restoring <Snapshot bba732f7 of [/var/lib/hermes/carlo/cron/jobs.json] at 2026-08-13 12:17:50.203232478 +0000 UTC by root@ubuntu> to /tmp/restic-verify/cron
Summary: Restored 6 files/dirs (11.294 KiB) in 0:00
[OK] cron restauriert: 1 Dateien, 11565 Bytes
--- the-donna / feff007a ---
restoring <Snapshot feff007a of [/opt/struktur/the-donna] at 2026-08-13 18:04:41.492952625 +0000 UTC by root@ubuntu> to /tmp/restic-verify/the-donna
Summary: Restored 139 files/dirs (11.781 MiB) in 0:06
[OK] the-donna restauriert: 117 Dateien, 12353046 Bytes
--- vento / 56ca305d ---
restoring <Snapshot 56ca305d of [/tmp/restic-stage/vento/vento.db] at 2026-08-13 13:04:27.969967326 +0000 UTC by root@ubuntu> to /tmp/restic-verify/vento
Summary: Restored 4 files/dirs (72.000 KiB) in 0:00
[OK] vento restauriert: 1 Dateien, 73728 Bytes
--- hermes-prompts-scripts / 4c2c3db3 ---
restoring <Snapshot 4c2c3db3 of [/tmp/restic-stage/hermes-prompts-scripts] at 2026-08-13 15:13:30.186298145 +0000 UTC by root@ubuntu> to /tmp/restic-verify/hermes-prompts-scripts
Summary: Restored 39 files/dirs (256.585 KiB) in 0:00
[OK] hermes-prompts-scripts restauriert: 32 Dateien, 262743 Bytes
--- knowledge-databases / e017a3f4 ---
restoring <Snapshot e017a3f4 of [/tmp/restic-stage/knowledge-databases] at 2026-08-13 15:34:30.506981115 +0000 UTC by root@ubuntu> to /tmp/restic-verify/knowledge-databases
Summary: Restored 5 files/dirs (1.094 GiB) in 1:09
[OK] knowledge-databases restauriert: 2 Dateien, 1174421504 Bytes
--- reports-reference / 3b95c8b7 ---
restoring <Snapshot 3b95c8b7 of [/tmp/restic-stage/reports-reference] at 2026-08-13 17:50:25.538741996 +0000 UTC by root@ubuntu> to /tmp/restic-verify/reports-reference
Summary: Restored 125 files/dirs (5.909 MiB) in 0:02
[OK] reports-reference restauriert: 120 Dateien, 6196294 Bytes
--- hermes-skills / 11fb7f73 ---
restoring <Snapshot 11fb7f73 of [/tmp/restic-stage/hermes-skills] at 2026-08-13 14:52:01.578380592 +0000 UTC by root@ubuntu> to /tmp/restic-verify/hermes-skills
Summary: Restored 42 files/dirs (89.310 KiB) in 0:00
[OK] hermes-skills restauriert: 21 Dateien, 91453 Bytes
--- hermes-workstates / 6f84f8e7 ---
restoring <Snapshot 6f84f8e7 of [/tmp/restic-stage/hermes-workstates] at 2026-08-13 15:22:07.995020088 +0000 UTC by root@ubuntu> to /tmp/restic-verify/hermes-workstates
Summary: Restored 112 files/dirs (174.138 KiB) in 0:00
[OK] hermes-workstates restauriert: 59 Dateien, 178317 Bytes
--- telefon-agent / b054da41 ---
restoring <Snapshot b054da41 of [/opt/struktur/telefon-agent] at 2026-08-13 18:04:11.793847503 +0000 UTC by root@ubuntu> to /tmp/restic-verify/telefon-agent
Summary: Restored 257 files/dirs (329.449 KiB) in 0:00
[OK] telefon-agent restauriert: 153 Dateien, 337356 Bytes
--- vps-admin-reference / 45100dc8 ---
restoring <Snapshot 45100dc8 of [/tmp/restic-stage/vps-admin-reference] at 2026-08-13 18:36:19.017738876 +0000 UTC by root@ubuntu> to /tmp/restic-verify/vps-admin-reference
Summary: Restored 39 files/dirs (2.071 MiB) in 0:00
[OK] vps-admin-reference restauriert: 20 Dateien, 2172061 Bytes
--- lead-engine / aaea505e ---
restoring <Snapshot aaea505e of [/tmp/restic-stage/lead-engine] at 2026-08-13 13:17:51.983767616 +0000 UTC by root@ubuntu> to /tmp/restic-verify/lead-engine
Summary: Restored 51 files/dirs (1.190 MiB) in 0:01
[OK] lead-engine restauriert: 45 Dateien, 1247378 Bytes
--- couchdb / 43070023 ---
restoring <Snapshot 43070023 of [/tmp/restic-stage/couchdb/obsidian-carlo.json /tmp/restic-stage/couchdb/obsidian-cm.json] at 2026-08-13 13:01:21.322435329 +0000 UTC by root@ubuntu> to /tmp/restic-verify/couchdb
Summary: Restored 5 files/dirs (5.464 MiB) in 0:01
[OK] couchdb restauriert: 2 Dateien, 5729799 Bytes
--- social-media / e35f24e5 ---
restoring <Snapshot e35f24e5 of [/opt/struktur/social-media-radar /opt/struktur/social-media-agent /opt/struktur/social-media-agent-v2] at 2026-08-13 17:26:43.42496893 +0000 UTC by root@ubuntu> to /tmp/restic-verify/social-media
Summary: Restored 2742 files/dirs (47.546 MiB) in 0:13
[OK] social-media restauriert: 2374 Dateien, 49855575 Bytes
--- research-apps / abb6bfb9 ---
restoring <Snapshot abb6bfb9 of [/tmp/restic-stage/research-apps] at 2026-08-13 17:37:18.506955088 +0000 UTC by root@ubuntu> to /tmp/restic-verify/research-apps
Summary: Restored 279 files/dirs (153.484 MiB) in 0:25
[OK] research-apps restauriert: 260 Dateien, 160939816 Bytes
--- solar-wirtschaftlichkeit / 42a2b280 ---
restoring <Snapshot 42a2b280 of [/tmp/restic-stage/solar-wirtschaftlichkeit] at 2026-08-13 18:03:39.012422714 +0000 UTC by root@ubuntu> to /tmp/restic-verify/solar-wirtschaftlichkeit
Summary: Restored 26 files/dirs (242.924 KiB) in 0:00
[OK] solar-wirtschaftlichkeit restauriert: 18 Dateien, 248754 Bytes
=== 4. SQLITE-INTEGRITÄT ===
[OK] SQLite: /tmp/restic-verify/research-apps/tmp/restic-stage/research-apps/content-extraction/data/content_extraction.db
[OK] SQLite: /tmp/restic-verify/research-apps/tmp/restic-stage/research-apps/youtube-research/youtube_research_backup_before_whisper_backfill_20260620_123934.sqlite
[OK] SQLite: /tmp/restic-verify/research-apps/tmp/restic-stage/research-apps/youtube-research/youtube_research_backup_before_transcript_migration_20260620_120810.sqlite
[OK] SQLite: /tmp/restic-verify/research-apps/tmp/restic-stage/research-apps/youtube-research/youtube_research_backup_before_transcript_migration_20260531_163821.sqlite
[OK] SQLite: /tmp/restic-verify/graphiti/opt/struktur/graphiti/request-data/requests.db
[OK] SQLite: /tmp/restic-verify/project-core/tmp/restic-stage/project-core/knowledge-curator/review-backlog-analysis.db
[OK] SQLite: /tmp/restic-verify/project-core/tmp/restic-stage/project-core/knowledge-curator/minimal-human-review.db
[OK] SQLite: /tmp/restic-verify/project-core/tmp/restic-stage/project-core/knowledge-curator/review_pilot.db
[OK] SQLite: /tmp/restic-verify/solar-wirtschaftlichkeit/tmp/restic-stage/solar-wirtschaftlichkeit/data/solar.sqlite
[OK] SQLite: /tmp/restic-verify/solar-wirtschaftlichkeit/tmp/restic-stage/solar-wirtschaftlichkeit/tests/test.sqlite
[OK] SQLite: /tmp/restic-verify/n8n/tmp/restic-stage/n8n/database.sqlite
[OK] SQLite: /tmp/restic-verify/social-media/opt/struktur/social-media-agent/db/posts.db
[OK] SQLite: /tmp/restic-verify/social-media/opt/struktur/social-media-agent/cases.db
[OK] SQLite: /tmp/restic-verify/social-media/opt/struktur/social-media-radar/signals/radar.db
[OK] SQLite: /tmp/restic-verify/social-media/opt/struktur/social-media-agent-v2/db/data.sqlite
[OK] SQLite: /tmp/restic-verify/lead-engine/tmp/restic-stage/lead-engine/email_agent.db
[OK] SQLite: /tmp/restic-verify/lead-engine/tmp/restic-stage/lead-engine/email_agent_portier_backup_20260513.db
[OK] SQLite: /tmp/restic-verify/kanban/tmp/restic-stage/kanban/kanban.db
[OK] SQLite: /tmp/restic-verify/mirofish/tmp/restic-stage/mirofish/uploads/simulations/sim_f2c0eeea4d4b/reddit_simulation.db
[OK] SQLite: /tmp/restic-verify/mirofish/tmp/restic-stage/mirofish/uploads/simulations/sim_f2c0eeea4d4b/twitter_simulation.db
[OK] SQLite: /tmp/restic-verify/mirofish/tmp/restic-stage/mirofish/uploads/simulations/sim_56bb0b9c4afb/reddit_simulation.db
[OK] SQLite: /tmp/restic-verify/mirofish/tmp/restic-stage/mirofish/uploads/simulations/sim_56bb0b9c4afb/twitter_simulation.db
[OK] SQLite: /tmp/restic-verify/vento/tmp/restic-stage/vento/vento.db
[OK] SQLite: /tmp/restic-verify/sma/tmp/restic-stage/sma/signals.db
[OK] SQLite: /tmp/restic-verify/worker-watcher/tmp/restic-stage/worker-watcher/data/watcher.sqlite
[OK] SQLite: /tmp/restic-verify/knowledge-databases/tmp/restic-stage/knowledge-databases/knowledge-pipeline.db
[OK] SQLite: /tmp/restic-verify/knowledge-databases/tmp/restic-stage/knowledge-databases/youtube-research-knowledge.db
SQLite-Datenbanken erkannt: 27
SQLite-Fehler: 0
=== 5. JSON-EXPORTS / REFERENZDATEIEN ===
JSON/JSONL-Dateien geprüft: 179
JSON-Warnungen: 0
=== 6. NEO4J-DUMPS ===
--- Graphiti ---
-rw-r--r-- 1 7474 7474 114M Aug 13 12:33 /tmp/restic-verify/graphiti/tmp/restic-stage/graphiti/neo4j.dump
Database: neo4j
Format: Neo4j ZSTD Dump.
Files: 106
Bytes: 698381915
[OK] Graphiti Neo4j-Dump wird von neo4j-admin erkannt
--- MiroFish ---
-rw-r--r-- 1 7474 7474 47K Aug 13 12:49 /tmp/restic-verify/mirofish/tmp/restic-stage/mirofish/neo4j.dump
Database: neo4j
Format: Neo4j ZSTD Dump.
Files: 57
Bytes: 270679770
[OK] MiroFish Neo4j-Dump wird von neo4j-admin erkannt
=== 7. SPEZIELLE PFLICHTDATEIEN ===
[OK] Cron jobs.json vorhanden
[OK] Kanban kanban.db vorhanden
[OK] SMA signals.db vorhanden
[OK] n8n database.sqlite vorhanden
[OK] YouTube Knowledge DB vorhanden
[OK] Knowledge Pipeline DB vorhanden
[OK] Worker Watcher DB vorhanden
[OK] Solar DB vorhanden
=== 8. GESAMTERGEBNIS ===
Ende: 2026-08-13T19:11:45+00:00
FEHLER: 0
WARNUNGEN:0
GESAMTSTATUS: OK
Bericht: /root/restic-verification-2026-08-13.txt
Restore-Verzeichnis: /tmp/restic-verify
============================================================