Learn about Centmin Mod LEMP Stack today
Become a Member

MariaDB MariaDB 10.1.18 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Oct 1, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.18. This is a Stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.1.18 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

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

    Continue reading...
     
    Last edited: Oct 1, 2016
    • Like Like x 2
    • Informative Informative x 1
  2. RoldanLT

    RoldanLT Well-Known Member

    3,829
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    8:48 AM
    1.11
    10.2
    Upgraded fine :).
     
    • Like Like x 2
  3. Revenge

    Revenge Active Member

    287
    64
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +227
    Local Time:
    1:48 AM
    1.9.x
    10.1.x
    This is not common but today MariaDB restarted in my server.
    I only noticed because i received an email from Newrelic saying errors increased for a minute.

    In the logs i only have this:
    Code:
    Oct 11 13:11:36 systemd[1]: mariadb.service: main process exited, code=killed, status=9/KILL
    Oct 11 13:11:36 systemd[1]: Unit mariadb.service entered failed state.
    Oct 11 13:11:36 systemd[1]: mariadb.service failed.
    Oct 11 13:11:41 systemd[1]: mariadb.service holdoff time over, scheduling restart.
    Oct 11 13:11:41 systemd[1]: Starting MariaDB database server...
    Is there any place where we can check a more detailed reason of why MariaDB process failed?
     
  4. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5
    maybe
    Code (Text):
    journalctl -u mariadb --no-pager
    journalctl -xn --no-pager
    systemctl -l status maridb.service
    

    also ensure mysql socket path set in my.cnf and check error log for invalid my.cnf options OR memory buffer allocation too high OR server crash as systemd file for mariadb has restart setting i.e. /usr/lib/systemd/system/mariadb.service holdoff time = 5s wait
    Code (Text):
    # Restart crashed server only, on-failure would also restart, for example, when
    # my.cnf contains unknown option
    Restart=on-abort
    RestartSec=5s


    check usual stuff like disk free space etc
     
    • Like Like x 1
  5. Xon

    Xon Active Member

    123
    55
    28
    Nov 16, 2015
    Ratings:
    +159
    Local Time:
    8:48 AM
    1.11.x
    MariaDB 10.1.x
    • Like Like x 1
  6. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5
    sweet good to know :D
     
  7. Xon

    Xon Active Member

    123
    55
    28
    Nov 16, 2015
    Ratings:
    +159
    Local Time:
    8:48 AM
    1.11.x
    MariaDB 10.1.x
    When I turned MariaDB's deadlock logging on, this caused a 700mb log file to be generated in a week :p
     
  8. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5
    guess that would be relatively small for the size of your forums and mysql activity ? :)
     
  9. Xon

    Xon Active Member

    123
    55
    28
    Nov 16, 2015
    Ratings:
    +159
    Local Time:
    8:48 AM
    1.11.x
    MariaDB 10.1.x
    Oh, relative to the total volume of alerts it was tiny. It was still a lot of deadlocks. Each deadlock description was ~2kb of text (it included both queries plus indexes, and stats for both queries).

    And over two weeks, not 1 week. Miss-remembered.
     
    • Informative Informative x 1
  10. Xon

    Xon Active Member

    123
    55
    28
    Nov 16, 2015
    Ratings:
    +159
    Local Time:
    8:48 AM
    1.11.x
    MariaDB 10.1.x
    I've had a Mariadb 10.1.18 server (in a 3 node galera cluster) just die with no logs, and instantly dies with no error messages when you try to start it. Twice so far.

    Since I was in a rush, I just blew it away and re-seeded.

    Weirdly it is just 1 server out of 3, and the other two where originally cloned of the 1 server which is having issues. :confused: But the HA worked!
     
    • Informative Informative x 1
  11. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5
    you mean linode clone server feature cloned ?
     
  12. Xon

    Xon Active Member

    123
    55
    28
    Nov 16, 2015
    Ratings:
    +159
    Local Time:
    8:48 AM
    1.11.x
    MariaDB 10.1.x
    I used the snapshot feature on the source server, and then used the option to deploy a snapshot to a new linode VM.

    Since I bootstrapped the cluster from the first node it didn't matter if the db was inconsistent on the cloned servers.
     
  13. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5
    interesting then that it's only the 2 copies that have issues.
     
    Last edited: Oct 21, 2016
  14. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    8:48 AM
    latest
    latest
    • Informative Informative x 2
    • Like Like x 1
  15. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    10:48 AM
    Nginx 1.13.x
    MariaDB 5.5