Upgraded to the Latest Stable - Upgraded Mariadb and database died

Please fill in any relevant information that applies to you:

• CentOS Version: i.e. CentOS 7 64bit
• Centmin Mod Version Installed: 131.00stable
• Nginx Version Installed: 1.27.1
• PHP Version Installed: 8.3.11
• MariaDB MySQL Version Installed: 10.4
• When was last time updated Centmin Mod code base ? : i.e. run centmin.sh menu option 23 submenu option 2 or cmupdate command
• Persistent Config:
  
  Code (Text):

  cat /etc/centminmod/custom_config.inc
  

• 
  
• This is the error that happened between MariaDB 10.4 and 10.5 (option 9)
• 
  
  Code:

  -------------------------------------------------------------------------------
  
   Please test on a test server and not a live production server. But if you use 
  
   on live server or if MySQL databases already exist, please back them up before 
  
   running this upgrade script via mysqldump - instructions at: 
  
   http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.
  
  
   ###################################################################
  
   ###          IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE          ###
  
   ###        OR RISK DATA LOSS DUE TO MARIADB 10.5 Changes        ###
  
   ###################################################################
  
  
   For each DATABASENAME backup via mysqldump i.e.
  
  
    mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
  
  ------------------------------------------------------------------------
  
  
  Have you backed up your databases ? [y/n] y
  
  
  MariaDB 10.5.x https://mariadb.com/kb/en/library/what-is-mariadb-104/
  
  
  !!  Note  !!
  
  upgrade process can take more >5 minutes.. you may want to shutdown
  
  nginx server to not show mysql errors to visitors on your site or
  
  put site(s) into maintenance mode before proceeding with mysql upgrade
  
  
  Do you want to continue with upgrade to MariaDB 10.5.x ? [y/n] y
  
  
  checking mysql root password works in /root/.my.cnf
  
  mysqladmin ver
  
  mysqladmin  Ver 9.1 Distrib 10.4.32-MariaDB, for Linux on x86_64
  
  Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
  
  
  Server version        10.4.32-MariaDB
  
  Protocol version    10
  
  Connection        Localhost via UNIX socket
  
  UNIX socket        /var/lib/mysql/mysql.sock
  
  Uptime:            106 days 9 hours 34 min 23 sec
  
  
  Threads: 41  Questions: 615991766  Slow queries: 1754  Opens: 18240  Flush tables: 1  Open tables: 1014  Queries per second avg: 67.007
  
              ____                                  _               
  
              |  _ \  _ __  ___  _ __    __ _  _ __ (_) _ __    __ _ 
  
              | |_) || '__|/ _ \| '_ \  / _` || '__|| || '_ \  / _` |
  
              |  __/ | |  |  __/| |_) || (_| || |   | || | | || (_| |
  
              |_|    |_|   \___|| .__/  \__,_||_|   |_||_| |_| \__, |
  
                                |_|                            |___/ 
  
      ____   _             _       _                          _____            
  
     / ___| | |__   _   _ | |_  __| |  ___ __      __ _ __   |  ___|___   _ __ 
  
     \___ \ | '_ \ | | | || __|/ _` | / _ \\ \ /\ / /| '_ \  | |_  / _ \ | '__|
  
      ___) || | | || |_| || |_| (_| || (_) |\ V  V / | | | | |  _|| (_) || |   
  
     |____/ |_| |_| \__,_| \__|\__,_| \___/  \_/\_/  |_| |_| |_|   \___/ |_|   
  
                                                                               
  
                    _   _                                _       
  
                  | | | | _ __    __ _  _ __  __ _   __| |  ___ 
  
                  | | | || '_ \  / _` || '__|/ _` | / _` | / _ \
  
                  | |_| || |_) || (_| || |  | (_| || (_| ||  __/
  
                    \___/ | .__/  \__, ||_|   \__,_| \__,_| \___|
  
                          |_|     |___/                          
  
  
   no MariaDB / Galera yum packages version locked packages detected
  
  
  
  shut down existing MariaDB server for upgrade..
  
  mysql -e "SET GLOBAL innodb_fast_shutdown = 1;"
  
  
  total 1.7G
  
  drwxr-xr-x  11 mysql mysql 4.0K Sep 11 19:33 .
  
  drwxr-xr-x. 41 root  root  4.0K Jan  2  2024 ..
  
  -rw-rw----   1 mysql mysql  80K Sep 11 19:33 aria_log.00000001
  
  -rw-rw----   1 mysql mysql   52 Sep 11 19:33 aria_log_control
  
  drwxr-xr-x   2 root  root    84 Dec 21  2023 cmsetiofiotest
  
  -rw-rw----   1 mysql mysql 1.3M May 28 09:58 ib_buffer_pool
  
  -rw-rw----   1 mysql mysql 138M Sep 11 19:33 ibdata1
  
  -rw-rw----   1 mysql mysql 768M Sep 11 19:33 ib_logfile0
  
  -rw-rw----   1 mysql mysql 768M Sep 10 18:55 ib_logfile1
  
  -rw-rw----   1 mysql mysql    0 Dec 21  2023 multi-master.info
  
  drwx------   2 mysql mysql 4.0K Dec 21  2023 mysql
  
  -rw-r--r--   1 mysql mysql   16 Dec 21  2023 mysql_upgrade_info
  
  drwx------   2 mysql mysql   20 Dec 21  2023 performance_schema
  
  drwx------   2 mysql mysql 4.0K Jan  4  2024 superprime
  
  drwx------   2 mysql mysql 4.0K Sep  5 19:22 superprimevip
  
  drwx------   2 mysql mysql   20 Dec 21  2023 test
  
  drwx------   2 mysql mysql 4.0K Sep 10 18:10 wp99426913db_29837
  
  drwx------   2 mysql mysql  28K Sep 11 19:32 xen
  
  drwx------   2 mysql mysql  20K Dec 21  2023 xen2
  
  
  warning: /etc/logrotate.d/mysql saved as /etc/logrotate.d/mysql.rpmsave
  
  Loaded plugins: fastestmirror, priorities, versionlock
  
  Resolving Dependencies
  
  --> Running transaction check
  
  ---> Package mytop.noarch 0:1.7-10.b737f60.el7 will be erased
  
  --> Finished Dependency Resolution
  
  
  Dependencies Resolved
  
  
  ================================================================================
  
   Package       Arch           Version                       Repository     Size
  
  ================================================================================
  
  Removing:
  
   mytop         noarch         1.7-10.b737f60.el7            @epel          68 k
  
  
  Transaction Summary
  
  ================================================================================
  
  Remove  1 Package
  
  
  Installed size: 68 k
  
  Downloading packages:
  
  Running transaction check
  
  Running transaction test
  
  Transaction test succeeded
  
  Running transaction
  
  Warning: RPMDB altered outside of yum.
  
    Erasing    : mytop-1.7-10.b737f60.el7.noarch                              1/1 
  
    Verifying  : mytop-1.7-10.b737f60.el7.noarch                              1/1 
  
  
  Removed:
  
    mytop.noarch 0:1.7-10.b737f60.el7                                             
  
  
  Complete!
  
      __  __               _         ____   ____    _   ___     ____          
  
     |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   | ___|   __  __
  
     | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |  |___ \   \ \/ /
  
     | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |_  >  < 
  
     |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/(_)/_/\_\
  
                                                                             
  
            ____                       ____         _                 
  
            |  _ \  ___  _ __    ___   / ___|   ___ | |_  _   _  _ __  
  
            | |_) |/ _ \| '_ \  / _ \  \___ \  / _ \| __|| | | || '_ \ 
  
            |  _ <|  __/| |_) || (_) |  ___) ||  __/| |_ | |_| || |_) |
  
            |_| \_\\___|| .__/  \___/  |____/  \___| \__| \__,_|| .__/ 
  
                        |_|                                     |_|    
  
  *************************************************
  
  MariaDB 10.5.x Repo setup...
  
  *************************************************
  
  
  Loaded plugins: fastestmirror, priorities, versionlock
  
  Cleaning repos: base centos-sclo-rh elasticsearch epel extras mariadb
  
                : percona-release-x86_64 prel-release-noarch updates
  
  Cleaning up list of fastest mirrors
  
  Other repos take up 23 M of disk space (use --verbose for details)
  
  rpm --import https://mirror.rackspace.com/mariadb/yum/RPM-GPG-KEY-MariaDB
  
  rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY
  
  
  *************************************************
  
  MariaDB 10.5.x check available packages
  
  yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
  
  *************************************************
  
  
  http://centos.mirrors.ovh.net/ftp.centos.org/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
  
  Trying other mirror.
  
  To address this issue please refer to the below wiki article 
  
  
  https://wiki.centos.org/yum-errors
  
  
  If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
  
  
  
  
   One of the configured repositories failed (CentOS-7 - Base),
  
   and yum doesn't have enough cached data to continue. At this point the only
  
   safe thing yum can do is fail. There are a few ways to work "fix" this:
  
  
      1. Contact the upstream for the repository and get them to fix the problem.
  
  
      2. Reconfigure the baseurl/etc. for the repository, to point to a working
  
          upstream. This is most often useful if you are using a newer
  
          distribution release than is supported by the repository (and the
  
          packages for the previous distribution release still work).
  
  
      3. Run the command with the repository temporarily disabled
  
              yum --disablerepo=base ...
  
  
      4. Disable the repository permanently, so yum won't use it by default. Yum
  
          will then just ignore the repository until you permanently enable it
  
          again or use --enablerepo for temporary usage:
  
  
              yum-config-manager --disable base
  
          or
  
              subscription-manager repos --disable=base
  
  
      5. Configure the failing repository to be skipped, if it is unavailable.
  
          Note that yum will try to contact the repo. when it runs most commands,
  
          so will have to try and fail each time (and thus. yum will be be much
  
          slower). If it is a very temporary problem though, this is often a nice
  
          compromise:
  
  
              yum-config-manager --save --setopt=base.skip_if_unavailable=true
  
  
  failure: repodata/repomd.xml from base: [Errno 256] No more mirrors to try.
  
  http://centos.mirrors.ovh.net/ftp.centos.org/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
  
  
  real    0m0.256s
  
  user    0m0.181s
  
  sys    0m0.067s
  
      __  __               _         ____   ____    _   ___     ____          
  
     |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   | ___|   __  __
  
     | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |  |___ \   \ \/ /
  
     | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |_  >  < 
  
     |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/(_)/_/\_\
  
                                                                             
  
                          ___              _          _  _ 
  
                        |_ _| _ __   ___ | |_  __ _ | || |
  
                          | | | '_ \ / __|| __|/ _` || || |
  
                          | | | | | |\__ \| |_| (_| || || |
  
                        |___||_| |_||___/ \__|\__,_||_||_|
  
                                                           
  
  
  *************************************************
  
  MariaDB 10.5.x YUM install...
  
  yum -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
  
  *************************************************
  
  
  Loaded plugins: fastestmirror, versionlock
  
  Loading mirror speeds from cached hostfile
  
  http://centos.mirrors.ovh.net/ftp.centos.org/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
  
  Trying other mirror.
  
  To address this issue please refer to the below wiki article 
  
  
  https://wiki.centos.org/yum-errors
  
  
  If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
  
  
  
  
   One of the configured repositories failed (CentOS-7 - Base),
  
   and yum doesn't have enough cached data to continue. At this point the only
  
   safe thing yum can do is fail. There are a few ways to work "fix" this:
  
  
      1. Contact the upstream for the repository and get them to fix the problem.
  
  
      2. Reconfigure the baseurl/etc. for the repository, to point to a working
  
          upstream. This is most often useful if you are using a newer
  
          distribution release than is supported by the repository (and the
  
          packages for the previous distribution release still work).
  
  
      3. Run the command with the repository temporarily disabled
  
              yum --disablerepo=base ...
  
  
      4. Disable the repository permanently, so yum won't use it by default. Yum
  
          will then just ignore the repository until you permanently enable it
  
          again or use --enablerepo for temporary usage:
  
  
              yum-config-manager --disable base
  
          or
  
              subscription-manager repos --disable=base
  
  
      5. Configure the failing repository to be skipped, if it is unavailable.
  
          Note that yum will try to contact the repo. when it runs most commands,
  
          so will have to try and fail each time (and thus. yum will be be much
  
          slower). If it is a very temporary problem though, this is often a nice
  
          compromise:
  
  
              yum-config-manager --save --setopt=base.skip_if_unavailable=true
  
  
  failure: repodata/repomd.xml from base: [Errno 256] No more mirrors to try.
  
  http://centos.mirrors.ovh.net/ftp.centos.org/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
  
  
  real    0m0.158s
  
  user    0m0.132s
  
  sys    0m0.017s
  
  
  *************************************************
  
  * Adjust old MariaDB 10.x /etc/my.cnf 
  
    for MariaDB 10.5.x my.cnf compatibility 
  
  *************************************************
  
      __  __               _         ____   ____    _   ___     ____          
  
     |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   | ___|   __  __
  
     | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |  |___ \   \ \/ /
  
     | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |_  >  < 
  
     |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/(_)/_/\_\
  
                                                                             
  
              __     _            __                                  __ 
  
            / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
  
            / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_ 
  
          / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
  
          /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|  
  
                                              |___/                     
  
          _        _   _              _                            _        
  
          / \    __| | (_) _   _  ___ | |_  _ __ ___    ___  _ __  | |_  ___ 
  
        / _ \  / _` | | || | | |/ __|| __|| '_ ` _ \  / _ \| '_ \ | __|/ __|
  
        / ___ \| (_| | | || |_| |\__ \| |_ | | | | | ||  __/| | | || |_ \__ \
  
      /_/   \_\\__,_|_/ | \__,_||___/ \__||_| |_| |_| \___||_| |_| \__||___/
  
                    |__/                                                    
  
  
  systemctl start mariadb.service
  
  Failed to start mariadb.service: Unit not found.
  
  systemctl restart mariadb.service
  
  Failed to restart mariadb.service: Unit not found.
  
  
  ## !! mysql failed to start properly !! ##
  
  journalctl -xn
  
  -- Logs begin at Wed 2023-12-27 10:24:59 UTC, end at Wed 2024-09-11 19:33:59 UTC. --
  
  Sep 11 19:33:38 ns3075059.ip-217-182-174.eu polkitd[798]: Unregistered Authentication Agent for unix-process:41998:2241052197 (system bus name :1.487196, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
  
  Sep 11 19:33:39 ns3075059.ip-217-182-174.eu kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=a4:bf:01:18:2c:ae:a0:e0:af:45:dd:fc:08:00 SRC=185.198.69.183 DST=217.182.174.126 LEN=40 TOS=0x00 PREC=0x00 TTL=240 ID=29694 PROTO=TCP SPT=54352 DPT=3353 WINDOW=1024 RES=0x00 SYN URGP=0 
  
  Sep 11 19:33:40 ns3075059.ip-217-182-174.eu systemd[1]: Reloading.
  
  Sep 11 19:33:40 ns3075059.ip-217-182-174.eu systemd[1]: Reloading.
  
  Sep 11 19:33:42 ns3075059.ip-217-182-174.eu yum[42092]: Erased: mytop-1.7-10.b737f60.el7.noarch
  
  Sep 11 19:33:44 ns3075059.ip-217-182-174.eu polkitd[798]: Registered Authentication Agent for unix-process:42250:2241053008 (system bus name :1.487197 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8)
  
  Sep 11 19:33:44 ns3075059.ip-217-182-174.eu polkitd[798]: Unregistered Authentication Agent for unix-process:42250:2241053008 (system bus name :1.487197, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
  
  Sep 11 19:33:52 ns3075059.ip-217-182-174.eu kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=a4:bf:01:18:2c:ae:a0:e0:af:45:dd:fc:08:00 SRC=35.203.211.30 DST=94.23.152.126 LEN=44 TOS=0x00 PREC=0x60 TTL=245 ID=5565 PROTO=TCP SPT=52401 DPT=26225 WINDOW=1024 RES=0x00 SYN URGP=0 
  
  Sep 11 19:33:59 ns3075059.ip-217-182-174.eu polkitd[798]: Registered Authentication Agent for unix-process:42269:2241054509 (system bus name :1.487198 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8)
  
  Sep 11 19:33:59 ns3075059.ip-217-182-174.eu polkitd[798]: Unregistered Authentication Agent for unix-process:42269:2241054509 (system bus name :1.487198, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
  
  
  tail -50 /var/log/mysqld.log
  
  
  possible errors / warnings
  
  
  possible unknown or incompatible /etc/my.cnf set options below
  
  maybe need to comment out or remove these in /etc/my.cnf
  
  
  attempting auto commenting out of invalid options
  
  systemctl restart mariadb.service
  
  Failed to restart mariadb.service: Unit not found.
  
  
  total 1.7G
  
  drwx------ 2 mysql mysql   20 Dec 21  2023 test
  
  -rw-rw---- 1 mysql mysql    0 Dec 21  2023 multi-master.info
  
  drwx------ 2 mysql mysql 4.0K Dec 21  2023 mysql
  
  drwx------ 2 mysql mysql   20 Dec 21  2023 performance_schema
  
  -rw-r--r-- 1 mysql mysql   16 Dec 21  2023 mysql_upgrade_info
  
  drwxr-xr-x 2 root  root    84 Dec 21  2023 cmsetiofiotest
  
  drwx------ 2 mysql mysql  20K Dec 21  2023 xen2
  
  drwx------ 2 mysql mysql 4.0K Jan  4  2024 superprime
  
  -rw-rw---- 1 mysql mysql 1.3M May 28 09:58 ib_buffer_pool
  
  drwx------ 2 mysql mysql 4.0K Sep  5 19:22 superprimevip
  
  drwx------ 2 mysql mysql 4.0K Sep 10 18:10 wp99426913db_29837
  
  -rw-rw---- 1 mysql mysql 768M Sep 10 18:55 ib_logfile1.bak
  
  drwx------ 2 mysql mysql  28K Sep 11 19:32 xen
  
  -rw-rw---- 1 mysql mysql 768M Sep 11 19:33 ib_logfile0.bak
  
  -rw-rw---- 1 mysql mysql 138M Sep 11 19:33 ibdata1
  
  -rw-rw---- 1 mysql mysql   52 Sep 11 19:33 aria_log_control
  
  -rw-rw---- 1 mysql mysql  80K Sep 11 19:33 aria_log.00000001
  
  mysql_upgrade --verbose
  
  /usr/local/src/centminmod/inc/mariadb_upgrade105.inc: line 1341: mysql_upgrade: command not found
  
  ------------------------------------------------
  
  Installing MariaDB 10 plugins
  
  ------------------------------------------------
  
  mysql -e "INSTALL SONAME 'metadata_lock_info';"
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  mysql -e "INSTALL SONAME 'query_cache_info';"
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  mysql -e "INSTALL SONAME 'query_response_time';"
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  mysql -t -e "SELECT * FROM mysql.plugin;"
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  mysql -t -e "SHOW PLUGINS;"
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  mysql -t -e "SHOW ENGINES;"
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  Initial Install: Update MariaDB 10 setting for NotifyAccess=all
  
  systemctl restart mariadb.service
  
  Failed to restart mariadb.service: Unit not found.
  
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  
  
  NotifyAccess=none
  
  LimitNOFILE=1048576
  
  OOMScoreAdjust=0
  
  
  systemctl enable mariadb.service
  
  Failed to execute operation: No such file or directory
  
  
  
  mysqladmin: connect to server at 'localhost' failed
  
  error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
  
  Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
  
  
  ------------------------------------------------
  
  MariaDB 10.5.x Upgrade completed
  
  ------------------------------------------------
  

Thanks for any help you can give me, not sure how to get the site running again. i did back up the database.

---

 

got this error from

Code:

[20:32][root@ns3075059.ip-217-182-174.eu centminlogs]# systemctl status mariadb.service

● mariadb.service - MariaDB 10.5.26 database server

   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

  Drop-In: /etc/systemd/system/mariadb.service.d

          └─mdb101.conf, migrated-from-my.cnf-settings.conf, notifyaccess.conf, oomscoreadjust.conf, openfileslimit.conf, protecthome.conf

   Active: inactive (dead)

    Docs: man:mariadbd(8)

          https://mariadb.com/kb/en/library/systemd/


Sep 11 19:33:36 ns3075.eu systemd[1]: Stopping MariaDB 10.4.32 database server...

Sep 11 19:33:36 ns3075.eu mysqld[10879]: 2024-09-11 19:33:36 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown

Sep 11 19:33:36 ns3075.eu mysqld[10879]: 2024-09-11 19:33:36 0 [Note] Event Scheduler: Purging the queue. 0 events

Sep 11 19:33:36 ns3075.eu mysqld[10879]: 2024-09-11 19:33:36 0 [Note] InnoDB: FTS optimize thread exiting.

Sep 11 19:33:36 ns3075.eu mysqld[10879]: 2024-09-11 19:33:36 0 [Note] InnoDB: Starting shutdown...

Sep 11 19:33:38 ns3075.eu mysqld[10879]: 2024-09-11 19:33:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

Sep 11 19:33:38 ns3075.eu mysqld[10879]: 2024-09-11 19:33:38 0 [Note] InnoDB: Shutdown completed; log sequence number 42503770544; transaction id 26738540

Sep 11 19:33:38 ns3075.eu mysqld[10879]: 2024-09-11 19:33:38 0 [Note] /usr/sbin/mysqld: Shutdown complete

Sep 11 19:33:38 ns3075.eu systemd[1]: Stopped MariaDB 10.4.32 database server.

 

Managed to solve this with ChatGPT

I will paste what it said that worked incase anyone else has this issue

first off all it identified that i never had the VAULT base Centos YUM files, so i found them.

Replaced the centos 7 mirror file locations with

Code:

[base]

name=CentOS-$releasever - Base

baseurl=http://archive.kernel.org/centos-vault/7.9.2009/os/$basearch/

enabled=1

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7



#released updates

[updates]

name=CentOS-$releasever - Updates

baseurl=http://archive.kernel.org/centos-vault/7.9.2009/updates/$basearch/

enabled=1

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7



#additional packages that may be useful

[extras]

name=CentOS-$releasever - Extras

baseurl=http://archive.kernel.org/centos-vault/7.9.2009/extras/$basearch/

enabled=1

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7



#additional packages that extend functionality of existing packages

[centosplus]

name=CentOS-$releasever - Plus

baseurl=http://archive.kernel.org/centos-vault/7.9.2009/centosplus/$basearch/

enabled=0

gpgcheck=1

then it helped me identify things, and this is what solved it.

Code:

The error `Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use` suggests that something is still holding port `3306`, even though `ps aux | grep mysqld` shows no active `mysqld` process. However, `php-fpm` is showing an active connection to `localhost:mysql`, which may still be causing the conflict.

Here’s a more focused approach to resolve this:

### 1. **Identify and Kill the Process Using Port 3306**

First, confirm that `php-fpm` is no longer holding the connection on port `3306`. Use `lsof` to list the processes using port `3306`:
```bash
sudo lsof -i :3306
```

If you still see `php-fpm` or another process holding the connection, you can forcefully kill the process:

- Find the Process ID (PID) from the output of `lsof` (it might be `php-fpm` or something else).
- Kill the process:
  ```bash
  kill -9 <PID>
  ```

Then verify that port `3306` is free:
```bash
sudo lsof -i :3306
```

If no output is returned, the port is free.

### 2. **Check for Other MySQL/MariaDB Instances**

If another `mysqld` instance is running and holding port `3306`, you can list all running MySQL/MariaDB instances with:
```bash
ps -ef | grep mysqld
```

If there is another `mysqld` process running, kill it using:
```bash
kill -9 <PID>
```


Save and exit the file. Now restart MariaDB:
```bash
systemctl restart mariadb.service
```

 

Hi Eva,

Code:

[07:12][root@ns3075059.ip-217-182-174.eu ]# cminfo versions


1st:

124.00stable.s102 #Thu Dec 21 02:09:30 UTC 2023

..

last 10:
130.00beta01.b692 #Wed Sep 11 19:20:54 UTC 2024
130.00beta01.b692 #Wed Sep 11 19:21:58 UTC 2024
131.00stable.b049 #Wed Sep 11 19:24:19 UTC 2024
131.00stable.b049 #Wed Sep 11 19:29:42 UTC 2024
131.00stable.b049 #Wed Sep 11 19:45:39 UTC 2024
131.00stable.b049 #Wed Sep 11 20:19:45 UTC 2024
131.00stable.b049 #Wed Sep 11 20:21:21 UTC 2024
131.00stable.b049 #Wed Sep 11 20:55:10 UTC 2024
131.00stable.b049 #Wed Sep 11 20:57:51 UTC 2024
131.00stable.b049 #Wed Sep 11 21:21:21 UTC 2024

and i do have a copy of the old mirrors, however i cant remember where it was located.
do you know the folder structure to where the mirror files where stored. i updateddb then tried locate .back but its not showing that file

 

Found it

Code:

# CentOS-Base.repo

#

# The mirror system uses the connecting IP address of the client and the

# update status of each mirror to pick mirrors that are updated to and

# geographically close to the client.  You should use this for CentOS updates

# unless you are manually picking other mirrors.

#

# If the mirrorlist= does not work for you, as a fall back you can try the

# remarked out baseurl= line instead.

#

#


[base]

name=CentOS-$releasever - Base

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra

baseurl=http://centos.mirrors.ovh.net/ftp.centos.org/$releasever/os/$basearch/

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

priority=1


#released updates

[updates]

name=CentOS-$releasever - Updates

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates&infra=$infra

baseurl=http://centos.mirrors.ovh.net/ftp.centos.org/$releasever/updates/$basearch/

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

priority=1

priority=1


#additional packages that may be useful

[extras]

name=CentOS-$releasever - Extras

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras&infra=$infra

baseurl=http://centos.mirrors.ovh.net/ftp.centos.org/$releasever/extras/$basearch/

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

priority=1

 

I also think you are right; I never run CMUPDATE.
I just run the update from the last stable to this one.

Mick

 

I have the chatgpt app installed and pay for the service.

its very useful, but also can give "lets say" false positives, you need to be mindful of that.

but it did help me find the issue and fix it.