Now 504 Gateway Timeout error gone, but have another issue. After pressing submit, it loads cpu for about 25 minutes and in the end throws message Too many writes in one request. Please send smaller requests
Here is browser console log log - Pastebin.com
Tried on own ubuntu PC and on vm, both same. Landed cost voucher consists of 190 items, and there is about 10 sales invoices after purchase invoice against which I try to make landed cost voucher. Why it takes so long to submit and how to solve the above issue?
Thank you @rmehta for your reply.
Yes purchase invoice is back dated, and there is only 15 sales invoices after the purchase invoice date, no other docs that affect the stock. Commented out those lines and tried to submit. It was doing something for about 1 hour and 40 minutes (cpu load was nearly 80-90%, 1 python and 2 mysql processes) and catch again 504 Gateway Timeout error(I set timeout 6000 sec as mentioned in first post). I have total of 800 stock ledger entries and 150 GL entries, database near 10Mb. I think that there is some thing wrong, as data amount that I have cannot generate so many update delete insert queries. I enabled mysql log and tried the same landed cost voucher but with only 4 items instead of 190, and submitted successfully. It gave about 20 000 update delete insert queries and about 7 minute submitting.
Thank you team for such wonderful app, it becomes better and better.
@Hadzhi Is it possible to send me the backup of your database via email? That will help me a lot to investigate the issue. Only 4 Items in 1 hrs 40 mins, surely there is a problem with reposting logic.
Please let me know, otherwise I have to replicate the scenario with sufficient dummy data.
Thank you for your feedback. Yes sure, I will send you soon. A little remark, 190 items took 1 hour and 40 minutes, but didn’t finish. 4 items took about 7 minutes. But as I said there is no such amount of data to to take it so much.