Update MariaDB 10.4.25 to 10.4.26 & 10.5.16 to 10.5.17 failed

T

toktokcity

Verified User
Joined
Apr 29, 2016
Messages
87
Location
The Netherlands
Normally running updates whitout any problems. But now the update failed and version is still .25. The update disappeared from Custombuild.

Make complete
Packaging mariadb-10.4.26...
CPack3: Create package using TGZ
CPack3: Install projects
CPack3: - Install project: MySQL []
CPack3: Create package
CPack3: - package: /usr/local/directadmin/custombuild/mariadb-10.4.26/mariadb-10.4.26-linux-x86_64.tar.gz generated.
Moving mariadb-10.4.26-*.tar.gz to /usr/local/directadmin/custombuild ...
Done.
Found created package: mariadb-10.4.26-linux-x86_64.tar.gz
tar: write error
Stopping mysqld ...
Service didn't get stopped, sleeping for 20 secs and re-trying ...
Stopping mysqld ...
Removed symlink /etc/systemd/system/multi-user.target.wants/mariadb.service.
Removed symlink /etc/systemd/system/mysql.service.
Removed symlink /etc/systemd/system/mysqld.service.
mv: cannot stat '/etc/systemd/system/mysql.service': No such file or directory
Failed to execute operation: No such file or directory
Failed to execute operation: No such file or directory
Linking /usr/local/mysql/bin/aria_chk -> /usr/local/bin/aria_chk...
Linking /usr/local/mysql/bin/aria_dump_log -> /usr/local/bin/aria_dump_log...
Linking /usr/local/mysql/bin/aria_ftdump -> /usr/local/bin/aria_ftdump...
Linking /usr/local/mysql/bin/aria_pack -> /usr/local/bin/aria_pack...
Linking /usr/local/mysql/bin/aria_read_log -> /usr/local/bin/aria_read_log...
Linking /usr/local/mysql/bin/galera_new_cluster -> /usr/local/bin/galera_new_cluster...
Linking /usr/local/mysql/bin/galera_recovery -> /usr/local/bin/galera_recovery...
Linking /usr/local/mysql/bin/innochecksum -> /usr/local/bin/innochecksum...
Linking /usr/local/mysql/bin/mariabackup -> /usr/local/bin/mariabackup...
Linking /usr/local/mysql/bin/mariadb -> /usr/local/bin/mariadb...
Linking /usr/local/mysql/bin/mariadb-access -> /usr/local/bin/mariadb-access...
Linking /usr/local/mysql/bin/mariadb-admin -> /usr/local/bin/mariadb-admin...
Linking /usr/local/mysql/bin/mariadb-backup -> /usr/local/bin/mariadb-backup...
Linking /usr/local/mysql/bin/mariadb-binlog -> /usr/local/bin/mariadb-binlog...
Linking /usr/local/mysql/bin/mariadb-check -> /usr/local/bin/mariadb-check...
Linking /usr/local/mysql/bin/mariadb-client-test -> /usr/local/bin/mariadb-client-test...
Linking /usr/local/mysql/bin/mariadb-convert-table-format -> /usr/local/bin/mariadb-convert-table-format...
Linking /usr/local/mysql/bin/mariadb-dump -> /usr/local/bin/mariadb-dump...
Linking /usr/local/mysql/bin/mariadb-dumpslow -> /usr/local/bin/mariadb-dumpslow...
Linking /usr/local/mysql/bin/mariadb-find-rows -> /usr/local/bin/mariadb-find-rows...
Linking /usr/local/mysql/bin/mariadb-fix-extensions -> /usr/local/bin/mariadb-fix-extensions...
Linking /usr/local/mysql/bin/mariadb-hotcopy -> /usr/local/bin/mariadb-hotcopy...
Linking /usr/local/mysql/bin/mariadb-import -> /usr/local/bin/mariadb-import...
Linking /usr/local/mysql/bin/mariadb-plugin -> /usr/local/bin/mariadb-plugin...
Linking /usr/local/mysql/bin/mariadb-secure-installation -> /usr/local/bin/mariadb-secure-installation...
Linking /usr/local/mysql/bin/mariadb-service-convert -> /usr/local/bin/mariadb-service-convert...
Linking /usr/local/mysql/bin/mariadb-setpermission -> /usr/local/bin/mariadb-setpermission...
Linking /usr/local/mysql/bin/mariadb-show -> /usr/local/bin/mariadb-show...
Linking /usr/local/mysql/bin/mariadb-slap -> /usr/local/bin/mariadb-slap...
Linking /usr/local/mysql/bin/mariadb-test -> /usr/local/bin/mariadb-test...
Linking /usr/local/mysql/bin/mariadb-tzinfo-to-sql -> /usr/local/bin/mariadb-tzinfo-to-sql...
Linking /usr/local/mysql/bin/mariadb-upgrade -> /usr/local/bin/mariadb-upgrade...
Linking /usr/local/mysql/bin/mariadb-waitpid -> /usr/local/bin/mariadb-waitpid...
Linking /usr/local/mysql/bin/mariadb_config -> /usr/local/bin/mariadb_config...
Linking /usr/local/mysql/bin/mariadbd -> /usr/local/bin/mariadbd...
Linking /usr/local/mysql/bin/mariadbd-multi -> /usr/local/bin/mariadbd-multi...
Linking /usr/local/mysql/bin/mariadbd-safe -> /usr/local/bin/mariadbd-safe...
Linking /usr/local/mysql/bin/mariadbd-safe-helper -> /usr/local/bin/mariadbd-safe-helper...
Linking /usr/local/mysql/bin/mbstream -> /usr/local/bin/mbstream...
Linking /usr/local/mysql/bin/msql2mysql -> /usr/local/bin/msql2mysql...
Linking /usr/local/mysql/bin/my_print_defaults -> /usr/local/bin/my_print_defaults...
Linking /usr/local/mysql/bin/myisam_ftdump -> /usr/local/bin/myisam_ftdump...
Linking /usr/local/mysql/bin/myisamchk -> /usr/local/bin/myisamchk...
Linking /usr/local/mysql/bin/myisamlog -> /usr/local/bin/myisamlog...
Linking /usr/local/mysql/bin/myisampack -> /usr/local/bin/myisampack...
Linking /usr/local/mysql/bin/mysql -> /usr/local/bin/mysql...
Linking /usr/local/mysql/bin/mysql_client_test -> /usr/local/bin/mysql_client_test...
Linking /usr/local/mysql/bin/mysql_config -> /usr/local/bin/mysql_config...
Linking /usr/local/mysql/bin/mysql_convert_table_format -> /usr/local/bin/mysql_convert_table_format...
Linking /usr/local/mysql/bin/mysql_find_rows -> /usr/local/bin/mysql_find_rows...
Linking /usr/local/mysql/bin/mysql_fix_extensions -> /usr/local/bin/mysql_fix_extensions...
Linking /usr/local/mysql/bin/mysql_plugin -> /usr/local/bin/mysql_plugin...
Linking /usr/local/mysql/bin/mysql_secure_installation -> /usr/local/bin/mysql_secure_installation...
Linking /usr/local/mysql/bin/mysql_setpermission -> /usr/local/bin/mysql_setpermission...
Linking /usr/local/mysql/bin/mysql_tzinfo_to_sql -> /usr/local/bin/mysql_tzinfo_to_sql...
Linking /usr/local/mysql/bin/mysql_upgrade -> /usr/local/bin/mysql_upgrade...
Linking /usr/local/mysql/bin/mysql_waitpid -> /usr/local/bin/mysql_waitpid...
Linking /usr/local/mysql/bin/mysqlaccess -> /usr/local/bin/mysqlaccess...
Linking /usr/local/mysql/bin/mysqladmin -> /usr/local/bin/mysqladmin...
Linking /usr/local/mysql/bin/mysqlbinlog -> /usr/local/bin/mysqlbinlog...
Linking /usr/local/mysql/bin/mysqlcheck -> /usr/local/bin/mysqlcheck...
Linking /usr/local/mysql/bin/mysqld -> /usr/local/bin/mysqld...
Linking /usr/local/mysql/bin/mysqld_multi -> /usr/local/bin/mysqld_multi...
Linking /usr/local/mysql/bin/mysqld_safe -> /usr/local/bin/mysqld_safe...
Linking /usr/local/mysql/bin/mysqld_safe_helper -> /usr/local/bin/mysqld_safe_helper...
Linking /usr/local/mysql/bin/mysqldump -> /usr/local/bin/mysqldump...
Linking /usr/local/mysql/bin/mysqldumpslow -> /usr/local/bin/mysqldumpslow...
Linking /usr/local/mysql/bin/mysqlhotcopy -> /usr/local/bin/mysqlhotcopy...
Linking /usr/local/mysql/bin/mysqlimport -> /usr/local/bin/mysqlimport...
Linking /usr/local/mysql/bin/mysqlshow -> /usr/local/bin/mysqlshow...
Linking /usr/local/mysql/bin/mysqlslap -> /usr/local/bin/mysqlslap...
Linking /usr/local/mysql/bin/mysqltest -> /usr/local/bin/mysqltest...
Linking /usr/local/mysql/bin/mytop -> /usr/local/bin/mytop...
Linking /usr/local/mysql/bin/perror -> /usr/local/bin/perror...
Linking /usr/local/mysql/bin/replace -> /usr/local/bin/replace...
Linking /usr/local/mysql/bin/resolve_stack_dump -> /usr/local/bin/resolve_stack_dump...
Linking /usr/local/mysql/bin/resolveip -> /usr/local/bin/resolveip...
Linking /usr/local/mysql/bin/wsrep_sst_backup -> /usr/local/bin/wsrep_sst_backup...
Linking /usr/local/mysql/bin/wsrep_sst_common -> /usr/local/bin/wsrep_sst_common...
Linking /usr/local/mysql/bin/wsrep_sst_mariabackup -> /usr/local/bin/wsrep_sst_mariabackup...
Linking /usr/local/mysql/bin/wsrep_sst_mysqldump -> /usr/local/bin/wsrep_sst_mysqldump...
Linking /usr/local/mysql/bin/wsrep_sst_rsync -> /usr/local/bin/wsrep_sst_rsync...
Linking /usr/local/mysql/bin/wsrep_sst_rsync_wan -> /usr/local/bin/wsrep_sst_rsync_wan...
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
FATAL ERROR: Upgrade failed
[1mError running '/usr/local/mysql/bin/mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --skip-version-check'(B[m
Restarting MySQL.
Installation completed.
Click to expand...

Update: problem on two different servers, one running MariaDB 10.4 and one 10.5
 
Last edited:
Code: 
Moving mariadb-10.4.26-*.tar.gz to /usr/local/directadmin/custombuild ...
Done.
Found created package: mariadb-10.4.26-linux-x86_64.tar.gz
tar: write error

Do you have enough disk space available in your /usr partition? You should have enough to both move the tar.gz file there and extract it, so it could be a few GB.
 
wtptrs said:
Code: 
Moving mariadb-10.4.26-*.tar.gz to /usr/local/directadmin/custombuild ...
Done.
Found created package: mariadb-10.4.26-linux-x86_64.tar.gz
tar: write error

Do you have enough disk space available in your /usr partition? You should have enough to both move the tar.gz file there and extract it, so it could be a few GB.
Click to expand...
 

Attachments

  • IMG_20220817_103238.jpg
    IMG_20220817_103238.jpg
    101.3 KB · Views: 5
Could you try removing /usr/local/directadmin/custombuild/mariadb-10.4.26-linux-x86_64* (both the .tar.gz if it exists and the folder) and building mariadb again?
 
wtptrs said:
Could you try removing /usr/local/directadmin/custombuild/mariadb-10.4.26-linux-x86_64* (both the .tar.gz if it exists and the folder) and building mariadb again?
Click to expand...
I did remove the file from the CustomBuild directory, but the update is not coming back in CustomBuild.
 
Same problem also occured on another server by updating from 10.5.16 to 10.5.17.
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
FATAL ERROR: Upgrade failed
[1mError running '/usr/local/mysql/bin/mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --skip-version-check'(B[m
Restarting MySQL.
Installation completed.
Click to expand...
 
toktokcity said:
Same problem also occured on another server by updating from 10.5.16 to 10.5.17.
Click to expand...
Hmm... is your DA / Custombuild upgraded to the latest version?
Is your MySQL datadir /home/mysql by any chance? See also:

Build MariaDB deletes all databases

I don't know if this behaviour is intended or a bug, but for me it was a surprise. I had some issues with MariaDB crashing the last week so I decided to rebuild it to see if it would fix things, wouldn't hurt either right? Custombuild > Build Software > Build MariaDB. I thought this worked...
forum.directadmin.com forum.directadmin.com
 
What does
toktokcity said:
./build tells the version of MariaDB is 10.4.26.

System information in DirectAdmin displays


Going to reboot the system tonight and see which DB it will start.
Click to expand...
What does

Code: 
mysqld --version

say?
 
wtptrs said:
What does

Code: 
mysqld --version

say?
Click to expand...
mysqld Ver 10.4.26-MariaDB for Linux on x86_64 (Source distribution)

&

mysqld Ver 10.5.17-MariaDB for Linux on x86_64 (Source distribution)

PMA is also telling me it is working on the updated version. So, although I got errors telling me the update failed, it is running.

I am a bit lost in confusion right now :-|
 
Last edited:
toktokcity said:
mysqld Ver 10.4.26-MariaDB for Linux on x86_64 (Source distribution)

&

mysqld Ver 10.5.17-MariaDB for Linux on x86_64 (Source distribution)

PMA is also telling me it is working on the updated version. So, although I got errors telling me the update failed, it is running.

I am a bit lost in confusion right now :-|
Click to expand...
Hmm not sure, looks like you are running the latest version but Directadmin is showing the unupdated version. Not sure where it's getting the System Information input from.
 
Try:
Code: 
cd /usr/local/directadmin/custombuild
./build update
./build mysql

If it doesn't help - feel free to PM me.
 
smtalk said:
Try:
Code: 
cd /usr/local/directadmin/custombuild
./build update
./build mysql

If it doesn't help - feel free to PM me.
Click to expand...
I think the point of wtptrs is correct, after the errors, the system looks to be updated and is running, but DirectAdmin didn't notice this and is still displaying the old version.
 
toktokcity said:
but DirectAdmin didn't notice this and is still displaying the old version.
Click to expand...
Like smtalk said... send him a pm.

We also did the Mariadb 10.4.25 to 10.4.26 but in our case DA does display the correct version.
So maybe there is some small adjustment needed, but smtalk can see quickly why the display in DA is wrong.
 
After update 10.4.26 -> 10.4.27 on one server failed:

Please help

Bash: 
[root@cursadweb-04 custombuild]# ./build mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error: Nothing to do
######################################################################## 100.0%
Found /usr/local/directadmin/custombuild/mysql/MariaDB-client-10.4.27-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-devel-10.4.27-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-server-10.4.27-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-shared-10.4.27-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-common-10.4.27-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-compat-10.4.27-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-backup-10.4.27-1.el7.centos.x86_64.rpm
Installing dependencies...
Installing libjemalloc...
Found /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/jemalloc-devel-3.6.0-1.el7.x86_64.rpm
warning: /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ########################################
Updating / installing...
jemalloc-3.6.0-1.el7                  ########################################
jemalloc-devel-3.6.0-1.el7            ########################################
Installing galera...
Found /usr/local/directadmin/custombuild/mysql/galera-4-26.4.8-1.el7.centos.x86_64.rpm
warning: /usr/local/directadmin/custombuild/mysql/galera-4-26.4.8-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ########################################
Updating / installing...
galera-4-26.4.8-1.el7.centos          ########################################
Stopping mysqld ...
Updating MariaDB 10.4.27 to 10.4.27
warning: MariaDB-client-10.4.27-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ########################################
Updating / installing...
MariaDB-compat-10.4.27-1.el7.centos   ########################################
MariaDB-common-10.4.27-1.el7.centos   ########################################
MariaDB-client-10.4.27-1.el7.centos   ########################################
MariaDB-shared-10.4.27-1.el7.centos   ########################################
MariaDB-devel-10.4.27-1.el7.centos    ########################################
MariaDB-server-10.4.27-1.el7.centos   ########################################
MariaDB-backup-10.4.27-1.el7.centos   ########################################
Created symlink from /etc/systemd/system/mysql.service to /etc/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/mysqld.service to /etc/systemd/system/mariadb.service.
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
Installation completed.
 
You must log in or register to reply here.
Back
Top