[ovirt-users] Re: Help remove snapshot

2020-08-19 Thread Eli Mesika
On Mon, Aug 17, 2020 at 2:48 PM Shani Leviim  wrote:

> Hi Magnus,
> Sounds like you triggered this one
> https://bugzilla.redhat.com/show_bug.cgi?id=1555116.
> The error message you've got was meant to avoid removing a snapshot from a
> broken chain.
>
> On the Active VM snapshot -> Disks, is there any disk with Illegal status?
>
> Deleting the whole snapshot can be done from the DB:
>
>
> *delete from snapshots where snapshot_id = '.';*
>
>
> *please avoid deleting stuff from DB directly ,  you should use teh right
> SP for doing the job since in many time database consistency is handled by
> the SP code and doing it directly will leave inconsistent data which may
> cause problems *
>
>
> *on this case you should use :*
>
> *SELECT DeleteSnapshot(<'snapshot-id'>);*
>
>
> Although it's recommended to understand the root cause for that one.
>
> Can you please share your engine.log?
>
>
> *Regards,*
>
> *Shani Leviim*
>
>
> On Mon, Aug 17, 2020 at 1:37 PM Magnus Isaksson  wrote:
>
>> Hi!
>>
>> I would need some help removing a snapshot that looks like this.
>> How do i remove it manually or fix snapshot definition?
>> -
>> Error while executing action:
>>
>> TUN_SALDC01:
>>
>>- The requested snapshot has an invalid parent, either fix the
>>snapshot definition or remove it manually to complete the process.
>>
>> -
>> And when i look at the disk on tha tnapshot it show as this:
>>
>>
>> And general info:
>>
>> ___
>> Users mailing list -- users@ovirt.org
>> To unsubscribe send an email to users-le...@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/5QEBPZPUHDGS52266D4OLVX54CUEWEOB/
>>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/QRNHSLEZXM27GABD43IJ7DHUYZ4EJJIY/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/DI5RLNOLXBP3574ORE7HBK3NWQYVY46Y/


[ovirt-users] Re: Host has time-drift of xxx seconds

2020-06-15 Thread Eli Mesika
Hi

Looking at the code I realized that the date/time retrieved from the host
is cached and not refreshed again until the RHV manager engine is restarted
Please open a bug on that, we should be able to notice that the problem was
fixed

Thanks
Eli

On Thu, Jun 11, 2020 at 6:02 AM Strahil Nikolov via Users 
wrote:

> Hello All,
>
> I have a strange error that should be fixed but the event log is  still
> filling with the following after the latest patching (4.3.10):
>
> Host ovirt2.localdomain has time-drift of 2909848 seconds while maximum
> configured value is 300 seconds.
> Host ovirt3.localdomain has time-drift of 2909848 seconds while maximum
> configured value is 300 seconds.
>
> As  it blamed only 2  out of 3 systems,  I checked what has happened  on
> ovirt1 and that one was far behind the other servers.
>
> Once I fixed the issue, I kept receiving those errors despite tthe fact
> that I fixed the time drift on ovirt1 several days ago.
> Currently the hosts and the engine are OK, but I got no idea how to 'fix'
> the issue.
>
> I have also noticed that the 2  errors had a  date  of 2 PM which is not
> possible with my current timezone.
>
> Here  is a one-shot query from all nodes:
>
> [root@ovirt1 ~]# for i in ovirt{1..3}; do ssh $i "ntpdate -q
> office.ipacct.com"; done
> server 195.85.215.8, stratum 1, offset 0.001233, delay 0.03105
> 11 Jun 05:48:16 ntpdate[5224]: adjust time server 195.85.215.8 offset
> 0.001233 sec
> server 195.85.215.8, stratum 1, offset -0.000200, delay 0.02821
> 11 Jun 05:48:23 ntpdate[6637]: adjust time server 195.85.215.8 offset
> -0.000200 sec
> server 195.85.215.8, stratum 1, offset 0.000243, delay 0.02914
> 11 Jun 05:48:30 ntpdate[14215]: adjust time server 195.85.215.8 offset
> 0.000243 sec
> [root@ovirt1 ~]# ssh engine 'ntpdate -q office.ipacct.com'
> root@engine's password:
> server 195.85.215.8, stratum 1, offset 0.000291, delay 0.02888
> 11 Jun 05:49:15 ntpdate[13911]: adjust time server 195.85.215.8 offset
> 0.000291 sec
>
> Any ideas ?
>
> Best Regards,
> Strahil Nikolov
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/B2IGFLACF66RX2SUWBTAX66GZTJJ4T4L/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/OALM4MOP65ZRBTAG7A7NVHJ4ERCBVTYH/


[ovirt-users] Re: LDAP setup fails on 4.4 reading PEM file

2020-06-15 Thread Eli Mesika
IMO your first error
[ ERROR ] Failed to execute stage 'Environment customization': a
byte-like object is required, not 'str'

seems to me as related to python2=>python3 upgrade and worth filing a bug
with all the relevant details


On Thu, Jun 11, 2020 at 8:38 PM Stack Korora 
wrote:

> Greetings,
> I'm having some issues getting LDAP working on CentOS 8 with oVirt 4.4.
> I would appreciate some help please.
>
> When I run ovirt-engine-extension-aaa-ldap-setup I choose "11 - RFC-2307
> Schema (Generic)" because that's what my LDAP guy said I should do. :-)
>
> Next I select the default Yes for "Use DNS".
>
> I select 4 for "Failover between multiple hosts".
>
> I put in my two hosts "svr1.my.domain srv2.my.domain".
>
> To select the protocol I type "ldaps".
>
> To select the method to obtain the PEM I type "File".
>
> Then the "File path". A full path to the file. Not quoted. Yes, I
> checked that I typed it correct. I can copy-paste into "ls" and it's
> fine with the correct read permissions and everything. (I can't copy
> paste into the script but that's another issue.)
>
> It immediately fails with:
> [ ERROR ] Failed to execute stage 'Environment customization': a
> byte-like object is required, not 'str'
>
> There is a log file, here is the snippet at the point it goes wrong.
>
> 2020-06-11 11:35:49,915-0500 DEBUG otopi.plugins.otopi.dialog.human
> dialog.__logString:204 DIALOG:SEND File path:
> 2020-06-11 11:36:24,373-0500 DEBUG otopi.plugins.otopi.dialog.human
> dialog.__logString:204 DIALOG:RECEIVE
> /etc/pki/ca-trust/source/anchors/Infrastructure.pem
> 2020-06-11 11:36:24,375-0500 DEBUG otopi.context
> context._executeMethod:145 method exception
> Traceback (most recent call last):
>   File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in
> _executeMethod
> method['method']()
>   File
>
> "/usr/share/ovirt-engine-extension-aaa-ldap/setup/bin/../plugins/ovirt-engine-extension-aaa-ldap/ldap/common.py",
> line 781, in _customization_late
> cacert, cacertfile, insecure = self._getCACert()
>   File
>
> "/usr/share/ovirt-engine-extension-aaa-ldap/setup/bin/../plugins/ovirt-engine-extension-aaa-ldap/ldap/common.py",
> line 357, in _getCACert
> _cacertfile.write('\n'.join(cacert) + '\n')
>   File "/usr/lib64/python3.6/tempfile.py", line 485, in func_wrapper
> return func(*args, **kwargs)
> TypeError: a bytes-like object is required, not 'str'
> 2020-06-11 11:36:24,376-0500 ERROR otopi.context
> context._executeMethod:154 Failed to execute stage 'Environment
> customization': a bytes-like object is required, not 'str'
> 2020-06-11 11:36:24,376-0500 DEBUG otopi.context
> context.dumpEnvironment:765 ENVIRONMENT DUMP - BEGIN
> 2020-06-11 11:36:24,376-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV BASE/error=bool:'True'
> 2020-06-11 11:36:24,376-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV BASE/exceptionInfo=list:'[( 'TypeError'>, TypeError("a bytes-like object is required, not 'str'",),
> )]'
> 2020-06-11 11:36:24,377-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV OVAAALDAP_LDAP/hosts=str:'svr1.my.domain
> srv2.my.domain'
> 2020-06-11 11:36:24,377-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV OVAAALDAP_LDAP/protocol=str:'ldaps'
> 2020-06-11 11:36:24,377-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV OVAAALDAP_LDAP/serverset=str:'failover'
> 2020-06-11 11:36:24,377-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV OVAAALDAP_LDAP/useDNS=bool:'True'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV
>
> QUESTION/1/OVAAALDAP_LDAP_CACERT_FILE=str:'/etc/pki/ca-trust/source/anchors/Infrastructure.pem'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV
> QUESTION/1/OVAAALDAP_LDAP_CACERT_METHOD=str:'file'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV
> QUESTION/1/OVAAALDAP_LDAP_PROTOCOL=str:'ldaps'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV QUESTION/1/OVAAALDAP_LDAP_SERVERSET=str:'4'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV QUESTION/1/OVAAALDAP_LDAP_USE_DNS=str:'yes'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:775 ENV
> QUESTION/2/OVAAALDAP_LDAP_SERVERSET=str:'svr1.my.domain srv2.my.domain'
> 2020-06-11 11:36:24,378-0500 DEBUG otopi.context
> context.dumpEnvironment:779 ENVIRONMENT DUMP - END
>
>
> Can someone help please?
> Thanks!
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/MHBAPSJOFLAWFMBT4HPJAZUYB3ODL7BX/
>

[ovirt-users] Re: Power Management on IBM AC922 Power9 (ppc64le)

2020-06-09 Thread Eli Mesika
On Fri, Jun 5, 2020 at 7:32 AM Vinícius Ferrão via Users 
wrote:

> Hello,
>
> I would like to know how to enable Power Management on AC922 hardware from
> IBM. It’s ppc64le architecture and runs OpenBMC as manager.
>
> I only get Test failed: Internal JSON-RPC error when adding the infos with
> ipmilan on the engine. From the command line I can use ipmitool but without
> specifying any user. On the Engine I must specify an user. There’s no way
> to leave it blank.
>

Yes, oVirt requires that you will authenticate against the fencing card
although I see in the fence_ipmilan script man page that it has a
*auth *parameter
that can be set to *"auth=none" *to bypass this authentication, so maybe we
should enabled blank user/password if this flag is given in the options
field ...



>
> Thanks,
>
>
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/5THZCU737LSCVOGLUF3INB5DEKWO56YD/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/NL44CRYCCCZCXKMX6MF6PYO4P2MMDZF6/


[ovirt-users] Re: VDSM host1/2/3 command GetStorageDeviceListVDS failed: Internal JSON-RPC error: {'reason': 'device is already in tree'}

2020-06-03 Thread Eli Mesika
HI

can you please attach engine and VDSM logs ?

Thanks

On Wed, Jun 3, 2020 at 4:41 PM Radoslav Milanov 
wrote:

> Hello
>
> I have oVirt 4.4 HCI/Gluster, 3 hosts and cluster is working but I'm
> getting those errors in log:
>
> VDSM host1/2/3 command GetStorageDeviceListVDS failed: Internal JSON-RPC
> error: {'reason': 'device is already in tree'}
>
> for all 3 hosts.
>
> Thank you.
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/ZK3VX3HM6VQYWEJAQMZ2WIEANMIZ7D7T/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/DP54JSLBZDYGN5EWPJPBTHJCHQEEW3AO/


[ovirt-users] Re: storage domain cross data center status

2020-05-23 Thread Eli Mesika
IIRC its "storage_domain_shared_status" of the storage_domains table

Here is how to look for example for all the columns that are like
"*status*" from psql prompt :

select table_name, column_name  from information_schema.columns where
column_name ilike '%status%' order by table_name;



On Fri, May 22, 2020 at 4:41 PM Николай Чаплинский  wrote:

> Hello!
> Wich table in ovirt database contains column with "cross data center
> status" оf Storage Domains?
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/E7RJA5P7UYOMHJ3E42S4YCSXPAQKXBFK/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/C2ZNHAESTVIPM7BKBMB7U3S7DXAP6CXR/


[ovirt-users] Re: how to save stateless disk

2020-05-23 Thread Eli Mesika
Hi

I have just tried that on 4.4 latest development environment and I am able
to create a snapshot on a stateless VM

On Fri, May 22, 2020 at 1:54 PM Jiří Sléžka  wrote:

> Hi,
>
> I have one vm configured as stateless (useful for example for testing
> ansible deploying). But now I am in the middle of work and we have
> planned power outage. If I power down this wm now I will lost my work.
>
> It looks like I am unable to create snapshot if vm is in stateless
> state. Is there any trick how to not loose my stateless state?
>
> Is it RFE worth problem?
>
> Cheers,
>
> Jiri
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/BZCJI4U3WQ22AHUU234TSNN5ZXJLXXCP/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/35TGT2ZD3CNYJMO6B57WR7PA5DVFAQWU/


[ovirt-users] Re: searching in manager

2020-05-23 Thread Eli Mesika
Hi Jiří

Can you please try :

Storage.name = "RHEV-SlowStorage" or Storage.name = "RHEV-MidStorage"


On Fri, May 22, 2020 at 1:34 PM Jiří Sléžka  wrote:

> Hi,
>
> oVirt 4.3.9.4-1.el7
>
> I am trying to search a vms which has storage domain other than
> RHEV-SSDStorage so I entered this search string in Manager in Compute /
> Virtual Machines search form.
>
> Storage != "RHEV-SSDStorage"
>
> but it looks like all vms are listed.
>
> When I try...
>
> Storage = "RHEV-SSDStorage"
>
> ...it works like expected and only right vms are listed.
>
> Also combinations seems does not work.
>
> Storage = "RHEV-SlowStorage" or Storage = "RHEV-MidStorage"
>
> ...returns 0 rows.
>
> Should it work?
>
> Cheers,
>
> Jiri
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@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/RVFGTGGM75U2M4ENW2K4DWFK34BPWJWH/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/OMFUMT6GSBBKELGLUP32IITLUT7OWCKY/


[ovirt-users] Re: Add LDAP user : ERROR: null value in column "external_id" violates not-null constraint

2020-02-20 Thread Eli Mesika
Hi

Can you please attach engine.log

On Mon, Feb 17, 2020 at 10:58 AM Lucas Lamy  wrote:

> Anybody ?
> ___
> 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/GKIO3ACQSZQMM5G2LTO4Q2B2HPKCQFAU/
>
___
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/5M5Q7DBR34SKEBSX6ORRFLJKTTTVKPCN/


[ovirt-users] Re: Power Management - drac5

2020-02-09 Thread Eli Mesika
On Mon, Feb 3, 2020 at 9:13 PM  wrote:

> I have iDrac 6 and 7. It didn't work for me. I will retry to verify but I
> get json error.
>

Can you please attach engine.log and vdsm.log of the host that served as a
proxy for the fencing operation?

>
> Eric Evans
> Digital Data Services LLC.
> 304.660.9080
>
>
> -Original Message-
> From: Chris Adams 
> Sent: Monday, February 03, 2020 1:29 PM
> To: users@ovirt.org
> Subject: [ovirt-users] Re: Power Management - drac5
>
> For my DRAC6 servers (R610s for me), I use power management type ipmilan
> and add lanplus=1 to the options, which works for me.
>
> Once upon a time, eev...@digitaldatatechs.com 
> said:
> > I have the same issue on Dell R710's. Power management is optional and I
> don't use it. It doesn't affect it either way. I am connected to APC Smart
> UPS 3000. It will not find the apc either.
> > Any other opinions would be welcome. He's right, no documentation about
> this issue.
> >
> > Eric Evans
> > Digital Data Services LLC.
> > 304.660.9080
> >
> >
> > -Original Message-
> > From: Robert Webb 
> > Sent: Monday, February 03, 2020 12:47 PM
> > To: users 
> > Subject: [ovirt-users] Power Management - drac5
> >
> > I have 3 Dell R410's with iDrac6 Enterprise capability. I am trying to
> get power management set up but the test will not pass and I am not finding
> the docs very helpful.
> >
> > I have put in the IP, user name, password, and drac5 as the type. I have
> tested both with and without secure checked and always get, "Test failed:
> Internal JSON-RPC error".
> >
> > idrac log shows:
> >
> > 2020 Feb 3 17:41:22   os[19772]   root closing session from
> 192.168.1.12
> > 2020 Feb 3 17:41:17   os[19746]   root login from 192.168.1.12
> >
> > Can someone please guide me in the right direction?
> >
> > ___
> > 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/RKFEK2OR
> > WOODCFHYTA6WILQ7MIO2VPI2/
> > ___
> > 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/AQMP3NIF
> > JNBGETM7FZLNVUF3B6P56ZHA/
>
> --
> Chris Adams 
> ___
> 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/Q6GAFCJ3QUKM3F4G76BPKDXOSXIS4ZVQ/
> ___
> 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/QKASWU3OD2KQSH7AKEHN365RXGLKGCVW/
>
___
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/O3SNS65CJMJ6DL3PE552TPESUMVBYMCK/


[ovirt-users] Re: SPM contending loop

2020-01-14 Thread Eli Mesika
On Tue, Jan 14, 2020 at 4:33 AM Jayme  wrote:

> My cluster appears to be experiencing an SPM problem. I recently placed
> each host in maintenance to move the ovirt management network to another
> interface.  All was successful and all VMs are currently running.  However,
> I'm not facing an SPM contending loop with data center going in and out of
> responsive status.
>
> I have a 3 server HCI setup and all volumes are active and healed, there
> are no unsynced entries or split brains.
>
> Does anyone know how I could diagnose the SPM issue?
>

Can you please try to select the host from web admin and make it SPM
manually ???



>
> engine.log:
>
> 2020-01-13 22:24:54,777-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterTasksListVDSCommand]
> (DefaultQuartzScheduler2) [213adf4f] START,
> GlusterTasksListVDSCommand(HostName = Orchard0,
> VdsIdVDSCommandParametersBase:{hostId='771c67eb-56e6-4736-8c67-668502d4ecf5'}),
> log id: 349f80a9
> 2020-01-13 22:24:55,231-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterTasksListVDSCommand]
> (DefaultQuartzScheduler2) [213adf4f] FINISH, GlusterTasksListVDSCommand,
> return: [], log id: 349f80a9
> 2020-01-13 22:24:58,245-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterServersListVDSCommand]
> (DefaultQuartzScheduler3) [4f66c75b] START,
> GlusterServersListVDSCommand(HostName = Orchard0,
> VdsIdVDSCommandParametersBase:{hostId='771c67eb-56e6-4736-8c67-668502d4ecf5'}),
> log id: 7b04f110
> 2020-01-13 22:24:58,887-04 INFO
>  [org.ovirt.engine.core.vdsbroker.vdsbroker.HSMGetAllTasksStatusesVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-72) [] Command
> 'org.ovirt.engine.core.vdsbroker.vdsbroker.HSMGetAllTasksStatusesVDSCommand'
> return value '
> TaskStatusListReturn:{status='Status [code=654, message=Not SPM]'}
> '
> 2020-01-13 22:24:58,888-04 INFO
>  [org.ovirt.engine.core.vdsbroker.vdsbroker.HSMGetAllTasksStatusesVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-72) [] HostName = Orchard1
> 2020-01-13 22:24:58,888-04 ERROR
> [org.ovirt.engine.core.vdsbroker.vdsbroker.HSMGetAllTasksStatusesVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-72) [] Command
> 'HSMGetAllTasksStatusesVDSCommand(HostName = Orchard1,
> VdsIdVDSCommandParametersBase:{hostId='fb1e62d5-1dc1-4ccc-8b2b-cf48f7077d0d'})'
> execution failed: IRSGenericException: IRSErrorException:
> IRSNonOperationalException: Not SPM
> 2020-01-13 22:24:59,034-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterServersListVDSCommand]
> (DefaultQuartzScheduler3) [4f66c75b] FINISH, GlusterServersListVDSCommand,
> return: [10.12.0.220/24:CONNECTED, orchard1.grove.silverorange.com:CONNECTED,
> orchard2.grove.silverorange.com:DISCONNECTED], log id: 7b04f110
> 2020-01-13 22:24:59,049-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterServersListVDSCommand]
> (DefaultQuartzScheduler3) [4f66c75b] START,
> GlusterServersListVDSCommand(HostName = Orchard2,
> VdsIdVDSCommandParametersBase:{hostId='fd0752d8-2d41-45b0-887a-0ffacbb8a237'}),
> log id: 43f1dd82
> 2020-01-13 22:24:59,099-04 INFO
>  [org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-72) [] START,
> ConnectStoragePoolVDSCommand(HostName = Orchard1,
> ConnectStoragePoolVDSCommandParameters:{hostId='fb1e62d5-1dc1-4ccc-8b2b-cf48f7077d0d',
> vdsId='fb1e62d5-1dc1-4ccc-8b2b-cf48f7077d0d',
> storagePoolId='a45e442e-9989-11e8-b0e4-00163e4bf18a', masterVersion='1'}),
> log id: 2b397b31
> 2020-01-13 22:24:59,099-04 INFO
>  [org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-72) [] Executing with
> domain map: {edc68a7c-7604-47e6-89bc-3738d727e8fc=active,
> 23c22a0f-0482-425e-8ada-730cf8ec0751=active,
> 390c0320-e843-4ff3-a4bb-a9973058447f=active,
> fb43d33a-82c8-44cb-8169-090cd0d8f56e=active,
> d70b171e-7488-4d52-8cad-bbc581dbf16e=active,
> 1f2e9989-9ab3-43d5-971d-568b8feca918=active}
> 2020-01-13 22:24:59,850-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterServersListVDSCommand]
> (DefaultQuartzScheduler3) [4f66c75b] FINISH, GlusterServersListVDSCommand,
> return: [10.12.0.222/24:CONNECTED, 10.11.0.220:CONNECTED,
> orchard1.grove.silverorange.com:CONNECTED], log id: 43f1dd82
> 2020-01-13 22:24:59,852-04 INFO
>  [org.ovirt.engine.core.vdsbroker.gluster.GlusterVolumesListVDSCommand]
> (DefaultQuartzScheduler3) [4f66c75b] START,
> GlusterVolumesListVDSCommand(HostName = Orchard0,
> GlusterVolumesListVDSParameters:{hostId='771c67eb-56e6-4736-8c67-668502d4ecf5'}),
> log id: 263be6f8
> 2020-01-13 22:25:00,019-04 INFO
>  [org.ovirt.engine.core.vdsbroker.vdsbroker.ConnectStoragePoolVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-72) [] FINISH,
> ConnectStoragePoolVDSCommand, return: , log id: 2b397b31
> 2020-01-13 22:25:00,036-04 INFO
>  [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxy]
> 

[ovirt-users] Re: Power management and storage domains error when running Ansible tasks!

2020-01-14 Thread Eli Mesika
On Sun, Jan 5, 2020 at 2:14 PM  wrote:

> I don't feel comfortable uploading the whole file with all the information
> inside it.
> I can see the following entries around power management.
>
> 2020-01-05 12:58:18,031+01 WARN
> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
> (EE-ManagedThreadFactory-engine-Thread-3) [26be9219] EVENT_ID:
> VDS_HOST_NOT_RESPONDING(9,027), Host  is not responding. Host
> cannot be fenced automatically because power management for the host is
> disabled.
> [...]
> 2020-01-05 12:58:24,435+01 WARN
> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
> (EE-ManagedThreadFactory-engineScheduled-Thread-25) [cff01c0] EVENT_ID:
> VDS_ALERT_FENCE_IS_NOT_CONFIGURED(9,000), Failed to verify Power Management
> configuration for Host .
>
> When (in the web UI) I try to activate power management for the host I get
> an error: Cannot edit Host. Power Management is enabled for Host but no
> Agent type selected.
>
> Which agent is the error talking about? Do I have to run an agent
> somewhere?
>

Please refer to [1] on how to set power management agent for your host

[1]
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.4/html/Administration_Guide/Assigning_system_administrator_role_to_a_storage_domain.html



> ___
> 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/7A5KBUZALRXP7TJR2PH2K6NMRRYFN6RK/
>
___
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/IXT3XQYEXWDAWXKTA7CF3YW3Q2ZGJJ73/


[ovirt-users] Re: Cluster CPU type update

2020-01-06 Thread Eli Mesika
On Sun, Jan 5, 2020 at 4:24 PM Strahil  wrote:

> Just a  question from curiosity.
> Can't we just define second cluster  and move each VM from old cluster  to
> the  new one ?
>

You can
If you want the VMs to be run on the new cluster host you should

1) add the new cluster
2) have at least 1 running host in this cluster (assuming that it can run
all your VMs , if not, add more hosts)
3) shut all your VMs down
4) Put all your hosts in old cluster in Maintainance, by doing so, one of
your hosts in the new cluster will switch to "Contending" and then to "SPM"
5) After that, you can run all your VMs again and it should be run by the
hosts in the new cluster

Regards
Eli



> Best Regards,
> Strahil Nikkolov
> On Jan 5, 2020 12:29, Eli Mesika  wrote:
>
> This is the right way to do that IMO
>
> On Sat, Jan 4, 2020 at 3:09 AM Morris, Roy  wrote:
>
> Hello,
>
> I'm running a 4.3 cluster with 56 VMs all set to default cluster and the
> cluster itself is set to Intel Westmere Family. I am getting a new server
> and retiring 3 old ones which brings me to my question.
>
> When implementing the new host into the cluster and retiring the older
> hosts. I want to change the CPU type setting in the cluster default to
> Broadwell which is what my new 3 host cluster will be. To make this change,
> I assume the process would be to turn off all VMs, set cluster cpu type to
> broadwell, then turn on VMs to get the new CPU flags?
>
> Just wanted to reach out and see if someone else has had to go through
> this before and has any notes/tips.
>
> Best regards,
>
> Roy
>
> ___
> 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/FKFGEOW5OI6A2U7X3TM57UUANL7UPGKW/
>
>
___
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/GG5753QVHKL4HRWNNH4WFQTBSROGTN7G/


[ovirt-users] Re: Cluster CPU type update

2020-01-05 Thread Eli Mesika
This is the right way to do that IMO

On Sat, Jan 4, 2020 at 3:09 AM Morris, Roy  wrote:

> Hello,
>
> I'm running a 4.3 cluster with 56 VMs all set to default cluster and the
> cluster itself is set to Intel Westmere Family. I am getting a new server
> and retiring 3 old ones which brings me to my question.
>
> When implementing the new host into the cluster and retiring the older
> hosts. I want to change the CPU type setting in the cluster default to
> Broadwell which is what my new 3 host cluster will be. To make this change,
> I assume the process would be to turn off all VMs, set cluster cpu type to
> broadwell, then turn on VMs to get the new CPU flags?
>
> Just wanted to reach out and see if someone else has had to go through
> this before and has any notes/tips.
>
> Best regards,
>
> Roy
>
> ___
> 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/FKFGEOW5OI6A2U7X3TM57UUANL7UPGKW/
>
___
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/Z2YPHLIPMFFBDJLWULXJHRREWR33EEUR/


[ovirt-users] Re: Power management and storage domains error when running Ansible tasks!

2020-01-05 Thread Eli Mesika
On Fri, Jan 3, 2020 at 5:29 PM  wrote:

> Hello everyone,
>
> when I create a host via Ansible role "ovirt.infra" I get an error that
> power management is not enabled (red exclamation sign in the UI). My vars
> in the playbook look as follows.
>
> hosts:
> - name: delirium
>   address: delirium.home
>   cluster: Matrix
>   public_key: true
>   power_management_enabled: true
>

Can you please attach engine.log

>
> Why is power management not enabled?
> What is it used for and how do I enable it with Ansible?
>

Power management is used to automatically recover a failing host by
rebooting it using its power-management card

>
> I am trying to create a storage domain as follows.
>
> storages:
> vmdata:
>   domain_function: data
>   state: present
>   data_center: Matrix
>   localfs:
> path: /vmisos
>   host: delirium.home
> vmisos:
>   domain_function: data
>   state: present
>   data_center: Matrix
>   localfs:
> path: /vmdata
>   host: delirium.home
>
> However I get the following error.
>
> msg: Fault reason is "Incomplete parameters". Fault detail is
> "StorageDomain [storage] required for add". HTTP response code is 400.
> An exception occurred during task execution. To see the full traceback,
> use -vvv. The error was: Error: Fault reason is "Incomplete parameters".
> Fault detail is "StorageDomain [storage] required for add". HTTP response
> code is 400.
> failed: [delirium.home] (item={'key': 'vmisos', 'value': {'name': 'isos',
> 'domain_function': 'data', 'state': 'present', 'data_center': 'Matrix',
> 'localfs': {'path': '/vmdata'}, 'host': 'delirium.home'}}) => changed=false
>
> What is "storage" here? I don't see "storage" as parameter in
> https://docs.ansible.com/ansible/latest/modules/ovirt_storage_domain_module.html#ovirt-storage-domain-module
> .
>
> Kind regards
> skrzetuski
> ___
> 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/V43K5NVHZAU5HS5EUUBBAAZMVE6NVHRW/
>
___
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/DXHZTNOWO6DZZRMNHRS25GXEQ3UMKF6V/


[ovirt-users] Re: oVirt 4.2.6.1 - 4.2.6.2 upgrade fails

2018-08-14 Thread Eli Mesika
Got the env from mburman , checking 

On Tue, Aug 14, 2018 at 10:13 AM, Martin Perina  wrote:

> Adding Eli
>
> On Tue, Aug 14, 2018 at 9:03 AM, Yedidyah Bar David 
> wrote:
>
>> On Tue, Aug 14, 2018 at 9:27 AM, Maton, Brett 
>> wrote:
>> >
>> > Just tried to update my test cluster to 4.2.6.2 :
>> >
>> >
>> > [ INFO  ] Stage: Misc configuration
>> > [ INFO  ] Running vacuum full on the engine schema
>> > [ INFO  ] Running vacuum full elapsed 0:00:04.523561
>> > [ INFO  ] Upgrading CA
>> > [ INFO  ] Backing up database localhost:ovirt_engine_history to
>> > '/var/lib/ovirt-engine-dwh/backups/dwh-20180814071815.xVSlda.dump'.
>> > [ INFO  ] Creating/refreshing DWH database schema
>> > [ INFO  ] Configuring Image I/O Proxy
>> > [ INFO  ] Configuring WebSocket Proxy
>> > [ INFO  ] Backing up database localhost:engine to
>> > '/var/lib/ovirt-engine/backups/engine-20180814071825.af3Hq2.dump'.
>> > [ INFO  ] Creating/refreshing Engine database schema
>> > [ ERROR ] schema.sh: FATAL: Cannot execute sql command:
>> > --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1220_
>> default_all_search_engine_string_fields_to_not_null.sql
>> > [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema
>> > refresh failed
>> > [ INFO  ] Yum Performing yum transaction rollback
>> >
>> >
>> > May or may not be relevant in this case but /tmp and /var/tmp are
>> mounted
>> > noexec.
>>
>> I do not think this is tested regularly, but I guess it should be ok.
>>
>> > Any more logs you need let me know.
>>
>> Can you please check/share full setup log? engine-setup should output the
>> full path, it should be in /var/log/ovirt-engine/setup . Thanks.
>> --
>> Didi
>> ___
>> 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/communit
>> y/about/community-guidelines/
>> List Archives: https://lists.ovirt.org/archiv
>> es/list/users@ovirt.org/message/KQGLRAXYPMUBZMIMWDISVUHBNLV4BLHX/
>>
>
>
>
> --
> Martin Perina
> Associate Manager, Software Engineering
> Red Hat Czech s.r.o.
>
___
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/A5WFPPD55OM26V4P4MD4BDRGYZXG6LPW/


[ovirt-users] Re: ERROR: integer out of range

2018-07-22 Thread Eli Mesika
On Thu, Jul 19, 2018 at 6:42 PM, Filip Goll  wrote:

>
>
> 19. 7. 2018 v 16:52, Eli Mesika :
>
> Hi
>
> Is there a chance that one of the following Integers passed 2^32 - 1 ???
>
>
> available_disk_size   | integer
>
> - max int 5533
>
>
> confirmed_available_disk_size | integer
>
> - 
>
>
> used_disk_size| integer
>
> - max int 1851
>
>
> commited_disk_size| integer
>
> - Which table? I can’t find it
>
>
> actual_images_size| integer
>
> - Which table? I can’t find it
>


​Those are taken from the storage_domains_image_sizes view :

SELECT isdm.storage_domain_id,
(COALESCE(sum(
CASE
WHEN i.active = true AND (vfdv.entity_type IS NULL OR
vfdv.entity_type::text <> 'TEMPLATE'::text) THEN i.size
ELSE din.actual_size
END), 0::numeric) *
0.0931322574615478515625)::bigint::integer AS commited_disk_size,
(COALESCE(sum(din.actual_size), 0::numeric) *
0.0931322574615478515625)::bigint::integer AS actual_images_size
   FROM images i
 JOIN image_storage_domain_map isdm ON i.image_guid = isdm.image_id
 LEFT JOIN disk_image_dynamic din ON i.image_guid = din.image_id
 LEFT JOIN vms_for_disk_view vfdv ON i.image_group_id = vfdv.device_id
  GROUP BY isdm.storage_domain_id;

I really suspect that one of those two computations leads to the reported
overflow

​

>
>
> warning_low_space_indicator   | integer
>
> - max int 10
>
>
> critical_space_action_blocker | integer
>
> - max int 5
>
>
> warning_low_confirmed_space_indicator | integer
>
> - 
>
>
> external_status   | integer
>
> - max int 0
>
>
> I am suspecting especially all those *size* columns , please check by
> extending one by one to BigInt and check if the problem solved
>
> On Thu, Jul 19, 2018 at 2:17 PM, Martin Perina  wrote:
>
>> Hi Filip,
>>
>> could you please share with us complete engine logs using SOS log
>> collector [1] and, if possible, engine database dump, so we can investigate
>> the issue? Also do you remember any steps you have performed before this
>> issue happened?
>>
>> Thanks
>>
>> Martin
>>
>> [1] https://www.ovirt.org/documentation/admin-guide/chap-
>> Utilities/#the-log-collector-tool
>>
>>
>> From: Filip Goll <
>>> ​​
>>> biohazar...@gmail.com>
>>> Date: Thu, 19 Jul 2018 at 13:19
>>> Subject: ERROR: integer out of range
>>> To: 
>>>
>>>
>>> Dear guru’s,
>>>
>>> Do you have any idea how to fix it? I can’t list any storage domain = no
>>> data storage domain is up, so the datacenter is also down.
>>>
>>> Thats why I understand this error:
>>> On startup any virtual machine this error:
>>>
>>>- Action failed due to database connection failure. Please check
>>>connectivity to your Database server
>>>
>>>
>>> Using: Software Version:4.2.4.5-1.el7
>>>
>>>
>>> PSQL:
>>> engine=# select * from
>>> ​​
>>> storage_domains_for_search;
>>> ERROR:  integer out of range
>>>
>>> In vdsm.log is everything, but on:
>>>
>>> engine.log:
>>> 2018-07-19 11:36:51,166+02 ERROR [org.ovirt.engine.core.bll.SearchQuery]
>>> (default task-251) [0d583ed2-fcbd-4d2d-b12c-0f0532a00a85] Query
>>> 'SearchQuery' failed: StatementCallback; SQL [SELECT * FROM ((SELECT
>>> distinct storage_domains_for_search.* FROM  storage_domains_for_search  )
>>> ORDER BY storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer
>>> out of range; nested exception is org.postgresql.util.PSQLException:
>>> ERROR: integer out of range
>>> 2018-07-19 11:36:51,166+02 ERROR [org.ovirt.engine.core.bll.SearchQuery]
>>> (default task-251) [0d583ed2-fcbd-4d2d-b12c-0f0532a00a85] Exception:
>>> org.springframework.dao.DataIntegrityViolationException:
>>> StatementCallback; SQL [SELECT * FROM ((SELECT distinct
>>> storage_domains_for_search.* FROM  storage_domains_for_search  )  ORDER BY
>>> storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer out of
>>> range; nested exception is org.postgresql.util.PSQLException: ERROR:
>>> integer out of range
>>> at org.springframework.jdbc.support.SQLStateSQLExceptionTransla
>>> tor.doTranslate(SQLStateSQLExceptionTranslator.java:102)
>>> [spring-jdbc.jar:4.3.9.RELEASE]
>>> at org.springframework

[ovirt-users] Re: ERROR: integer out of range

2018-07-19 Thread Eli Mesika
Hi

Is there a chance that one of the following Integers passed 2^32 - 1 ???


available_disk_size   | integer
confirmed_available_disk_size | integer
used_disk_size| integer
commited_disk_size| integer
actual_images_size| integer
warning_low_space_indicator   | integer
critical_space_action_blocker | integer
warning_low_confirmed_space_indicator | integer
external_status   | integer

I am suspecting especially all those *size* columns , please check by
extending one by one to BigInt and check if the problem solved

On Thu, Jul 19, 2018 at 2:17 PM, Martin Perina  wrote:

> Hi Filip,
>
> could you please share with us complete engine logs using SOS log
> collector [1] and, if possible, engine database dump, so we can investigate
> the issue? Also do you remember any steps you have performed before this
> issue happened?
>
> Thanks
>
> Martin
>
> [1] https://www.ovirt.org/documentation/admin-guide/
> chap-Utilities/#the-log-collector-tool
>
>
> From: Filip Goll <
>> ​​
>> biohazar...@gmail.com>
>> Date: Thu, 19 Jul 2018 at 13:19
>> Subject: ERROR: integer out of range
>> To: 
>>
>>
>> Dear guru’s,
>>
>> Do you have any idea how to fix it? I can’t list any storage domain = no
>> data storage domain is up, so the datacenter is also down.
>>
>> Thats why I understand this error:
>> On startup any virtual machine this error:
>>
>>- Action failed due to database connection failure. Please check
>>connectivity to your Database server
>>
>>
>> Using: Software Version:4.2.4.5-1.el7
>>
>>
>> PSQL:
>> engine=# select * from
>> ​​
>> storage_domains_for_search;
>> ERROR:  integer out of range
>>
>> In vdsm.log is everything, but on:
>>
>> engine.log:
>> 2018-07-19 11:36:51,166+02 ERROR [org.ovirt.engine.core.bll.SearchQuery]
>> (default task-251) [0d583ed2-fcbd-4d2d-b12c-0f0532a00a85] Query
>> 'SearchQuery' failed: StatementCallback; SQL [SELECT * FROM ((SELECT
>> distinct storage_domains_for_search.* FROM  storage_domains_for_search  )
>> ORDER BY storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer
>> out of range; nested exception is org.postgresql.util.PSQLException:
>> ERROR: integer out of range
>> 2018-07-19 11:36:51,166+02 ERROR [org.ovirt.engine.core.bll.SearchQuery]
>> (default task-251) [0d583ed2-fcbd-4d2d-b12c-0f0532a00a85] Exception:
>> org.springframework.dao.DataIntegrityViolationException:
>> StatementCallback; SQL [SELECT * FROM ((SELECT distinct
>> storage_domains_for_search.* FROM  storage_domains_for_search  )  ORDER BY
>> storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer out of
>> range; nested exception is org.postgresql.util.PSQLException: ERROR:
>> integer out of range
>> at org.springframework.jdbc.support.SQLStateSQLExceptionTransla
>> tor.doTranslate(SQLStateSQLExceptionTranslator.java:102)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
>> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
>> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
>> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:474)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:484)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.ovirt.engine.core.dao.StorageDomainDaoImpl.getAllWithQue
>> ry(StorageDomainDaoImpl.java:115) [dal.jar:]
>> at org.ovirt.engine.core.bll.SearchQuery.genericSearch(SearchQuery.java:344)
>> [bll.jar:]
>> at 
>> org.ovirt.engine.core.bll.SearchQuery.searchStorageDomain(SearchQuery.java:393)
>> [bll.jar:]
>> at 
>> org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:204)
>> [bll.jar:]
>> at 
>> org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:106)
>> [bll.jar:]
>> at org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:33)
>> [dal.jar:]
>> at org.ovirt.engine.core.bll.executor.DefaultBackendQueryExecut
>> or.execute(DefaultBackendQueryExecutor.java:14) [bll.jar:]
>> at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:538)
>> [bll.jar:]
>> at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:507)
>> [bll.jar:]
>> at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
>> [:1.8.0_171]
>> at 
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> [rt.jar:1.8.0_171]
>> at java.lang.reflect.Method.invoke(Method.java:498) 

[ovirt-users] Re: Ovirt 4.2.4 upgrade

2018-05-27 Thread Eli Mesika
Hi

The provider_binding_host_id is a new table added recently , can you please
attach the output of the following query on your database :

select * from schema_version order by id desc;

Thanks

On Fri, May 25, 2018 at 2:30 PM, Maton, Brett 
wrote:

> It would be from the last 4.2.3 release in the ovirt-4.2-pre repositories
>
> I haven't got the logs unfortunately, I'll try to recreate the scenario
> over the weekend.
>
> On 25 May 2018 at 12:09, Martin Perina  wrote:
>
>> Hi,
>>
>> from which oVirt version are you upgrading to 4.2.4? Could you please
>> share with us complete upgrade logs from engine host?
>>
>> Thanks
>>
>> Martin
>>
>>
>> On Fri, May 25, 2018 at 10:38 AM, Sandro Bonazzola 
>> wrote:
>>
>>>
>>>
>>> 2018-05-25 9:41 GMT+02:00 Maton, Brett :
>>>
 The 4.2.4 upgrade appears to have a database issue, i'm seeing these
 errors in the postgresql logs:

 2018-05-24 16:27:08.292 UTC ERROR:  relation "provider_binding_host_id"
 does not exist at character 15
 2018-05-24 16:27:08.292 UTC QUERY:  SELECT 1 FROM
 provider_binding_host_id WHERE vds_id = v_vds_id FOR UPDATE
 2018-05-24 16:27:08.292 UTC CONTEXT:  PL/pgSQL function
 updatehostproviderbinding(uuid,character varying[],character
 varying[]) line 3 at PERFORM

 Any suggestions ?

>>>
>>> Thanks for having tested 4.2.4 RC1 and giving feedback! Adding Martin
>>> and Eli for further investigations.
>>>
>>>
>>>

 ___
 Users mailing list -- users@ovirt.org
 To unsubscribe send an email to users-le...@ovirt.org


>>>
>>>
>>> --
>>>
>>> SANDRO BONAZZOLA
>>>
>>> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R
>>>
>>> Red Hat EMEA 
>>>
>>> sbona...@redhat.com
>>> 
>>> 
>>>
>>
>>
>>
>> --
>> Martin Perina
>> Associate Manager, Software Engineering
>> Red Hat Czech s.r.o.
>>
>
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org


[ovirt-users] Re: Custom Intel AMT fencing question

2018-05-16 Thread Eli Mesika
On Tue, May 15, 2018 at 6:50 PM, Shawn Southern <shawn.south...@entegrus.com
> wrote:

> Thanks for this!
>
> I’ve got fence_amt_ws working fine, however the document you linked
> mentions creating a script, and I’m not sure how I’m to pass the various
> parameters (host to fence, etc.) to this script.  From the doc, I'm looking
> at:
>
​It's not creating , rather using the engine-config tool to set a custom
fence agent ​


>
> engine-config -s CustomVdsFenceType="amt"
> engine-config -s CustomVdsFenceOptionMapping="amt:port=ipport"
> engine-config -s CustomFencePowerWaitParam="amt=power_wait"
>
> Will this pass a parameter called ipport that has the IP address or
> hostname of the host to fence to my script (which in this case is
> /usr/sbin/fence_amt)?
>

​Should work after restarting the agent , if not , please attach the
engine.log
​


>
> - original message -
> From: Martin Perina <mper...@redhat.com>
> Sent: May 15, 2018 4:20 AM
> To: Shawn Southern <shawn.south...@entegrus.com>; Eli Mesika <
> emes...@redhat.com>
> Cc: users <users@ovirt.org>
> Subject: Re: [ovirt-users] Custom Intel AMT fencing question
>
>
>
> On Mon, May 14, 2018 at 8:13 PM, Shawn Southern <mailto:shawn.southern@
> entegrus.com> wrote:
> I'm now using Intel AMT and the wsmancli package to reboot/power off/power
> on my entry level systems... but now I want oVirt to use this for fencing.
>
> I created 3 xml files: powercycle.xml (uses PowerState 10), poweron.xml
> (uses PowerState 2) and poweroff.xml (uses PowerState 8).  Here is the
> poweroff.xml file:
> http://schemas.dmtf.
> org/wbem/wscim/1/cim-schema/2/CIM_PowerManagementService">
>   8
>   http://schemas.xmlsoap.org/ws/2004/08/
> addressing"
> xmlns:wsman="http://schemas.dmtf.org/wbem/wsman/1/wsman.xsd;>
> http://schemas.xmlsoap.org/ws/2004/08/
> addressing/role/anonymous
> 
>   http://schemas.dmtf.org/wbem/wscim/1/
> cim-schema/2/CIM_ComputerSystem
>   
> CIM_
> ComputerSystem
> ManagedSystem
>   
> 
>   
> 
>
> I can then reboot or power on/off the server with:
> wsman invoke -a RequestPowerStateChange http://schemas.dmtf.org/wbem/
> wscim/1/cim-schema/2/CIM_PowerManagementService -h [AMT IP] -P 16992 -u
> admin -p [amt password] -J /fencing/poweron.xml  (or poweroff.xml, etc).
>
> My question is, how do I move from this to using this for fencing in oVirt?
>
> ​At the moment oVirt doesn't officially support AMT as fence agent. But
> I've just looked that on CentOS 7 we already have fence-agents-amt-ws
> package, so please try to install fence-agents-amt-ws package and test if
> it's working for your server​.
>
> If above agent is working fine, then please take a look Custom Fencing
> oVirt feature [1], which should allow you to use fence_agent_amt_ws agent
> in oVirt. Am I right Eli?
>
> Regards
>
> Martin
>
>
> [1] https://www.ovirt.org/develop/developer-guide/engine/custom-fencing/
>
>
> Thanks!
> ___
> Users mailing list -- mailto:users@ovirt.org
> To unsubscribe send an email to mailto:users-le...@ovirt.org
>
>
>
> --
> Martin Perina
> Associate Manager, Software Engineering
> Red Hat Czech s.r.o.
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org


[ovirt-users] Re: Custom Intel AMT fencing question

2018-05-16 Thread Eli Mesika
On Tue, May 15, 2018 at 11:20 AM, Martin Perina  wrote:

>
>
> On Mon, May 14, 2018 at 8:13 PM, Shawn Southern <
> shawn.south...@entegrus.com> wrote:
>
>> I'm now using Intel AMT and the wsmancli package to reboot/power
>> off/power on my entry level systems... but now I want oVirt to use this for
>> fencing.
>>
>> I created 3 xml files: powercycle.xml (uses PowerState 10), poweron.xml
>> (uses PowerState 2) and poweroff.xml (uses PowerState 8).  Here is the
>> poweroff.xml file:
>> http://schemas.dmtf.o
>> rg/wbem/wscim/1/cim-schema/2/CIM_PowerManagementService">
>>   8
>>   http://schemas.xmls
>> oap.org/ws/2004/08/addressing"
>> xmlns:wsman="http://schemas.dmtf.org/wbem/wsman/1/wsman.xsd;>
>> http://schemas.xmlsoap.org/ws/2004/08/addressin
>> g/role/anonymous
>> 
>>   http://schemas.dmtf.org/wbem/wscim/1/cim-
>> schema/2/CIM_ComputerSystem
>>   
>> CIM_C
>> omputerSystem
>> ManagedSystem
>>   
>> 
>>   
>> 
>>
>> I can then reboot or power on/off the server with:
>> wsman invoke -a RequestPowerStateChange http://schemas.dmtf.org/wbem/w
>> scim/1/cim-schema/2/CIM_PowerManagementService -h [AMT IP] -P 16992 -u
>> admin -p [amt password] -J /fencing/poweron.xml  (or poweroff.xml, etc).
>>
>> My question is, how do I move from this to using this for fencing in
>> oVirt?
>>
>
> ​At the moment oVirt doesn't officially support AMT as fence agent. But
> I've just looked that on CentOS 7 we already have fence-agents-amt-ws
> package, so please try to install fence-agents-amt-ws package and test if
> it's working for your server​.
>
> ​Yes, should work
>

> Regards
>
> Martin
>
>
> [1] https://www.ovirt.org/develop/developer-guide/engine/custom-fencing/
>
>
>> Thanks!
>> ___
>> Users mailing list -- users@ovirt.org
>> To unsubscribe send an email to users-le...@ovirt.org
>>
>
>
>
> --
> Martin Perina
> Associate Manager, Software Engineering
> Red Hat Czech s.r.o.
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org


Re: [ovirt-users] Decrease downtime for HA

2018-04-25 Thread Eli Mesika
On Mon, Apr 23, 2018 at 8:06 PM, Michal Skrivanek <
michal.skriva...@redhat.com> wrote:

>
>
> On 23 Apr 2018, at 10:52, Daniel Menzel 
> wrote:
>
> Hi Michal,
>
> in your last mail you wrote, that the values can be turned down - how can
> this be done?
> ​H
>
> ​AFAIK , there is no point in changing fencing vdc_options values in that
case (assuming no kdump is configured here ...)

The Fencing mechanism ​

​is putting the host in "connecting" state for a grace period that depends
on its number of running VMs and if it serves as APM or not
While the host became non-responding , we first try to do a soft-fence
(restart VDSM via ssh) , this will also take time
After that point , if soft-fence is failing , the host will be reboot via
the fencing script and the time it takes is totally depending ​on the host
If you have something to look at , it is your host reboot time and try to
improve it, if the host will reboot faster, the whole process will take
less time ...

Regards

Eli

​
>
>
> Best
> Daniel
>
> On 12.04.2018 20:29, Michal Skrivanek wrote:
>
>
>
> On 12 Apr 2018, at 13:13, Daniel Menzel 
> wrote:
>
> Hi there,
>
> does anyone have an idea how to decrease a virtual machine's downtime?
>
> Best
> Daniel
>
> On 06.04.2018 13:34, Daniel Menzel wrote:
>
> Hi Michal,
>
>
> Hi Daniel,
> adding Martin to review fencing behavior
>
> (sorry for misspelling your name in my first mail).
>
>
> that’s not the reason I’m replying late!:-))
>
> The settings for the VMs are the following (oVirt 4.2):
>
>1. HA checkbox enabled of course
>2. "Target Storage Domain for VM Lease" -> left empty
>
>
> if you need faster reactions then try to use VM Leases as well, it won’t
> make a difference in this case but will help in case of network issues.
> E.g. if you use iSCSI and the storage connection breaks while host
> connection still works it would restart the VM in about 80s; otherwise it
> would take >5 mins.
>
>
>1. "Resume Behavior" -> AUTO_RESUME
>2. Priority for Migration -> High
>3. "Watchdog Model" -> No-Watchdog
>
> For testing we did not kill any VM but the host. So basically we simulated
> an instantaneous crash by manually turning the machine off via
> IPMI-Interface (not via operating system!) and ping the guest(s). What
> happens then?
>
>1. 2-3 seconds after the we press the host's shutdown button we lose
>ping contact to the VM(s).
>2. After another 20s oVirt changes the host's status to "connecting",
>the VM's status is set to a question mark.
>3. After ~1:30 the host is flagged to "non responsive”
>
>
> that sounds about right. Now fencing action should have been initiated, if
> you can share the engine logs we can confirm that. IIRC we first try soft
> fencing - try to ssh to that host, that might take some time to time out I
> guess. Martin?
>
>
>1.
>2. After ~2:10 the host's reboot is initiated by oVirt, 5-10s later
>the guest is back online.
>
> So, there seems to be one mistake I made in the first mail: The downtime
> is "only" 2.5min. But still I think this time can be decreased as for some
> services it is still quite a long time.
>
>
> these values can be tuned down, but then you may be more susceptible to
> fencing power cycling a host in case of shorter network outages. It may be
> ok…depending on your requirements.
>
> Best
> Daniel
>
> On 06.04.2018 12:49, Michal Skrivanek wrote:
>
> On 6 Apr 2018, at 12:45, Daniel Menzel  
>  wrote:
>
> Hi Michael,
> thanks for your mail. Sorry, I forgot to write that. Yes, we have power 
> management and fencing enabled on all hosts. We also tested this and found 
> out that it works perfectly. So this cannot be the reason I guess.
>
> Hi Daniel,
> ok, then it’s worth looking into details. Can you describe in more detail 
> what happens? What exact settings you’re using for such VM? Are you killing 
> the HE VM or other VMs or both? Would be good to narrow it down a bit and 
> then review the exact flow
>
> Thanks,
> michal
>
>
> Daniel
>
>
>
> On 06.04.2018 11:11, Michal Skrivanek wrote:
>
> On 4 Apr 2018, at 15:36, Daniel Menzel  
>  wrote:
>
> Hello,
>
> we're successfully using a setup with 4 Nodes and a replicated Gluster for 
> storage. The engine is self hosted. What we're dealing with at the moment is 
> the high availability: If a node fails (for example simulated by a forced 
> power loss) the engine comes back up online withing ~2min. But guests (having 
> the HA option enabled) come back online only after a very long grace time of 
> ~5min. As we have a reliable network (40 GbE) and reliable servers I think 
> that the default grace times are way too high for us - is there any 
> possibility to change those values?
>
> And do you have Power Management(iLO, iDRAC,etc) configured for your hosts? 
> 

Re: [ovirt-users] Configuring ilo4 on hp blade gen 9

2017-10-15 Thread Eli Mesika
On Thu, Oct 5, 2017 at 1:58 PM, Martin Perina  wrote:

>
>
> On Thu, Oct 5, 2017 at 11:38 AM, Gianluca Cecchi <
> gianluca.cec...@gmail.com> wrote:
>
>> On Thu, Oct 5, 2017 at 11:04 AM, Martin Perina 
>> wrote:
>>
>>>
>>>
>>>
>>> ​Please take a look at man page of fence_ilo_ssh and scroll down to
>>> STDIN  PARAMETERS section. These parameters needs to be used in Options
>>> field in webadmin
>>> ​
>>>
>>
>> It seems on ovirt node the man pages are missing, probably to cut off
>> installation base.. ;-)
>>
>
> ​Unfortunately you are right, space saving :-(
> ​
>
>
>> Anyway I would check installing the ordinary rpm package on a base CentOS
>> 7 system.
>> In the mean time I have checked the STDIN  PARAMETERS section of
>> fence_ilo4 man page for a CentOS  6.7 clustersuite server I have at hand,
>> thanks. I think it should be similar
>>
>
> ​They should be more or less the same ...
> ​
>
>
>>
>>
>>
 All in all do you think it is the best agent for ilo4 based blades?

>>>
>>> ​Yes, according to our knowledge ilo4 should be used for all new HP
>>> servers (and also ilo4 agent has most of default parameters, so if you
>>> don't have some special configuration on your server you should be fine.
>>> ​
>>>
>>>
 I have made some test with fence_ilo4 but unable to get success... what
 should I enable on ilo web administration page in this case, if you think
 the agent would be better for any reason?

>>>
>>> ​If you are using admin user, then the default should be fine. If you
>>> are want to create a special user just for oVirt PM operations then
>>> following permissions needs to be assigned to user within iLO4
>>> configuration​:
>>>
>>>   Virtual power and reset
>>>   Remote Console Access
>>>   Virtual Media
>>>
>>> And you need to add following into Options for the host PM settings:
>>>
>>>   privlvl=operator
>>>
>>> ​
>>> Thanks
>>>
>>> Martin​
>>>
>>>
>> Perfect: it works.
>> Assigned the three privileges to the fenceuser user and now the
>> corresponding command line works
>>
>> # fence_ilo4 -a ilo_ip -l fenceuser -L operator -S
>> /usr/local/bin/my_fence_script.sh -o status
>> Status: ON
>> #
>>
>> And also from gui the test is ok using ilo4 type and
>> "privlvl=operator,inet4_only=1" option
>>
>
> ​Great to hear!
> ​
>
>
>>
>> BTW: for the fence_ilo_ssh agent it is enough to have only the "Virtual
>> power and reset" privilege for the dedicated user (at least to get the
>> status of the blade)
>>
>
​That's right, but engine will fail to restart the server in case it is not
responding if not all 3 are set ​

>
> ​Thanks for info!
>
> Martin
> ​
>
>
>>
>> Thanks again,
>> Gianluca
>>
>>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Help with Power Management network

2017-10-01 Thread Eli Mesika
On Sat, Sep 30, 2017 at 2:51 PM, Dan Yasny  wrote:

> The power management command is sent by the engine via a proxy host. That
> means you need at least one more host to act as proxy. The engine itself
> doesn't need to access the bmc network directly. Just like the engine needs
> no access to the atorage network to perform storage manipulations.
>
> I think in some recent versions fencing by the engine was introduced, but
> I don't have a setup in front of me to verify.
>

​No, this is an open RFE which we didn't apply yet and as far as I know
there is no plan for that in the near future.
So, currently there is a need for an additional host that will serve as a
proxy to the fencing operation.​
The main reason for the existence of the proxy host  is when a host that
has power management configure becomes non-responsive
In that case we might restart the host via its power management card
But, since this host may have some HA VMs that will be migrated to another
host before the problematic host is rebooted, we have to implement a
shutdown->wait for OFF status from PM card->migrate HA VMs->start->wait for
ON status from PM card
This is done in order to prevent running a VM on two hosts which will cause
corruption (brain split)




>
> On Sep 29, 2017 11:13 PM, "~Stack~"  wrote:
>
>> On 09/29/2017 05:31 PM, Dan Yasny wrote:
>> > You need more than one host for power management
>> >
>>
>> Seriously?? I didn't see anything like that in the docs...Maybe I just
>> missed it.
>>
>> Also, why wouldn't it still validate? It should still be able to talk to
>> the interface over the BMC/IPMI network. The fact that I can run the
>> equivalent test on the command line makes it seem like it should at
>> least be able to check via the test. Obviously, it would be silly for it
>> to try to manage itself, but it could at least verify that the
>> configuration is valid, right?
>>
>> I have more hosts that I'm going to add, I was just hoping to do those
>> via the Foreman integration instead of manually building them. Since I'm
>> not quite ready for that, I will just build a second host on Monday and
>> report back.
>>
>> Thanks for the feedback. I would have never guess that as a possibility.
>> :-)
>>
>> ~Stack~
>>
>>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Slow booting host - restart loop

2017-09-06 Thread Eli Mesika
Hi

try from shell prompt

PGPASSWORD= psql -U engine -c "update vdc_options set
option_value = '900' where option_name =
'FenceQuietTimeBetweenOperationsInSec';"
engine

On Tue, Sep 5, 2017 at 6:34 PM, Bernardo Juanicó <bjuan...@gmail.com> wrote:

> Hi Eli,
>
> I could not access the psql prompt, i tried with the credentials and
> values on /etc/ovirt-engine/engine.conf.d/10-setup-database.conf.
>
> I tried interactively and also with a .pgpass file containing:
> localhost:5432:engine:engine:PASSWORD
>
> And i get the following error:
>
> psql: FATAL:  Peer authentication failed for user "engine"
>
> Thanks!
>
> Bernardo
>
>
> PGP Key <http://pgp.mit.edu/pks/lookup?op=get=0x695E5BCE34263F5B>
> Skype: mattraken
>
> 2017-09-05 12:14 GMT-03:00 Eli Mesika <emes...@redhat.com>:
>
>> Hi Bernardo
>>
>> I would like to suggest a workaround to this problem , can you please
>> check that :
>>
>> We have a configuration value named FenceQuietTimeBetweenOperationsInSec.
>> It controls the minimal timeout to wait between fence operation (stop,
>> start),
>> currently, it is defaulted to 180 sec , The key is not exposed to
>> engine-config, so, I would suggest to
>>
>> 1) Change this key value to 900 by running the following from psql prompt
>> :
>>
>> update vdc_options set option_value = '900' where option_name =
>> 'FenceQuietTimeBetweenOperationsInSec';
>>
>> 2) Restart the engine
>>
>> 3) Repeat the scenario
>>
>> Now, the engine will require 15 min between fencing operations and your
>> host can be up again without being fenced again.
>>
>> Please let me know if this workaround is working for you
>>
>> Thanks
>>
>> Eli
>>
>> On Tue, Sep 5, 2017 at 4:20 PM, Bernardo Juanicó <bjuan...@gmail.com>
>> wrote:
>>
>>> Martin, thanks for your reply, i was aware of the [1] BUG and the
>>> implemented solution, changing ServerRebootTimeout to 1200 didnt change a
>>> thing...
>>> Now i know about [2] and ill test the fix once it gets released.
>>>
>>> Regards,
>>>
>>> Bernardo
>>>
>>> PGP Key <http://pgp.mit.edu/pks/lookup?op=get=0x695E5BCE34263F5B>
>>> Skype: mattraken
>>>
>>> 2017-09-05 8:23 GMT-03:00 Martin Perina <mper...@redhat.com>:
>>>
>>>> Hi Bernardo,
>>>>
>>>> we have added timeout to wait until host is booted [1] in oVirt 4.1.2.
>>>> This timeout is by default 5 minutes, but it can be extended using
>>>> following command:
>>>>
>>>>engine-config -s ServerRebootTimeout=NNN
>>>>
>>>> where NNN is number of seconds you want to wait until host is booted up.
>>>>
>>>> But be aware that you may be affected by [2], which we are currently
>>>> trying to fix.
>>>>
>>>> Regards
>>>>
>>>> Martin Perina
>>>>
>>>>
>>>> [1] https://bugzilla.redhat.com/show_bug.cgi?id=1423657
>>>> [2] https://bugzilla.redhat.com/show_bug.cgi?id=1477700
>>>>
>>>>
>>>> On Fri, Sep 1, 2017 at 7:54 PM, Bernardo Juanicó <bjuan...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi everyone,
>>>>>
>>>>> I installed 2 hosts on a new cluster and the servers take a really
>>>>> long to boot up (about 8 minutes).
>>>>>
>>>>> When a host crashes or is powered off the ovirt-manager starts it via
>>>>> power management, since the servers takes all that time to boot up the
>>>>> ovirt-manager thinks it failed to start and proceeds to reboot it, several
>>>>> times before giving up, when the server is finally started (about 20
>>>>> minutes after the failure)
>>>>>
>>>>> I changed some engine variables with engine-config trying to set a
>>>>> higher timeout, but the problem persists.
>>>>>
>>>>> Any ideas??
>>>>>
>>>>>
>>>>> Regards,
>>>>> Bernardo
>>>>>
>>>>>
>>>>> PGP Key
>>>>> <http://pgp.mit.edu/pks/lookup?op=get=0x695E5BCE34263F5B>
>>>>> Skype: mattraken
>>>>>
>>>>> ___
>>>>> Users mailing list
>>>>> Users@ovirt.org
>>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>>
>>>>>
>>>>
>>>
>>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Slow booting host - restart loop

2017-09-05 Thread Eli Mesika
Hi Bernardo

I would like to suggest a workaround to this problem , can you please check
that :

We have a configuration value named FenceQuietTimeBetweenOperationsInSec.
It controls the minimal timeout to wait between fence operation (stop,
start),
currently, it is defaulted to 180 sec , The key is not exposed to
engine-config, so, I would suggest to

