{"id":256,"date":"2025-11-24T02:48:34","date_gmt":"2025-11-24T02:48:34","guid":{"rendered":"https:\/\/ayoocloud.com.br\/blog\/?p=256"},"modified":"2025-11-24T02:48:34","modified_gmt":"2025-11-24T02:48:34","slug":"resolvendo-erro-select-from-to_master-virtualizor-proxmox","status":"publish","type":"post","link":"https:\/\/ayoocloud.com.br\/blog\/2025\/11\/24\/resolvendo-erro-select-from-to_master-virtualizor-proxmox\/","title":{"rendered":"Resolvendo erro SELECT * FROM to_master Virtualizor proxmox"},"content":{"rendered":"<h1 data-start=\"239\" data-end=\"342\"><\/h1>\n<h1 data-start=\"239\" data-end=\"342\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-257\" src=\"https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/11\/000-http-error-codes-1024x576.png\" alt=\"Proxmox e Virtualizor Error SELECT * FROM to_master\" width=\"608\" height=\"342\" srcset=\"https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/11\/000-http-error-codes-1024x576.png 1024w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/11\/000-http-error-codes-300x169.png 300w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/11\/000-http-error-codes-768x432.png 768w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/11\/000-http-error-codes.png 1080w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/h1>\n<h1 data-start=\"239\" data-end=\"342\"><\/h1>\n<h1 data-start=\"239\" data-end=\"342\">Como resolver o erro \u201cCan&#8217;t find file: &#8216;to_master&#8217; (errno: 2)\u201d no Virtualizor (SOLU\u00c7\u00c3O DEFINITIVA)<\/h1>\n<p data-start=\"344\" data-end=\"652\">Neste artigo vou ajudar quem est\u00e1 enfrentando o erro relacionado \u00e0 tabela <strong data-start=\"418\" data-end=\"431\">to_master<\/strong> ao tentar acessar o painel do Virtualizor.<br data-start=\"474\" data-end=\"477\" \/>Esse erro aconteceu comigo do nada \u2014 o painel simplesmente parou de funcionar. Pesquisei em v\u00e1rios lugares, vi gente com o mesmo problema, mas ningu\u00e9m tinha uma resposta real.<\/p>\n<p data-start=\"654\" data-end=\"758\">Depois de investigar por conta pr\u00f3pria e conversar com o ChatGPT, descobri a causa REAL e como resolver.<\/p>\n<hr data-start=\"760\" data-end=\"763\" \/>\n<h2 data-start=\"765\" data-end=\"788\">\u2757 O erro que aparece<\/h2>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">Could <span class=\"hljs-keyword\">not<\/span> make the Query.<br \/>\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> to_master<br \/>\n<span class=\"hljs-keyword\">Array<\/span><br \/>\n(<br \/>\n    [<span class=\"hljs-number\">0<\/span>] <span class=\"hljs-operator\">=<\/span><span class=\"hljs-operator\">&gt;<\/span> HY000<br \/>\n    [<span class=\"hljs-number\">1<\/span>] <span class=\"hljs-operator\">=<\/span><span class=\"hljs-operator\">&gt;<\/span> .......<br \/>\n    [<span class=\"hljs-number\">2<\/span>] <span class=\"hljs-operator\">=<\/span><span class=\"hljs-operator\">&gt;<\/span> Can<span class=\"hljs-string\">'t find file: '<\/span>to_master<span class=\"hljs-string\">' (errno: 2)<br \/>\n)<br \/>\n<\/span><\/code><\/div>\n<\/div>\n<hr data-start=\"946\" data-end=\"949\" \/>\n<h2 data-start=\"951\" data-end=\"980\">\u2714 A causa REAL do problema<\/h2>\n<p data-start=\"982\" data-end=\"1004\">A causa \u00e9 bem simples:<\/p>\n<h3 data-start=\"1006\" data-end=\"1082\"><strong data-start=\"1010\" data-end=\"1082\">\u27a1 O disco onde o Proxmox\/Virtualizor est\u00e1 instalado est\u00e1 100% cheio.<\/strong><\/h3>\n<p data-start=\"1084\" data-end=\"1193\">Quando isso acontece, o Virtualizor <strong data-start=\"1120\" data-end=\"1149\">n\u00e3o consegue gravar dados<\/strong> na tabela <code data-start=\"1160\" data-end=\"1171\">to_master<\/code>, e o painel n\u00e3o abre.<\/p>\n<p data-start=\"1195\" data-end=\"1267\">Isso n\u00e3o tem nada a ver com MySQL, permiss\u00e3o, arquivo corrompido ou bug.<\/p>\n<hr data-start=\"1269\" data-end=\"1272\" \/>\n<h1 data-start=\"1274\" data-end=\"1315\">1. Veja quanto do disco est\u00e1 ocupado<\/h1>\n<p data-start=\"1317\" data-end=\"1325\">Execute:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-bash\"><span class=\"hljs-built_in\">df<\/span> -h \/<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"1348\" data-end=\"1371\">Se aparecer algo assim:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">\/dev\/md3   97G   96G   100%   \/<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"1414\" data-end=\"1445\">\u27a1 <strong data-start=\"1416\" data-end=\"1445\">Pronto: achou o problema.<\/strong><\/p>\n<hr data-start=\"1447\" data-end=\"1450\" \/>\n<h1 data-start=\"1452\" data-end=\"1502\">2. Descubra QUAL pasta est\u00e1 lotando seu disco<\/h1>\n<p data-start=\"1504\" data-end=\"1564\">Esse comando abaixo foi o que realmente salvou meu servidor:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-bash\"><span class=\"hljs-built_in\">du<\/span> -xh \/ | grep -E <span class=\"hljs-string\">\"G|M\"<\/span> | <span class=\"hljs-built_in\">sort<\/span> -h | <span class=\"hljs-built_in\">tail<\/span> -n 30<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"1627\" data-end=\"1631\">Ele:<\/p>\n<ul data-start=\"1633\" data-end=\"1784\">\n<li data-start=\"1633\" data-end=\"1667\">\n<p data-start=\"1635\" data-end=\"1667\">lista o uso de TODAS as pastas<\/p>\n<\/li>\n<li data-start=\"1668\" data-end=\"1703\">\n<p data-start=\"1670\" data-end=\"1703\">exibe somente tamanhos em MB\/GB<\/p>\n<\/li>\n<li data-start=\"1704\" data-end=\"1736\">\n<p data-start=\"1706\" data-end=\"1736\">ordena do menor para o maior<\/p>\n<\/li>\n<li data-start=\"1737\" data-end=\"1784\">\n<p data-start=\"1739\" data-end=\"1784\">mostra os 30 maiores consumidores de espa\u00e7o<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1786\" data-end=\"1935\">N\u00e3o importa onde esteja o problema:<br data-start=\"1821\" data-end=\"1824\" \/><code data-start=\"1824\" data-end=\"1834\">\/var\/log<\/code>, <code data-start=\"1836\" data-end=\"1849\">\/var\/lib\/vz<\/code>, <code data-start=\"1851\" data-end=\"1858\">\/root<\/code>, <code data-start=\"1860\" data-end=\"1872\">\/usr\/local<\/code>, <code data-start=\"1874\" data-end=\"1898\">\/var\/virtualizor\/proxk<\/code>, qualquer lugar \u2014 ele SEMPRE mostra.<\/p>\n<hr data-start=\"1937\" data-end=\"1940\" \/>\n<h1 data-start=\"1942\" data-end=\"1978\">3. Como interpretar o resultado<\/h1>\n<p data-start=\"1980\" data-end=\"2011\">O final normalmente fica assim:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">XXG \/alguma\/pasta<br \/>\nYYG \/outra\/pasta<br \/>\nZZG \/<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"2063\" data-end=\"2107\">O <strong data-start=\"2065\" data-end=\"2094\">maior n\u00famero antes de \u201c\/\u201d<\/strong> \u00e9 o culpado.<\/p>\n<p data-start=\"2109\" data-end=\"2121\">No meu caso:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre!\">77G \/var\/virtualizor\/proxk<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"2159\" data-end=\"2242\">Ou seja:<br data-start=\"2167\" data-end=\"2170\" \/>\u27a1 <strong data-start=\"2172\" data-end=\"2242\">Meus templates do Virtualizor estavam ocupando quase todo o disco.<\/strong><\/p>\n<hr data-start=\"2244\" data-end=\"2247\" \/>\n<h1 data-start=\"2249\" data-end=\"2276\">4. Como liberar espa\u00e7o<\/h1>\n<p data-start=\"2278\" data-end=\"2321\">Depois de identificar o culpado, voc\u00ea pode:<\/p>\n<ul data-start=\"2323\" data-end=\"2414\">\n<li data-start=\"2323\" data-end=\"2350\">\n<p data-start=\"2325\" data-end=\"2350\">apagar arquivos grandes<\/p>\n<\/li>\n<li data-start=\"2351\" data-end=\"2377\">\n<p data-start=\"2353\" data-end=\"2377\">mover para outro disco<\/p>\n<\/li>\n<li data-start=\"2378\" data-end=\"2391\">\n<p data-start=\"2380\" data-end=\"2391\">compactar<\/p>\n<\/li>\n<li data-start=\"2392\" data-end=\"2414\">\n<p data-start=\"2394\" data-end=\"2414\">fazer backup antes<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"2416\" data-end=\"2440\">Para deletar um arquivo:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-bash\"><span class=\"hljs-built_in\">rm<\/span> -f \/caminho\/do\/arquivo<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"2481\" data-end=\"2513\">Ou, se quiser confirma\u00e7\u00e3o antes:<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-bash\"><span class=\"hljs-built_in\">rm<\/span> -i \/caminho\/do\/arquivo<br \/>\n<\/code><\/div>\n<\/div>\n<hr data-start=\"2554\" data-end=\"2557\" \/>\n<h1 data-start=\"2559\" data-end=\"2620\">5. Se depois de liberar espa\u00e7o o painel ainda n\u00e3o voltar<\/h1>\n<p data-start=\"2622\" data-end=\"2678\">Reinicie apenas o painel do Virtualizor (N\u00c3O afeta VMs):<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-bash\">service virtualizor restart<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"2721\" data-end=\"2723\">ou<\/p>\n<div class=\"contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-bash\">systemctl restart virtualizor<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"2768\" data-end=\"2816\">Depois disso, o meu painel voltou imediatamente.<\/p>\n<hr data-start=\"2818\" data-end=\"2821\" \/>\n<h1 data-start=\"2823\" data-end=\"2844\">Experi\u00eancia real<\/h1>\n<p data-start=\"2846\" data-end=\"3067\">Eu abri ticket com o suporte da empresa, esperei 3 dias e n\u00e3o obtive solu\u00e7\u00e3o.<br data-start=\"2923\" data-end=\"2926\" \/>Mexendo por conta pr\u00f3pria, achei o problema e resolvi \u2014 ent\u00e3o estou publicando para ajudar outras pessoas que v\u00e3o passar pela mesma situa\u00e7\u00e3o.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como resolver o erro \u201cCan&#8217;t find file: &#8216;to_master&#8217; (errno: 2)\u201d no Virtualizor (SOLU\u00c7\u00c3O DEFINITIVA) Neste artigo vou ajudar quem est\u00e1 enfrentando o erro relacionado \u00e0 tabela to_master ao tentar acessar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,21,39,29],"tags":[],"class_list":["post-256","post","type-post","status-publish","format-standard","hentry","category-servidor-de-containers-com-docker","category-servidor-de-virtualizacao","category-servidor-de-web","category-servidor-dedicado"],"_links":{"self":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":1,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/256\/revisions"}],"predecessor-version":[{"id":258,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/256\/revisions\/258"}],"wp:attachment":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/categories?post=256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/tags?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}