[MDEV-25240] minor upgrade does not perform server restart Created: 2021-02-15  Updated: 2021-03-29  Resolved: 2021-03-29

Status: Closed
Project: MariaDB Server
Component/s: Packaging
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.2.38, 10.3.29

Type: Bug Priority: Critical
Reporter: Timofey Turenko Assignee: Alexey Bychko (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

sles12, sles15


Issue Links:
Problem/Incident
is caused by MDEV-21363 RPM's postin script only starts and e... Closed

 Description   

upgrade without uninstalling does not work:

 
( 1/18) Installing: MariaDB-backup-debuginfo-10.2.37_10-1.x86_64 ................................................................................................................................................................[done]
( 2/18) Installing: MariaDB-client-debuginfo-10.2.37_10-1.x86_64 ................................................................................................................................................................[done]
( 3/18) Installing: MariaDB-common-10.2.37_10-1.x86_64 ..........................................................................................................................................................................[done]
( 4/18) Installing: MariaDB-common-debuginfo-10.2.37_10-1.x86_64 ................................................................................................................................................................[done]
( 5/18) Installing: MariaDB-devel-debuginfo-10.2.37_10-1.x86_64 .................................................................................................................................................................[done]
( 6/18) Installing: MariaDB-gssapi-server-debuginfo-10.2.37_10-1.x86_64 .........................................................................................................................................................[done]
( 7/18) Installing: MariaDB-rocksdb-engine-debuginfo-10.2.37_10-1.x86_64 ........................................................................................................................................................[done]
( 8/18) Installing: MariaDB-server-debuginfo-10.2.37_10-1.x86_64 ................................................................................................................................................................[done]
( 9/18) Installing: MariaDB-shared-debuginfo-10.2.37_10-1.x86_64 ................................................................................................................................................................[done]
(10/18) Installing: galera-enterprise-3-25.3.32-1.x86_64 ........................................................................................................................................................................[done]
(11/18) Installing: MariaDB-shared-10.2.37_10-1.x86_64 ..........................................................................................................................................................................[done]
(12/18) Installing: MariaDB-devel-10.2.37_10-1.x86_64 ...........................................................................................................................................................................[done]
(13/18) Installing: MariaDB-client-10.2.37_10-1.x86_64 ..........................................................................................................................................................................[done]
(14/18) Installing: MariaDB-backup-10.2.37_10-1.x86_64 ..........................................................................................................................................................................[done]
(15/18) Installing: MariaDB-server-10.2.37_10-1.x86_64 ..........................................................................................................................................................................[done]
(16/18) Installing: MariaDB-rocksdb-engine-10.2.37_10-1.x86_64 ..................................................................................................................................................................[done]
(17/18) Installing: MariaDB-gssapi-server-10.2.37_10-1.x86_64 ...................................................................................................................................................................[done]
(18/18) Installing: MariaDB-cracklib-password-check-10.2.37_10-1.x86_64 .........................................................................................................................................................[done]
There are some running programs that might use files deleted by recent upgrade. You may wish to check and restart some of them. Run 'zypper ps -s' to list these programs.
 
turenko@mdbci-hw5cz7mm-1613413172-build:~> sudo zypper ps -s
The following running processes use deleted files:
 
PID   | PPID  | UID | User  | Command          | Service
------+-------+-----+-------+------------------+--------
13365 | 13262 | 490 | mysql | mysqld (deleted) | mysql  
 
You may wish to restart these processes.
See 'man zypper' for information about the meaning of values in the above table.

version after upgrade attempt:

echo "select version()" | sudo mysql
version()
10.2.36-10-MariaDB-enterprise

after server restart everything is ok. In other distros restart happens automatically



 Comments   
Comment by Alexey Bychko (Inactive) [ 2021-03-12 ]

tturenko how to reproduce it? is it 10.2 -> 10.3 upgrade or minor 10.2.x -> 10.2.y upgrade?

Comment by Alexey Bychko (Inactive) [ 2021-03-12 ]

surprisingly postinst script is the same in all versions. no idea why it works differently on some version

Comment by Timofey Turenko [ 2021-03-12 ]

I did one more test: installed 10.3.27-10 and tried to upgrade to 10.3.28-11:

turenko@mdbci-uqq3twrl-1615585065-build:~> sudo zypper -n install MariaDB-backup MariaDB-backup-debuginfo MariaDB-client MariaDB-client-debuginfo MariaDB-cracklib-password-check MariaDB-common MariaDB-common-debuginfo MariaDB-devel MariaDB-devel-debuginfo MariaDB-gssapi-server MariaDB-gssapi-server-debuginfo MariaDB-rocksdb-engine MariaDB-rocksdb-engine-debuginfo MariaDB-server MariaDB-server-debuginfo MariaDB-shared MariaDB-shared-debuginfo
Refreshing service 'Basesystem_Module_15_SP2_x86_64'.
Refreshing service 'Containers_Module_15_SP2_x86_64'.
Refreshing service 'Desktop_Applications_Module_15_SP2_x86_64'.
Refreshing service 'Development_Tools_Module_15_SP2_x86_64'.
Refreshing service 'Legacy_Module_15_SP2_x86_64'.
Refreshing service 'Public_Cloud_Module_15_SP2_x86_64'.
Refreshing service 'Python_2_Module_15_SP2_x86_64'.
Refreshing service 'SUSE_Cloud_Application_Platform_Tools_Module_15_SP2_x86_64'.
Refreshing service 'SUSE_Linux_Enterprise_Server_15_SP2_x86_64'.
Refreshing service 'Server_Applications_Module_15_SP2_x86_64'.
Refreshing service 'Web_and_Scripting_Module_15_SP2_x86_64'.
Loading repository data...
Reading installed packages...
Resolving package dependencies...
 
The following NEW package is going to be installed:
  galera-enterprise-3
 
The following package is going to be REMOVED:
  galera
 
The following 17 packages are going to be upgraded:
  MariaDB-backup MariaDB-backup-debuginfo MariaDB-client MariaDB-client-debuginfo MariaDB-common MariaDB-common-debuginfo MariaDB-cracklib-password-check MariaDB-devel MariaDB-devel-debuginfo
  MariaDB-gssapi-server MariaDB-gssapi-server-debuginfo MariaDB-rocksdb-engine MariaDB-rocksdb-engine-debuginfo MariaDB-server MariaDB-server-debuginfo MariaDB-shared MariaDB-shared-debuginfo
 
The following 18 packages have no support information from their vendor:
  MariaDB-backup MariaDB-backup-debuginfo MariaDB-client MariaDB-client-debuginfo MariaDB-common MariaDB-common-debuginfo MariaDB-cracklib-password-check MariaDB-devel MariaDB-devel-debuginfo
  MariaDB-gssapi-server MariaDB-gssapi-server-debuginfo MariaDB-rocksdb-engine MariaDB-rocksdb-engine-debuginfo MariaDB-server MariaDB-server-debuginfo MariaDB-shared MariaDB-shared-debuginfo
  galera-enterprise-3
 
17 packages to upgrade, 1 new, 1 to remove.
Overall download size: 171.9 MiB. Already cached: 0 B. After the operation, 58.4 MiB will be freed.
Continue? [y/n/v/...? shows all options] (y): y
Retrieving package MariaDB-backup-debuginfo-10.3.28_11-1.x86_64                                                                                                   (1/18),  33.5 MiB (154.6 MiB unpacked)
Retrieving: MariaDB-backup-debuginfo-10.3.28_11-1.x86_64.rpm .....................................................................................................................................[done]
Retrieving package MariaDB-client-debuginfo-10.3.28_11-1.x86_64                                                                                                   (2/18),   3.9 MiB ( 42.8 MiB unpacked)
Retrieving: MariaDB-client-debuginfo-10.3.28_11-1.x86_64.rpm .....................................................................................................................................[done]
Retrieving package MariaDB-common-10.3.28_11-1.x86_64                                                                                                             (3/18),  78.7 KiB (295.2 KiB unpacked)
Retrieving: MariaDB-common-10.3.28_11-1.x86_64.rpm ...............................................................................................................................................[done]
Retrieving package MariaDB-common-debuginfo-10.3.28_11-1.x86_64                                                                                                   (4/18), 168.2 KiB (736.9 KiB unpacked)
Retrieving: MariaDB-common-debuginfo-10.3.28_11-1.x86_64.rpm .....................................................................................................................................[done]
Retrieving package MariaDB-devel-debuginfo-10.3.28_11-1.x86_64                                                                                                    (5/18),  16.6 KiB ( 25.9 KiB unpacked)
Retrieving: MariaDB-devel-debuginfo-10.3.28_11-1.x86_64.rpm ......................................................................................................................................[done]
Retrieving package MariaDB-gssapi-server-debuginfo-10.3.28_11-1.x86_64                                                                                            (6/18),  52.7 KiB (172.8 KiB unpacked)
Retrieving: MariaDB-gssapi-server-debuginfo-10.3.28_11-1.x86_64.rpm ..............................................................................................................................[done]
Retrieving package MariaDB-rocksdb-engine-debuginfo-10.3.28_11-1.x86_64                                                                                           (7/18),  68.0 MiB (280.0 MiB unpacked)
Retrieving: MariaDB-rocksdb-engine-debuginfo-10.3.28_11-1.x86_64.rpm .............................................................................................................................[done]
Retrieving package MariaDB-server-debuginfo-10.3.28_11-1.x86_64                                                                                                   (8/18),  44.0 MiB (237.7 MiB unpacked)
Retrieving: MariaDB-server-debuginfo-10.3.28_11-1.x86_64.rpm ........................................................................................................................[done (29.5 MiB/s)]
Retrieving package MariaDB-shared-debuginfo-10.3.28_11-1.x86_64                                                                                                   (9/18), 356.2 KiB (  1.6 MiB unpacked)
Retrieving: MariaDB-shared-debuginfo-10.3.28_11-1.x86_64.rpm .......................................................................................................................[done (132.2 KiB/s)]
Retrieving package galera-enterprise-3-25.3.32-1.x86_64                                                                                                         (10/18), 1001.8 KiB (  3.8 MiB unpacked)
Retrieving: galera-enterprise-3-25.3.32-1.x86_64.rpm ...............................................................................................................................[done (118.8 KiB/s)]
Retrieving package MariaDB-shared-10.3.28_11-1.x86_64                                                                                                            (11/18), 105.1 KiB (324.6 KiB unpacked)
Retrieving: MariaDB-shared-10.3.28_11-1.x86_64.rpm ...............................................................................................................................................[done]
Retrieving package MariaDB-devel-10.3.28_11-1.x86_64                                                                                                             (12/18),   1.5 MiB (  6.6 MiB unpacked)
Retrieving: MariaDB-devel-10.3.28_11-1.x86_64.rpm ................................................................................................................................................[done]
Retrieving package MariaDB-client-10.3.28_11-1.x86_64                                                                                                            (13/18),   1.5 MiB ( 37.6 MiB unpacked)
Retrieving: MariaDB-client-10.3.28_11-1.x86_64.rpm ...............................................................................................................................................[done]
Retrieving package MariaDB-backup-10.3.28_11-1.x86_64                                                                                                            (14/18),   5.3 MiB ( 24.7 MiB unpacked)
Retrieving: MariaDB-backup-10.3.28_11-1.x86_64.rpm ...............................................................................................................................................[done]
Retrieving package MariaDB-server-10.3.28_11-1.x86_64                                                                                                            (15/18),   9.4 MiB (104.7 MiB unpacked)
Retrieving: MariaDB-server-10.3.28_11-1.x86_64.rpm ...............................................................................................................................................[done]
Retrieving package MariaDB-rocksdb-engine-10.3.28_11-1.x86_64                                                                                                    (16/18),   3.0 MiB ( 16.8 MiB unpacked)
Retrieving: MariaDB-rocksdb-engine-10.3.28_11-1.x86_64.rpm .......................................................................................................................................[done]
Retrieving package MariaDB-gssapi-server-10.3.28_11-1.x86_64                                                                                                     (17/18),  12.9 KiB ( 14.4 KiB unpacked)
Retrieving: MariaDB-gssapi-server-10.3.28_11-1.x86_64.rpm ........................................................................................................................................[done]
Retrieving package MariaDB-cracklib-password-check-10.3.28_11-1.x86_64                                                                                           (18/18),  10.3 KiB (  6.3 KiB unpacked)
Retrieving: MariaDB-cracklib-password-check-10.3.28_11-1.x86_64.rpm .................................................................................................................[done (10.3 KiB/s)]
 
Checking for file conflicts: .....................................................................................................................................................................[done]
( 1/18) Installing: MariaDB-backup-debuginfo-10.3.28_11-1.x86_64 .................................................................................................................................[done]
( 2/18) Installing: MariaDB-client-debuginfo-10.3.28_11-1.x86_64 .................................................................................................................................[done]
( 3/18) Installing: MariaDB-common-10.3.28_11-1.x86_64 ...........................................................................................................................................[done]
( 4/18) Installing: MariaDB-common-debuginfo-10.3.28_11-1.x86_64 .................................................................................................................................[done]
( 5/18) Installing: MariaDB-devel-debuginfo-10.3.28_11-1.x86_64 ..................................................................................................................................[done]
( 6/18) Installing: MariaDB-gssapi-server-debuginfo-10.3.28_11-1.x86_64 ..........................................................................................................................[done]
( 7/18) Installing: MariaDB-rocksdb-engine-debuginfo-10.3.28_11-1.x86_64 .........................................................................................................................[done]
( 8/18) Installing: MariaDB-server-debuginfo-10.3.28_11-1.x86_64 .................................................................................................................................[done]
( 9/18) Installing: MariaDB-shared-debuginfo-10.3.28_11-1.x86_64 .................................................................................................................................[done]
(10/18) Installing: galera-enterprise-3-25.3.32-1.x86_64 .........................................................................................................................................[done]
(11/18) Installing: MariaDB-shared-10.3.28_11-1.x86_64 ...........................................................................................................................................[done]
(12/18) Installing: MariaDB-devel-10.3.28_11-1.x86_64 ............................................................................................................................................[done]
(13/18) Installing: MariaDB-client-10.3.28_11-1.x86_64 ...........................................................................................................................................[done]
(14/18) Installing: MariaDB-backup-10.3.28_11-1.x86_64 ...........................................................................................................................................[done]
(15/18) Installing: MariaDB-server-10.3.28_11-1.x86_64 ...........................................................................................................................................[done]
(16/18) Installing: MariaDB-rocksdb-engine-10.3.28_11-1.x86_64 ...................................................................................................................................[done]
(17/18) Installing: MariaDB-gssapi-server-10.3.28_11-1.x86_64 ....................................................................................................................................[done]
(18/18) Installing: MariaDB-cracklib-password-check-10.3.28_11-1.x86_64 ..........................................................................................................................[done]
Executing %posttrans scripts .....................................................................................................................................................................[done]
There are running programs which still use files and libraries deleted or updated by recent upgrades. They should be restarted to benefit from the latest updates. Run 'zypper ps -s' to list these programs.
 
turenko@mdbci-uqq3twrl-1615585065-build:~> sudo mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.3.27-10-MariaDB-enterprise MariaDB Enterprise Server
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [(none)]> select @@version;
+-------------------------------+
| @@version                     |
+-------------------------------+
| 10.3.27-10-MariaDB-enterprise |
+-------------------------------+
1 row in set (0.000 sec)

Then tried to restart:

turenko@mdbci-uqq3twrl-1615585065-build:~> sudo service mariadb restart
Job for mariadb.service failed because the control process exited with error code.
See "systemctl  status mariadb.service" and "journalctl  -xe" for details.

 
turenko@mdbci-uqq3twrl-1615585065-build:~> sudo journalctl  -xe
Mar 12 23:00:38 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Mar 12 23:00:39 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Mar 12 23:00:39 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Mar 12 23:00:40 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Mar 12 23:00:40 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [Note] InnoDB: Unable to open the first data file
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-sy>
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system t>
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
Mar 12 23:00:41 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:41 0 [Note] InnoDB: Starting shutdown...
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [ERROR] Plugin 'InnoDB' init function returned error.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [Note] Plugin 'S3' is disabled.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [Note] Plugin 'FEEDBACK' is disabled.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/mdbci-uqq3twrl-1615585065-build@' not found in keytab
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS fa>
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [ERROR] Plugin 'gssapi' init function returned error.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 210312 23:00:42 server_audit: MariaDB Audit Plugin version 1.4.11 STARTED.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 210312 23:00:42 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2021-03-12 23:00:42 0 [ERROR]>
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 2021-03-12 23:00:42 0 [ERROR] Aborting
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: 210312 23:00:42 server_audit: STOPPED
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build mysqld[16117]: Warning: Memory not freed: 520
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build systemd[1]: Failed to start MariaDB 10.3.28-11 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mariadb.service has failed.
-- 
-- The result is failed.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build systemd[1]: mariadb.service: Unit entered failed state.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mar 12 23:00:42 mdbci-uqq3twrl-1615585065-build sudo[16061]: pam_unix(sudo:session): session closed for user root
Mar 12 23:03:10 mdbci-uqq3twrl-1615585065-build sudo[16152]:  turenko : TTY=pts/0 ; PWD=/home/turenko ; USER=root ; COMMAND=/usr/bin/journalctl -xe
Mar 12 23:03:10 mdbci-uqq3twrl-1615585065-build sudo[16152]: pam_unix(sudo:session): session opened for user root by turenko(uid=1000)
turenko@mdbci-uqq3twrl-1615585065-build:~> systemctl  status mariadb.service
● mariadb.service - MariaDB 10.3.28-11 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Fri 2021-03-12 23:00:42 CET; 2min 54s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 16117 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 16072 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITI>
  Process: 16071 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 16117 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
lines 1-12/12 (END)

but:

systemctl  status mysql.service
● mysql.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/init.d/mysql; generated; vendor preset: disabled)
   Active: active (running) since Fri 2021-03-12 22:48:49 CET; 17min ago
     Docs: man:systemd-sysv-generator(8)
    Tasks: 39
   CGroup: /system.slice/mysql.service
           ├─14796 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mdbci-uqq3twrl-1615585065-build.pid
           └─14912 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mdbci-uqq3twrl-1615585065-build.err --pid-file>

