MySQL 5.7.37 on AaPanel getting automatically stopped frequently, like weekly or so. How/where can I find out what is causing this issue? It is a Pro account and I have Website Statitistics 6.1, Apache WAF 8.8, website tamper-proof etc. already installed. Thanks in advance.

System: Debian GNU/Linux 11 x86_64(Py3.12.3) 64 GB RAM, 16 Cores CPU this is the result of running the command: dmesg|grep -iE "kill|httpd|apache|http|mysql|oom" [4242352.438309] omiengine invoked oom-killer: gfp_mask=0x100cca(GFP_HIGHUSER_MOVABLE), order=0, oom_score_adj=0 [4242352.469180] oom_kill_process.cold+0xb/0x10 [4242352.739794] [ pid ] uid tgid total_vm rss pgtables_bytes swapents oom_score_adj name [4242352.903167] [ 8679] 0 8679 108995 106185 917504 0 0 httpd [4242352.907987] [ 10126] 0 10126 1513 127 53248 0 0 mysqld_safe [4242352.953498] [3123960] 1002 3123960 5206738 1741443 15974400 0 0 mysqld [4242353.503650] [1961434] 1001 1961434 1256058 52864 921600 0 0 httpd [4242353.508083] [1961529] 1001 1961529 1273622 61987 1003520 0 0 httpd [4242353.512540] [1961610] 1001 1961610 1257230 50176 888832 0 0 httpd [4242353.516980] [1961729] 1001 1961729 1273622 53969 937984 0 0 httpd [4242353.521799] [1963943] 1001 1963943 1240846 30760 712704 0 0 httpd [4242353.540728] [1978758] 1001 1978758 1158926 26970 643072 0 0 httpd [4242353.545151] [1981020] 1001 1981020 1261328 40754 868352 0 0 httpd [4242353.549659] [1981221] 1001 1981221 1052426 26303 638976 0 0 httpd [4242353.554799] [1981308] 1001 1981308 1273622 37784 872448 0 0 httpd [4242353.559304] [1981733] 1001 1981733 1052426 34832 753664 0 0 httpd [4242353.563807] [1981843] 1001 1981843 1052426 27262 671744 0 0 httpd [4242353.568595] [1981981] 1001 1981981 1052426 27789 667648 0 0 httpd [4242353.573033] [1983432] 1001 1983432 675594 13651 466944 0 0 httpd [4242353.818753] [1985559] 1001 1985559 741130 16552 471040 0 0 httpd [4242354.175644] [1985874] 1001 1985874 1181457 26925 655360 0 0 httpd [4242354.265558] [1985970] 1001 1985970 1052426 19151 585728 0 0 httpd [4242354.429301] [1986118] 1001 1986118 1052426 21976 577536 0 0 httpd [4242354.774787] [1986457] 1001 1986457 724746 14783 479232 0 0 httpd [4242355.189574] [1986651] 1001 1986651 741130 14741 471040 0 0 httpd [4242355.391877] [1986882] 1001 1986882 675594 13211 462848 0 0 httpd [4242355.989023] [1987825] 1001 1987825 658038 3725 417792 0 0 httpd [4242355.999626] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=omid.service,mems_allowed=0,global_oom,task_memcg=/system.slice/mysqld.service,task=mysqld,pid=3123960,uid=1002 [4242356.009541] Out of memory: Killed process 3123960 (mysqld) total-vm:20826952kB, anon-rss:6965772kB, file-rss:0kB, shmem-rss:0kB, UID:1002 pgtables:15600kB oom_score_adj:0

aboobacker [4242356.009541] Out of memory: Killed process 3123960 (mysqld) total-vm:20826952kB, anon-rss:6965772kB, file-rss:0kB, shmem-rss:0kB, UID:1002 pgtables:15600kB oom_score_adj:0 Mysqld was killed because RAM was not enough. Try to allocate more RAM. What is you Server specification?

Hello, Can you check whether the total running memory of the configured software exceeds the physical memory? Check mysql's slow logs at the same time

