Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
6.4.7- CS only, 22.08.8, 23.02.4
-
None
-
None
-
VirtualBox v7.0.8
openSUSE Thumbleweed: Linux Thumbleweed 6.4.2-1-default #1 SMP PREEMPT_DYNAMIC Mon Jul 10 10:03:25 UTC 2023 (b97b894) x86_64 x86_64 x86_64 GNU/Linux
MariaDB ColumnStore v10.11.4_6.4.7 as single node installation.
-
2023-8
Description
After installation or restart of service is broken permissions for /dev/shm directory.
- This is state before install:
Thumbleweed:~ # l /dev/shm/total 1052drwxrwxrwt 2 root root 80 Jul 18 13:06 ./drwxr-xr-x 18 root root 4120 Jul 18 13:06 ../-rw------- 1 postgres postgres 26976 Jul 18 13:06 PostgreSQL.3071437720-rw------- 1 postgres postgres 1048576 Jul 18 13:06 PostgreSQL.3800041244 - This is state after install:
Thumbleweed:~ # l /dev/shm/total 8532drwxrwxrwx 2 root root 320 Jul 18 13:09 ./drwxr-xr-x 18 root root 4120 Jul 18 13:06 ../-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00010000-rw-rw-rw- 1 mysql mysql 5000020 Jul 18 13:09 MCS-shm-00010002-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00020000-rw-rw-rw- 1 mysql mysql 96000 Jul 18 13:09 MCS-shm-00020001-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00030000-rw-rw-rw- 1 mysql mysql 800 Jul 18 13:09 MCS-shm-00030001-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00040000-rw-rw-rw- 1 mysql mysql 2500020 Jul 18 13:09 MCS-shm-00040002-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00050000-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00060000-rw-rw-rw- 1 mysql mysql 16777216 Jul 18 13:09 MCS-shm-00060001-rw-rw-rw- 1 mysql mysql 72 Jul 18 13:09 MCS-shm-ff000000-rw------- 1 postgres postgres 26976 Jul 18 13:06 PostgreSQL.3071437720-rw------- 1 postgres postgres 1048576 Jul 18 13:06 PostgreSQL.3800041244 - This is state after restart service mariadb-columnstore:
Thumbleweed:~ # service mariadb-columnstore restartThumbleweed:~ # l /dev/shm/total 8536drwxrwxrwx 2 root root 340 Jul 18 13:09 ./drwxr-xr-x 18 root root 4120 Jul 18 13:06 ../-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00010000-rw-rw-rw- 1 mysql mysql 5000020 Jul 18 13:09 MCS-shm-00010003-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00020000-rw-rw-rw- 1 mysql mysql 96000 Jul 18 13:09 MCS-shm-00020001-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00030000-rw-rw-rw- 1 mysql mysql 800 Jul 18 13:09 MCS-shm-00030001-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00040000-rw-rw-rw- 1 mysql mysql 2500020 Jul 18 13:09 MCS-shm-00040004-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00050000-rw-rw-rw- 1 mysql mysql 112 Jul 18 13:09 MCS-shm-00060000-rw-rw-rw- 1 mysql mysql 16777216 Jul 18 13:09 MCS-shm-00060001-rw-rw-rw- 1 mysql mysql 40 Jul 18 13:09 MCS-shm-f7000000-rw-rw-rw- 1 mysql mysql 72 Jul 18 13:09 MCS-shm-ff000000-rw------- 1 mysql mysql 26976 Jul 18 13:06 PostgreSQL.3071437720-rw------- 1 mysql mysql 1048576 Jul 18 13:06 PostgreSQL.3800041244
I found that permissions change this Python script: /usr/bin/mcs-loadbrm.py.
So as workaround I locally modify this script and remove set permissions for all files in script (lines).