Dear team,
My site goes makes un responsive after some time then again it will become access , like that happening,
i have turned Fail2ban off so it not that issue, and after that i had to restart my supervisorctl to start active again
There could be thousand different reasons. Please provide more information; environment, hosting, versions, server logs, apps; etc…
If you are on a bench development mode then some users have reported the kernel kills the process due to low RAM
Also journalctl & dmesg logs might give more clues
we have deployed in azure server with 16 GB RAM and 4 core CPU
total used free shared buff/cache available
Mem: 15Gi 3.1Gi 8.1Gi 4.0Mi 4.4Gi 12Gi
Swap: 4.0Gi 0B 4.0Gi
like this when free -h coming, also when doing htop it is not maximum
also we have added following in mysql in 50-server.cnf
default_storage_engine = InnoDB
innodb_buffer_pool_size = 6G
innodb_log_buffer_size = 1G
innodb_file_per_table = 1
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 2
innodb_open_files = 400
innodb_io_capacity = 400
innodb_flush_method = O_DIRECT
slow_query_log = 1
long_query_time = 2
to make balance sql and
[program:frappe-bench-frappe-web]
command=/home/frappe/frappe-bench/env/bin/gunicorn -b 127.0.0.1:8000 -w 5 --timeout 600 --worker-connections 2000 --max> in the file to address as we use 5 workers and timeout also
also at that time of hanging when we do mysql -uroot -p -e “SHOW FULL PROCESSLIST\G”
*************************** 1. row ***************************
Id: 9389
User: _17ccbe685e69e08d
Host: localhost:34866
db: _17ccbe685e69e08d
Command: Sleep
Time: 544
State:
Info: NULL
Progress: 0.000
*************************** 2. row ***************************
Id: 9390
User: _17ccbe685e69e08d
Host: localhost:45452
db: _17ccbe685e69e08d
Command: Sleep
Time: 544
State:
Info: NULL
Progress: 0.000
*************************** 3. row ***************************
Id: 9402
User: _17ccbe685e69e08d
Host: localhost:60646
db: _17ccbe685e69e08d
Command: Sleep
Time: 531
State:
Info: NULL
Progress: 0.000
*************************** 4. row ***************************
Id: 9451
User: _17ccbe685e69e08d
Host: localhost:44342
db: _17ccbe685e69e08d
Command: Sleep
Time: 4
State:
Info: NULL
Progress: 0.000
*************************** 5. row ***************************
Id: 9497
User: _17ccbe685e69e08d
Host: localhost:55306
db: _17ccbe685e69e08d
Command: Sleep
Time: 0
State:
Info: NULL
Progress: 0.000
*************************** 6. row ***************************
Id: 9498
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: starting
Info: SHOW FULL PROCESSLIST
Progress: 0.000
How did you deploy it? Docker? Bench CLI?
this is production server