[MCOL-5446] CS Install/Upgrade chown mysql:mysql /var/lib/columnstore performance Created: 2023-03-08  Updated: 2023-07-01

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Allen Herrera Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

On large customer deployments, the following takes a very long time when using the yum package manager.

chown mysql:mysql /var/lib/columnstore/

For rpms i have this work around

# rpm -Uvh MariaDB-columnstore-engine-10.6.7[version].centos.x86_64.rpm --noscripts
    * Edit the file /bin/columnstore-post-install and comment out line 357
    * Manually run the two commands that the install script would normally run automatically:
# mkdir -p /var/lib/columnstore/local (this may already exist, only run it if need be)
# columnstore-post-install --rpmmode=install

Ideally columnstore might search for files not own by mysql or count if none skip. Or provide an easy method to skip this check on upgrade. The current brute force method makes upgrading customers production take super long when downtime is most critical and needs to be as fast as possible often.


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