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
