Juliano, obrigado pela resposta.
O que estou achando estranho é que quando rodamos o vacuum via pg_admin (vacuum full ...), sem vacuumdb, nenhum erro acontece. A principio imaginei que poderia ser algum bug no vacuumdb, mas usei-o para fazer vaccum em outras bases no mesmo servidor e tudo ocorreu bem. Apenas nessa base que ele dá esse erro de "missing chunk". Best regards, -- Miguel Eugênio Ramalho Bezerra, M.Sc. Federal University of Pernambuco, Brazil home: http://www.cin.ufpe.br/~merb/ twitter: @migueleugenio Em 14 de junho de 2013 18:22, Juliano Atanazio <[email protected]>escreveu: > > > > 2013/6/14 Miguel Bezerra <[email protected]> > >> Prezados, >> >> Durante a execução do vacuum full via vacuumdb (vacuumdb -d locadora01 >> -f), na versão 9.1.3, ocorre o erro de "ERROR: missing chunk number 0 for >> toast value 31115602 in pg_toast_2619". >> >> Isso se trata de um bug ou de base corrompida? >> >> >> > Base corrompida. > Isso é possível que aconteça se sua memória não estiver legal. > Dê preferência a memórias com ECC. > > Dê uma olhada nisto: > > > http://www.postgresql.org/message-id/[email protected] > > >> Parte do log, com os erros: >> 2013-06-14 10:24:23 BRT [28206]: [1-1] db=,user=@ 0:10/26270 ERROR: >> canceling autovacuum task >> 2013-06-14 11:30:55 BRT [29279]: [3-1] db=locadora01,user=postgres@[local] >> 3372510:2/197943 ERROR: missing chunk number 0 for toast value 27247037 in >> pg_toast_2619 >> 2013-06-14 11:36:43 BRT [401]: [3-1] db=locadora01,user=postgres@[local] >> 3372530:11/39864 ERROR: missing chunk number 0 for toast value 14806211 in >> pg_toast_2618 >> 2013-06-14 12:26:22 BRT [30474]: [3-1] db=locadora01,user=postgres@[local] >> 3373151:11/44846 ERROR: missing chunk number 0 for toast value 14806211 in >> pg_toast_2618 >> 2013-06-14 12:26:40 BRT [30677]: [3-1] db=locadora01,user=postgres@[local] >> 3373153:11/45031 ERROR: missing chunk number 0 for toast value 14806211 in >> pg_toast_2618 >> 2013-06-14 12:32:00 BRT [32306]: [3-1] db=locadora01,user= >> [email protected](60391) 0:11/46593 ERROR: relation >> "pg_toast_2618" does not exist at character 56 >> 2013-06-14 12:32:14 BRT [32306]: [5-1] db=locadora01,user= >> [email protected](60391) 0:11/46594 ERROR: invalid input syntax >> for type oid: "pg_toast_2618" at character 56 >> 2013-06-14 12:35:11 BRT [3535]: [3-1] db=locadora01,user=postgres@[local] >> 3373156:12/60185 ERROR: missing chunk number 0 for toast value 14806211 in >> pg_toast_2618 >> 2013-06-14 13:47:24 BRT [14886]: [3-1] db=locadora01,user= >> [email protected](49464) 0:6/22977 ERROR: relation "pg_toast" >> does not exist >> 2013-06-14 13:50:17 BRT [14886]: [5-1] db=locadora01,user= >> [email protected](49464) 0:6/22978 ERROR: relation >> "pg_toast_2618" does not exist >> 2013-06-14 16:54:50 BRT [24730]: [3-1] db=locadora01,user=postgres@[local] >> 3374304:14/36878 ERROR: missing chunk number 0 for toast value 31115602 in >> pg_toast_2619 >> >> >> Best regards, >> -- >> Miguel Eugênio Ramalho Bezerra, M.Sc. >> Federal University of Pernambuco, Brazil >> home: http://www.cin.ufpe.br/~merb/ >> twitter: @migueleugenio >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
