Fabio, que você acha? Tá me parecendo base mesmo. Vê as ultimas 3 linhas, reclama de indice duplicado. Em 29/06/2011 09:51, "emerson lopes" <emerson.pal...@gmail.com> escreveu: > Segue abaixo: > > > 2011-06-29 03:50:05 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:50:05 BRT FATAL: the database system is starting up > 2011-06-29 03:50:05 BRT LOG: database system was interrupted; last known up > at 2011-06-29 03:48:17 BRT > 2011-06-29 03:50:05 BRT LOG: database system was not properly shut down; > automatic recovery in progress > 2011-06-29 03:50:05 BRT LOG: record with zero length at B8/CB5C4708 > 2011-06-29 03:50:05 BRT LOG: redo is not required > 2011-06-29 03:50:06 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:50:06 BRT FATAL: the database system is starting up > 2011-06-29 03:50:07 BRT LOG: database system is ready to accept connections > 2011-06-29 03:50:07 BRT LOG: autovacuum launcher started > 2011-06-29 03:50:07 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 07:01:12 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 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. > 2011-06-29 07:01:56 BRT ERROR: index "pg_class_oid_index" contains > unexpected zero page at block 0 > 2011-06-29 07:01:56 BRT HINT: Please REINDEX it. > 2011-06-29 07:02:56 BRT ERROR: index "pg_class_oid_index" contains > unexpected zero page at block 0 > 2011-06-29 07:02:56 BRT HINT: Please REINDEX it. > 2011-06-29 07:03:56 BRT ERROR: index "pg_class_oid_index" contains > unexpected zero page at block 0 > 2011-06-29 07:03:56 BRT HINT: Please REINDEX it. > 2011-06-29 07:04:20 BRT LOG: received fast shutdown request > 2011-06-29 07:04:20 BRT LOG: aborting any active transactions > 2011-06-29 07:04:20 BRT LOG: autovacuum launcher shutting down > 2011-06-29 07:04:20 BRT LOG: shutting down > 2011-06-29 07:04:20 BRT LOG: database system is shut down > 2011-06-29 03:24:09 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:24:10 BRT FATAL: the database system is starting up > 2011-06-29 03:24:10 BRT LOG: database system was interrupted; last known up > at 2011-06-28 18:56:43 BRT > 2011-06-29 03:24:10 BRT LOG: database system was not properly shut down; > automatic recovery in progress > 2011-06-29 03:24:10 BRT LOG: record with zero length at B8/C3409208 > 2011-06-29 03:24:10 BRT LOG: redo is not required > 2011-06-29 03:24:11 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:24:11 BRT FATAL: the database system is starting up > 2011-06-29 03:24:12 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:24:12 BRT FATAL: the database system is starting up > 2011-06-29 03:24:12 BRT LOG: database system is ready to accept connections > 2011-06-29 03:24:12 BRT LOG: autovacuum launcher started > 2011-06-29 03:24:13 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:25:33 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-06-29 03:25:59 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 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 > > > Em 29 de junho de 2011 09:44, Fábio Telles Rodriguez < fabio.tel...@gmail.com >> escreveu: > >> Em 29 de junho de 2011 09:35, emerson lopes <emerson.pal...@gmail.com >escreveu: >> >>> Opa Bruno! >>> >>> Esse banco em específico é 8.3 e o PGADMIN é 1.8.4. >>> >>> Realmente não sei como refazer o índice! Se puder me ajudar, fico grato, >>> >> >> Bom, o problema parece estar no banco de dados, não no pgadmin. Mas isso é >> fácil de verificar, já tentou se conectar com o psql do próprio servidor >> onde o postgres está instalado? >> >> Tem como mandar o log do postgres? >> >> Se você estiver perdido, inseguro e esta base for importante, recomendo >> contratar um DBA. Dependendo do que você fizer, você pode piorar a situação. >> Se não for importante, mande o log e a gente vê se consegue lhe ajudar. >> >>> >>> Emerson >>> >>> escreveu: >>> >>>> >>>> > Senhores, >>>> > >>>> > Estou com o seguinte erro no meu banco de dados. Alguem pode me dar uma >>>> luz >>>> > ? Obs.: Não estou conseguindo acessar o PGADMIN, como proceder ? >>>> > >>>> > >>>> > index "pg_class_oid_index" contains unexpected zero page at block 0 >>>> > >>>> > >>>> > Obrigado, >>>> > >>>> > Emerson Lopes >>>> >>>> _______________________________________________ >>>> pgbr-geral mailing list >>>> pgbr-geral@listas.postgresql.org.br >>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>> >>>> >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> pgbr-geral@listas.postgresql.org.br >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> >> -- >> Atenciosamente, >> Fábio Telles Rodriguez >> blog: http://www.midstorm.org/~telles/ >> e-mail / gtalk / MSN: fabio.tel...@gmail.com >> Skype: fabio_telles >> >> >> _______________________________________________ >> pgbr-geral mailing list >> pgbr-geral@listas.postgresql.org.br >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >>
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
