Docker config.yaml - set SQLite use_wal to true

[gonsalvesc]

This pull request sets the the default value of SQLite use_wal to true. This removes the below warning at startup.
/kind enhancement
/area configuration

level=warning msg="sqlite is not using WAL mode, LAPI might become unresponsive when inserting the community blocklist"

[github-actions]

@gonsalvesc: There are no 'kind' label on this PR. You need a 'kind' label to generate the release automatically.

• /kind feature
• /kind enhancement
• /kind refactoring
• /kind fix
• /kind chore
• /kind dependencies

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]

@gonsalvesc: There are no area labels on this PR. You can add as many areas as you see fit.

• /area agent
• /area local-api
• /area cscli
• /area appsec
• /area security
• /area configuration

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.

[LaurenceJJones]

This pull request sets the the default value of SQLite use_wal to true. This removes the below warning at startup.

level=warning msg="sqlite is not using WAL mode, LAPI might become unresponsive when inserting the community blocklist"

The problem is we cant set it to true by default, as somebody could be storing the sqlite from a NFS mount and WAL should not be used with NFS shares.