1) Change this key value to 900 by running the following from psql prompt :

update vdc_options set option_value = '900' where option_name =
'FenceQuietTimeBetweenOperationsInSec';

2) Restart the engine

3) Repeat the scenario

Now, the engine will require 15 min between fencing operations and your
host can be up again without being fenced again.

Please let me know if this workaround is working for you

Thanks

Eli

On Tue, Sep 5, 2017 at 4:20 PM, Bernardo Juanicó  wrote:

> Martin, thanks for your reply, i was aware of the [1] BUG and the
> implemented solution, changing ServerRebootTimeout to 1200 didnt change a
> thing...
> Now i know about [2] and ill test the fix once it gets released.
>
> Regards,
>
> Bernardo
>
> PGP Key 
> Skype: mattraken
>
> 2017-09-05 8:23 GMT-03:00 Martin Perina :
>
>> Hi Bernardo,
>>
>> we have added timeout to wait until host is booted [1] in oVirt 4.1.2.
>> This timeout is by default 5 minutes, but it can be extended using
>> following command:
>>
>>engine-config -s ServerRebootTimeout=NNN
>>
>> where NNN is number of seconds you want to wait until host is booted up.
>>
>> But be aware that you may be affected by [2], which we are currently
>> trying to fix.
>>
>> Regards
>>
>> Martin Perina
>>
>>
>> [1] https://bugzilla.redhat.com/show_bug.cgi?id=1423657
>> [2] https://bugzilla.redhat.com/show_bug.cgi?id=1477700
>>
>>
>> On Fri, Sep 1, 2017 at 7:54 PM, Bernardo Juanicó 
>> wrote:
>>
>>> Hi everyone,
>>>
>>> I installed 2 hosts on a new cluster and the servers take a really long
>>> to boot up (about 8 minutes).
>>>
>>> When a host crashes or is powered off the ovirt-manager starts it via
>>> power management, since the servers takes all that time to boot up the
>>> ovirt-manager thinks it failed to start and proceeds to reboot it, several
>>> times before giving up, when the server is finally started (about 20
>>> minutes after the failure)
>>>
>>> I changed some engine variables with engine-config trying to set a
>>> higher timeout, but the problem persists.
>>>
>>> Any ideas??
>>>
>>>
>>> Regards,
>>> Bernardo
>>>
>>>
>>> PGP Key 
>>> Skype: mattraken
>>>
>>> ___
>>> Users mailing list
>>> Users@ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] NullPointerException when changing compatibility version to 4.0

2017-07-20 Thread Eli Mesika
Hi

Please attach full engine.log

On Wed, Jul 19, 2017 at 12:33 PM, Marcel Hanke 
wrote:

> Hi,
> i currently have a problem with changing one of our clusters to
> compatibility
> version 4.0.
> The Log shows a NullPointerException after several successful vms:
> 2017-07-19 11:19:45,886 ERROR [org.ovirt.engine.core.bll.UpdateVmCommand]
> (default task-31) [1acd2990] Error during ValidateFailure.:
> java.lang.NullPointerException
> at
> org.ovirt.engine.core.bll.UpdateVmCommand.validate(
> UpdateVmCommand.java:632)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.CommandBase.internalValidate(
> CommandBase.java:886)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:391)
> [bll.jar:]
> at org.ovirt.engine.core.bll.Backend.runAction(Backend.java:493)
> [bll.jar:]
> .
>
> On other Clusters with the exect same configuration the change to 4.0 was
> successfull without a problem.
> Turning off the cluster for the change is also not possible because of
> >1200
> Vms running on it.
>
> Does anyone have an idea what to do, or that to look for?
>
> Thanks
> Marcel
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] [ovirt 4.1] how to increase HA VM retry count ?

2017-07-12 Thread Eli Mesika
Hi

You have the following configuration parameters :

FenceStartStatusRetries (default 10)
FenceStartStatusDelayBetweenRetriesInSec (default 18 sec)

FenceStopStatusRetries(default 10)
FenceStopStatusDelayBetweenRetriesInSec(default 18 sec)


You can use the engine-config utility to change any of those (requires
engine restart)

For example

engine-config -s FenceStartStatusRetries=30




On Wed, Jul 12, 2017 at 12:27 PM, TranceWorldLogic . <
tranceworldlo...@gmail.com> wrote:

> Hi,
>
> I have created HA VM with priority as High.
> And then I block host network connection using firewall rule as shown
> below.
> e.g.
> iptables -I INPUT -j DROP; iptables -I OUTPUT -j DROP;
>
> As expected ovirt had call fencing to power off host and power on it again.
> At backgroud ovirt tried 10 time to start that VM but as host down it fail
> to start.
> And after 10 trial it giveup to start VM.
>
> Is there any way to increase trail count ?
> And also let me know how to change retry timer.
>
> Thanks,
> ~Rohit
>
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] SQL : last time halted?

2017-07-09 Thread Eli Mesika
On Thu, Jul 6, 2017 at 6:48 PM, Juan Hernández  wrote:

> On 07/06/2017 02:07 PM, Nicolas Ecarnot wrote:
>
>> [For the record]
>>
>> Juan,
>>
>> Thanks to your hint, I eventually found it more convenient for me to use
>> a SQL query to find out which VM was unsed for months :
>>
>> SELECT
>>vm_static.vm_name,
>>vm_dynamic.status,
>>vm_dynamic.vm_ip,
>>vm_dynamic.vm_host,
>>vm_dynamic.last_start_time,
>>vm_dynamic.vm_guid,
>>vm_dynamic.last_stop_time
>> FROM
>>public.vm_dynamic,
>>public.vm_static
>> WHERE
>>vm_dynamic.vm_guid = vm_static.vm_guid AND
>>vm_dynamic.status = 0
>> ORDER BY
>>vm_dynamic.last_stop_time ASC;
>>
>> Thank you.
>>
>>
> That is nice. Just keep in mind that the database schema isn't kept
> backwards compatible. A minor change in the engine can make your query fail
> or return incorrect results.


​I tend to agree ​

​with Juan that if you are doing that periodically then using the Python
SDK will insure that your script will survive schema changes ​

>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] question mark on VM ( DB status 8 )

2016-03-19 Thread Eli Mesika
- Original Message -

> From: p...@email.cz
> To: "users" < users@ovirt.org >
> Sent: Thursday, March 17, 2016 9:27:11 AM
> Subject: [ovirt-users] question mark on VM ( DB status 8 )

> Hello,
> during backup VM hanged with question mark in ovirt and status 8 in DB,
> snapshot file ( for backup )is locked.
> How to clean snapshot locking a wake up this VM from "unknow" state ???
Try using the unlock_entity.sh utility (run with --help for usage) 

> regs.
> pavel

> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7

2016-02-04 Thread Eli Mesika


- Original Message -
> From: "Martin Perina" <mper...@redhat.com>
> To: "Marcelo Leandro" <marcelol...@gmail.com>
> Cc: "Darrell Budic" <bu...@onholyground.com>, "Eli Mesika" 
> <emes...@redhat.com>, "users" <users@ovirt.org>
> Sent: Thursday, February 4, 2016 6:12:34 PM
> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7
> 
> Hi,
> 
> so it seems, that for some strange reason, user 'engine' cannot create
> schema in 'engine' database although it should be an owner of this db.
> I double checked that on all our testing databases this works fine and
> also if you created engine db according to doc (either automatically
> by engine-setup or manually in case of remote db) this should work.
> 
> So you can try to execute following command which adds proper
> permissions to 'engine' db user (please adapt according to you setup):
> 
> 
>  su - postgres -c "psql --command=\"GRANT ALL ON DATABASE
>  @ENGINE_DB_DATABASE@ TO @ENGINE_DB_USER@;\""
> 
> The correct output should be:
> 
>  GRANT
> 
> If it's successful, please execute engine-setup again to verify that
> above step fixed the issue.

Martin, should that be added to engine-setup ?

> 
> Thanks
> 
> Martin Perina
> 
> - Original Message -
> > From: "Marcelo Leandro" <marcelol...@gmail.com>
> > To: "Martin Perina" <mper...@redhat.com>
> > Sent: Thursday, February 4, 2016 1:40:36 PM
> > Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to
> > 6.2.6-1.el7
> > 
> > Hello Martin,
> > 
> > Indeed there´s an issue here. Runnig your command, I got this error:
> > ERROR:  permission denied for database engine ,  I'm investigating
> > deeper
> > 
> > Thanks
> > 
> > 2016-02-04 6:18 GMT-03:00 Martin Perina <mper...@redhat.com>:
> > > Hi,
> > >
> > > I just verified that upgrades on both Centos 6.7 and Centos 7.2 works
> > > fine,
> > > so there's something bad with psql on you machines :-(
> > >
> > > Could you please execute following steps and send me result?
> > >
> > > 1. Please take a look at your engine db configuration in
> > >/etc/ovirt-engine/engine.conf.d/10-setup-database.conf
> > >
> > > 2. Please replace variables (@VAR@) with real values according to your
> > >db setup and execute following command on engine host (or VM in
> > >case of hosted engine):
> > >
> > >LC_ALL="C" PGPASSWORD="@ENGINE_DB_PASSWORD@" psql -w
> > >--pset=tuples_only=on --host="@ENGINE_DB_HOST@"
> > >--port="@ENGINE_DB_PORT@" --username="@ENGINE_DB_USER@"
> > >--dbname="@ENGINE_DB_DATABASE@" --set ON_ERROR_STOP=1 --no-psqlrc
> > >--command="CREATE SCHEMA aaa_jdbc_x AUTHORIZATION @ENGINE_DB_USER@;"
> > >||
> > >die "Cannot execute sql command"
> > >
> > >Correct output should be:
> > >
> > >  CREATE SCHEMA
> > >
> > >
> > > Thanks a lot
> > >
> > > Martin Perina
> > >
> > > - Original Message -
> > >> From: "Darrell Budic" <bu...@onholyground.com>
> > >> To: "Marcelo Leandro" <marcelol...@gmail.com>
> > >> Cc: "Martin Perina" <mper...@redhat.com>, "users" <users@ovirt.org>
> > >> Sent: Thursday, February 4, 2016 6:17:21 AM
> > >> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to
> > >> 6.2.6-1.el7
> > >>
> > >> I just hit a similar problem, but on Centos 6.7, postgres (PostgreSQL)
> > >> 8.4.20. Looks like a permission error for me?
> > >>
> > >> 2016-02-03 22:52:42 DEBUG otopi.context context._executeMethod:142 Stage
> > >> misc
> > >> ME
> > >> THOD
> > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.aaajdbc.Plugin._misc
> > >> 2016-02-03 22:52:42 INFO
> > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.aa
> > >> ajdbc aaajdbc._setupSchema:97 Creating/refreshing Engine 'internal'
> > >> domain
> > >> datab
> > >> ase schema
> > >> 2016-02-03 22:52:42 DEBUG
> > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a
> > >> aajdbc plugin.executeRaw:828 execute:
> > >> ['/usr/share/ovir

Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6

2016-01-31 Thread Eli Mesika


- Original Message -
> From: "Amador Pahim" <apa...@redhat.com>
> To: "Eli Mesika" <emes...@redhat.com>, "Marcelo Leandro" 
> <marcelol...@gmail.com>
> Cc: "Martin Perina" <mper...@redhat.com>, "Moti Asayag" <masa...@redhat.com>, 
> "Allon Mureinik" <amure...@redhat.com>,
> "users" <users@ovirt.org>
> Sent: Thursday, January 28, 2016 6:18:33 PM
> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> 
> On 01/28/2016 01:59 PM, Eli Mesika wrote:
> >
> > - Original Message -
> >> From: "Marcelo Leandro" <marcelol...@gmail.com>
> >> To: "Amador Pahim" <apa...@redhat.com>
> >> Cc: "Eli Mesika" <emes...@redhat.com>, "Martin Perina"
> >> <mper...@redhat.com>, "Moti Asayag" <masa...@redhat.com>,
> >> "Allon Mureinik" <amure...@redhat.com>, "users" <users@ovirt.org>
> >> Sent: Thursday, January 28, 2016 1:39:49 PM
> >> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >>
> >> Hello,
> >> Yes i can.
> >>
> >> It's here:
> >> https://copy.com/OmnU13SAPXh13ZiR
> > Yes
> >
> > The problem is in the command_entities table that is not cleaned up and has
> > two records after taskcleaner.sh is invoked by engine-setup
> > Since engine tries to deserialize classes defined in this table and as
> > Martin noted changes between 3.5 and 3.6 changed some classes, we got this
> > exception
> > We should not allow leftovers to exists in this table during the upgrade
> > process and taskcleaner utility should handle that as well
> > Please open a BZ on that, I will handle that
> > Meanwhile, as a workaround, run the following before the upgrade
> >
> > psql -U engine -c "DELETE from command_entities;" 
> 
> I'm afraid the upgrade was done already. Will this work after the
> upgrade? Or he's supposed to downgrade/restore env to 3.5, run the
> DELETE and then try to upgrade again? Asking 'cause It's quite a task if
> yes :)

No need to downgrade, just run the query and retry 

> 
> >
> >
> >
> >> Thanks.
> >>
> >> 2016-01-28 8:17 GMT-03:00 Amador Pahim <apa...@redhat.com>:
> >>> On 01/28/2016 09:10 AM, Eli Mesika wrote:
> >>>>
> >>>> - Original Message -
> >>>>> From: "Martin Perina" <mper...@redhat.com>
> >>>>> To: "Eli Mesika" <emes...@redhat.com>
> >>>>> Cc: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> >>>>> <amure...@redhat.com>, "users" <users@ovirt.org>, "Amador
> >>>>> Pahim" <apa...@redhat.com>, "Marcelo Leandro" <marcelol...@gmail.com>
> >>>>> Sent: Thursday, January 28, 2016 12:59:02 PM
> >>>>> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >>>>>
> >>>>>
> >>>>>
> >>>>> - Original Message -
> >>>>>> From: "Eli Mesika" <emes...@redhat.com>
> >>>>>> To: "Martin Perina" <mper...@redhat.com>
> >>>>>> Cc: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> >>>>>> <amure...@redhat.com>, "users" <users@ovirt.org>, "Amador
> >>>>>> Pahim" <apa...@redhat.com>, "Marcelo Leandro" <marcelol...@gmail.com>
> >>>>>> Sent: Thursday, January 28, 2016 11:55:56 AM
> >>>>>> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> - Original Message -
> >>>>>>> From: "Martin Perina" <mper...@redhat.com>
> >>>>>>> To: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> >>>>>>> <amure...@redhat.com>
> >>>>>>> Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>,
> >>>>>>> "Amador
> >>>>>>> Pahim" <apa...@redhat.com>, "Marcelo
> >>>>>>> Leandro" <marcelol...@gmai

Re: [ovirt-users] Trunk vnic and simulated ipmi ?

2016-01-31 Thread Eli Mesika


- Original Message -
> From: "Dan Lavu" 
> To: users@ovirt.org
> Sent: Sunday, January 31, 2016 1:03:16 PM
> Subject: [ovirt-users] Trunk vnic and simulated ipmi ?
> 
> I've been looking around and trying to find a way to test hypervisors
> technologies on to of oVirt, in the most realistic way possible. Primarily
> openstack, so I was wondering if there was a way to trunk a virtual
> interface so i can run nested guests on different VLANs?
> 
> Secondly, does anybody have any experience with simulating IPMI? so fencing
> guests is possible using IPMI? I know there is a rhevm fence agent as an
> alternative.

AFAIK the hypervisor does not implement IPMI
However, you can track this open BZ [1] on libvirt

[1] https://bugzilla.redhat.com/show_bug.cgi?id=815136


> 
> Thanks.
> 
> Dan
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6

2016-01-28 Thread Eli Mesika


- Original Message -
> From: "Marcelo Leandro" <marcelol...@gmail.com>
> To: "Amador Pahim" <apa...@redhat.com>
> Cc: "Eli Mesika" <emes...@redhat.com>, "Martin Perina" <mper...@redhat.com>, 
> "Moti Asayag" <masa...@redhat.com>,
> "Allon Mureinik" <amure...@redhat.com>, "users" <users@ovirt.org>
> Sent: Thursday, January 28, 2016 1:39:49 PM
> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> 
> Hello,
> Yes i can.
> 
> It's here:
> https://copy.com/OmnU13SAPXh13ZiR

Yes 

The problem is in the command_entities table that is not cleaned up and has two 
records after taskcleaner.sh is invoked by engine-setup
Since engine tries to deserialize classes defined in this table and as Martin 
noted changes between 3.5 and 3.6 changed some classes, we got this exception
We should not allow leftovers to exists in this table during the upgrade 
process and taskcleaner utility should handle that as well
Please open a BZ on that, I will handle that 
Meanwhile, as a workaround, run the following before the upgrade 

psql -U engine -c "DELETE from command_entities;" 



> 
> Thanks.
> 
> 2016-01-28 8:17 GMT-03:00 Amador Pahim <apa...@redhat.com>:
> > On 01/28/2016 09:10 AM, Eli Mesika wrote:
> >>
> >>
> >> - Original Message -
> >>>
> >>> From: "Martin Perina" <mper...@redhat.com>
> >>> To: "Eli Mesika" <emes...@redhat.com>
> >>> Cc: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> >>> <amure...@redhat.com>, "users" <users@ovirt.org>, "Amador
> >>> Pahim" <apa...@redhat.com>, "Marcelo Leandro" <marcelol...@gmail.com>
> >>> Sent: Thursday, January 28, 2016 12:59:02 PM
> >>> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >>>
> >>>
> >>>
> >>> - Original Message -
> >>>>
> >>>> From: "Eli Mesika" <emes...@redhat.com>
> >>>> To: "Martin Perina" <mper...@redhat.com>
> >>>> Cc: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> >>>> <amure...@redhat.com>, "users" <users@ovirt.org>, "Amador
> >>>> Pahim" <apa...@redhat.com>, "Marcelo Leandro" <marcelol...@gmail.com>
> >>>> Sent: Thursday, January 28, 2016 11:55:56 AM
> >>>> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >>>>
> >>>>
> >>>>
> >>>> - Original Message -
> >>>>>
> >>>>> From: "Martin Perina" <mper...@redhat.com>
> >>>>> To: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> >>>>> <amure...@redhat.com>
> >>>>> Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>,
> >>>>> "Amador
> >>>>> Pahim" <apa...@redhat.com>, "Marcelo
> >>>>> Leandro" <marcelol...@gmail.com>
> >>>>> Sent: Wednesday, January 27, 2016 2:31:20 PM
> >>>>> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >>>>>
> >>>>> So now I finally understand the issue:
> >>>>>
> >>>>> When you try to login, CommandBase tries to execute LoginCommand, but
> >>>>> before the command execution it loads content of commands cache and
> >>>>> here comes the issue: there's stored AddVmFromSnapshotCommand which
> >>>>> contains DiskImage as a parameter and DiskImage implementation has
> >>>>> changed between 3.5 and 3.6.
> >>>>>
> >>>>> Moti, is there some way how to clean up commands cache so it doesn't
> >>>>> contain those 3.5 commands?
> >>>>>
> >>>>> Also should those situation be covered during engine upgrades?
> >>>>
> >>>> Martin, is this a left over in the command_entities table that caused
> >>>> the
> >>>> failure while the entity is deserialized ?
> >>>
> >>> Probably, because this DiskImage.Id serialization exception started to
> >>> appear
> >>> after upgrade from 3.5. Is there any way

Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6

2016-01-28 Thread Eli Mesika


- Original Message -
> From: "Martin Perina" <mper...@redhat.com>
> To: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik" <amure...@redhat.com>
> Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>, "Amador 
> Pahim" <apa...@redhat.com>, "Marcelo
> Leandro" <marcelol...@gmail.com>
> Sent: Wednesday, January 27, 2016 2:31:20 PM
> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> 
> So now I finally understand the issue:
> 
> When you try to login, CommandBase tries to execute LoginCommand, but
> before the command execution it loads content of commands cache and
> here comes the issue: there's stored AddVmFromSnapshotCommand which
> contains DiskImage as a parameter and DiskImage implementation has
> changed between 3.5 and 3.6.
> 
> Moti, is there some way how to clean up commands cache so it doesn't
> contain those 3.5 commands?
> 
> Also should those situation be covered during engine upgrades?

Martin, is this a left over in the command_entities table that caused the 
failure while the entity is deserialized ?

> 
> Thanks
> 
> Martin
> 
> 
> - Original Message -
> > From: "Marcelo Leandro" <marcelol...@gmail.com>
> > To: "Martin Perina" <mper...@redhat.com>
> > Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>, "Amador
> > Pahim" <apa...@redhat.com>
> > Sent: Wednesday, January 27, 2016 1:08:19 PM
> > Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> > 
> > The server  just in time  isolate from the network,is it a problem?
> > thats ok?
> > 
> > follows the logs:
> > 
> > server.log:
> > https://copy.com/Eni9adZSCjyMZNFN
> > 
> > engine.log:
> > https://copy.com/ayczW9ipHdW4BWni
> > 
> > 2016-01-27 5:32 GMT-03:00 Martin Perina <mper...@redhat.com>:
> > > Hi,
> > >
> > > according to the test of login by ovirt-engine-extensions-tool you were
> > > logged in
> > > successfully, so there shouldn't be any issues logging into engine using
> > > admin@internal ...
> > >
> > > Unfortunately both engine.log and server.log ends on Jan 22th and I'd
> > > really
> > > like to see up-to-date logs.
> > >
> > > So if you still cannot login into webadmin please do following:
> > >
> > > 1. Stop engine service
> > >
> > >  systemctl stop ovirt-engine
> > >
> > >or
> > >
> > >  service ovirt-engine stop
> > >
> > >
> > > 2. Rotate logs
> > >
> > >cd /var/log/ovirt-engine
> > >mv engine.log engine-20160127.log
> > >mv server.log server-20160127.log
> > >
> > >
> > > 3. Start engine
> > >
> > >  systemctl start ovirt-engine
> > >
> > >or
> > >
> > >  service ovirt-engine start
> > >
> > >
> > > 4. Try to login as admin with domain internal using webadmin
> > >
> > >
> > > 5. Try to login as admin@internal using REST API by
> > >accessing
> > >
> > >  http://SERVER/ovirt-engine/api/datacenters
> > >
> > >Into user please enter full username: admin@internal
> > >
> > >
> > > When done please attach latest server.log and engine.log
> > >
> > >
> > > Thanks a lot
> > >
> > > Martin Perina
> > >
> > >
> > > - Original Message -
> > >> From: "Marcelo Leandro" <marcelol...@gmail.com>
> > >> To: "Martin Perina" <mper...@redhat.com>
> > >> Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>,
> > >> "Amador
> > >> Pahim" <apa...@redhat.com>
> > >> Sent: Tuesday, January 26, 2016 8:46:12 PM
> > >> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> > >>
> > >> hello,
> > >>
> > >> setup.log:
> > >> https://copy.com/lIYzccOnwCiW7e9q
> > >>
> > >> and output the command :
> > >> https://copy.com/7psvpyUzUq0FKW31
> > >>
> > >> error screen when i try to login on webadmin:
> > >> https://copy.com/CfKZePnGFmIwF7B8
> > >>
> > >> Thanks
> &

Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6

2016-01-28 Thread Eli Mesika


- Original Message -
> From: "Martin Perina" <mper...@redhat.com>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik" 
> <amure...@redhat.com>, "users" <users@ovirt.org>, "Amador
> Pahim" <apa...@redhat.com>, "Marcelo Leandro" <marcelol...@gmail.com>
> Sent: Thursday, January 28, 2016 12:59:02 PM
> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> 
> 
> 
> - Original Message -
> > From: "Eli Mesika" <emes...@redhat.com>
> > To: "Martin Perina" <mper...@redhat.com>
> > Cc: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> > <amure...@redhat.com>, "users" <users@ovirt.org>, "Amador
> > Pahim" <apa...@redhat.com>, "Marcelo Leandro" <marcelol...@gmail.com>
> > Sent: Thursday, January 28, 2016 11:55:56 AM
> > Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> > 
> > 
> > 
> > - Original Message -
> > > From: "Martin Perina" <mper...@redhat.com>
> > > To: "Moti Asayag" <masa...@redhat.com>, "Allon Mureinik"
> > > <amure...@redhat.com>
> > > Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>, "Amador
> > > Pahim" <apa...@redhat.com>, "Marcelo
> > > Leandro" <marcelol...@gmail.com>
> > > Sent: Wednesday, January 27, 2016 2:31:20 PM
> > > Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> > > 
> > > So now I finally understand the issue:
> > > 
> > > When you try to login, CommandBase tries to execute LoginCommand, but
> > > before the command execution it loads content of commands cache and
> > > here comes the issue: there's stored AddVmFromSnapshotCommand which
> > > contains DiskImage as a parameter and DiskImage implementation has
> > > changed between 3.5 and 3.6.
> > > 
> > > Moti, is there some way how to clean up commands cache so it doesn't
> > > contain those 3.5 commands?
> > > 
> > > Also should those situation be covered during engine upgrades?
> > 
> > Martin, is this a left over in the command_entities table that caused the
> > failure while the entity is deserialized ?
> 
> Probably, because this DiskImage.Id serialization exception started to appear
> after upgrade from 3.5. Is there any way how to verify and clean up?

I suggest having a bug on the taskcleaner code which is called upon upgrade, 
then I will try to reproduce 
Amador, Is there a chance we can get a backup of that 3.5 DB in order to 
reproduce ?

> 
> > 
> > > 
> > > Thanks
> > > 
> > > Martin
> > > 
> > > 
> > > - Original Message -
> > > > From: "Marcelo Leandro" <marcelol...@gmail.com>
> > > > To: "Martin Perina" <mper...@redhat.com>
> > > > Cc: "Eli Mesika" <emes...@redhat.com>, "users" <users@ovirt.org>,
> > > > "Amador
> > > > Pahim" <apa...@redhat.com>
> > > > Sent: Wednesday, January 27, 2016 1:08:19 PM
> > > > Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> > > > 
> > > > The server  just in time  isolate from the network,is it a problem?
> > > > thats ok?
> > > > 
> > > > follows the logs:
> > > > 
> > > > server.log:
> > > > https://copy.com/Eni9adZSCjyMZNFN
> > > > 
> > > > engine.log:
> > > > https://copy.com/ayczW9ipHdW4BWni
> > > > 
> > > > 2016-01-27 5:32 GMT-03:00 Martin Perina <mper...@redhat.com>:
> > > > > Hi,
> > > > >
> > > > > according to the test of login by ovirt-engine-extensions-tool you
> > > > > were
> > > > > logged in
> > > > > successfully, so there shouldn't be any issues logging into engine
> > > > > using
> > > > > admin@internal ...
> > > > >
> > > > > Unfortunately both engine.log and server.log ends on Jan 22th and I'd
> > > > > really
> > > > > like to see up-to-date logs.
> > > > >
> > > > > So if you still cannot login into webadmin please do following:
> > > &g

Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6

2016-01-25 Thread Eli Mesika
Adding Martin

There are some aaa errors before that, but first significant error is in 
2016-01-20 00:14:55,002 
Can you take a look ?

- Original Message -
> From: "Marcelo Leandro" <marcelol...@gmail.com>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: users@ovirt.org, "Amador Pahim" <apa...@redhat.com>
> Sent: Sunday, January 24, 2016 1:48:04 PM
> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> 
> It's here : https://copy.com/TWjgIu7KwSkcmRZ8
> 
> 
> - Original Message -
> > From: "Amador Pahim" <apa...@redhat.com>
> > To: "Marcelo Leandro" <marcelol...@gmail.com>, users@ovirt.org
> > Cc: emes...@redhat.com
> > Sent: Friday, January 22, 2016 7:08:20 PM
> > Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> >
> > On 01/22/2016 03:03 PM, Marcelo Leandro wrote:
> > > After engine-setup from ovirt-engine-3.5.6.2-1.el7.centos to
> > > ovirt-engine-3.6.1.3-1.el7.centos, I'm not able to login anymore. The
> > > engine.log say
> > > Caused by: org.codehaus.jackson.map.JsonMappingException: Invalid type
> > > id 'org.ovirt.engine.core.common.businessentities.DiskImage' (for id
> > > type 'Id.class'): no such class found (through reference chain:
> > >
> org.ovirt.engine.core.common.action.AddVmFromSnapshotParameters["vm"]->org.ovirt.engine.core.common.businessentities.VM["diskList"])
> >
> > hmm, I see a similar msg here:
> > http://lists.ovirt.org/pipermail/devel/2015-July/010976.html
> >
> > Not sure if related. Eli? Any thoughts here?
> 
> I don't think it is related ...
> Amador, can you please attach a full engine log ?
> 
> >
> > >
> > > Here the setup log:
> > > https://copy.com/YBddV8bg3tnjHnwp
> > >
> > > And here the engine.log:
> > > https://copy.com/TWjgIu7KwSkcmRZ8
> > >
> > > Need urgent assistance. Thank you in advance.
> > >
> > > Best Regards,
> > > Marcelo Leandro
> > > ___
> > > Users mailing list
> > > Users@ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/users
> >
> >
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6

2016-01-24 Thread Eli Mesika


- Original Message -
> From: "Amador Pahim" 
> To: "Marcelo Leandro" , users@ovirt.org
> Cc: emes...@redhat.com
> Sent: Friday, January 22, 2016 7:08:20 PM
> Subject: Re: [ovirt-users] Cannot login after upgrade from 3.5 to 3.6
> 
> On 01/22/2016 03:03 PM, Marcelo Leandro wrote:
> > After engine-setup from ovirt-engine-3.5.6.2-1.el7.centos to
> > ovirt-engine-3.6.1.3-1.el7.centos, I'm not able to login anymore. The
> > engine.log say
> > Caused by: org.codehaus.jackson.map.JsonMappingException: Invalid type
> > id 'org.ovirt.engine.core.common.businessentities.DiskImage' (for id
> > type 'Id.class'): no such class found (through reference chain:
> > org.ovirt.engine.core.common.action.AddVmFromSnapshotParameters["vm"]->org.ovirt.engine.core.common.businessentities.VM["diskList"])
> 
> hmm, I see a similar msg here:
> http://lists.ovirt.org/pipermail/devel/2015-July/010976.html
> 
> Not sure if related. Eli? Any thoughts here?

I don't think it is related ...
Amador, can you please attach a full engine log ?

> 
> >
> > Here the setup log:
> > https://copy.com/YBddV8bg3tnjHnwp
> >
> > And here the engine.log:
> > https://copy.com/TWjgIu7KwSkcmRZ8
> >
> > Need urgent assistance. Thank you in advance.
> >
> > Best Regards,
> > Marcelo Leandro
> > ___
> > Users mailing list
> > Users@ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> 
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] power management on ovirt3.6.1

2016-01-18 Thread Eli Mesika
Hi Alireza

Me and Martin Perina are in charge of Power Management issues in oVirt
Please let us know if your problem is solved or attach the relevant logs for 
investigation 

Thanks 

- Original Message -
> From: "combuster" 
> To: "alireza sadeh seighalan" , users@ovirt.org
> Sent: Monday, January 18, 2016 3:35:55 PM
> Subject: Re: [ovirt-users] power management on ovirt3.6.1
> 
> Hi,
> 
> you need at least two servers in the cluster for pm test to succeed. If you
> do, make sure that IP address of the iLO is pingable from all hosts in the
> cluster. oVirt engine log would also help in troubleshooting the issue.
> 
> 
> On 01/18/2016 02:10 PM, alireza sadeh seighalan wrote:
> 
> 
> 
> hi everyone
> 
> i wanted to configure power management on ovirt3.6.1 but it failed. i attach
> the configuration image . thanks in advance
> 
> 
> os: centos7.1
> ovirt: 3.6.1
> server: DL380 G7 (ilo3)
> 
> 
> ___
> Users mailing list Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] iLO2

2016-01-03 Thread Eli Mesika


- Original Message -
> From: "Eriks Goodwin" <er...@connectcombpo.com>
> To: "Eli Mesika" <emes...@redhat.com>
> Sent: Tuesday, December 29, 2015 4:13:11 AM
> Subject: Re: [ovirt-users] iLO2
> 
> [root@n001 ~]# /usr/sbin/fence_ipmilan --ip=10.0.1.104 --username=ovirtmgmt
> --password=REDACTED -v --action=status --lanplus

Please try again with 

# /usr/sbin/fence_ipmilan --ip=10.0.1.104 --username=ovirtmgmt 
--password=REDACTED -v --action=status --lanplus -T 4

> 
> Executing: /usr/bin/ipmitool -I lanplus -H 10.0.1.104 -U ovirtmgmt -P [set]
> -p 623 -L ADMINISTRATOR chassis power status
> 
> Connection timed out
> 
> [root@n001 ~]#
> 
> 
> - On Dec 22, 2015, at 8:48 AM, Eli Mesika <emes...@redhat.com> wrote:
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] iLO2

2015-12-22 Thread Eli Mesika


- Original Message -
> From: "Eriks Goodwin" <er...@connectcombpo.com>
> To: "users" <users@ovirt.org>
> Sent: Tuesday, December 22, 2015 11:08:15 AM
> Subject: [ovirt-users] iLO2
> 
> I have been tinkering with various settings and configurations trying to get
> power management working properly--but it keeps giving me "Fail:" (without
> any details) every time I test the settings. The servers I am using are HP
> Proliant DL380 G6 with integrated iLO2. Any tips?
> 
> I can use the same credentials to log into the system via the web
> interface--so I'm sure I have the address, username, and passwd right. :-)

can you please try to reach the PM agent via the /usr/sbin/fence_ipmilan script 
using "lanplus=1,power_wait=4" and see if it is working for you?
If not , please paste the result you got 

Thanks 
Eli Mesika

> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] ERROR: update or delete on table "luns" violates foreign key constraint...

2015-12-20 Thread Eli Mesika


- Original Message -
> From: "Aleksey Chudov" 
> To: users@ovirt.org
> Sent: Friday, December 18, 2015 11:38:21 AM
> Subject: [ovirt-users] ERROR: update or delete on table "luns" violates   
> foreign key constraint...
> 
> Hi,
> 
> I have two-node self hosted engine cluster with iscsi shared storage. Every
> ovirt-engine restart produces the following error in
> /var/log/ovirt-engine/engine.log. After that engine works without any
> problems.
> 
> How to fix it?

CCing Allon M

This seems as a bug 

disk_lun_map FK is created without ON DELETE/UPDATE CASCADE
This makes the FK failing in deleting from the luns table (by calling 
DeleteLun) while the deleted lun in the parent table has references in 
disk_lun_map

Allon, please advice 

> 
> 2015-12-18 11:33:00,053 ERROR
> [org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand]
> (org.ovirt.thread.pool-8-thread-11) [674068d8] Command
> 'org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand'
> failed: CallableStatementCallback; SQL [{call deletelun(?)}]; ERROR: update
> or delete on table "luns" violates foreign key constraint
> "disk_lun_to_lun_fk" on table "disk_lun_map"
> Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced
> from table "disk_lun_map".
> Where: SQL statement "DELETE FROM LUNs
> WHERE LUN_id = v_LUN_id"
> PL/pgSQL function deletelun(character varying) line 10 at SQL statement;
> nested exception is org.postgresql.util.PSQLException: ERROR: update or
> delete on table "luns" violates foreign key constraint "disk_lun_to_lun_fk"
> on table "disk_lun_map"
> Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced
> from table "disk_lun_map".
> Where: SQL statement "DELETE FROM LUNs
> WHERE LUN_id = v_LUN_id"
> PL/pgSQL function deletelun(character varying) line 10 at SQL statement
> 2015-12-18 11:33:00,053 ERROR
> [org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand]
> (org.ovirt.thread.pool-8-thread-11) [674068d8] Exception:
> org.springframework.dao.DataIntegrityViolationException:
> CallableStatementCallback; SQL [{call deletelun(?)}]; ERROR: update or
> delete on table "luns" violates foreign key constraint "disk_lun_to_lun_fk"
> on table "disk_lun_map"
> Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced
> from table "disk_lun_map".
> Where: SQL statement "DELETE FROM LUNs
> WHERE LUN_id = v_LUN_id"
> PL/pgSQL function deletelun(character varying) line 10 at SQL statement;
> nested exception is org.postgresql.util.PSQLException: ERROR: update or
> delete on table "luns" violates foreign key constraint "disk_lun_to_lun_fk"
> on table "disk_lun_map"
> Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced
> from table "disk_lun_map".
> Where: SQL statement "DELETE FROM LUNs
> WHERE LUN_id = v_LUN_id"
> PL/pgSQL function deletelun(character varying) line 10 at SQL statement
> at
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:147)
> [dal.jar:]
> at
> org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:142)
> [dal.jar:]
> at
> org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:80)
> [dal.jar:]
> at org.ovirt.engine.core.dao.LunDaoImpl.remove(LunDaoImpl.java:127)
> [dal.jar:]
> at org.ovirt.engine.core.dao.LunDaoImpl.remove(LunDaoImpl.java:18) [dal.jar:]
> at
> org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand.refreshLunsInfo(SyncLunsInfoForBlockStorageDomainCommand.java:94)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand$1.runInTransaction(SyncLunsInfoForBlockStorageDomainCommand.java:51)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand$1.runInTransaction(SyncLunsInfoForBlockStorageDomainCommand.java:48)
> [bll.jar:]
> at
> 

Re: [ovirt-users] Ovirt Backup API

2015-12-17 Thread Eli Mesika


- Original Message -
> From: "Manuel Meier" <me...@atix.de>
> To: users@ovirt.org
> Sent: Thursday, December 17, 2015 11:40:04 AM
> Subject: [ovirt-users] Ovirt Backup API
> 
> Hi,
> 
> we are planning to use ovirt for our internal IT.
> At the moment we are not sure about the proposed backup procedure.
> It seems that there is an Backup API but not really well documented.
> Where can we get the documentation?
> Also what Backup Programs support the Ovirt Backup API ?

Hi Manuel
Please check http://www.ovirt.org/Features/Backup-Restore_API_Integration

Regards

Eli Mesika



> 
> 
> Thanks for your help
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] vms are shutting off by themselves ovirt3.6.

2015-12-16 Thread Eli Mesika


- Original Message -
> From: "Liam Curtis" 
> To: "users" 
> Sent: Tuesday, December 15, 2015 10:41:13 PM
> Subject: [ovirt-users] vms are shutting off by themselves ovirt3.6.
> 
> Hello All,
> 
> On ovirt3.6. Have run into issues whereby vms are shutting off by themselves
> for no apprent reason...logs are pretty verbose. Having hard time finding
> root cause.

Can you attach please relevant engine.log?
Thanks
Eli

> 
> Any known issues?
> 
> 3.6.0.2-1.el7.centos
> 
> --
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] left panel has disappeared

2015-12-15 Thread Eli Mesika


- Original Message -
> From: "Nathanaël Blanchet" 
> To: "Joop" , users@ovirt.org
> Sent: Tuesday, December 15, 2015 11:59:13 AM
> Subject: Re: [ovirt-users] left panel has disappeared
> 
> Yes, other browser on an other computer gets the same issue

I know that Alexander W merged today a patch doing lazy loading magic in 
UserPortal/WebAdmin (commit 7431bdf)
Can you rebase on a commit before this one and see if you got this working ?

> 
> Le 15/12/2015 10:51, Joop a écrit :
> 
> 
> 
> On 15-12-2015 10:36, Nathanaël Blanchet wrote:
> 
> 
> rather something like that :)
> (image with no System tree deleted)
> 
> Oops, thats is something different than I thought. Ofcourse you tried:
> - different browser
> - cleaning broswer cache
> 
> Other than that :-\
> 
> Joop
> 
> PS:
> Adding ML, sorry about that.
> 
> 
> --
> Nathanaël Blanchet
> 
> Supervision réseau
> Pôle Infrastrutures Informatiques
> 227 avenue Professeur-Jean-Louis-Viala
> 34193 MONTPELLIER CEDEX 5
> Tél. 33 (0)4 67 54 84 55
> Fax  33 (0)4 67 54 84 14 blanc...@abes.fr
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Postgresql failure (was: Ovirt Engine Issue)

2015-12-07 Thread Eli Mesika


- Original Message -
> From: "Yedidyah Bar David" <d...@redhat.com>
> To: "Melissa Mesler" <meli...@aasteel.com>, "Eli Mesika" <emes...@redhat.com>
> Cc: users@ovirt.org
> Sent: Monday, December 7, 2015 4:14:49 PM
> Subject: Postgresql failure (was: [ovirt-users] Ovirt Engine Issue)
> 
> On Mon, Dec 7, 2015 at 4:00 PM, Melissa Mesler <meli...@aasteel.com> wrote:
> > Here is what I retrieved from the postresql logs:
> >
> > LOG:  database system was interrupted; last known up at 2015-12-04 10:57:43
> > CST
> > LOG:  unexpected pageaddr 0/69564000 in log file 0, segment 107, offset
> > 5652480
> > LOG:  invalid primary checkpoint record
> > LOG:  unexpected pageaddr 0/6952A000 in log file 0, segment 107, offset
> > 5414912
> > LOG:  invalid secondary checkpoint record
> > PANIC:  could not locate a valid checkpoint record
> > LOG:  startup process (PID 1637) was terminated by signal 6: Aborted
> > LOG:  aborting startup due to startup process failure
> > LOG:  database system was interrupted; last known up at 2015-12-04 10:57:43
> > CST
> > LOG:  unexpected pageaddr 0/69564000 in log file 0, segment 107, offset
> > 5652480
> > LOG:  invalid primary checkpoint record
> > LOG:  unexpected pageaddr 0/6952A000 in log file 0, segment 107, offset
> > 5414912
> > LOG:  invalid secondary checkpoint record
> > PANIC:  could not locate a valid checkpoint record
> > LOG:  startup process (PID 2632) was terminated by signal 6: Aborted
> > LOG:  aborting startup due to startup process failure
> >
> > Also, when I did the sync on the ovirt vm it was powered off. I know not to
> > do live syncs as there could be issues. That's why I'm so confused that
> > there's a pr oblem.
> 
> No idea, adding Eli and changing subject.

Seems as database is corrupted 
This is a serious issue that someone with DBA knowledge should handle 
http://blog.endpoint.com/2014/11/when-postgres-will-not-start.html
Remember to do a physical copy of your database file to a different partition 
or server before you start 

Eli

> 
> Best,
> 
> >
> >
> >
> > On 12/7/15 1:03 AM, Yedidyah Bar David wrote:
> >
> > On Mon, Dec 7, 2015 at 12:09 AM, Melissa Mesler <meli...@aasteel.com>
> > wrote:
> >
> > Hopefully someone can give me a good idea of how to troubleshoot an ovirt
> > issue. I am running 3.5 on CentOS 6.7. Here is the issue I'm having. I have
> > Ovirt running as a virtual machine in KVM. I recently moved (with virtsync)
> > the vm to rebuild the host. Once the host was rebuilt I moved ovirt back.
> > Now ovirt-engine starts but is inaccessible. In the logs it says this:
> >
> > 2015-12-06 15:57:24,558 ERROR [org.ovirt.engine.core.bll.Backend] (MSC
> > service thread 1-2) Error in getting DB connection. The database is
> > inaccessible. Original exception is: DataAccessResourceFailureException:
> > Error retreiving database metadata; nested exception is
> > org.springframework.jdbc.support.MetaDataAccessException: Could not get
> > Connection for extracting meta data; nested exception is
> > org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
> > JDBC Connection; nested exception is java.sql.SQLException:
> > javax.resource.ResourceException: IJ000453: Unable to get managed
> > connection
> > for java:/ENGINEDataSource
> >
> > I did notice that I can't get postgresql to start.
> >
> > What happens when you try? Check/post also pg logs please, from
> > /var/lib/pgsql/data/pg_log/ .
> >
> > Everything worked
> > perfectly fine before. Any ideas?
> >
> > Was the copy done from a live machine? From a snapshot? Perhaps it wasn't
> > consistent? Need to check pg logs.
> >
> > Best,
> >
> >
> 
> 
> 
> --
> Didi
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Need to clear domain Export already exists in an ovirt (3.5)

2015-12-06 Thread Eli Mesika


- Original Message -
> From: "Christopher Cox" <c...@endlessnow.com>
> Cc: users@ovirt.org
> Sent: Saturday, December 5, 2015 8:44:20 AM
> Subject: Re: [ovirt-users] Need to clear domain Export already exists in an 
> ovirt (3.5)
> 
> On 12/03/2015 08:55 AM, Eli Mesika wrote:
> >
> >
> > - Original Message -
> >> From: c...@endlessnow.com
> >> To: users@ovirt.org
> >> Sent: Wednesday, December 2, 2015 11:02:25 PM
> >> Subject: [ovirt-users] Need to clear domain Export already exists in an
> >>ovirt (3.5)
> >>
> >> Our ovirt 3.5 host thinks it has an export domain, but it's not visible
> >> anywhere, but it's keeping us from importing a domain from a different
> >> datacenter.  What database update do I need to issue to clear the bad
> >> state from the ovirt 3.5 we are trying to Import into?
> >
> > Hi
> >
> > Can you please provide the result of the following query
> >
> > select * from storage_domain_static where storage_domain_type = 3;
> >
> > Is that the storage domain you wish to remove ?
> 
> Correct.
> 
> engine=> select * from storage_domain_static where storage_domain_type = 3;
>id  |   storage
>|
> storage_name | storage_domain_type | storage_type | storage_domain_format_typ
> e | _create_date  | _update_date | recoverable |
> last_time_used_as_master | storage_description | storage_comment
> --+--+--+-+--+--
> --+---+--+-+--+-+-
>   57fdd1c6-5c76-4174-8df7-50dbe82bc957 | d0eebb52-b9f6-4b11-8bc1-f100880519dd
>   |
> Export   |   3 |1 | 0
>| 2015-12-02 13:57:10.111442-06 |  | t   |
>   0 | |
>   c29afe14-0bc5-4fde-ab15-3f98f1ef9ed0 | 2e0bb17a-5f0c-4a24-9ab7-312de3f718be
>   |
> MoveIt   |   3 |1 | 0
>| 2014-09-24 15:36:03.066565-05 |  | t   |
>   0 | |
> (2 rows)
> 
> 
> These don't exist on the datacenter.

Please follow :

1) Use engine-backup to backup your database 
2) To delete a storage domain from the database you should run from the psql 
prompt 

select Deletestorage_domain_static() ;

where id is '57fdd1c6-5c76-4174-8df7-50dbe82bc957' or 
'c29afe14-0bc5-4fde-ab15-3f98f1ef9ed0' depends on the one you want to delete 

Please do not perform any operation before having a valid fresh backup of your 
database 




> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Need to clear domain Export already exists in an ovirt (3.5)

2015-12-03 Thread Eli Mesika


- Original Message -
> From: c...@endlessnow.com
> To: users@ovirt.org
> Sent: Wednesday, December 2, 2015 11:02:25 PM
> Subject: [ovirt-users] Need to clear domain Export already exists in an   
> ovirt (3.5)
> 
> Our ovirt 3.5 host thinks it has an export domain, but it's not visible
> anywhere, but it's keeping us from importing a domain from a different
> datacenter.  What database update do I need to issue to clear the bad
> state from the ovirt 3.5 we are trying to Import into?

Hi

Can you please provide the result of the following query 

select * from storage_domain_static where storage_domain_type = 3;

Is that the storage domain you wish to remove ?


> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Engine upgrade error

2015-12-01 Thread Eli Mesika


- Original Message -
> From: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: Users@ovirt.org
> Sent: Tuesday, December 1, 2015 12:43:17 PM
> Subject: Re: [ovirt-users] Engine upgrade error
> 
> Oh, that looks not so good...
> 
>                vds_id| network_name
> --+--
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | vlan111
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHNetzVLAN1
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | ovirtmgmt
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHnetz
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | vlan111
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | KHNetzVLAN1
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | ovirtmgmt
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | KHnetz

Hi

Error complains about the following key 

Key (vds_id, network_name)=(ba954f0f-6ecb-4ec8-b169-7e0a1147b4cd, KHnetz) is 
duplicated.

This was omitted from your data above 
Can you please provide the full data ("select * from vds_interface;")

Thanks 

> 
> 
> Now I have to drop something, I guess...
> 
> Am Montag, den 30.11.2015, 18:04 -0500 schrieb Eli Mesika:
> > 
> > - Original Message -
> > > From: "Oved Ourfali" <oourf...@redhat.com>
> > > To: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> > > Cc: Users@ovirt.org
> > > Sent: Monday, November 30, 2015 6:45:17 PM
> > > Subject: Re: [ovirt-users] Engine upgrade error
> > > 
> > > 
> > > 
> > > CC-ing Alona and Yevgeny from the network team to take a look.
> > > 
> > > Regards,
> > > Oved Ourfali
> > > On Nov 30, 2015 4:07 PM, "Frank Rothenstein" <
> > > f.rothenst...@bodden-kliniken.de > wrote:
> > > 
> > > 
> > > Hello,
> > > 
> > > I tried several times to upgrade my ovirt-engine 3.5.5 to 3.6.
> > > Every
> > > time the setup stops at updating the DB-schema. The log revealed
> > > when
> > > this happpens: The setup ist complaining about a duplicated key -
> > > here
> > > is the part of the log. Of course there is only one network in the
> > > interface.
> > > 
> > > Can anybody help me getting a solution?
> > 
> > Can you please attach the result of the following query :
> > 
> > select vds_id, network_name from vds_interface;
> > 
> > Thanks
> > 
> > > 
> > > Thnaks, Frank
> > > 
> > > Running upgrade sql script '/usr/share/ovirt-
> > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_
> > > inte
> > > rface.sql'...
> > > 2542964-
> > > 2542965-2015-11-30 08:15:26 DEBUG
> > > otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
> > > plugin.execute:941 execute-output: ['/usr/share/ovirt-
> > > engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u',
> > > 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-
> > > engine-setup-20151130073216-erdh9f.log', '-c', 'apply'] stderr:
> > > 2543300-psql:/usr/share/ovirt-
> > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_
> > > inte
> > > rface.sql:1: ERROR: could not create unique index
> > > "vds_interface_vds_id_network_name_unique"
> > > 2543487:DETAIL: Key (vds_id, network_name)=(ba954f0f-6ecb-4ec8-
> > > b169-
> > > 7e0a1147b4cd, KHnetz) is duplicated.
> > > 2543585-CONTEXT: SQL statement "ALTER TABLE vds_interface ADD
> > > CONSTRAINT vds_interface_vds_id_network_name_unique unique (vds_id,
> > > network_name)"
> > > 2543723-PL/pgSQL function fn_db_create_constraint(character
> > > varying,character varying,text) line 4 at EXECUTE statement
> > > 2543835-FATAL: Cannot execute sql command: --file=/usr/share/ovirt-
> > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_
> > > inte
> > > rface.sql
> > 

Re: [ovirt-users] Engine upgrade error

2015-12-01 Thread Eli Mesika


- Original Message -
> From: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: Users@ovirt.org
> Sent: Tuesday, December 1, 2015 12:43:17 PM
> Subject: Re: [ovirt-users] Engine upgrade error
> 
> Oh, that looks not so good...
> 
>                vds_id| network_name
> --+--
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | vlan111
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHNetzVLAN1
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | ovirtmgmt
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHnetz
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | vlan111
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | KHNetzVLAN1
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | ovirtmgmt
>  6d9c0683-be85-4f70-9790-0f491b7c8021 | KHnetz
> 
> 
> Now I have to drop something, I guess...

Alona, Yevgeny 
Table includes duplicate records and therefor 
dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_interface.sql fails 
on creating a unique constraint.
Please advice 

1) What should be removed in that case 
2) How can we fix the upgrade script to handle such cases in order that the 
full upgrade process will not fail ?

> 
> Am Montag, den 30.11.2015, 18:04 -0500 schrieb Eli Mesika:
> > 
> > - Original Message -
> > > From: "Oved Ourfali" <oourf...@redhat.com>
> > > To: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> > > Cc: Users@ovirt.org
> > > Sent: Monday, November 30, 2015 6:45:17 PM
> > > Subject: Re: [ovirt-users] Engine upgrade error
> > > 
> > > 
> > > 
> > > CC-ing Alona and Yevgeny from the network team to take a look.
> > > 
> > > Regards,
> > > Oved Ourfali
> > > On Nov 30, 2015 4:07 PM, "Frank Rothenstein" <
> > > f.rothenst...@bodden-kliniken.de > wrote:
> > > 
> > > 
> > > Hello,
> > > 
> > > I tried several times to upgrade my ovirt-engine 3.5.5 to 3.6.
> > > Every
> > > time the setup stops at updating the DB-schema. The log revealed
> > > when
> > > this happpens: The setup ist complaining about a duplicated key -
> > > here
> > > is the part of the log. Of course there is only one network in the
> > > interface.
> > > 
> > > Can anybody help me getting a solution?
> > 
> > Can you please attach the result of the following query :
> > 
> > select vds_id, network_name from vds_interface;
> > 
> > Thanks
> > 
> > > 
> > > Thnaks, Frank
> > > 
> > > Running upgrade sql script '/usr/share/ovirt-
> > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_
> > > inte
> > > rface.sql'...
> > > 2542964-
> > > 2542965-2015-11-30 08:15:26 DEBUG
> > > otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
> > > plugin.execute:941 execute-output: ['/usr/share/ovirt-
> > > engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u',
> > > 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-
> > > engine-setup-20151130073216-erdh9f.log', '-c', 'apply'] stderr:
> > > 2543300-psql:/usr/share/ovirt-
> > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_
> > > inte
> > > rface.sql:1: ERROR: could not create unique index
> > > "vds_interface_vds_id_network_name_unique"
> > > 2543487:DETAIL: Key (vds_id, network_name)=(ba954f0f-6ecb-4ec8-
> > > b169-
> > > 7e0a1147b4cd, KHnetz) is duplicated.
> > > 2543585-CONTEXT: SQL statement "ALTER TABLE vds_interface ADD
> > > CONSTRAINT vds_interface_vds_id_network_name_unique unique (vds_id,
> > > network_name)"
> > > 2543723-PL/pgSQL function fn_db_create_constraint(character
> > > varying,character varying,text) line 4 at EXECUTE statement
> > > 2543835-FATAL: Cannot execute sql command: --file=/usr/share/ovirt-
> > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_netw

[ovirt-users] FW: Engine upgrade error

2015-12-01 Thread Eli Mesika


- Original Message -
> From: "Eli Mesika" <emes...@redhat.com>
> To: "Alpaslan Kaplan" <akap...@redhat.com>, "Yevgeny Zaspitsky" 
> <yzasp...@redhat.com>
> Cc: Users@ovirt.org
> Sent: Tuesday, December 1, 2015 1:57:53 PM
> Subject: Re: [ovirt-users] Engine upgrade error
> 
> 
> 
> - Original Message -----
> > From: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> > To: "Eli Mesika" <emes...@redhat.com>
> > Cc: Users@ovirt.org
> > Sent: Tuesday, December 1, 2015 12:43:17 PM
> > Subject: Re: [ovirt-users] Engine upgrade error
> > 
> > Oh, that looks not so good...
> > 
> >                vds_id| network_name
> > --+--
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 |
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 |
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 |
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 |
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 |
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 |
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c | vlan111
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHNetzVLAN1
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c | ovirtmgmt
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHnetz
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
> >  2211ca5c-8d2c-42f3-939c-de11e085aa1c |
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 | vlan111
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 | KHNetzVLAN1
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 | ovirtmgmt
> >  6d9c0683-be85-4f70-9790-0f491b7c8021 | KHnetz
> > 
> > 
> > Now I have to drop something, I guess...
> 
> Alona, Yevgeny
> Table includes duplicate records and therefor
> dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_interface.sql
> fails on creating a unique constraint.
> Please advice
> 
> 1) What should be removed in that case
> 2) How can we fix the upgrade script to handle such cases in order that the
> full upgrade process will not fail ?
> 
> > 
> > Am Montag, den 30.11.2015, 18:04 -0500 schrieb Eli Mesika:
> > > 
> > > - Original Message -
> > > > From: "Oved Ourfali" <oourf...@redhat.com>
> > > > To: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> > > > Cc: Users@ovirt.org
> > > > Sent: Monday, November 30, 2015 6:45:17 PM
> > > > Subject: Re: [ovirt-users] Engine upgrade error
> > > > 
> > > > 
> > > > 
> > > > CC-ing Alona and Yevgeny from the network team to take a look.
> > > > 
> > > > Regards,
> > > > Oved Ourfali
> > > > On Nov 30, 2015 4:07 PM, "Frank Rothenstein" <
> > > > f.rothenst...@bodden-kliniken.de > wrote:
> > > > 
> > > > 
> > > > Hello,
> > > > 
> > > > I tried several times to upgrade my ovirt-engine 3.5.5 to 3.6.
> > > > Every
> > > > time the setup stops at updating the DB-schema. The log revealed
> > > > when
> > > > this happpens: The setup ist complaining about a duplicated key -
> > > > here
> > > > is the part of the log. Of course there is only one network in the
> > > > interface.
> > > > 
> > > > Can anybody help me getting a solution?
> > > 
> > > Can you please attach the result of the following query :
> > > 
> > > select vds_id, network_name from vds_interface;
> > > 
> > > Thanks
> > > 
> > > > 
> > > > Thnaks, Frank
> > > > 
> > > > Running upgrade sql script '/usr/share/ovirt-
> > > > engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_
> > > > inte
> > > > rface.sql'...
> > > > 2542964-
> > > > 2542965-2015-11-30 08:15:26 DEBUG
> > > > otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
> > > > plugin.execute:941 execute-output: ['/usr/share/ovirt-
> > > > engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u',
> > > > 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-
> > > > engine-setup-20151130073216-erdh9f.log', '-c', 'apply'] stderr:
> > > > 2543300-psql:/usr/share/ovirt-
> > > > engine/dbscripts

Re: [ovirt-users] Engine upgrade error

2015-11-30 Thread Eli Mesika


- Original Message -
> From: "Oved Ourfali" 
> To: "Frank Rothenstein" 
> Cc: Users@ovirt.org
> Sent: Monday, November 30, 2015 6:45:17 PM
> Subject: Re: [ovirt-users] Engine upgrade error
> 
> 
> 
> CC-ing Alona and Yevgeny from the network team to take a look.
> 
> Regards,
> Oved Ourfali
> On Nov 30, 2015 4:07 PM, "Frank Rothenstein" <
> f.rothenst...@bodden-kliniken.de > wrote:
> 
> 
> Hello,
> 
> I tried several times to upgrade my ovirt-engine 3.5.5 to 3.6. Every
> time the setup stops at updating the DB-schema. The log revealed when
> this happpens: The setup ist complaining about a duplicated key - here
> is the part of the log. Of course there is only one network in the
> interface.
> 
> Can anybody help me getting a solution?

Can you please attach the result of the following query :

select vds_id, network_name from vds_interface;

Thanks 

> 
> Thnaks, Frank
> 
> Running upgrade sql script '/usr/share/ovirt-
> engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_inte
> rface.sql'...
> 2542964-
> 2542965-2015-11-30 08:15:26 DEBUG
> otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
> plugin.execute:941 execute-output: ['/usr/share/ovirt-
> engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u',
> 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-
> engine-setup-20151130073216-erdh9f.log', '-c', 'apply'] stderr:
> 2543300-psql:/usr/share/ovirt-
> engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_inte
> rface.sql:1: ERROR: could not create unique index
> "vds_interface_vds_id_network_name_unique"
> 2543487:DETAIL: Key (vds_id, network_name)=(ba954f0f-6ecb-4ec8-b169-
> 7e0a1147b4cd, KHnetz) is duplicated.
> 2543585-CONTEXT: SQL statement "ALTER TABLE vds_interface ADD
> CONSTRAINT vds_interface_vds_id_network_name_unique unique (vds_id,
> network_name)"
> 2543723-PL/pgSQL function fn_db_create_constraint(character
> varying,character varying,text) line 4 at EXECUTE statement
> 2543835-FATAL: Cannot execute sql command: --file=/usr/share/ovirt-
> engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_inte
> rface.sql
> 2543975-
> 2543976-2015-11-30 08:15:26 DEBUG otopi.context
> context._executeMethod:156 method exception
> 2544060-Traceback (most recent call last):
> 2544095- File "/usr/lib/python2.7/site-packages/otopi/context.py",
> line 146, in _executeMethod
> 2544183- method['method']()
> 2544206- File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-
> engine-setup/ovirt-engine/db/schema.py", line 291, in _misc
> 2544325- oenginecons.EngineDBEnv.PGPASS_FILE
> 2544365- File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line
> 946, in execute
> 255- command=args[0],
> 2544466-RuntimeError: Command '/usr/share/ovirt-
> engine/dbscripts/schema.sh' failed to execute
> 2544552-2015-11-30 08:15:26 ERROR otopi.context
> context._executeMethod:165 Failed to execute stage 'Misc
> configuration': Command '/usr/share/ovirt-engine/dbscripts/schema.sh'
> failed to execute
> 2544737-2015-11-30 08:15:26 DEBUG otopi.transaction
> transaction.abort:134 aborting 'Yum Transaction'
> 2544830-2015-11-30 08:15:26 INFO
> otopi.plugins.otopi.packagers.yumpackager yumpackager.info:95 Yum
> Performing yum transaction rollback
> 
> 
> 
> 
> 
> __
> BODDEN-KLINIKEN Ribnitz-Damgarten GmbH
> Sandhufe 2
> 18311 Ribnitz-Damgarten
> 
> Telefon: 03821-700-0
> Fax: 03821-700-240
> 
> E-Mail: i...@bodden-kliniken.de Internet: http://www.bodden-kliniken.de
> 
> Sitz: Ribnitz-Damgarten, Amtsgericht: Stralsund, HRB 2919, Steuer-Nr.:
> 079/133/40188
> Aufsichtsratsvorsitzende: Carmen Schröter, Geschäftsführer: Dr. Falko Milski
> 
> Der Inhalt dieser E-Mail ist ausschließlich für den bezeichneten Adressaten
> bestimmt. Wenn Sie nicht der vorge-
> sehene Adressat dieser E-Mail oder dessen Vertreter sein sollten, beachten
> Sie bitte, dass jede Form der Veröf-
> fentlichung, Vervielfältigung oder Weitergabe des Inhalts dieser E-Mail
> unzulässig ist. Wir bitten Sie, sofort den
> Absender zu informieren und die E-Mail zu löschen.
> 
> 
> Bodden-Kliniken Ribnitz-Damgarten GmbH 2015
> *** Virenfrei durch Kerio Mail Server und Sophos Antivirus ***
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] [ovirt-devel] Controlling UI table column visibility and position

2015-11-25 Thread Eli Mesika


- Original Message -
> From: "Oved Ourfali" 
> To: "Vojtech Szocs" 
> Cc: "users" , "devel" 
> Sent: Wednesday, November 25, 2015 7:32:33 PM
> Subject: Re: [ovirt-devel] Controlling UI table column visibility and position
> 
> 
> 
> That's awesome!
> Looking forward to playing around with it!
> 
> Thanks,
> Oved
> On Nov 25, 2015 6:42 PM, "Vojtech Szocs" < vsz...@redhat.com > wrote:
> 
> 
> Dear developers and users,
> 
> it's now possible to tweak table column visibility and position
> through header context menu in WebAdmin's main & sub tabs [1,2].
> 
> [1] https://gerrit.ovirt.org/#/c/43401/
> [2] https://gerrit.ovirt.org/#/c/47542/
> 
> This allows you to turn "unwanted" columns off and re-arrange
> those which are visible to match your personal preference.
> 
> Screenshot of customizing VM main tab:
> 
> https://imgur.com/5dfh8QA

Really useful 
However, I would filter out status columns since this column does not have a 
title and also  I can not see a use-case of removing this column from the view 

> 
> There's also RFE [3] to persist (remember) such column settings
> in the browser, similar to persisting other client-side options.
> 
> [3] https://bugzilla.redhat.com/1285456
> 
> Regards,
> Vojtech
> ___
> Devel mailing list
> de...@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
> 
> ___
> Devel mailing list
> de...@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] [3.6] User can't create a VM. No permission for EDIT_ADMIN_VM_PROPERTIES