but:

 sudo systemctl  stop mysql.service
 sudo systemctl  start mariadb.service

fixes the problem

Comment by Alexey Bychko (Inactive) [ 2021-03-18 ]

even more, server is not started on SLES after installation

sles-15:~ # rpm -qa | grep Maria
MariaDB-common-10.3.28_11-1.x86_64
MariaDB-backup-10.3.28_11-1.x86_64
MariaDB-cracklib-password-check-10.3.28_11-1.x86_64
MariaDB-shared-10.3.28_11-1.x86_64
MariaDB-client-10.3.28_11-1.x86_64
MariaDB-server-10.3.28_11-1.x86_64
MariaDB-gssapi-server-10.3.28_11-1.x86_64
MariaDB-devel-10.3.28_11-1.x86_64
MariaDB-rocksdb-engine-10.3.28_11-1.x86_64
sles-15:~ # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Comment by Alexey Bychko (Inactive) [ 2021-03-18 ]

seems the problem is related to following piece of code:

    if [ $1 = 2 ]; then
      SYSTEMCTL_SKIP_REDIRECT=1 /etc/init.d/mysql stop >/dev/null 2>&1 || :
      systemctl start mariadb >/dev/null 2>&1 || :
    fi

posttrans scriptlet (using /bin/sh):
set -x
if [ -r /var/lib/rpm-state/mariadb/need-restart ] ; then
  rm /var/lib/rpm-state/mariadb/need-restart
  if [ -x /usr/bin/systemctl ] ; then
    /usr/bin/systemctl daemon-reload > /dev/null 2>&1
    /usr/bin/systemctl try-restart mariadb.service > /dev/null 2>&1
  elif /etc/init.d/mysql status > /dev/null 2>&1; then
    # only restart the server if it was alredy running
    /etc/init.d/mysql restart
  fi
