Euler,
Em 5 de setembro de 2013 10:05, Euler Taveira <[email protected]>escreveu: > On 05-09-2013 09:55, JotaComm wrote: > > Exato, é um JOIN entre estas tabelas. O vacuum não está bloqueado > (waiting > > = FALSE) e em pg_locks granded=TRUE. Não tenho prepared statements > > bloqueadas neste banco. > > > > O mais estranho é que não consigo "matar", conforme descrevi acima. > > > Isso parece-me bug do sistema operacional. Digo isso porque se você não > consegue matar o processo é porque ele está interrompido em uma parte > crítica (geralmente I/O). Qual a saída de 'strace -p 2738'? > Segue o strace do processo: semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1179682, {{0, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1998907, {{1, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1277989, {{6, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1867831, {{4, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1998907, {{8, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1376296, {{1, 1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1867831, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1343527, {{6, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1638448, {{15, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1802293, {{13, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{10, 1, 0}}, 1) = 0 semop(2162752, {{8, 1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 semop(2162752, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(2162752, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(2162752, {{9, -1, 0}}, 1) = 0 semop(1998907, {{0, 1, 0}}, 1) = 0 > > > -- > Euler Taveira Timbira - http://www.timbira.com.br/ > PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > Abraços -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
