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>
Thanks to Benny Zlotnik for the heads up and fix https://lists.ovirt.org/archives/list/devel@ovirt.org/message/JVWIWPAZIUZMQT2OKJVOZMXZGRYJX234/
Severity is missing...