fi

so, restart on upgrade should be performed in 2 parts: stop using old sysv script (disregarding its existence) and start then using systemd unit

Comment by Alexey Bychko (Inactive) [ 2021-03-18 ]

upgrade trace log:

Checking for file conflicts: ..................................................................................................................................................................................[done]
(1/1) Installing: MariaDB-server-10.3.29_12-1.x86_64 ..........................................................................................................................................................[done]
Additional rpm output:
++ rpm -q --whatprovides mysql-server
+ installed='MariaDB-server-10.3.28_11-1.x86_64
MariaDB-server-10.3.28_11-1.x86_64'
+ '[' 0 -eq 0 -a -n 'MariaDB-server-10.3.28_11-1.x86_64
MariaDB-server-10.3.28_11-1.x86_64' ']'
++ echo 'MariaDB-server-10.3.28_11-1.x86_64
MariaDB-server-10.3.28_11-1.x86_64'
++ sed -n 1p
+ installed=MariaDB-server-10.3.28_11-1.x86_64
++ rpm -q '--queryformat=MariaDB Corporation' MariaDB-server-10.3.28_11-1.x86_64
++ sed 's/Monty Program AB/MariaDB Foundation/'
+ vendor='MariaDB Corporation'
++ rpm -q --queryformat=10.3.29_12 MariaDB-server-10.3.28_11-1.x86_64
+ version=10.3.29_12
+ myvendor='MariaDB Corporation'
+ myversion=10.3.29
++ echo 10.3.29_12
++ sed -n -e 's,^\([1-9][0-9]*\.[0-9][0-9]*\)\..*$,\1,p'
+ old_family=10.3
++ echo 10.3.29
++ sed -n -e 's,^\([1-9][0-9]*\.[0-9][0-9]*\)\..*$,\1,p'
+ new_family=10.3
+ '[' -z 'MariaDB Corporation' ']'
+ '[' -z 10.3 ']'
+ '[' -z 10.3 ']'
+ error_text=
+ '[' 'MariaDB Corporation' '!=' 'MariaDB Corporation' ']'
+ '[' 10.3 '!=' 10.3 ']'
+ '[' -n '' ']'
+ '[' -f /usr/lib/systemd/system/mariadb.service -a -x /usr/bin/systemctl ']'
+ systemd_conf=/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
+ '[' -x /usr/bin/mariadb-service-convert -a '!' -f /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf ']'
+ '[' 2 = 1 ']'
+ SETARGETDIR=/etc/selinux/targeted/src/policy
+ SEDOMPROG=/etc/selinux/targeted/src/policy/domains/program
+ SECONPROG=/etc/selinux/targeted/src/policy/file_contexts/program
+ '[' -x /usr/sbin/semodule ']'
+ /usr/sbin/semodule -i /usr/share/mysql/policy/selinux/mariadb.pp
Failed to resolve typeattributeset statement at /var/lib/selinux/targeted/tmp/modules/400/mariadb/cil:1
/usr/sbin/semodule:  Failed!
+ '[' -x sbin/restorecon ']'
+ sbin/restorecon -R var/lib/mysql
 
 
Executing %posttrans script 'MariaDB-server-10.3.29_12-1.x86_64.rpm' ---------------------------------------------------------------------------------------------------------------------------------------------[-]
Output of MariaDB-server-10.3.29_12-1.x86_64.rpm %posttrans script:
    + '[' -r /var/lib/rpm-state/mariadb/need-restart ']'
    + rm /var/lib/rpm-state/mariadb/need-restart
    + '[' -x /usr/bin/systemctl ']'
    + /usr/bin/systemctl daemon-reload
    + /usr/bin/systemctl try-restart mariadb.service
 
