This question has been flagged

Hi 

i am using odoo 13 and when i'm trying to export product variants with specified fields i get this error . i tried to change memory limits for workers but the problem is still there
any ideas on how to properly config odoo to solve the issue ?

this is my config file

xmlrpc_port = 8069

limit_request = 8192

limit_time_cpu = 600

limit_time_real = 1200

max_cron_threads = 1

limit_memory_hard = 5368706371

limit_memory_soft = 4831835734


and this is the error that pops out every time : 

2020-09-30 10:44:53,228 3883 INFO products_test odoo.addons.base.models.ir_cron: Job `Mail: Fetchmail Service` done. 

2020-09-30 10:45:08,049 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:45:08] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.044 50.113

2020-09-30 10:45:58,231 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:45:58] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.058 50.097

2020-09-30 10:46:48,569 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:46:48] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.044 50.077

2020-09-30 10:47:38,762 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:47:38] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.043 50.116

2020-09-30 10:48:28,931 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:48:28] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.050 50.082

2020-09-30 10:48:53,621 3883 INFO products_test odoo.addons.base.models.ir_cron: Starting job `Mail: Fetchmail Service`. 

2020-09-30 10:48:53,705 3883 INFO products_test odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server Khooger Income 

2020-09-30 10:48:56,139 3883 INFO products_test odoo.addons.fetchmail.models.fetchmail: General failure when trying to fetch mail from imap server Khooger Income. 

Traceback (most recent call last):

  File "/home/khooger/Programming/Projects/Odoo/odoo13/addons/fetchmail/models/fetchmail.py", line 162, in fetch_mail

    imap_server = server.connect()

  File "/home/khooger/Programming/Projects/Odoo/odoo13/addons/fetchmail/models/fetchmail.py", line 108, in connect

    connection.login(self.user, self.password)

  File "/usr/lib/python3.6/imaplib.py", line 598, in login

    raise self.error(dat[-1])

imaplib.IMAP4.error: b'[AUTHENTICATIONFAILED] Authentication failed.'

2020-09-30 10:48:56,236 3883 INFO products_test odoo.addons.base.models.ir_cron: Job `Mail: Fetchmail Service` done. 

2020-09-30 10:49:19,624 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:49:19] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.044 50.118

2020-09-30 10:49:35,446 3883 WARNING ? odoo.service.server: Server memory limit (4990951424) reached. 

2020-09-30 10:49:36,519 3883 WARNING ? odoo.service.server: Server memory limit (5004058624) reached. 

2020-09-30 10:49:37,602 3883 WARNING ? odoo.service.server: Server memory limit (5016903680) reached. 

2020-09-30 10:49:38,675 3883 WARNING ? odoo.service.server: Server memory limit (5030010880) reached. 

2020-09-30 10:49:39,747 3883 WARNING ? odoo.service.server: Server memory limit (5043118080) reached. 

2020-09-30 10:49:40,805 3883 WARNING ? odoo.service.server: Server memory limit (5056487424) reached. 

2020-09-30 10:49:41,882 3883 WARNING ? odoo.service.server: Server memory limit (5069856768) reached. 

2020-09-30 10:49:42,965 3883 WARNING ? odoo.service.server: Server memory limit (5082963968) reached. 

2020-09-30 10:49:44,032 3883 WARNING ? odoo.service.server: Server memory limit (5096071168) reached. 

2020-09-30 10:49:45,090 3883 WARNING ? odoo.service.server: Server memory limit (5109178368) reached. 

2020-09-30 10:49:46,166 3883 WARNING ? odoo.service.server: Server memory limit (5122547712) reached. 

2020-09-30 10:49:47,244 3883 WARNING ? odoo.service.server: Server memory limit (5135917056) reached. 

2020-09-30 10:49:48,312 3883 WARNING ? odoo.service.server: Server memory limit (5148762112) reached. 

2020-09-30 10:49:49,394 3883 WARNING ? odoo.service.server: Server memory limit (5162393600) reached. 

2020-09-30 10:49:50,477 3883 WARNING ? odoo.service.server: Server memory limit (5175762944) reached. 

