DB error during engine upgrade in dev environment
Hi, I'm trying to upgrade my engine dev environment to latest master, but during $HOME/ovirt-engine/bin/engine-setup I'm getting error bellow even when I run with full DB vacuum. Any idea how to fix it? Thanks Vojta 2021-04-12 08:45:41,395-0400 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.7/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/bin/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/config/public_glance_repository.py", line 69, in _misc storage_domain_id="072fbaa1-08f3-4a40-9f34-a5ca22dd1d74" File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/ovirt_**FILTERED**_setup/**FILTERED**_common/database.py", line 258, in execute args, psycopg2.ProgrammingError: function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2021-04-12 08:45:41,396-0400 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
I've encountered this a long time ago, not sure what the root cause was but I think a refresh of the schema helped: $ $PREFIX/share/ovirt-engine/dbscripts/schema.sh -c refresh On Mon, Apr 12, 2021 at 4:03 PM Vojtech Juranek <vjuranek@redhat.com> wrote:
Hi, I'm trying to upgrade my engine dev environment to latest master, but during
$HOME/ovirt-engine/bin/engine-setup
I'm getting error bellow even when I run with full DB vacuum. Any idea how to fix it?
Thanks Vojta
2021-04-12 08:45:41,395-0400 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.7/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/bin/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/config/public_glance_repository.py", line 69, in _misc storage_domain_id="072fbaa1-08f3-4a40-9f34-a5ca22dd1d74" File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/ovirt_**FILTERED**_setup/**FILTERED**_common/database.py", line 258, in execute args, psycopg2.ProgrammingError: function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2021-04-12 08:45:41,396-0400 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts._______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/devel@ovirt.org/message/CJPPQALDD3MCCF...
On Monday, 12 April 2021 15:13:32 CEST Benny Zlotnik wrote:
I've encountered this a long time ago, not sure what the root cause was but I think a refresh of the schema helped: $ $PREFIX/share/ovirt-engine/dbscripts/schema.sh -c refresh
thanks, but doesn't seem to work, fails with some other error in the DB (probably somehow completely broken DB). Probably would be more easy to start from scratch. Just for the reference, if someone needs this in the future, needs to be run with $PREFIX/share/ovirt-engine/dbscripts/schema.sh -c refresh -s 127.0.0.1 -p 5432 -u engine -d engine and export DBFUNC_DB_="/home/engine/pgpass" which has 127.0.0.1:5432:engine:engine:engine otherwise fails with "fe_sendauth: no password supplied"
On Mon, Apr 12, 2021 at 4:03 PM Vojtech Juranek <vjuranek@redhat.com> wrote:
Hi, I'm trying to upgrade my engine dev environment to latest master, but during> $HOME/ovirt-engine/bin/engine-setup
I'm getting error bellow even when I run with full DB vacuum. Any idea how to fix it?
Thanks Vojta
2021-04-12 08:45:41,395-0400 DEBUG otopi.context context._executeMethod:145 method exception> Traceback (most recent call last): File "/usr/lib/python3.7/site-packages/otopi/context.py", line 132, in _executeMethod> method['method']()
File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/b in/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/config/public_ glance_repository.py", line 69, in _misc> storage_domain_id="072fbaa1-08f3-4a40-9f34-a5ca22dd1d74"
File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/o virt_**FILTERED**_setup/**FILTERED**_common/database.py", line 258, in execute> args,
psycopg2.ProgrammingError: function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider(
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2021-04-12 08:45:41,396-0400 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider(
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts._______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/devel@ovirt.org/message/CJPPQALDD3M CCFDLEMWF7423DYGA73XO/
On Mon, Apr 12, 2021 at 5:00 PM Vojtech Juranek <vjuranek@redhat.com> wrote:
On Monday, 12 April 2021 15:13:32 CEST Benny Zlotnik wrote:
I've encountered this a long time ago, not sure what the root cause was but I think a refresh of the schema helped: $ $PREFIX/share/ovirt-engine/dbscripts/schema.sh -c refresh
thanks, but doesn't seem to work, fails with some other error in the DB (probably somehow completely broken DB). Probably would be more easy to start from scratch.
Just for the reference, if someone needs this in the future, needs to be run with
$PREFIX/share/ovirt-engine/dbscripts/schema.sh -c refresh -s 127.0.0.1 -p 5432 -u engine -d engine
and
export DBFUNC_DB_="/home/engine/pgpass"
which has
127.0.0.1:5432:engine:engine:engine
otherwise fails with "fe_sendauth: no password supplied"
On Mon, Apr 12, 2021 at 4:03 PM Vojtech Juranek <vjuranek@redhat.com> wrote:
Hi, I'm trying to upgrade my engine dev environment to latest master, but during> $HOME/ovirt-engine/bin/engine-setup
I'm getting error bellow even when I run with full DB vacuum. Any idea how to fix it?
Thanks Vojta
2021-04-12 08:45:41,395-0400 DEBUG otopi.context context._executeMethod:145 method exception> Traceback (most recent call last): File "/usr/lib/python3.7/site-packages/otopi/context.py", line 132, in _executeMethod> method['method']()
File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/b in/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/config/public_ glance_repository.py", line 69, in _misc> storage_domain_id="072fbaa1-08f3-4a40-9f34-a5ca22dd1d74"
File "/home/**FILTERED**/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/o virt_**FILTERED**_setup/**FILTERED**_common/database.py", line 258, in execute> args,
psycopg2.ProgrammingError: function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider(
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2021-04-12 08:45:41,396-0400 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': function inst_add_glance_provider(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: select inst_add_glance_provider(
^
No idea about your general DB corruption/issue, but you skip/prevent above failure with: engine-setup --otopi-environment=OVESETUP_CONFIG/addOvirtGlanceRepository=bool:False Best regards,
HINT: No function matches the given name and argument types. You might need to add explicit type casts._______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/devel@ovirt.org/message/CJPPQALDD3M CCFDLEMWF7423DYGA73XO/
_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/devel@ovirt.org/message/EAQI3WFTXT4MUQ...
-- Didi
participants (3)
-
Benny Zlotnik -
Vojtech Juranek -
Yedidyah Bar David