/ Register

Join the community today
Register Now

MariaDB MariaDB 10.1.20 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Dec 16, 2016.

Previous Thread Next Thread
Loading...
Page 1 of 2
  1. Dec 16, 2016 #1
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.20. This is a Stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.1.20 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

    The post MariaDB 10.1.20 now available appeared first on MariaDB.org.

    Continue reading...
     
    Last edited: Dec 16, 2016
  2. Dec 16, 2016 #2
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    4:38 PM
    Nginx 1.17.9
    MariaDB 10.3.22
    Still nothing on my yum update
     
  3. Dec 16, 2016 #3
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:38 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Nothing for me also :(
     
  4. Dec 17, 2016 #4
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    try running before hand
    Code (Text):
    yum clean all
     
  5. Dec 17, 2016 #5
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:38 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    I was run that before and the update was not there :(

    Now that i re run it it's ok :)
     
  6. Dec 17, 2016 #6
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    4:38 PM
    Nginx 1.17.9
    MariaDB 10.3.22
    I allways run yum clean all before any "big" update.
    Updated 5 minutes ago...
    Code:
    [root@upcloud ~]# yum clean all
Loaded plugins: fastestmirror, priorities
Cleaning repos: base centos-sclo-rh centos-sclo-sclo elasticsearch-5.x epel extras mariadb
              : updates varnish-4.1
Cleaning up everything
Cleaning up list of fastest mirrors
[root@upcloud ~]# yum update
Loaded plugins: fastestmirror, priorities
base                                                                      | 3.6 kB  00:00:00     
centos-sclo-rh                                                            | 2.9 kB  00:00:00     
centos-sclo-sclo                                                          | 2.9 kB  00:00:00     
elasticsearch-5.x                                                         | 1.3 kB  00:00:00     
epel/x86_64/metalink                                                      |  23 kB  00:00:00     
epel                                                                      | 4.3 kB  00:00:00     
extras                                                                    | 3.4 kB  00:00:00     
mariadb                                                                   | 2.9 kB  00:00:00     
updates                                                                   | 3.4 kB  00:00:00     
varnish-4.1                                                               |  951 B  00:00:00     
(1/11): base/7/x86_64/group_gz                                            | 155 kB  00:00:00     
(2/11): centos-sclo-sclo/x86_64/primary_db                                | 117 kB  00:00:00     
(3/11): epel/x86_64/group_gz                                              | 170 kB  00:00:00     
(4/11): epel/x86_64/updateinfo                                            | 691 kB  00:00:00     
(5/11): epel/x86_64/primary_db                                            | 4.4 MB  00:00:00     
(6/11): extras/7/x86_64/primary_db                                        | 183 kB  00:00:00     
(7/11): centos-sclo-rh/x86_64/primary_db                                  | 2.1 MB  00:00:00     
(8/11): elasticsearch-5.x/primary                                         |  18 kB  00:00:00     
(9/11): mariadb/primary_db                                                |  18 kB  00:00:00     
(10/11): base/7/x86_64/primary_db                                         | 5.6 MB  00:00:00     
(11/11): updates/7/x86_64/primary_db                                      | 1.2 MB  00:00:00     
varnish-4.1/x86_64/primary                                                | 9.5 kB  00:00:00     
Determining fastest mirrors
 * base: mirror.centos.org
 * epel: mirror.de.leaseweb.net
 * extras: mirror.centos.org
 * updates: mirror.centos.org
elasticsearch-5.x                                                                          40/40
varnish-4.1                                                                                31/31
271 packages excluded due to repository priority protections
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.1.19-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.1.19-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.1.19-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.1.19-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.1.19-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package MariaDB-shared.x86_64 0:10.1.19-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.1.20-1.el7.centos will be an update
---> Package galera.x86_64 0:25.3.18-1.rhel7.el7.centos will be updated
---> Package galera.x86_64 0:25.3.19-1.rhel7.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================
 Package                Arch           Version                             Repository       Size
=================================================================================================
Updating:
 MariaDB-client         x86_64         10.1.20-1.el7.centos                mariadb          39 M
 MariaDB-common         x86_64         10.1.20-1.el7.centos                mariadb          43 k
 MariaDB-compat         x86_64         10.1.20-1.el7.centos                mariadb         1.4 M
 MariaDB-devel          x86_64         10.1.20-1.el7.centos                mariadb         6.6 M
 MariaDB-server         x86_64         10.1.20-1.el7.centos                mariadb         100 M
 MariaDB-shared         x86_64         10.1.20-1.el7.centos                mariadb         1.3 M
 galera                 x86_64         25.3.19-1.rhel7.el7.centos          mariadb         8.0 M

Transaction Summary
=================================================================================================
Upgrade  7 Packages

Total download size: 157 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for mariadb
(1/7): MariaDB-10.1.20-centos7-x86_64-common.rpm                          |  43 kB  00:00:00     
(2/7): MariaDB-10.1.20-centos7-x86_64-compat.rpm                          | 1.4 MB  00:00:00     
(3/7): MariaDB-10.1.20-centos7-x86_64-client.rpm                          |  39 MB  00:00:03     
(4/7): MariaDB-10.1.20-centos7-x86_64-devel.rpm                           | 6.6 MB  00:00:02     
(5/7): MariaDB-10.1.20-centos7-x86_64-shared.rpm                          | 1.3 MB  00:00:01     
(6/7): galera-25.3.19-1.rhel7.el7.centos.x86_64.rpm                       | 8.0 MB  00:00:02     
(7/7): MariaDB-10.1.20-centos7-x86_64-server.rpm                          | 100 MB  00:00:06     
-------------------------------------------------------------------------------------------------
Total                                                             16 MB/s | 157 MB  00:00:09     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : MariaDB-common-10.1.20-1.el7.centos.x86_64                                   1/14
  Updating   : MariaDB-client-10.1.20-1.el7.centos.x86_64                                   2/14
  Updating   : galera-25.3.19-1.rhel7.el7.centos.x86_64                                     3/14
  Updating   : MariaDB-server-10.1.20-1.el7.centos.x86_64                                   4/14
  Updating   : MariaDB-shared-10.1.20-1.el7.centos.x86_64                                   5/14
  Updating   : MariaDB-devel-10.1.20-1.el7.centos.x86_64                                    6/14
  Updating   : MariaDB-compat-10.1.20-1.el7.centos.x86_64                                   7/14
  Cleanup    : MariaDB-server-10.1.19-1.el7.centos.x86_64                                   8/14
  Cleanup    : MariaDB-devel-10.1.19-1.el7.centos.x86_64                                    9/14
  Cleanup    : MariaDB-client-10.1.19-1.el7.centos.x86_64                                  10/14
  Cleanup    : MariaDB-compat-10.1.19-1.el7.centos.x86_64                                  11/14
  Cleanup    : MariaDB-shared-10.1.19-1.el7.centos.x86_64                                  12/14
  Cleanup    : MariaDB-common-10.1.19-1.el7.centos.x86_64                                  13/14
  Cleanup    : galera-25.3.18-1.rhel7.el7.centos.x86_64                                    14/14
  Verifying  : MariaDB-shared-10.1.20-1.el7.centos.x86_64                                   1/14
  Verifying  : MariaDB-server-10.1.20-1.el7.centos.x86_64                                   2/14
  Verifying  : MariaDB-common-10.1.20-1.el7.centos.x86_64                                   3/14
  Verifying  : galera-25.3.19-1.rhel7.el7.centos.x86_64                                     4/14
  Verifying  : MariaDB-devel-10.1.20-1.el7.centos.x86_64                                    5/14
  Verifying  : MariaDB-compat-10.1.20-1.el7.centos.x86_64                                   6/14
  Verifying  : MariaDB-client-10.1.20-1.el7.centos.x86_64                                   7/14
  Verifying  : MariaDB-devel-10.1.19-1.el7.centos.x86_64                                    8/14
  Verifying  : MariaDB-compat-10.1.19-1.el7.centos.x86_64                                   9/14
  Verifying  : MariaDB-client-10.1.19-1.el7.centos.x86_64                                  10/14
  Verifying  : galera-25.3.18-1.rhel7.el7.centos.x86_64                                    11/14
  Verifying  : MariaDB-shared-10.1.19-1.el7.centos.x86_64                                  12/14
  Verifying  : MariaDB-server-10.1.19-1.el7.centos.x86_64                                  13/14
  Verifying  : MariaDB-common-10.1.19-1.el7.centos.x86_64                                  14/14

Updated:
  MariaDB-client.x86_64 0:10.1.20-1.el7.centos    MariaDB-common.x86_64 0:10.1.20-1.el7.centos   
  MariaDB-compat.x86_64 0:10.1.20-1.el7.centos    MariaDB-devel.x86_64 0:10.1.20-1.el7.centos   
  MariaDB-server.x86_64 0:10.1.20-1.el7.centos    MariaDB-shared.x86_64 0:10.1.20-1.el7.centos   
  galera.x86_64 0:25.3.19-1.rhel7.el7.centos     

Complete!
You have new mail in /var/spool/mail/root
[root@upcloud ~]# systemctl daemon-reload
[root@upcloud ~]# mysqlrestart
Restarting mysql (via systemctl):                          [  OK  ]
[root@upcloud ~]# mysql -v
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 10.1.20-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> \q
Writing history-file /root/.mysql_history
Bye
     
  7. Dec 17, 2016 #7
    RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    7:38 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    Hmm I've never updated MariaDB on CMM...

    I ran:
    # yum clean all
    then
    # yum update
    but I get: "No packages marked for update"

    mysql -v returns "10.0.28-MariaDB MariaDB Server"

    Should I just use centmin.sh menu option 11 sub-menu 5 after backing up databases?
     
  8. Dec 17, 2016 #8
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    You seem to be on Centmin Mod 123.08stable which has MariaDB 10.0.x branch. So this version doesn't apply to you as only Centmin Mod 123.09beta01 defaults to MariaDB 10.1.x branch. You're next version is MariaDB 10.0.29 not 10.1.20.
     
  9. Dec 17, 2016 #9
    RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    7:38 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    I'm on 123.09beta01
     
  10. Dec 17, 2016 #10
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    did you upgrade from 123.08stable ?

    If you did then you would still be on 123.08stable's MariaDB 10.0 branch unless you manually backup all mysql databases on server and then upgrade major branch to MariaDB 10.1 via centmin.sh menu option 11 submenu option 5

    centmin.sh menu option 11 is for major branch updates only i.e. MariaDB 5.5 to 10.0 or 10.0 to 10.1 or 10.1 to 10.2. For minor version updates YUM package manager is used.

    Code (Text):
    --------------------------------------------------------
     Centmin Mod Menu 123.09beta01 centminmod.com    
--------------------------------------------------------
1).  Centmin Install
2).  Add Nginx vhost domain
3).  NSD setup domain name DNS
4).  Nginx Upgrade / Downgrade
5).  PHP Upgrade / Downgrade
6).  XCache Re-install
7).  APC Cache Re-install
8).  XCache Install
9).  APC Cache Install
10). Memcached Server Re-install
11). MariaDB MySQL Upgrade & Management
12). Zend OpCache Install/Re-install
13). Install/Reinstall Redis PHP Extension
14). SELinux disable
15). Install/Reinstall ImagicK PHP Extension
16). Change SSHD Port Number
17). Multi-thread compression: pigz,pbzip2,lbzip2...
18). Suhosin PHP Extension install
19). Install FFMPEG and FFMPEG PHP Extension
20). NSD Install/Re-Install
21). Update - Nginx + PHP-FPM + Siege
22). Add Wordpress Nginx vhost + Cache Plugin
23). Update Centmin Mod Code Base
24). Exit
--------------------------------------------------------
Enter option [ 1 - 24 ] 11
--------------------------------------------------------

    Code (Text):
    --------------------------------------------------------
     MariaDB MySQL Upgrade & Management Sub-Menu      
--------------------------------------------------------
0). Regenerate New MySQL Root User Password (local server)
1). MariaDB 5.2.x Branch Upgrade Only
2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
7). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 7 ]
     
  11. Dec 17, 2016 #11
    narji

    narji Member

    69
    6
    8
    Feb 4, 2016
    Ratings:
    +12
    Local Time:
    9:38 PM
    yum already update mariadb
    Code:
    yum history info
Loaded plugins: fastestmirror, priorities
Transaction ID : 75
Begin time     : Sat Dec 17 08:43:35 2016
Begin rpmdb    : 756:e6601c1c798bc2e2c3e8f3648ac21fc42dcb83ec
End time       :            08:44:11 2016 (36 seconds)
End rpmdb      : 756:9586f69cce2cf39d2f2716fd9ae082b1205cd9ab
User           : root <root>
Return-Code    : Success
Transaction performed with:
    Installed     rpm-4.11.3-21.el7.x86_64                      @cr
    Installed     yum-3.4.3-150.el7.centos.noarch               @cr
    Installed     yum-metadata-parser-1.1.4-10.el7.x86_64       @anaconda
    Installed     yum-plugin-fastestmirror-1.1.31-40.el7.noarch @cr
Packages Altered:
    Updated MariaDB-client-10.1.19-1.el7.centos.x86_64 @mariadb
    Update                 10.1.20-1.el7.centos.x86_64 @mariadb
    Updated MariaDB-common-10.1.19-1.el7.centos.x86_64 @mariadb
    Update                 10.1.20-1.el7.centos.x86_64 @mariadb
    Updated MariaDB-compat-10.1.19-1.el7.centos.x86_64 @mariadb
    Update                 10.1.20-1.el7.centos.x86_64 @mariadb
    Updated MariaDB-devel-10.1.19-1.el7.centos.x86_64  @mariadb
    Update                10.1.20-1.el7.centos.x86_64  @mariadb
    Updated MariaDB-server-10.1.19-1.el7.centos.x86_64 @mariadb
    Update                 10.1.20-1.el7.centos.x86_64 @mariadb
    Updated MariaDB-shared-10.1.19-1.el7.centos.x86_64 @mariadb
    Update                 10.1.20-1.el7.centos.x86_64 @mariadb
    Updated galera-25.3.18-1.rhel7.el7.centos.x86_64   @mariadb
    Update         25.3.19-1.rhel7.el7.centos.x86_64   @mariadb
history info
    but mysql version not change to 10.1.20-1
    Code:
    service mariadb status
Redirecting to /bin/systemctl status  mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf, protecthome.conf
   Active: active (running) since Fri 2016-12-16 23:14:17 WIB; 11h ago
 Main PID: 1341 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           └─1341 /usr/sbin/mysqld

Dec 16 23:14:17 mydomain.com mysqld[1341]: 2016-12-16 23:14:17 139730090744064 [Note] InnoDB: Waiting for purge to start
Dec 16 23:14:17 mydomain.com mysqld[1341]: 2016-12-16 23:14:17 139730090744064 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.32-79.0 ...896812115
Dec 16 23:14:17 mydomain.com mysqld[1341]: 2016-12-16 23:14:17 139730090744064 [Note] Plugin 'FEEDBACK' is disabled.
Dec 16 23:14:17 mydomain.com mysqld[1341]: 161216 23:14:17 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED.
Dec 16 23:14:17 mydomain.com mysqld[1341]: 161216 23:14:17 server_audit: logging started to the file server_audit.log.
Dec 16 23:14:17 mydomain.com mysqld[1341]: 2016-12-16 23:14:17 139729622267648 [Note] InnoDB: Dumping buffer pool(s) not yet started
Dec 16 23:14:17 mydomain.com mysqld[1341]: 2016-12-16 23:14:17 139730090744064 [Note] Server socket created on IP: '::'.
Dec 16 23:14:17 mydomain.com mysqld[1341]: 2016-12-16 23:14:17 139730090744064 [Note] /usr/sbin/mysqld: ready for connections.
Dec 16 23:14:17 mydomain.com mysqld[1341]: Version: '10.1.19-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
Dec 16 23:14:17 mydomain.com systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@keep ~]# mysql -v
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 20
Server version: 10.1.19-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> exit
Writing history-file /root/.mysql_history
Bye
    centos 7 123.09beta01
     
  12. Dec 17, 2016 #12
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    restart mysql server
     
  13. Dec 17, 2016 #13
    RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    7:38 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    Was getting all kinds of database errors after updating but I guess all I needed to to was manually start mysql and it seems to be working now...

    service mysql start

    MariaDB 10.1.20 now :)
     
  14. Dec 17, 2016 #14
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    should have a upgrade log from output of command
    Code (Text):
    ls -lahrt /root/centminlogs | grep 'mariadb_10'

    post contents of the log to pastebin.com or gist.github.com
     
  15. Dec 17, 2016 #15
    Xon

    Xon Active Member

    173
    61
    28
    Nov 16, 2015
    Ratings:
    +229
    Local Time:
    10:38 PM
    1.15.x
    MariaDB 10.3.x
    Working fine for me so far in a 3 node Mariadb galera cluster, hopeful it'll fix some sporadic crash issues we've been having since upgrading from 10.1.14
     
  16. Dec 17, 2016 #16
    RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    7:38 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    MariaDB 10.1.x Upgrade Log · GitHub
     
  17. Dec 17, 2016 #17
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Good to know :)

    @RB1 you ran into mariadb 10.1 bug fixed in 123.09beta01 specifically for 10.1.x branch Beta Branch - set MariaDB 10.1 ProtectHome=false for CentOS 7 systemd in 123.09beta01 | Centmin Mod Community

    it's only fixed when mariadb 10.1 detected and a fresh centmin.sh run and exit is made

    Code (Text):
    2016-12-17  4:06:40 139653703325952 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ibfvVPMG' (Errcode: 13 "Permission denied")