Executing %posttrans scripts ..................................................................................................................................................................................[done]
There are running programs which still use files and libraries deleted or updated by recent upgrades. They should be restarted to benefit from the latest updates. Run 'zypper ps -s' to list these programs.

Comment by Alexey Bychko (Inactive) [ 2021-03-18 ]

The following running processes use deleted files:
 
PID   | PPID  | UID | User  | Command          | Service
------+-------+-----+-------+------------------+--------
12565 | 12451 | 475 | mysql | mysqld (deleted) | mysql
 
You may wish to restart these processes.
See 'man zypper' for information about the meaning of values in the above table.
 
No core libraries or services have been updated.
Reboot is probably not necessary.

Comment by Alexey Bychko (Inactive) [ 2021-03-18 ]

● mariadb.service - MariaDB 10.3.29-12 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: inactive (dead)
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/

Comment by Alexey Bychko (Inactive) [ 2021-03-24 ]

adjusted the restart logic on upgrade

Comment by Alexey Bychko (Inactive) [ 2021-03-25 ]

actually, we see the sum of few bugs here. whole upgrade logic is broken

Comment by Alexey Bychko (Inactive) [ 2021-03-29 ]

in general it's fixed, pushed to ES and CS. ES is done, waiting for CS 10.2

Comment by Alexey Bychko (Inactive) [ 2021-03-29 ]

pushed to CS also

Generated at Thu Feb 08 09:36:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.