2015-11-23 Thread Eli Mesika


- Original Message -
> From: "Maksim Naumov" 
> To: "users" 
> Sent: Monday, November 23, 2015 11:18:09 AM
> Subject: Re: [ovirt-users] [3.6] User can't create a VM. No permission for
> EDIT_ADMIN_VM_PROPERTIES
> 
> CPU pinning topology is also not used in this template. And even there is no
> settings in the user interface to change it.
> 
> So, currently no one user is able to create new VM.

Seems to me as a bug 
Can you please open a bug, attach all relevant logs and also fully describe the 
template that you attempt to use to create the VM?

> 
> On Mon, Nov 23, 2015 at 8:54 AM, Maksim Naumov < maksim.nau...@hitmeister.de
> > wrote:
> 
> 
> 
> As I was able to understand this error mean that user tried to rewrite the
> destination host of VM. But the problem is that there is no setting like
> this in the user interface. User can't change the destination 100%. It is
> not hardcoded in the template settings because he was trying to run Base
> template (which is not attached to any host).
> 
> On Mon, Nov 23, 2015 at 8:36 AM, Maksim Naumov < maksim.nau...@hitmeister.de
> > wrote:
> 
> 
> 
> Hello
> 
> I faced with the problem. The user can;t create a VM. The user has
> PowerUserRole on Cluster. He tried to create a VM with a base template and
> had no success.
> 
> Here some lines from log. Have no idea why it wants for
> EDIT_ADMIN_VM_PROPERTIES permission for user?
> 
> 2015-11-20 16:42:10,888 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] Checking whether user
> 'acc9ced5-a764-4d60-84d7-db4b4a498a18' or one of the groups he is member of,
> have the following permissions: ID: a303bbca-af20-4de5-9eff-01c52d3bf615
> Type: VdsGroupsAction group CREATE_VM with role type USER, ID:
> ---- Type: VmTemplateAction group CREATE_VM
> with role type USER, ID: a303bbca-af20-4de5-9eff-01c52d3bf615 Type:
> VdsGroupsAction group EDIT_ADMIN_VM_PROPERTIES with role type ADMIN
> 2015-11-20 16:42:10,890 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] Found permission
> '129c57bb-df56-4529-93d9-52db0265263f' for user when running 'AddVm', on
> 'Cluster' with id 'a303bbca-af20-4de5-9eff-01c52d3bf615'
> 2015-11-20 16:42:10,893 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] Found permission
> '0004-0004-0004-0004-0355' for user when running 'AddVm', on
> 'Template' with id '----'
> 2015-11-20 16:42:10,894 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] No permission found for user when running
> action 'AddVm', on object 'Cluster' for action group
> 'EDIT_ADMIN_VM_PROPERTIES' with id 'a303bbca-af20-4de5-9eff-01c52d3bf615'.
> 2015-11-20 16:42:10,894 WARN [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] CanDoAction of action 'AddVm' failed for user
> vincent.en...@hitmeister.de@ hitmeister.de . Reasons:
> VAR__ACTION__ADD,VAR__TYPE__VM,USER_NOT_AUTHORIZED_TO_PERFORM_ACTION
> 
> --
> Maksim Naumov
> Hitmeister GmbH
> Softwareentwickler
> 
> Habsburgerring 2
> 50674 Köln
> 
> E: maksim.nau...@hitmeister.de
> www.hitmeister.de
> 
> HRB 59046, Amtsgericht Köln
> Geschäftsführer: Dr. Gerald Schönbucher
> 
> 
> 
> --
> Maksim Naumov
> Hitmeister GmbH
> Softwareentwickler
> 
> Habsburgerring 2
> 50674 Köln
> 
> E: maksim.nau...@hitmeister.de
> www.hitmeister.de
> 
> HRB 59046, Amtsgericht Köln
> Geschäftsführer: Dr. Gerald Schönbucher
> 
> 
> 
> --
> Maksim Naumov
> Hitmeister GmbH
> Softwareentwickler
> 
> Habsburgerring 2
> 50674 Köln
> 
> E: maksim.nau...@hitmeister.de
> www.hitmeister.de
> 
> HRB 59046, Amtsgericht Köln
> Geschäftsführer: Dr. Gerald Schönbucher
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] [3.6] Unable to create VM in user portal

2015-11-22 Thread Eli Mesika


- Original Message -
> From: "Maksim Naumov" 
> To: "users" 
> Sent: Friday, November 20, 2015 5:46:41 PM
> Subject: Re: [ovirt-users] [3.6] Unable to create VM in user portal
> 
> I found the following LOG entrie
> 
> What is this EDIT_ADMIN_VM_PROPERTIES ?

Hi
You are probably trying to set the list of hosts dedicated to run this VM or 
host CPU pinning 
For those you must be administrator 

> 
> 
> 2015-11-20 16:42:10,888 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] Checking whether user
> 'acc9ced5-a764-4d60-84d7-db4b4a498a18' or one of the groups he is member of,
> have the following permissions: ID: a303bbca-af20-4de5-9eff-01c52d3bf615
> Type: VdsGroupsAction group CREATE_VM with role type USER, ID:
> ---- Type: VmTemplateAction group CREATE_VM
> with role type USER, ID: a303bbca-af20-4de5-9eff-01c52d3bf615 Type:
> VdsGroupsAction group EDIT_ADMIN_VM_PROPERTIES with role type ADMIN
> 2015-11-20 16:42:10,890 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] Found permission
> '129c57bb-df56-4529-93d9-52db0265263f' for user when running 'AddVm', on
> 'Cluster' with id 'a303bbca-af20-4de5-9eff-01c52d3bf615'
> 2015-11-20 16:42:10,893 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] Found permission
> '0004-0004-0004-0004-0355' for user when running 'AddVm', on
> 'Template' with id '----'
> 2015-11-20 16:42:10,894 DEBUG [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] No permission found for user when running
> action 'AddVm', on object 'Cluster' for action group
> 'EDIT_ADMIN_VM_PROPERTIES' with id 'a303bbca-af20-4de5-9eff-01c52d3bf615'.
> 2015-11-20 16:42:10,894 WARN [org.ovirt.engine.core.bll.AddVmCommand]
> (default task-160) [2f0eb905] CanDoAction of action 'AddVm' failed for user
> vincent.en...@hitmeister.de@ hitmeister.de . Reasons:
> VAR__ACTION__ADD,VAR__TYPE__VM,USER_NOT_AUTHORIZED_TO_PERFORM_ACTION
> 
> 
> 
> On Fri, Nov 20, 2015 at 3:29 PM, Maksim Naumov < maksim.nau...@hitmeister.de
> > wrote:
> 
> 
> 
> Hello
> 
> User in the User portal un able to create virtual machine. Everytime I see en
> error " User is not authorized to perform this action. "
> I tried different roles: VmCreator + DiskCreator, PowerUserRole,
> UserVmManager  even a new role with all the permissions - no way!
> 
> Can you give a 100% working example how should I setup role for user to be
> abte to create a VM?
> 
> Thank you
> 
> --
> Maksim Naumov
> Hitmeister GmbH
> Softwareentwickler
> 
> Habsburgerring 2
> 50674 Köln
> 
> E: maksim.nau...@hitmeister.de
> www.hitmeister.de
> 
> HRB 59046, Amtsgericht Köln
> Geschäftsführer: Dr. Gerald Schönbucher
> 
> 
> 
> --
> Maksim Naumov
> Hitmeister GmbH
> Softwareentwickler
> 
> Habsburgerring 2
> 50674 Köln
> 
> E: maksim.nau...@hitmeister.de
> www.hitmeister.de
> 
> HRB 59046, Amtsgericht Köln
> Geschäftsführer: Dr. Gerald Schönbucher
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] oVirt - High Availability

2015-10-14 Thread Eli Mesika


- Original Message -
> From: "Indunil Jayasooriya" <induni...@gmail.com>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: users@ovirt.org
> Sent: Tuesday, October 13, 2015 6:25:59 PM
> Subject: Re: [ovirt-users] oVirt - High Availability
> 
> Hi,
> 
> Thank you very much for your reply.
> 
> I would like to know in which cases HA will happen?
> 
> 1. network failure? ( i.e , if we accidentally remove the network cable or
> if network card stopped working due to some reasons. )
> 
> 2. Server is suddenly shut-down due to power failure (i.e - NOT a proper
> shut-down ) or due to server  Hardware failure such as motherboard or
> processor.
> 
> 3. accidental reboot ?

Basically yes for all 3 
in case of 1)
There is a grace period that depends on the host load we give the host to get 
UP again and if that grace period passes then host is rebooted and HA VMs are 
atetmpted  to run on a different host 

> 
> 
> WILL HA will happen when above mentioned things happen?
> 
> 
> YES or NO?
> 
> Hope to hear from you?
> 
> 
> On Tue, Oct 13, 2015 at 7:33 PM, Eli Mesika <emes...@redhat.com> wrote:
> 
> >
> >
> > - Original Message -
> > > From: "Indunil Jayasooriya" <induni...@gmail.com>
> > > To: users@ovirt.org
> > > Sent: Tuesday, October 13, 2015 6:13:22 AM
> > > Subject: [ovirt-users] oVirt - High Availability
> > >
> > > Hi users,
> > >
> > >
> > > I have setup OVIRT 3.5 with 2 REDHAT 7.1 hosts. Everything is ok other
> > than
> > > HA ( High Availability). To test HA, Documentation says, Power
> > Management is
> > > needed.
> > >
> > > Could you pls let me know if this Power Management is a separate Device
> > or
> > > does it come with a BRANDED Server such as HP, IBM or Dell?
> >
> > PM can be implemented by a separate card or come as part of a  BRANDED
> > Server such as HP, IBM or Dell.
> >
> > >
> > > I have seen a ILO port in HP servers. Can I use it for HA ( High
> > > Availability) in ovirt?
> >
> > Yes you can, ILO is one of the PM devices supported by oVirt
> >
> > >
> > > If power management is present in Branded Servers , Could you pls let me
> > know
> > > some Branded RHEL 7.1/CentOS 7.1 supported servers?
> > >
> > > Then, I can use it for Production use.
> > >
> > >
> > > This is an YOU TUBE video for HA.
> > >
> > > https://www.youtube.com/watch?v=uHCnXGUMaS0
> > >
> > > Is this a correct video for HA?
> >
> > Please see also https://www.youtube.com/watch?v=IuRPGU7nF1E
> >
> > >
> > >
> > > I did some research.
> > >
> > > a few URLs.
> > >
> > >
> > > http://lists.ovirt.org/pipermail/users/2013-January/011519.html
> > >
> > > http://www.ovirt.org/OVirt_Administration_Guide#Host_Resilience
> > >
> > >
> > https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.5/html/Administration_Guide/sect-Improving_Uptime_with_Virtual_Machine_High_Availability.html
> > >
> > >
> > > what is Soft-Fencing Hosts ? ovirt doc gives below . (
> > > http://www.ovirt.org/OVirt_Administration_Guide#Host_Resilience )
> > >
> > > Soft-Fencing Hosts
> > >
> > >
> > > Sometimes a host becomes non-responsive due to an unexpected problem, and
> > > though VDSM is unable to respond to requests, the virtual machines that
> > > depend upon VDSM remain alive and accessible. In these situations,
> > > restarting VDSM returns VDSM to a responsive state and resolves this
> > issue.
> > >
> > > oVirt 3.3 introduces "soft-fencing over SSH". Prior to oVirt 3.3,
> > > non-responsive hosts were fenced only by external fencing devices. In
> > oVirt
> > > 3.3, the fencing process has been expanded to include "SSH Soft
> > Fencing", a
> > > process whereby oVirt attempts to restart VDSM via SSH on non-responsive
> > > hosts. If oVirt fails to restart VDSM via SSH, the responsibility for
> > > fencing falls to the external fencing agent if an external fencing agent
> > has
> > > been configured.
> > >
> > >
> > > BUT, It does NOT say how to set it up?
> > >
> > >
> > > is there any step by step doc for it?
> >
> > There is no need to set it up, soft-fencing is simply VDSM service restart
>

Re: [ovirt-users] oVirt - High Availability

2015-10-13 Thread Eli Mesika


- Original Message -
> From: "Indunil Jayasooriya" 
> To: users@ovirt.org
> Sent: Tuesday, October 13, 2015 6:13:22 AM
> Subject: [ovirt-users] oVirt - High Availability
> 
> Hi users,
> 
> 
> I have setup OVIRT 3.5 with 2 REDHAT 7.1 hosts. Everything is ok other than
> HA ( High Availability). To test HA, Documentation says, Power Management is
> needed.
> 
> Could you pls let me know if this Power Management is a separate Device or
> does it come with a BRANDED Server such as HP, IBM or Dell?

PM can be implemented by a separate card or come as part of a  BRANDED Server 
such as HP, IBM or Dell.

> 
> I have seen a ILO port in HP servers. Can I use it for HA ( High
> Availability) in ovirt?

Yes you can, ILO is one of the PM devices supported by oVirt 

> 
> If power management is present in Branded Servers , Could you pls let me know
> some Branded RHEL 7.1/CentOS 7.1 supported servers?
> 
> Then, I can use it for Production use.
> 
> 
> This is an YOU TUBE video for HA.
> 
> https://www.youtube.com/watch?v=uHCnXGUMaS0
> 
> Is this a correct video for HA?

Please see also https://www.youtube.com/watch?v=IuRPGU7nF1E

> 
> 
> I did some research.
> 
> a few URLs.
> 
> 
> http://lists.ovirt.org/pipermail/users/2013-January/011519.html
> 
> http://www.ovirt.org/OVirt_Administration_Guide#Host_Resilience
> 
> https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.5/html/Administration_Guide/sect-Improving_Uptime_with_Virtual_Machine_High_Availability.html
> 
> 
> what is Soft-Fencing Hosts ? ovirt doc gives below . (
> http://www.ovirt.org/OVirt_Administration_Guide#Host_Resilience )
> 
> Soft-Fencing Hosts
> 
> 
> Sometimes a host becomes non-responsive due to an unexpected problem, and
> though VDSM is unable to respond to requests, the virtual machines that
> depend upon VDSM remain alive and accessible. In these situations,
> restarting VDSM returns VDSM to a responsive state and resolves this issue.
> 
> oVirt 3.3 introduces "soft-fencing over SSH". Prior to oVirt 3.3,
> non-responsive hosts were fenced only by external fencing devices. In oVirt
> 3.3, the fencing process has been expanded to include "SSH Soft Fencing", a
> process whereby oVirt attempts to restart VDSM via SSH on non-responsive
> hosts. If oVirt fails to restart VDSM via SSH, the responsibility for
> fencing falls to the external fencing agent if an external fencing agent has
> been configured.
> 
> 
> BUT, It does NOT say how to set it up?
> 
> 
> is there any step by step doc for it?

There is no need to set it up, soft-fencing is simply VDSM service restart on 
the server side and is done always whether you configured PM on the host or not 
as a first step when you host is not-responding 


> 
> 
> 
> 
> 
> HOPE TO hear from you?
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> cat /etc/motd
> 
> Thank you
> Indunil Jayasooriya
> http://www.theravadanet.net/
> http://www.siyabas.lk/sinhala_how_to_install.html - Download Sinhala Fonts
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Support for windows10

2015-10-06 Thread Eli Mesika
CCing Vinzenz 

- Original Message -
> From: "Budur Nagaraju" 
> To: "users" 
> Sent: Tuesday, October 6, 2015 8:59:50 AM
> Subject: [ovirt-users] Support for windows10
> 
> Hi
> 
> Does Ovirt supports windows 10 OS ?
> 
> Thanks,
> Nagaraju
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] HA - Fencing not working when host with engine gets shutdown

2015-09-24 Thread Eli Mesika


- Original Message -
> From: "Martin Perina" 
> To: "Michael Hölzl" 
> Cc: users@ovirt.org
> Sent: Thursday, September 24, 2015 11:02:21 AM
> Subject: Re: [ovirt-users] HA - Fencing not working when host with engine 
> gets shutdown
> 
> Hi,
> 
> sorry for the late response, but you hit a "corner case" :-(
> 
> Let me start explain you a few things first:
> 
> After startup of engine there's an internval during which fencing is
> disabled. It's called DisableFenceAtStartupInSec and by default it's
> set to 5 minutes. It can be changed using
> 
>engine-config -s DisableFenceAtStartupInSec
> 
> but please do that with caution.
> 
> Why do we have such timeout? It's a prevention of fencing storm, which
> could happen in during power issues in whole DC: when both engine and
> hosts are started, for huge hosts it may take a lot of time until become
> up and VDSM start to communicate with engine. So usually engine is started
> first and without this interval engine will start fencing for hosts which
> are just starting ...
> 
> Another thing: if we cannot properly fence the host, we cannot determine
> if there's not just communication issue between engine and host, so we
> cannot restart HA VMs on another host. The only thing we can do is to
> offer "Mark host as rebooted" manual option to administrator. If
> administrator execution this option, we try to restart HA VMs on different
> host ASAP, because admin took the responsibility of validation that VMs
> are really not running.
> 
> 
> When engine is started, following actions related to fencing are taken:
> 
> 1. Get status of all hosts from DB and schedule Non Responding Treatment
>after DisableFenceAtStartupInSec timeout is passed
> 
> 2. Try to communicate with all host and refresh their status
> 
> 
> If some host become Non Resposive during DisableFenceAtStartupInSec interval
> we skip fencing and administator will see message in Events tab that host
> is Non Responsive, but fencing is disabled due to startup interval. So
> administrator have to take care of such host manually.
> 
> 
> Now what happened in your case:
> 
>  1. Hosted engine VM is running on host1 with other VMs
>  2. Status of host1 and host2 is Up
>  3. You kill/shutdown host1 -> hosted engine VM is also shut down -> no
>  engine
> is running to detect issue with host1 and change its status to Non
> Responsive
>  4. In the meantime hosted engine VM is started on host2 -> it will read host
> status from DB, but all hosts are up -> it will try to communicate with
> host1,
> but it's unreachable -> so it changes host1 status Non Responsive and
> starts
> Non Responsive Treatment for host1 -> Non Responsive Treatment is aborted
> because engine is still in DisableFenceAtStartupInSec
> 
> 
> So in normal deployment (without hosted engine) admin is notified that host,
> where engine is running, crashed and was rebooted, so he has to take a look
> and do manual steps if needed.
> 
> In hosted engine deployment it's an issue because hosted engine VM can be
> restart
> on different host also in other cases then crashes (for example if host is
> overloaded hosted engine can stop hosted engine VM and restart it on
> different
> host, but this shouldn't happen too often).
> 
> At the moment the only solution for this is manual: let administrator to be
> notified that host engine VM is restarted on different host, so administrator
> can check manually what was the cause for this restart and execute manual
> steps
> if needed.
> 
> So to summarize: at the moment I don't see any reliable automatic solution
> for this :-( and fencing storm prevention is more important. But feel free to
> create
> a bug for this issue, maybe we can think of at least some improvement for
> this use
> case.

Thanks for the detailed explanation Martin 
Really a corner case, lets see if we got more inputs on that from other users
Maybe when hosted engine VM is restarted on another node we can ask for the 
reason and act accordingly 
Doron, with current implementation, is the reason for hosted engine VM restart 
stored anywhere ? 

> 
> 
> Thanks
> 
> Martin Perina
> 
> - Original Message -
> > From: "Michael Hölzl" 
> > To: "Martin Perina" 
> > Cc: users@ovirt.org
> > Sent: Monday, September 21, 2015 4:47:06 PM
> > Subject: Re: [ovirt-users] HA - Fencing not working when host with engine
> > gets shutdown
> > 
> > Hi,
> > 
> > The whole engine.log including the shutdown time (was performed around
> > 9:19)
> > http://pastebin.com/cdY9uTkJ
> > 
> > vdsm.log of host01 (the host which kept on running and took over the
> > engine) split into 3 uploads (limit of 512 kB of pastebin):
> > 1 : http://pastebin.com/dr9jNTek
> > 2 : http://pastebin.com/cuyHL6ne
> > 3 : http://pastebin.com/7x2ZQy1y
> > 
> > Michael
> > 
> > On 09/21/2015 03:00 PM, Martin Perina wrote:
> > > Hi,
> > >
> > > could you 

Re: [ovirt-users] backup and restore the vm

2015-09-24 Thread Eli Mesika


- Original Message -
> From: "Budur Nagaraju" 
> To: users@ovirt.org
> Sent: Tuesday, September 22, 2015 1:24:17 PM
> Subject: [ovirt-users] backup and restore the vm
> 
> Hi
> 
> can you pls provide me the tools to backup and restore the vm images in
> Ovirt?

Please take a look at
http://www.ovirt.org/Features/Backup-Restore_API_Integration

> 
> Thanks,
> Nagaraju
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] moving storage and importing vms issue

2015-09-10 Thread Eli Mesika


- Original Message -
> From: "Jiří Sléžka" 
> To: users@ovirt.org
> Sent: Thursday, September 10, 2015 1:30:29 AM
> Subject: [ovirt-users] moving storage and importing vms issue
> 
> Hello,
> 
> I am working on some consolidation of our RHEV/oVirt servers and I moved
> one storage to new oVirt datacenter (put it into maintenance, detached
> it from old and imported into new datacenter) which worked pretty good.
> 
> Then I tried to import all the vms which worked also great except for
> three of them.
> 
> These vms are stucked in VM Import sub-tab and are quietly failing
> import attempts (I can only see failed task "Importing VM clavius-winxp
> from configuration to Cluster CIT-oVirt" but no related event and/or
> explanation)
> 
> There is only one host in this datacenter/cluster which is SPM. I can't
> find anything interesting in vdsm.log (short span of import time is in
> attachment).

Can you please attach also engine.log ?

> 
> Could you point me where should I look, please?
> 
> Storage (FC) was formerly attached to RHEV3.5.3 on RHEL6.7 and was
> imported into oVirt3.5.4 on CentOS7.1
> 
> Thanks in advance,
> 
> Jiri Slezka
> 
> 
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] moving storage and importing vms issue

2015-09-10 Thread Eli Mesika


- Original Message -
> From: "Jiří Sléžka" 
> To: emes...@redhat.com
> Cc: users@ovirt.org
> Sent: Thursday, September 10, 2015 1:50:14 PM
> Subject: Re: [ovirt-users] moving storage and importing vms issue
> 
> Hello,
> 
> > - Original Message -
> >> From: "Jiří Sléžka" 
> >> To: users@ovirt.org
> >> Sent: Thursday, September 10, 2015 1:30:29 AM
> >> Subject: [ovirt-users] moving storage and importing vms issue
> >>
> >> Hello,
> >>
> >> I am working on some consolidation of our RHEV/oVirt servers and I moved
> >> one storage to new oVirt datacenter (put it into maintenance, detached
> >> it from old and imported into new datacenter) which worked pretty good.
> >>
> >> Then I tried to import all the vms which worked also great except for
> >> three of them.
> >>
> >> These vms are stucked in VM Import sub-tab and are quietly failing
> >> import attempts (I can only see failed task "Importing VM clavius-winxp
> >> from configuration to Cluster CIT-oVirt" but no related event and/or
> >> explanation)
> >>
> >> There is only one host in this datacenter/cluster which is SPM. I can't
> >> find anything interesting in vdsm.log (short span of import time is in
> >> attachment).
> >
> > Can you please attach also engine.log ?
> 
> sure
> 
> well, here I can see an error... it looks like some db and/or snapshot
> issue.

Yes, seems as ImportVmFromConfigurationCommand tries to add snapshots with the 
empty GUID (000..0) 
This cause violation of the primary key of the snapshots table 
CCing Omer F on that 

> 
> well and it looks like I lost also one secondary disk from one correctly
> imported vm.
> 
> is there a way to show all images on some storage domain?
> 
> I found that my storage is this
> 
> [root@ovirt04 ~]# vdsClient -s 0 getStorageDomainInfo
> 088e7ed9-84c7-4fbd-a570-f37fa986a772
>   uuid = 088e7ed9-84c7-4fbd-a570-f37fa986a772
>   vguuid = MkMpr6-o9c1-LBUq-rZ0E-ZRSg-X31T-2aU1PV
>   state = OK
>   version = 3
>   role = Master
>   type = FCP
>   class = Data
>   pool = ['0002-0002-0002-0002-02b9']
>   name = oVirt-SlowStorage
> 
> but I have no luck with finding how to display all images on it.

try 

# vdsClient -s getImagesList "088e7ed9-84c7-4fbd-a570-f37fa986a772"



> 
> Thanks,
> 
> Jiri
> 
> 
> >
> >>
> >> Could you point me where should I look, please?
> >>
> >> Storage (FC) was formerly attached to RHEV3.5.3 on RHEL6.7 and was
> >> imported into oVirt3.5.4 on CentOS7.1
> >>
> >> Thanks in advance,
> >>
> >> Jiri Slezka
> >>
> >>
> >> ___
> >> Users mailing list
> >> Users@ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> 
> 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] moving storage and importing vms issue

2015-09-10 Thread Eli Mesika
Adding Allon M 

- Original Message -
> From: "Jiří Sléžka" <jiri.sle...@slu.cz>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: users@ovirt.org, "Omer Frenkel" <ofren...@redhat.com>
> Sent: Thursday, September 10, 2015 4:07:48 PM
> Subject: Re: [ovirt-users] moving storage and importing vms issue
> 
> Hello,
> 
> > - Original Message -
> >> From: "Jiří Sléžka" <jiri.sle...@slu.cz>
> >> To: emes...@redhat.com
> >> Cc: users@ovirt.org
> >> Sent: Thursday, September 10, 2015 1:50:14 PM
> >> Subject: Re: [ovirt-users] moving storage and importing vms issue
> >>
> >> Hello,
> >>
> >>> - Original Message -
> >>>> From: "Jiří Sléžka" <jiri.sle...@slu.cz>
> >>>> To: users@ovirt.org
> >>>> Sent: Thursday, September 10, 2015 1:30:29 AM
> >>>> Subject: [ovirt-users] moving storage and importing vms issue
> >>>>
> >>>> Hello,
> >>>>
> >>>> I am working on some consolidation of our RHEV/oVirt servers and I moved
> >>>> one storage to new oVirt datacenter (put it into maintenance, detached
> >>>> it from old and imported into new datacenter) which worked pretty good.
> >>>>
> >>>> Then I tried to import all the vms which worked also great except for
> >>>> three of them.
> >>>>
> >>>> These vms are stucked in VM Import sub-tab and are quietly failing
> >>>> import attempts (I can only see failed task "Importing VM clavius-winxp
> >>>> from configuration to Cluster CIT-oVirt" but no related event and/or
> >>>> explanation)
> >>>>
> >>>> There is only one host in this datacenter/cluster which is SPM. I can't
> >>>> find anything interesting in vdsm.log (short span of import time is in
> >>>> attachment).
> >>>
> >>> Can you please attach also engine.log ?
> >>
> >> sure
> >>
> >> well, here I can see an error... it looks like some db and/or snapshot
> >> issue.
> >
> > Yes, seems as ImportVmFromConfigurationCommand tries to add snapshots with
> > the empty GUID (000..0)
> > This cause violation of the primary key of the snapshots table
> > CCing Omer F on that
> >
> >>
> >> well and it looks like I lost also one secondary disk from one correctly
> >> imported vm.
> >>
> >> is there a way to show all images on some storage domain?
> >>
> >> I found that my storage is this
> >>
> >> [root@ovirt04 ~]# vdsClient -s 0 getStorageDomainInfo
> >> 088e7ed9-84c7-4fbd-a570-f37fa986a772
> >>uuid = 088e7ed9-84c7-4fbd-a570-f37fa986a772
> >>vguuid = MkMpr6-o9c1-LBUq-rZ0E-ZRSg-X31T-2aU1PV
> >>state = OK
> >>version = 3
> >>role = Master
> >>type = FCP
> >>class = Data
> >>pool = ['0002-0002-0002-0002-02b9']
> >>name = oVirt-SlowStorage
> >>
> >> but I have no luck with finding how to display all images on it.
> >
> > try
> >
> > # vdsClient -s getImagesList "088e7ed9-84c7-4fbd-a570-f37fa986a772"
> 
> yes, it works :-)
> 
> now I have list of imgUUIDs on this storage. When I compare it against
> Disks tab in oVirt manager a see 5 images that are not visible in manager.
> 
> 346ad5af-9db8-46eb-9a45-172ce3213496
> 45493042-67f5-4dcd-8dae-5b2c213aa95a
> fb8f3165-5976-4094-9d37-ea0b09124547
> e15288bc-30ec-4a77-837b-bdc7de37a08b
> be5c56de-6a22-4d1a-8579-f0f5d501d90c
> 
> now I tried to find anything about these images
> 
> [root@ovirt04 ~]# vdsClient -s 0 getVolumesList
> "088e7ed9-84c7-4fbd-a570-f37fa986a772"
> "0002-0002-0002-0002-02b9"
> "346ad5af-9db8-46eb-9a45-172ce3213496"
> eeca0e49-ba6d-4b4b-9eb4-731b90b48091 : Exported by virt-v2v.
> da00feb8-991d-4b91-b424-6931daf00c83 : Parent is
> eeca0e49-ba6d-4b4b-9eb4-731b90b48091
> 
> 
> 
> [root@ovirt04 ~]# vdsClient -s 0 getVolumesList
> "088e7ed9-84c7-4fbd-a570-f37fa986a772"
> "0002-0002-0002-0002-02b9"
> "45493042-67f5-4dcd-8dae-5b2c213aa95a"
> 
> d2916b5d-50e4-482c-aa6b-e26d2c78ef46 : Exported by virt-v2v.
> 
> 
> 
> [root@ovirt04 ~]# vdsClient -s 0 getVolumesList
> "088e7ed9-84c7-4fbd-a570-f37fa986a772"
> "0002-0002-0002-0002-02b9"
&g

[ovirt-users] Videoes on 3.6 features

2015-09-03 Thread Eli Mesika
Hi all

The following 3.6 videos on new features were omitted from last Brian P report: 

oVirt 3.6 power management UI changes : 
https://www.youtube.com/watch?v=AkfAMpEykdU=1
oVirt 3.6 external status for host & storage domain  : 
https://www.youtube.com/watch?v=xUIbNeN-AxA=1

Thanks
Eli Mesika

___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Automatically start VM after host reboot

2015-08-30 Thread Eli Mesika


- Original Message -
 From: gregor gregor_fo...@catrix.at
 To: Users@ovirt.org
 Sent: Sunday, August 30, 2015 2:30:00 PM
 Subject: [ovirt-users] Automatically start VM after host reboot
 
 Hi,
 
 I installed oVirt allinone, is there a way to automatically start
 certain VM's after the host reboots?

See
http://lists.ovirt.org/pipermail/users/2014-November/029424.html

 
 cheers
 gregor
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] searching vm disks according to vm tags

