2018-05-09 10:04 GMT+02:00 Benny Zlotnik <bzlotnik@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
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.\" engine.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.TagsDirector@891dc3a Caused by: 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.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@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@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Infra mailing list -- infra@ovirt.org To unsubscribe send an email to infra-leave@ovirt.org
-- SANDRO BONAZZOLA ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D Red Hat EMEA <https://www.redhat.com/> sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
On Wed, May 9, 2018 at 11:12 AM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
2018-05-09 10:04 GMT+02:00 Benny Zlotnik <bzlotnik@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.TagsDirector@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@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@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Infra mailing list -- infra@ovirt.org To unsubscribe send an email to infra-leave@ovirt.org
--
SANDRO BONAZZOLA
ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D
Red Hat EMEA <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
9.2-1002-jdbc4 It does not look like the same issue On Sun, May 13, 2018 at 11:46 AM, Eli Mesika <emesika@redhat.com> wrote:
On Wed, May 9, 2018 at 11:12 AM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
2018-05-09 10:04 GMT+02:00 Benny Zlotnik <bzlotnik@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@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@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Infra mailing list -- infra@ovirt.org To unsubscribe send an email to infra-leave@ovirt.org
--
SANDRO BONAZZOLA
ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D
Red Hat EMEA <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
On Sun, May 13, 2018 at 12:09 PM, Benny Zlotnik <bzlotnik@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@redhat.com> wrote:
On Wed, May 9, 2018 at 11:12 AM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
2018-05-09 10:04 GMT+02:00 Benny Zlotnik <bzlotnik@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@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@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Infra mailing list -- infra@ovirt.org To unsubscribe send an email to infra-leave@ovirt.org
--
SANDRO BONAZZOLA
ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D
Red Hat EMEA <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
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 <emesika@redhat.com> wrote:
On Sun, May 13, 2018 at 12:09 PM, Benny Zlotnik <bzlotnik@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@redhat.com> wrote:
On Wed, May 9, 2018 at 11:12 AM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
2018-05-09 10:04 GMT+02:00 Benny Zlotnik <bzlotnik@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@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@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Infra mailing list -- infra@ovirt.org To unsubscribe send an email to infra-leave@ovirt.org
--
SANDRO BONAZZOLA
ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D
Red Hat EMEA <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://redhat.com/summit>
_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org %(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org %(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/> gshereme@redhat.com IRC: gshereme <https://red.ht/sig>
participants (4)
-
Benny Zlotnik -
Eli Mesika -
Greg Sheremeta -
Sandro Bonazzola