Hi,
We are trying to create a index concurrently but, at least apparently, it hangs in a infinite loop and never ends.
Our version:
flip=# select version();
version
--------------------------------
PostgreSQL 9.3.12 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 2012
0313 (Red Hat 4.4.7-16), 64-bit
(1 row)
Index creation:
CREATE INDEX CONCURRENTLY index_texto
ON flip_pagina_edicao
USING hash
(texto COLLATE pg_catalog."default"); -- texto is a text data type.
Size of the table:
flip=# select pg_size_pretty(pg_total_relation_size('flip_pagina_edicao'));
pg_size_pretty
----------------
956 GB
(1 row)
Process strace:
....
semop(622611, {{6, 1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout)
semop(655380, {{5, -1, 0}}, 1) = 0
semop(622611, {{6, 1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
semop(622611, {{6, 1, 0}}, 1) = 0
semop(622611, {{6, 1, 0}}, 1) = 0
semop(622611, {{6, 1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
semop(622611, {{6, 1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
semop(622611, {{6, 1, 0}}, 1) = 0
semop(557073, {{2, 1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
semop(655380, {{5, -1, 0}}, 1) = 0
...
Thanks in advance.
Robert