/ Register

Join the community today
Register Now

Install New CMM Stable install failed MariaDB

Discussion in 'Install & Upgrades or Pre-Install Questions' started by rdan, May 23, 2022.

Previous Thread Next Thread
Loading...
  1. May 23, 2022 #1
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    12:24 PM
    Mainline
    10.2
    Code:
            __  __               _         ____   ____    _   ___     _____
       |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ /
       | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    |_ \
       | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |
       |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/
                                                                        
          __   __                   ___              _          _  _
          \ \ / /_   _  _ __ ___   |_ _| _ __   ___ | |_  __ _ | || |
           \ V /| | | || '_ ` _ \   | | | '_ \ / __|| __|/ _` || || |
            | | | |_| || | | | | |  | | | | | |\__ \| |_| (_| || || |
            |_|  \__,_||_| |_| |_| |___||_| |_||___/ \__|\__,_||_||_|
                                                                    
MariaDB 10.3 YUM install...
                                ____         _   
                               / ___|   ___ | |_
                               \___ \  / _ \| __|
                                ___) ||  __/| |_
                               |____/  \___| \__|
                                                
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_| 
                                             |___/                     

Copying MariaDB my-mdb10-4gb.cnf file to /etc/my.cnf

time yum -q -y --disableplugin=fastestmirror,downloadonly --disablerepo=epel --disablerepo=rpmforge --disableplugin=priorities install perl-DBI
http://yum.mariadb.org/10.3/centos7-amd64/repodata/1e7b8c75ffb66d65b737406e49171f02928529b3f1597a960986d402b69f22e7-primary.sqlite.bz2: [Errno 14] HTTPS Error 302 - Found
Trying other mirror.
Package perl-DBI-1.627-4.el7.x86_64 already installed and latest version

real    0m16.659s
user    0m0.521s
sys    0m0.125s

*************************************************
[1;32;40mMariaDB 10.3.x YUM install...
[m[1;32;40myum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disablerepo=rpmforge --disableplugin=priorities
[m*************************************************

Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
 * base: mirror.grid.uchicago.edu
 * centos-sclo-rh: repos.lax.layerhost.com
 * centos-sclo-sclo: centos-distro.1gservers.com
 * extras: mirror.hostduplex.com
 * updates: repos.lax.layerhost.com
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.3.35-1.el7.centos will be installed
---> Package MariaDB-common.x86_64 0:10.3.35-1.el7.centos will be installed
---> Package MariaDB-compat.x86_64 0:10.3.35-1.el7.centos will be installed
---> Package MariaDB-devel.x86_64 0:10.3.35-1.el7.centos will be installed
---> Package MariaDB-server.x86_64 0:10.3.35-1.el7.centos will be installed
--> Processing Dependency: galera for package: MariaDB-server-10.3.35-1.el7.centos.x86_64
---> Package MariaDB-shared.x86_64 0:10.3.35-1.el7.centos will be installed
--> Running transaction check
---> Package galera.x86_64 0:25.3.35-1.el7.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch        Version                     Repository    Size
================================================================================
Installing:
 MariaDB-client      x86_64      10.3.35-1.el7.centos        mariadb       11 M
 MariaDB-common      x86_64      10.3.35-1.el7.centos        mariadb       81 k
 MariaDB-compat      x86_64      10.3.35-1.el7.centos        mariadb      2.2 M
 MariaDB-devel       x86_64      10.3.35-1.el7.centos        mariadb      7.2 M
 MariaDB-server      x86_64      10.3.35-1.el7.centos        mariadb       24 M
 MariaDB-shared      x86_64      10.3.35-1.el7.centos        mariadb      112 k
Installing for dependencies:
 galera              x86_64      25.3.35-1.el7.centos        mariadb      8.1 M

Transaction Summary
================================================================================
Install  6 Packages (+1 Dependent package)

Total download size: 53 M
Installed size: 245 M
Downloading packages:
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-client-10.3.35-1.el7.centos.x86_64.rpm: [Errno 14] HTTPS Error 302 - Found
Trying other mirror.


Error downloading packages:
  MariaDB-client-10.3.35-1.el7.centos.x86_64: [Errno 256] No more mirrors to try.


real    0m20.558s
user    0m1.939s
sys    0m0.340s
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_| 
                                             |___/                     
                                      _           _                  _         
  ___  ___   _ __ ___   _ __    __ _ | |_    ___ | |__    ___   ___ | | __ ___
 / __|/ _ \ | '_ ` _ \ | '_ \  / _` || __|  / __|| '_ \  / _ \ / __|| |/ // __|
