Tem como eu verificar se ele gerou alguma inconsistência no catálogo? Em 5 de julho de 2012 16:34, Aldrey Galindo <[email protected]>escreveu:
> Guedes, > > Eu rodei e não apareceu nada. > > Em 5 de julho de 2012 16:30, Dickson S. Guedes <[email protected]>escreveu: > > Em 5 de julho de 2012 16:23, Aldrey Galindo <[email protected]> >> escreveu: >> > Matheus, >> > >> > Era um acesso que tentei nesse momento. >> > Reiniciei novamente o banco e quando tento refazer a tabela, ele >> começa a >> > rodar 'ALTER TABLE waiting'. Mais não faz nada, nem IO ele faz direito. >> >> Esta consulta te mostra qual processo esta esperando por outro: >> >> SELECT waiting.locktype AS waiting_locktype, >> waiting.relation::regclass AS waiting_table, waiting_stm.current_query >> AS waiting_query, waiting.mode AS waiting_mode, waiting.pid AS >> waiting_pid, other.locktype AS other_locktype, >> other.relation::regclass AS other_table, other_stm.current_query AS >> other_query, other.mode AS other_mode, other.pid AS other_pid, >> other.granted AS other_granted >> FROM pg_locks waiting >> JOIN pg_stat_activity waiting_stm ON waiting_stm.procpid = waiting.pid >> JOIN pg_locks other ON waiting.database = other.database AND >> waiting.relation = other.relation OR waiting.transactionid = >> other.transactionid >> JOIN pg_stat_activity other_stm ON other_stm.procpid = other.pid >> WHERE waiting.granted = false AND waiting.pid <> other.pid; >> >> >> Veja se consegue rastrear. >> >> []s >> -- >> Dickson S. Guedes >> mail/xmpp: [email protected] - skype: guediz >> http://guedesoft.net - http://www.postgresql.org.br >> _______________________________________________ >> 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
