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 » Sat Oct 05, 2013 5:36 pm

Hi!


The error (adminTools-dbadmin.log):

Code: Select all

Data directory [/mnt/hgfs/VDBs/TestDB/v_testdb_node0001_catalog] has wrong ownership
Exiting process ( exit(1) ).10/05/13 10:11:41 SP_connect: DEBUG: Auth list is: NULL 
Who is owner of catalog?

Code: Select all

ls -ld /mnt/hgfs/VDBs/TestDB/v_testdb_node0001_catalog
(should be something like follow:

Code: Select all

drwx------ 9 dbadmin dbadmin 4096 Oct  5 12:02 /mnt/hgfs/VDBs/TestDB/v_testdb_node0001_catalog
)

This command should resolve this problem:

Code: Select all

sudo chown -R dbadmin:dbadmin /mnt/hgfs/VDBs/TestDB
--- Daniel

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

Re: Database Creation fails

Post by oppelo » Sat Oct 05, 2013 6:10 pm

I will try this. But the issue is I start creating the database and I can see the directory and files being created. Then since it fails they get deleted. Can I create the database on /home/dab admin/VDBs directory and the move the directory to my external drive and change permissions. Do you think this will work ?

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

Re: Database Creation fails

Post by id10t » Sat Oct 05, 2013 6:40 pm

Hi!

Something like this you can do: https://my.vertica.com/docs/6.1.x/HTML/ ... #12383.htm
1. Install Vertica
2. Add a new location for catalog or/and data or/and temp
3. Optionally drop old location for catalog/data/temp

The problem that mount point is - shared folder on HOST OS. I don't know If WMVare allows to change an owner (catalog and data must ownership of dbadmin )

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

Re: Database Creation fails

Post by id10t » Sat Oct 05, 2013 9:54 pm

Hi!

I found a trick.

1. Can you post output of command 'id' from a Guest OS (vm, where Vertica is installed)?
Example:

Code: Select all

daniel@synapse:~$ id
uid=1000(daniel) gid=1000(daniel) groups=1000(daniel),4(adm),24(cdrom),27(sudo),30(dip),46(plugdev),107(lpadmin),124(sambashare),1001(verticadba)
2. Can you post output of next command(from Guesr OS)?:

Code: Select all

ls -ld /mnt/hgfs/VDBs

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

Re: Database Creation fails

Post by oppelo » Sun Oct 06, 2013 5:41 pm

Thank you for your response. This approach worked, however I could not drop the location on my vm. I was able to add a location on my external drive and start loading. I loaded about 5 out of 14 tables and then it errors out trying to load to the VMware location for out of space. I am not sure how I can make the data location on my VMware inactive.

Again thank you for all the support. And help.

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

Re: Database Creation fails

Post by oppelo » Sun Oct 06, 2013 5:43 pm

I did not see your recent post. I am not home now and as soon as I go home I will send it out .

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:03 pm

Here are the 2 commands and their results.

[dbadmin@vertica ~]$ id
uid=500(dbadmin) gid=500(dbadmin) groups=10(wheel),500(dbadmin),501(verticadba)

[dbadmin@vertica ~]$ ls -ld /mnt/hgfs/VerticaDBs/
drwxrwxrwx 1 root root 0 Oct 5 16:26 /mnt/hgfs/VerticaDBs/

Post Reply

Return to “Vertica Installation”