The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
5365: User available location ["string"] does not exist on node ["string"]
Navin_C
Vertica Customer ✭
Hello All,
I cam across this error while trying to add and grant storage locations to a new user.
Basically my requirement is loading data from files.
The storage location where all my files reside are is /mnt/data/
Now , I am not much aware of this works, but I thinks its shared NFS.
df -h
Filesystem Size Used Avail Use% Mounted on
xxx.xxx.xxx.xx:/data/fake_dsm xxT xxT xxT 61% /mnt/data
This is how the location looks. Now I have sub directories under /mnt/data/
If I understand correctly for a new user to load data he needs to have a storage location added from where the data is going to be loaded(location of flat files) and then granted the access to this new user.
I did the same
SELECT ADD_LOCATION('/mnt/data/','xxxxxx','USER');
It was added successfully
GRANT ALL ON LOCATION '/mnt/data/' on xxxxxxto etluser;
This gives me error
ROLLBACK 5365: User available location ["/mnt/data/"] does not exist on node ["xxxxxx"]
I checked in the storage_locations table and it shows the newly added location.
What might be causing this error.
I cam across this error while trying to add and grant storage locations to a new user.
Basically my requirement is loading data from files.
The storage location where all my files reside are is /mnt/data/
Now , I am not much aware of this works, but I thinks its shared NFS.
df -h
Filesystem Size Used Avail Use% Mounted on
xxx.xxx.xxx.xx:/data/fake_dsm xxT xxT xxT 61% /mnt/data
This is how the location looks. Now I have sub directories under /mnt/data/
If I understand correctly for a new user to load data he needs to have a storage location added from where the data is going to be loaded(location of flat files) and then granted the access to this new user.
I did the same
SELECT ADD_LOCATION('/mnt/data/','xxxxxx','USER');
It was added successfully
GRANT ALL ON LOCATION '/mnt/data/' on xxxxxxto etluser;
This gives me error
ROLLBACK 5365: User available location ["/mnt/data/"] does not exist on node ["xxxxxx"]
I checked in the storage_locations table and it shows the newly added location.
What might be causing this error.
0
Comments
Try GRANT ALL ON LOCATION '/mnt/data' on xxxxxxto etluser; (remove the last slash)
It should work ok.
The directory is added without any ending slash