Results 1 to 5 of 5

Thread: mariadb update failed

  1. #1
    Join Date
    Feb 2015
    Posts
    14

    Angry mariadb update failed

    Hi,
    I just updated from 10.2.15 to 10.2.16 and the sql server is not starting anymore.

    2018-07-04 12:29:07 0 [ERROR] Can't open and lock privilege tables: Table './mysql/servers.MYI' is read only
    2018-07-04 12:29:07 0 [Note] Server socket created on IP: '::'.
    2018-07-04 12:29:07 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user.MYI' is read only

    I tried to update to 10.3.8 too, same result.
    I made a backup for /home/mysql and try to reinstall mariadb (https://help.directadmin.com/item.php?id=563)
    Same results.

    Any ideeas?

  2. #2
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    12,133
    Hello,

    Do you have a separate partition for /var/lib/mysql?

    Try
    Code:
    /usr/local/directadmin/scripts/set_permissions.sh mysql
    and see whether or not it fixes the error with writing, and allows MySQL to start.

  3. #3
    Join Date
    Feb 2015
    Posts
    14
    There is no separate partition for mysql. I tryed even chmod 777 for every **** just to make it start.
    Nothing worked with mariadb.

    I made a backup of mysql data and after replace with mysql 5.7 it's working.
    I got some performance_schema errors but it't working.

    I will reinstall that VPS, but directadmin got a "-1" from me with this update that broke sql with no warning.


    Thank for your response, Alex.

  4. #4
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    12,133
    An upgrade process might have failed and/or you had another copy of MariaDB running... Directadmin uses rpm packages on CentOS (if you run it of course).

    The MySQL/MariaDB update is the one that produces the most issues at least in my practice and I don't think Directadmin is one that should be blamed.

    It does not help anybody if you simply "unlike it"... if there is bug it should be reported either to Directadmin or to MariaDB developers.

  5. #5
    Join Date
    Feb 2015
    Posts
    14
    I agree with you.
    But i used directadmin tool for update, and i got errors. Nothing new, dealing with servers you got errors and situations all the time. But my server was down for about 3 hours because of me thinking that using that tool it's safe.

    I have 4 directadmin servers and 2 updates where ok, 1 crashed, and.... i am not that brave to update the last one.

    I have no ideea what hapents, so am not able to report a bug anywere.

    After all, directadmin is a great tool if you know how to use/tune it.
    I miss a responsive theme/ios app for it and a responsive theme for roundcube also.

    Alex i am sure you know, but for everybody reading this: backup is the key!

    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •