Unable to start database or create a new database

Hi!

verticad - its just a daemon not a dbms.

use in adminTools to start a dbms.

https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/OEMCookbook/Packaging/StartingDB.htm

https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/AdministratorsGuide/OperatingTheDatabase/StartingTheDatabase.htm

Hi sKwa !

I know verticad is not the dbms. And I also understand how to start the database inside adminTools  or by  /opt/vertica/bin/admintools --tool start_db [ options ]

The problem I'm facing is the application itself is not coming up. vertica has to be running to start any database, right. So I'm unable to start vertica itself.

just as a try with the shell command to start a database, I tried 

/opt/vertica/bin/admintools --tool start_db -d mydatabase -p passwd 

and I got the error:

Unable to read database catalogs - cannot start database.
Database mydatabase did not start successfully.

The main problem is here:-

$ /etc/init.d/verticad start
   Vertica: Password:
   start OK for users: dbadmin

$ ps -ef | grep vertica

$ dbadmin  13161 16990  0 18:19 pts/0    00:00:00 grep vertica

The vertica service/ process itself is not starting.

Hi, 

Did you alter anything in your Linuc limits.conf file ?

Is the dbadmin user configurated with unlimited resources at the OS level ?

 try to run the following:

/opt/vertica/bin/admintools --tool start_db -d mydatabase -p passwd -f

If not try to run the following:

echo -e "listdetails Site" |/opt/vertica/bin/vertica -D /path to the/catalog/dbname/v_dbname_nodename_catalog/ -E'batch'

 post the output here 

I got like as follows 

vertica@lnxapp103:/home> echo -e "listdetails Site" |/opt/vertica/bin/vertica -D /apps/vertica/catalog/PHIDB/v_phidb_node0001_catalog/  -E'batch'

/opt/vertica/bin/vertica: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by /opt/vertica/bin/vertica)

The background is like as follows .

we upgraded the the DB from 7.0 to 7.2 directly .Upgrade completed successfully .But not able to start the database using admintools .

vertica@lnxapp103:/apps/vertica/catalog/PHIDB/v_phidb_node0001_catalog> /opt/vertica/bin/admintools --tool start_db -d PHIDB -p BDVh3STe

Unable to read database catalogs - cannot start database.

Database PHIDB did not start successfully

vertica@lnxapp103:/apps/vertica/catalog/PHIDB/v_phidb_node0001_catalog> cd /home/

vertica@lnxapp103:/home> pwd

/home

vertica@lnxapp103:/home> echo -e "listdetails Site" |/opt/vertica/bin/vertica -D /apps/vertica/catalog/PHIDB/v_phidb_node0001_catalog/  -E'batch'

/opt/vertica/bin/vertica: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by /opt/vertica/bin/vertica)

Please advise is this problem with direct upgrade from 7.0 to 7.2 ? is there is any solution on this?

Thanks

Renjith Alex

DUPLICATE POST !  

I think you are missing gcc ! 

Also the upgrade path clearly states that is from 7.0 --> 7.1 --> 7.2 , you might of missed some libs in the process.

Install gcc, this will also install the libstdc++.so.6.

After this try to start the database.

 Also make sure all path variables are avaialbe and set.