Database Creation fails

Moderator: NorbertKrupa

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Database Creation fails

Post by id10t » Sun Oct 06, 2013 8:08 pm

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?

oppelo
Newbie
Newbie
Posts: 13
Joined: Thu Apr 18, 2013 8:16 pm

Re: Database Creation fails

Post by oppelo » Sun Oct 06, 2013 8:20 pm

Host OS is Windows

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Database Creation fails

Post by id10t » Sun Oct 06, 2013 8:54 pm

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.

oppelo
Newbie
Newbie
Posts: 13
Joined: Thu Apr 18, 2013 8:16 pm

Re: Database Creation fails

Post by oppelo » Sun Oct 06, 2013 9:56 pm

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 ?

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Database Creation fails

Post by id10t » Mon Oct 07, 2013 12:23 am

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.

oppelo
Newbie
Newbie
Posts: 13
Joined: Thu Apr 18, 2013 8:16 pm

Re: Database Creation fails

Post by oppelo » Mon Oct 07, 2013 12:37 am

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.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Database Creation fails

Post by id10t » Mon Oct 07, 2013 1:06 am

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 73851 times
vm5.png
edit mtab: look at line with ".host:/". Do you see `uid`, `gid` and `owner` definition?
vm5.png (62.9 KiB) Viewed 73851 times
vm6.png
remount and chek :) everything now is belong to dbadmin.
vm6.png (50.71 KiB) Viewed 73851 times

Post Reply

Return to “Vertica Installation”