Permission error while adding new Storage Location
Posted: Fri Dec 11, 2015 7:04 pm
I am facing problem adding a new Storage Location.
Scenario:
Mutiple disks mounted using root user.
/dev/sdd1 on /mnt/disk2 type ext4 (rw)
/dev/sde1 on /mnt/disk3 type ext4 (rw)
Each disk has a directory created and owned by Vertica admin user (dbadmin).
ls -ltr /mnt/disk2/ | grep dbadmin
drwxrwxrwx 3 dbadmin verticadba 4096 Dec 11 22:29 dbadmin
Adding this path as Storage location, throws permisson error.
dbadmin=> CREATE LOCATION '/mnt/disk2/dbadmin';
ERROR 2810: Could not add location [/mnt/disk2/dbadmin]: Directory not empty
HINT: Please make sure that the directories in the path have sufficient permissions for the vertica process and if the directory denoted by the path exists make sure it is an empty directory
Scenario:
Mutiple disks mounted using root user.
/dev/sdd1 on /mnt/disk2 type ext4 (rw)
/dev/sde1 on /mnt/disk3 type ext4 (rw)
Each disk has a directory created and owned by Vertica admin user (dbadmin).
ls -ltr /mnt/disk2/ | grep dbadmin
drwxrwxrwx 3 dbadmin verticadba 4096 Dec 11 22:29 dbadmin
Adding this path as Storage location, throws permisson error.
dbadmin=> CREATE LOCATION '/mnt/disk2/dbadmin';
ERROR 2810: Could not add location [/mnt/disk2/dbadmin]: Directory not empty
HINT: Please make sure that the directories in the path have sufficient permissions for the vertica process and if the directory denoted by the path exists make sure it is an empty directory