| (__| (_) || | | | | || |_) || (_| || |_  | (__ | | | ||  __/| (__ |   < \__ \
 \___|\___/ |_| |_| |_|| .__/  \__,_| \__|  \___||_| |_| \___| \___||_|\_\|___/
                       |_|                                                     

        __  __               _         ____   ____    _   ___     _____
       |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ /
       | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    |_ \
       | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |
       |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/
                                                                        
                   ____                      _   __  _       
                  / ___|  _ __    ___   ___ (_) / _|(_)  ___
                  \___ \ | '_ \  / _ \ / __|| || |_ | | / __|
                   ___) || |_) ||  __/| (__ | ||  _|| || (__
                  |____/ | .__/  \___| \___||_||_|  |_| \___|
                         |_|                                 
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_| 
                                             |___/                     

                                  _   _                          _  _       
    _ __ ___   _   _  ___   __ _ | | | |_  _ __ ___   _ __    __| |(_) _ __
   | '_ ` _ \ | | | |/ __| / _` || | | __|| '_ ` _ \ | '_ \  / _` || || '__|
   | | | | | || |_| |\__ \| (_| || | | |_ | | | | | || |_) || (_| || || |   
   |_| |_| |_| \__, ||___/ \__, ||_|  \__||_| |_| |_|| .__/  \__,_||_||_|   
               |___/          |_|                    |_|                   
                                     _                 
                          ___   ___ | |_  _   _  _ __ 
                         / __| / _ \| __|| | | || '_ \
                         \__ \|  __/| |_ | |_| || |_) |
                         |___/ \___| \__| \__,_|| .__/
                                                |_|   
setup /var/log/mysqld.log
chown: invalid user: ‘mysql:mysql’
-rw-------. 1 root root 0 May 22 10:23 /var/log/mysqld.log

systemctl restart mariadb.service
Failed to restart mariadb.service: Unit not found.

     
  2. May 23, 2022 #2
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    MariaDB YUM mirror issues probably. Where's your server located? Output for command
    Code (Text):
    curl -s https://ipinfo.io/
     
  3. May 23, 2022 #3
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Just remembered MariaDB 10.3.35 was just released, could also be that not all mirrors have been populated yet for your server's geographic location picked up by their mirror system
     
  4. May 23, 2022 #4
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    12:24 PM
    Mainline
    10.2
    "city": "Los Angeles",
    "region": "California",
    "country": "US",
    "org": "AS23470 ReliableSite.Net LLC",

    Any way we can prevent that issue on future install?
    Maybe Fallback to main domain if no mirrors are working.
     
  5. May 23, 2022 #5
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Fallback is usually done by MariaDB repo itself - it isn't normal not to have any mirrors at all.

    What's output for command
    Code (Text):
    yum list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disablerepo=rpmforge --disableplugin=priorities

    and
    Code (Text):
    yum clean all
yum repolist all
     
  6. May 23, 2022 #6
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    12:24 PM
    Mainline
    10.2
    I reformatted the server already, sorry.
    But Server install was done yesterday.
     
  7. May 23, 2022 #7
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    I see. Probably best as when you have any connectivity issues to YUM repos, it could be the server network connectivity itself so other YUM repos may have failed too so to be 100% sure of working system, do a fresh install where you can. For existing working installs you don't need a fresh install though as usually you're isolated to the YUM repo issues reported and can work to fix them without a reinstall.
     
  8. May 23, 2022 #8
    buik

    buik “The best traveler is one without a camera.”

    1,990
    518
    113
    Apr 29, 2016
    Flanders
    Ratings:
    +1,647
    Local Time:
    6:24 AM
    Got the same weird shit a week ago or so with another error and Mariadb server services who wouldn't start:
    Deleting /var/lib/mysql/ib_logfile0 and /var/lib/mysql/ib_logfile1 did the trick.
     
  9. May 24, 2022 #9
    buik

    buik “The best traveler is one without a camera.”

    1,990
    518
    113
    Apr 29, 2016
    Flanders
    Ratings:
    +1,647
    Local Time:
    6:24 AM
    An impending explanation is necessary.
    I got the above error on a new CMM stable installation.
    Perhaps a different kind of error.

    Same kind of a new installation and also the new version of Mariadb.
     
  10. May 24, 2022 #10
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  11. May 24, 2022 #11
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Not able to reproduce the issue. Did fresh 124.00stable install on Upcloud server

    Code (Text):
    ---------------------------------------------------------------------------
Total Curl Installer YUM or DNF Time: 89.2021 seconds
Total YUM Time: 10.233515073 seconds
Total YUM or DNF + Source Download Time: 30.0842
Total Nginx First Time Install Time: 193.1555
Total PHP First Time Install Time: 242.8028
Download From Github Time: 0.8023
Total Time Other eg. source compiles: 318.6247
Total Centmin Mod Install Time: 784.6673
---------------------------------------------------------------------------
Total Install Time (curl yum + cm install + zip download): 874.6717 seconds
---------------------------------------------------------------------------
4 AMD EPYC 7542 32-Core Processor
4 2894.562
---------------------------------------------------------------------------
Install summary logs: /root/centminlogs/installer_summary_links.log
---------------------------------------------------------------------------


    initial install's reported main software checks in post install check list
    Code (Text):
    *************************************************
* Post-Install Check List....
*************************************************

--------------------------------------------------------
Check ccache Version:
--------------------------------------------------------
ccache version 3.7.12

Copyright (C) 2002-2007 Andrew Tridgell
Copyright (C) 2009-2020 Joel Rosdahl

This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License as published by the Free Software
Foundation; either version 3 of the License, or (at your option) any later
version.

--------------------------------------------------------
Check Nginx Version:
--------------------------------------------------------
nginx version: nginx/1.21.6 (230522-202526-centos7-kvm-3f20304)
built by gcc 10.2.1 20210130 (Red Hat 10.2.1-11) (GCC) 
built with OpenSSL 1.1.1o  3 May 2022
TLS SNI support enabled
configure arguments: --with-ld-opt='-Wl,-E -L/usr/local/zlib-cf/lib -L/usr/local/nginx-dep/lib -ljemalloc -Wl,-z,relro -Wl,-rpath,/usr/local/zlib-cf/lib:/usr/local/nginx-dep/lib -flto=4 -fuse-ld=gold' --with-cc-opt='-I/usr/local/zlib-cf/include -I/usr/local/nginx-dep/include -m64 -march=x86-64 -DTCP_FASTOPEN=23 -g -O3 -fstack-protector-strong -flto=4 -fuse-ld=gold --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wno-pointer-sign -Wimplicit-fallthrough=0 -Wno-missing-profile -Wno-implicit-function-declaration -Wno-int-conversion -Wno-unused-result -Wno-unused-result -fcode-hoisting -Wno-cast-function-type -Wno-format-extra-args -Wno-vla-parameter -Wp,-D_FORTIFY_SOURCE=2' --sbin-path=/usr/local/sbin/nginx --conf-path=/usr/local/nginx/conf/nginx.conf --build=230522-202526-centos7-kvm-3f20304 --with-compat --without-pcre2 --with-http_stub_status_module --with-http_secure_link_module --with-libatomic --with-http_gzip_static_module --with-http_sub_module --with-http_addition_module --with-http_image_filter_module=dynamic --with-http_geoip_module --with-stream_geoip_module --with-stream_realip_module --with-stream_ssl_preread_module --with-threads --with-stream --with-stream_ssl_module --with-http_realip_module --add-dynamic-module=../ngx-fancyindex-0.4.2 --add-module=../ngx_cache_purge-2.5.1 --add-dynamic-module=../ngx_devel_kit-0.3.0 --add-dynamic-module=../set-misc-nginx-module-0.32 --add-dynamic-module=../echo-nginx-module-0.62 --add-module=../redis2-nginx-module-0.15 --add-module=../ngx_http_redis-0.3.7 --add-module=../memc-nginx-module-0.19 --add-module=../srcache-nginx-module-0.32 --add-dynamic-module=../headers-more-nginx-module-0.33 --with-pcre-jit --with-zlib=../zlib-cloudflare-1.3.0 --with-http_ssl_module --with-http_v2_module --with-openssl=../openssl-1.1.1o

--------------------------------------------------------
Check PHP-FPM Version:
--------------------------------------------------------
PHP 7.4.29 (cli) (built: May 23 2022 20:31:09) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.29, Copyright (c), by Zend Technologies

--------------------------------------------------------
Check MariaDB installed RPM Versions:
--------------------------------------------------------
MariaDB-common-10.3.35-1.el7.centos.x86_64
MariaDB-devel-10.3.35-1.el7.centos.x86_64
MariaDB-shared-10.3.35-1.el7.centos.x86_64
MariaDB-compat-10.3.35-1.el7.centos.x86_64
MariaDB-server-10.3.35-1.el7.centos.x86_64
MariaDB-client-10.3.35-1.el7.centos.x86_64

--------------------------------------------------------
Check Memcached Server Version:
--------------------------------------------------------
memcached 1.6.5

--------------------------------------------------------
Check CSF Firewall Version:
--------------------------------------------------------
csf: v14.16 (generic)

--------------------------------------------------------
Check Siege Benchmark Version:
--------------------------------------------------------
SIEGE 4.0.4

Copyright (C) 2017 by Jeffrey Fulmer, et al.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE.


--------------------------------------------------------
Check mysqlreport version:
--------------------------------------------------------
mysqlreport v3.5-maria11 Jul 4 2013

--------------------------------------------------------
Check pure-ftpd Version:
--------------------------------------------------------
pure-ftpd v1.0.47

--------------------------------------------------------
Check YUM Repo List
--------------------------------------------------------
Loaded plugins: fastestmirror, priorities, versionlock
Loading mirror speeds from cached hostfile
 * base: ewr.edge.kernel.org
 * centos-sclo-rh: mirror.centos.iad1.serverforge.org
 * centos-sclo-sclo: nyc.mirrors.clouvider.net
 * epel: epel.mirror.constant.com
 * extras: mirror.centos.iad1.serverforge.org
 * updates: nyc.mirrors.clouvider.net
219 packages excluded due to repository priority protections
repo id                  repo name                                   status
base/7/x86_64            CentOS-7 - Base                             7,774+2,298
centos-sclo-rh/x86_64    CentOS-7 - SCLo rh                             7,840+23
centos-sclo-sclo/x86_64  CentOS-7 - SCLo sclo                                816
epel/x86_64              Extra Packages for Enterprise Linux 7 - x86  12,792+959
extras/7/x86_64          CentOS-7 - Extras                                   513
mariadb                  MariaDB                                            95+6
percona-release-x86_64/7 Percona Original release/x86_64 YUM reposit    2,392+45
prel-release-noarch/7    Percona Release release/noarch YUM reposito           5
updates/7/x86_64         CentOS-7 - Updates                            3,094+766
repolist: 35,321

--------------------------------------------------------
mytimes check:
/usr/bin/mytimes
--------------------------------------------------------
Mon May 23 20:35:28 UTC 2022    [UTC]
Tue May 24 06:35:28 AEST 2022   [Australia/Brisbane]
Mon May 23 13:35:28 PDT 2022    [America/Los_Angeles]
Mon May 23 15:35:28 CDT 2022    [America/Chicago]
Mon May 23 16:35:28 EDT 2022    [America/New_York]
Mon May 23 16:35:28 EDT 2022    [America/Montreal]
Mon May 23 21:35:28 BST 2022    [Europe/London]
Mon May 23 22:35:28 CEST 2022   [Europe/Berlin]
Tue May 24 03:35:28 +07 2022    [Asia/Bangkok]
Tue May 24 03:35:28 +07 2022    [Asia/Ho_Chi_Minh]
Tue May 24 03:35:28 WIB 2022    [Asia/Jakarta]
Tue May 24 04:35:28 +08 2022    [Asia/Kuala_Lumpur]
Tue May 24 04:35:28 +08 2022    [Asia/Singapore]
--------------------------------------------------------

    Code (Text):
    mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.3.35-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.3.35-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 4 min 46 sec

Threads: 4  Questions: 1  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 11  Queries per second avg: 0.003


    would need your initial install logs to troubleshoot :)
     
  12. May 29, 2022 #12
    happyhacking

    happyhacking Member

    111
    18
    18
    Apr 23, 2021
    Ratings:
    +61
    Local Time:
    11:24 PM
    1.22.0
    MariadDB 10.4.25
    this happened some time ago in 2 or 3 vps of 9 that i installed simultaneously with mariadb 10.3, it showed as installed, but refused to run, because of that i reformated and installed mariadb 10.4.x and got no problems at all.
     
  13. May 29, 2022 #13
    eva2000

    eva2000 Administrator Staff Member

    53,211
    12,113
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,650
    Local Time:
    2:24 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
Previous Thread Next Thread
Loading...

.