Mysqld service failed to start

aaP_hazardtrader968

Can you tell me the solution to this problem? I have been trying to solve this problem for 2 days but it is not working.

aaPanel_Kern

Hello, please check the mysql error log
cat /www/server/data/*.err|grep -i -C 10 error

aaP_hazardtrader968

aaPanel_Kern send me your email lets solve there

aaP_hazardtrader968

aaPanel_Kern root@webserver1:~# cat /www/server/data/.err|grep -i -C 10 error
cat: '/www/server/data/.err': No such file or directory

aaPanel_Kern

Hello, I suggest you paste the error message

aaP_hazardtrader968

aaPanel_Kern

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

aaP_hazardtrader968

please stay here and solve my problem

aaP_hazardtrader968

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!

aaP_hazardtrader968

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.

aaPanel_Kern

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 start

aaP_hazardtrader968

aaPanel_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!

aaPanel_Kern

aaP_hazardtrader968

cd /etc/systemd/system/
rm mysqld.service mysql.service
systemctl daemon-reload
/etc/init.d/mysqld start

aaP_hazardtrader968

aaPanel_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#

aaPanel_Kern

aaP_hazardtrader968
please check the log: cat /www/server/data/*.err|grep -i -C 10 error

aaP_hazardtrader968

aaPanel_Kern root@webserver1:~# cat /www/server/data/.err | grep -i -C 10 error
cat: '/www/server/data/.err': No such file or directory

aaPanel_Kern

Hello, would you like to reinstall mysql?

aaP_hazardtrader968

yes

aaPanel_Kern

Will reinstalling fix it?

aaP_hazardtrader968

aaPanel_Kern no

aaP_hazardtrader968

Send me your email I'll give you my aa panel username password please fix it

aaPanel_Kern

It is recommended that you check the installation log: /tmp/panelExec.log

aaP_hazardtrader968