Opa Fábio! Obrigado pela ajuda. Então, não estou conseguindo acessar o banco, ele retorna a mensagem após pedir a senha no PSQL. No reindex tambem... E agora ? hehe
Att, Em 29 de junho de 2011 10:13, Fábio Telles Rodriguez <[email protected] > escreveu: > Rode um: > reindexdb -s postgres > > E mandar os logs gerados neste período. Veja se as coisas se normalizam. > > Se o postgres cair antes de concluir o teste, você vai ter de subir o > postgres sem utilizar os índices do catálogo, com a opção -P. Aí > começa a complicar um pouco... > > Veja no log que houve uma queda abrupta por aí: > 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 > > Por outro lado, parece que outra pessoa já andou tentando um REINDEX > por aí, não? Foi você mesmo? Outra pessoa já andou tentando algo? > > []s > > 2011/6/29 emerson lopes <[email protected]> > > > > 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 < > [email protected]> escreveu: > >> > >> Em 29 de junho de 2011 09:35, emerson lopes <[email protected]> > 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 > >>>> [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 > >>> > >> > >> > >> > >> -- > >> Atenciosamente, > >> Fábio Telles Rodriguez > >> blog: http://www.midstorm.org/~telles/ > >> e-mail / gtalk / MSN: [email protected] > >> Skype: fabio_telles > >> > >> _______________________________________________ > >> 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 > > > > > > -- > Atenciosamente, > Fábio Telles Rodriguez > blog: http://www.midstorm.org/~telles/ > e-mail / gtalk / MSN: [email protected] > Skype: fabio_telles > _______________________________________________ > 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
