Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
On 04/03/2014 01:37 PM, Stefan Wendler wrote: On Thursday 03 April 2014 13:05:36 Roy Golan wrote: On Wed 02 Apr 2014 04:48:12 PM IDT, Stefan Wendler wrote: On Wednesday 02 April 2014 16:16:34 Roy Golan wrote: an upgrade to 3.3 should have run an upgrade script [1] and update all vms with 6 to 0 (the new internal id of other) can you run this sql [2] to see if it did ran? [1] 03_03_0660_alter_os_type_unassigned_to_other.sql [2] psql engine engine -c "select * from schema_version where script ilike '%unassigned%';" The query [2] returns "0 rows" this upgrade is from 3.3.4 to 3.4 i think. did you ever upgraded from 3.2 to 3.3? if yes then we need that upgrade log. AFAIR we started with 3.3 on our production environment. Yes this is from 3.3.4 to 3.4. We had 3.3.0 before and I upgraded to 3.3.4 before going to 3.4 more directions - did you anytime override the osinfo files or added some custom ones? please paste the content of /etc/ovirt-engine/osinfo.conf.d and /usr/share/ovirt-engine/conf/osinfo-defaults.properties /usr/share/ovirt-engine/conf/osinfo-defaults.properties of the centos rpm with the one from the current sources. But it didn't work before that. I just replaced them to check if this would fix it. Until then I never heard of this osinfo file so I never changed/replaced it before. if non of this has relevant results than its totally safe to run the script above mentioned [1] This is the distribution of "os-types" in our database: engine=# select count(*), os from vm_static group by os order by os; count | os ---+-- 5 |0 3 |1 1 |4 46 |5 1 | 11 1 | 12 1 | 16 1 | 1501 (8 rows) So it wouldn't make much sense to execute the "03_03_0660_alter_os_type_unassigned_to_other.sql" ? of course not I forgot you already removed the VM with os id 6. Regarding the config I send you a link to the tgz with all files. I don't want to put the link public because it is my private server with not so much bandwith ;) Cheers, Stefan ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
On Thursday 03 April 2014 13:05:36 Roy Golan wrote: > On Wed 02 Apr 2014 04:48:12 PM IDT, Stefan Wendler wrote: > > On Wednesday 02 April 2014 16:16:34 Roy Golan wrote: > >> an upgrade to 3.3 should have run an upgrade script [1] and update all > >> vms with 6 to 0 (the new internal id of other) > >> > >> can you run this sql [2] to see if it did ran? > >> > >> [1] 03_03_0660_alter_os_type_unassigned_to_other.sql > >> [2] psql engine engine -c "select * from schema_version where script > >> ilike '%unassigned%';" > > > > The query [2] returns "0 rows" > > this upgrade is from 3.3.4 to 3.4 i think. did you ever upgraded from > 3.2 to 3.3? if yes then we need that upgrade log. AFAIR we started with 3.3 on our production environment. Yes this is from 3.3.4 to 3.4. We had 3.3.0 before and I upgraded to 3.3.4 before going to 3.4 > > more directions - did you anytime override the osinfo files or added > some custom ones? please paste the content of > /etc/ovirt-engine/osinfo.conf.d and > /usr/share/ovirt-engine/conf/osinfo-defaults.properties /usr/share/ovirt-engine/conf/osinfo-defaults.properties of the centos rpm with the one from the current sources. But it didn't work before that. I just replaced them to check if this would fix it. Until then I never heard of this osinfo file so I never changed/replaced it before. > > if non of this has relevant results than its totally safe to run the > script above mentioned [1] This is the distribution of "os-types" in our database: engine=# select count(*), os from vm_static group by os order by os; count | os ---+-- 5 |0 3 |1 1 |4 46 |5 1 | 11 1 | 12 1 | 16 1 | 1501 (8 rows) So it wouldn't make much sense to execute the "03_03_0660_alter_os_type_unassigned_to_other.sql" ? Regarding the config I send you a link to the tgz with all files. I don't want to put the link public because it is my private server with not so much bandwith ;) Cheers, Stefan ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
On Wednesday 02 April 2014 09:56:30 Yedidyah Bar David wrote: > > Can you please post the upgrade log from 3.3? Something like > /var/log/ovirt-engine/setup/ovirt-engine-setup-DATE.log > > Thanks! Sent the log to Yedidyah Bar David and Roy Golan only since the file is too long to be pasted anywhere. If somebody else needs it, write me. cheers ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
- Original Message - > From: "Stefan Wendler" > To: "Roy Golan" > Cc: users@ovirt.org > Sent: Wednesday, April 2, 2014 4:48:12 PM > Subject: Re: [Users] VM-List gone after upgrade to 3.4 - Found the error > > On Wednesday 02 April 2014 16:16:34 Roy Golan wrote: > > > > an upgrade to 3.3 should have run an upgrade script [1] and update all > > vms with 6 to 0 (the new internal id of other) > > > > can you run this sql [2] to see if it did ran? > > > > [1] 03_03_0660_alter_os_type_unassigned_to_other.sql > > [2] psql engine engine -c "select * from schema_version where script > > ilike '%unassigned%';" > > The query [2] returns "0 rows" Can you please post the upgrade log from 3.3? Something like /var/log/ovirt-engine/setup/ovirt-engine-setup-DATE.log Thanks! -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
On Wednesday 02 April 2014 16:16:34 Roy Golan wrote: > > an upgrade to 3.3 should have run an upgrade script [1] and update all > vms with 6 to 0 (the new internal id of other) > > can you run this sql [2] to see if it did ran? > > [1] 03_03_0660_alter_os_type_unassigned_to_other.sql > [2] psql engine engine -c "select * from schema_version where script > ilike '%unassigned%';" The query [2] returns "0 rows" ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
On 04/02/2014 11:38 AM, Stefan Wendler wrote: I think I found the error. At least it is working again. When I read the threads Einav provided I recognized that the Problem had been somewhat related to os type "Other" And I have seen some changes regarding FreeBSD. FreeBSD is not the problem here but that got me thinking that we have a FreeBSD VM with vm os type "Other" which was curretly down. Which is the only vm with that type, too. That also explained why I could view all bookmarks for "all running vms" but not the bookmarks for "all vms in cluster" or "all stopped vms". So I started the FreeBSD vm via ovirt-shell and I was able to view "all stopped vms" but not "all running vms". Stopped the vm again and it was vice versa again. So I deleted the vm (but not the disk image) and voila, everything is working again. Recreated the vm with the now available os type FreeBSD and it is still working. So I guess there is a problem with vm os type 6 (Other). Cheers, Stefan On Wednesday 02 April 2014 01:53:09 Omer Frenkel wrote: - Original Message - From: "Itamar Heim" To: "Stefan Wendler" , "Einav Cohen" Cc: users@ovirt.org Sent: Wednesday, April 2, 2014 8:16:04 AM Subject: Re: [Users] VM-List gone after upgrade to 3.4 On 04/01/2014 11:16 PM, Stefan Wendler wrote: Read the links and checked the osinfo properties file. even downloaded the latest one. But it didn't work. I have one FreeBSD vm which has type Other (6 in database) but in the ostype props bundled with version 3.4 (and even the on in git) has backwardCompatibility.Other = 0. The same as unassigned. I changed Other to 6 but it didn't help. The error stays the same. unfortunately. an upgrade to 3.3 should have run an upgrade script [1] and update all vms with 6 to 0 (the new internal id of other) can you run this sql [2] to see if it did ran? [1] 03_03_0660_alter_os_type_unassigned_to_other.sql [2] psql engine engine -c "select * from schema_version where script ilike '%unassigned%';" just to be sure, do you see any error in the engine.log? Stefan - maybe if you can provide the db backup to one of the developers, they can reproduce this. Cheers, Stefan On Tuesday 01 April 2014 12:21:47 Einav Cohen wrote: found some references to the similar issues: one in 3.3.1 that seems to be related to os-info [1]. another issue from latest ovirt (back in January...) which I am not exactly sure how it ended up (os-info? db? maybe Adam remembers?) [2]. not sure if any of them is related, but maybe. HTH. Thanks, Einav [1] http://lists.ovirt.org/pipermail/users/2013-December/thread.html look for a thread titled: 'Strange UI bug: tab "VM" unusable / oVirt 3.3.1+' [2] http://lists.ovirt.org/pipermail/engine-devel/2014-January/thread.html look for a thread titled: 'UI: VM list not populating' - Original Message - From: "Stefan Wendler" Sent: Tuesday, April 1, 2014 11:57:48 AM Thanks for pushing it Einav. Would be nice to have a workaround until there is a real fix or we figured out where I f*cked up ;) Even a patch file for the javascript would be nice. Because we are really relying on the gui. Cheers On Tuesday 01 April 2014 09:42:33 Einav Cohen wrote: Thanks, Stefan. Tomas/UI maintainers: I recall several similar issues in the past - does anyone have any helpful information / recommendations how to proceed? - Original Message - From: "Stefan Wendler" To: "Einav Cohen" Cc: users@ovirt.org Sent: Tuesday, April 1, 2014 9:37:00 AM Subject: Re: [Users] VM-List gone after upgrade to 3.4 You are right. Here is the message: I tried deleting the browser cache but the error stays the same -- begin -- Tue Apr 01 14:46:42 GMT+200 2014 com.google.gwt.logging.client.LogConfiguration SEVERE: (TypeError) stack: TypeError: Cannot call method 'Fk' of null at tek (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:12049:58) at Object.Qom [as z1] (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:17764:28600) at uvk (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:15782:166) at Object.Zzk (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:16763:328) at Zuk (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:15976:146) at $uk (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:15870:29) at tMk (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:7346:19) at Object.cNk [as nV] (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 B6F 9FEF .cache.html:17740:20496) at Object.jyk [as tX] (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19
Re: [Users] VM-List gone after upgrade to 3.4 - Found the error
I think I found the error. At least it is working again. When I read the threads Einav provided I recognized that the Problem had been somewhat related to os type "Other" And I have seen some changes regarding FreeBSD. FreeBSD is not the problem here but that got me thinking that we have a FreeBSD VM with vm os type "Other" which was curretly down. Which is the only vm with that type, too. That also explained why I could view all bookmarks for "all running vms" but not the bookmarks for "all vms in cluster" or "all stopped vms". So I started the FreeBSD vm via ovirt-shell and I was able to view "all stopped vms" but not "all running vms". Stopped the vm again and it was vice versa again. So I deleted the vm (but not the disk image) and voila, everything is working again. Recreated the vm with the now available os type FreeBSD and it is still working. So I guess there is a problem with vm os type 6 (Other). Cheers, Stefan On Wednesday 02 April 2014 01:53:09 Omer Frenkel wrote: > - Original Message - > > > From: "Itamar Heim" > > To: "Stefan Wendler" , "Einav Cohen" > > Cc: users@ovirt.org > > Sent: Wednesday, April 2, 2014 8:16:04 AM > > Subject: Re: [Users] VM-List gone after upgrade to 3.4 > > > > On 04/01/2014 11:16 PM, Stefan Wendler wrote: > > > Read the links and checked the osinfo properties file. even downloaded > > > the > > > latest one. > > > But it didn't work. I have one FreeBSD vm which has type Other (6 in > > > database) > > > but in the ostype props bundled with version 3.4 (and even the on in > > > git) > > > has > > > backwardCompatibility.Other = 0. The same as unassigned. I changed Other > > > to > > > 6 > > > but it didn't help. The error stays the same. unfortunately. > > just to be sure, > do you see any error in the engine.log? > > > Stefan - maybe if you can provide the db backup to one of the > > developers, they can reproduce this. > > > > > Cheers, > > > Stefan > > > > > > On Tuesday 01 April 2014 12:21:47 Einav Cohen wrote: > > >> found some references to the similar issues: > > >> > > >> one in 3.3.1 that seems to be related to os-info [1]. > > >> > > >> another issue from latest ovirt (back in January...) which > > >> I am not exactly sure how it ended up (os-info? db? maybe > > >> Adam remembers?) [2]. > > >> > > >> not sure if any of them is related, but maybe. > > >> HTH. > > >> > > >> > > >> Thanks, > > >> Einav > > >> > > >> [1] http://lists.ovirt.org/pipermail/users/2013-December/thread.html > > >> look for a thread titled: 'Strange UI bug: tab "VM" unusable / oVirt > > >> 3.3.1+' > > >> > > >> [2] > > >> http://lists.ovirt.org/pipermail/engine-devel/2014-January/thread.html > > >> look for a thread titled: 'UI: VM list not populating' > > >> > > >>> - Original Message - > > >>> From: "Stefan Wendler" > > >>> Sent: Tuesday, April 1, 2014 11:57:48 AM > > >>> > > >>> Thanks for pushing it Einav. Would be nice to have a workaround until > > >>> there > > >>> is > > >>> a real fix or we figured out where I f*cked up ;) > > >>> > > >>> Even a patch file for the javascript would be nice. Because we are > > >>> really > > >>> relying on the gui. > > >>> > > >>> Cheers > > >>> > > >>> On Tuesday 01 April 2014 09:42:33 Einav Cohen wrote: > > Thanks, Stefan. > > Tomas/UI maintainers: I recall several similar issues in the past - > > does anyone have any helpful information / recommendations how to > > proceed? > > > > - Original Message - > > > > > From: "Stefan Wendler" > > > To: "Einav Cohen" > > > Cc: users@ovirt.org > > > Sent: Tuesday, April 1, 2014 9:37:00 AM > > > Subject: Re: [Users] VM-List gone after upgrade to 3.4 > > > > > > You are right. Here is the message: > > > > > > I tried deleting the browser cache but the error stays the same > > > > > > > > > > > > -- begin -- > > > > > > Tue Apr 01 14:46:42 GMT+200 2014 > > > com.google.gwt.logging.client.LogConfiguration > > > SEVERE: (TypeError) > > > > > > stack: TypeError: Cannot call method 'Fk' of null > > > > > > at tek > > > (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 > > > B6F > > > 9FEF > > > .cache.html:12049:58) at Object.Qom [as z1] > > > (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 > > > B6F > > > 9FEF > > > .cache.html:17764:28600) at uvk > > > (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 > > > B6F > > > 9FEF > > > .cache.html:15782:166) at Object.Zzk > > > (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 > > > B6F > > > 9FEF > > > .cache.html:16763:328) at Zuk > > > (https://engine/ovirt-engine/webadmin/4A8A784A2E5C61BA5B8132B19 > > > B6F > > > 9FEF > > >
