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):
