Vertica error -could not get database metadata

Hello all,

 

I iam trying to install vPV and I am having the below error in pvhibernate.log. This is a fresh install . Any idea what could be the issue?

 

Nov 26 11:14:35 - ERROR - could not get database metadata
java.sql.SQLException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source)
at com.vertica.jdbc.SStatement.executeQuery(Unknown Source)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:69)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:62)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:170)
at com.hp.reporter.db.HibernateManager.updateSchema(Unknown Source)
at com.hp.reporter.db.HibernateManager.<init>(Unknown Source)
at com.hp.reporter.db.HibernateManager.getInstance(Unknown Source)
at com.hp.reporter.db.HibernateHelper.executeSQLListQuery(Unknown Source)
at com.hp.pm.core.po.DBUtil.getSQLResultUsingTemplateQuery(Unknown Source)
at com.hp.pm.core.po.DBUtil.getEventsList(Unknown Source)
at com.hp.pv.alerts.AlertAdapter.getLatestAlerts(Unknown Source)
at com.hp.pm.core.adapter.alert.AbstractAlertAdapter.getAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.loadAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.getJSONObject(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getLatestComponentData(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentCacheWithLock(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentData(Unknown Source)
at com.hp.pm.web.command.json.GetDashboardDataCommand.doAction(Unknown Source)
at com.hp.pm.web.command.ServiceExcecutor.execute(Unknown Source)
at com.hp.pm.web.URLRouter.routeURL(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL1(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL(Unknown Source)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:612)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
... 53 more
Nov 26 11:14:35 - ERROR - could not complete schema update
java.sql.SQLException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source)
at com.vertica.jdbc.SStatement.executeQuery(Unknown Source)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:69)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:62)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:170)
at com.hp.reporter.db.HibernateManager.updateSchema(Unknown Source)
at com.hp.reporter.db.HibernateManager.<init>(Unknown Source)
at com.hp.reporter.db.HibernateManager.getInstance(Unknown Source)
at com.hp.reporter.db.HibernateHelper.executeSQLListQuery(Unknown Source)
at com.hp.pm.core.po.DBUtil.getSQLResultUsingTemplateQuery(Unknown Source)
at com.hp.pm.core.po.DBUtil.getEventsList(Unknown Source)
at com.hp.pv.alerts.AlertAdapter.getLatestAlerts(Unknown Source)
at com.hp.pm.core.adapter.alert.AbstractAlertAdapter.getAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.loadAlerts(Unknown Source)
at com.hp.pm.core.dashboard.AlertsComponent.getJSONObject(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getLatestComponentData(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentCacheWithLock(Unknown Source)
at com.hp.pm.core.dashboard.CacheManager.getComponentData(Unknown Source)
at com.hp.pm.web.command.json.GetDashboardDataCommand.doAction(Unknown Source)
at com.hp.pm.web.command.ServiceExcecutor.execute(Unknown Source)
at com.hp.pm.web.URLRouter.routeURL(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL1(Unknown Source)
at com.hp.perf.web.URLRouter.routeURL(Unknown Source)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:612)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
... 53 more
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Node" does not exist
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Cluster" does not exist
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datastore" does not exist
Nov 26 11:14:35 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Enclosure" does not exist
Nov 26 11:14:36 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Capacity__DataCenter" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datacenter" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_Infrastructure__Node" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__NodeDSRelation" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__NodeDSRelation" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datastore" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Node" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Cluster" does not exist
Nov 26 11:14:37 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Virtualization__Datastore" does not exist
Nov 26 11:14:43 - ERROR - [Vertica][VJDBC](4566) ERROR: Relation "dml_inst_Infrastructure__Node" does not exist

 

Many thanks,

SGS

Parents
  • I suspect the table itself is not getting created. I can see below error during installation

     

    2015-11-26 11:10:41,123 INFO - Logfile for package HPPVCore is located at : /tmp/HPOvInstaller/HPPV_2.20.388/Package_rpm_HPPVCore_install.log
    2015-11-26 11:10:41,128 INFO - Checking existence of :/tmp/VpV/packages/HPPVCore-02.20.388.rpm
    Found :/tmp/VpV/packages/HPPVCore-02.20.388.rpm
    rpm command returned : 0
    warning: /tmp/VpV/packages/HPPVCore-02.20.388.rpm: Header V3 RSA/SHA1 Signature, key ID b564a643: NOKEY
    Preparing packages for installation...
    HPPVCore-2.20.388-1
    chown root /var/opt/OV/databases/pv
    chmod 777 /var/opt/OV/databases/pv
    su pv_vertica -c /opt/vertica/bin/adminTools -t create_db -s localhost -d pv -c /var/opt/OV/databases/pv/catalog -D /var/opt/OV/databases/pv/data
    Info: no password specified, using none
    Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
    Distributing changes to cluster.
    127.0.0.1 OK [vertica][(7, 1, 1)][000][x86_64]
    Creating database pv
    Starting bootstrap node v_pv_node0001 (127.0.0.1)
    Starting nodes:
    v_pv_node0001 (127.0.0.1)

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

    Node Status: v_pv_node0001: (INITIALIZING)
    Node Status: v_pv_node0001: (INITIALIZING)
    Node Status: v_pv_node0001: (UP)
    Database pv created successfully.
    CREATE TABLE
    CREATE TABLE
    CREATE TABLE
    CREATE TABLE
    OUTPUT
    --------
    1
    (1 row)

    OUTPUT
    --------
    1
    (1 row)

    CREATE TABLE
    CREATE TABLE
    CREATE TABLE
    CREATE TABLE
    CREATE TABLE
    CREATE TABLE
    vsql:/opt/OV/newconfig/DataDir/conf/PV/Model/DMLMetaMetaSchema:74: WARNING 4116: No super projections created for table public.Events.
    HINT: Default super projections will be automatically created with the next DML
    CREATE PROJECTION
    CREATE TABLE
    /var/tmp/rpm-tmp.TBnbDh: line 6574: pv: command not found
    INFO: Current vPV version is
    /var/tmp/rpm-tmp.TBnbDh: line 6576: [: ==: unary operator expected
    odbcinst: Driver installed. Usage count increased to 1.
    Target directory is /etc
    /var/tmp/rpm-tmp.TBnbDh: line 4818: [: too many arguments
    /var/tmp/rpm-tmp.TBnbDh: line 4823: [: too many arguments
    /var/tmp/rpm-tmp.TBnbDh: line 4828: [: too many arguments
    INTERNAL ERROR: Log variable OVCSL_LOG_APPLICATION is not set. Logging is disabled.
    Error:
    (xpl-81) Could not open '/opt/OV/newconfig/OVPM/smepack'.
    (RTL-2) No such file or directory
    Traceback (most recent call last):
    File "/opt/OV/lbin/PV/ChangeAlertSensitivity.py", line 44, in <module>
    CopyConfigFiles("medium")
    File "/opt/OV/lbin/PV/ChangeAlertSensitivity.py", line 11, in CopyConfigFiles
    for dirName in os.listdir("/opt/OV/newconfig/OVPM/smepack"):
    FileNotFoundError: [Errno 2] No such file or directory: '/opt/OV/newconfig/OVPM/smepack'

    Caught exception:
    (sec.core-76) Could not decrypt data. Incorrect padding.Completed installation
    Fixing RPM db. Leaving : HPPVCore warning: /tmp/VpV/packages/HPPVCore-02.20.388.rpm: Header V3 RSA/SHA1 Signature, key ID b564a643: NOKEY
    2.20.388
    Completed the HP OpenView Component Package Installation : 0

     

     

     

    System.txt

     

    <rolled=0>
    0: INF: Thu Nov 26 11:50:12 2015: ovcd (15547/140308701091584): (ctrl-212) ovbbccb has been started. PID: 15555
    0: INF: Thu Nov 26 11:50:12 2015: ovcd (15547/140308676364032): (sec.cm.client-50) Configuration setting CERTIFICATE_SERVER is not set. Certificate request cannot be sent.
    0: INF: Thu Nov 26 11:50:17 2015: ovcd (15547/140308057679616): (ctrl-212) pvcd has been started. PID: 15608
    0: INF: Thu Nov 26 11:50:18 2015: pvcd (15608/139877065549600): pvcd.pvc Server is started.
    0: INF: Thu Nov 26 11:50:31 2015: ovcd (15547/140308057679616): (ctrl-212) ovtomcatB has been started. PID: 16141

  • Verified Answer

    Sorted out the issue. 

    Issue-  vPV related database was not getting created. Vertica installation was successful. 

    Reason - Smepack was not extracted properly. (scripts.zip/sql.zip was not extracted to /opt/OV/newconfig/OVPM/smepack

    'unzip' utility should be a prerequisite for the OS.  After installing unzip, and following installation, sme pack was extracted successfully.

     

Reply
  • Verified Answer

    Sorted out the issue. 

    Issue-  vPV related database was not getting created. Vertica installation was successful. 

    Reason - Smepack was not extracted properly. (scripts.zip/sql.zip was not extracted to /opt/OV/newconfig/OVPM/smepack

    'unzip' utility should be a prerequisite for the OS.  After installing unzip, and following installation, sme pack was extracted successfully.

     

Children
No Data