[MCOL-1525] Non-root Install - core dumps not working Created: 2018-07-03  Updated: 2023-10-26  Resolved: 2018-07-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.1.5
Fix Version/s: 1.1.6

Type: Bug Priority: Minor
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-15

 Description   

There are 2 issues causing core dumps to not be generated on non-root installs after the EnableCoreFile configuration parmataer is set to 'y'.

1. Bug in the columnstore service script, these lines need to be removed from the start() function
SUDO=
if [ "$user" != "root" ]; then
SUDO="$SUDO"
fi

2. The core file directory needs to be writeable by all users, so it needs permission command
of:

chmod 777 /var/log/mariadb/columnstore/corefiles

 Comments   
Comment by David Hill (Inactive) [ 2018-07-05 ]

and in the columnstore script, remove $SUDO from unlimit command

Comment by David Hill (Inactive) [ 2018-07-05 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/513

Comment by David Hill (Inactive) [ 2018-07-05 ]

how to test. do a non-root install and bring up the system.

1. mcsadmin shutdownsystem y
2. edit Columnstore.xml - CoreFilesFlag = 'y'
3. mcsadmin startsystem
4. cd ...log/corefiles
5. generate a corefile

  1. ps -ef | grep Server
  2. kill -6 XXXX
    6. check for corefile in directory.

Here is an example used in testing

[mariadb-user@ip-172-31-39-209 bin]$ log
[mariadb-user@ip-172-31-39-209 columnstore]$ ll
total 244
rw-rr- 1 mariadb-user mariadb-user 0 Jul 5 15:32 activeAlarms
rw-rr- 1 mariadb-user mariadb-user 5512 Jul 5 15:32 alarm.log
drwxrwxr-x. 2 root root 4096 Jul 5 14:08 archive
drwxrwxrwx. 2 root root 6 Jul 5 15:09 corefiles
rw------ 1 root root 600 Jul 5 15:23 crit.log
rw------ 1 root root 139607 Jul 5 15:32 debug.log
rw------ 1 root root 3926 Jul 5 15:32 err.log
rw------ 1 root root 12217 Jul 5 15:32 info.log
rw-rr- 1 mariadb-user mariadb-user 78 Jul 5 15:32 load_brm.log1
rw-rw-r- 1 mariadb-user mariadb-user 360 Jul 5 15:30 mcsadmin.log
rw-rr- 1 mariadb-user mariadb-user 191 Jul 5 15:32 reset_locks.log1
rw-rr- 1 mariadb-user mariadb-user 81 Jul 5 15:30 save_brm.log1
drwxrwxr-x. 2 root root 6 Jun 19 15:58 trace
rw------ 1 root root 3926 Jul 5 15:32 warning.log
[mariadb-user@ip-172-31-39-209 columnstore]$ ll corefiles/
total 0
[mariadb-user@ip-172-31-39-209 columnstore]$ ps -ef | grep Server
mariadb+ 8502 7948 0 15:32 pts/0 00:00:00 /home/mariadb-user/mariadb/columnstore/bin/ServerMonitor
mariadb+ 8993 31204 0 15:33 pts/0 00:00:00 grep --color=auto Server
[mariadb-user@ip-172-31-39-209 columnstore]$ kill -6 8502
[mariadb-user@ip-172-31-39-209 columnstore]$ ll corefiles/
total 8280
rw------ 1 mariadb-user mariadb-user 29663232 Jul 5 15:33 core.ServerMonitor.8502

Comment by Daniel Lee (Inactive) [ 2018-07-06 ]

Build verified: 1.1.6-1 source

/root/columnstore/mariadb-columnstore-server
commit 1741c7e7d522d1245ec9c1e4c7c7474574f09bd2
Merge: 2adc4b5 6abef48
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Tue Jun 19 09:51:48 2018 -0500

Merge pull request #113 from mariadb-corporation/davidhilldallas-patch-3

update readme

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit a16d1b068d49d272c7c24bc9dcde680fc79b1668
Merge: 22d7647 58dcdb3
Author: David.Hall <david.hall@mariadb.com>
Date: Thu Jul 5 11:40:46 2018 -0500

Merge pull request #513 from mariadb-corporation/MCOL-1525

MCOL-1525 - fix nonroot corefile generating issue

Verify mentioned test case.

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