Page is loading late

ByEzel

Waiting too long while making a request to the relevant page. I stopped and uninstalled Fail2Ban. I reset the server but the problem is not solved. never had such a problem before

aaPanel_Kern

It is recommended to check the website log and php slow log, mysql slow log, this is generally a problem of slow data display

ByEzel

aaPanel_Kern

I checked the log records, but I couldn't see any problem with this situation.

Website Access Log

14.191.30.20 - - [17/Mar/2023:09:12:39 +0000] ＂GET /assets/fonts/flUhRq6tzZclQEJ-Vdg-IuiaDsNcIhQ8tQ.woff2 HTTP/2.0＂ 200 121680 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:39 +0000] ＂GET /assets/fonts/KFOmCnqEu92Fr1Mu4mxKKTU1Kg.woff2 HTTP/2.0＂ 200 11032 ＂https://10minutesemail.net/assets/css/fonts.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:39 +0000] ＂GET /assets/fonts/KFOlCnqEu92Fr1MmSU5fBBc4AMP6lQ.woff2 HTTP/2.0＂ 200 11132 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
101.109.3.24 - - [17/Mar/2023:09:12:39 +0000] ＂POST /getEmailAddress HTTP/2.0＂ 200 136 ＂https://10minutesemail.net/＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.41＂
171.224.181.116 - - [17/Mar/2023:09:12:40 +0000] ＂POST /Email/getInbox HTTP/2.0＂ 200 2 ＂https://10minutesemail.net/faq＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
171.224.181.116 - - [17/Mar/2023:09:12:40 +0000] ＂POST /getEmailAddress HTTP/2.0＂ 200 135 ＂https://10minutesemail.net/faq＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:40 +0000] ＂GET /assets/fonts/KFOlCnqEu92Fr1MmSU5fChc4AMP6lbBP.woff2 HTTP/2.0＂ 200 7836 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:40 +0000] ＂GET /assets/fonts/KFOmCnqEu92Fr1Mu7GxKKTU1Kvnz.woff2 HTTP/2.0＂ 200 7700 ＂https://10minutesemail.net/assets/css/fonts.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:40 +0000] ＂GET /assets/fonts/KFOlCnqEu92Fr1MmWUlfBBc4AMP6lQ.woff2 HTTP/2.0＂ 200 11048 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:40 +0000] ＂GET /assets/fonts/KFOlCnqEu92Fr1MmEU9fBBc4AMP6lQ.woff2 HTTP/2.0＂ 200 11048 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:40 +0000] ＂GET /assets/fonts/KFOlCnqEu92Fr1MmEU9fChc4AMP6lbBP.woff2 HTTP/2.0＂ 200 7696 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂
14.191.30.20 - - [17/Mar/2023:09:12:40 +0000] ＂GET /assets/fonts/KFOlCnqEu92Fr1MmWUlfChc4AMP6lbBP.woff2 HTTP/2.0＂ 200 7656 ＂https://10minutesemail.net/assets/css/style.min.css?ver=1.2.5＂＂Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36＂

Website Error Log

2023/03/17 08:44:01 [crit] 117320#0: *811 connect() to unix:/tmp/php-cgi-74.sock failed (2: No such file or directory) while connecting to upstream, client: 197.210.77.19, server: 10minutesemail.net, request: ＂POST /getServerTime HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:44:02 [crit] 117320#0: *20 connect() to unix:/tmp/php-cgi-74.sock failed (2: No such file or directory) while connecting to upstream, client: 103.85.9.45, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/en/email?id=1＂
2023/03/17 08:44:03 [crit] 117320#0: *27 connect() to unix:/tmp/php-cgi-74.sock failed (2: No such file or directory) while connecting to upstream, client: 114.79.16.198, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/id＂
2023/03/17 08:44:03 [crit] 117320#0: *811 connect() to unix:/tmp/php-cgi-74.sock failed (2: No such file or directory) while connecting to upstream, client: 197.210.77.19, server: 10minutesemail.net, request: ＂POST /getEmailAddress HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:51:21 [error] 4371#0: *14 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 213.109.48.211, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:51:21 [error] 4371#0: *16 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 112.197.34.132, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/vi＂
2023/03/17 08:51:21 [error] 4371#0: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 160.154.248.48, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/fr/email?id=1＂
2023/03/17 08:51:21 [error] 4371#0: *2 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 175.100.105.158, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:51:21 [error] 4371#0: *1 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 121.171.209.172, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:51:21 [error] 4371#0: *2 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 175.100.105.158, server: 10minutesemail.net, request: ＂POST /getEmailAddress HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:51:21 [error] 4371#0: *1 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 121.171.209.172, server: 10minutesemail.net, request: ＂POST /getEmailAddress HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/＂
2023/03/17 08:51:21 [error] 4371#0: *10 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 85.242.138.160, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/en/email?id=1＂
2023/03/17 08:51:22 [crit] 4371#0: *20 connect() to unix:/tmp/php-cgi-74.sock failed (2: No such file or directory) while connecting to upstream, client: 66.249.69.35, server: 10minutesemail.net, request: ＂GET /tr HTTP/1.1＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂
2023/03/17 08:56:34 [error] 4371#0: *938 open() ＂/www/wwwroot/10minutesemail.net/.well-known/traffic-advice＂ failed (2: No such file or directory), client: 66.249.81.55, server: 10minutesemail.net, request: ＂GET /.well-known/traffic-advice HTTP/1.1＂, host: ＂10minutesemail.net＂

