The Vertica Database Forums

my virtual Environment:

hp1 <---------------> hp2
190 191


i had two troubles in my installation:

#####################################

first one:

Database with 1 or 2 hosts cannot be k-safe and it may lose data if it crashes

my two hosts disk utilization is under 60% , why it still gave me this message, but i stilled go on

################################

second :

*** Creating database: www ***
172.16.145.190 OK [vertica][(7, 1, 1)][000][x86_64]
172.16.145.191 OK [vertica][(7, 1, 1)][000][x86_64]
Checking full connectivity
Creating database www
Starting bootstrap node v_www_node0001 (172.16.145.190)
Starting nodes:
v_www_node0001 (172.16.145.190)

Starting Vertica on all nodes. Please wait, databases with large catalogs may take a while to initialize.

Node Status: v_www_node0001: (INITIALIZING)
Node Status: v_www_node0001: (INITIALIZING)
Node Status: v_www_node0001: (UP)
Creating database nodes
Creating node v_www_node0002 (host 172.16.145.191)
Generating new configuration information
Stopping bootstrap node
Starting all nodes
Starting nodes:
v_www_node0001 (172.16.145.190)
v_www_node0002 (172.16.145.191)
Error: the vertica process for the database is running on the following hosts:
172.16.145.190
This may be because the process has not completed previous shutdown activities. Please
wait and retry again.


Node Status: v_www_node0001: (DOWN) v_www_node0002: (DOWN)
Node Status: v_www_node0001: (DOWN) v_www_node0002: (DOWN)
Node Status: v_www_node0001: (DOWN) v_www_node0002: (DOWN)



@@@@@@@@@@@@@that the log gave me this: /opt/vertica/log/adminTools-dbadmin.log

Mar 22 11:49:48 [5904] Scp outbound: local_file: /home/dbadmin/www/v_www_node0001_catalog/spread.conf, remote_file: dbadmin@172.16.145.191:/home/dbadmin/www/v_www_node0002_catalog/spread.conf
Mar 22 11:49:49 [5904] Starting nodes:
Mar 22 11:49:49 [5904] v_www_node0001 (172.16.145.190)
Mar 22 11:49:49 [5904] v_www_node0002 (172.16.145.191)
Mar 22 11:49:49 [5904] KSafety: 0 Total hosts:2 Down hosts:[]
Mar 22 11:49:49 [5904] <BashAdapter: dbadmin@172.16.145.190>: ['/opt/vertica/bin/vertica -V']
Mar 22 11:49:49 [5904] <PexpectAdapter: dbadmin@172.16.145.191>: /opt/vertica/bin/vertica -V
Mar 22 11:49:49 [5904] <BashAdapter: dbadmin@172.16.145.190>: (rc=0) ['Vertica Analytic Database v7.1.1-0', "vertica(v7.1.1-0) built by release@build2.verticacorp.com from releases/VER_7_1_RELEASE_BUILD_1_0_20141016@148158 on 'Thu Oct 16 15:55:09 America/New_York 2014' $BuildId$"]
Mar 22 11:49:49 [5904] <PexpectAdapter: dbadmin@172.16.145.191>: (rc=0) ['Vertica Analytic Database v7.1.1-0', "vertica(v7.1.1-0) built by release@build2.verticacorp.com from releases/VER_7_1_RELEASE_BUILD_1_0_20141016@148158 on 'Thu Oct 16 15:55:09 America/New_York 2014' $BuildId$"]
Mar 22 11:49:49 [5904] <BashAdapter: dbadmin@172.16.145.190>: ['/opt/vertica/bin/vertica --status -D /home/dbadmin/www/v_www_node0001_catalog || ps -C "vertica" -o args | grep -F "/home/dbadmin/www/v_www_node0001_catalog"']
Mar 22 11:49:49 [5904] <PexpectAdapter: dbadmin@172.16.145.191>: /opt/vertica/bin/vertica --status -D /home/dbadmin/www/v_www_node0002_catalog || ps -C "vertica" -o args | grep -F "/home/dbadmin/www/v_www_node0002_catalog"
Mar 22 11:49:49 [5904] <BashAdapter: dbadmin@172.16.145.190>: (rc=0) ['vertica process is running (PID 6194)']
Mar 22 11:49:49 [5904] <PexpectAdapter: dbadmin@172.16.145.191>: (rc=1) ['vertica process is not running']
Mar 22 11:49:49 [5904] [SSH.StartDatabaseNodes] Vertica running on 172.16.145.190: ['vertica process is running (PID 6194)']
Mar 22 11:49:49 [5904] Error: the vertica process for the database is running on the following hosts:
172.16.145.190
This may be because the process has not completed previous shutdown activities. Please
wait and retry again.


Mar 22 11:49:49 [5904] [SSH.checkDatabaseState] dbName=www, port=5433, nodemap={'v_www_node0002': '172.16.145.191', 'v_www_node0001': '172.16.145.190'}
Mar 22 11:49:49 [5904] [SSH.checkDatabaseState] vsql_cmd = /opt/vertica/bin/vsql --no-vsqlrc -n -p 5433 -h '172.16.145.191' www
Mar 22 11:49:49 [5904] [SSH.checkDatabaseState] vsql return code = 2
Mar 22 11:49:49 [5904] [SSH.checkDatabaseState] vsql_cmd = /opt/vertica/bin/vsql --no-vsqlrc -n -p 5433 -h '172.16.145.190' www
Mar 22 11:49:49 [5904] [SSH.checkDatabaseState] vsql return code = 2
Mar 22 11:49:49 [5904] {"type":"NODEHOST", "state":"DOWN", "host":"172.16.145.190", "node":"v_www_node0001", "dbname":"www", "msg":"", "maxSteps":"1", "currStep":"1"}
Mar 22 11:49:49 [5904] {"type":"NODEHOST", "state":"DOWN", "host":"172.16.145.191", "node":"v_www_node0002", "dbname":"www", "msg":"", "maxSteps":"1", "currStep":"1"}
Mar 22 11:49:49 [5904] [SSH.checkForRunning] nodeStatusString: Node Status: v_www_node0001: (DOWN) v_www_node0002: (DOWN)



@@@@@@@@@@@@@@@@@@@
PID 6194 ???

[root@localhost ~]# ps aux | grep 6194
root 8948 0.0 0.0 103244 856 pts/1 S+ 11:20 0:00 grep 6194

[root@localhost ~]# ls /proc/6194
ls: cannot access /proc/6194: No such file or directory

no such process , why ??? was the previous process haven't enough time to close his vertica initialization process and the next step was comming up so it think vertica process was staill running????

so the process haven't more try to start vertica process but try to connect to port 5433 so give me this message ???


how can i solve this porblem ???? please help me ????? ...... else i will cry .......~~~~(>_<)~~~~

Hi,

Did you try running the ps command to see if there are any Vertica processes running on each server prior to starting the db?

ps -aux | grep -i vertica

If there are, first try using the admintools to kill the processes on the hosts:

admintools -t kill_host -s 172.16.145.190,172.16.145.191.

If that doesn't work, you can use kill -9 to end terminate the processes.