ActivityWatch/aw-server-rust

Possible database corruption and 100% CPU after Windows updates

ArthurusDent opened this issue · 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