[MDEV-14671] Minor upgrade of all packages on zypper-based systems loses extra engines Created: 2017-12-16  Updated: 2018-07-13  Resolved: 2018-07-13

Status: Closed
Project: MariaDB Server
Component/s: Packaging, Platform RedHat
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-14691 Remove workaround for MDEV-14671 from... Closed
Duplicate
is duplicated by MDEV-14560 Extra engines enabled through additio... Closed
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MDEV-14691 Remove workaround for MDEV-14671 from... Technical task Closed Elena Stepanova  

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse42-amd64/builds/1676/steps/minor-upgrade-all/logs/stdio

+ case "10.1" in
+ diff -u /tmp/engines.old /tmp/engines.new
--- /tmp/engines.old	2017-12-14 17:02:46.315882591 +0000
+++ /tmp/engines.new	2017-12-14 17:04:23.219874137 +0000
@@ -1,11 +1,8 @@
 Aria	YES	NO	NO
-CASSANDRA	YES	NO	NO
-CONNECT	YES	NO	NO
 CSV	YES	NO	NO
 InnoDB	DEFAULT	YES	YES
 MEMORY	YES	NO	NO
 MRG_MyISAM	YES	NO	NO
 MyISAM	YES	NO	NO
-OQGRAPH	YES	NO	NO
 PERFORMANCE_SCHEMA	YES	NO	NO
 SEQUENCE	YES	YES	YES
 
ERROR: the lists of engines in the old and new installations differ

The problem is somewhat similar to MDEV-14560.
To upgrade installed packages from local RPMs, we run zypper install <list or RPMs> (unlike with yum. there seems to be no zypper command for actual upgrade from RPMs).

When we upgrade this way the server and extra engines together, the server gets restarted after upgrade, as it should; but it happens before the engines get upgraded, so we end up with

171217 12:18:05 [ERROR] Can't open shared library 'ha_cassandra.so' (errno: 8, API version for STORAGE ENGINE plugin CASSANDRA not supported by this version of the server)
171217 12:18:05 [ERROR] Couldn't load plugins from 'ha_cassandra.so'.
171217 12:18:05 [ERROR] Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)
171217 12:18:05 [ERROR] Couldn't load plugins from 'ha_connect.so'.
171217 12:18:05 [ERROR] Can't open shared library 'ha_oqgraph.so' (errno: 8, API version for STORAGE ENGINE plugin OQGRAPH not supported by this version of the server)
171217 12:18:05 [ERROR] Couldn't load plugins from 'ha_oqgraph.so'.
171217 12:18:05 [Note] Server socket created on IP: '::'.

If the server is restarted manually again after engines are upgraded, everything works.
For now I will add the extra server restart after upgrade for zypper-based systems.


Generated at Thu Feb 08 08:15:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.