2015-08-30 Thread Eli Mesika


- Original Message -
 From: Yaniv Dary yd...@redhat.com
 To: Eli Mesika emes...@redhat.com, Liron Kuchlani lkuch...@redhat.com
 Sent: Sunday, August 30, 2015 2:30:55 PM
 Subject: Fwd: [ovirt-users] searching vm disks according to vm tags
 
 Yaniv Dary
 Technical Product Manager
 Red Hat Israel Ltd.
 34 Jerusalem Road
 Building A, 4th floor
 Ra'anana, Israel 4350109
 
 Tel : +972 (9) 7692306
 8272306
 Email: yd...@redhat.com
 IRC : ydary
 
 
 -- Forwarded message --
 From: Jiří Sléžka jiri.sle...@slu.cz
 Date: Thu, Aug 27, 2015 at 11:41 AM
 Subject: [ovirt-users] searching vm disks according to vm tags
 To: users@ovirt.org users@ovirt.org
 
 
 Hello,
 
 Is there a possibility to filter (in manager) all disks which belongs to
 vms with certain tag? If not I think it would be useful. What do you think?

Currently the Disks TAB in webadmin does not support searching by tag, you may 
open a RFE for that 

 
 I am trying this: I have about 50 vms with disks on different storages. I
 have tagged some from this vms by tag migrate_to_new_storage and then I
 would like to move all appropriate disks to new storage. It seems it is not
 possible from manager (in simple way - it looks like I have to filter vms
 by tag, then click on every of them, choose disks tab, select them, click
 move,...).
 
 It would also be nice to have possibility to filter by tags also with
 boolean operator AND and not just OR.

There is already a RFE for that
For doing so we should add a TAB in the webadmin for Tags that will enable that
The challenge is that the result can be mixed entities (hosts, vms etc...), not 
trivial to display in one result list ...


 
 
 Cheers,
 
 Jiri
 
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] vm status

2015-08-27 Thread Eli Mesika


- Original Message -
 From: InterNetX - Juergen Gotteswinter j...@internetx.com
 To: Michael Wagenknecht wagenkne...@fuh-e.de, users@ovirt.org
 Sent: Tuesday, August 25, 2015 8:48:55 PM
 Subject: Re: [ovirt-users] vm status
 
 if the vm is really down, you whould find this helpful

This will work only if the VM status is LOCKED for any other status, it will do 
nothing 

 
 [root@portal dbscripts]# ./unlock_entity.sh -h
 Usage: ./unlock_entity.sh [options] [ENTITIES]
 
 -h- This help text.
 -v- Turn on verbosity (WARNING:
 lots of output)
 -l LOGFILE- The logfile for capturing output  (def. )
 -s HOST   - The database servername for the database  (def.
 localhost)
 -p PORT   - The database port for the database(def. 5432)
 -u USER   - The username for the database (def. engine)
 -d DATABASE   - The database name (def. engine)
 -t TYPE   - The object type {vm | template | disk | snapshot}
 -r- Recursive, unlocks all disks under the selected
 vm/template.
 -q- Query db and display a list of the locked entites.
 ENTITIES  - The list of object names in case of vm/template,
 UUIDs in case of a disk
 
 NOTE: This utility access the database and should have the
   corresponding credentals.
 
   In case that a password is used to access the database PGPASSWORD
   or PGPASSFILE should be set.
 
 Example:
 $ PGPASSWORD=xx ./unlock_entity.sh -t disk -q
 
 [root@portal dbscripts]# pwd
 /usr/share/ovirt-engine/dbscripts
 [root@portal dbscripts]#
 
 
 Am 25.08.2015 um 07:33 schrieb Michael Wagenknecht:
  Hi all,
  how can I mark a VM as shut down when the status of the VM is ??
  There is no qemu-kvm process for this VM on the node.
  But I can't set the node to maintenance mode, because there is a very
  important VM running.
  
  Best Regards,
  Michael
  ___
  Users mailing list
  Users@ovirt.org
  http://lists.ovirt.org/mailman/listinfo/users
  
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Hanging Tasks

2015-08-02 Thread Eli Mesika


- Original Message -
 From: Arsène Gschwind arsene.gschw...@unibas.ch
 To: Raz Tamir rata...@redhat.com, Donny Davis do...@cloudspin.me
 Cc: users users@ovirt.org
 Sent: Thursday, July 30, 2015 5:40:48 PM
 Subject: Re: [ovirt-users] Hanging Tasks
 
 correct, I'm not able to see it on the Hosts.
 Is there a way to remove it from the engine host?

Well, there we 2 Bugs that were resolved for 3.6 on that 
Meanwhile , you can try the following 

 psql -U db user -c delete from job where description ilike '%Handling non 
 responsive Host%'; db name

 
 Thanks,
 Arsène
 
 On 07/30/2015 04:00 PM, Raz Tamir wrote:
 
 
 
 This is not async_task so vdsClient is useless in this case
 
 
 
 
 Thanks,
 Raz Tamir
 Red Hat Israel
 
 
 From: Donny Davis do...@cloudspin.me
 To: Arsène Gschwind arsene.gschw...@unibas.ch
 Cc: users users@ovirt.org
 Sent: Thursday, July 30, 2015 4:38:13 PM
 Subject: Re: [ovirt-users] Hanging Tasks
 
 
 
 You can use the vdsClient CLI to remove tasks.
 On Jul 30, 2015 9:37 AM, Arsène Gschwind  arsene.gschw...@unibas.ch 
 wrote:
 
 
 
 The tasks are : Handling non responsive Host xxx
 They hang since July 22. and I think they will not timeout...
 
 Do I have to use the engine CLI to kill them?
 
 Thanks for your help.
 rgds,
 Arsène
 
 On 07/30/2015 03:31 PM, Donny Davis wrote:
 
 
 
 
 Just wait for them to timeout. They can be killed from the CLI. What is the
 task?
 On Jul 30, 2015 9:30 AM, Arsène Gschwind  arsene.gschw...@unibas.ch 
 wrote:
 
 
 Hi,
 
 I've searched around but couldn't find a solution.
 Is there a way to kill/remove hanging tasks in the oVirt admin portal?
 
 Thanks for any hint.
 rgds,
 Arsène
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
 
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] broken vdsm installation because of fence-agents-compute

2015-06-24 Thread Eli Mesika
Adding Marek Grac 

- Original Message -
 From: Nathanaël Blanchet blanc...@abes.fr
 To: users@ovirt.org
 Sent: Wednesday, June 24, 2015 1:46:07 PM
 Subject: [ovirt-users] broken vdsm installation because of
 fence-agents-compute
 
 Hi, I failed to install this morning a new host, with that dependence issue:
 Failed to execute stage 'Package installation':
 [u'fence-agents-all-4.0.11-13.el7_1.x86_64 requires fence-agents-compute'].
  From a yum view, I get this :
 Erreur : Paquet : fence-agents-all-4.0.11-13.el7_1.x86_64 (updates)
   Requiert : fence-agents-compute
 
 I installed some other hosts last week without problem, the issue seems
 to come from the update of fence-agents  with the 13 tag (previous 11
 worked fine)
 
 --
 Nathanaël Blanchet
 
 Supervision réseau
 Pôle Infrastrutures Informatiques
 227 avenue Professeur-Jean-Louis-Viala
 34193 MONTPELLIER CEDEX 5
 Tél. 33 (0)4 67 54 84 55
 Fax  33 (0)4 67 54 84 14
 blanc...@abes.fr
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] spm changes hourly due to unexpected error of getAllTasksStatuses

2015-06-23 Thread Eli Mesika


- Original Message -
 From: like ma like...@cs2c.com.cn
 To: de...@ovirt.org, users@ovirt.org
 Sent: Tuesday, June 23, 2015 11:26:17 AM
 Subject: [ovirt-users] spm changes hourly due to unexpected error of  
 getAllTasksStatuses
 
 Hello all,
 
 In our ovirt environment(oVirt 3.4.4), we have 2 hosts, and the spm changes
 hourly between the 2 hosts. In the events of DataCenters there is following
 message each hour:
 'Data Center is being initialized, please wait for initialization to
 complete'
 
 In the vdsm.log i found following error message:
 Thread-13::ERROR::2015-06-23
 13:38:36,667::task::866::TaskManager.Task::(_setError)
 Task=`e450d7d6-771d-4c51-90b7-c6b10da37897`::Unexpected error
 Traceback (most recent call last):
 File /usr/share/vdsm/storage/task.py, line 873, in _run
 return fn(*args, **kargs)
 File /usr/share/vdsm/logUtils.py, line 45, in wrapper
 res = f(*args, **kwargs)
 File /usr/share/vdsm/storage/hsm.py, line 2125, in getAllTasksStatuses
 allTasksStatus = sp.getAllTasksStatuses()
 File /usr/share/vdsm/storage/securable.py, line 73, in wrapper
 raise SecureError(Secured object is not in safe state)
 SecureError: Secured object is not in safe state
 
 The attachment is vdsm.log and engine.log. The error occured at 2015-06-23
 13:38 and 2015-06-23 15:38 in vdsm.log.
 (by the way, in the other host the error occured at 2015-06-23 12:38 and
 2015-06-23 14:38 )
 
 And in the engine.log i found following error message:
 2015-06-23 13:38:37,933 ERROR
 [org.ovirt.engine.core.vdsbroker.irsbroker.IrsBrokerCommand]
 (DefaultQuartzScheduler_Worker-34) [781beaea] IrsBroker::Failed::UpdateVMVDS
 due to: XmlRpcException: type 'exceptions.UnicodeDecodeError':'utf8' codec
 can't decode byte 0xeb in position 749: invalid continuation byte
 
 2015-06-23 13:38:37,971 ERROR [org.ovirt.engine.core.bll.OvfDataUpdater]
 (DefaultQuartzScheduler_Worker-34) [781beaea] Exception while trying to
 update or remove VMs/Templates ovf in Data Center Default.:
 org.ovirt.engine.core.common.errors.VdcBLLException: VdcBLLException:
 java.lang.reflect.UndeclaredThrowableException (Failed with error
 VDS_NETWORK_ERROR and code 5022)
 at org.ovirt.engine.core.bll.VdsHandler.handleVdsResult(VdsHandler.java:116)
 [bll.jar:]
 at
 org.ovirt.engine.core.bll.VDSBrokerFrontendImpl.RunVdsCommand(VDSBrokerFrontendImpl.java:33)
 [bll.jar:]
 at
 org.ovirt.engine.core.bll.OvfDataUpdater.executeUpdateVmInSpmCommand(OvfDataUpdater.java:383)
 [bll.jar:]
 at
 org.ovirt.engine.core.bll.OvfDataUpdater.performOvfUpdate(OvfDataUpdater.java:163)
 [bll.jar:]
 at
 org.ovirt.engine.core.bll.OvfDataUpdater.updateOvfForVmsOfStoragePool(OvfDataUpdater.java:135)
 [bll.jar:]
 at
 org.ovirt.engine.core.bll.OvfDataUpdater.ovfUpdate_timer(OvfDataUpdater.java:93)
 [bll.jar:]
 at sun.reflect.GeneratedMethodAccessor250.invoke(Unknown Source) [:1.7.0_65]
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [rt.jar:1.7.0_65]
 at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_65]
 at org.ovirt.engine.core.utils.timer.JobWrapper.execute(JobWrapper.java:60)
 [scheduler.jar:]
 at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz.jar:]
 at
 org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
 [quartz.jar:]
 
 Can anyone help?

Can you please share the result of the following on both hosts ?

 echo $LANG

thanks 


 Thanks
 
 like...@cs2c.com.cn
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Error while executing action: Cannot add Host. Host with the same UUID already exists.

2015-06-21 Thread Eli Mesika


- Original Message -
 From: Юрий Полторацкий y.poltorats...@gmail.com
 To: Alon Bar-Lev alo...@redhat.com
 Cc: users@ovirt.org
 Sent: Thursday, June 18, 2015 4:05:18 PM
 Subject: Re: [ovirt-users] Error while executing action: Cannot add Host. 
 Host with the same UUID already exists.
 
 Hi,
 
 I have resolved this in such way.
 
 On the engine host connect to db:
 su postgres
 psql -s engine
 
 Then delete host from db manualy:
 select vds_id from vds_static where host_name = 'HOST_NAME';
 delete from vds_statistics where vds_id = 'id';
 delete from vds_dynamic where vds_id = 'id';
 delete from vds_static where vds_id = 'id';

this is only part of the work, now you have junk in some of your table 

The right way is to call 

SELECT DeleteVds(uuid);

the body of this SP is :

---Start---
UPDATE vm_static
  SET dedicated_vm_for_vds = null
  WHERE dedicated_vm_for_vds = v_vds_id;
  DELETE FROM tags_vds_map
  WHERE vds_id = v_vds_id;
   -- Delete all Vds Alerts from the database
  PERFORM DeleteAuditLogAlertsByVdsID(v_vds_id);
  DELETE FROM vds_statistics WHERE vds_id = v_vds_id;
  DELETE FROM vds_dynamic WHERE vds_id = v_vds_id;
  DELETE FROM vds_static WHERE vds_id = v_vds_id;
  DELETE FROM permissions where object_id = v_vds_id;
--- end ---

Please verify that you complete the missing operations manually and consult 
with us in future before doing anything directly on the database 

Thanks


 
 2015-06-18 16:04 GMT+03:00 Alon Bar-Lev  alo...@redhat.com  :
 
 
 
 A log will be nice.
 However, can you please compare /etc/vdsm/ vdsm.id in both hosts?
 If not available at new host it might be a bios issue, try to uuidgen 
 /etc/vdsm/ vdsm.id and add host.
 
 - Original Message -
  From: m...@ohnewald.net
  To: users@ovirt.org
  Sent: Thursday, June 18, 2015 3:54:25 PM
  Subject: [ovirt-users] Error while executing action: Cannot add Host. Host
  with the same UUID already exists.
  
  Hello List,
  
  i am using oVirt Engine Version: 3.5.2.1-1.el6.
  
  I would like to remove a node from a GlusterFS Cluster and use it for
  local storage.
  
  So i put my node into maintance. Reinstalled it freshly with CentOS7.
  
  Now i would like to add it to a New Cluster with local storage, but i get:
  
  Error while executing action: Cannot add Host. Host with the same UUID
  already exists.
  
  
  
  How can i resolve this problem?
  
  
  I can NOT remove my old host from the Gluster: Cannot remove Host.
  Server having Gluster volume.
  
  
  
  Thanks,
  Mario
  
  ___
  Users mailing list
  Users@ovirt.org
  http://lists.ovirt.org/mailman/listinfo/users
  
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] problems with power management using idrac7 on r620

2015-06-17 Thread Eli Mesika


- Original Message -
 From: Jason Keltz jason.ke...@gmail.com
 To: Marek marx Grac mg...@redhat.com
 Cc: Eli Mesika emes...@redhat.com, users users@ovirt.org
 Sent: Wednesday, June 17, 2015 12:02:48 PM
 Subject: Re: problems with power management using idrac7 on r620
 
 Hi Marek.
 
 Actually its the idrac that I believe has the memory leak.  Dell wants to
 know how often ovirt is querying the idrac for status and whether the delay
 is configurable.

Well oVirt does not query the status automatically by default 
There is a feature that enables that 
http://www.ovirt.org/Features/PMHealthCheck
Basically this feature depends on 2 configuration values :

PMHealthCheckEnabled that shoul be true if the feature is enabled 
PMHealthCheckIntervalInSec which is defaulted to 3600 Sec , so it is checked in 
that case once in an hour 

So, first please check if this is enabled in your environment 

engine-config -g PMHealthCheckEnabled

engine-config -g PMHealthCheckIntervalInSec

Other scenario when status is used is when host becomes non-responsive 

In case that host become non responsive : 

After a grace period that depends on the host load and if it is SPM or not a 
soft-fence attempt (vdsmd service restart) is issued 
If the soft-fence attempt fails we will do a real fencing (if power management 
is configured correctly on the host and a proxy host is found)
We are sending a STOP command 
We are sending by default 18 status command , one each 10 sec until we get 
'off' status from the agent 
We are sending a START command 
We are sending by default 18 status command , one each 10 sec until we get 'on' 
status from the agent

Those depends on the following configuration variables :

FenceStopStatusRetries - default 18
FenceStopStatusDelayBetweenRetriesInSec - default 10 
FenceStartStatusRetries - default 18
FenceStartStatusDelayBetweenRetriesInSec - default 10 

This can be changed using the engine-config tool (requires restart to take 
affect)



 
 Jason.
 On Jun 17, 2015 2:42 AM, Marek marx Grac mg...@redhat.com wrote:
 
 
 
  On 06/16/2015 09:37 AM, Eli Mesika wrote:
 
  CCing Marek Grac
 
  - Original Message -
 
  From: Jason Keltz jason.ke...@gmail.com
  To: users users@ovirt.org
  Cc: Eli Mesika emes...@redhat.com
  Sent: Monday, June 15, 2015 11:08:35 PM
  Subject: problems with power management using idrac7 on r620
 
  Hi.
 
  I've been having problem with power management using iDRAC 7 EXPRESS on
  a Dell R620.  This uses a shared LOM as opposed to Enterprise that has a
  dedicated one.   Every now and then, idrac simply stops responding to
  ping, so it can't respond to status commands from the proxy.  If I send
  a reboot with ipmitool mc reset cold command, the idrac reboots and
  comes back, but after the problem has occurred, even after a reboot, it
  responds to ping, but drops 80+% of packets.  The only way I can solve
  the problem is to physically restart the server.This isn't just
  happening on  one R620 - it's happening on all of my ovirt hosts.  I
  highly suspect it has to do with a memory leak, and being monitored by
  engine causes the problem.I had applied a recent firmware upgrade
  that was supposed to solve this kind of problem, but it doesn't.  In
  other to provide Dell with more details, can someone tell me how often
  each host is being queried for status?  I can't seem to find that info.
  The idrac on my file server doesn't seem to exhibit the same problem,
  and I suspect that is because it isn't being queried.
 
  Hi,
 
  fence agent for IPMI is based on ipmitool. So if ping/ipmitool is not
  working there is not much to do about it. I don't know enough about oVirt
  engine but there is no real place where fence agent can memory leak because
  it does not run as daemon.
 
  m,
 
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] problems with power management using idrac7 on r620

2015-06-16 Thread Eli Mesika
CCing Marek Grac 

- Original Message -
 From: Jason Keltz jason.ke...@gmail.com
 To: users users@ovirt.org
 Cc: Eli Mesika emes...@redhat.com
 Sent: Monday, June 15, 2015 11:08:35 PM
 Subject: problems with power management using idrac7 on r620
 
 Hi.
 
 I've been having problem with power management using iDRAC 7 EXPRESS on
 a Dell R620.  This uses a shared LOM as opposed to Enterprise that has a
 dedicated one.   Every now and then, idrac simply stops responding to
 ping, so it can't respond to status commands from the proxy.  If I send
 a reboot with ipmitool mc reset cold command, the idrac reboots and
 comes back, but after the problem has occurred, even after a reboot, it
 responds to ping, but drops 80+% of packets.  The only way I can solve
 the problem is to physically restart the server.This isn't just
 happening on  one R620 - it's happening on all of my ovirt hosts.  I
 highly suspect it has to do with a memory leak, and being monitored by
 engine causes the problem.I had applied a recent firmware upgrade
 that was supposed to solve this kind of problem, but it doesn't.  In
 other to provide Dell with more details, can someone tell me how often
 each host is being queried for status?  I can't seem to find that info.
 The idrac on my file server doesn't seem to exhibit the same problem,
 and I suspect that is because it isn't being queried.
 
 Thanks,
 
 Jason.
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Comma Seperated Value doesn't accept by custom properties

2015-06-07 Thread Eli Mesika


- Original Message -
 From: Dan Kenigsberg dan...@redhat.com
 To: Punit Dambiwal hypu...@gmail.com
 Cc: users@ovirt.org
 Sent: Friday, June 5, 2015 5:16:43 PM
 Subject: Re: [ovirt-users] Comma Seperated Value doesn't accept by custom 
 properties
 
 On Fri, Jun 05, 2015 at 03:28:11PM +0800, Punit Dambiwal wrote:
  Hi,
  
  I have installed noipspoof VDSM hooks...in the vdsm hooks it specify that
  you can use multiple ip address by comma separate listbut it's not
  working...
  
  single ip can work without any issue...but can not add multiple ip address
  in this filed...
 
 what is your
 
  engine-config -g UserDefinedVMProperties
 
 the regexp there should accept comas, too.

As far as I see the separator is ; and not , 

packaging/etc/engine-config/engine-config.properties:UserDefinedVMProperties.description=User
 defined VM properties
packaging/etc/engine-config/engine-config.properties:UserDefinedVMProperties.type=UserDefinedVMProperties
packaging/etc/engine-config/engine-config.properties:UserDefinedVMProperties.mergable=true
packaging/etc/engine-config/engine-config.properties:UserDefinedVMProperties.delimiter=;



 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Configuring ilo2 PM; passing ssh options

2015-05-25 Thread Eli Mesika


- Original Message -
 From: Martin Perina mper...@redhat.com
 To: Daniel Helgenberger daniel.helgenber...@m-box.de
 Cc: users@ovirt.org, Eli Mesika emes...@redhat.com
 Sent: Monday, May 25, 2015 11:23:29 AM
 Subject: Re: [ovirt-users] Configuring ilo2 PM; passing ssh options
 
 
 
 - Original Message -
  From: Daniel Helgenberger daniel.helgenber...@m-box.de
  To: Martin Perina mper...@redhat.com
  Cc: users@ovirt.org, Eli Mesika emes...@redhat.com
  Sent: Sunday, May 24, 2015 10:02:34 AM
  Subject: Re: [ovirt-users] Configuring ilo2 PM; passing ssh options
  
  
  
  On 23.05.2015 15:04, Martin Perina wrote:
  
  
   - Original Message -
   From: Daniel Helgenberger daniel.helgenber...@m-box.de
   To: Martin Perina mper...@redhat.com
   Cc: users@ovirt.org, Eli Mesika emes...@redhat.com
   Sent: Thursday, May 21, 2015 9:31:50 PM
   Subject: Re: [ovirt-users] Configuring ilo2 PM; passing ssh options
  
  
  
   On 21.05.2015 21:07, Martin Perina wrote:
   Hi Daniel,
  
   I'm cc'ing Eli as we are currently facing issue with fence agents
   regression for passing boolean flags to fence agents.
   Thanks for getting back to me so quickly.
  
   I looked at man page of fence_ilo2 again and I haven't found
   --tls1.0 option at all.
   Strange? FYI I am running CentOS7.1 hosts; installed fence:
   fence-agents-ilo2-4.0.11-11.el7_1.x86_64
  
   Here, clearly I have this option. The fence agent itself seems to use
   gnutls successfully:
  
   # fence_ilo2 -a 10.11.0.212 --username=ovirt -p ** -v -o status
   --ssl-insecure --tls1.0
  
   Running command: /usr/bin/gnutls-cli --priority
   NORMAL:-VERS-TLS1.2:-VERS-TLS1.1:+VERS-TLS1.0:%LATEST_RECORD_VERSION
   --insecure --crlf -p 443 10.11.0.212
  
  
   Ahh, I looked at older version on F20. But I can't find --tls1.0 option
   even on man page for fence-agents-ilo2-4.0.11-11.el7_1.x86_64 :-(
  
   So if you really see this option, please take a look at the end of man
   page, where you can find STDIN format options names and add it along
   with ssl_insecure to options in Power Management tab of the hosts
   (instead
   of tls1_0 use what you find in your man page):
  Many thanks! Using the STDIN options solved this issue. I finally get:
  Test succeeded: on
  
  I am using these options in the options field for the ilo2 fencing module:
  
  ssl_insecure=1,tls1.0=1
  
  Also working:
  ssl_insecure=1,notls=1
  
  
 ssl_insecure=1,tls1_0=1
  True. What still puzzles me is the tls1.0 option. In the my man pages
  the STDIN option ins called 'tls1.0'. Also, can you check wherever you
  have a 'notls' option to force SSL3.0? This also works for me.
 
 Ahh, sorry for the confusion. By mistake I looked at older fence-agents
 RPM :-(
 
 I looked again and now I also have tls1.0. The notls options is contained
 also in the older version (like the one I have in my F20).
 
  
  I think all the info you gave here, esp. using the stdin binary options
  in a way 'option=0|1' is quite essential to get fenceing working. I had
  a quick look over some man pages and I think all the standard fence
  agents are used in the same manner.
 
 Yes, this is the regression I wrote you about. Latest fence-agents dropped
 the support for passing boolean options without value (just sending notls
 was ok in prior versions), but the last version requires to send notls=1
 or notls=true, otherwise the option is not used. We are currenlty preparing
 patches to handle it.

This is planned to be fixed for 3.6 by an upgrade script (not including 
encrypted options)
BTW, according to Marek G who is the fence-agents maintainer sending boolean 
flags by their own 
was enabled for all agents but was actually working only for the ipmilan agent 
... 

 
  Also, a hint might be in order that old ilo boards can't cope with TLS
  and need it disabled. I think here [1] [2]?
  
  [1] http://www.ovirt.org/Automatic_Fencing
  [2]
  http://www.ovirt.org/OVirt_Administration_Guide#Host_Power_Management_Settings_Explained
 
 Hmm, thanks for the input, I will talk with Eli and Oved how to make
 the documentation more understandable.

I had added a comment to the troubleshooting section of [1] regarding that ...

 
 Thanks
 
 Martin Perina
 
  
  Thanks!
  
   Thanks
  
   Martin Perina
  
   I put the whole command output below [1]
  
  
  To specify --ssl-insecure please add following
   into options in Power Management tab of the host:
  
   ssl_insecure=1
   Thanks for pointing out how to actually use these options.
  
  
   Martin Perina
  
   - Original Message -
   From: Daniel Helgenberger daniel.helgenber...@m-box.de
   To: Martin Perina mper...@redhat.com
   Cc: users@ovirt.org
   Sent: Thursday, May 21, 2015 8:11:40 PM
   Subject: Re: [ovirt-users] Configuring ilo2 PM; passing ssh options
  
  
  
   On 12.05.2015 09:16, Martin Perina wrote:
   Hi Daniel,
   Hello Martin,
  
   sorry for answering that late. And thanks for pointing me to the man
   page

Re: [ovirt-users] Hung task in the Tasks tab

2015-05-25 Thread Eli Mesika


- Original Message -
 From: Christopher Cross crcr...@cprmail.org
 To: Users@ovirt.org
 Sent: Friday, May 22, 2015 11:01:47 PM
 Subject: [ovirt-users] Hung task in the Tasks tab
 
 Hello,
 
 I have been working on a new cluster on 3.5 with CentOS 7 hosts. My current
 production stuff is still on 3.4 So I had to play around a bit to figure out
 the VDSM networking stuff. I got it all sorted but at one point I had a host
 that was not configured correctly and a task, Configuring networks on host
 vm2, has been sitting in the task tab since then. I was sucsessfull in
 getting the host configured with all the required bonding, VLANs, and
 networks I need and the host is functioning fine.
 
 My problem is that this task will not go away from the manager web interface.
 I do not think it is actually doing anything but it would be nice to get it
 out of there. I tried making other network changes and re-saving the
 configuration and also rebooting the host and nothing takes it away. Has
 anyone else seen this?

please run the following from your SPM host 

vdsClient -s 1 getAllTasksStatuses

In case that there is a stuck task, it can be stopped using stopTask (see 
vdsClient --help)

In case that all is OK on the VDSM side, then it seems like a bug in the engine 
side and we will need a BZ for that with engine  vdsm(SPM) logs 

We can easily remove that using SQL but lets first see if we can indentify the 
problem origin 


 
 Thanks,
 
 Christopher Cross
 Linux Systems Network Administrator
 Colorado Public Radio
 7409 South Alton Court | Centennial, CO 80112
 303-871-9191, ext. 258
 www.cpr.org
 
 ...
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] oVirt user permissions for fence_rhevm

2015-05-19 Thread Eli Mesika
CC Marek Grac 

- Original Message -
 From: Rik Theys rik.th...@esat.kuleuven.be
 To: users@ovirt.org
 Sent: Monday, May 18, 2015 4:56:23 PM
 Subject: [ovirt-users] oVirt user permissions for fence_rhevm
 
 Hi,
 
 I've created a user in AD that should only be able to power off/on a
 specific VM in oVirt.
 
 I've granted this user UserRole permission on this specific VM.
 
 If I log into the user portal with these credentials I can see the VM
 and power it off/on.
 
 When I use the fence_rhevm agent it fails to find the correct plug. I
 fixed this by adding the Filter: true header to the fence_rhevm
 script. When running manually, fence_rhevm can show me the status of the
 plug and can power it on/off.
 
 When I try to integrate this into a pacemaker cluster (on Debian 7)
 using the fence_rhevm resource agent it reboots the VM on every monitor
 action.
 
 Has anyone succeeded in using fence_rhevm with oVirt on pacemaker 1.1?
 Are there any additional oVirt permissions the user needs to make this
 work? I don't want to make this fence user an admin for my entire ovirt
 datacenter.
 
 The stonith primitive is configured:
 
 primitive p_fence_vm1 stonith:fence_rhevm \
  params port=vm1 login=fence-...@mydomain.ad
 ipaddr=ovirt-engine.mydomain ipport=443 ssl=1 passwd=secret
 verbose=1 pcmk_host_list=vm1 pcmk_host_check=static-list \
  op monitor interval=15m
 
 
 Regards,
 
 Rik
 
 --
 Rik Theys
 System Engineer
 KU Leuven - Dept. Elektrotechniek (ESAT)
 Kasteelpark Arenberg 10 bus 2440  - B-3001 Leuven-Heverlee
 +32(0)16/32.11.07
 
 Any errors in spelling, tact or fact are transmission errors
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Unable to remove host (SQL error)

2015-04-27 Thread Eli Mesika


- Original Message -
 From: Jannick DelOro jdel...@web.de
 To: Eli Mesika emes...@redhat.com
 Cc: users@ovirt.org
 Sent: Monday, April 27, 2015 11:14:01 AM
 Subject: Re: [ovirt-users] Unable to remove host (SQL error)
 
 Hello Eli,
 
I'm unable to remove a re-installed host from oVirt 3.5 cluster. The
engine.log states:

2015-04-26 21:19:27,795 ERROR
[org.ovirt.engine.core.bll.RemoveVdsCommand]
(org.ovirt.thread.pool-8-thread-43) [34db91ae] Command
org.ovirt.engine.core.bll.RemoveVdsCommand throw exception:
org.springframework.dao.DataIntegrityViolationException:
CallableStatementCallback; SQL [{call deletevdsstatic(?)}]; ERROR:
update
or
delete on table vds_static violates foreign key constraint
vds_static_vm_dynamic_m on table vm_dynamic
  Detail: Key (vds_id)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still
  referenced from table vm_dynamic.
  Where: SQL statement DELETE FROM vds_static WHERE vds_id =  $1 
PL/pgSQL function deletevdsstatic line 11 at SQL statement; nested
exception is org.postgresql.util.PSQLException: ERROR: update or delete
on
table vds_static violates foreign key constraint
vds_static_vm_dynamic_m
on table vm_dynamic
  Detail: Key (vds_id)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still
  referenced from table vm_dynamic.
  Where: SQL statement DELETE FROM vds_static WHERE vds_id =  $1 
PL/pgSQL function deletevdsstatic line 11 at SQL statement
at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
[spring-jdbc.jar:3.1.1.RELEASE]
at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[spring-jdbc.jar:3.1.1.RELEASE]
[...]

The host re-installed (Kickstart) before.
   
   Hi
   
   this should not happen, please open a bug for that and attach the full
   engine
   log
   

What can I do to remove the host (via Webinterface) or database
interaction?
   
   from psql prompt
   
select DeleteVds('629ca86d-f6a6-4702-bf0f-182af3df3b8c');
  
  
  Looking again in the messages
  Seems you still have running VMs on this hots , can you put it first to
  maintenance and try the removale again before touching the DB ???
 
 No, the host is in maintenance mode and no VM is running on this host.
 
 But here is what has happened before:
 
 - VM on host got unresponsive. Was unable to migrate or power off.
 - Host was restarted and clicked Confirm Host has been rebooted.
 - Faulty VM was started on different host.
 - Host was put to maintenance mode.
 - Host was re-installed via Kickstart.
 - Trying to remove host from Cluster (due to change in address). Doesn't
 work.
 - Host was re-installed via oVirt web interface.
 - Trying to remove host from Cluster. Doesn't work.


Well, please open a BZ first with the full scenario you described above plus 
engine log 
To resolve your current problem, please do from database prompt

 update vm_dynamic set status=0, migrating_to_vds = null where 
 migrating_to_vds = '629ca86d-f6a6-4702-bf0f-182af3df3b8c';


After that, please try to remove again your host from the UI

Eli


 
 Kind regards
 
 Jannick
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Unable to remove host (SQL error)

2015-04-27 Thread Eli Mesika


- Original Message -
 From: Eli Mesika emes...@redhat.com
 To: jdel...@web.de
 Cc: users@ovirt.org
 Sent: Monday, April 27, 2015 10:26:51 AM
 Subject: Re: [ovirt-users] Unable to remove host (SQL error)
 
 
 
 - Original Message -
  From: jdel...@web.de
  To: users@ovirt.org
  Sent: Sunday, April 26, 2015 10:36:59 PM
  Subject: [ovirt-users] Unable to remove host (SQL error)
  
  Hello,
  
  I'm unable to remove a re-installed host from oVirt 3.5 cluster. The
  engine.log states:
  
  2015-04-26 21:19:27,795 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand]
  (org.ovirt.thread.pool-8-thread-43) [34db91ae] Command
  org.ovirt.engine.core.bll.RemoveVdsCommand throw exception:
  org.springframework.dao.DataIntegrityViolationException:
  CallableStatementCallback; SQL [{call deletevdsstatic(?)}]; ERROR: update
  or
  delete on table vds_static violates foreign key constraint
  vds_static_vm_dynamic_m on table vm_dynamic
