Improve installation procedure and reduce SQL limitations (MCOL-3686)

[MCOL-3708] RPM/DEB removal should run mcsadmin shutdown Created: 2020-01-03  Updated: 2020-02-20  Resolved: 2020-02-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.4.2
Fix Version/s: 1.4.3

Type: Sub-Task Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
Duplicate
Sprint: 2020-1, 2020-2, 2020-4, 2020-5, 2020-6, 2020-7

 Description   

When the RPM/DEB packages for ColumnStore are removed they should execute a cluster shutdown.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2020-01-21 ]

In the PR with MCOL-3707

Comment by Daniel Lee (Inactive) [ 2020-02-10 ]

Build verified: 1.4.3-1 source
server
commit 9bd5e14f4de1402c6cd4a3f81564887c1213c9e1
engine
commit 5efa6a4dc52129be2de49fdfc23e44020401b86b

Verified RPM packages only. DEB packages are not yet available.

[root@localhost ~]# rpm -e $(rpm -qa 'MariaDB*')
shutdownsystem Mon Feb 10 21:41:51 2020

This command stops the processing of applications on all Modules within the MariaDB ColumnStore System

Checking for active transactions

Stopping System...
Successful stop of System

Shutting Down System...
Successful shutdown of System

Mariab Columnstore uninstall completed

Comment by Daniel Lee (Inactive) [ 2020-02-12 ]

Build tested: 1.4.3-1 BB nightly

Engine commit: 8588678

Centos 7 RPM worked as specified, but Debian 8 DEB did not run "mcsadmin shutdown".

I used "dpkg -r" and "dpkg -P" to remove the packages. Is there a different command I should use?
root@jessie:~# dpkg -r $(dpkg -l |grep Maria|awk -F" " '

{print $2}')
(Reading database ... 72839 files and directories currently installed.)
Removing libmariadb3-compat (1:10.4.12.6+maria~jessie) ...
Removing mariadb-columnstore-engine (1.4.3-1) ...
Removing mariadb-columnstore-libs (1.4.3-1) ...
Removing mariadb-columnstore-platform (1.4.3-1) ...
dpkg: warning: while removing mariadb-columnstore-platform, directory '/var/lib/columnstore/local' not empty so not removed
dpkg: warning: while removing mariadb-columnstore-platform, directory '/etc/columnstore' not empty so not removed
Removing mariadb-server-10.4 (1:10.4.12.6+maria~jessie) ...
Warning: Unit file of mysql.service changed on disk, 'systemctl daemon-reload' recommended.
Removing mariadb-server-core-10.4 (1:10.4.12.6+maria~jessie) ...
dpkg: warning: while removing mariadb-server-core-10.4, directory '/usr/share/mysql' not empty so not removed
Removing mariadb-client-10.4 (1:10.4.12.6+maria~jessie) ...
Removing mariadb-client-core-10.4 (1:10.4.12.6+maria~jessie) ...
Removing libmariadb3:amd64 (1:10.4.12.6+maria~jessie) ...
Removing mariadb-common (1:10.4.12.6+maria~jessie) ...
Removing mysql-common (1:10.4.12.6+maria~jessie) ...
Processing triggers for man-db (2.7.0.2-5) ...
Processing triggers for libc-bin (2.19-18+deb8u6) ...
root@jessie:~# ma
-bash: /usr/bin/mcsadmin: No such file or directory
root@jessie:~# ps -ef |grep ExeMgr
root 4441 3297 0 21:02 ? 00:00:00 [ExeMgr]
root 17328 15864 0 21:40 pts/0 00:00:00 grep ExeMgr

root@jessie:~# dpkg -P $(dpkg -l |grep Maria|awk -F" " '{print $2}

')
(Reading database ... 72361 files and directories currently installed.)
Removing libmariadb3:amd64 (1:10.4.12.6+maria~jessie) ...
Purging configuration files for libmariadb3:amd64 (1:10.4.12.6+maria~jessie) ...
Removing mariadb-client-10.4 (1:10.4.12.6+maria~jessie) ...
Purging configuration files for mariadb-client-10.4 (1:10.4.12.6+maria~jessie) ...
Removing mariadb-common (1:10.4.12.6+maria~jessie) ...
Purging configuration files for mariadb-common (1:10.4.12.6+maria~jessie) ...
Removing mariadb-server-10.4 (1:10.4.12.6+maria~jessie) ...
Purging configuration files for mariadb-server-10.4 (1:10.4.12.6+maria~jessie) ...
userdel: user mysql is currently used by process 3870
Removing mysql-common (1:10.4.12.6+maria~jessie) ...
Purging configuration files for mysql-common (1:10.4.12.6+maria~jessie) ...
root@jessie:~# ps -ef |grep ExeMgr
root 4441 3297 0 21:02 ? 00:00:00 [ExeMgr]
root 18454 17849 0 21:57 pts/0 00:00:00 grep ExeMgr

Comment by Daniel Lee (Inactive) [ 2020-02-20 ]

Build verified: 1.4.3-1 Azure build (20200220)

Verified both RPM and DEB packages.

Generated at Thu Feb 08 02:44:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.