We have recently migrated to Odoo 16 and we are encounter an issue with the CRONs.
They are not executed automatically and after I restart the web machine, they go back to working normally and stop after some time.
After some digging in the code, we have found that the " ir_cron._process_jobs" stops working and returns this error: SSL SYSCALL error: Connection timed out
2024-03-22 11:06:32,934 1 WARNING ? odoo.service.server: ____________ ir_cron._process_jobs odoo-stack | Exception in thread odoo.service.cron.cron0: odoo-stack | Traceback (most recent call last): odoo-stack | File "/usr/lib/python3.9/threading.py", line 954, in _bootstrap_inner odoo-stack | self.run() odoo-stack | File "/usr/lib/python3.9/threading.py", line 892, in run odoo-stack | self._target(*self._args, **self._kwargs) odoo-stack | File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 499, in target odoo-stack | self.cron_thread(i) odoo-stack | File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 469, in cron_thread odoo-stack | pg_conn.poll() odoo-stack | psycopg2.OperationalError: could not receive data from server: Connection timed out odoo-stack | SSL SYSCALL error: Connection timed out odoo-stack | odoo-stack | Exception in thread odoo.service.cron.cron1: odoo-stack | Traceback (most recent call last): odoo-stack | File "/usr/lib/python3.9/threading.py", line 954, in _bootstrap_inner odoo-stack | self.run() odoo-stack | File "/usr/lib/python3.9/threading.py", line 892, in run odoo-stack | self._target(*self._args, **self._kwargs) odoo-stack | File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 499, in target odoo-stack | self.cron_thread(i) odoo-stack | File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 469, in cron_thread odoo-stack | pg_conn.poll() odoo-stack | psycopg2.OperationalError: could not receive data from server: Connection timed out odoo-stack | SSL SYSCALL error: Connection timed out odoo-stack | odoo-stack | Exception in thread odoo.service.cron.cron2: odoo-stack | Traceback (most recent call last): odoo-stack | File "/usr/lib/python3.9/threading.py", line 954, in _bootstrap_inner odoo-stack | self.run() odoo-stack | File "/usr/lib/python3.9/threading.py", line 892, in run odoo-stack | self._target(*self._args, **self._kwargs) odoo-stack | File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 499, in target odoo-stack | self.cron_thread(i) odoo-stack | File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 469, in cron_thread odoo-stack | pg_conn.poll() odoo-stack | psycopg2.OperationalError: could not receive data from server: Connection timed out odoo-stack | SSL SYSCALL error: Connection timed out
The web and database server are separate and we have one database.
The application is used by approximately 450 users and you can find below some of the conf file info
limit_memory_hard = 26843545600000
limit_memory_soft = 21474836480000
limit_request = 8327680000
limit_time_cpu = 480
limit_time_real = 1000000
limit_time_real_cron = -1
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = warn
logfile =
longpolling_port = 8072
max_cron_threads = 2
osv_memory_age_limit = False
osv_memory_count_limit = False
pg_path =
pidfile =
proxy_mode = False
reportgz = False
screencasts =
screenshots = /tmp/odoo_tests
server_wide_modules = base,web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
syslog = False
test_enable = False
test_file =
test_tags = None
transient_age_limit = 1.0
translate_modules = ['all']
unaccent = False
upgrade_path =
without_demo = True
workers = 0
This issue is blocking our workflow. Your input is really appreciated.
Thank you in advance
Hello Master,
Thank you for your input. I have tried what you suggested but unfortunately it didn't work.