{"id":419,"date":"2016-09-09T07:13:38","date_gmt":"2016-09-09T07:13:38","guid":{"rendered":"http:\/\/172.16.10.10:8080\/?p=419"},"modified":"2023-03-30T10:37:30","modified_gmt":"2023-03-30T08:37:30","slug":"updating-vcenter-is-always-a-pleasure-part-2-of-3","status":"publish","type":"post","link":"http:\/\/vblog.hochsticher.de\/?p=419","title":{"rendered":"Updating vCenter is always a pleasure &#8230; (Part 2 of 3)"},"content":{"rendered":"<p>Cleanup your DB before the upgrade is not a &#8220;must&#8221; but this is a good moment.<!--more--><\/p>\n<p>But first, take a Selfie &#8230; \u00c4\u00e4\u00e4hh a Snapshot \ud83d\ude09<\/p>\n<p>So&nbsp;follow <a href=\"https:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&amp;cmd=displayKC&amp;externalId=1025914\">this<\/a>&nbsp;guide to purge and&nbsp;<a href=\"https:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&amp;cmd=displayKC&amp;externalId=1036738\">this<\/a>&nbsp;one to shrink your DB. Shrinking your DB took a very long time. In my case with a 90 GB DB on flash disk took about 2,5 hours.<\/p>\n<p>After we cleaned the DB, startup your vCenter Service. This also took a very long time on first&nbsp;startup in my case (~2,5 hours). You can follow&nbsp;it in your vpxd.log:<\/p>\n<pre class=\"lang:default decode:true\" title=\"vpxd.log\">[VdbStatement] SQL execution took too long: select VALUE from VPX_INT_ARRAY where ARRAY_ID = (?) and TYPE_ID = (?) order by ARRAY_INDEX<\/pre>\n<p><!-- index.php -->\n<div\n\tclass=\"ngg-galleryoverview ngg-ajax-pagination-none\"\n\tid=\"ngg-gallery-429-1\">\n\n    \t<div class=\"slideshowlink\">\n        <a href='http:\/\/vblog.hochsticher.de\/index.php\/nggallery\/slideshow?p=419'>[Show slideshow]<\/a>\n\t\t\n\t<\/div>\n\t\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\" >\n\t\t\t\t        <div class=\"ngg-gallery-thumbnail\">\n            <a href=\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-update\/2.jpg\"\n               title=\"\"\n               data-src=\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-update\/2.jpg\"\n               data-thumbnail=\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-update\/thumbs\/thumbs_2.jpg\"\n               data-image-id=\"48\"\n               data-title=\"2\"\n               data-description=\"\"\n               data-image-slug=\"2-1\"\n               class=\"ngg-fancybox\" rel=\"429\">\n                <img\n                    title=\"2\"\n                    alt=\"2\"\n                    src=\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-update\/thumbs\/thumbs_2.jpg\"\n                    width=\"240\"\n                    height=\"160\"\n                    style=\"max-width:100%;\"\n                \/>\n            <\/a>\n        <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n        \n\t\t\n\t\t<!-- Pagination -->\n\t<div class='ngg-clear'><\/div>\t<\/div>\n<\/p>\n<p style=\"text-align: left;\"><em>BTW:&nbsp;<\/em><em>In vCenter 5.5 the default vpxd logpath is &#8220;C:\\ProgramData\\VMware\\VMware VirtualCenter\\Logs&#8221;.&nbsp;<\/em><em>In vCenter 6.0 it&#8217;s in &#8220;C:\\ProgramData\\VMware\\vCenterServer\\logs\\vmware-vpx&#8221;.<\/em><\/p>\n<p>If your vCenter service is up and running, we can start the upgrade to vSphere 6.<\/p>\n<hr>\n<p>The Installer of&nbsp;vCenter 6 is really simple and rock solid. He does a lot of pre-checks to be safe and successfull. In my case he had to upgrade the vCenter certificate.<\/p>\n<p>So, this one took also arround 2 hours to complete.<\/p>\n<hr>\n<p style=\"text-align: left;\">If your vCenter service is up, you can start to upgrade&nbsp;the other components like&nbsp;Updatemanager, vSphere Client, etc.<\/p>\n<hr>\n<p style=\"text-align: left;\">So now we are happy with the upgrade until we see the first bugs.<\/p>\n<p style=\"text-align: left;\">Continue with&nbsp;<a href=\"https:\/\/vblog.hochsticher.de\/\/?p=431\">Part 3<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cleanup your DB before the upgrade is not a &#8220;must&#8221; but this is a good moment.<\/p>\n","protected":false},"author":1,"featured_media":422,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[11,10,7],"tags":[],"class_list":["post-419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","category-vcenter","category-vsphere"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/posts\/419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=419"}],"version-history":[{"count":17,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":1109,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/posts\/419\/revisions\/1109"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=\/wp\/v2\/media\/422"}],"wp:attachment":[{"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/vblog.hochsticher.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}