concurrent reindex issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux