Hello, please check the mysql error log
cat /www/server/data/*.err|grep -i -C 10 error
Mysqld service failed to start
aaPanel_Kern send me your email lets solve there
Hello, I suggest you paste the error message
aaPanel_Kern root@webserver1:~# cat /www/server/data/.err|grep -i -C 10 error
cat: '/www/server/data/.err': No such file or directory
please stay here and solve my problem
Is it normal to use this command to start once: /etc/init.d/mysqld start
If it is abnormal, please check the log: cat /www/server/data/*.err|grep -i -C 10 error
aaPanel_Kern root@webserver1:~# /etc/init.d/mysqld start
Starting mysqld (via systemctl): mysqld.serviceJob for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
failed!
root@webserver1:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.39 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─tokudb.conf
Active: failed (Result: exit-code) since Mon 2024-08-26 07:10:13 UTC; 3min 27s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 219400 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUC>
Process: 219408 ExecStartPre=/bin/sh -c systemctl unset-environment WSREP_START_POSITION (code=exited, status=0/SU>
Process: 219409 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bi>
Process: 219611 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, st>
Main PID: 219611 (code=exited, status=7)
Status: "MariaDB server is down"
Aug 26 07:10:11 webserver1 systemd[1]: Starting MariaDB 10.3.39 database server...
Aug 26 07:10:12 webserver1 mysqld[219611]: 2024-08-26 7:10:12 0 [Warning] option 'max_allowed_packet': unsigned value >
Aug 26 07:10:12 webserver1 mysqld[219611]: 2024-08-26 7:10:12 0 [Warning] 'default-authentication-plugin' is MySQL 5.6>
Aug 26 07:10:12 webserver1 mysqld[219611]: 2024-08-26 7:10:12 0 [Warning] Could not increase number of max_open_files >
Aug 26 07:10:13 webserver1 systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING
Aug 26 07:10:13 webserver1 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Aug 26 07:10:13 webserver1 systemd[1]: Failed to start MariaDB 10.3.39 database server.
Hello, there is MariaDB installed using the apt command on your server. It is recommended that you deal with it.
Make a snapshot backup of the server before operation.
apt remove mariadb*
cd /etc/systemd/system/
rm mysqld.service mysql.service
systemctl daemon-reload
/etc/init.d/mysqld startaaPanel_Kern root@webserver1:~# apt remove mariadb*
e
systemctl daemon-reload
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'mariadb-rocksdb-engine-10.2' for glob 'mariadb'
Note, selecting 'mariadb-rocksdb-engine-10.3' for glob 'mariadb'
Note, selecting 'mariadb-test' for glob 'mariadb'
Note, selecting 'mariadb-test-data-10.0' for glob 'mariadb'
Note, selecting 'mariadb-testsuite-10.1' for glob 'mariadb'
Note, selecting 'mariadb-testsuite-10.3' for glob 'mariadb'
Note, selecting 'mariadb-test-data' for glob 'mariadb'
Note, selecting 'mariadb-plugin-cracklib-password-check' for glob 'mariadb'
Note, selecting 'mariadb-test-5.5' for glob 'mariadb'
Note, selecting 'mariadb-common' for glob 'mariadb'
Note, selecting 'mariadb-plugin-connect' for glob 'mariadb'
Note, selecting 'mariadb-server-core-5.5' for glob 'mariadb'
Note, selecting 'mariadb-server-5.1' for glob 'mariadb'
Note, selecting 'mariadb-server-5.2' for glob 'mariadb'
Note, selecting 'mariadb-server-5.3' for glob 'mariadb'
Note, selecting 'mariadb-server-5.5' for glob 'mariadb'
Note, selecting 'mariadb-tokudb-engine-5.5' for glob 'mariadb'
Note, selecting 'mariadb-server-core-10.0' for glob 'mariadb'
Note, selecting 'mariadb-server-core-10.1' for glob 'mariadb'
Note, selecting 'mariadb-server-core-10.2' for glob 'mariadb'
Note, selecting 'mariadb-server-core-10.3' for glob 'mariadb'
Note, selecting 'mariadb-connect-engine-10.0' for glob 'mariadb'
Note, selecting 'mariadb-connect-engine-10.1' for glob 'mariadb'
Note, selecting 'mariadb-galera-server' for glob 'mariadb'
Note, selecting 'mariadb-backup' for glob 'mariadb'
Note, selecting 'mariadb-client-5.5' for glob 'mariadb'
Note, selecting 'mariadb-server-10.0' for glob 'mariadb'
Note, selecting 'mariadb-server-10.1' for glob 'mariadb'
Note, selecting 'mariadb-server-10.2' for glob 'mariadb'
Note, selecting 'mariadb-server-10.3' for glob 'mariadb'
Note, selecting 'mariadb-plugin-oqgraph' for glob 'mariadb'
Note, selecting 'mariadb-plugin-gssapi-client' for glob 'mariadb'
Note, selecting 'mariadb-plugin-spider' for glob 'mariadb'
Note, selecting 'mariadb-galera-server-10.0' for glob 'mariadb'
Note, selecting 'mariadb-plugin-rocksdb' for glob 'mariadb'
Note, selecting 'mariadb-plugin-gssapi-server' for glob 'mariadb'
Note, selecting 'mariadb-plugin-tokudb' for glob 'mariadb'
Note, selecting 'mariadb-client-10.0' for glob 'mariadb'
Note, selecting 'mariadb-client-10.1' for glob 'mariadb'
Note, selecting 'mariadb-client-10.2' for glob 'mariadb'
Note, selecting 'mariadb-client-10.3' for glob 'mariadb'
Note, selecting 'mariadb-server' for glob 'mariadb'
Note, selecting 'mariadb-tokudb-engine-10.0' for glob 'mariadb'
Note, selecting 'mariadb-tokudb-engine-10.1' for glob 'mariadb'
Note, selecting 'mariadb-client-core-10.0' for glob 'mariadb'
Note, selecting 'mariadb-client-core-10.1' for glob 'mariadb'
Note, selecting 'mariadb-client-core-10.2' for glob 'mariadb'
Note, selecting 'mariadb-client-core-10.3' for glob 'mariadb'
Note, selecting 'mariadb-client' for glob 'mariadb'
Note, selecting 'mariadb-test-10.0' for glob 'mariadb'
Note, selecting 'mariadb-test-10.1' for glob 'mariadb'
Note, selecting 'mariadb-oqgraph-engine-10.0' for glob 'mariadb'
Note, selecting 'mariadb-oqgraph-engine-10.1' for glob 'mariadb'
Note, selecting 'mariadb-galera-server-5.5' for glob 'mariadb'
Note, selecting 'mariadb-client-core-5.5' for glob 'mariadb'
Note, selecting 'mariadb-gssapi-server-10.1' for glob 'mariadb'
Note, selecting 'mariadb-gssapi-server-10.2' for glob 'mariadb'
Note, selecting 'mariadb-gssapi-client-10.1' for glob 'mariadb'
Note, selecting 'mariadb-gssapi-client-10.2' for glob 'mariadb'
Note, selecting 'mariadb-plugin-mroonga' for glob 'mariadb'
Note, selecting 'mariadb-backup-10.1' for glob 'mariadb'
Note, selecting 'mariadb-backup-10.2' for glob 'mariadb'
Package 'mariadb-client-10.1' is not installed, so not removed
Package 'mariadb-client-core-10.1' is not installed, so not removed
Package 'mariadb-server-5.5' is not installed, so not removed
Package 'mariadb-server-10.1' is not installed, so not removed
Package 'mariadb-server-core-10.1' is not installed, so not removed
Package 'mariadb-galera-server-10.0' is not installed, so not removed
Package 'mariadb-galera-server-5.5' is not installed, so not removed
Package 'mariadb-server-10.0' is not installed, so not removed
Package 'mariadb-server-5.1' is not installed, so not removed
Package 'mariadb-server-5.2' is not installed, so not removed
Package 'mariadb-server-5.3' is not installed, so not removed
Package 'mariadb-backup-10.1' is not installed, so not removed
Package 'mariadb-backup-10.2' is not installed, so not removed
Package 'mariadb-client-10.0' is not installed, so not removed
Package 'mariadb-client-10.2' is not installed, so not removed
Package 'mariadb-client-5.5' is not installed, so not removed
Package 'mariadb-client-core-10.0' is not installed, so not removed
Package 'mariadb-client-core-10.2' is not installed, so not removed
Package 'mariadb-client-core-5.5' is not installed, so not removed
Package 'mariadb-connect-engine-10.0' is not installed, so not removed
Package 'mariadb-connect-engine-10.1' is not installed, so not removed
Package 'mariadb-gssapi-client-10.1' is not installed, so not removed
Package 'mariadb-gssapi-client-10.2' is not installed, so not removed
Package 'mariadb-gssapi-server-10.1' is not installed, so not removed
Package 'mariadb-gssapi-server-10.2' is not installed, so not removed
Package 'mariadb-oqgraph-engine-10.0' is not installed, so not removed
Package 'mariadb-oqgraph-engine-10.1' is not installed, so not removed
Package 'mariadb-rocksdb-engine-10.2' is not installed, so not removed
Package 'mariadb-rocksdb-engine-10.3' is not installed, so not removed
Package 'mariadb-tokudb-engine-10.0' is not installed, so not removed
Package 'mariadb-tokudb-engine-10.1' is not installed, so not removed
Package 'mariadb-tokudb-engine-5.5' is not installed, so not removed
Package 'mariadb-galera-server' is not installed, so not removed
Package 'mariadb-server-10.2' is not installed, so not removed
Package 'mariadb-server-core-10.0' is not installed, so not removed
Package 'mariadb-server-core-10.2' is not installed, so not removed
Package 'mariadb-server-core-5.5' is not installed, so not removed
Package 'mariadb-test-10.0' is not installed, so not removed
Package 'mariadb-test-10.1' is not installed, so not removed
Package 'mariadb-test-5.5' is not installed, so not removed
Package 'mariadb-test-data-10.0' is not installed, so not removed
Package 'mariadb-testsuite-10.1' is not installed, so not removed
Package 'mariadb-testsuite-10.3' is not installed, so not removed
The following packages were automatically installed and are no longer required:
cracklib-runtime galera-3 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libcrack2 libdbd-mysql-perl
libdbi-perl libencode-locale-perl libfcgi-perl libgflags2.2 libhtml-parser-perl libhtml-tagset-perl
libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl libjudydebian1 liblwp-mediatypes-perl
libodbc1 odbcinst odbcinst1debian2 python3-mysqldb rcs rocksdb-tools unixodbc
Use 'apt autoremove' to remove them.
The following packages will be REMOVED:
libmariadb-dev libmariadb3 libmariadbclient-dev mariadb-backup mariadb-client mariadb-client-10.3
mariadb-client-core-10.3 mariadb-common mariadb-plugin-connect mariadb-plugin-cracklib-password-check
mariadb-plugin-gssapi-client mariadb-plugin-gssapi-server mariadb-plugin-mroonga mariadb-plugin-oqgraph
mariadb-plugin-rocksdb mariadb-plugin-spider mariadb-plugin-tokudb mariadb-server mariadb-server-10.3
mariadb-server-core-10.3 mariadb-test mariadb-test-data
0 upgraded, 0 newly installed, 22 to remove and 0 not upgraded.
After this operation, 601 MB disk space will be freed.
Do you want to continue? [Y/n] Abort.
root@webserver1:~# systemctl daemon-reload
root@webserver1:~# /etc/init.d/mysqld start
Starting mysqld (via systemctl): mysqld.serviceJob for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
failed!
cd /etc/systemd/system/
rm mysqld.service mysql.service
systemctl daemon-reload
/etc/init.d/mysqld startaaPanel_Kern root@webserver1:~# cd /etc/systemd/system/
root@webserver1:/etc/systemd/system# rm mysqld.service mysql.service
root@webserver1:/etc/systemd/system# systemctl daemon-reload
troot@webserver1:/etc/systemd/system# /etc/init.d/mysqld start
Starting mysqld (via systemctl): mysqld.serviceJob for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
failed!
root@webserver1:/etc/systemd/system#
aaP_hazardtrader968
please check the log: cat /www/server/data/*.err|grep -i -C 10 error
aaPanel_Kern root@webserver1:~# cat /www/server/data/.err | grep -i -C 10 error
cat: '/www/server/data/.err': No such file or directory
Hello, would you like to reinstall mysql?
Will reinstalling fix it?
Send me your email I'll give you my aa panel username password please fix it
It is recommended that you check the installation log: /tmp/panelExec.log