Skip to Content
This question has been flagged
3 Replies
2107 Views
Avatar
paidy kumar

i want to duplicate one of my existed records record contains one one2many field and it has 3000 records are attached when i tried to duplicate that record getting connection lost and restored message.

my odoo.conf

limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 900
limit_time_real = 2200
workers=0

Avatar
Discard
Avatar
paidy kumar
Author Best Answer

in logs backend process of duplicating of record is going on ..all method are calling which are related to duplication..after loading some time it is showing up connection lost and in fraction of seconds connection restored message is coming

Avatar
Discard
Avatar
Oddoers
Best Answer

I think you have to chnage in nginx conf file, client_max_body_size : 200M.




Avatar
Discard
paidy kumar
Author

i changed to 200M and 1024M and also tried 2000M but not solved issue

Avatar
Baiju KS
Best Answer

HI,

Please try increasing the value of the limit_time_real parameter to the config file

limit_time_real = 1000000


or run odoo server with command line adding this parameter

--limit-time-real 1000000


--limit-time-real

Prevents the worker from taking longer than seconds to process a request. If the limit is exceeded, the worker is killed.


Avatar
Discard
paidy kumar
Author

Thanks for your answer sir but not worked..

Baiju KS

Please include more information, how much time is it taking to reset, your server specs, Please check the log file to find out what is happening

paidy kumar
Author

in logs backend process of duplicating of record is going on ..all method are calling which are related to duplication..after loading some time it is showing up connection lost and in fraction of seconds connection restored message is coming

Baiju KS

Please try increasing memory[limit_memory_hard,limit_memory_soft] in config.
Please post the section of error in the log file

paidy kumar
Author

these are my logs when i changed memory[limit_memory_hard=4579139413,limit_memory_soft=3863311530]

2021-11-02 05:38:28,712 27511 DEBUG v24_db_18_sept odoo.api: call slide.channel(191,).copy()
2021-11-02 05:38:30,485 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:31,068 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:31,202 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:31,774 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:31] "GET /survey/start/6cf0d210-b2f3-4ad4-9a11-3af30a8cc61a HTTP/1.0" 200 - 27 0.928 0.440
2021-11-02 05:38:32,285 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:32] "POST /web/action/load HTTP/1.0" 200 - 29 0.799 0.371
2021-11-02 05:38:32,541 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:32,657 27511 DEBUG v24_db_18_sept odoo.api: call slide.exam().load_views(options={'action_id': 185, 'toolbar': True, 'load_filters': True}, views=[[False, 'list'], [False, 'form'], [2250, 'search']])
2021-11-02 05:38:33,962 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:33] "POST /web/dataset/call_kw/slide.exam/load_views HTTP/1.0" 200 - 34 0.806 0.688
2021-11-02 05:38:34,252 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:34,809 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:34] "POST /web/dataset/search_read HTTP/1.0" 200 - 7 0.369 0.350
2021-11-02 05:38:35,657 27511 DEBUG v24_db_18_sept odoo.api.create: slide.slide().create() called with 3357 dicts
2021-11-02 05:38:35,663 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:36,675 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:36] "GET /survey/start/6d5d8549-fff7-458c-aa74-b8657e7859b4 HTTP/1.0" 200 - 27 0.536 0.497
2021-11-02 05:38:38,233 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:38,903 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:38] "GET / HTTP/1.0" 200 - 19 0.566 0.191
2021-11-02 05:38:39,597 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:40,655 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:40] "GET /survey/start/70148ebc-b536-437f-b446-c9f2824de853 HTTP/1.0" 200 - 27 0.518 0.557
2021-11-02 05:38:42,860 27511 DEBUG v24_db_18_sept odoo.modules.registry: Multiprocess signaling check: [Registry - 686 -> 686] [Cache - 21137 -> 21137]
2021-11-02 05:38:43,891 27511 INFO v24_db_18_sept werkzeug: 127.0.0.1 - - [02/Nov/2021 05:38:43] "GET /survey/start/70bab74e-9a92-4d7e-808f-b81ef9a3c135 HTTP/1.