Results 1 to 6 of 6

Thread: CustomB 2.0 MariaDB 10.3.13 update to 10.3.14 is available - fails

  1. #1
    Join Date
    Apr 2013
    Location
    London
    Posts
    49

    CustomB 2.0 MariaDB 10.3.13 update to 10.3.14 is available - fails

    There is an update available in CustomBuild 2.0:

    MariaDB 10.3.13 update to 10.3.14 is available

    When I execute the update, I get the following error for every database on each DirectAdmin user:

    Dumping database directadminUser_xxxxx
    mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'directadminUser_xxxxx'': Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50541, now running 100313. Please use mysql_upgrade to fix this error (1558)
    The above error seems to be asking me to upgrade all the databases by using mysql_upgrade. Please, kindly let me know the easiest way to achieve this?

    I came across this help page when doing a search, but unsure whether to go ahead and try without advice first, please?

    https://help.directadmin.com/item.php?id=699

    kind regards

  2. #2
    Join Date
    Aug 2006
    Location
    LT, EU
    Posts
    7,795
    Please try:
    Code:
    mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf
    Martynas Bendorius
    MB Martynas IT. Professional server management company. Official DirectAdmin, CloudLinux, LiteSpeed and Comodo partners.

  3. #3
    Join Date
    Apr 2013
    Location
    London
    Posts
    49
    Hi smtalk

    Thanks for the suggestion. I just tried it and got the following error:-

    mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf
    mysql_upgrade: unknown variable 'max_allowed_packet=500M'
    It seems it was a variable that i added to /etc/my./conf a long time ago for whatever reason.

    I will try adding the [mysqld] on the line just above it and see if that helps.
    Last edited by themadguru; 04-05-2019 at 11:09 PM.

  4. #4
    Join Date
    Apr 2013
    Location
    London
    Posts
    49
    Yes, adding [mysqld] on the line above in /etc/my.conf has worked:-

    [mysqld]
    max_allowed_packet=500M
    Thanks for your help!

  5. #5
    Join Date
    Apr 2013
    Location
    London
    Posts
    49
    I spoke too soon. When now trying the update again, I'm getting this line repeated over and over again...

    Warning: fread() expects parameter 1 to be resource, boolean given in /usr/local/directadmin/plugins/custombuild/admin/build_software_command.raw on line 26
    Not sure what that is. it eventually says done, but the update is still there in CustomBuild 2.0.

    Please help?

  6. #6
    Join Date
    Sep 2016
    Posts
    18
    Quote Originally Posted by themadguru View Post
    Not sure what that is. it eventually says done, but the update is still there in CustomBuild 2.0.

    Code:
    Warning: fread() expects parameter 1 to be resource, boolean given in /usr/local/directadmin/plugins/custombuild/admin/build_software_command.raw on line 26
    Please help?
    I posted about this error here for other people that search for this:
    https://forum.directadmin.com/showthread.php?t=57915

    Bottom line is wait because the update eventually completes as you noticed, its just the log output.

Posting Permissions

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