Postgres 8.3.10 Alter Table Waiting issue

Поиск
Список
Период
Сортировка
Искать

Postgres 8.3.10 Alter Table Waiting issue

От:
Pratheeban Jebasingh Tharmaraj <ptharmaraj@sirahu.com>
Дата:
Hi Team,

I am trying to add column to the table that's hanging.

alter table hr_firms add column_name biginit;

This is the lock I see in the db

 relation      |   564709 | 586888   |      |       |            |               |         |       |          | 1/8                | 1871 | AccessExclusiveLock | f

Version of postgres: 8.3.10 

Is it known issue or any fix available?


--
With Warm Regards,

Pratheeban .T

Re: Postgres 8.3.10 Alter Table Waiting issue

От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
[please don't send a post to multiple lists]
 
Pratheeban Jebasingh Tharmaraj  wrote:
 
> I am trying to add column to the table that's hanging.
> 
> alter table hr_firms add column_name biginit;
> 
> This is the lock I see in the db
> 
>  relation      |   564709 | 586888   |      |       |            |
>     |         |       |          | 1/8                | 1871 |
> AccessExclusiveLock | f
 
So it's temporarily blocking, waiting for conflicting access to
complete.
 
> Is it known issue or any fix available?
 
Don't modify the structure of the table at the same time as
conflicting access against the table, or wait for the transactions
performing the conflicting access to commit?
 
You haven't described the other activity on the table or shown the
other lock(s) involved in the blocking.  Without more information,
it's hard to be more specific.
 
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
 
-Kevin

FAQ