********************** Windows PowerShell transcript start Start time: 20260923125013 Username: DESKTOP-DJ40RL2\Administrator RunAs User: DESKTOP-DJ40RL2\Administrator Configuration Name: Machine: DESKTOP-DJ40RL2 (Microsoft Windows NT 10.0.28000.0) Host Application: C:\WINDOWS\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy Bypass -File C:\Users\Administrator\.gemini\antigravity\scratch\ClassNotify\tests\test_rc4_backup_restore.ps1 Process ID: 15264 PSVersion: 5.1.28000.2952 PSEdition: Desktop PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.28000.2952 BuildVersion: 10.0.28000.2952 CLRVersion: 4.0.30319.42000 WSManStackVersion: 3.0 PSRemotingProtocolVersion: 2.3 SerializationVersion: 1.1.0.1 ********************** ========================================================================== ClassNotify P1 RC2 鈥?Gate RC-4C: Backup & Disaster Restore Suite Reviewer Mandate: ChatGPT Architecture Reviewer (RC-4 Approved Plan) Target RCArtifactId: P1-RC2-20260922-151442-F2C14966 Restore Evidence ID: EVIDENCE-RC4-RESTORE-20260923-125012 ========================================================================== >>> [Pre-Flight] System & Environment Baseline... [Timeline/Restore] [PRE-FLIGHT] START - Verifying authentication and baseline health [PASS] Pre-Flight: Authentication succeeded [PASS] Pre-Flight: Target Device Online >>> [1/6] Executing Production Database Backup via ops/classnotify-db-backup.sh... [Timeline/Restore] [BACKUP] START - Triggering classnotify-db-backup.sh on Tokyo VPS [Wed Sep 23 04:50:19 UTC 2026] Starting ClassNotify PostgreSQL backup... [Wed Sep 23 04:50:19 UTC 2026] Daily backup created: /var/backups/classnotify/daily/classnotify_20260923_045019.sql.gz (34071 bytes) [Wed Sep 23 04:50:19 UTC 2026] ClassNotify PostgreSQL backup completed successfully. Latest Backup File: /var/backups/classnotify/daily/classnotify_20260923_045019.sql.gz [PASS] Step 1: Production Backup Created & Integrity Verified File: classnotify_20260923_045019.sql.gz (34071 bytes), Gzip: GZIP_VALID, Duration: 3004 ms [Timeline/Restore] [BACKUP] PASS - Backup generated in 3004 ms >>> [2/6] Downloading Off-Host Backup Copy to Windows Endpoint via SCP... [Timeline/Restore] [OFFSITE-COPY] START - Downloading backup to Windows endpoint [PASS] Step 2: Off-Host Copy Downloaded & SHA256 Verified Remote: 08267DA9489CB95388300A96E184F445B6617B20A35E04523DD54AD235EBEA53, Local: 08267DA9489CB95388300A96E184F445B6617B20A35E04523DD54AD235EBEA53, DownloadMs: 5564 [Timeline/Restore] [OFFSITE-COPY] PASS - Off-host copy verified in 5564 ms >>> [3/6] Restoring Backup into Isolated Database 'classnotify_restore_rc4_20260923-125012'... [Timeline/Restore] [RESTORE-ISOLATED] START - Creating isolated database classnotify_restore_rc4_20260923-125012 [PASS] Step 3: Isolated Database Restored Live Tables: 11, Restored Tables: 11, RestoreMs: 5838 [Timeline/Restore] [RESTORE-ISOLATED] PASS - Isolated restore completed in 5838 ms >>> [4/6] Executing 4-Layer Consistency Verification (Live vs Restored)... [Timeline/Restore] [CONSISTENCY-CHECK] START - Comparing schema, row counts, canonical digests, and spot checks [PASS] Layer 1: Schema & EF Migration History 100% Identical Tables: 11, Migrations: Identical [PASS] Layer 2: Row Counts across all 10 Critical Tables 100% Equal [PASS] Layer 3: Canonical Data Digests 100% Equal [PASS] Layer 4: Target Object Spot-Check (dev_59e35e79, t_beijing_no4) Identical [Timeline/Restore] [CONSISTENCY-CHECK] PASS - All 4 layers of consistency verified with 100% match >>> [5/6] Executing Controlled Temporary DR Cutover to Restored DB... [Timeline/Restore] [DR-CUTOVER] START - Switching connection string to isolated restore DB classnotify_restore_rc4_20260923-125012 PS>TerminatingError(Invoke-RestMethod): "远程服务器返回错误: (502) 错误的网关。" PS>TerminatingError(Invoke-RestMethod): "远程服务器返回错误: (502) 错误的网关。" PS>TerminatingError(Invoke-RestMethod): "远程服务器返回错误: (502) 错误的网关。" [PASS] DR Cutover: Public Health verified against Restored DB HealthMs: 5751 (<= 60000) [PASS] DR Cutover: Device Reconnected Without Re-activation ReconnectMs: 10509 (<= 60000) Sending smoke notification 'RC4-RESTORE-CUTOVER-SMOKE'... Cutover smoke notification sent: ID = msg_1790139107455_dd2c [PASS] DR Cutover: Smoke notification received and ACKed by Windows Client MessageId: msg_1790139107455_dd2c >>> [6/6] Restoring Production Database Configuration & Cleaning Temporary DB... [Timeline/Restore] [DR-CUTOVER-ROLLBACK] START - Reverting connection string back to production database [PASS] Production DB Configuration Restored: Health Verified Temporary restore DB classnotify_restore_rc4_20260923-125012 dropped cleanly. [PASS] RC-4C: Backup & Disaster Restore Acceptance Summary BackupMs: 3004, DownloadMs: 5564, RestoreMs: 5838, CutoverHealthMs: 5751, DeviceReconnectMs: 10509 [Timeline/Restore] [RESTORE-SUITE] COMPLETE - RC-4C Backup and Disaster Restore completed with all PASS ********************** Windows PowerShell transcript end End time: 20260923125204 **********************