Detail: Key (vds_id)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still
referenced from table vm_dynamic.
Where: SQL statement DELETE FROM vds_static WHERE vds_id =  $1 
  PL/pgSQL function deletevdsstatic line 11 at SQL statement; nested
  exception is org.postgresql.util.PSQLException: ERROR: update or delete on
  table vds_static violates foreign key constraint
  vds_static_vm_dynamic_m
  on table vm_dynamic
Detail: Key (vds_id)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still
referenced from table vm_dynamic.
Where: SQL statement DELETE FROM vds_static WHERE vds_id =  $1 
  PL/pgSQL function deletevdsstatic line 11 at SQL statement
  at
  
  org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at
  
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  [spring-jdbc.jar:3.1.1.RELEASE]
  [...]
  
  The host re-installed (Kickstart) before.
 
 Hi
 
 this should not happen, please open a bug for that and attach the full engine
 log
 
  
  What can I do to remove the host (via Webinterface) or database
  interaction?
 
 from psql prompt
 
  select DeleteVds('629ca86d-f6a6-4702-bf0f-182af3df3b8c');


Looking again in the messages 
Seems you still have running VMs on this hots , can you put it first to 
maintenance and try the removale again before touching the DB ???


 
 
  
  Kind regards
  
  Jannick
  ___
  Users mailing list
  Users@ovirt.org
  http://lists.ovirt.org/mailman/listinfo/users
  
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Unable to remove host (SQL error)

2015-04-27 Thread Eli Mesika


- Original Message -
 From: jdel...@web.de
 To: users@ovirt.org
 Sent: Sunday, April 26, 2015 10:36:59 PM
 Subject: [ovirt-users] Unable to remove host (SQL error)
 
 Hello,
 
 I'm unable to remove a re-installed host from oVirt 3.5 cluster. The
 engine.log states:
 
 2015-04-26 21:19:27,795 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand]
 (org.ovirt.thread.pool-8-thread-43) [34db91ae] Command
 org.ovirt.engine.core.bll.RemoveVdsCommand throw exception:
 org.springframework.dao.DataIntegrityViolationException:
 CallableStatementCallback; SQL [{call deletevdsstatic(?)}]; ERROR: update or
 delete on table vds_static violates foreign key constraint
 vds_static_vm_dynamic_m on table vm_dynamic
   Detail: Key (vds_id)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still
   referenced from table vm_dynamic.
   Where: SQL statement DELETE FROM vds_static WHERE vds_id =  $1 
 PL/pgSQL function deletevdsstatic line 11 at SQL statement; nested
 exception is org.postgresql.util.PSQLException: ERROR: update or delete on
 table vds_static violates foreign key constraint vds_static_vm_dynamic_m
 on table vm_dynamic
   Detail: Key (vds_id)=(629ca86d-f6a6-4702-bf0f-182af3df3b8c) is still
   referenced from table vm_dynamic.
   Where: SQL statement DELETE FROM vds_static WHERE vds_id =  $1 
 PL/pgSQL function deletevdsstatic line 11 at SQL statement
 at
 
 org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
 [spring-jdbc.jar:3.1.1.RELEASE]
 at
 
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
 [spring-jdbc.jar:3.1.1.RELEASE]
 [...]
 
 The host re-installed (Kickstart) before.

Hi

this should not happen, please open a bug for that and attach the full engine 
log 

 
 What can I do to remove the host (via Webinterface) or database interaction?

from psql prompt 

 select DeleteVds('629ca86d-f6a6-4702-bf0f-182af3df3b8c');


 
 Kind regards
 
 Jannick
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Options not being passed fence_ipmilan, Ovirt3.5 on Centos 7.1 hosts

2015-04-22 Thread Eli Mesika


- Original Message -
 From: Mike Lindsay mike.lind...@cbc.ca
 To: users@ovirt.org
 Sent: Tuesday, April 21, 2015 8:16:18 PM
 Subject: [ovirt-users] Options not being passed fence_ipmilan,
 Ovirt3.5 on Centos 7.1 hosts
 
 Hi All,
 
 I have a bit of an issue with a new install of Ovirt 3.5 (our 3.4 cluster is
 working fine) in a 4 node cluster.
 
 When I test fencing (or cause a kernal panic triggering a fence) the fencing
 fails. On investigation it appears that the fencing options are not being
 passed to the fencing script (fence_ipmilan in this case):
 
 Fence options under GUI(as entered in the gui): lanplus, ipport=623,
 power_wait=4, privlvl=operator
 
 from vdsm.log on the fence proxy node:
 
 Thread-818296::DEBUG::2015-04-21 12:39:39,136::API::1209::vds::(fenceNode)
 fenceNode(addr=x.x.x.x,port=,agent=ipmilan,user=stonith,passwd=,action=status,secure=False,options=
 power_wait=4
 Thread-818296::DEBUG::2015-04-21 12:39:39,137::utils::739::root::(execCmd)
 /usr/sbin/fence_ipmilan (cwd None)
 Thread-818296::DEBUG::2015-04-21 12:39:39,295::utils::759::root::(execCmd)
 FAILED: err = 'Failed: Unable to obtain correct plug status or plug is not
 available\n\n\n'; rc = 1
 Thread-818296::DEBUG::2015-04-21 12:39:39,296::API::1164::vds::(fence) rc 1
 inp agent=fence_ipmilan
 Thread-818296::DEBUG::2015-04-21 12:39:39,296::API::1235::vds::(fenceNode) rc
 1 in agent=fence_ipmilan
 Thread-818296::DEBUG::2015-04-21
 12:39:39,297::stompReactor::163::yajsonrpc.StompServer::(send) Sending
 response
 
 
 from engine.log on the engine:
 2015-04-21 12:39:38,843 INFO
 [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
 (ajp--127.0.0.1-8702-4) Correlation ID: null, Call Stack: null, Custom Event
 ID: -1, Message: Host mpc-ovirt-node03 from cluster Default was chosen as a
 proxy to execute Status command on Host mpc-ovirt-node04.
 2015-04-21 12:39:38,845 INFO [org.ovirt.engine.core.bll.FenceExecutor]
 (ajp--127.0.0.1-8702-4) Using Host mpc-ovirt-node03 from cluster Default as
 proxy to execute Status command on Host
 2015-04-21 12:39:38,885 INFO [org.ovirt.engine.core.bll.FenceExecutor]
 (ajp--127.0.0.1-8702-4) Executing Status Power Management command, Proxy
 Host:mpc-ovirt-node03, Agent:ipmilan, Target Host:, Management IP:x.x.x.x,
 User:stonith, Options: power_wait=4, ipport=623, privlvl=operator,lanplus,
 Fencing policy:null
 2015-04-21 12:39:38,921 INFO
 [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand]
 (ajp--127.0.0.1-8702-4) START, FenceVdsVDSCommand(HostName =
 mpc-ovirt-node03, HostId = 5613a489-589d-4e89-ab01-3642795eedb8, targetVdsId
 = dbfa4e85-3e97-4324-b222-bf40a491db08, action = Status, ip = x.x.x.x, port
 = , type = ipmilan, user = stonith, password = **, options = '
 power_wait=4, ipport=623, privlvl=operator,lanplus', policy = 'null'), log
 id: 774f328
 2015-04-21 12:39:39,338 WARN
 [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
 (ajp--127.0.0.1-8702-4) Correlation ID: null, Call Stack: null, Custom Event
 ID: -1, Message: Power Management test failed for Host mpc-ovirt-node04.Done
 2015-04-21 12:39:39,339 INFO
 [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand]
 (ajp--127.0.0.1-8702-4) FINISH, FenceVdsVDSCommand, return: Test Succeeded,
 unknown, log id: 774f328
 2015-04-21 12:39:39,340 WARN [org.ovirt.engine.core.bll.FenceExecutor]
 (ajp--127.0.0.1-8702-4) Fencing operation failed with proxy host
 5613a489-589d-4e89-ab01-3642795eedb8, trying another proxy...
 2015-04-21 12:39:39,594 INFO
 [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
 (ajp--127.0.0.1-8702-4) Correlation ID: null, Call Stack: null, Custom Event
 ID: -1, Message: Host mpc-ovirt-node01 from cluster Default was chosen as a
 proxy to execute Status command on Host mpc-ovirt-node04.
 2015-04-21 12:39:39,595 INFO [org.ovirt.engine.core.bll.FenceExecutor]
 (ajp--127.0.0.1-8702-4) Using Host mpc-ovirt-node01 from cluster Default as
 proxy to execute Status command on Host
 2015-04-21 12:39:39,598 INFO [org.ovirt.engine.core.bll.FenceExecutor]
 (ajp--127.0.0.1-8702-4) Executing Status Power Management command, Proxy
 Host:mpc-ovirt-node01, Agent:ipmilan, Target Host:, Management IP:x.x.x.x,
 User:stonith, Options: power_wait=4, ipport=623, privlvl=operator,lanplus,
 Fencing policy:null
 2015-04-21 12:39:39,634 INFO
 [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand]
 (ajp--127.0.0.1-8702-4) START, FenceVdsVDSCommand(HostName =
 mpc-ovirt-node01, HostId = c3e8be6e-ac54-4861-b774-17ba5cc66dc6, targetVdsId
 = dbfa4e85-3e97-4324-b222-bf40a491db08, action = Status, ip = x.x.x.x, port
 = , type = ipmilan, user = stonith, password = **, options = '
 power_wait=4, ipport=623, privlvl=operator,lanplus', policy = 'null'), log
 id: 6369eb1
 2015-04-21 12:39:40,056 WARN
 [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
 (ajp--127.0.0.1-8702-4) Correlation ID: null, Call Stack: null, Custom Event
 ID: 

Re: [ovirt-users] ap7920 fencing device does not work

2015-04-13 Thread Eli Mesika


- Original Message -
 From: Mario Giammarco mgiamma...@gmail.com
 To: Eli Mesika emes...@redhat.com
 Cc: users@ovirt.org
 Sent: Monday, April 13, 2015 10:23:29 PM
 Subject: Re: [ovirt-users] ap7920 fencing device does not work
 
 So,
 I just added the first host and I cannot check if fencing works until I add
 the second host?

Yes, this is how it works now 
We have a RFE for letting oVirt engine itself serve as a proxy and then you are 
supposed to do that with one host as well ...

 Nice to know
 
 Thanks again,
 Mario
 
 2015-04-13 21:18 GMT+02:00 Eli Mesika emes...@redhat.com:
 
 
 
  - Original Message -
   From: Mario Giammarco mgiamma...@gmail.com
   To: users@ovirt.org
   Sent: Monday, April 13, 2015 10:01:07 PM
   Subject: [ovirt-users] ap7920 fencing device does not work
  
   Hello,
   I am trying to use ap7920 as fencing device for ovirt 3.5.1
  
   I have configured all parameters correctly but I get only:
  
   2015-04-13 20:58:21,704 ERROR [org.ovirt.engine.core.bll.FenceExecutor]
   (ajp--127.0.0.1-8702-10) Failed to run Power Management command on Host
  , no
   running proxy Host was found.
  
   In my ovirt node I do fence_apc -a 10.1.0.208 -l apc -p apc -o status -n
  7 -x
  
   and I get a correct reply Status: ON
  
   So command line is working.
  
   What can I do?
 
  Hi
 
  oVirt power management handling requires another host in the fenced host
  Cluster/DC except the fenced host that is served as a proxy for the
  operation
  It means that when a fencing operation is required, oVirt will search for
  a proxy host and the relevant scripts in the proxy host will invoke the
  fencing operation on the target.
  Please make sure that you have another Host in the Cluster/DC which is in
  UP status or any other status that does not mark connectivity issues
 
  
   Please help me!
  
   Thanks,
   Mario
  
   ___
   Users mailing list
   Users@ovirt.org
   http://lists.ovirt.org/mailman/listinfo/users
  
 
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] postgresql error on glance image repo

2015-04-05 Thread Eli Mesika


- Original Message -
 From: Jorick Astrego j.astr...@netbulae.eu
 To: Simone Tiraboschi stira...@redhat.com
 Cc: users@ovirt.org
 Sent: Friday, April 3, 2015 12:13:13 PM
 Subject: Re: [ovirt-users] postgresql error on glance image repo
 
 
 
 On 04/03/2015 10:07 AM, Simone Tiraboschi wrote:
  
  - Original Message -
  From: Jorick Astrego j.astrego@ netbulae.eu 
  To: users@ ovirt.org
  Sent: Friday, April 3, 2015 10:00:58 AM
  Subject: [ovirt-users] postgresql error on glance image repo
  
  Hi,
  
  Running a fresh ovirt 3.5.2rc3 install. When I select the default
  ovirt-image-repository on the storage tab, the images list keeps loading
  and
  I see the following errors in the log:
  Hi,
  I tried it and I'm not able to reproduce, at least on fedora 20.
  I'm able to see image list and I'm able to import cirros template.
  Could you please attach setup logs?
  
  thanks,
  Simone
 
 Hmm strange after clicking away and selecting again, I get the images
 without the sql error.
 
 I attached the logs.

Query seems OK , please try to have a clear reproducible scenario for this one

thanks
Eli 

 
 
  2015-04-03 09:53:27,150 ERROR [org.ovirt.engine.core.bll.SearchQuery]
  (ajp--127.0.0.1-8702-10) Query SearchQuery failed. Exception message is
  StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct
  providers.* FROM providers WHERE providers.name LIKE
  'ovirt-image-repository' ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT
  100]; nested exception is org.postgresql.util.PSQLException: The column
  name
  disk_storage_type was not found in this ResultSet. :
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
  SQL
  grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers WHERE
  providers.name LIKE 'ovirt-image-repository' ) ORDER BY name ASC) as T1
  OFFSET (1 -1) LIMIT 100]; nested exception is
  org.postgresql.util.PSQLException: The column name disk_storage_type was
  not
  found in this ResultSet.: org.springframework.jdbc.BadSqlGrammarException:
  StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct
  providers.* FROM providers WHERE providers.name LIKE
  'ovirt-image-repository' ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT
  100]; nested exception is org.postgresql.util.PSQLException: The column
  name
  disk_storage_type was not found in this ResultSet.
  at
  org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at
  org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
  [spring-jdbc.jar:3.1.1.RELEASE]
  at
  org.ovirt.engine.core.dao.DiskDaoDbFacadeImpl.getAllWithQuery(DiskDaoDbFacadeImpl.java:103)
  [dal.jar:]
  at
  org.ovirt.engine.core.bll.SearchQuery.genericSearch(SearchQuery.java:269)
  [bll.jar:]
  at
  org.ovirt.engine.core.bll.SearchQuery.genericSearch(SearchQuery.java:257)
  [bll.jar:]
  at org.ovirt.engine.core.bll.SearchQuery.searchDisk(SearchQuery.java:299)
  [bll.jar:]
  at
  org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:117)
  [bll.jar:]
  at
  org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73)
  [bll.jar:]
  at
  org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31)
  [dal.jar:]
  at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:497)
  [bll.jar:]
  at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:471) [bll.jar:]
 
  at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
  [:1.7.0_75]
  at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  [rt.jar:1.7.0_75]
  at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
  at
  org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
  at
  org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
  at
  org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
  

Re: [ovirt-users] very long time to detach an export domain

2015-03-18 Thread Eli Mesika
Hi

Please attach relevant VDSM + engine logs

thanks 


- Original Message -
 From: Nathanaël Blanchet blanc...@abes.fr
 To: users@ovirt.org
 Sent: Wednesday, March 18, 2015 12:43:17 PM
 Subject: [ovirt-users] very long time to detach an export domain
 
 Hi all,
 
 I have no latence for attaching an existing v1 export domain to any
 datacenter. However, detaching the same export domain takes a while
 (more than 30 min) saying preparing for mainteance. Is it a regular
 behaviour? If yes, what is it done at this step for being so long?
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Power Management config on Ovirt

2015-03-18 Thread Eli Mesika
  
  
  
  CRACKNELL  DUBAI   |  P.O. Box 66231  |   United Arab Emirates
  | T
  +971 4
  3445417  |  F +971 4 3493675 |  M +971 50 7386484 ABU DHABI |
  DUBAI
  | LONDON | MUSCAT | DOHA | JEDDAH EMAIL ren...@cracknell.com |
  | WEB
  www.cracknell.com
  
  This email, its content and any files transmitted with it are
  intended solely for the addressee(s) and may be legally
  privileged and/or confidential. If you are not the intended
  recipient please let us know by email reply and delete it from
  the system. Please note that any views or opinions presented
  in this email do not necessarily represent those of the company.
  Email transmissions cannot be guaranteed to be secure or
  error-free as information could be intercepted, corrupted,
  lost, destroyed, arrive late or incomplete, or contain
  viruses. The company therefore does not accept liability for
  any errors or omissions in the contents of this message which
  arise as a result of email transmission.
  
  
  -Original Message-
  From: Piotr Kliczewski [mailto:piotr.kliczew...@gmail.com]
  Sent: Tuesday, March 17, 2015 3:35 PM
  To: Renchu Mathew
  Cc: Piotr Kliczewski; Eli Mesika; users@ovirt.org
  Subject: Re: [ovirt-users] Power Management config on Ovirt
  
  On Tue, Mar 17, 2015 at 12:18 PM, Renchu Mathew
  ren...@cracknell.com
  wrote:
   Hi Piotr,
  
   I have re-installed the node with ovirt node 3.5 latest
   version and tried the power management and it shows test
   succeeded, on but if I stop the network of one of the node
   the running  vm is not migrating to the other instead both
   the nodes are getting down.
   Can anybody help me on this?
  
  
  Please provide engine and both nodes logs for analysis.
  
  
   Also is it possible to use the resources (CPU cores and
   memory) from other node in the same cluster or combine 2
   nodes in same clusters and create a vm on that.
  
   Regards
  
   Renchu Mathew
  
   -Original Message-
   From: Piotr Kliczewski [mailto:pklic...@redhat.com]
   Sent: Tuesday, January 27, 2015 2:04 PM
   To: Renchu Mathew
   Cc: Piotr Kliczewski; Eli Mesika; users@ovirt.org
   Subject: Re: [ovirt-users] Power Management config on Ovirt
  
  
  
  
  
   - Original Message -
   From: Renchu Mathew ren...@cracknell.com
   To: Piotr Kliczewski pklic...@redhat.com
   Cc: Piotr Kliczewski piotr.kliczew...@gmail.com, Eli
   Mesika
   emes...@redhat.com, users@ovirt.org
   Sent: Tuesday, January 27, 2015 10:48:12 AM
   Subject: RE: [ovirt-users] Power Management config on Ovirt
  
   Hi Piotr,
  
   Can you please provide me the link to download the new node iso?
   I can see only ovirt live iso.
  
  
   I saw that Douglas sent following links in other thread [1]
   on this
   list:
  
   centos7:
   http://jenkins.ovirt.org/job/ovirt-node_master_create-iso-el
   7_
   me
   rg
   ed
   /
  
   Fedora20:
   http://jenkins.ovirt.org/job/ovirt-node_master_create-iso-fc
   20
   _m
   er
   ge
   d/
  
   Please note that We should share the official iso this week.
  
   [1]
   http://lists.ovirt.org/pipermail/users/2015-January/030846.h
   tm
   l
  
  
   Regards
  
   Renchu Mathew
  
   -Original Message-
   From: Piotr Kliczewski [mailto:pklic...@redhat.com]
   Sent: Tuesday, January 27, 2015 12:21 PM
   To: Renchu Mathew
   Cc: Piotr Kliczewski; Eli Mesika; users@ovirt.org
   Subject: Re: [ovirt-users] Power Management config on Ovirt
  
   Hi Mathew,
  
   It seems like this is quite old version (September 2014).
   There were good number of fixes in this area.
  
   Looking at provided logs I am not able to tell which call
   is exactly failing.
   Do you have any steps to reproduce?
  
   Thanks,
   Piotr
  
   - Original Message -
   From: Renchu Mathew ren...@cracknell.com
   To: Piotr Kliczewski piotr.kliczew...@gmail.com
   Cc: Eli Mesika emes...@redhat.com, Piotr Kliczewski
   pklic...@redhat.com, users@ovirt.org
   Sent: Monday, January 26, 2015 5:15:46 AM
   Subject: RE: [ovirt-users] Power Management config on Ovirt
  
   Hi Piotr,
   VDSM Version is vdsm-4.16.4-0.el6
  
   Regards
  
   Renchu Mathew
   .
  
   From: Piotr Kliczewski [mailto:piotr.kliczew...@gmail.com]
   Sent: Sunday, January 25, 2015 6:08 PM
   To: Renchu Mathew
   Cc: Eli Mesika; Piotr Kliczewski; users@ovirt.org
   Subject: Re: [ovirt-users] Power Management config on Ovirt

Re: [ovirt-users] Power Management config on Ovirt

2015-03-18 Thread Eli Mesika


- Original Message -
 From: Renchu Mathew ren...@cracknell.com
 To: Eli Mesika emes...@redhat.com
 Cc: Martin Perina mper...@redhat.com, users@ovirt.org
 Sent: Wednesday, March 18, 2015 3:15:40 PM
 Subject: RE: [ovirt-users] Power Management config on Ovirt
 
 Hi Eli,
 
 Those 2 hosts are connected with Fujitsu iRMC management port and power
 management is configured with ipmi. So it can use this connection to fence
 the other node, is it correct?

No, keep in mind that the one that communicates with the proxy host is the 
oVirt engine, so , if it is not accessable, oVirt engine can not use it 


 
 Regards
 
 Renchu Mathew
 
 -Original Message-
 From: Eli Mesika [mailto:emes...@redhat.com]
 Sent: Wednesday, March 18, 2015 4:31 PM
 To: Renchu Mathew
 Cc: Martin Perina; users@ovirt.org
 Subject: Re: [ovirt-users] Power Management config on Ovirt
 
 
 
 - Original Message -
  From: Renchu Mathew ren...@cracknell.com
  To: Martin Perina mper...@redhat.com
  Cc: users@ovirt.org
  Sent: Wednesday, March 18, 2015 2:24:46 PM
  Subject: Re: [ovirt-users] Power Management config on Ovirt
  
  Hi Martin,
  
  My setup meets all those requirements and I can able to migrate the VM
  from one host to another manually. Once network cable is pulled off
  from one of the server other server is also shuts down.
 
 Hi
 Sorry for jumping in late , Yesterday was an election day in ISRAEL...
 
 If the other server shuts down when you plug-off the first one and you have
 only 2 hosts then no fencing will take place since there is no available
 proxy host to perform the operation
 
  
  Regards
  
  Renchu Mathew  |  Sr. IT Administrator
  
  
  
  CRACKNELL  DUBAI   |  P.O. Box 66231  |   United Arab Emirates  |  T
  +971 4
  3445417  |  F +971 4 3493675 |  M +971 50 7386484 ABU DHABI | DUBAI |
  LONDON | MUSCAT | DOHA | JEDDAH EMAIL ren...@cracknell.com | WEB
  www.cracknell.com
  
  This email, its content and any files transmitted with it are intended
  solely for the addressee(s) and may be legally privileged and/or
  confidential. If you are not the intended recipient please let us know
  by email reply and delete it from the system. Please note that any
  views or opinions presented in this email do not necessarily represent
  those of the company. Email transmissions cannot be guaranteed to be
  secure or error-free as information could be intercepted, corrupted,
  lost, destroyed, arrive late or incomplete, or contain viruses. The
  company therefore does not accept liability for any errors or
  omissions in the contents of this message which arise as a result of email
  transmission.
  
  
  -Original Message-
  From: Martin Perina [mailto:mper...@redhat.com]
  Sent: Tuesday, March 17, 2015 8:31 PM
  To: Renchu Mathew
  Cc: users@ovirt.org
  Subject: Re: [ovirt-users] Power Management config on Ovirt
  
  Hi,
  
  prior to the test I would check this:
  
- Data Center status is Up
- All hosts status is Up
- All storage domains status is Up
- VM is running
  
  If this is valid, you can start your fence testing. But bear in mind
  what I sent you in previous email: at least one host in DC should be
  fully functional to be able to fence non responsive host.
  
  Martin Perina
  
  - Original Message -
   From: Renchu Mathew ren...@cracknell.com
   To: Martin Perina mper...@redhat.com
   Cc: users@ovirt.org
   Sent: Tuesday, March 17, 2015 5:03:53 PM
   Subject: RE: [ovirt-users] Power Management config on Ovirt
   
   Hi Martin
   
   Yes, my test VM still running on this storage. Is it possible to do
   remote session and check this?
   
   Regards
   
   Renchu Mathew
   
   
   -Original Message-
   From: Martin Perina [mailto:mper...@redhat.com]
   Sent: Tuesday, March 17, 2015 7:30 PM
   To: Renchu Mathew
   Cc: users@ovirt.org
   Subject: Re: [ovirt-users] Power Management config on Ovirt
   
   Hi,
   
   this is what happened (at least what I was able to read from log):
   
   18:18:02 - host node02 changed status to Connecting
   
 - that's OK, but prior to this I can see many errors
   from ConnectStorage*Commands. Are you sure that your storage
   was ok prior to fencing test?
   
   18:18:51 - host node02 changed status to Non Responsive
   
 - that's OK, non responding treatment started with SSH Soft
   Fencing
   
   
   18:18:55 - SSH Soft Fencing failed, because of no route to host
   node02
   
 - that's OK
   
   
   18:18:56 - power management stop was executed using node01 as fence
   proxy
   
 - problem started here, communication with node01 was timed out, we
 were
   not able to find any other suitable fence proxy
   
   18:21:57 - host node01 changed status to Connection
   
   
   From this point there's is nothing that can be done, because engine
   cannot communicate with any host, so it cannot fix anything.
   
   When you are doing those tests you need  at least one functional
   host

Re: [ovirt-users] Dell DRAC 8

2015-03-08 Thread Eli Mesika
Hi

You can always add iDrac8 as a custom agent 

http://www.ovirt.org/Custom_Fencing

Eli


- Original Message -
 From: Patrick Russell patrick_russ...@volusion.com
 To: Nathanaël Blanchet blanc...@abes.fr, users@ovirt.org
 Sent: Friday, March 6, 2015 8:33:10 PM
 Subject: Re: [ovirt-users] Dell DRAC 8
 
 I ended up using the drac5 fence, secure, and cmd_prompt=
 
 This works if I connect to the individual idrac for each blade. I never did
 get it working from the CMC level, but this way is acceptable.
 
 -Patrick
 
 
 From: Nathanaël Blanchet
 Date: Friday, March 6, 2015 at 5:11 AM
 To:  users@ovirt.org 
 Subject: Re: [ovirt-users] Dell DRAC 8
 
 Hi,
 
 Did you try with this options? It is intended for the second generation of
 idrac7 but, it may work for idrac8.
 
 
 
 - Original Message -
 
 
 From: Oved Ourfali oourf...@redhat.com
 To: Nathanaël Blanchet blanc...@abes.fr
 Cc: users@ovirt.org , Eli Mesika emes...@redhat.com
 Sent: Monday, February 2, 2015 7:04:05 PM
 Subject: Re: [ovirt-users] power management test fails while ipmi command
 successes
 
 We've recently pushed a patch to have lanplus as a default option for drac7.
 Until then you can set this option explicitly through the additional options
 in the power management configuration tab in the edit/add host dialog.
 Please check whether it helps.
 
 CC-ing Eli, just in case I've missed something.
 Please make sure that you have the following in the UI options field (on the
 Edit dialog PM TAB)
 
 privlvl=OPERATOR,lanplus,delay=10
 
 
 
 
 Regards,
 Oved
 
 On Feb 2, 2015 6:10 PM, Nathanaël Blanchet blanc...@abes.fr wrote:
 
 
 Hi all,
 
 I've just installed two new dell r630 hosts and every thing is alright
 with vdsm registration, but power management test always fails with ipmi
 or drac7 item. When I start the manual ipmi command like this ipmitool
 -I lanplus -H 10.34.20.45 -U root chassis power status, it always
 success with power chassis is on.
 All of my other dell servers (r710, r620) success on power management test.
 Is it a known bug?
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
 Le 06/03/2015 03:54, Patrick Russell a écrit :
 
 
 
 Looks like it’s just the CMC, I can use power management on the individual
 sled DRAC’s using the drac5 fence agent no problem.
 
 -Patrick
 
 
 From: Volusion Inc
 Date: Thursday, March 5, 2015 at 8:22 PM
 To:  users@ovirt.org 
 Subject: [ovirt-users] Dell DRAC 8
 
 Anyone having success with fencing and DRAC 8 via CMC? We just received a
 couple Dell FX2 chassis and we’re having trouble getting the fencing agents
 to work on these. It is a CMC setup similar to the dell blade chassis, but
 it DRAC version 8.
 
 -Patrick
 
 
 ___
 Users mailing list Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Issues adding a custom fencing agent

2015-02-15 Thread Eli Mesika


- Original Message -
 From: Tobias Fiebig m...@wybt.net
 To: Eli Mesika emes...@redhat.com
 Cc: users@ovirt.org
 Sent: Wednesday, February 11, 2015 2:17:02 PM
 Subject: Re: [ovirt-users] Issues adding a custom fencing agent
 
 Heho,
  Assigned both BZ to me, will handle ...
  Thanks for finding that
 Np. Btw... is there some further documentation on the fencing scripts?
 I basically ended up reading the python scripts to figure out how they
 work, and that the supplied commands do no really equal to the options
 expected via stdin.

