Help

0

Email Marketing not sending emails but test emails works fine

Avatar
emaan

Hi everyone, 


I am using Odoo 13 docker. I have over 3000 contacts and am trying to send mass email to contacts but the email goes into schedular and remains into queue. Test emails works fine.


Also the performance of the UI goes so low that even it won't load the email marketing page any more.


The server is Xeon quad core with 48 GB ram so hardware surely isn't an issue.


This is crucial time for our business to send these emails so any help will be really appreciated.


here is the log;


2020-09-15 23:43:08,466 1 INFO production odoo.addons.base.models.ir_cron: Starting job `Email Marketing: Process queue`. 

2020-09-15 23:43:08,738 1 INFO production odoo.addons.mass_mailing.models.mailing: Mass-mailing mailing.mailing(13,) targets res.partner, no opt out list available 

2020-09-15 23:43:08,739 1 INFO production odoo.addons.mass_mailing.models.mailing: Mass-mailing mailing.mailing(13,) has already reached 0 res.partner emails 

2020-09-15 23:43:19,916 1 INFO production werkzeug: 192.168.0.29 - - [15/Sep/2020 23:43:19] "POST /longpolling/poll HTTP/1.1" 200 - 19 0.034 50.052

2020-09-15 23:44:11,070 1 INFO production werkzeug: 192.168.0.29 - - [15/Sep/2020 23:44:11] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.081 50.143

2020-09-15 23:45:02,413 1 INFO production werkzeug: 192.168.0.29 - - [15/Sep/2020 23:45:02] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.079 50.165

2020-09-15 23:45:08,616 1 WARNING ? odoo.service.server: Thread <Thread(odoo.service.cron.cron0, started daemon 139818298242816)> virtual real time limit (120/120s) reached. 

2020-09-15 23:45:08,622 1 INFO ? odoo.service.server: Dumping stacktrace of limit exceeding threads before reloading 

2020-09-15 23:45:08,985 1 INFO ? odoo.tools.misc: 


# Thread: <Thread(odoo.service.cron.cron0, started daemon 139818298242816)> (db:production) (uid:n/a) (url:n/a)

File: "/usr/lib/python3.7/threading.py", line 885, in _bootstrap

  self._bootstrap_inner()

File: "/usr/lib/python3.7/threading.py", line 917, in _bootstrap_inner

  self.run()

File: "/usr/lib/python3.7/threading.py", line 865, in run

  self._target(*self._args, **self._kwargs)

File: "/usr/lib/python3/dist-packages/odoo/service/server.py", line 430, in target

  self.cron_thread(i)

File: "/usr/lib/python3/dist-packages/odoo/service/server.py", line 411, in cron_thread

  ir_cron._acquire_job(db_name)

File: "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_cron.py", line 273, in _acquire_job

  cls._process_jobs(db_name)

File: "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_cron.py", line 237, in _process_jobs

  registry[cls._name]._process_job(job_cr, job, lock_cr)

File: "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_cron.py", line 147, in _process_job

  cron._callback(job['cron_name'], job['ir_actions_server_id'], job['id'])

File: "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_cron.py", line 109, in _callback

  self.env['ir.actions.server'].browse(server_action_id).run()

File: "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions.py", line 545, in run

  res = func(action, eval_context=eval_context)

File: "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_actions.py", line 59, in run_action_code_multi

  res = super(ServerAction, self).run_action_code_multi(action, eval_context)

File: "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions.py", line 430, in run_action_code_multi

  safe_eval(action.sudo().code.strip(), eval_context, mode="exec", nocopy=True)  # nocopy allows to return 'action'

File: "/usr/lib/python3/dist-packages/odoo/tools/safe_eval.py", line 351, in safe_eval

  return unsafe_eval(c, globals_dict, locals_dict)

File: "", line 1, in <module>

File: "/usr/lib/python3/dist-packages/odoo/addons/mass_mailing/models/mailing.py", line 578, in _process_mass_mailing_queue

  mass_mailing.action_send_mail()

File: "/usr/lib/python3/dist-packages/odoo/addons/mass_mailing/models/mailing.py", line 548, in action_send_mail

  composer.send_mail(auto_commit=auto_commit)

File: "/usr/lib/python3/dist-packages/odoo/addons/mail/wizard/mail_compose_message.py", line 263, in send_mail

  all_mail_values = wizard.get_mail_values(res_ids)

File: "/usr/lib/python3/dist-packages/odoo/addons/mass_mailing/wizard/mail_compose_message.py", line 21, in get_mail_values

  res = super(MailComposeMessage, self).get_mail_values(res_ids)

File: "/usr/lib/python3/dist-packages/odoo/addons/mail/wizard/mail_compose_message.py", line 299, in get_mail_values

  rendered_values = self.render_message(res_ids)

File: "/usr/lib/python3/dist-packages/odoo/addons/mail/wizard/mail_compose_message.py", line 482, in render_message

  bodies = self.env['mail.template']._render_template(self.body, self.model, res_ids, post_process=True)

File: "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_template.py", line 298, in _render_template

  results[res_id] = self.render_post_process(result)

File: "/usr/lib/python3/dist-packages/odoo/addons/mass_mailing/models/mail_template.py", line 20, in render_post_process

  blacklist=['/unsubscribe_from_list']

File: "/usr/lib/python3/dist-packages/odoo/addons/link_tracker/models/link_tracker.py", line 159, in convert_links

  link = self.create(vals)

File: "<decorator-gen-99>", line 2, in create

File: "/usr/lib/python3/dist-packages/odoo/api.py", line 314, in _model_create_single

  return create(self, arg)

File: "/usr/lib/python3/dist-packages/odoo/addons/link_tracker/models/link_tracker.py", line 133, in create

  create_vals['title'] = self._get_title_from_url(create_vals['url'])

File: "/usr/lib/python3/dist-packages/odoo/addons/link_tracker/models/link_tracker.py", line 97, in _get_title_from_url

  p = html.fromstring(page.text.encode('utf-8'), parser=html.HTMLParser(encoding='utf-8'))

File: "/usr/lib/python3/dist-packages/requests/models.py", line 857, in text

  encoding = self.apparent_encoding

File: "/usr/lib/python3/dist-packages/requests/models.py", line 727, in apparent_encoding

  return chardet.detect(self.content)['encoding']

File: "/usr/lib/python3/dist-packages/chardet/__init__.py", line 38, in detect

  detector.feed(byte_str)

File: "/usr/lib/python3/dist-packages/chardet/universaldetector.py", line 211, in feed

  if prober.feed(byte_str) == ProbingState.FOUND_IT:

File: "/usr/lib/python3/dist-packages/chardet/charsetgroupprober.py", line 71, in feed

  state = prober.feed(byte_str)

File: "/usr/lib/python3/dist-packages/chardet/sbcharsetprober.py", line 86, in feed

  order = char_to_order_map[c] 

2020-09-15 23:45:08,992 1 INFO ? odoo.service.server: Initiating server reload 

2020-09-15 23:45:10,394 1 INFO ? odoo: Odoo version 13.0-20200826 

2020-09-15 23:45:10,394 1 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf 

2020-09-15 23:45:10,394 1 INFO ? odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/var/lib/odoo/addons/13.0', '/mnt/extra-addons'] 

2020-09-15 23:45:10,395 1 INFO ? odoo: database: odoo@172.17.0.2:5432 

2020-09-15 23:45:10,636 1 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf 

2020-09-15 23:45:10,783 1 INFO ? odoo.service.server: HTTP service (werkzeug) running on b12c1e93066c:8069 

2020-09-15 23:45:24,399 1 INFO ? odoo.http: HTTP Configuring static files 

2020-09-15 23:45:24,426 1 INFO production odoo.modules.loading: loading 1 modules... 

2020-09-15 23:45:24,458 1 INFO production odoo.modules.loading: 1 modules loaded in 0.03s, 0 queries 

2020-09-15 23:45:24,518 1 INFO production odoo.modules.loading: loading 62 modules... 

2020-09-15 23:45:25,401 1 INFO production odoo.modules.loading: 62 modules loaded in 0.88s, 0 queries 


Avatar
Discard
1 Answer
0
Avatar
Ermin Trevisan
Best Answer

Did you read that and have you checked if it is the cause by setting more appropriate limits in your Odoo conf file?

2020-09-15 23:45:08,616 1 WARNING ? odoo.service.server: Thread <Thread(odoo.service.cron.cron0, started daemon 139818298242816)> virtual real time limit (120/120s) reached. 


Avatar
Discard