[ovirt-users] Re: VM stuck in "Migrating to"

[Bruckner, Simone]

Hi,

 worked!

Thank you very much and all the best,
Simone

-Ursprüngliche Nachricht-
Von: Shmuel Melamud 
Gesendet: Sonntag, 15. Juli 2018 13:31
An: Bruckner, Simone 
Cc: users@ovirt.org
Betreff: Re: [ovirt-users] VM stuck in "Migrating to"

Hi!

As I understand, the VM is down already. You can fix this directly in the 
database. Connect to it with psql tool and do the following:

select vm_guid from vms where vm_name='Name of your VM';

You'll get the VM ID. And then:

update vm_dynamic set status=0 where vm_guid='VM ID';

On Wed, Jul 11, 2018 at 11:17 PM, Bruckner, Simone 
 wrote:
> Hi all,
>
>
>
>   I have a VM stuck in state „Migrating to“. I restarted ovirt-engine
> and rebooted all hosts, no success. I run ovirt 4.2.4.5-1.el7 on
> CentOS 7.5 hosts with vdsm-4.20.32-1.el7.x86_64. How can I clean this up?
>
>
>
> Thank you and all the best,
>
> Simone
>
>
>
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org Privacy
> Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/4OPRY2GR
> YDZQJ724TLT5GHGGHB5NFU45/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/4EGZVVBOE7D7YYWYWYAWAKR52KIP5YIL/

[ovirt-users] Re: VM stuck in "Migrating to"

[Bruckner, Simone]

Hi,



  running engine-setup did not resolve the issue.



All the best,

Simone



Von: Maton, Brett 
Gesendet: Sonntag, 15. Juli 2018 13:59
An: Bruckner, Simone 
Cc: users@ovirt.org
Betreff: Re: [ovirt-users] VM stuck in "Migrating to"



You could also run engine-setup on hosted-engine again



On 11 July 2018 at 21:17, Bruckner, Simone 
mailto:simone.bruck...@fabasoft.com>> wrote:

   Hi all,



 I have a VM stuck in state „Migrating to“. I restarted ovirt-engine and 
rebooted all hosts, no success. I run ovirt 4.2.4.5-1.el7 on CentOS 7.5 hosts 
with vdsm-4.20.32-1.el7.x86_64. How can I clean this up?



   Thank you and all the best,

   Simone




   ___
   Users mailing list -- users@ovirt.org
   To unsubscribe send an email to 
users-le...@ovirt.org
   Privacy Statement: https://www.ovirt.org/site/privacy-policy/
   oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
   List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/4OPRY2GRYDZQJ724TLT5GHGGHB5NFU45/



___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/55Q3MBEPBBRXHYQKYZBYBU55U7F3EI7G/

[ovirt-users] Re: VM stuck in "Migrating to"

[Maton, Brett]

You could also run engine-setup on hosted-engine again

On 11 July 2018 at 21:17, Bruckner, Simone 
wrote:

> Hi all,
>
>
>
>   I have a VM stuck in state „Migrating to“. I restarted ovirt-engine and
> rebooted all hosts, no success. I run ovirt 4.2.4.5-1.el7 on CentOS 7.5
> hosts with vdsm-4.20.32-1.el7.x86_64. How can I clean this up?
>
>
>
> Thank you and all the best,
>
> Simone
>
>
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct: https://www.ovirt.org/community/about/community-
> guidelines/
> List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/
> message/4OPRY2GRYDZQJ724TLT5GHGGHB5NFU45/
>
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/2R33FKC7DJSLOLXXIIT5BCATU3G5NRGX/

[ovirt-users] Re: VM stuck in "Migrating to"

[Shmuel Melamud]

Hi!

As I understand, the VM is down already. You can fix this directly in
the database. Connect to it with psql tool and do the following:

select vm_guid from vms where vm_name='Name of your VM';

You'll get the VM ID. And then:

update vm_dynamic set status=0 where vm_guid='VM ID';

On Wed, Jul 11, 2018 at 11:17 PM, Bruckner, Simone
 wrote:
> Hi all,
>
>
>
>   I have a VM stuck in state „Migrating to“. I restarted ovirt-engine and
> rebooted all hosts, no success. I run ovirt 4.2.4.5-1.el7 on CentOS 7.5
> hosts with vdsm-4.20.32-1.el7.x86_64. How can I clean this up?
>
>
>
> Thank you and all the best,
>
> Simone
>
>
>
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/4OPRY2GRYDZQJ724TLT5GHGGHB5NFU45/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/OEISQPZXGKLHXWNXOX5PUTY5GW4GOCQX/

[ovirt-users] ovirt 3.8 to ovirt 4.2 Migration.

[techieim]

