2011/6/29 emerson lopes <emerson.pal...@gmail.com> > > <corte> > > 2011-06-29 07:01:13 BRT FATAL: index "pg_class_oid_index" contains > unexpected zero page at block 0 > 2011-06-29 07:01:13 BRT HINT: Please REINDEX it. > > Aqui o PostgreSQL está dando uma dica a vc, informando que o índice "pg_class_oid_index" está com problemas e que vc precisa reindexá-lo, tente rodar o comando de dentro do psql:
REINDEX INDEX "pg_class_oid_index"; > <corte> > > 2011-06-29 03:26:14 BRT WARNING: index "pg_statistic_relid_att_index" > contains 1853 row versions, but table contains 1937 row versions > 2011-06-29 03:26:14 BRT HINT: Rebuild the index with REINDEX. > 2011-06-29 03:26:14 BRT WARNING: index "pg_statistic_relid_att_index" > contains 1853 row versions, but table contains 1937 row versions > 2011-06-29 03:26:14 BRT HINT: Rebuild the index with REINDEX. > 2011-06-29 03:26:17 BRT WARNING: index "id_acerto" contains 2832 row > versions, but table contains 3011 row versions > 2011-06-29 03:26:17 BRT HINT: Rebuild the index with REINDEX. > 2011-06-29 03:26:17 BRT WARNING: index "id_acerto" contains 2832 row > versions, but table contains 3011 row versions > 2011-06-29 03:26:17 BRT HINT: Rebuild the index with REINDEX. > > 2011-06-29 03:27:33 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:28:19 BRT NOTICE: table "pg_class" was reindexed > 2011-06-29 03:28:19 BRT NOTICE: table "sql_features" was reindexed > 2011-06-29 03:28:19 BRT NOTICE: table "sql_implementation_info" was > reindexed > 2011-06-29 03:28:19 BRT ERROR: could not create unique index > "pg_statistic_relid_att_index" > 2011-06-29 03:28:19 BRT DETAIL: Table contains duplicated values. > 2011-06-29 03:28:19 BRT STATEMENT: reindex database postgres > > 2011-06-29 03:28:19 BRT WARNING: index "pg_statistic_relid_att_index" > contains 1853 row versions, but table contains 1937 row versions > 2011-06-29 03:28:19 BRT HINT: Rebuild the index with REINDEX. > 2011-06-29 03:28:19 BRT WARNING: index "pg_statistic_relid_att_index" > contains 1853 row versions, but table contains 1937 row versions > 2011-06-29 03:28:19 BRT HINT: Rebuild the index with REINDEX. > 2011-06-29 03:28:19 BRT WARNING: index "id_acerto" contains 2832 row > versions, but table contains 3011 row versions > 2011-06-29 03:28:19 BRT HINT: Rebuild the index with REINDEX. > 2011-06-29 03:28:42 BRT NOTICE: table "pg_class" was reindexed > 2011-06-29 03:28:42 BRT NOTICE: table "sql_features" was reindexed > 2011-06-29 03:28:42 BRT NOTICE: table "sql_implementation_info" was > reindexed > 2011-06-29 03:28:42 BRT ERROR: could not create unique index > "pg_statistic_relid_att_index" > 2011-06-29 03:28:42 BRT DETAIL: Table contains duplicated values. > 2011-06-29 03:28:42 BRT STATEMENT: reindex database postgres > > Não sei o que esta ocorrendo no seu servidor que está ocasionando esses problemas com os índices, o mais adequado é reindexar toda sua base: $ psql -U postgres nomedasuabase nomedasuabase=# REINDEX DATABASE nomedasuabase; Mas cuidado, pq dependendo do tamanho da sua base esse procedimento pode levar bastante tempo... ou se preferiri olhe atentamente o LOG e reindexe somente as tabelas/indices que estão apontando problemas. -- Fabrízio de Royes Mello >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
