Crowdsec high cpu usage since last crowdsec update

[lokiiiii]

Description

Hello,

Since the last crowdsec update (v1.7.8), homepage consumes high cpu usage (2x 100% cpu usage processes as shown in the attached screenshot) whenever I'm checking homepage.

After a few minutes in background, my chrome page is going idle and these 2 system processes disappear.

Anyone else impacted by this issue ?

Thanks

homepage version

e81aadb

Installation method

Docker

Configuration

No response

Container Logs

No response

Browser Logs

No response

Troubleshooting

NA

[lokiiiii]

[lokiiiii]

after refreshing a few times homepage, I now have 3 process consuming 400% :

[shamoon]

Sounds like something that should be reported upstream if you are pegging it to a crowdsec version change, I dont know how responsive they'll be. Homepage is after all just hitting their API (at a reasonable interval)

[brownshelf9817]

crowdsecurity/crowdsec#4464
"Worth noting: the Homepage CrowdSec widget's bans panel hits /v1/alerts/decision_type=ban&origin=crowdsec&has_active_decision=1 on every refresh, which is the exact filter combo that triggers the slow query. So for us Homepage users running CrowdSec, it is essentially polling the worst-case path."

[shamoon]

Despite that comment there are tons of users experiencing issues so I think this is firmly upstream. I had sudden “database locked” errors too. Let’s see what they say/do

[makakam83]

Going back to 1.7.7 removed the problem with high CPU usage in my case.

[OnlyMalinka]

Same problem, moving to postgres instead of sqlite fixed the issue