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: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.