Php Slow Log

[17-Mar-2023 09:15:13] [pool www] pid 7438
script_filename = /www/wwwroot/10minutesemail.net/index.php
[0x00007f71e46145c0] imap_sort() /www/wwwroot/10minutesemail.net/app/Controllers/Email.php:59
[0x00007f71e4613f30] inboxEmails() /www/wwwroot/10minutesemail.net/app/Controllers/Email.php:94
[0x00007f71e4613e30] getInbox() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:914
[0x00007f71e4613cb0] runController() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:400
[0x00007f71e46137f0] handleRequest() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:308
[0x00007f71e4613530] run() /www/wwwroot/10minutesemail.net/index.php:66

[17-Mar-2023 09:15:13] [pool www] pid 8143
script_filename = /www/wwwroot/10minutesemail.net/index.php
[0x00007f71e46165c0] imap_sort() /www/wwwroot/10minutesemail.net/app/Controllers/Email.php:59
[0x00007f71e4615f30] inboxEmails() /www/wwwroot/10minutesemail.net/app/Controllers/Email.php:94
[0x00007f71e4615e30] getInbox() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:914
[0x00007f71e4615cb0] runController() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:400
[0x00007f71e46157f0] handleRequest() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:308
[0x00007f71e4615530] run() /www/wwwroot/10minutesemail.net/index.php:66

[17-Mar-2023 09:15:13] [pool www] pid 8146
script_filename = /www/wwwroot/10minutesemail.net/index.php
[0x00007f71e4617970] flock() /www/wwwroot/10minutesemail.net/system/Session/Handlers/FileHandler.php:160
[0x00007f71e4617510] read() /www/wwwroot/10minutesemail.net/system/Session/Session.php:1005
[0x00007f71e46174c0] session_start() /www/wwwroot/10minutesemail.net/system/Session/Session.php:1005
[0x00007f71e4617420] startSession() /www/wwwroot/10minutesemail.net/system/Session/Session.php:240
[0x00007f71e4616e90] start() /www/wwwroot/10minutesemail.net/system/Config/Services.php:778
[0x00007f71e4616c40] session() /www/wwwroot/10minutesemail.net/system/Config/BaseService.php:123
[0x00007f71e4616ad0] getSharedInstance() /www/wwwroot/10minutesemail.net/system/Config/Services.php:759
[0x00007f71e46168a0] session() /www/wwwroot/10minutesemail.net/system/Common.php:894
[0x00007f71e46167f0] session() /www/wwwroot/10minutesemail.net/app/Views/404.php:2

Mysql Slow Log

Rows_affected: 0 Bytes_sent: 343

use 10minutes_db;
SET timestamp=1678902449;
SELECT *
FROM emails
WHERE address = 'cflrn3yh8n@edu.email.edu.pl';

Time: 230315 18:37:24

User@Host: 10minutes_db[10minutes_db] @ localhost []

Thread_id: 19301 Schema: 10minutes_db QC_hit: No

Query_time: 3.173604 Lock_time: 0.000107 Rows_sent: 0 Rows_examined: 2026275

Rows_affected: 0 Bytes_sent: 343

SET timestamp=1678905444;
SELECT *
FROM emails
WHERE address = '3qgmjpmear@email.edu.pl';

Time: 230315 20:57:35

User@Host: 10minutes_db[10minutes_db] @ localhost []

Thread_id: 26744 Schema: 10minutes_db QC_hit: No

Query_time: 3.908186 Lock_time: 0.003622 Rows_sent: 0 Rows_examined: 2026527

Rows_affected: 0 Bytes_sent: 343

SET timestamp=1678913855;
SELECT *
FROM emails
WHERE address = 'rn06mpsctx@edu.email.edu.pl';

Time: 230315 21:06:41

User@Host: 10minutes_db[10minutes_db] @ localhost []

Thread_id: 27096 Schema: 10minutes_db QC_hit: No

Query_time: 3.721132 Lock_time: 0.000153 Rows_sent: 0 Rows_examined: 2026535

Rows_affected: 0 Bytes_sent: 343

SET timestamp=1678914401;
SELECT *
FROM emails
WHERE address = '9abdc5ilkk@edu.email.edu.pl';
/www/server/mysql/bin/mariadbd, Version: 10.7.3-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument

Time: 230315 23:00:10

User@Host: root[root] @ localhost []

Thread_id: 32467 Schema: 10minutes_db QC_hit: No

