Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.1.25 is out

Discussion in 'MariaDB & General MySQL news & discussions' started by pamamolf, Jul 5, 2017.

  1. pamamolf

    pamamolf Well-Known Member

    2,721
    242
    63
    May 31, 2014
    Ratings:
    +433
    Local Time:
    10:26 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    MariaDB 10.1.25 Changelog

    Notable Changes
    • MariaDB can no longer be compiled with the OpenSSL version 0.9.8 and below. Last 0.9.8 release was in December 2015, it is out of support and is no longer getting security fixes.
    • MariaDB Backup is now beta
    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for Ubuntu 16.10 "Yakkety"

    Code:
        Revision #f8dadbdf24 2017-06-04 11:47:30 +0300
            Ensure that we have LOG_log locked when relay_log.close is called
        Revision #228479a28c 2017-05-29 11:35:36 +0300
            MDEV-8075: DROP TEMPORARY TABLE not marked as ddl, causing optimistic parallel replication to fail
        Revision #da7604a294 2017-07-01 21:12:26 +0300
            Latest additions to the list of unstable tests in 10.1.25
        Revision #806d4e3127 2017-06-30 16:17:29 -0700
            Run spider mtr suites in 10.1 only on demand.
        Merge Revision #d38b15de65 2017-06-30 16:33:13 +0200 - Merge branch '10.0-galera' into 10.1
        Revision #4f40f87c48 2017-06-02 11:33:35 -0400
            bump the VERSION
        Revision #3806a323ce 2017-06-01 16:40:57 +0530
            Fix galera_var_node_address.test
        Revision #aa0f7e9bd7 2017-05-31 17:53:32 +0530
            Fix galera_defaults test and check_galera_version.inc script
        Merge Revision #92209ac6f6 2017-05-30 15:28:52 +0530 - Merge tag 'mariadb-10.0.31' into 10.0-galera
        Merge Revision #d3cc15eb82 2017-06-30 13:28:39 +0200 - Merge branch '10.0' into 10.1
        Merge Revision #92928bcdd9 2017-06-29 23:32:18 +0200 - Merge branch '5.5' into 10.0
        Revision #4db6e1e4a5 2017-06-29 20:47:08 +0200
            uninitialized variable
        Revision #5c89f23b45 2017-06-29 21:27:05 +0300
            Fix debug assert post MDEV-10306
        Merge Revision #a02ba9c1c9 2017-06-28 10:10:31 +0200 - Merge branch '5.5' into 10.0
        Revision #d5cd334504 2017-06-27 14:00:10 +0200
            MDEV-13187 incorrect backslash parsing in clients
        Revision #39385ff7b2 2017-06-27 13:25:50 +0200
            MDEV-13187 incorrect backslash parsing in clients
        Revision #b503b1c0ed 2017-06-23 15:14:22 +0200
            MDEV-11646 main.myisam, maria.maria, main.mix2_myisam, main.myisampack, main.mrr_icp_extra fail in buildbot with valgrind (Syscall param pwrite64(buf) points to uninitialised byte(s))
        Revision #a1e51e7f47 2017-06-30 11:28:52 +0300
            Mariabackup: Test file cleanup
        Revision #4fe89773d8 2017-06-22 12:21:54 +0300
            Mariabackup: Clean up xtrabackup options
        Revision #273e0f663e 2017-06-30 10:28:01 +0200
            MDEV-13179 main.errors fails in buildbot and outside with wrong errno 1290
        Merge Revision #330792f3c3 2017-06-27 16:34:36 +0300 - Merge branch 'bb-10.1-vicentiu' into 10.1
        Revision #32659db864 2017-06-26 12:22:27 +0300
            Fix merge error from 10.0
        Merge Revision #2e335a471c 2017-06-21 16:19:43 +0300 - Merge remote-tracking branch '10.0' into 10.1
        Merge Revision #8baf9b0c46 2017-06-20 12:31:17 +0300 - Merge remote-tracking branch '5.5' into 10.0
        Revision #ded614d7db 2017-06-14 13:44:31 +0200
            MDEV-12778 mariadb-10.1 FTBFS on GNU/Hurd due to use of PATH_MAX
        Revision #48429359d6 2017-06-16 11:34:59 +0200
            MDEV-4646 No mysqld-debug or debuginfo in MariaDB-Server RPM
        Revision #e548e2184b 2017-03-26 16:00:35 +1100
            Use CPACK_RPM_FILE_NAME="RPM-DEFAULT"
        Revision #c7141fa75d 2017-06-15 14:41:59 +0200
            MDEV-13002 mysqltest regex replace results in incorrect result
        Revision #c661b4d0fb 2017-06-14 00:48:34 +0200
            MDEV-13017 LOCK TABLE fails with irrelevant error while working with tables affected by ANSI_QUOTES
        Revision #5cbbfe9f54 2017-06-14 00:33:11 +0200
            cleanup: remove duplicate code
        Revision #918e47030b 2017-06-14 11:30:32 +0200
            MDEV-13063 Server crashes in intern_plugin_lock or assertion `plugin_ptr->ref_count == 1' fails in plugin_init
        Revision #70b94c35d7 2017-06-14 11:27:36 +0200
            cleanup: move common test into a function
        Revision #b850fc66ca 2017-06-07 22:54:57 -0700
            Fixed the bug MDEV-12855
        Revision #151f4e9b4a 2017-06-07 16:29:55 -0700
            Fixed the bug MDEV-12963
        Revision #c258ca2463 2017-06-07 12:45:09 -0700
            Fixed the bug MDEV-12838
        Revision #5e4f4ec821 2017-06-19 15:59:19 +0300
            MDEV-12975 InnoDB redo log minimum size check uses detected file size instead of requested innodb_log_file_size
        Revision #3a37afec29 2017-06-19 12:45:32 +0400
            MDEV-10306 Wrong results with combination of CONCAT, SUBSTR and CONVERT in subquery
        Revision #f0ad93403f 2017-05-22 17:06:01 +0300
            MDEV-12666: CURRENT_ROLE() and DATABASE() does not work in a view
        Revision #34da3be8a8 2017-05-22 13:38:26 +0300
            MDEV-10463: Granted as a whole to roles, databases are not show in SHOW DATABASES
        Revision #2579b252dd 2017-06-15 12:35:53 +0200
            Update MariaDB Foundation sponsors
        Revision #3125ba8912 2017-06-27 03:48:04 +0300
            Updated list of unstable tests for 10.1.25 release
        Revision #b76b69cd5f 2017-06-20 14:55:30 +0200
            MDEV-10880: Assertions `keypart_map' or `prebuilt->search_tuple->n_fields > 0' fail on DISTINCT and GROUP BY constant
        Revision #f65d6a03f0 2017-06-22 19:28:07 +0000
            workaround for a test failure on windows (by serg)
        Revision #9b7afd4188 2017-06-16 16:24:36 +0200
            MDEV-12819 order by ordering expression changed to empty string when creatin view with union
        Revision #ba9daddcd8 2017-06-20 20:02:20 +0000
            Cherrypick Percona's fix for leaking descriptors with new xbstream.
        Revision #f1a6d24af3 2017-06-21 23:29:19 +0200
            MDEV-11003 ndb test suite still exists and does not work
        Revision #3f240bff80 2017-06-16 00:35:57 +0200
            MDEV-13097 Online alter of a partitioned MyISAM table with auto_increment
        Revision #b6ce68f450 2017-06-15 20:16:18 +0200
            MDEV-13012 Assertion `share->error' failed in discover_handlerton upon executing statement with max_session_mem_used = 8192
        Revision #d937916c06 2017-06-14 20:21:24 +0200
            MDEV-12193 Discontinue support of insecure and unsupported OpenSSL versions (< 1.0.1)
        Revision #d4007f2e73 2017-05-04 17:18:45 +0200
            disable getopt prefix matching in mtr bootstrap
        Revision #e333d82964 2017-06-22 11:38:50 +0530
            MDEV-12398 All cluster nodes stop due to a foreign key constraint failure
        Revision #472c2d9b2f 2017-06-19 18:23:55 +0000
            MDEV-13106 : Fix check for empty directory in MSI installer
        Revision #b9a326b6e1 2017-06-19 17:00:09 +0000
            MDEV-12709 : mariabackup - during backup phase read some innodb parameter using "show variables", rather than take the value from my.cnf.
        Revision #d1e182d603 2017-06-19 15:59:19 +0300
            MDEV-12975 InnoDB redo log minimum size check uses detected file size instead of requested innodb_log_file_size
        Revision #9a646c91dd 2017-05-29 14:24:18 +0300
            Mariabackup: Remove the --stats option
        Revision #cede2b6f0f 2017-05-26 12:13:48 +0300
            Mariabackup: Remove support for .xbcrypt files
        Revision #7e22050e66 2017-05-26 12:38:32 +0300
            Mariabackup: Remove the options --compact --rebuild-indexes --rebuild-threads
        Revision #fa70d077f7 2017-05-26 12:51:11 +0300
            Mariabackup: Remove the options --to-archived-lsn --innodb-log-arch-dir
        Revision #056bab0880 2017-06-16 15:47:46 +0400
            MDEV-12620 - set lock_wait_timeout = 1;flush tables with read lock; lock not released after timeout
        Revision #58f87a41bd 2017-06-15 12:41:02 +0300
            Remove some fields from dict_table_t
        Revision #88b961816e 2017-06-15 12:40:24 +0300
            Re-record a failing test, likely related to MDEV-12610
        Merge Revision #9ed325efc1 2017-06-13 18:29:40 +0300 - Merge 10.0 into 10.1, plus fixup for MDEV-12873
        Revision #1d5a306e38 2017-06-13 16:20:21 +0300
            MDEV-12873 InnoDB SYS_TABLES.TYPE incompatibility for PAGE_COMPRESSION in MariaDB 10.2.2 to 10.2.6
        Revision #74e4cf70d0 2017-06-12 18:43:23 +0000
            MDEV-13059 XtraDB hangs on Windows due to failing to release block->lock X-latch in innodb_read_only mode.
        Revision #9f0ed6c67e 2017-06-13 17:21:15 +0300
            MDEV-13009 10.1.24 does not compile on architectures without 64-bit atomics
        Revision #3976ec1e83 2017-06-09 17:22:59 +0300
            MDEV-13043 Skipped tests ignore warning suppressions
        Revision #3005cebc96 2017-06-12 17:10:56 +0300
            Post-push fix for MDEV-12610 MariaDB start is slow
        Revision #757339efd0 2017-06-12 17:09:44 +0300
            Adjust a test result after merge
        Merge Revision #fa57479fcd 2017-06-12 14:26:32 +0300 - Merge 10.0 into 10.1
        Revision #75b35a3b68 2017-06-12 14:10:39 +0300
            Partially disable a test affected by MDEV-13059
        Revision #4325041df6 2017-06-12 11:08:06 +0300
            MDEV-13057 innodb_read_only=1 should avoid creating buf_flush_page_cleaner_thread
        Revision #417434f12d 2017-06-08 15:43:06 +0300
            MDEV-13039 innodb_fast_shutdown=0 may fail to purge all undo log
        Revision #a9117c9008 2017-06-09 13:44:04 +0300
            Correct a merge error of MDEV-11626
        Revision #d03abc71a4 2017-06-08 10:34:10 +0300
            MDEV-12609: Allow suppression of InnoDB log messages about reserving extents
        Revision #58c56dd7f8 2017-06-08 15:40:25 +0300
            MDEV-12610: MariaDB start is slow
        Revision #fbeb9489cd 2017-06-06 14:59:42 +0300
            Cleanup of MDEV-12600: crash during install_db with innodb_page_size=32K and ibdata1=3M
        Revision #68890fe7d4 2017-06-06 15:24:43 +0300
            Revert part of MDEV-12113
        Merge Revision #18f62d94d6 2017-06-08 08:18:38 +0300 - Merge pull request #404 from grooverdan/10.1-MDEV-13032-galera_new_cluster
        Revision #d8515829ec 2017-06-08 12:43:39 +1000
            MDEV-13032: fix galera_new_cluster to be POSIX
        Revision #6439238c53 2017-06-06 14:57:20 +0300
            Correct a merge error
        Merge Revision #30df297c2f 2017-06-06 09:54:57 +0300 - Merge 10.0 into 10.1
        Revision #d8d39721df 2017-06-06 09:34:09 +0300
            Follow-up to MDEV-12042 (test innodb_page_size variants)
        Revision #151daaf480 2017-06-05 15:16:15 +0300
            MDEV-12994 innodb_fast_shutdown=0 skips change buffer merge; fast shutdown does it
        Revision #ab62b7538f 2017-06-02 01:46:25 +0300
            MDEV-12042 Re-bootstrap the server if InnoDB options are incompatible
        Merge Revision #c2ef0bb6ce 2017-05-29 13:15:36 +0300 - Merge 5.5 into 10.0
        Revision #2cb94aa1b7 2017-05-29 13:07:23 +0300
            MDEV-11626 innodb.innodb-change-buffer-recovery fails for xtradb
        Revision #b8405c853f 2017-05-22 07:09:49 +0200
            MDEV-11958: LEFT JOIN with stored routine produces incorrect result
        Revision #da61107fc8 2017-06-05 13:10:24 +0530
            MDEV-9544 FLUSH [RELAY] LOGS does not rotate logs for a named slave
        Revision #112b21da37 2017-05-30 11:55:11 +0300
            MDEV-12600: crash during install_db with innodb_page_size=32K and ibdata1=3M;
        Revision #6b6987154a 2017-05-30 12:02:42 +0300
            MDEV-12114: install_db shows corruption for rest encryption and innodb_checksum_algorithm=strict_none
        Revision #1af8bf39ca 2017-05-30 11:30:43 +0300
            MDEV-12113: install_db shows corruption for rest encryption with innodb_data_file_path=ibdata1:3M;
        Revision #473f4a65e1 2017-05-31 11:39:21 -0400
            bump the VERSION
        Revision #5e0038b376 2017-05-29 20:57:34 +0200
            cleanup: remove Regexp_processor_pcre::m_subpatterns_needed
        Revision #2372bfaa7b 2017-05-29 20:49:36 +0200
            MDEV-12942 REGEXP_INSTR returns 1 when using brackets

     
    • Informative Informative x 1
  2. pamamolf

    pamamolf Well-Known Member

    2,721
    242
    63
    May 31, 2014
    Ratings:
    +433
    Local Time:
    10:26 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Very interesting seems to be:

    MariaDB Backup

    Code:
    yum install MariaDB-backup
    But the provide no documentation with a sample:

     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    5:26 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Informative Informative x 1
  4. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    5:26 PM
    Nginx 1.13.x
    MariaDB 5.5
    updating 123.09beta01 to MariaDB 10.1.25 just requires
    Code (Text):
    yum update
    

    answer yes (y) to update
    Code (Text):
    yum update
    Loaded plugins: fastestmirror, priorities
    Loading mirror speeds from cached hostfile
     * base: mirror.nsw.coloau.com.au
     * epel: mirror.nsw.coloau.com.au
     * extras: mirror.ventraip.net.au
     * rpmforge: mirror.ventraip.net.au
     * updates: mirror.qoxy.com
    371 packages excluded due to repository priority protections
    Resolving Dependencies
    --> Running transaction check
    ---> Package MariaDB-client.x86_64 0:10.1.24-1.el7.centos will be updated
    ---> Package MariaDB-client.x86_64 0:10.1.25-1.el7.centos will be an update
    ---> Package MariaDB-common.x86_64 0:10.1.24-1.el7.centos will be updated
    ---> Package MariaDB-common.x86_64 0:10.1.25-1.el7.centos will be an update
    ---> Package MariaDB-compat.x86_64 0:10.1.24-1.el7.centos will be updated
    ---> Package MariaDB-compat.x86_64 0:10.1.25-1.el7.centos will be an update
    ---> Package MariaDB-devel.x86_64 0:10.1.24-1.el7.centos will be updated
    ---> Package MariaDB-devel.x86_64 0:10.1.25-1.el7.centos will be an update
    ---> Package MariaDB-server.x86_64 0:10.1.24-1.el7.centos will be updated
    ---> Package MariaDB-server.x86_64 0:10.1.25-1.el7.centos will be an update
    ---> Package MariaDB-shared.x86_64 0:10.1.24-1.el7.centos will be updated
    ---> Package MariaDB-shared.x86_64 0:10.1.25-1.el7.centos will be an update
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ==========================================================================================================================================================================================================================================================
     Package                                                        Arch                                                   Version                                                              Repository                                               Size
    ==========================================================================================================================================================================================================================================================
    Updating:
     MariaDB-client                                                 x86_64                                                 10.1.25-1.el7.centos                                                 mariadb                                                  39 M
     MariaDB-common                                                 x86_64                                                 10.1.25-1.el7.centos                                                 mariadb                                                 123 k
     MariaDB-compat                                                 x86_64                                                 10.1.25-1.el7.centos                                                 mariadb                                                 1.4 M
     MariaDB-devel                                                  x86_64                                                 10.1.25-1.el7.centos                                                 mariadb                                                 6.6 M
     MariaDB-server                                                 x86_64                                                 10.1.25-1.el7.centos                                                 mariadb                                                 103 M
     MariaDB-shared                                                 x86_64                                                 10.1.25-1.el7.centos                                                 mariadb                                                 1.3 M
    
    Transaction Summary
    ==========================================================================================================================================================================================================================================================
    Upgrade  6 Packages
    
    Total download size: 152 M
    Is this ok [y/d/N]:
    

    Then need to restart or reloaded MariaDB mysql for version change to be reported with
    Code (Text):
    mysqladmin ver
    

    command
    before restart/reload
    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.1.25-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.24-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 13 days 6 hours 20 min 55 sec
    
    Threads: 1  Questions: 24360  Slow queries: 0  Opens: 28  Flush tables: 1  Open tables: 22  Queries per second avg: 0.021
    

    restart on CentOS 7 wants a systemctl daemon-reload so the update must of altered the systemd service file for MariaDB
    Code (Text):
    service mysql restart
    Restarting mysql (via systemctl):  Warning: mysql.service changed on disk. Run 'systemctl daemon-reload' to reload units.
                                                               [  OK  ]
    

    do systemctl daemon-reload before restart and looks okay
    Code (Text):
    service mysql restart
    Restarting mysql (via systemctl):                          [  OK  ]
    

    or
    Code (Text):
    mysqlrestart
    

    Code (Text):
    mysqladmin ver      
    mysqladmin  Ver 9.1 Distrib 10.1.25-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.25-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 min 45 sec
    
    Threads: 1  Questions: 16  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 12  Queries per second avg: 0.152
    

    If you don't want visitors seeing mysql down errors during restart use command to stop nginx first
    Code (Text):
    ngxstop; mysqlrestart; ngxstart
    

    Code (Text):
    ngxstop; mysqlrestart; ngxstart
    Stopping nginx (via systemctl):                            [  OK  ]
    Restarting mysql (via systemctl):                          [  OK  ]
    Starting nginx (via systemctl):                            [  OK  ]
    
     
    Last edited: Jul 5, 2017
    • Informative Informative x 3
  5. RoldanLT

    RoldanLT Well-Known Member

    3,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    3:26 PM
    1.11
    10.2
    :D
     
    • Like Like x 1
  6. Jon Snow

    Jon Snow Active Member

    155
    25
    28
    Jun 30, 2017
    Ratings:
    +30
    Local Time:
    4:26 AM
    Nginx 1.13.4
    MariaDB 10.1.26
    Is there any possibly risk of upgrading to MariaDB 10.1.25?
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    5:26 PM
    Nginx 1.13.x
    MariaDB 5.5
    There's always a risk in either not upgrading or upgrading as both may have underlying bugs in the version you stay on or upgrade to. To be safe, always backup mysql databases before upgrading :)
     
  8. Jon Snow

    Jon Snow Active Member

    155
    25
    28
    Jun 30, 2017
    Ratings:
    +30
    Local Time:
    4:26 AM
    Nginx 1.13.4
    MariaDB 10.1.26
    I've already upgraded via Centminmod and things are smooth but does restarting mysql only change the version number as seen in the above posts or does it have another effect that warrants me to backup before restarting?
     
  9. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    5:26 PM
    Nginx 1.13.x
    MariaDB 5.5
    restarts are fine.. it's upgrade process that can have potential for issues requiring backing up before upgrading.
     
  10. Jon Snow

    Jon Snow Active Member

    155
    25
    28
    Jun 30, 2017
    Ratings:
    +30
    Local Time:
    4:26 AM
    Nginx 1.13.4
    MariaDB 10.1.26
    Alright because I just upgraded but haven't restarted yet (not sure if that second part was important). I wanted to make a backup of my database but my CPU usage gets to 100% when I use the mysqldump command.

    Reason I asked is because when restarting nginx, it sometimes says "fail" depending on a bad config and everything seems normal until nginx gets restarted.
     
  11. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    5:26 PM
    Nginx 1.13.x
    MariaDB 5.5
    CPU load optimal is 1.0 per cpu thread so 8 cpu thread normal = 8x1 = 8.0. 16 cpu server normal is 16x1 = 16.0

    so cpu load of 8 for
    • 2 cpu server = 8/2 = 4.0 load average
    • 4 cpu server = 8/4 = 2.0 load average
    • 8 cpu server = 8/8 = 1.0 load average
    When you type top command, hit number 1 to break down per cpu stats

    So on a 4 cpu server ideal is 4.0 or 400% and under. So if you have 100% cpu load on 4 cpu server = 100/400 = 0.25 cpu load utilisation = 25% cpu utilisation

    what is exact errors ? post them wrapped in CODE tags
     
  12. Jon Snow

    Jon Snow Active Member

    155
    25
    28
    Jun 30, 2017
    Ratings:
    +30
    Local Time:
    4:26 AM
    Nginx 1.13.4
    MariaDB 10.1.26
    I haven't restarted mysql yet. Just afraid of running into errors like how I did when restarting nginx.
     
  13. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    5:26 PM
    Nginx 1.13.x
    MariaDB 5.5
    Should be fine I've updated around 80+ servers so far without issue
     
  14. Jon Snow

    Jon Snow Active Member

    155
    25
    28
    Jun 30, 2017
    Ratings:
    +30
    Local Time:
    4:26 AM
    Nginx 1.13.4
    MariaDB 10.1.26
    Code (Text):
    ngxstop; mysqlrestart; ngxstart
    Stopping nginx (via systemctl):                            [  OK  ]
    Restarting mysql (via systemctl):                          [  OK  ]
    Starting nginx (via systemctl):                            [  OK  ]

    Yay :D