concurrent reindex issues

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: concurrent reindex issues
Date: 2009-10-08 17:27:30
Message-ID: 8a547c840910081027l72edbea0gb4134736cffcb54c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hey all, it's been a bit however I'm running into some issues with my
concurrent index

Always get this error during a concurrent index.

*2009-10-07 22:18:02 PDT admissionclsdb postgres 10.13.200.70(46706) ERROR:
deadlock detected*

*2009-10-07 22:18:02 PDT admissionclsdb postgres 10.13.200.70(46706)
DETAIL: Process 20939 waits for ShareLock on virtual transaction
16/43817381; blocked by process 1874.*

* Process 1874 waits for ExclusiveLock on relation 17428 of database
16384; blocked by process 20939.*

*2009-10-07 22:18:02 PDT admissionclsdb postgres 10.13.200.70(46706)
STATEMENT: CREATE INDEX CONCURRENTLY prc_temp_idx_impressions_log_date2 ON
tracking.impressions USING btree (log_date) TABLESPACE trackingindexspace*

This happens all the time, so it's not the occasional deadlock. We even
turned off all applications that insert into the database and it still
fails.

Tried restarting the database as well.

Also when looking at active connections there is no process 1874.

So I'm at a lost, this first started happening in my slave DB (Slon
replication), but it is now happening on my master which is odd.

Any idea?

postgres 8.3.4

Linux system.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin T Pryzby 2009-10-08 17:44:05 Re: dump time increase by 1h with new kernel
Previous Message Joe Uhl 2009-10-08 15:33:00 Partitioned Tables and ORDER BY