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
