[MCOL-5060] Clean up legacy OAM remnants Created: 2022-04-21  Updated: 2022-06-06  Resolved: 2022-06-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: 6.2.3
Fix Version/s: 6.4.1

Type: Bug Priority: Major
Reporter: Todd Stoffel (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Duplicate
duplicates MCOL-4094 Syntax error in columnstore-post-inst... Closed

 Description   

columnstore-post-install contains some code that needs cleanup as well as a reference to obsolete software. This is breaking some installs.

[root@1224989474ee /]# dnf -y install MariaDB-columnstore-engine
Last metadata expiration check: 0:01:01 ago on Thu Apr 21 16:41:54 2022.
Dependencies resolved.
===============================================================================================================================================================================================================================================================
 Package                                                                Architecture                                       Version                                                           Repository                                                   Size
===============================================================================================================================================================================================================================================================
Installing:
 MariaDB-columnstore-engine                                             x86_64                                             10.6.7_3_6.2.3-1.el8                                              mariadb-es-main                                             7.4 M
 
Transaction Summary
===============================================================================================================================================================================================================================================================
Install  1 Package
 
Total download size: 7.4 M
Installed size: 7.4 M
Downloading Packages:
MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el8.x86_64.rpm                                                                                                                                                                     9.2 MB/s | 7.4 MB     00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                                          9.1 MB/s | 7.4 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                                                                                                       1/1
  Running scriptlet: MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el8.x86_64                                                                                                                                                                                1/1
  Installing       : MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el8.x86_64                                                                                                                                                                                1/1
  Running scriptlet: MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el8.x86_64                                                                                                                                                                                1/1
checking for engine columnstore...
columnstore exists
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
strings: '/proc/0/environ': No such file
error: process ID out of range
 
Usage:
 ps [options]
 
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
 
For more details see ps(1).
strings: '/proc//environ': No such file
/bin/columnstore-post-install: line 18: [: too many arguments
Populating the engine initial system catalog.
 
  Verifying        : MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el8.x86_64                                                                                                                                                                                1/1
 
Installed:
  MariaDB-columnstore-engine-10.6.7_3_6.2.3-1.el8.x86_64
 
Complete!

The offending code is here:

https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/develop-6/oam/install_scripts/columnstore-post-install.in#L15-L25



 Comments   
Comment by Ben Thompson (Inactive) [ 2022-04-21 ]

Removing old configuration stuff that was undocumented for S3 using env variables.

Comment by Roman [ 2022-05-31 ]

4 QA This bug happens when a /usr/bin/columnstore-post-install is run in a container so the quick test would be to install packages in any container. Previously the script fails and exists early leaving MCS in partially configured state, e.g. there are no udf functions installed in MDB(select * from mysql.func)

Comment by Daniel Lee (Inactive) [ 2022-06-01 ]

Build tested: 6.4.1-1 (Drone #4590)

Reproduced the reported issue in 6.2.4 and 6.3.1 using docker containers.

With the 6.4.1-1, I got:

[root@s2 rpms]# rpm -ivh MariaDB-columnstore-engine-10.6.8_4_6.3.1-1.el8.x86_64.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:MariaDB-columnstore-engine-10.6.8################################# [100%]
220601 16:07:06 mysqld_safe Logging to '/var/log/mariadb/columnstore/mariadb-error.log'.
grep: mysqld_safe: No such file or directory
220601 16:07:06 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
checking for engine columnstore...
columnstore exists
/sbin/ldconfig: Cannot lstat /lib64/libasm-0.185.so: No such file or directory
/sbin/ldconfig: Cannot lstat /lib64/libbfd-2.30-108.el8_5.1.so: No such file or directory
/sbin/ldconfig: Cannot lstat /lib64/libcap.so.2.26: No such file or directory
/sbin/ldconfig: Cannot lstat /lib64/libdw-0.185.so: No such file or directory
/sbin/ldconfig: Cannot lstat /lib64/libelf-0.185.so: No such file or directory
/sbin/ldconfig: Cannot lstat /lib64/libopcodes-2.30-108.el8_5.1.so: No such file or directory
/sbin/ldconfig: Cannot lstat /lib64/libseccomp.so.2.5.1: No such file or directory

toddstoffel Are the /sbin/ldconfig errors expected in docker containers? I did not see these error messages on VM installations.

Comment by Daniel Lee (Inactive) [ 2022-06-06 ]

Created MCOL-5120 to track the report issue.

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