Big news! The community will be moving to a new platform April 21. Read more.
Big news! The community will be moving to a new platform April 21. Read more.
Vice Admiral Vice Admiral
Vice Admiral
783 views

/var/opt/OV/log/pvhibernate.log => Relation "pg_class" does not exist

This is showing up more than a few times.  Anyone know what this means and make it go away ?

 

May 14 14:48:03 - 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.reporter.collector.CollectionStatusTask.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4566) ERROR: Relation "pg_class" does not exist
... 24 more

Labels (1)
Tags (1)
0 Likes
2 Replies
Captain Captain
Captain

Hi,

 

We have vPV installed on RHEL 6.2 and we're facing this same problem.

Did you get to fix this issue?

 

Thanks and best regards,

 

Paulo Ferreira

0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Hello,

 

I guess this error is not resulting in any funcationality impact and you can safely ignore the exception in log file.

 

Currently there is no support for Vertica dialect from Hiberanate.  This request is still in open state.

Using postgresql dialect works for Vertica as well with exception logged in log file. 

https://hibernate.atlassian.net/browse/HHH-9560

 

Note: Postgres dialet is compatible with Vertica.   Dialect is a Hibernate feature that generate the appropriate SQL for a chosesn database for Java applications.  Since vPV uses Vertica DB resulting exception in log file.

 

Regards,

Udupa

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.