can't update mysql

[mikajaxxx]

Hello
in directadmin/ Custom Build always update message for mysql 5.7.36 to 5.7.37 has been shown, the process starts but after fininshing i get the upgrade message again. i have no idea what is the problem. the following codes extracted from upgrade log. i also tried upgrading by SSH but the same result

 Stopping mysqld ...
Service didn't get stopped, sleeping for 20 secs and re-trying ...
Stopping mysqld ...
Updating MySQL 5.7.36 to 5.7.37
warning: mysql-community-client-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ########################################
Updating / installing...
mysql-community-common-5.7.37-1.el7 ########################################
mysql-community-libs-5.7.37-1.el7 ########################################
mysql-community-client-5.7.37-1.el7 ########################################
error: unpacking of archive failed on file /usr/bin/mysql;627e0702: cpio: read failed - Inappropriate ioctl for device
error: mysql-community-client-5.7.37-1.el7.x86_64: install failed
mysql-community-server-5.7.37-1.el7 ########################################
mysql-community-devel-5.7.37-1.el7 ########################################
mysql-community-libs-compat-5.7.37-1.e########################################
error: mysql-community-client-5.7.36-1.el7.x86_64: erase skipped
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Checking if update is needed.
This installation of MySQL is already upgraded to 5.7.37, use --force if you still need to run mysql_upgrade

 

[Zhenyapan]

check mysql error log, there must be more details, also:
error: unpacking of archive failed on file /usr/bin/mysql;627e0702: cpio: read failed - Inappropriate ioctl for device
error: mysql-community-client-5.7.37-1.el7.x86_64: install failed
---
try remove downloaded archives from /custombuild directory, update fileserver mirror
./build set_fastest
and run update again

 

[mikajaxxx]

Hello,
it didin't work bro still get update message in directaadmin panel

 Found /usr/local/directadmin/custombuild/mysql/mysql-community-client-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-devel-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-server-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-common-5.7.37-1.el7.x86_64.rpm
Stopping mysqld ...
Service didn't get stopped, sleeping for 20 secs and re-trying ...
Stopping mysqld ...
Updating MySQL 5.7.36 to 5.7.37
warning: mysql-community-client-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ########################################
Updating / installing...
mysql-community-common-5.7.37-1.el7 ########################################
mysql-community-libs-5.7.37-1.el7 ########################################
mysql-community-client-5.7.37-1.el7 ########################################
error: unpacking of archive failed on file /usr/bin/mysql;628427b1: cpio: read failed - Inappropriate ioctl for device
error: mysql-community-client-5.7.37-1.el7.x86_64: install failed
mysql-community-server-5.7.37-1.el7 ########################################
mysql-community-devel-5.7.37-1.el7 ########################################
mysql-community-libs-compat-5.7.37-1.e########################################
error: mysql-community-client-5.7.36-1.el7.x86_64: erase skipped
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Checking if update is needed.
This installation of MySQL is already upgraded to 5.7.37, use --force if you still need to run mysql_upgrade

 

[Richard G]

is already upgraded to 5.7.37

What is the output of mysql -V because it seems you can't upgrade something you're already running.

Anyway, check what mirror you are currently using. Then use the set_fastest command again and see if it changed. If not, change the mirror manually restart directadmin and try again.

 

[Zhenyapan]

error: unpacking of archive failed on file /usr/bin/mysql;628427b1: cpio: read failed - Inappropriate ioctl for device
--
strange, all ok with your disk? enough space? no errors in dmesg?

 

[mikajaxxx]

What is the output of mysql -V because it seems you can't upgrade something you're already running.

Anyway, check what mirror you are currently using. Then use the set_fastest command again and see if it changed. If not, change the mirror manually restart directadmin and try again.

 mysql -V
mysql  Ver 14.14 Distrib 5.7.36, for Linux (x86_64) using  EditLine wrapper

Also in directadmin i have update message!

 

[mikajaxxx]

