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? 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
