Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
회계
재고 관리
PoS
프로젝트
MRP

All apps

모든 게시물 사용자 배지

태그 (모두 보기)

odoo accounting v14 pos v15

게시판 정보

도움말

Memory Error While Exporting 200k product variants

configuration memory memory_usage largescale Odoo13.0

2 답글

12192 화면

amir ehsan

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

Uday

I am encountering a similar error while trying to uninstall a module in Odoo, which involves lock timeouts and registry loading failures.

MUHAMMAD Imran

limit_memory_hard = 5368706371

limit_memory_soft = 4831835734

increase this memory.

토론이 재미있으신가요? 직접 참여해보세요!

지금 바로 가입하여 독점 서비스를 이용해보고 특별한 커뮤니티와 소통하세요!

가입

관련 게시물	답글	화면
Wkhtmltopdf failed (error code: -11). Memory limit too low or maximum file number of subprocess reached. Message : b'' memory memory_usage pdfreport	1 6월 24	5057
v13: Error: most likely hit a memory limit report memory Odoo13.0	1 12월 23	5388
Different between limit_memory_hard and limit_memory_soft 해결 완료 configuration memory_usage workers ram	3 10월 24	34139
res.config.settings documentation 해결 완료 configuration help Odoo13.0 Odoo13	2 12월 24	32806
how can I increase the memory limit 해결 완료 limit memory memory_usage odooV12	1 2월 19	21078

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!