Re: Create Index CONCURRENTLY Hangs Indefinitely. - Mailing list pgsql-admin

From Jan Lentfer
Subject Re: Create Index CONCURRENTLY Hangs Indefinitely.
Date
Msg-id 62cfc7c5688f59b16d257b9dbfb382d3@imap.lan.net
Whole thread Raw
In response to Create Index CONCURRENTLY Hangs Indefinitely.  (Wei Shan <weishan.ang@gmail.com>)
List pgsql-admin
Am 2015-05-19 12:30, schrieb Wei Shan:
> Hi all,
>
> Today I tried to create an index online, however it took far too long
> that I cancelled the query.
>
> 1. psql version => 9.2.4
> 2. Table structure as follows. (7.5GB in size)
>
> evocsp=# d certificatedata
>        Table "public.certificatedata"
>         Column        |  Type   | Modifiers
> ----------------------+---------+-----------
>  fingerprint          | text    | not null
>  base64cert           | text    |
>  cafingerprint        | text    |
>  certificateprofileid | integer | not null
>  expiredate           | bigint  | not null
>  issuerdn             | text    | not null
>  revocationdate       | bigint  | not null
>  revocationreason     | integer | not null
>  rowprotection        | text    |
>  rowversion           | integer | not null
>  serialnumber         | text    | not null
>  status               | integer | not null
>  subjectdn            | text    | not null
>  subjectkeyid         | text    |
>  tag                  | text    |
>  type                 | integer | not null
>  updatetime           | bigint  | not null
>  username             | text    |
> Indexes:
>     "certificatedata_pkey" PRIMARY KEY, btree (fingerprint)
>     "certificatedata_idx7" btree (certificateprofileid)
>
> 3. The query ran was => CREATE INDEX CONCURRENTLY
> certificatedata_idx2
> ON CertificateData (username) tablespace tablespace_index;
> 4. After it took more than 2hrs+, I went to terminate the session via
> Ctrl-C, it returned the following error.
>
> WARNING:  canceling wait for synchronous replication due to user
> request
> DETAIL:  The transaction has already committed locally, but might not
> have been replicated to the standby.
> ^CCancel request sent
> ERROR:  canceling statement due to user request
>
> Any input or ideas are welcome.


Was your SR slave actually online consuming changes? What does "select
* from pg_stat_replication" tell you?

Jan


pgsql-admin by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: Create Index CONCURRENTLY Hangs Indefinitely.
Next
From: Gustav Karlsson
Date:
Subject: Deleting old WAL-files