[1.6.4] Investigate unable to update bouncer 'X'

[LaurenceJJones]

We need to investigate the following log calls:

time="2024-11-20T16:08:01Z" level=error msg="unable to update bouncer 'FirewallBouncer-1650280536' pull: unable to update machine last pull in database: context canceled: sql: transaction has already been committed or rolled back"
time="2024-11-20T16:08:11Z" level=error msg="unable to update bouncer 'FirewallBouncer-1650280536' pull: unable to update machine last pull in database: context canceled"

Since we now propagate the request context to the database call it will cancel if the request is cancelled by the client.

I am proactively opening an issue so users can report their own experience below and log statements to help us debug.

[github-actions]

@LaurenceJJones: Thanks for opening an issue, it is currently awaiting triage.

In the meantime, you can:

1. Check Crowdsec Documentation to see if your issue can be self resolved.
2. You can also join our Discord.
3. Check Releases to make sure your agent is on the latest version.

Details

I am a bot created to help the crowdsecurity developers manage community feedback and contributions. You can check out my manifest file to understand my behavior and what I can do. If you want to use this for your project, you can check out the BirthdayResearch/oss-governance-bot repository.

[github-actions]

@LaurenceJJones: There are no 'kind' label on this issue. You need a 'kind' label to start the triage process.

• /kind feature
• /kind enhancement
• /kind refactoring
• /kind bug
• /kind packaging

Details

I am a bot created to help the crowdsecurity developers manage community feedback and contributions. You can check out my manifest file to understand my behavior and what I can do. If you want to use this for your project, you can check out the BirthdayResearch/oss-governance-bot repository.

[J-a-x-u]

Well, what log statements or info do you need?

level=error msg="unable to update bouncer 'name' pull: unable to update machine last pull in database: context canceled: sql: transaction has already been committed or rolled back"

DB backend is mariadb.
Crowdsec is crowdsec-1.6.4-1.el9.x86_64.