Pessoal, estou com uma tabela que aparentemente está com um Lock mas não consigo encontrar quem fez isso. Em virtude do lock a tabela está indisponível, não responde mais a selects, inserts, deletes ou updates.
O que posso fazer para voltar essa tabela? Como identificar que transação travou ela (isso se foi uma transação)? Aproveito para perguntar qual o nível de isolamento vocês costumam utilizar? Ambiente: PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux) 4.7.1 20120723 [gcc-4_7-branch revision 189773], 64-bit SO OpenSuse 12.2 Abaixo o retorno do analyze: INFO: vacuuming "public.tb_clientes" INFO: scanned index "clientes_001" to remove 50 row versions DETAIL: CPU 0.10s/0.37u sec elapsed 0.52 sec. INFO: scanned index "clientes_002" to remove 50 row versions DETAIL: CPU 0.08s/0.36u sec elapsed 0.45 sec. INFO: "tb_clientes": removed 50 row versions in 33 pages DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: index "clientes_001" now contains 8287018 row versions in 41091 pages DETAIL: 50 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: index "clientes_002" now contains 8287018 row versions in 31911 pages DETAIL: 50 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: "tb_clientes": found 303 removable, 10430 nonremovable row versions in 127 out of 93475 pages DETAIL: 18 dead row versions cannot be removed yet. There were 6 unused item pointers. 0 pages are entirely empty. CPU 0.19s/0.74u sec elapsed 0.99 sec. INFO: analyzing "public.tb_clientes" INFO: "tb_clientes": scanned 30000 of 93475 pages, containing 2659810 live rows and 4 dead rows; 30000 rows in sample, 8286201 estimated total rows VACUUM _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
