Open ivbo opened 5 years ago
Can you give me more information: steps to reproduce? Odoo version?
odoo version 11 on ubuntu 18.04, with latest muk_dms, muk_base and muk_base...
scenario A to upload 2 files:
in log file I see displayed errors with previous comments
scenario B to upload folder with 5 files:
I managed to recreate the bug.
While I try to debug this you can use the drag and drop functionality of the tree view. That should work despite this bug (just tested it).
yes, it works with much better results for many files (I tried folders with differents number of files up to 12 ..), but sometimes do not upload 2 or 3 files too ... (especially if have 6 and more files ...)
Same error here when uploading multiple files with drag&drop.
Best to reproduce is to upload a bunch of PNG files. Then I get the following error almost every time:
ERROR: could not serialize access due to concurrent update
2020-07-09 14:43:19,115 76 ERROR prod flectra.sql_db: bad query: b'UPDATE "muk_dms_directory" SET "count_files"=13,"write_uid"=78,"write_date"=(now() at time zone \'UTC\') WHERE id IN (85)'
ERROR: could not serialize access due to concurrent update
2020-07-09 14:43:19,115 6407 ERROR prod flectra.sql_db: bad query: b'UPDATE "muk_dms_directory" SET "count_files"=13,"write_uid"=78,"write_date"=(now() at time zone \'UTC\') WHERE id IN (85)
'
ERROR: could not serialize access due to concurrent update
2020-07-09 14:43:19,116 6407 INFO prod flectra.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.2726 sec...
2020-07-09 14:43:19,116 76 INFO prod flectra.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.4091 sec...
2020-07-09 14:43:19,117 80 INFO prod flectra.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.8733 sec...
2020-07-09 14:43:19,137 6404 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:19] "POST /web/dataset/call_kw/muk_dms.file/create HTTP/1.1" 200 - 104 0.036 0.071
2020-07-09 14:43:19,557 6404 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:19] "GET /web/login HTTP/1.1" 200 - 28 0.019 0.056
2020-07-09 14:43:19,570 76 ERROR prod flectra.sql_db: bad query: b'UPDATE "muk_dms_directory" SET "count_files"=14,"write_uid"=78,"write_date"=(now() at time zone \'UTC\') WHERE id IN (85)'
ERROR: could not serialize access due to concurrent update
2020-07-09 14:43:19,571 76 INFO prod flectra.service.model: SERIALIZATION_FAILURE, retry 2/5 in 0.0244 sec...
2020-07-09 14:43:19,586 6407 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:19] "POST /web/dataset/call_kw/muk_dms.file/create HTTP/1.1" 200 - 212 0.129 0.436
2020-07-09 14:43:19,611 76 ERROR prod flectra.sql_db: bad query: b'INSERT INTO "mail_followers" ("id", "res_model", "partner_id", "res_id") VALUES(nextval(\'mail_followers_id_seq\'), \'muk_d
ms.file\', 3274, 799) RETURNING id'
ERROR: duplicate key value violates unique constraint "mail_followers_mail_followers_res_partner_res_model_id_uniq"
DETAIL: Key (res_model, res_id, partner_id)=(muk_dms.file, 799, 3274) already exists.
2020-07-09 14:43:19,615 76 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:19] "POST /web/dataset/call_kw/muk_dms.file/create HTTP/1.1" 200 - 85 0.065 0.526
2020-07-09 14:43:20,227 80 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:20] "POST /web/dataset/call_kw/muk_dms.file/create HTTP/1.1" 200 - 213 0.131 1.065
2020-07-09 14:43:21,134 6404 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:21] "GET /web/image/15475/Auswahl_393.png?access_token=63bbf7df-45e2-4975-9241-e09e4c8a2c9c HTTP/1.1" 200 -
7 0.007 0.021
2020-07-09 14:43:26,520 6407 INFO prod werkzeug: 172.18.0.3 - - [09/Jul/2020 14:43:26] "GET /web/login HTTP/1.1" 200 - 28 0.025 0.070
When I upload other file types there are no errors, or only one error on 50 upload tasks.
It is really supported multiple files upload ? I tried to upload multiple files but everytime only one file was uploaded ...
In log file I found following errors: