I had the same issue on a fresh fedora 28 install. s/9.2-1002-jdbc4/42.2.2/ fixes it.
I opened https://bugzilla.redhat.com/show_bug.cgi?id=1581503 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> 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 Greg On Sun, May 13, 2018 at 5:51 AM, Eli Mesika <[email protected]> wrote: > > > On Sun, May 13, 2018 at 12:09 PM, Benny Zlotnik <[email protected]> > wrote: > >> 9.2-1002-jdbc4 >> >> It does not look like the same issue >> > > Can you please send to me the details of the machine in order to > investigate? > > > > >> >> On Sun, May 13, 2018 at 11:46 AM, Eli Mesika <[email protected]> wrote: >> >>> >>> >>> On Wed, May 9, 2018 at 11:12 AM, Sandro Bonazzola <[email protected]> >>> wrote: >>> >>>> >>>> >>>> 2018-05-09 10:04 GMT+02:00 Benny Zlotnik <[email protected]>: >>>> >>>>> I've had an issue[1] running engine, it looks like it's related to >>>>> Fedora 28 coming with postgresql 10. >>>>> I managed to workaround it by upgrading locally the jdbc driver to the >>>>> latest 42.2.2 >>>>> >>>> >>> Which JDBC version was used in original installation ? >>> Can you check if this BZ [1] is the cause ? >>> >>> [1] https://bugzilla.redhat.com/show_bug.cgi?id=1459499 >>> >>> >>> >>>> >>>> Dropping infra, adding Martin and Eli. >>>> Also changing subject >>>> >>>> >>>>> >>>>> >>>>> >>>>> [1] >>>>> 2018-05-09 10:59:26,303+03 ERROR >>>>> [org.jboss.as.controller.management-operation] >>>>> (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - >>>>> address: ([("deployment" => "engine.ear")]) - failure description: >>>>> {"WFLYCTL0080: Failed services" => {"jboss.deployment.subunit.\"e >>>>> ngine.ear\".\" >>>>> bll.jar\".component.Backend.START" => "java.lang.IllegalStateException: >>>>> WFLYEE0042: Failed to construct component instance >>>>> Caused by: java.lang.IllegalStateException: WFLYEE0042: Failed to >>>>> construct component instance >>>>> Caused by: javax.ejb.EJBException: >>>>> org.jboss.weld.exceptions.WeldException: >>>>> WELD-000049: Unable to invoke protected void org.ovirt.engine.core. >>>>> bll.TagsDirector.init() on org.ovirt.engine.core.bll.Tags >>>>> Director@891dc3a >>>>> Caused by: org.jboss.weld.exceptions.WeldException: WELD-000049: >>>>> Unable to invoke protected void org.ovirt.engine.core.bll.Tags >>>>> Director.init() >>>>> on org.ovirt.engine.core.bll.TagsDirector@891dc3a >>>>> Caused by: java.lang.reflect.InvocationTargetException >>>>> Caused by: org.springframework.jdbc.BadSqlGrammarException: >>>>> PreparedStatementCallback; bad SQL grammar [select * from >>>>> gettagsbyparent_id()]; n >>>>> ested 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 >>>>> 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"}} >>>>> >>>>> >>>>> On Wed, May 9, 2018 at 10:38 AM, Sandro Bonazzola <[email protected] >>>>> > wrote: >>>>> >>>>>> Hi, >>>>>> if you're not yet on Fedora 28, please consider updating to it. >>>>>> On master we are aiming to support Fedora 28 and we are dismissing >>>>>> any older Fedora jobs in Jenkins soon. >>>>>> >>>>>> As a reminder Fedora 26 support is going to be EOL on Tuesday, May >>>>>> 29th, 2018. >>>>>> >>>>>> Thanks, >>>>>> -- >>>>>> >>>>>> SANDRO BONAZZOLA >>>>>> >>>>>> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D >>>>>> >>>>>> Red Hat EMEA <https://www.redhat.com/> >>>>>> >>>>>> [email protected] >>>>>> <https://red.ht/sig> >>>>>> <https://redhat.com/summit> >>>>>> >>>>>> _______________________________________________ >>>>>> Infra mailing list -- [email protected] >>>>>> To unsubscribe send an email to [email protected] >>>>>> >>>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> SANDRO BONAZZOLA >>>> >>>> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D >>>> >>>> Red Hat EMEA <https://www.redhat.com/> >>>> >>>> [email protected] >>>> <https://red.ht/sig> >>>> <https://redhat.com/summit> >>>> >>>> _______________________________________________ >>>> Devel mailing list -- [email protected] >>>> To unsubscribe send an email to [email protected] >>>> %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s >>>> >>> >>> >> > > _______________________________________________ > Devel mailing list -- [email protected] > To unsubscribe send an email to [email protected] > %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s > -- GREG SHEREMETA SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX Red Hat NA <https://www.redhat.com/> [email protected] IRC: gshereme <https://red.ht/sig>
_______________________________________________ Devel mailing list -- [email protected] To unsubscribe send an email to [email protected]
