BUG #15074: psql client never returns when creating index (long running operation)

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: lars(dot)vonk(at)gmail(dot)com
Subject: BUG #15074: psql client never returns when creating index (long running operation)
Date: 2018-02-19 08:26:48
Message-ID: 151902880834.1393.3975169520725435333@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15074
Logged by: Lars Vonk
Email address: lars(dot)vonk(at)gmail(dot)com
PostgreSQL version: 9.6.7
Operating system: ubuntu 14.04 LTS
Description:

When creating an index on a table containing approx. 100M records the psql
client never returns when the index is eventually created on the server.
This happens both in a psql client (9.6.6) on mac osx and using the libpq
client via the ruby pg gem when using active records migrations.

When running the command directly op the postgres database server using the
psql client it works as expected.

The logs from the server:
2018-02-16 16:11:05 CET:82.161.205.254(59584):REDACTED(at)REDACTED_DB:[23141]:
LOG: duration: 999618.165 ms
2018-02-16 16:11:05 CET:82.161.205.254(59584):REDACTED(at)REDACTED_DB:[23141]:
LOG: could not receive data from client: Connection reset by peer

The psql client just hangs, when trying to cancel the query client side
(ctrl-c) the server logs says:
2018-02-16 16:13:53 CET:82.161.205.254(59961):[unknown](at)[unknown]:[25738]:
LOG: PID 23141 in cancel request did not match any process

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-02-19 08:33:49 BUG #15075: jsonb_set return [null] if new value is null but not 'null'.
Previous Message Pawan Sharma 2018-02-19 06:40:30 Re: Installation problem