2016-12-17  4:06:40 139653703325952 [ERROR] Plugin 'InnoDB' init function returned error.
2016-12-17  4:06:40 139653703325952 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-12-17  4:06:40 139653703325952 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-12-17  4:06:40 139653703325952 [ERROR] Aborting


    try running centmin.sh and exiting and then restart mysql server
    Code (Text):
    mysqlrestart

    Then as per faq item 19 for centos 7 mariadb mysql server check error log via command below to see - might need to post to pastebin or gist and mask any server hostnames if needed
    Code (Text):
    journalctl -u mariadb --no-pager
     
  18. Dec 17, 2016 #18
    RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    7:38 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    OK, after running invoking centmin.sh again and restarting mysql do I manually need to change ProtectHome or is it automatically fixed?

    Code (Text):
    Dec 17 08:32:37 atlas systemd[1]: Stopping MariaDB database server...
Dec 17 08:32:39 atlas systemd[1]: Starting MariaDB database server...
Dec 17 08:32:39 atlas mysqld[9638]: 2016-12-17  8:32:39 139928991611136 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 9638 ...
Dec 17 08:32:43 atlas systemd[1]: Started MariaDB database server.
     
  19. Dec 17, 2016 #19
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:38 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    it will be auto fixed on next centmin.sh run after update but I just updated 123.09beta01 to add the fix during (not after) mariadb 10.0 to 10.1 upgrades via centmin.sh menu option 11 submenu option 5.
    If you can restart mysql server it usually means it's fixed and can confirm by checking /etc/systemd/system/mariadb.service.d/protecthome.conf file exists and it has the following contents
    Code (Text):
    [Service]
ProtectHome=false
     
  20. Dec 17, 2016 #20
    RB1

    RB1 Active Member

    292
    75
    28
    Nov 11, 2016
    California
    Ratings:
    +122
    Local Time:
    7:38 AM
    Nginx 1.21.x
    MariaDB 10.1.x
    Fast reply, thanks!
    Yes it's fixed. :)
     
Previous Thread Next Thread
Loading...
Page 1 of 2

.