2020-09-30 10:49:51,555 3883 WARNING ? odoo.service.server: Server memory limit (5188870144) reached. 

2020-09-30 10:49:52,638 3883 WARNING ? odoo.service.server: Server memory limit (5201453056) reached. 

2020-09-30 10:49:53,714 3883 WARNING ? odoo.service.server: Server memory limit (5214298112) reached. 

2020-09-30 10:49:54,787 3883 WARNING ? odoo.service.server: Server memory limit (5247254528) reached. 

2020-09-30 10:49:55,871 3883 WARNING ? odoo.service.server: Server memory limit (5260361728) reached. 

2020-09-30 10:49:56,939 3883 WARNING ? odoo.service.server: Server memory limit (5273206784) reached. 

2020-09-30 10:49:58,022 3883 WARNING ? odoo.service.server: Server memory limit (5286576128) reached. 

2020-09-30 10:49:59,093 3883 WARNING ? odoo.service.server: Server memory limit (5299683328) reached. 

2020-09-30 10:50:00,177 3883 WARNING ? odoo.service.server: Server memory limit (5312528384) reached. 

2020-09-30 10:50:01,239 3883 WARNING ? odoo.service.server: Server memory limit (5325111296) reached. 

2020-09-30 10:50:02,312 3883 WARNING ? odoo.service.server: Server memory limit (5337169920) reached. 

2020-09-30 10:50:03,329 3883 WARNING ? odoo.service.server: Server memory limit (5348966400) reached. 

2020-09-30 10:50:04,392 3883 WARNING ? odoo.service.server: Server memory limit (5361287168) reached. 

2020-09-30 10:50:05,465 3883 WARNING ? odoo.service.server: Server memory limit (5368627200) reached. 

2020-09-30 10:50:06,145 3883 ERROR products_test odoo.addons.web.controllers.main: An exception occured during an http request 

Traceback (most recent call last):

  File "/home/khooger/Programming/Projects/Odoo/odoo13/addons/web/controllers/main.py", line 110, in wrap

    return f(*args, **kwargs)

  File "/home/khooger/Programming/Projects/Odoo/odoo13/addons/web/controllers/main.py", line 1900, in index

    return self.base(data, token)

  File "/home/khooger/Programming/Projects/Odoo/odoo13/addons/web/controllers/main.py", line 1852, in base

    export_data = records.export_data(field_names).get('datas',[])

  File "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/models.py", line 898, in export_data

    return {'datas': self._export_rows(fields_to_export)}

  File "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/models.py", line 855, in _export_rows

    lines2 = value._export_rows(fields2, _is_toplevel_call=False)

  File "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/models.py", line 862, in _export_rows

    lines += lines2[1:]

MemoryError

2020-09-30 10:50:07,743 3883 INFO products_test werkzeug: 127.0.0.1 - - [30/Sep/2020 10:50:07] "POST /web/export/xlsx HTTP/1.1" 500 - 637 0.942 462.320

2020-09-30 10:50:08,743 3883 INFO ? odoo.service.server: Dumping stacktrace of limit exceeding threads before reloading 

2020-09-30 10:50:08,758 3883 INFO ? odoo.tools.misc: 

# Thread: <_MainThread(MainThread, started 140513909024576)> (db:n/a) (uid:n/a) (url:n/a)

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo-bin", line 8, in <module>

  odoo.cli.main()

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/cli/command.py", line 60, in main

  o.run(args)

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/cli/server.py", line 178, in run

  main(args)

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/cli/server.py", line 172, in main

  rc = odoo.service.server.start(preload=preload, stop=stop)

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/service/server.py", line 1276, in start

  rc = server.run(preload, stop)

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/service/server.py", line 535, in run

  dumpstacks(thread_idents=[thread.ident for thread in self.limits_reached_threads])

File: "/home/khooger/Programming/Projects/Odoo/odoo13/odoo/tools/misc.py", line 957, in dumpstacks

  for line in extract_stack(stack): 


Avatar
Discard
Best Answer

limit_memory_hard = 5368706371

limit_memory_soft = 4831835734


increase this memory.

Avatar
Discard