aw-server-rust icon indicating copy to clipboard operation
aw-server-rust copied to clipboard

Possible database corruption and 100% CPU after Windows updates

Open ArthurusDent opened this issue 1 year ago • 0 comments

It looks like whenever there was the monthly Windows update, the aw-server-rust database gets somehow corrupted. It doesn't seem to happen with normal reboots.

After the Windows update was applied and the system has rebooted, AW starts, but aw-server-rust seems to hit one thread of the CPU with 100%. The web GUI ist also much slower to respond and I sometimes get notified that connection to the server was lost. The performance problems never resolve, even after hours.

The fix is to restore the AW folders from a backup. That's why I suspect that the database gets somehow corrupted.

For some reason there are no logs available for the time during the Windows update. I've uploaded the logs after a manual start of AW after the Windows update and reboot of the system.

System: Windows 10 22H2 ActivityWatch: v0.12.2 (rust)

Logs: activitywatch.zip

ArthurusDent avatar Feb 15 '24 15:02 ArthurusDent