Maybe you can assist ...

Important according to Google magic.
Click to teach Red Hat Mail this conversation is not important.

Shir Fishbain sfishbai@redhat.com

3:37 PM (23 hours ago)

to Alona

Hi Alona ,

Burman told me to consult with you about that I can't do reinstall to my hosts , I get the following error log :

hostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist

Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM

2018-05-28 13:41:12,683+03 ERROR [org.ovirt.engine.core.bll.hostdeploy.InstallVdsInternalCommand] (EE-ManagedThreadFactory-engine-Thread-2) [66b2ab87-4bb1-480f-8eec-948facdf114f] Exception: org.ovirt.engine.core.common.errors.EngineException: EngineException: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call updatehostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist

Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM (Failed with error ENGINE and code 5001)

We tried it on his engine and it was normal. I'd be glad if you could help me with this problem.

Thanks,

Shir Fishbain

Forward

Alona Kaplan

10:16 AM (4 hours ago)

to me

Hi Shir,

I there a chance you had an error during the engine setup? What version of ovirt-engine are you using?

Seems like a table that should have been created during the upgrade it missing (provider_binding_host_id).

Try to run the engine setup again.

If it doesn't help please send me the credentials of your environment and I will try to connect and take a look.

Please also send the output of 'select * from shcema_version;'.

Thanks,

Alona.

On Mon, May 28, 2018 at 3:37 PM, Shir Fishbain <sfishbai@redhat.com> wrote:

Hi Alona ,

Burman told me to consult with you about that I can't do reinstall to my hosts , I get the following error log :

hostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist
Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM
2018-05-28 13:41:12,683+03 ERROR [org.ovirt.engine.core.bll.hostdeploy.InstallVdsInternalCommand] (EE-ManagedThreadFactory-engine-Thread-2) [66b2ab87-4bb1-480f-8eec-948facdf114f] Exception: org.ovirt.engine.core.common.errors.EngineException: EngineException: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call updatehostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist
Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM (Failed with error ENGINE and code 5001)

We tried it on his engine and it was normal. I'd be glad if you could help me with this problem.

Thanks,
Shir Fishbain

Forward

Shir Fishbain sfishbai@redhat.com

11:58 AM (2 hours ago)

to Alona

Hi Alona,

I tried to run the engine setup again and the table: "provider_binding_host_id" is still missing. The version that was before 4.2.3-10.

The current version that I've installed is 4.2.4-1.

I give you the credentials of the environment :

shir-engine-1.scl.lab.tlv.redhat.com/ovirt-engine/

password: qum5net

Attached the output of the

select * from schema_version order by id desc;

Thanks,

Shir

On Tue, May 29, 2018 at 10:16 AM, Alona Kaplan <alkaplan@redhat.com> wrote:

Hi Shir,

I there a chance you had an error during the engine setup? What version of ovirt-engine are you using?

Seems like a table that should have been created during the upgrade it missing (provider_binding_host_id).
Try to run the engine setup again.
If it doesn't help please send me the credentials of your environment and I will try to connect and take a look.
Please also send the output of 'select * from shcema_version;'.

Thanks,
Alona.

On Mon, May 28, 2018 at 3:37 PM, Shir Fishbain <sfishbai@redhat.com> wrote:
Hi Alona ,

Burman told me to consult with you about that I can't do reinstall to my hosts , I get the following error log :

hostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist
Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM
2018-05-28 13:41:12,683+03 ERROR [org.ovirt.engine.core.bll.hostdeploy.InstallVdsInternalCommand] (EE-ManagedThreadFactory-engine-Thread-2) [66b2ab87-4bb1-480f-8eec-948facdf114f] Exception: org.ovirt.engine.core.common.errors.EngineException: EngineException: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call updatehostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist
Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM (Failed with error ENGINE and code 5001)

We tried it on his engine and it was normal. I'd be glad if you could help me with this problem.

Thanks,
Shir Fishbain

Attachments area

Preview attachment output.csv

Forward

Alona Kaplan

12:27 PM (2 hours ago)

to me

Hi Shir,

Please notice lines 3 and 5 in your output files. They both have the same script upgrade/04_02_1110_enlarge_custom_cpu_type.sql

Line 5 should contain upgrade/04_02_0980_add_host_provider_binding_ids.sql.

Seems like the numbering of script enlarge_custom_cpu_type was changed since the last time you ran the engine-setup.

This is something (changing the numbering) that shouldn't happen in official builds. Maybe you installed private rpm to verify something?

Anyway, to fix your current issue you need to run upgrade/04_02_0980_add_host_provider_binding_ids.sql script manually.

Thanks,

Alona.

On Tue, May 29, 2018 at 11:58 AM, Shir Fishbain <sfishbai@redhat.com> wrote:

Hi Alona,

I tried to run the engine setup again and the table: "provider_binding_host_id" is still missing. The version that was before 4.2.3-10.
The current version that I've installed is 4.2.4-1.
I give you the credentials of the environment :
shir-engine-1.scl.lab.tlv.redhat.com/ovirt-engine/
password: qum5net
Attached the output of the
select * from schema_version order by id desc;
Thanks,
Shir
On Tue, May 29, 2018 at 10:16 AM, Alona Kaplan <alkaplan@redhat.com> wrote:
Hi Shir,

I there a chance you had an error during the engine setup? What version of ovirt-engine are you using?

Seems like a table that should have been created during the upgrade it missing (provider_binding_host_id).
Try to run the engine setup again.
If it doesn't help please send me the credentials of your environment and I will try to connect and take a look.
Please also send the output of 'select * from shcema_version;'.

Thanks,
Alona.

On Mon, May 28, 2018 at 3:37 PM, Shir Fishbain <sfishbai@redhat.com> wrote:
Hi Alona ,

Burman told me to consult with you about that I can't do reinstall to my hosts , I get the following error log :

hostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist
Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM
2018-05-28 13:41:12,683+03 ERROR [org.ovirt.engine.core.bll.hostdeploy.InstallVdsInternalCommand] (EE-ManagedThreadFactory-engine-Thread-2) [66b2ab87-4bb1-480f-8eec-948facdf114f] Exception: org.ovirt.engine.core.common.errors.EngineException: EngineException: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call updatehostproviderbinding(?, ?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "provider_binding_host_id" does not exist
Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM (Failed with error ENGINE and code 5001)

We tried it on his engine and it was normal. I'd be glad if you could help me with this problem.

Thanks,
Shir Fishbain

Forward

Click here to Reply or Forward