queue_job: support running when pgbouncer is used (share config with bus_alt_connection)
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 42/100
Research direction
The runner's LISTEN cursor is the place to start; find where queue_job opens its listening connection and compare with how bus_alt_connection picks alternative connection parameters from settings or environment variables. The issue does not name exact files, so confirm the entry point first. Done when the runner can use the alternative connection for LISTEN when the configuration is present and falls back otherwise.
Written by the indexing model from the issue text.
Description
The module bus_alt_connection (in OCA/server-tools) allows using different connection parameters in the bus addon to issue the LISTEN imbus SQL request. This allows configuring pgbouncer in transaction mode to pool connections to the database server, lowering the number of connections to the db, and therefore allowing to tune postgresql more aggressively.
The queue_job runner also uses LISTEN and would benefit from sharing the configuration done for bus_alt_connection: if the settings / environment variables are available, then use the alternative connection to get the cursor that will LISTEN.
- Dominant language
- Python
- Stars
- 271
- Forks
- 602
- Avg merge
- 8d 3h
- Merged PRs (30d)
- 4
Getting set up
- No Dockerfile or Docker Compose file
- No pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from OCA/queue
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 22/100
Maintainers usually reply within 1 day
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 30/100
Maintainers usually reply within 1 day
-
help wanted no stale work in progress
Difficulty 5/5 Over a week Newbie friendliness 35/100
Maintainers usually reply within 1 day
-
Delaying unlink or write on a model whose method was replaced raises AttributeError at enqueue timePossibly taken A pull request linked to this issue is open or already merged. Openbug
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Maintainers usually reply within 1 day
-
[19.0] queue_job: Jobs stay pending after the jobrunner's database connection is silently droppedPossibly taken @HoloborodkoBohdan claimed this 46 days ago. Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 25/100
OCA/queue#984 · 1 comment · 1 reaction ·
Maintainers usually reply within 1 day
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
cpp-best-practices/project_validator#267 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Project-N-E-K-O/N.E.K.O#3725 ·
Maintainers usually reply within 1 day
-
[Bug] Sending a Telegram message chain twice duplicates mentionsPossibly taken @123XieC claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
AstrBotDevs/AstrBot#11125 ·
Maintainers usually reply within 1 day
-
backend bug priority: high
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
nooriegarg/ContribIQ#73 ·
Maintainers usually reply within 1 day
-
bug p3 security
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Maintainers usually reply within 1 day