Hello, MySQL stopped again this morning. System configuration is: Debian GNU/Linux 11 x86_64(Py3.12.3) / 64 GB RAM / 16 Cores CPU Here is the MySQL Slow log: `l.code, l.id, english_name, nt.name AS native_name, major, active, default_locale, encode_url, tag, lt.name AS display_name FROM tdnrn_icl_languages l JOIN tdnrn_icl_languages_translations nt ON ( nt.language_code = l.code AND nt.display_language_code = l.code ) LEFT OUTER JOIN tdnrn_icl_languages_translations lt ON l.code=lt.language_code WHERE ( lt.display_language_code = 'en' OR (lt.display_language_code = 'en' AND NOT EXISTS ( SELECT * FROM tdnrn_icl_languages_translations ls WHERE ls.language_code = l.code AND ls.display_language_code = 'en' ) ) ) GROUP BY l.code ORDER BY english_name ASC; Time: 2025-06-08T22:25:44.197075Z User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 85 Query_time: 6.727249 Lock_time: 0.090269 Rows_sent: 262 Rows_examined: 287 SET timestamp=1749421544; SELECT name, val FROM tdnrn_wfconfig WHERE autoload = 'yes'; Time: 2025-06-08T22:25:44.454885Z User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 139 Query_time: 6.851179 Lock_time: 0.024185 Rows_sent: 262 Rows_examined: 287 SET timestamp=1749421544; SELECT name, val FROM tdnrn_wfconfig WHERE autoload = 'yes'; Time: 2025-06-08T22:25:44.888891Z User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 158 Query_time: 7.268808 Lock_time: 0.269380 Rows_sent: 65 Rows_examined: 325 SET timestamp=1749421544; SELECT l.code, l.id, english_name, nt.name AS native_name, major, active, default_locale, encode_url, tag, lt.name AS display_name FROM tdnrn_icl_languages l JOIN tdnrn_icl_languages_translations nt ON ( nt.language_code = l.code AND nt.display_language_code = l.code ) LEFT OUTER JOIN tdnrn_icl_languages_translations lt ON l.code=lt.language_code WHERE ( lt.display_language_code = 'en' OR (lt.display_language_code = 'en' AND NOT EXISTS ( SELECT * FROM tdnrn_icl_languages_translations ls WHERE ls.language_code = l.code AND ls.display_language_code = 'en' ) ) ) GROUP BY l.code ORDER BY english_name ASC; Time: 2025-06-08T22:25:45.295349Z User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 149 Query_time: 7.691104 Lock_time: 0.206105 Rows_sent: 1 Rows_examined: 2649 SET timestamp=1749421545; SELECT count(*) FROM tdnrn_options WHERE option_name LIKE 'jpsq_sync-%'; /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument Time: 2025-06-08T22:32:13.031727Z User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 16 Query_time: 4.187719 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use sql_thefirstcoll; SET timestamp=1749421933; SELECT COUNT(*) FROM tdnrn_hurrytimer_evergreen; /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument`

MySQL server automatically stopping frequently

aboobacker

Hi, runjing the above command returns this error:

sudo: unable to resolve host DebianVMWPSites1: Temporary failure in name resolution

While figuring it out with the IT team, can I enable the "Memory protection" setting?

or, enable the cron job "Start MySQL"?

Kindly advise.

aaPanel_Kern

Recommend to enable this

aboobacker

aaPanel_Kern

aboobacker sudo: unable to resolve host DebianVMWPSites1: Temporary failure in name resolution

This error is caused by not configuring /etc/hosts pointing to 127.0.0.1

aboobacker

aaPanel_Kern
Thanks. It shows this error when enabling the Daemon:

But, System Hardening is not enabled.

aaPanel_Kern

Try to close System hardening
Or turn off special permissions and add
chattr -i /var/spool/cron/crontabs/root

aboobacker

when runnign this command, it still shows:

sudo: unable to resolve host DebianVMWPSites1: Temporary failure in name resolution

in hosts file I see there is already 127.0.0.1 localhost added.

aaP_kotakomputer.ceo

aboobacker

Just pointing DebianVMWPSites1 to 127.0.0.1 as shown below:

127.0.0.1 localhost
127.0.0.1 DebianVMWPSites1

aboobacker

aaP_kotakomputer.ceo Thanks. It worked 🙂 I have enabled the mySQL Daemon. Will see if it solves the issue. Thanks

aboobacker

Hi, when I check the logs of mysql daemon cron, it shows "btpython - command not found". Is there anything I should do in this case? MySQL server is running fine currently though.

btpython /www/server/panel/script/restart_services.py mysql

aaPanel_Kern

Is it normal to try to generate btpyhon manually?

ln -sf /www/server/panel/pyenv/bin/python3 /usr/bin/btpython

aboobacker

Running the above command shows below error (even with sudo):

ln: failed to create symbolic link '/usr/bin/btpython': Operation not permitted

Is it fine to try the below instead?

sudo ln -sf /www/server/panel/pyenv/bin/python3 /usr/local/bin/btpython

aaPanel_Kern

aboobacker
Yes, you try

aboobacker

aaPanel_Kern Still getting the error:

ln: failed to create symbolic link '/usr/local/bin/btpython': Operation not permitted

FYI - I have these addons installed in AaPanel. Could it be blocked by any of these?

aaPanel_Kern

Are System hardening used?

aboobacker

aaPanel_Kern

No. System hardening is not installed.

aaPanel_Kern

Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:

No post link will not be able to know which user's information is, and the problem will not be processed

aboobacker

Sure, will send the details today by email. Thanks.