Skip to content

Possible database corruption and 100% CPU after Windows updates #467

Open
@ArthurusDent

Description

@ArthurusDent

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions