uwsgi Broken pipe
Note: 为了方便多处发表所以用了英文
Created: Jul 30, 2019 2:49 PM
Last Edited Time: Aug 02, 2019 9:58 PM
Status: Draft
Issue Description
- Happen when saving purchase formset in Supplier Admin page.
1.png
Reason
May cause by the multiple actions of calculating and saving the summary records that every time a purchase record is saved.
Possible Solution
1. Change signal to crontab
Drowback of this approach is:
- Can't see the data change right after the user submit new data. Add a [Update Now] botton to manually update
- Extra effort to setup crontab on server
- Every time restart container may need to restart crontab service
2. Set the max_num to inline formset
This is a workaround, it reduces the times of database writing at the same request. So as to reduce the possibility of Broken pipe or connection timeout!
# apps/purchase/admin.py
class MaterialPurchaseInline(BaseTransactionInline):
model = MaterialPurchase
form = MaterialPurchaseInlineForm
max_num = 10 # <---- also set to BaseTransactionInline
Action Plan
- Exame my Hypothesis: Stop the signals submit a 30 records formset, see if error accore.
- If yes:
- Write another view linked to a botton to manually update the record
- Create a crontab
- If Not:
- Seek other solution
