[ovirt-users] ovirt 3.5.6: ERROR: duplicate key value violates unique constraint "pk_images" during import

[Andrea Ghelardi]

Ciao Sandro,
I understand your curiosity, and as said this is our production environment and we do not have a test one to check upgrades before going live.
Coupled with the fact that system performed reasonably well until now and that we have a long time (bad) habit of “not trying to fix what’s not broken”, we ended up in this situation.
I’m trying to fix this approach since the last few months but changing company habits is a rather slow process.

Cheers
AG

From: Sandro Bonazzola [mailto:sbonazzo at redhat.com]
Sent: Friday, September 02, 2016 10:45
To: Andrea Ghelardi <a.ghelardi at iontrading.com>
Cc: users at ovirt.org
Subject: Re: [ovirt-users] ovirt 3.5.6: ERROR: duplicate key value violates unique constraint "pk_images" during import



On Thu, Sep 1, 2016 at 2:38 PM, Andrea Ghelardi <a.ghelardi at iontrading.com<mailto:a.ghelardi at iontrading.com>> wrote:
Hi Sandro,
Since this is a production environment, our upgrade project is not so quick to complete.
Are you asking because you think this database issue would be cleared by an upgrade or maybe because we could check the bug on a currently maintained version? ☺



No, I'm just asking because 3.5.6 has been released on 2015-12-01. You haven't updated to 3.6 in 3.6 life cycle and now even 3.6 is gone to end of life adn we're already at 3rd maintenace release for 4.0.
You're missing something like 2000 bug fixes / updates including security fixes, urgent and high severity fixes and lot of new features (that you may or may not need, but still...)
So I'm just curious about why you didn't upgrade. If something blocked the upgrade on a test environment or an upgrade on a new version showed regressions or degraded performance or maybe just a matter of "don't change what works fine"


Cheers
AG

From: Sandro Bonazzola [mailto:sbonazzo at redhat.com<mailto:sbonazzo at redhat.com>]
Sent: Thursday, September 01, 2016 14:03
To: Andrea Ghelardi <a.ghelardi at iontrading.com<mailto:a.ghelardi at iontrading.com>>
Cc: users at ovirt.org<mailto:users at ovirt.org>
Subject: Re: [ovirt-users] ovirt 3.5.6: ERROR: duplicate key value violates unique constraint "pk_images" during import

Hi Andrea, I'm a bit curious, any reason for staying on 3.5 and not upgrading to 3.6 / 4.0 ?

On Mon, Aug 15, 2016 at 12:47 AM, Andrea Ghelardi <a.ghelardi at iontrading.com<mailto:a.ghelardi at iontrading.com>> wrote:
Hallo all,

I’m currently unable to import/activate VM due to error above.
It has been a long series of unfortunate events.
Long story short:
- VM running on storage on iscsi failing disks
- put storage and server in maint. Shut down server
- restart server.
- server has a misconfiguration on lvm/multipath rules (not due to ovirt)
- put storage and server active
- cluster goes down. Put storage in maintenance again. Detached storage from cluster (ach! That was unfortunate).
- cluster now ok. Storage ok. Activate storage.
- trying to import VM. Ovirt replies with error in subject and attached.

How can I recover from this situation?
It would be great to recover the entire VM, but I’m more interested in disks which are in unregistered state than VM itself.

Thank you all

_______________________________________________
Users mailing list
Users at ovirt.org<mailto:Users at ovirt.org>
http://lists.ovirt.org/mailman/listinfo/users



--
Sandro Bonazzola
Better technology. Faster innovation. Powered by community collaboration.
See how it works at redhat.com<http://redhat.com>
<https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>


<https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>
 <https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>
-- <https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>
Sandro Bonazzola
Better technology. Faster innovation. Powered by community collaboration.
See how it works at redhat.com<https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>
[http://images.engage.redhat.com/EloquaImages/clients/RedHat/%7B53f97a34-013e-4b79-966f-222f50a6de8c%7D_Red_Hat_Open_Source_Day_2_CITIES.png]<https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160902/78d563ad/attachment-0001.html>