Yes, please take a look on those:

https://fedorahosted.org/cluster/wiki/FenceArch
https://fedorahosted.org/cluster/wiki/FenceArguments


 
 If that is missing i can spend some time on compiling some doc-snippets
 for that, which could be placed on the ovirt page.
 
 With best Regards,
 Tobias
 
 
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Issues adding a custom fencing agent

2015-02-11 Thread Eli Mesika


- Original Message -
 From: Tobias Fiebig m...@wybt.net
 To: users@ovirt.org
 Sent: Monday, February 9, 2015 8:18:11 PM
 Subject: Re: [ovirt-users] Issues adding a custom fencing agent
 
 Heho,
 solved (more or less) with:
 
 https://bugzilla.redhat.com/show_bug.cgi?id=1190843
 
 and
 
 https://bugzilla.redhat.com/show_bug.cgi?id=1190845

Assigned both BZ to me, will handle ...
Thanks for finding that 

 
 With best Regards,
 Tobias
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Issues adding a custom fencing agent

2015-02-09 Thread Eli Mesika


- Original Message -
 From: Tobias Fiebig m...@wybt.net
 To: users@ovirt.org
 Sent: Thursday, February 5, 2015 8:43:26 PM
 Subject: [ovirt-users] Issues adding a custom fencing agent
 
 Heho,
 i currently try to get an intelmodular server working with fencing,
 following:
 http://lists.ovirt.org/pipermail/devel/2014-February/006525.html
 and
 http://www.ovirt.org/Custom_Fencing
 
 BaseInfo:
 Scientific Linux 6.6 (engine/hosts)
 Ovirt 3.5
 
 I added an agent with:
 
 engine-config -s CustomVdsFenceType=intelmodular
 /etc/init.d/ovirt-engine restart
 
 The issue is, that the added agent always results in:
 
 2015-02-05 19:31:08,963 ERROR [org.ovirt.engine.core.bll.FenceExecutor]
 (ajp--127.0.0.1-8702-1) Failed to run Power Management command on Host ,
 no running proxy Host was found.

Hi

How many hosts do you have in the cluster/dc ?

 
 and:
 Test Failed, There is no other host in the data center that can be used
 to test the power management settings.
 
 Picking any other agent, results in the execution of the binary on one
 of the cluster hosts. (which, of course fails).
 Replacing one of theses default-fences with a bash-script echoing $@ to
 a file prints nothing, additional programs (id, env) however do print
 sth. to the given file.
 
 Any ideas on how to continue this, to ideally get fence_intelmodular
 working?
 
 With best Regards,
 Tobias
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] power management test fails while ipmi command successes

2015-02-03 Thread Eli Mesika


- Original Message -
 From: Oved Ourfali oourf...@redhat.com
 To: Nathanaël Blanchet blanc...@abes.fr
 Cc: users@ovirt.org, Eli Mesika emes...@redhat.com
 Sent: Monday, February 2, 2015 7:04:05 PM
 Subject: Re: [ovirt-users] power management test fails while ipmi command 
 successes
 
 We've recently pushed a patch to have lanplus as a default option for drac7.
 Until then you can set this option explicitly through the additional options
 in the power management configuration tab in the edit/add host dialog.
 Please check whether it helps.
 
 CC-ing Eli, just in case I've missed something.

Please make sure that you have the following in the UI options field (on the 
Edit dialog PM TAB) 

privlvl=OPERATOR,lanplus,delay=10


 
 Regards,
 Oved
 
 On Feb 2, 2015 6:10 PM, Nathanaël Blanchet blanc...@abes.fr wrote:
 
  Hi all,
 
  I've just installed two new dell r630 hosts and every thing is alright
  with vdsm registration, but power management test always fails with ipmi
  or drac7 item. When I start the manual ipmi command like this ipmitool
  -I lanplus -H 10.34.20.45 -U root chassis power status, it always
  success with power chassis is on.
  All of my other dell servers (r710, r620) success on power management test.
  Is it a known bug?
  ___
  Users mailing list
  Users@ovirt.org
  http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Host remains Non-Responsive after reboot

2015-01-27 Thread Eli Mesika


- Original Message -
 From: ILanit Stein ist...@redhat.com
 To: Artyom Lukianov aluki...@redhat.com, Eli Mesika emes...@redhat.com
 Cc: users@ovirt.org, rabsh...@citytwist.net
 Sent: Tuesday, January 27, 2015 5:19:12 PM
 Subject: Fwd: [ovirt-users] Host remains Non-Responsive after reboot
 
 
 Hi Guys,
 
 Can you please look into this please?

Hi
From the logs I can see clearly that host is turned on in 2015-01-26 
11:56:51,191
However, there is a stomp exception in 2015-01-26 11:56:53,544 and a connection 
timeout in 2015-01-26 11:56:53,553 that might be related 

Piotr, can you please have a look ?


 
 Thanks,
 Ilanit.
 - Forwarded Message -
 From: Rob Abshear rabsh...@citytwist.net
 To: ILanit Stein ist...@redhat.com
 Sent: Tuesday, January 27, 2015 3:05:56 PM
 Subject: Re: [ovirt-users] Host remains Non-Responsive after reboot
 
 Here are the logs. you requested.  The shutdown of the node was at 11:53
 and vdsmd was manually restarted at 12:01 to get the node back online.
 
 On Tue, Jan 27, 2015 at 2:05 AM, ILanit Stein ist...@redhat.com wrote:
 
  It might be a bug,
  Would you please attach the logs, I mentioned bellow,
  that can bring more details on the failure?
  Adding Eli, that may want to give some input on this issue.
 
  Thanks,
  Ilanit.
 
  - Original Message -
  From: Rob Abshear rabsh...@citytwist.net
  To: ILanit Stein ist...@redhat.com
  Cc: users@ovirt.org
  Sent: Monday, January 26, 2015 9:43:14 PM
  Subject: Re: [ovirt-users] Host remains Non-Responsive after reboot
 
  I have done a bit more investigating on this matter.  If I restart the node
  from within oVirt using the power management option restart, then the
  node restarts and vdsmd DOES NOT start.  If I go into the DRAC and issue
  the command to power cycle the machine, then the machine restarts and vdsmd
  DOES start.  I can run the following command from another node in the
  cluster:
  fence_drac5 -a 192.168.200.105 -l root -p password -x -o reboot
  and the node restarts and vdsmd DOES start.
 
  On Sun, Jan 25, 2015 at 1:56 AM, ILanit Stein ist...@redhat.com wrote:
 
   Hi Rob,
  
   Thanks for this report.
  
   Would you please provide these logs, at the time frame, the host failure
   occur:
   1. oVirt Engine: /var/log/ovirt-engine/engine.log
   2. host: /var/log/vdsm/vdsm.log
  
   If it is reproducible, please add this info as well.
  
   You can also check vdsm service status, on host, while host reported as
   Non responsive,
   by running on host 'service vdsmd status'
   There might some problem, that might have prevented from vdsm service to
   come up, on host.
  
   Ilanit.
  
   - Original Message -
   From: Rob Abshear rabsh...@citytwist.net
   To: users@ovirt.org
   Sent: Friday, January 23, 2015 9:22:42 PM
   Subject: [ovirt-users] Host remains Non-Responsive after reboot
  
  
   I am running oVirt Engine Version 3.5.0.1-1.el6. I have 4 hosts in the
   cluster. Each host has a drac5 and it is configured and working. I am
   trying to simulate a node failure. I am running one HA VM on one of the
   hosts for testing. I simulate the failure by powering off the host with
  the
   VM running.
  
   Here is what is happening.
  
  
   * Host is powered off
   * ~4 minutes pass and the host is recognized as not responding
   * Automatic fence runs and the VM migrates. Another host in the node
   is chosen as a proxy to execute Status command on the host.
   * Same host is chosen as proxy to execute Start command on the host.
   * Same host is chosen as proxy to execute Status command on the host.
   * The host DOES physically start.
   * The host never shows status of UP.
   * I select “confirm host has been rebooted” and I see a manual fence
   start.
   * Host stays non-responsive.
   * I put the host in maintenance and then activate it.
   * Host still non-responsive
   * I put the host in maintenance and do a reinstall
   * Reinstall finishes and host becomes UP
  
   So, everything seems to go fine with the HA functionality, but the host
   never recovers without being reinstalled. Please let me know which logs
  you
   need to look at to help me out with this.
  
   Thanks
  
  
   Sent with Mixmax
  
   ___
   Users mailing list
   Users@ovirt.org
   http://lists.ovirt.org/mailman/listinfo/users
  
 
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Power Management config on Ovirt

2015-01-25 Thread Eli Mesika
Hi Renchu

I am looking currently on he case and will respond later on today after 
investigating the logs.
If I will not find anything, can I use the details for the host PM only for 
status command to try to debug and find the source of the problem ?

Thanks

Eli

- Original Message -
 From: Renchu Mathew ren...@cracknell.com
 To: Martin Perina mper...@redhat.com
 Cc: users@ovirt.org, Eli Mesika emes...@redhat.com
 Sent: Sunday, January 25, 2015 6:50:00 AM
 Subject: RE: [ovirt-users] Power Management config on Ovirt
 
 Hi Martin,
 
 I got the below output when I run the command and it works from both the
 nodes.
 
 fence_ipmilan -a 192.168.1.114 -l admin -p admin -o status -v -P
 
 Getting status of IPMI:192.168.1.114...Spawning: '/usr/bin/ipmitool -I
 lanplus -H '192.168.1.114' -U 'admin' -P '[set]' -v chassis power status'...
 Chassis power = On
 Done
 
 Thanks
 
 Renchu Mathew  |  Sr. IT Administrator
 
 
 
 CRACKNELL  DUBAI   |  P.O. Box 66231  |   United Arab Emirates  |  T +971 4
 3445417  |  F +971 4 3493675 |  M +971 50 7386484
 ABU DHABI | DUBAI | LONDON | MUSCAT | DOHA | JEDDAH
 EMAIL ren...@cracknell.com | WEB www.cracknell.com
 
 This email, its content and any files transmitted with it are intended solely
 for the addressee(s) and may be legally privileged and/or confidential. If
 you are not the intended recipient please let us know by email reply and
 delete it from the system. Please note that any views or opinions presented
 in this email do not necessarily represent those of the company. Email
 transmissions cannot be guaranteed to be secure or error-free as information
 could be intercepted, corrupted, lost, destroyed, arrive late or incomplete,
 or contain viruses. The company therefore does not accept liability for any
 errors or omissions in the contents of this message which arise as a result
 of email transmission.
 
 
 -Original Message-
 From: Martin Perina [mailto:mper...@redhat.com]
 Sent: Thursday, January 22, 2015 6:12 PM
 To: Renchu Mathew
 Cc: users@ovirt.org; Eli Mesika
 Subject: Re: [ovirt-users] Power Management config on Ovirt
 
 
 
 - Original Message -
  From: Renchu Mathew ren...@cracknell.com
  To: Martin Perina mper...@redhat.com
  Cc: users@ovirt.org
  Sent: Thursday, January 22, 2015 2:39:43 PM
  Subject: RE: [ovirt-users] Power Management config on Ovirt
  
  Hi Martin,
  
  
  
  Yes. The vdsm host.log is from node-02.
 
 That's strange, I cannot find any call to fenceNode which should appear, if
 PM status is gathered.
 
 Eli, any idea?
 
  I have checked the link and it says
  we need to install the sever view management agent  net-snmp on the hosts.
  Do we need to try this? How to install this on node? I used the below
  irmc admin user.
 
 Not, AFAIK this is needed only from Clustersuite, but not for oVirt.
 
 But could you please execute this command on node-20 just to confirm that
 Fujitsu Primergy is communicating through IPMI:
 
   fence_ipmilan -a IP -l USER -p PASS -o status -v -P
 
 where IP is IPMI address (from the log it should be 192.168.1.114) USER and
 PASS please set according to you setup.
 
 Thanks
 
 Martin
 
  
  
  
  [cid:image001.png@01D03669.DD48B4E0]
  
  
  
  Regards
  
  
  
  Renchu Mathew  |  Sr. IT Administrator
  
  
  
  
  
  
  
  CRACKNELL  DUBAI   |  P.O. Box 66231  |   United Arab Emirates  |  T +971 4
  3445417  |  F +971 4 3493675 |  M +971 50 7386484
  
  ABU DHABI | DUBAI | LONDON | MUSCAT | DOHA | JEDDAH
  
  EMAIL ren...@cracknell.com | WEB www.cracknell.com
  
  
  
  This email, its content and any files transmitted with it are intended
  solely for the addressee(s) and may be legally privileged and/or
  confidential. If you are not the intended recipient please let us know
  by email reply and delete it from the system. Please note that any
  views or opinions presented in this email do not necessarily represent
  those of the company. Email transmissions cannot be guaranteed to be
  secure or error-free as information could be intercepted, corrupted,
  lost, destroyed, arrive late or incomplete, or contain viruses. The
  company therefore does not accept liability for any errors or
  omissions in the contents of this message which arise as a result of email
  transmission.
  
  
  
  
  
  -Original Message-
  From: Martin Perina [mailto:mper...@redhat.com]
  Sent: Thursday, January 22, 2015 4:49 PM
  To: Renchu Mathew
  Cc: users@ovirt.org
  Subject: Re: [ovirt-users] Power Management config on Ovirt
  
  
  
  Hi,
  
  
  
  according to [1] Fujitsu iRMC should be accessible using IPMI.
  
  Now, I looked at logs, but I cannot see any fenceNode exection in vdsm.log.
  According to engine.log, host Node-02.cracknell.com was used as fence
  proxy.
  Are you sure that vdsm.log is from this host?
  
  
  
  Thanks
  
  
  
  Martin
  
  
  
  [1]
  https://www.redhat.com/archives/linux-cluster/2010-January/msg00056.ht
  ml
  
  
  
  
  
  - Original Message -
  
   From

Re: [ovirt-users] Power Management config on Ovirt

2015-01-25 Thread Eli Mesika


- Original Message -
 From: Renchu Mathew ren...@cracknell.com
 To: Eli Mesika emes...@redhat.com
 Cc: Martin Perina mper...@redhat.com, users@ovirt.org
 Sent: Sunday, January 25, 2015 11:19:21 AM
 Subject: RE: [ovirt-users] Power Management config on Ovirt
 
 Hi Eli,
 
 Please use any details.
 
 Thanks for your support.
 
 Regards
 
 Renchu Mathew

Hi again

Looking in the logs I see that this is a issue we handled when we switched from 
XML RPC to JSON RPC protocol.
Which vdsm is installed in the proxy host ?  
I am adding Piotr who is on charge of the JSON RPC protocol and who helped me 
in the past when I got a similar error on PM operations 

 
 -Original Message-
 From: Eli Mesika [mailto:emes...@redhat.com]
 Sent: Sunday, January 25, 2015 12:58 PM
 To: Renchu Mathew
 Cc: Martin Perina; users@ovirt.org
 Subject: Re: [ovirt-users] Power Management config on Ovirt
 
 Hi Renchu
 
 I am looking currently on he case and will respond later on today after
 investigating the logs.
 If I will not find anything, can I use the details for the host PM only for
 status command to try to debug and find the source of the problem ?
 
 Thanks
 
 Eli
 
 - Original Message -
  From: Renchu Mathew ren...@cracknell.com
  To: Martin Perina mper...@redhat.com
  Cc: users@ovirt.org, Eli Mesika emes...@redhat.com
  Sent: Sunday, January 25, 2015 6:50:00 AM
  Subject: RE: [ovirt-users] Power Management config on Ovirt
  
  Hi Martin,
  
  I got the below output when I run the command and it works from both
  the nodes.
  
  fence_ipmilan -a 192.168.1.114 -l admin -p admin -o status -v -P
  
  Getting status of IPMI:192.168.1.114...Spawning: '/usr/bin/ipmitool -I
  lanplus -H '192.168.1.114' -U 'admin' -P '[set]' -v chassis power
  status'...
  Chassis power = On
  Done
  
  Thanks
  
  Renchu Mathew  |  Sr. IT Administrator
  
  
  
  CRACKNELL  DUBAI   |  P.O. Box 66231  |   United Arab Emirates  |  T
  +971 4
  3445417  |  F +971 4 3493675 |  M +971 50 7386484 ABU DHABI | DUBAI |
  LONDON | MUSCAT | DOHA | JEDDAH EMAIL ren...@cracknell.com | WEB
  www.cracknell.com
  
  This email, its content and any files transmitted with it are intended
  solely for the addressee(s) and may be legally privileged and/or
  confidential. If you are not the intended recipient please let us know
  by email reply and delete it from the system. Please note that any
  views or opinions presented in this email do not necessarily represent
  those of the company. Email transmissions cannot be guaranteed to be
  secure or error-free as information could be intercepted, corrupted,
  lost, destroyed, arrive late or incomplete, or contain viruses. The
  company therefore does not accept liability for any errors or
  omissions in the contents of this message which arise as a result of email
  transmission.
  
  
  -Original Message-
  From: Martin Perina [mailto:mper...@redhat.com]
  Sent: Thursday, January 22, 2015 6:12 PM
  To: Renchu Mathew
  Cc: users@ovirt.org; Eli Mesika
  Subject: Re: [ovirt-users] Power Management config on Ovirt
  
  
  
  - Original Message -
   From: Renchu Mathew ren...@cracknell.com
   To: Martin Perina mper...@redhat.com
   Cc: users@ovirt.org
   Sent: Thursday, January 22, 2015 2:39:43 PM
   Subject: RE: [ovirt-users] Power Management config on Ovirt
   
   Hi Martin,
   
   
   
   Yes. The vdsm host.log is from node-02.
  
  That's strange, I cannot find any call to fenceNode which should
  appear, if PM status is gathered.
  
  Eli, any idea?
  
   I have checked the link and it says
   we need to install the sever view management agent  net-snmp on the
   hosts.
   Do we need to try this? How to install this on node? I used the
   below irmc admin user.
  
  Not, AFAIK this is needed only from Clustersuite, but not for oVirt.
  
  But could you please execute this command on node-20 just to confirm
  that Fujitsu Primergy is communicating through IPMI:
  
fence_ipmilan -a IP -l USER -p PASS -o status -v -P
  
  where IP is IPMI address (from the log it should be 192.168.1.114)
  USER and PASS please set according to you setup.
  
  Thanks
  
  Martin
  
   
   
   
   [cid:image001.png@01D03669.DD48B4E0]
   
   
   
   Regards
   
   
   
   Renchu Mathew  |  Sr. IT Administrator
   
   
   
   
   
   
   
   CRACKNELL  DUBAI   |  P.O. Box 66231  |   United Arab Emirates  |  T +971
   4
   3445417  |  F +971 4 3493675 |  M +971 50 7386484
   
   ABU DHABI | DUBAI | LONDON | MUSCAT | DOHA | JEDDAH
   
   EMAIL ren...@cracknell.com | WEB www.cracknell.com
   
   
   
   This email, its content and any files transmitted with it are
   intended solely for the addressee(s) and may be legally privileged
   and/or confidential. If you are not the intended recipient please
   let us know by email reply and delete it from the system. Please
   note that any views or opinions presented in this email do not
   necessarily represent those of the company. Email transmissions

Re: [ovirt-users] Alerts

2015-01-07 Thread Eli Mesika


- Original Message -
 From: Koen Vanoppen vanoppen.k...@gmail.com
 To: users@ovirt.org
 Sent: Wednesday, January 7, 2015 7:42:25 AM
 Subject: [ovirt-users] Alerts
 
 Hi All,
 
 We recently had a major crash on our ovirt environment due a strange bug (has
 been reported in the meanwhile).
 
 But now we are left we a bunch of aerts (+100) that are still standing
 there... Is there a way I can flush them manually from command line or so?
 Because the right click+clear all, doesn't seem to work that good... :-).

If you want to remove ALL alerts run from command line 

psql -U engine -c delete from audit_log where severity = 10; engine 

NOTE:
Keep in mind that before any manual operation on your database you should 
backup it first.

 
 Kind regards,
 
 Koen
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Problem Upgrading 3.4.4 - 3.5

2014-12-22 Thread Eli Mesika


- Original Message -
 From: InterNetX - Juergen Gotteswinter j...@internetx.com
 To: users@ovirt.org
 Sent: Monday, December 22, 2014 11:08:05 AM
 Subject: [ovirt-users] Problem Upgrading 3.4.4 - 3.5
 
 Hi,
 
 i am currently trying to upgrade an existing 3.4.4 Setup (which got
 upgraded several times before, starting at 3.3), but this time i run
 into a Error while Upgrading the DB

Hi
Can you please attach the following data (this information does not include any 
customer info, just log of installed scripts)

pg_dump -U engine -f schema-version.sql -t schema_version  engine

 
 -- snip --
 
 
 * QUERY **
 ALTER TABLE event_subscriber DROP CONSTRAINT
 fk_event_subscriber_event_notification_methods;
 **
 
 2014-12-20 00:16:27 DEBUG
 otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
 plugin.executeRaw:803 execute-result:
 ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
 '5432', '-u', 'engine', '-d', 'engine', '-l',
 '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log',
 '-c', 'apply'], rc=1
 2014-12-20 00:16:27 DEBUG
 otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
 plugin.execute:861 execute-output:
 ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
 '5432', '-u', 'engine', '-d', 'engine', '-l',
 '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log',
 '-c', 'apply'] stdout:
 Creating schema engine@localhost:5432/engine
 Saving custom users permissions on database objects...
 upgrade script detected a change in Config, View or Stored Procedure...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/_config.sql'...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql'...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql'...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql'...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0040_extend_installed_by_column.sql'...
 Dropping materialized views...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql'...
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql'...
 Skipping upgrade script
 /usr/share/ovirt-engine/dbscripts/upgrade/03_05_0030_add_ha_columns_to_vds_statistics.sql,
 already installed by 03040610
 Skipping upgrade script
 /usr/share/ovirt-engine/dbscripts/upgrade/03_05_0040_add_ha_maintenance_events.sql,
 already installed by 03040620
 Running upgrade sql script
 '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql'...
 
 2014-12-20 00:16:27 DEBUG
 otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
 plugin.execute:866 execute-output:
 ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
 '5432', '-u', 'engine', '-d', 'engine', '-l',
 '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log',
 '-c', 'apply'] stderr:
 psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql:2:
 ERROR:  constraint fk_event_subscriber_event_notification_methods of
 relation event_subscriber does not exist
 FATAL: Cannot execute sql command:
 --file=/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql
 
 2014-12-20 00:16:27 DEBUG otopi.context context._executeMethod:152
 method exception
 Traceback (most recent call last):
   File /usr/lib/python2.6/site-packages/otopi/context.py, line 142, in
 _executeMethod
 method['method']()
   File
 /usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py,
 line 291, in _misc
 oenginecons.EngineDBEnv.PGPASS_FILE
   File /usr/lib/python2.6/site-packages/otopi/plugin.py, line 871, in
 execute
 command=args[0],
 RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/schema.sh'
 failed to execute
 2014-12-20 00:16:27 ERROR otopi.context context._executeMethod:161
 Failed to execute stage 'Misc configuration': Command
 '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute
 2014-12-20 00:16:27 DEBUG otopi.transaction transaction.abort:131
 aborting 'Yum Transaction'
 
 -- snip --
 
 after that, engine-setup starts doing a rollback to 3.4.4 which
 worksflawless.
 
 Anyone got an Idea what is causing this?
 
 Thanks,
 
 Juergen
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Problem Upgrading 3.4.4 - 3.5

2014-12-22 Thread Eli Mesika


- Original Message -
 From: InterNetX - Juergen Gotteswinter j...@internetx.com
 To: Eli Mesika emes...@redhat.com
 Cc: users@ovirt.org
 Sent: Monday, December 22, 2014 12:06:51 PM
 Subject: Re: [ovirt-users] Problem Upgrading 3.4.4 - 3.5
 
 Am 22.12.2014 um 10:41 schrieb Eli Mesika:
  
  
  - Original Message -
  From: InterNetX - Juergen Gotteswinter j...@internetx.com
  To: users@ovirt.org
  Sent: Monday, December 22, 2014 11:08:05 AM
  Subject: [ovirt-users] Problem Upgrading 3.4.4 - 3.5
 
  Hi,
 
  i am currently trying to upgrade an existing 3.4.4 Setup (which got
  upgraded several times before, starting at 3.3), but this time i run
  into a Error while Upgrading the DB
  
  Hi
  Can you please attach the following data (this information does not include
  any customer info, just log of installed scripts)
  
  pg_dump -U engine -f schema-version.sql -t schema_version  engine
 
 sure :)
 

I 
It seems that somebody had deleted manually the constraint 
fk_event_subscriber_event_notification_methods from your database 
Therefor, the first line that attempts to drop this constraint in 
03_05_0050_event_notification_methods.sql:  ALTER TABLE event_subscriber DROP 
CONSTRAINT fk_event_subscriber_event_notification_methods;
fails.

Please try to run the following manually and upgrade again

psql -U engine -c ALTER TABLE ONLY event_subscriber ADD CONSTRAINT 
fk_event_subscriber_event_notification_methods FOREIGN KEY (method_id) 
REFERENCES event_notification_methods(method_id) ON DELETE CASCADE; engine 

Let me know how it is going ...

Eli


  
 
  -- snip --
 
 
  * QUERY **
  ALTER TABLE event_subscriber DROP CONSTRAINT
  fk_event_subscriber_event_notification_methods;
  **
 
  2014-12-20 00:16:27 DEBUG
  otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
  plugin.executeRaw:803 execute-result:
  ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
  '5432', '-u', 'engine', '-d', 'engine', '-l',
  '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log',
  '-c', 'apply'], rc=1
  2014-12-20 00:16:27 DEBUG
  otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
  plugin.execute:861 execute-output:
  ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
  '5432', '-u', 'engine', '-d', 'engine', '-l',
  '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log',
  '-c', 'apply'] stdout:
  Creating schema engine@localhost:5432/engine
  Saving custom users permissions on database objects...
  upgrade script detected a change in Config, View or Stored Procedure...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/_config.sql'...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql'...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql'...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql'...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0040_extend_installed_by_column.sql'...
  Dropping materialized views...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql'...
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql'...
  Skipping upgrade script
  /usr/share/ovirt-engine/dbscripts/upgrade/03_05_0030_add_ha_columns_to_vds_statistics.sql,
  already installed by 03040610
  Skipping upgrade script
  /usr/share/ovirt-engine/dbscripts/upgrade/03_05_0040_add_ha_maintenance_events.sql,
  already installed by 03040620
  Running upgrade sql script
  '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql'...
 
  2014-12-20 00:16:27 DEBUG
  otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
  plugin.execute:866 execute-output:
  ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
  '5432', '-u', 'engine', '-d', 'engine', '-l',
  '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log',
  '-c', 'apply'] stderr:
  psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql:2:
  ERROR:  constraint fk_event_subscriber_event_notification_methods of
  relation event_subscriber does not exist
  FATAL: Cannot execute sql command:
  --file=/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql
 
  2014-12-20 00:16:27 DEBUG otopi.context context._executeMethod:152
  method exception
  Traceback (most recent call last):
File /usr/lib/python2.6/site-packages/otopi/context.py, line 142, in
  _executeMethod
  method['method']()
File
  /usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db

Re: [ovirt-users] Problem Upgrading 3.4.4 - 3.5

2014-12-22 Thread Eli Mesika


- Original Message -
 From: InterNetX - Juergen Gotteswinter j...@internetx.com
 To: users@ovirt.org
 Sent: Monday, December 22, 2014 2:07:55 PM
 Subject: Re: [ovirt-users] Problem Upgrading 3.4.4 - 3.5
 
 Hello again,
 
  It seems that somebody had deleted manually the constraint
  fk_event_subscriber_event_notification_methods from your database
  Therefor, the first line that attempts to drop this constraint in
  03_05_0050_event_notification_methods.sql:  ALTER TABLE event_subscriber
  DROP CONSTRAINT fk_event_subscriber_event_notification_methods;
  fails.
 
 uhm, interesting. could this be caused be deinstallation of dwh reporting?
 
  
  Please try to run the following manually and upgrade again
  
  psql -U engine -c ALTER TABLE ONLY event_subscriber ADD CONSTRAINT
  fk_event_subscriber_event_notification_methods FOREIGN KEY (method_id)
  REFERENCES event_notification_methods(method_id) ON DELETE CASCADE;
  engine
  
 
 it just drops ERROR:  relation event_notification_methods does not
 exist

OK
Lets check what do you have in your DB

Please attach the result of the following 

psql -U engine -c select table_name from information_schema.tables where 
table_schema = 'public' order by table_name ; engine 

Thanks 


 
  Let me know how it is going ...
  
  Eli
  
 
 Thank you already for your help!
 
 Juergen
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] alternate method of fencing

2014-12-17 Thread Eli Mesika


- Original Message -
 From: Brent Hartzell brent.hartz...@outlook.com
 To: users@ovirt.org
 Sent: Friday, December 12, 2014 6:14:40 PM
 Subject: [ovirt-users] alternate method of fencing
 
 
 
 Is there a way to force oVirt to place a host into maintenance mode
 automatically when a problem occurs? The problem we have is separate
 networks for everything:
 
 
 
 2 public nics which are bonded active/backup for internet access
 
 4 bonded gigabit nics for our Gluster network
 
 1 IPMI
 
 
 
 The ipmi is on a completely different network, not attached to anything else
 other than a VPN.
 
 
 
 ///
 
 
 
 Our cluster servers shared Gluster  hypervisor on the same hosts, which
 works great however, all are 1U servers so we don’t have room for another
 NIC to dedicate to just an ipmi network connection in addition to the ipmi
 card itself. Even if the PSU on a host fails, then the ipmi power management
 is useless anyhow and the VM’s on that host will not be moved.
 
 
 
 I’ve tested putting a host into maintenance mode with running VM’s and it
 will auto-migrate the VM’s without issue. Is there a way to make oVirt just
 force a host into maintenance mode if there’s some sort of problem or some
 other fencing mechanism that will allow the VM’s to be migrated to another
 host?

I think this is a scheduling issue rather than fencing , please take a look at 
http://www.ovirt.org/Features/oVirtScheduler
http://www.ovirt.org/Features/oVirtSchedulerAPI
http://www.ovirt.org/Features/oVirt_External_Scheduling_Proxy

 
 
 
 
 
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] webui typo

2014-12-11 Thread Eli Mesika


- Original Message -
 From: Alon Bar-Lev alo...@redhat.com
 To: Scott Worthington scott.c.worthing...@gmail.com
 Cc: users@ovirt.org
 Sent: Thursday, December 11, 2014 12:21:38 AM
 Subject: Re: [ovirt-users] webui typo
 
 
 
 - Original Message -
  From: Scott Worthington scott.c.worthing...@gmail.com
  To: users@ovirt.org
  Sent: Thursday, December 11, 2014 12:18:58 AM
  Subject: [ovirt-users] webui typo
  
  I'm not certain where the code is that contains this typo, but Live
  Snapsnot
  Support should read Live Snapshot Support
  
  I am running ovirt-engine-3.5.0.1-1.el6
  
  I found some files that contained Snapsnot in here:
  /usr/share/ovirt-engine/engine.ear/webadmin.war/deferredjs/
  
  
  
  Should I open a bz?

git grep -i Live Snapsnot Support
frontend/webadmin/modules/webadmin/src/main/resources/org/ovirt/engine/ui/webadmin/ApplicationConstants_de_DE.properties:liveSnapshotSupportHostGeneral=Live
 Snapsnot Support

seems that it is only in the DE translation file ...

Einav?



 
 Sure.
 ___
 Users mailing list
 Users@ovirt.org
 http://lists.ovirt.org/mailman/listinfo/users
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


  1   2   3   >