vacuum deadlock
От | Ibrahim Harrani |
---|---|
Тема | vacuum deadlock |
Дата | |
Msg-id | 530068a1002050143n26ee05c6hda0de69f5ed97a9d@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: vacuum deadlock
Re: vacuum deadlock |
Список | pgsql-admin |
Hi,
I am using PostgreSQL 8.3.7.
autovacuum is enabled in postgresql.conf
I got a deadlock while vacuuming all databases with vacuumdb command.
vacuumdb: vacuuming of database "mydb" failed: ERROR: deadlock detected
DETAIL: Process 1294 waits for AccessExclusiveLock on relation 2662 of database ; blocked by process 1807.
Process 1807 waits for AccessShareLock on relation 1259 of database 16389; blocked by process 1294.
I think, because of this lock, deleting a large table (15 million records) was taking too much time
How can I know the name of the relations 2662 and 1259?
Do you have any ide about the problem and solution?
Thanks in advance.
I am using PostgreSQL 8.3.7.
autovacuum is enabled in postgresql.conf
I got a deadlock while vacuuming all databases with vacuumdb command.
vacuumdb: vacuuming of database "mydb" failed: ERROR: deadlock detected
DETAIL: Process 1294 waits for AccessExclusiveLock on relation 2662 of database ; blocked by process 1807.
Process 1807 waits for AccessShareLock on relation 1259 of database 16389; blocked by process 1294.
I think, because of this lock, deleting a large table (15 million records) was taking too much time
How can I know the name of the relations 2662 and 1259?
Do you have any ide about the problem and solution?
Thanks in advance.
В списке pgsql-admin по дате отправления: