Solution:
Root Cause: Corrupted Local Sync SQLite Database Index When Google Drive for Desktop fails to write sync state confirmations back to its local SQLite database (
snapshot.db), it loses track of previously uploaded file hashes. This forces the client to assume local files are new, triggering redundant re-uploads on every session initialization.
Diagnostic Verification: Inspect Google Drive log files for repeated upload request loops: Copy
bash
# Windows PowerShell path
Get-Content "$env:LOCALAPPDATA\Google\DriveFS\Logs\drive_fs.txt" -Tail 50 | Select-String "Upload"
Look for continuous 200 OK responses re-uploading identical file paths.
Step-by-Step Fix: 1 Open Google Drive for Desktop, click Settings (Gear) > Quit Google Drive .
2 Navigate to the local application cache directory:
Windows: %LOCALAPPDATA%\Google\DriveFS\macOS: ~/Library/Application Support/Google/DriveFS/3 Locate the randomized alphanumeric profile folder (e.g., 11223344556677889900) and delete or rename the content_cache and snapshot.db files.
4 Restart Google Drive for Desktop and log back into your Google Account.
5 Re-select your backup folders to force a clean server-side index comparison instead of raw force-uploading.
Prevention & Long-Term Monitoring: Avoid force-terminating the Google Drive process during active sync synchronization windows.