@pioneerpathan By this server still responsive and keep unfreeze. But still gunicorn taking more memory and facing hang issue in server system.
Frappe Framework: v16.10.7 (version-16)
ERPNext: v16.7.3 (version-16)
Frappe HR: v16.4.2 (version-16)
Note: Before our inno_db_pool_size is 12 MB only, i updated it to 16 GB
How many gunicorns are there?
Hi @pioneerpathan ,
we have 6 currently, and optimization in one of our query resolved this issue. Even i have verified your steps as well. Thanks for the support.
In mycase, We have separate Application server and Database server still Swap memory for Application Server getting full sometimes. A quick solution to make empty swap is
sudo swapoff -a
And again turned on
sudo swapon -a
Please note this is not a solution just quick way to make swap empty.
CAUTION: But you should not run these commands when you don’t have sufficient memory free, otherwise your server may get trapped in problematic condition. Especially production server it is not recommended. In your case as application server is in separate server, you may restrict memory swappiness as I mentioned earlier and limit gunicorn workers.
