Bug 1581503
| Summary: | ovirt-engine won't start on Fedora 28, PostgreSQL JDBC drivers >= 42.2.2 are required to use PostgreSQL 10 | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Greg Sheremeta <gshereme> |
| Component: | Database.Core | Assignee: | Eli Mesika <emesika> |
| Status: | CLOSED UPSTREAM | QA Contact: | Lukas Svaty <lsvaty> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.2.3 | CC: | bugs, bzlotnik, gshereme, lsvaty, mperina, sbonazzo |
| Target Milestone: | ovirt-4.3.0 | Flags: | rule-engine:
ovirt-4.3+
|
| Target Release: | 4.3.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | ovirt-engine-4.3.0_alpha | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-08-16 08:05:33 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Thanks to Benny Zlotnik for the heads up and fix https://lists.ovirt.org/archives/list/devel@ovirt.org/message/JVWIWPAZIUZMQT2OKJVOZMXZGRYJX234/ Severity is missing... |
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>