Merhaba,
Yeni bir sunucuda işlem sağlarken mysql bağlantısı belirli süre çalışıp kendini meşgule alıyor.
[2023-10-27 12:26:49.980] 731240:653b8259ecabb ERR [panel.ui] DB query failed: SQLSTATE[HY000] [2002] Connection refused<br><a href='http://kb.plesk.com/plesk-error/search?metaId=d97366041fd841d375c797bfbf879f60&messageId=6034252deb5922bce38f9749a93d75ca&file=Mysql.php&line>[2023-10-27 12:26:49.980] 731466:653b8259ec91d ERR [panel.ui] DB query failed: SQLSTATE[HY000] [2002] Connection refused<br><a href='http://kb.plesk.com/plesk-error/search?metaId=d97366041fd841d375c797bfbf879f60&messageId=6034252deb5922bce38f9749a93d75ca&file=Mysql.php&line>
[2023-10-27 12:26:50.089] 731465:653b825a15c27 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/Session/Helper.php:176
Plesk\Session\Helper::initStorage()
3: /opt/psa/admin/plib/auth.php:275
AutoPrepend->initUserSession()
4: /opt/psa/admin/plib/auth.php:188
AutoPrepend->run()
5: /opt/psa/admin/plib/auth.php:583
[2023-10-27 12:26:50.090] 731465:653b825a15c27 ERR [panel] Cannot load settings: DB query failed: SQLSTATE[HY000] [2002] Connection refused
[2023-10-27 12:26:50.100] 731465:653b825a15c27 ERR [panel] SQLSTATE[HY000] [2002] Connection refused
[2023-10-27 12:26:50.263] 731467:653b825a4037f ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/Session/Helper.php:176
Plesk\Session\Helper::initStorage()
3: /opt/psa/admin/plib/auth.php:275
AutoPrepend->initUserSession()
4: /opt/psa/admin/plib/auth.php:188
AutoPrepend->run()
5: /opt/psa/admin/plib/auth.php:583
Bulabildiğim log kaydı bu şekilde. Daha detaylı bir log bulamıyorum. Sunucum FASTCGI apache üzerinden hizmet sağlıyor.
Yaptığım ayarlar:
Additional directives for HTTP
<IfModule mod_fcgid.c>
FcgidBusyTimeout 3200
FcgidIOTimeout 3200
FcgidConnectTimeout 3200
FcgidMaxRequestsPerProcess 500
FcgidOutputBufferSize 0
FcgidProcessLifeTime 3600
</IfModule>
Additional directives for HTTPS
<IfModule mod_fcgid.c>
FcgidBusyTimeout 3200
FcgidIOTimeout 3200
FcgidConnectTimeout 3200
FcgidMaxRequestsPerProcess 500
FcgidOutputBufferSize 0
FcgidProcessLifeTime 3600
</IfModule>
Mysql için de my.cnf dosyamdaki değerler şu şekilde:
[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = 127.0.0.1
local-infile = 0
max_connections = 1000
connect_timeout = 5
wait_timeout = 28800
interactive_timeout = 28800
lock_wait_timeout = 31536000
max_allowed_packet = 32M
thread_cache_size = 128
sort_buffer_size = 4M
bulk_insert_buffer_size = 16M
tmp_table_size = 32M
max_heap_table_size = 32M
default_storage_engine = InnoDB
innodb_buffer_pool_size = 1024M
innodb_log_buffer_size = 8M
innodb_file_per_table = 1
innodb_open_files = 800
innodb_io_capacity = 800
innodb_flush_method = O_DIRECT
Herhangi bir ramde zorlanma vs de olmuyor. Kaynak değerlerim yeterince yüksek. Fakat bağlantının neden sonlandığını anlayamıyorum.
Sunucumda firewall aktif durumda. Burada takılan bir kısım oluyor diyeceğim ama net bir log bulamadım.