Thanks Shirly,
As we are not planning to move to 4.2 until next month I
have applied this update, it's actually in
/usr/share/ovirt-engine-dwh/dbscripts/upgrade/
and it seems to working O.K. since yesterday.
Regards,
Paul S.
__
Thanks Shirly,
unfortunately Microsoft sent your reply to my Junk Email
folder so I have only noticed it today.
Is there any instructions on how to run the script? I can't find any tables or
views with the vm_interface_daily_history, etc columns.
I'm not a database expe
In that case there is a workaround but I would recommend upgrading to 4.2
if you can.
I did not test the workaround:
You can add to /usr/share/ovirt-engine-dwh/packaging/dbscripts/upgrade/
a file called
04_01_0025__updated_vm_interface_history_id_to_bigint.sql
with the same content as in my pat
Sorry was looking at the engine database, rather than ovirt_engine_history
database.
When running
SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id',
'integer', 'bigint');
I get
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on
Hi,
This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
in version 4.2.2.
I believe you can update manually the history_id field in tables -
vm_interface_daily_history, vm_interface_hourly_history,
vm_interface_samples_history
from integer to bigint and it should fix the issue
5 matches
Mail list logo
