Uh oh!
There was an error while loading.Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork9.7k
[Messenger] Change the default notify timeout value for PostgreSQL#36990
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
Uh oh!
There was an error while loading.Please reload this page.
Conversation
fabpot commentedMay 28, 2020
@dunglas Does that make sense for you? |
dunglas commentedMay 28, 2020
It shouldn't be the case because of symfony/src/Symfony/Component/Messenger/Bridge/Doctrine/Transport/PostgreSqlConnection.php Lines 76 to 79 inb841eab
The loop should consume some CPU to allow checking for delayed updates, but shouldn't sent useless SQL queries except when Maybe that the default value of By the way, we should maybe call |
b841eab to6e5a761Compare6e5a761 tod9decf9Compare
The default value of 0 means that notify is kind of disable and that incurs many SQL requests. 10 minutes is kind of arbitrary but seems to be a good balance between waiting for a message (blocking) and trying again later in case of an issue.