Hello Team Ovirt,

We are running Ovirt3.8 version in our prod, we want to upgrade to 3.8 to
4.2.
At present we have 2 (hyp A & hyp B)physical host ovirt 3.8 is running with
self hosted engine with data domain and iso one cluster and data center.
What we were thing do this migration in following fashion.
Plan A.
1. Attach export domain present infra.
2. Take backup all of running vm as export.
3. Detach export domain
4.  Detach hyp B from cluster and data center
5. Install fresh ovirt 4.2 iso on hyp B
6. Install self hosted engine
7. Attach Data Domain
8. Attach Export Domain which was use in ovirt 3.8
9. Import all vm's from there to new ovirt 4.2
10. Once all the vm's got up and running poweroff hyp A
11. Install fresh ovirt 4.2 iso on hyp A and attach cluster.

Plan B.
1. Attach export domain present infra.
2. Take backup all of running vm as export.
3. Detach export domain
4.  Detach hyp B from cluster and data center
5. Install fresh ovirt 4.2 iso on hyp B
6. Install self hosted engine
7. Attach Data Domain
8. Export from ovirt 3.8 to ovirt 4.2
9. Once all the vm's got up and running poweroff hyp A
10. Install fresh ovirt 4.2 iso on hyp A and attach cluster.

Thank a ton in advance we may be wrong with above step help us to win this
migration.

Regards
Techieim
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/3DXX3BM3GEP5W4FIXDYAKUC7X2OHI6XV/

[ovirt-users] [ANN] oVirt 4.2.5 Second Release Candidate is now available

[Lev Veyde]

The oVirt Project is pleased to announce the availability of the oVirt
4.2.5 Second Release Candidate, as of July 15th, 2018.

This update is a release candidate of the fifth in a series of
stabilization updates to the 4.2
series.
This is pre-release software. This pre-release should not to be used in
production.

This release is available now for:
* Red Hat Enterprise Linux 7.5 or later
* CentOS Linux (or similar) 7.5 or later

This release supports Hypervisor Hosts running:
* Red Hat Enterprise Linux 7.5 or later
* CentOS Linux (or similar) 7.5 or later

See the release notes [1] for installation / upgrade instructions and
a list of new features and bugs fixed.

Notes:
- oVirt Appliance is available
- oVirt Node is available [2]

Additional Resources:
* Read more about the oVirt 4.2.5 release highlights:
http://www.ovirt.org/release/4.2.5/
* Get more oVirt Project updates on Twitter: https://twitter.com/ovirt
* Check out the latest project news on the oVirt blog:
http://www.ovirt.org/blog/

[1] http://www.ovirt.org/release/4.2.5/
[2] http://resources.ovirt.org/pub/ovirt-4.2-pre/iso/

-- 

Lev Veyde

Software Engineer, RHCE | RHCVA | MCITP

Red Hat Israel



l...@redhat.com | lve...@redhat.com

TRIED. TESTED. TRUSTED. 
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/U2VPEOX4F35IR5TASKQKG7RIQEKZQAOR/

[ovirt-users] Re: oVirt reports using Grafana

[Shirly Radco]

Hello,

I have updated the blog "Build oVirt Reports Using Grafana" , I used latest
Grafana.
https://ovirt.org/blog/2018/06/ovirt-report-using-grafana/

It was also tested by our QE.

Thank you for your input on this issue and I hope this blog will make it
easier for you to use Grafana with oVirt DWH and get the statistics that
you need.

Best regards,

--

SHIRLY RADCO

BI SENIOR SOFTWARE ENGINEER

Red Hat Israel 

TRIED. TESTED. TRUSTED. 

On Wed, May 23, 2018 at 11:37 AM, Alejandro Cortina <
alejandro.corti...@gmail.com> wrote:

> Hi Shirly,
>
> I went through your instructions just yesterday and they work but some
> troubleshooting was needed. This is what I have found:
>
> * When adding the graph I also got syntax errors: '*pq: syntax error at
> or near "$"'*, maybe add an "ignore this error" line to the docs would be
> an improvement
> * I am new to grafana then I could not understand about templating. Took
> me a few *trips* to http://docs.grafana.org/reference/templating/ to
> understand it. Maybe some simple instructions would make experience better.
> * Regarding tremplating:
>
> cluster_name
> - fails: SELECT cluster_name FROM v4_2_configuration_history_clusters
> WHERE datacenter_id = $datacenter_id
> - not fail: SELECT cluster_name FROM v4_2_configuration_history_clusters
> WHERE datacenter_id='$datacenter_id'
>
> cluster_id
> - fails: SELECT cluster_id FROM v4_2_configuration_history_clusters WHERE
> datacenter_id = $datacenter_id
> - not fail: SELECT cluster_id FROM v4_2_configuration_history_clusters
> WHERE datacenter_id ='$datacenter_id'
>
> there are many more.
>
> * Modifying DB, even DWH views are stable I think it would be better to
> instruct to make backup.
>
> Regarding modifying DB, Is it possible to revert these changes?
>
> Thanks!
>
> On Tue, May 22, 2018 at 6:09 PM, Shirly Radco  wrote:
>
>>
>>
>> --
>>
>> SHIRLY RADCO
>>
>> BI SENIOR SOFTWARE ENGINEER
>>
>> Red Hat Israel
>>
>>
>> TRIED. TESTED. TRUSTED.
>>
>>
>>
>> On Fri, May 18, 2018, 16:02 Vincent Royer  wrote:
>>
>>> Yes I agree, because the database contains so many version specific
>>> pointers, all of them will stop working when you upgrade. So that's no good!
>>>
>>
>> Not sure what you mean. The DWH  views are stable and we currently
>> support 3.6 and above views. It means you do not have to update the version
>> of the view.
>> Also DWH is pretty stable. So you should not expect many changes.
>>
>>
>>> If you ever get something decent working with Grafana, I'd be very
>>> interested.  I'm still not happy with the integration with the engine
>>> history database, I was never really able to get predictable output from
>>> it, and spent way too many hours messing around with it.
>>>
>>
>> Ill try and add a few more meaningful examples if that will help.
>>
>> Is the problem is how to join the tables together?
>>
>>
>>>
>>> On Thu, May 17, 2018 at 11:21 PM Karli Sjöberg 
>>> wrote:
>>>
 On Thu, 2018-05-17 at 10:37 -0700, Vincent Royer wrote:
 > These are the same issues I ran into.  I did get it working, look up
 > my post history and you'll find some solutions to the errors

 Big thanks, now I understand what the problem was!

 But I must say, after reading that thread, I´m actually more interested
 in setting up the metrics store as it seems you get way more data out
 of it without having to access the database directly. The point being,
 the less manual stuff you do to alter the original setup in the engine,
 the less issues you are going to have later on, with upgrades and such.

 /K

 >
 > On Thu, May 17, 2018, 1:01 AM Sandro Bonazzola, 
 > wrote:
 > > Shirly, can you please update the blog post pointing to an updated
 > > documentation page?
 > >
 > > 2018-05-17 9:35 GMT+02:00 Karli Sjöberg :
 > > > Heya!
 > > >
 > > > I've been whishing for reports in oVirt ever since the old
 > > > 'Jasper
 > > > Reports' was removed. For an Enterprise, having pretty graphs to
 > > > look
 > > > at is a must.
 > > >
 > > > Searching the subject, I've found this[*] and have managed to get
 > > > it
 > > > installed OK but having issues trying to follow the guide setting
 > > > it
 > > > up.
 > > >
 > > > First of all, I think the guide should have at least mentioned
 > > > that
 > > > 'pg_hba.conf' needs to be edited for the read only user to be
 > > > able to
 > > > connect to the database, I scratched my head around that for a
 > > > while
 > > > before I got it.
 > > >
 > > > When I first type in the query example, I got syntax errors:
 > > > 'pq: syntax error at or near "$"'. I continued anyways since I
 > > > figured
 > > > it would be solved at a later point, which turned out to be true,
 > > > since
 > > > the next step is to use the "Templating feature" 

[ovirt-users] Re: ovirt 4.2.4 installation failures

[Yedidyah Bar David]

Hi,

