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 replied to this.
  • Hello, it has been processed and the processing process is:
    mv /www/server/data /www/server/data_bak
    mv /www/server/mysql /www/server/mysql_bak
    dpkg -r bt-mysql80
    Install mysql 5.7 in aapanel

    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!

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

          aaP_hazardtrader968

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

            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#