error: unpacking of archive failed on file /usr/bin/mysql;628427b1: cpio: read failed - Inappropriate ioctl for device
--
strange, all ok with your disk? enough space? no errors in dmesg?

I have absolutly no problem on updating other extensions or directadmin the only extension doesn't updated is mysql

 

[Richard G]

Have you tried what I said about changing mirror?
Because:

cpio: read failed - Inappropriate ioctl for device

means packages is corrupt or incomplete.

 

[mikajaxxx]

Have you tried what I said about changing mirror?
Because:

means packages is corrupt or incomplete.

i don't know how to setup mirror manually! could you share codes?

 

[Richard G]

You can just have a look in the /usr/local/directadmin/custombuild/options.conf file for a line like:
downloadserver=
check what it says not, then do:

./build update
./build set_fastest

from the custombuild directory
and see if that line has another server there.

If not, change manually to:
downloadserver=files1.directadmin.com
or
downloadserver=files-fi.directadmin.com
which are 2 working examples.

Then do ./build update
again and then try to update mysql again with ./build update_versions command.

 

[mikajaxxx]

Hello
ok here is the codes before changing mirror

 ./build update

###################################################################################################################################################################################################################################### 100.0%

Extracting custombuild.tar.gz...

Cronjob frequency: daily

Automatic notifications: no

Automatic updates: no

Installing sa-update cronjob...

Downloading             sa-update.sh...

###################################################################################################################################################################################################################################### 100.0%

Automatic SpamAssassin rule updates: daily


 ./build set_fastest

Testing with file 10.kb:

2023 B/s        - files-fi.directadmin.com

8477 B/s        - files-fr.directadmin.com

2010 B/s        - files-lt.directadmin.com

3938 B/s        - files-de.directadmin.com

327 B/s         - files-sg.directadmin.com

1012 B/s        - files-ca.directadmin.com

Total test duration: 1 seconds


Testing with file 100.kb:

2403 B/s        - files-fi.directadmin.com

23485 B/s       - files-fr.directadmin.com

2363 B/s        - files-lt.directadmin.com

5453 B/s        - files-de.directadmin.com

327 B/s         - files-sg.directadmin.com

1154 B/s        - files-ca.directadmin.com

Total test duration: 1 seconds


Fastest server is files-fr.directadmin.com at 23485 B/s

Changed downloadserver option from files2.directadmin.com to files-fr.directadmin.com

i run the update and nothing changed!
next i changed the mirror and

Found /usr/local/directadmin/custombuild/mysql/mysql-community-client-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-devel-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-server-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-common-5.7.37-1.el7.x86_64.rpm
Stopping mysqld ...
Service didn't get stopped, sleeping for 20 secs and re-trying ...
Stopping mysqld ...
Updating MySQL 5.7.36 to 5.7.37
warning: mysql-community-client-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-5.7.37-1.e################################# [ 14%]
   2:mysql-community-libs-5.7.37-1.el7################################# [ 29%]
   3:mysql-community-client-5.7.37-1.e################################# [ 43%]
error: unpacking of archive failed on file /usr/bin/mysql;628a3be6: cpio: read
error: mysql-community-client-5.7.37-1.el7.x86_64: install failed

It didn't work bro

 

[Richard G]

It didn't work bro

Ah wait....

Found /usr/local/directadmin/custombuild/mysql/mysql-community-client-5.7.37-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-devel-5.7.37-1.el7.x86_64.rpm

Custombuild found them, they were not downloaded again.

Remove those rpm files, then try the update_versions again please?

It should download the RPM's again. If it does and still throws the error, then I guess a support ticket is needed or somebody else must know what to do.

 

[mikajaxxx]

Remove those rpm files, then try the update_versions again please?

Thank you very much. it finally solved. you are my hero
Best Regards

 

[Richard G]

So it was indeed a mirror issue.

Glad to here everything is fixed now, thank you for reporting back!