On Fri, Jul 13, 2018 at 5:25 PM, Vineet Khandpur  wrote:
> bump?
>
> vk
> 
> Vineet Khandpur
> UNIX System Administrator
> Information Technology Services
> University of Alberta Libraries
> +1-780-492-4718
>
> On 12 July 2018 at 09:24, Vineet Khandpur  wrote:
>>
>> Sorry, more clarification:
>>
>> 2018-07-12 08:45:24,810-0600 DEBUG otopi.context
>> context._executeMethod:128 Stage misc METHOD
>> otopi.plugins.ovirt_engine_setup.ovirt_engine.network.ovirtproviderovn.Plugin._misc_configure_pro
>> vider
>> 2018-07-12 08:45:24,810-0600 DEBUG otopi.transaction
>> transaction._prepare:61 preparing 'File transaction for
>> '/etc/ovirt-engine/ovirt-provider-ovn-conf.example''
>> 2018-07-12 08:45:24,810-0600 DEBUG otopi.filetransaction
>> filetransaction.prepare:183 file
>> '/etc/ovirt-engine/ovirt-provider-ovn-conf.example' missing
>> 2018-07-12 08:45:24,823-0600 DEBUG otopi.transaction
>> transaction._prepare:61 preparing 'File transaction for
>> '/etc/ovirt-provider-ovn/conf.d/10-setup-ovirt-provider-ovn.conf''
>> 2018-07-12 08:45:24,823-0600 DEBUG otopi.filetransaction
>> filetransaction.prepare:183 file
>> '/etc/ovirt-provider-ovn/conf.d/10-setup-ovirt-provider-ovn.conf' missing
>> 2018-07-12 08:45:24,830-0600 DEBUG
>> otopi.plugins.ovirt_engine_setup.ovirt_engine.network.ovirtproviderovn
>> plugin.executeRaw:813 execute: ('keytool', '-import', '-alias',
>> 'ovirt-provider-ovn',
>>  '-keystore', '/var/lib/ovirt-engine/external_truststore', '-file',
>> '/etc/pki/ovirt-engine/ca.pem', '-noprompt', '-storepass:env', 'pass'),
>> executable='None', cwd='None', env={'pass': '**FILT
>> ERED**'}
>> 2018-07-12 08:45:24,842-0600 DEBUG
>> otopi.plugins.ovirt_engine_setup.ovirt_engine.network.ovirtproviderovn
>> plugin.executeRaw:869 execute-result: ('keytool', '-import', '-alias',
>> 'ovirt-provide
>> r-ovn', '-keystore', '/var/lib/ovirt-engine/external_truststore', '-file',
>> '/etc/pki/ovirt-engine/ca.pem', '-noprompt', '-storepass:env', 'pass'),
>> exception
>> Traceback (most recent call last):
>>   File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 856, in
>> executeRaw
>> preexec_fn=preexec_fn,
>>   File "/usr/lib64/python2.7/subprocess.py", line 711, in __init__
>> errread, errwrite)
>>   File "/usr/lib64/python2.7/subprocess.py", line 1327, in _execute_child
>> raise child_exception
>> OSError: [Errno 2] No such file or directory

Seems somewhat similar to:

https://bugzilla.redhat.com/1481583

Sorry for not attaching there at the time the actual logs :-

Is it possible that you (tried to) something non-default? Perhaps
a non clean machine? Manually (partially?) configured ovn? Something
like that?

Anyway, in case you do not know about anything "bad" you did:

The thing that failed is the command:

keytool -import -alias ovirt-provider-ovn -keystore
/var/lib/ovirt-engine/external_truststore -file
/etc/pki/ovirt-engine/ca.pem -noprompt -storepass:env pass

and if you want to try it yourself, you'll have to first set 'pass' to the
value of ENGINE_EXTERNAL_PROVIDERS_TRUST_STORE_PASSWORD, which defaults to
'changeit'. So e.g. 'export pass=changeit' and then run above command.

It seems to me (although a bit hard to tell) that the "no such file or
directory"
is not about one of the arguments, but about 'keytool' itself. Do you have
/usr/bin/keytool?

It should be supplied by the package 'java-1.8.0-openjdk-headless', but we
do not require it directly. We require 'java-openjdk-headless >= 1:1.8.0'.
So in theory this could have happened if you pre-installed some other package
that provides this but does not provide keytool.

I suggest to open a bug, provide precise and detailed flow, and attach a full
sosreport, or at least all relevant logs, including e.g.:

yum.log
full setup.log
ls -l of all relevant files/directories

>> 2018-07-12 08:45:24,844-0600 DEBUG otopi.context
>> context._executeMethod:143 method exception
>> Traceback (most recent call last):
>>
>> --
>> Also:
>>
>> [root@ovirtdev conf.d]# pwd
>> /etc/ovirt-provider-ovn/conf.d
>> [root@ovirtdev conf.d]# ls -al
>> total 4
>> drwxr-xr-x. 2 root root  20 Jul 12 08:45 .
>> drwxr-xr-x. 3 root root  70 Jul 12 08:34 ..
>> -rw-r--r--. 1 root root 194 Jun  4 08:22 README
>> [root@ovirtdev conf.d]#

I assume you showed this to us because of the line
"10-setup-ovirt-provider-ovn.conf missing", but that in itself is not
a problem and most likely unrelated. It's just part of otopi's normal
logging - if it's asked (by engine-setup) to create a file, and the
file does not exist, it logs this. If it does exist, it creates a backup
(and logs that as well).

Best regards,

>>
>>
>>
>> vk
>> 
>> Vineet Khandpur
>> UNIX System Administrator
>> Information Technology Services
>> University of Alberta Libraries
>> +1-780-492-4718
>>
>> On 12 July 2018 at 09:17, Vineet Khandpur  wrote:
>>>
>>> cat
>>>