queue icon indicating copy to clipboard operation
queue copied to clipboard

[18.0] Job stuck in Enqueued state

Open enricodg opened this issue 11 months ago • 1 comments

Module

queue_job

Describe the bug

Job get stuck in Enqueued

To Reproduce

Affected versions: 18.0

Steps to reproduce the behavior:

  1. I just tested the module in local with the url http://odoo.local:8080/queue_job/create_test_job
  2. Here's my odoo.conf:
[options]
addons_path =  xxx
admin_passwd =  xxx
db_name = odoo18
db_host = localhost
db_port = 5432
db_user =
db_password =
workers = 6
server_wide_modules = web,queue_job
max_cron_threads = 1
proxy_mode = True
[queue_job]
channels = root:2
scheme = http
host = odoo.local
port = 8080
  1. I have tested with proxy equal to True/False. But does not change anything
  2. I tried to debug, and when calling requests.get(url) the module does nothing? It logs :
2025-03-07 13:59:11,055 50596 DEBUG ? odoo.addons.queue_job.jobrunner.channels: job 987c8fc8-e9de-4949-9a3d-45d7e1eab1b8 marked pending in channel root(C:2,Q:1,R:0,F:0) 
2025-03-07 13:59:11,057 50596 DEBUG ? odoo.addons.queue_job.jobrunner.channels: job 987c8fc8-e9de-4949-9a3d-45d7e1eab1b8 marked running in channel root(C:2,Q:0,R:1,F:0) 
2025-03-07 13:59:11,057 50596 INFO ? odoo.addons.queue_job.jobrunner.runner: asking Odoo to run job 987c8fc8-e9de-4949-9a3d-45d7e1eab1b8 on db odoo18 
2025-03-07 13:59:11,067 50596 DEBUG ? odoo.addons.queue_job.jobrunner.runner: select() timeout: 60.00 sec 
2025-03-07 13:59:11,074 50574 INFO odoo18 odoo.addons.queue_job.jobrunner.channels: Configured channel: root(C:2,Q:0,R:0,F:0) 
2025-03-07 13:59:11,078 50632 INFO odoo18 odoo.service.server: Worker WorkerJobRunner (50632) alive 
2025-03-07 13:59:11,080 50632 DEBUG ? odoo.addons.queue_job.jobrunner: WorkerJobRunner (50632) starting up 
2025-03-07 13:59:16,086 50632 INFO ? odoo.addons.queue_job.jobrunner.runner: starting 
2025-03-07 13:59:16,088 50632 INFO ? odoo.addons.queue_job.jobrunner.runner: initializing database connections 
2025-03-07 13:59:16,116 50632 DEBUG ? odoo.addons.queue_job.jobrunner.channels: job 987c8fc8-e9de-4949-9a3d-45d7e1eab1b8 marked running in channel root(C:2,Q:0,R:1,F:0) 
2025-03-07 13:59:16,117 50632 INFO ? odoo.addons.queue_job.jobrunner.runner: queue job runner ready for db odoo18 
2025-03-07 13:59:16,118 50632 INFO ? odoo.addons.queue_job.jobrunner.runner: database connections ready 
2025-03-07 13:59:16,118 50632 DEBUG ? odoo.addons.queue_job.jobrunner.runner: select() timeout: 60.00 sec 
  1. If i change the workers to 0 it works just fine

Expected behavior Should not stuck in Enqueued and should be Done state?

Additional context I'm running python 3.11.10

enricodg avatar Mar 07 '25 13:03 enricodg

i think it's because the db_name. if i use dbfilter it works fine

enricodg avatar Mar 07 '25 14:03 enricodg

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days. If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.

github-actions[bot] avatar Sep 07 '25 12:09 github-actions[bot]