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
