I had the same issue on a fresh fedora 28 install. s/9.2-1002-jdbc4/42.2.2/
fixes it.
I opened
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 <emesika(a)redhat.com> wrote:
On Sun, May 13, 2018 at 12:09 PM, Benny Zlotnik <bzlotnik(a)redhat.com>
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 <emesika(a)redhat.com> wrote:
>
>>
>>
>> On Wed, May 9, 2018 at 11:12 AM, Sandro Bonazzola <sbonazzo(a)redhat.com>
>> wrote:
>>
>>>
>>>
>>> 2018-05-09 10:04 GMT+02:00 Benny Zlotnik <bzlotnik(a)redhat.com>:
>>>
>>>> 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
<sbonazzo(a)redhat.com
>>>> > 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/>
>>>>>
>>>>> sbonazzo(a)redhat.com
>>>>> <
https://red.ht/sig>
>>>>> <
https://redhat.com/summit>
>>>>>
>>>>> _______________________________________________
>>>>> Infra mailing list -- infra(a)ovirt.org
>>>>> To unsubscribe send an email to infra-leave(a)ovirt.org
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> SANDRO BONAZZOLA
>>>
>>> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D
>>>
>>> Red Hat EMEA <
https://www.redhat.com/>
>>>
>>> sbonazzo(a)redhat.com
>>> <
https://red.ht/sig>
>>> <
https://redhat.com/summit>
>>>
>>> _______________________________________________
>>> Devel mailing list -- devel(a)ovirt.org
>>> To unsubscribe send an email to devel-leave(a)ovirt.org
>>> %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
>>>
>>
>>
>
_______________________________________________
Devel mailing list -- devel(a)ovirt.org
To unsubscribe send an email to devel-leave(a)ovirt.org
%(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
--
GREG SHEREMETA
SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX
Red Hat NA
<