Re: ETL Service
by Yedidyah Bar David
On Mon, Mar 16, 2020 at 2:04 PM Anton Louw <Anton.Louw(a)voxtelecom.co.za> wrote:
>
>
>
> Hi All,
>
>
>
> I am having a strange issue. I configured my DWH scale with scales that I would like to report on. I checked this morning, and the last row in my PostgreSQL DB is from the 9th. I checked the logs, and I see that it is referring to an “ETL Service” which I am not familiar with. I have attached the lines in the text document.
Where is this from? If from the engine db, please check also:
/var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log
Then try to (re)start it with:
systemctl restart ovirt-engine-dwhd.service
ETL is a common name in the industry for what dwhd does: Extract,
Transform, Load.
>
>
>
> If anybody could point me in the right direction, it would be greatly appreciated.
>
>
>
> Thank you
>
>
> Anton Louw
> Cloud Engineer: Storage and Virtualization at Vox
> ________________________________
> T: 087 805 0000 | D: 087 805 1572
> M: N/A
> E: anton.louw(a)voxtelecom.co.za
> A: Rutherford Estate, 1 Scott Street, Waverley, Johannesburg
> www.vox.co.za
>
>
>
>
>
>
>
>
> Disclaimer
>
> The contents of this email are confidential to the sender and the intended recipient. Unless the contents are clearly and entirely of a personal nature, they are subject to copyright in favour of the holding company of the Vox group of companies. Any recipient who receives this email in error should immediately report the error to the sender and permanently delete this email from all storage devices.
>
> This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more Click Here.
>
>
>
> _______________________________________________
> Users mailing list -- users(a)ovirt.org
> To unsubscribe send an email to users-leave(a)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/users@ovirt.org/message/QGK64XNPKSY...
--
Didi
4 years, 1 month
Migrate engine from one storage domain to another
by anton.louw＠voxtelecom.co.za
Hi All,
What would be the easiest way to migrate my hosted engine disk from one storage domain, to another? I see that I can click on the disk, and select move, but for some reason I feel nervous about it :)
Thanks
4 years, 1 month
Client separation on bridge level
by Hendrik Peyerl
Hello everyone,
is there a way to seperate the traffic between VMs on the same bridge on one oVirt-node with built-in tools from ovirt? We have VMs using the same bridge which should never be able to talk to each other.
We are currently using ebtables for that, but its not working very good anymore now that we upgraded to 4.3 with firewalld.
Any suggestions would be greatly appreciated.
Best regards,
Hendrik
4 years, 1 month
Ansible playbook timeout
by Barrett Richardson
Version 4.2.8.2-1.0.9.el7
Per the info near the bottom of
/usr/share/ovirt-engine/services/ovirt-engine/ovirt-engine.conf I
should be able to create this file,
/etc/ovirt-engine/engine.conf.d/99-ansible-playbook-timeout.conf
and place in the file these contents,
ANSIBLE_PLAYBOOK_EXEC_DEFAULT_TIMEOUT=150
and extend the playbook timeout. It doesn't work, still times out
after 30 minutes. Any suggested workarounds?
4 years, 1 month
strange error when editing multiple disks
by Gianluca Cecchi
I'm noticing this on 4.3.8 and I don't have understood exactly the raising
condition, if UI based or what
At first I thought it was the bootable flag, but it is not, apparently
vm1 powered on with two disks
I select the VM then Disks subtab
select line of second disk --> edit --> OK
All goes well
Then, remaining in the same Disks subtab window I select the line of the
first disk --> Edit --> OK
And now I get the error window:
"
Error while executing action:
vm1:
- Cannot edit Virtual Disk. At least one of the VMs is not down.
"
?
Then I go and select another powered on VM, vm2, with only one disk, the
one with bootable flag, and I'm able to edit it successfully.
Then I come back and select vm1 and Disks subtab, select again the first
line of the boot disk --> Edit --> OK
and I'm able to edit with success..... but eg if I want to modify both
alias and description fields I have to do one at a time, otherwise if in
the same window I try to modify both and then press OK I still get the
error message above.
Can anyone verify/test? I was able to reproduce on bot oVirt 4.3.8 and RHV
4.3.8
Gianluca
4 years, 1 month
Re: upgrade from 4.38 to 4.39
by eevans＠digitaldatatechs.com
Since the upgrade, for some reason I get this message when checking for
upgrade on one host:
Failed to check for available updates on host kvm01 with message 'Failed to
run check-update of host 'kvm01.digitaldatatechs.com'. Error: fatal:
[kvm01.digitaldatatechs.com]: FAILED! => {"changed": false, "msg": "Failed
to connect to the host via ssh: Permission denied
(publickey,gssapi-keyex,gssapi-with-mic,password).", "unreachable": true}
I can ssh into the server from the ovirt server and re-copied the ssh keys
and authorized keys but the problem persists.
I am still unable to manually migrate but auto load balance seems to be
working again.
I am attaching the engine log for your review.
Thank you so much for your help.
Eric Evans
Digital Data Services LLC.
304.660.9080
4 years, 1 month
Image File Owner change Situation. (root:root)
by Robert O'Kane
Hello @All,
This has happened to us for the first time and only on One VM.
I believe it happened with the switch from Fuse to "LibgfApi" in Ovirt.
I was using LibgfApiSupported=True on 4.2.8 . I upgraded to 4.3.8 and did NOT restart all of my VMs (30+)
but only some VMs, no problem. Eventually I noticed that LibgfApiSupported=False and reset it to True.
The VM was Running WindowsServer2016 and we did a Cold-Reboot (not VM Restart). It did not come back online
due to "Invalid Volume" which was eventually due to the IMAGEs (Boot and Data) being user:group=root but
not the meta,lease or directory. Nor any other VM have/had this problem but they were (if at all) completely
stopped and restarted.
I am looking for another VM that has not yet been restarted to test this theory. I thought this would be
interesting for others looking into this problem.
(I will ask my Colleague next week what he means with Cold-Reboot vs Warm-reboot....)
Stay Healthy.
Cheers,
Robert O'Kane
--
Robert O'Kane
Systems Administrator
Kunsthochschule für Medien Köln
Peter-Welter-Platz 2
50676 Köln
fon: +49(221)20189-223
fax: +49(221)20189-49223
4 years, 1 month
