Bug 1581503 - ovirt-engine won't start on Fedora 28, PostgreSQL JDBC drivers >= 42.2.2 are required to use PostgreSQL 10
Summary: ovirt-engine won't start on Fedora 28, PostgreSQL JDBC drivers >= 42.2.2 are ...
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Database.Core
Version: 4.2.3
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ovirt-4.3.0
: 4.3.0
Assignee: Eli Mesika
QA Contact: Lukas Svaty
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-05-23 00:03 UTC by Greg Sheremeta
Modified: 2018-11-26 16:12 UTC (History)
6 users (show)

Fixed In Version: ovirt-engine-4.3.0_alpha
Clone Of:
Environment:
Last Closed: 2018-08-16 08:05:33 UTC
oVirt Team: Infra
Embargoed:
rule-engine: ovirt-4.3+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1459502 0 high CLOSED oVirt can not upgrade JDBC driver due to a postgres-jdbc driver regression issue 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 1583944 0 unspecified CLOSED postgresql-jdbc 9.2 is not compatible with postgresql 10 2021-02-22 00:41:40 UTC
oVirt gerrit 91847 0 master MERGED core: Bump PostgreSQL JDBC drivers to 42.2.2 2018-06-03 18:52:31 UTC

Internal Links: 1459502 1583944

Description Greg Sheremeta 2018-05-23 00:03:07 UTC
Description of problem:
I installed a fresh f28.
ovirt-engine won't start:

Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from  gettagsbyparent_id()]; nested exception is org.postgresql.util.PSQLException: ERROR: function gettagsbyparent_id() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 16
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
<snip>
Caused by: org.postgresql.util.PSQLException: ERROR: function gettagsbyparent_id() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 16


Version-Release number of selected component (if applicable):
4.3 master

How reproducible:
always

Steps to Reproduce:
1. install fedora 28
2. install ovirt-engine
3. start ovirt-engine

Actual results:
engine does not start

Expected results:
engine works

Additional info:

This works:

diff --git a/pom.xml b/pom.xml
index 902e76d8633..c1ced0c858c 100644
--- a/pom.xml
+++ b/pom.xml
@@ -51,7 +51,7 @@
     <commons-lang.version>2.6</commons-lang.version>
     <commons-compress.version>1.5</commons-compress.version>
     <quartz.version>2.1.2</quartz.version>
-    <postgres.jdbc.version>9.2-1002-jdbc4</postgres.jdbc.version>
+    <postgres.jdbc.version>42.2.2</postgres.jdbc.version>
     <javax.transaction>1.1</javax.transaction>
     <javax.activation.version>1.1</javax.activation.version>
     <xmlrpc-client.version>3.1.3</xmlrpc-client.version>

Comment 1 Greg Sheremeta 2018-05-23 00:05:36 UTC
Thanks to Benny Zlotnik for the heads up and fix

https://lists.ovirt.org/archives/list/devel@ovirt.org/message/JVWIWPAZIUZMQT2OKJVOZMXZGRYJX234/

Comment 2 Yaniv Kaul 2018-05-23 06:49:37 UTC
Severity is missing...


Note You need to log in before you can comment on or make changes to this bug.