{"id":1385,"date":"2015-01-20T18:41:03","date_gmt":"2015-01-20T10:41:03","guid":{"rendered":"https:\/\/cowmanchiang.me\/wp\/?p=1385"},"modified":"2023-10-31T15:44:06","modified_gmt":"2023-10-31T07:44:06","slug":"vcenter-could-not-allocate-space-for-object-dbo-vpx_event_arg-pk_vpx_event_arg-in-database-vim_vcdb-because-the-primary-filegroup-is-full-create-disk-space-by-deleting-unneeded-files","status":"publish","type":"post","link":"https:\/\/cowmanchiang.me\/wp\/?p=1385","title":{"rendered":"vCenter: Could not allocate space for object &#8230;"},"content":{"rendered":"<p>\u6700\u8fd1 vCenter \u6703\u51fa\u73fe\u67d0\u53f0 ESXi \u4e3b\u6a5f\u7684 &#8220;\u4e3b\u6a5f\u9023\u7dda\u548c\u96fb\u6e90\u72c0\u614b&#8221; \u8b66\u544a&#8230;<br \/>\n\u6240\u4ee5\u6839\u64da <a href=\"https:\/\/communities.vmware.com\/message\/2230696\" title=\"VMware Community : Host connection and Power state in ESXi 5.0\" target=\"_blank\" rel=\"noopener noreferrer\">Host connection and Power state in ESXi 5.0<\/a> \u7684\u8aaa\u660e<br \/>\n\u628a vCenter \u4e0a\u7684\u9632\u706b\u7246\u8a2d\u5b9a \u958b\u555f 902, 5989, 80,443,623, 8000, 8001, 6500, 514,8080 \u9019\u5e7e\u5404 Port<\/p>\n<p>\u7136\u5f8c\u89c0\u5bdf\u4e00\u4e0b vCenter \u90a3\u53f0\u7684\u7cfb\u7d71\u65e5\u8a8c\u767c\u73fe\u4e86\u5e7e\u500b\u932f\u8aa4&#8230;<br \/>\n1. Could not allocate space for object &#8216;dbo.VPX_EVENT_ARG&#8217;.&#8217;PK_VPX_EVENT_ARG&#8217; in database &#8216;VIM_VCDB&#8217; because the &#8216;PRIMARY&#8217; filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.<br \/>\n2. CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.<\/p>\n<p>\u56e0\u70ba\u7576\u521d\u5b89\u88dd\u7684\u7248\u672c\u662f mssql 2005 excpress&#8230;\u8981\u89e3\u6c7a 2 \u7684\u554f\u984c\u53ea\u6709\u5347\u7d1a\u4e86~\u9019\u5371\u96aa\u7684\u52d5\u4f5c\u5c31\u5148\u4e0d\u505a<br \/>\n\u65bc\u662f\u5148\u91dd\u5c0d 1 \u9032\u884c\u4fee\u6b63<br \/>\n\u5148\u4e0b\u8f09 Microsoft SQL Server Management Studio Express 2005 \u9032\u884c\u5b89\u88dd<br \/>\n\u7136\u5f8c\u6839\u64da <a href=\"http:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&#038;cmd=displayKC&#038;externalId=1025914\" title=\"VMware Knowledge Base: Purging old data from the database used by VMware vCenter Server 4.x and 5.x (1025914)\" target=\"_blank\" rel=\"noopener noreferrer\">Purging old data from the database used by VMware vCenter Server 4.x and 5.x (1025914)<\/a> \u7684\u6b65\u9a5f\u9032\u884c<br \/>\n1. \u958b\u555f VIM_VCDB -> dbo.VPX_PARAMETER \u4fee\u6539\u5169\u500b\u5c6c\u6027\u503c<br \/>\n  (1) \u4fee\u6539 event.maxAge \u70ba 30 ( \u7db2\u9801\u4e0a\u8aaa\u7684\uff0c\u53ea\u662f\u6211\u4f9d\u820a\u4fdd\u7559 180 )\uff0c\u4fee\u6539 event.maxAgeEnabled \u70batrue<br \/>\n  (2) \u4fee\u6539 task.maxAge \u70ba 30 ( \u540c\u4e0a )\uff0c\u4fee\u6539 task.maxAgeEnabled \u70batrue<br \/>\n2. \u57f7\u884c\u9810\u5b58\u7a0b\u5e8f VIM_VCDB -> \u53ef\u7a0b\u5f0f\u6027 -> \u9810\u5b58\u7a0b\u5e8f -> dbo.cleanup_events_tasks_proc<\/p>\n<p>\u9019\u6a23\u5c31\u6703\u628a\u8a31\u65e9\u4e4b\u524d\u7684 log \u5148\u6e05\u7a7a\uff0c\u722d\u53d6\u4e00\u9ede\u7a7a\u9593\u5427~!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1 vCenter \u6703\u51fa\u73fe\u67d0\u53f0 ESXi \u4e3b\u6a5f\u7684 &#8220;\u4e3b\u6a5f\u9023\u7dda\u548c\u96fb\u6e90\u72c0\u614b&#8221; \u8b66\u544a&#8230; \u6240\u4ee5\u6839\u64da Host connection and Power state in ESXi 5.0 \u7684\u8aaa\u660e \u628a vCenter \u4e0a\u7684\u9632\u706b\u7246\u8a2d\u5b9a \u958b\u555f 902, 5989, 80,443,623, 8000, 8001, 6500, 514,8080 \u9019\u5e7e\u5404 Port \u7136\u5f8c\u89c0\u5bdf\u4e00\u4e0b vCenter \u90a3\u53f0\u7684\u7cfb\u7d71\u65e5\u8a8c\u767c\u73fe\u4e86\u5e7e\u500b\u932f\u8aa4&#8230; 1. Could not allocate space for object &hellip; <a href=\"https:\/\/cowmanchiang.me\/wp\/?p=1385\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61,14],"tags":[],"class_list":["post-1385","post","type-post","status-publish","format-standard","hentry","category-mssql","category-vmware"],"_links":{"self":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1385"}],"version-history":[{"count":1,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1385\/revisions"}],"predecessor-version":[{"id":1947,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1385\/revisions\/1947"}],"wp:attachment":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}