Hi!
UID/GID of root is 0 and he is owner of '/mnt/hgfs/VerticaDBs/', it's bad, my trick will not work. Does Host OS is windows or Linux?
Database Creation fails
Moderator: NorbertKrupa
Re: Database Creation fails
Host OS is Windows
Re: Database Creation fails
Hi!
>> Host OS is Windows.
You can't setup a storage for data on Host OS, because Vertica requirements for file system is EXT3 or EXT4, while Windows uses in NTFS.
NTFS has different permissions mechanism than Linux, but because its NTFS you can't change UID/GID for location to UID/GID of dbadmin.
As I pointed: a owner of catalog and data must be dbadmin.
>> Host OS is Windows.
You can't setup a storage for data on Host OS, because Vertica requirements for file system is EXT3 or EXT4, while Windows uses in NTFS.
NTFS has different permissions mechanism than Linux, but because its NTFS you can't change UID/GID for location to UID/GID of dbadmin.
As I pointed: a owner of catalog and data must be dbadmin.
Re: Database Creation fails
OK. I am using an EXTERNAL DRIVE exclusively for this. Is there a way to FORMAT the EXT DRIVE in LINUX format and use it for the DATA ?
Re: Database Creation fails
Hi!
I'm testing something, so follow to the thread to be updated. Looks like I was wrong, and its possible to install on NTFS.
I'm testing something, so follow to the thread to be updated. Looks like I was wrong, and its possible to install on NTFS.
Re: Database Creation fails
Thank you. I did ADD_LOCATION for both DATA and TEMP. Then I started loading data. I was able to load 1 table successfully. But I got the following error.
ERROR 5123: Unable to access temporary file block
HINT: Check for file system errors
ERROR 5123: Unable to access temporary file block
HINT: Check for file system errors
ERROR 3890: LSort temp file 16 read failed: No such file or directory
I have files in the DATA directory on my EXTERNAL DRIVE for 1 table.
Hope this gives you some clue.
ERROR 5123: Unable to access temporary file block
HINT: Check for file system errors
ERROR 5123: Unable to access temporary file block
HINT: Check for file system errors
ERROR 3890: LSort temp file 16 read failed: No such file or directory
I have files in the DATA directory on my EXTERNAL DRIVE for 1 table.
Hope this gives you some clue.
Re: Database Creation fails
Hi!
All on GuestOS (aka Vertica host):
1.edit as root file /etc/mtab: set uid,gid and owner for NFS
Change in mtab line:
to
(dont do COPY/PASTE, edit it manually!!!)
2. unmount NFS
3. mount NFS
4. Profit!!! (now you able to create a database on HostOS)
All on GuestOS (aka Vertica host):
1.edit as root file /etc/mtab: set uid,gid and owner for NFS
Change in mtab line:
Code: Select all
.host:/ /mnt/hgfs vmhgfs rw,ttl=1 0 0
Code: Select all
.host:/ /mnt/hgfs vmhgfs rw,uid=500,gid=500,owner=500,ttl=1 0 0
2. unmount NFS
Code: Select all
sudo umount /mnt/hgfs
Code: Select all
sudo mount /mnt/hgfs