Permission error while adding new Storage Location

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Fri Dec 11, 2015 6:42 pm

Permission error while adding new Storage Location

Post by jainprithviraj » Fri Dec 11, 2015 7:04 pm

I am facing problem adding a new Storage Location.

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

User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: Permission error while adding new Storage Location

Post by JimKnicely » Tue Dec 15, 2015 1:11 am

Not to state the obvious, but are you sure that the directory /mnt/disk2/dbadmin is completely empty? i.e. no files or sub-directories?
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”