Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
3164 Widoki

kindly help to overcome the situation, when user runs a report to extract for more than 4 Months it is throwing error as below: (replaced actual word with xxxxx intentionally)


ERROR xxxxx-purchase-approval-10635620 odoo.sh: Worker process (pid=229) was killed by signal 9 (most likely hit a memory limit, please check your custom modules memory usage.)


is it related to any configuration/setting? or physical memory of Server or Client machine?


please help how to resolve this issue.


regards

Awatar
Odrzuć
Autor

any help please??

Autor

nobody yet faced this problem?

Najlepsza odpowiedź

Hello John,

The error message you’re seeing indicates that the worker process of your Odoo instance was terminated due to a memory limit being exceeded. This can happen if your custom module or other processes within Odoo consume a significant amount of memory. Here are a few suggestions on how to resolve this issue:


Check Your Custom Modules: Review the code in your custom modules to see if there are any memory-intensive operations that could be optimized. This could include large database queries, complex computations, or large data structures.


Increase Worker Memory Limit: If your server has enough physical memory, you can increase the memory limit for Odoo worker processes. This can be done by adjusting the limit_memory_hard and limit_memory_soft parameters in your Odoo configuration file.


Add More Workers: If your server has multiple cores, you can increase the number of worker processes to better utilize your server’s resources. This can be done by adjusting the workers parameter in your Odoo configuration file.


Upgrade Server Hardware: If your server is consistently running out of memory, it may be necessary to upgrade your server to a machine with more RAM.


Remember, these are just suggestions and the exact solution may vary depending on the specifics of your Odoo instance and server configuration. It’s always a good idea to backup your data and configuration before making any changes. If you’re unsure, consider reaching out to a professional Odoo consultant.

Best regards,

Maciej

Awatar
Odrzuć
Autor

thanks a bunch for your inputs/guidance & suggestions.
yes in this report the Query is heavy enough to gather information from various Models / Tables, this is a table Function to return Records and it runs in PgAdmin fine, the responsible persons has increased Worker Memory Limit and added more Workers but still situation is same. more likely it can be lead to upgrade Server hardware as you have suggested. developers already tried their best to optimize the Queries in said function.

thanks again for reply.

best regards

Powiązane posty Odpowiedzi Widoki Czynność
0
paź 22
2245
1
gru 20
1376
0
lip 20
2796
5
sty 23
4848
0
lut 21
3711