Page 3 of 4

Re: Database Creation fails

Posted: Sun Oct 06, 2013 8:08 pm
by id10t
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?

Re: Database Creation fails

Posted: Sun Oct 06, 2013 8:20 pm
by oppelo
Host OS is Windows

Re: Database Creation fails

Posted: Sun Oct 06, 2013 8:54 pm
by id10t
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.

Re: Database Creation fails

Posted: Sun Oct 06, 2013 9:56 pm
by oppelo
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

Posted: Mon Oct 07, 2013 12:23 am
by id10t
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.

Re: Database Creation fails

Posted: Mon Oct 07, 2013 12:37 am
by oppelo
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.

Re: Database Creation fails

Posted: Mon Oct 07, 2013 1:06 am
by id10t
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:

Code: Select all

.host:/  /mnt/hgfs  vmhgfs  rw,ttl=1 0 0
to

Code: Select all

.host:/  /mnt/hgfs  vmhgfs  rw,uid=500,gid=500,owner=500,ttl=1 0 0
(dont do COPY/PASTE, edit it manually!!!)

2. unmount NFS

Code: Select all

sudo umount /mnt/hgfs
3. mount NFS

Code: Select all

sudo mount /mnt/hgfs
4. Profit!!! (now you able to create a database on HostOS)
vm1.png
My props are similar to yours: dbadmin(uid=500), /mnt/hgfs(uid=1000), i.e. I also can't create a db on HostOS
vm1.png (46.61 KiB) Viewed 73905 times
vm5.png
edit mtab: look at line with ".host:/". Do you see `uid`, `gid` and `owner` definition?
vm5.png (62.9 KiB) Viewed 73905 times
vm6.png
remount and chek :) everything now is belong to dbadmin.
vm6.png (50.71 KiB) Viewed 73905 times