Query_time: 7.317549 Lock_time: 0.000048 Rows_sent: 2026726 Rows_examined: 2026726

Rows_affected: 0 Bytes_sent: 153496416

use 10minutes_db;
SET timestamp=1678921210;
SELECT /*!40001 SQL_NO_CACHE */ id, address, creation_time, recover_key, ip FROM emails;

Time: 230315 23:00:55

User@Host: root[root] @ localhost []

Thread_id: 32534 Schema: cilt_bakimlarim QC_hit: No

Query_time: 3.764886 Lock_time: 0.000045 Rows_sent: 2390938 Rows_examined: 2390938

Rows_affected: 0 Bytes_sent: 187320262

use cilt_bakimlarim;
SET timestamp=1678921255;
SELECT /*!40001 SQL_NO_CACHE */ id, camp_id, level, message, created FROM wpho_auto_robot_logs;

Time: 230316 7:27:26

User@Host: 10minutes_db[10minutes_db] @ localhost []

Thread_id: 59249 Schema: 10minutes_db QC_hit: No

Query_time: 3.537158 Lock_time: 0.000382 Rows_sent: 0 Rows_examined: 2027783

Rows_affected: 0 Bytes_sent: 343

use 10minutes_db;
SET timestamp=1678951646;
SELECT *
FROM emails
WHERE address = 'orqm2xbjh7@email.edu.pl';

Time: 230316 10:40:09

User@Host: 10minutes_db[10minutes_db] @ localhost []

Thread_id: 73178 Schema: 10minutes_db QC_hit: No

Query_time: 3.179325 Lock_time: 0.000071 Rows_sent: 0 Rows_examined: 2028356

Rows_affected: 0 Bytes_sent: 343

SET timestamp=1678963209;
SELECT *
FROM emails
WHERE address = 'qkbcunwtrh@edu.email.edu.pl';
/www/server/mysql/bin/mariadbd, Version: 10.7.3-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument

Time: 230316 23:00:08

User@Host: root[root] @ localhost []

Thread_id: 139847 Schema: 10minutes_db QC_hit: No

Query_time: 7.221940 Lock_time: 0.000000 Rows_sent: 2030543 Rows_examined: 2030543

Rows_affected: 0 Bytes_sent: 153768277

use 10minutes_db;
SET timestamp=1679007608;
SELECT /*!40001 SQL_NO_CACHE */ id, address, creation_time, recover_key, ip FROM emails;

Time: 230316 23:00:51

User@Host: root[root] @ localhost []

Thread_id: 139892 Schema: cilt_bakimlarim QC_hit: No

Query_time: 3.922289 Lock_time: 0.000045 Rows_sent: 2402593 Rows_examined: 2402593

Rows_affected: 0 Bytes_sent: 188212090

use cilt_bakimlarim;
SET timestamp=1679007651;
SELECT /*!40001 SQL_NO_CACHE */ id, camp_id, level, message, created FROM wpho_auto_robot_logs;
/www/server/mysql/bin/mariadbd, Version: 10.7.3-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mariadbd, Version: 10.7.3-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mariadbd, Version: 10.7.3-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument

aaPanel_Kern

ByEzel
2023/03/17 08:44:03 [crit] 117320#0: *27 connect() to unix:/tmp/php-cgi-74.sock failed (2: No such file or directory) while connecting to upstream, client: 114.79.16.198, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/id＂

2023/03/17 08:51:21 [error] 4371#0: *10 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 85.242.138.160, server: 10minutesemail.net, request: ＂POST /Email/getInbox HTTP/2.0＂, upstream: ＂fastcgi://unix:/tmp/php-cgi-74.sock:＂, host: ＂10minutesemail.net＂, referrer: ＂https://10minutesemail.net/en/email?id=1＂

Php Slow Log

[17-Mar-2023 09:15:13] [pool www] pid 7438
script_filename = /www/wwwroot/10minutesemail.net/index.php
[0x00007f71e46145c0] imap_sort() /www/wwwroot/10minutesemail.net/app/Controllers/Email.php:59
[0x00007f71e4613f30] inboxEmails() /www/wwwroot/10minutesemail.net/app/Controllers/Email.php:94
[0x00007f71e4613e30] getInbox() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:914
[0x00007f71e4613cb0] runController() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:400
[0x00007f71e46137f0] handleRequest() /www/wwwroot/10minutesemail.net/system/CodeIgniter.php:308
[0x00007f71e4613530] run() /www/wwwroot/10minutesemail.net/index.php:66

looks like

php did not start the problem, or no response
PHP runs slowly

ByEzel

aaPanel_Kern
There was no such problem before. how can i fix this error?

aaPanel_Kern

Check if php is normal, if not, start php once.
The problem of slow log requires website program development to check whether there is any problem

ByEzel

aaPanel_Kern
There is no problem with the software I use. because different hosting and servers also work smoothly. There was no such problem before. started to be new. PHP is also working normally. I tried restarting. no problem.

aaPanel_Kern

The log has stated