PrepareStatement.execute() blocked because of long time 'create index' operation, connection leak

Поиск
Список
Период
Сортировка
От jingzhi.zhang@outlook.com
Тема PrepareStatement.execute() blocked because of long time 'create index' operation, connection leak
Дата
Msg-id BLU437-SMTP10F2FDBD2E377E73A45234F95C0@phx.gbl
обсуждение исходный текст
Ответ на Re: Re: Batches of single-insert statements vs batches of multi-insert statements  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: PrepareStatement.execute() blocked because of long time 'create index' operation, connection leak  (Dave Cramer <pg@fastcrypt.com>)
Re: PrepareStatement.execute() blocked because of long time'create index' operation, connection leak  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Дерево обсуждения
Hi,


I use jdbc  to create index on a table, the sql of 'create index' cost about 30 minutes.
Finally I found, the jdbc client thread blocked at PrepareStatement.execute(), not finished.
At server side, query pg_stat_activity, the connection state already be ‘idle’ (index creation finished).

Is there any suggestion? How to deal with the client thread blocking (read for a response message?) and connection leak.


Thanks a lot.


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Re: Batches of single-insert statements vs batches ofmulti-insert statements
Следующее
От: "jingzhi.zhang@outlook.com"
Дата:
Сообщение: PrepareStatement.execute() blocked because of long time 'create index' operation, connection leak