| Lists: | pgsql-bugs |
|---|
| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | sennirban89(at)gmail(dot)com |
| Subject: | BUG #15253: DROP/select/update query waiting for pg_dump |
| Date: | 2018-06-27 14:01:09 |
| Message-ID: | 153010806978.20041.7029041583313809991@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15253
Logged by: NIRBAN SEN
Email address: sennirban89(at)gmail(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: rhel7
Description:
DROP/select/update queries are going into waiting state when pg_dump is
running.
I'm using 9.2.18 version.
| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | sennirban89(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #15253: DROP/select/update query waiting for pg_dump |
| Date: | 2018-06-27 15:01:34 |
| Message-ID: | 20180627150134.lphsddetwachkrkj@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Hi,
On 2018-06-27 14:01:09 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15253
> Logged by: NIRBAN SEN
> Email address: sennirban89(at)gmail(dot)com
> PostgreSQL version: Unsupported/Unknown
> Operating system: rhel7
> Description:
>
> DROP/select/update queries are going into waiting state when pg_dump is
> running.
DROP TABLE, and many other kinds of DDL, are indeed going to be blocked
by a concurrent pg_dump. That's expected and not a bug. SELECT / UPDATE
on their own won't.
Please note that the form you used is for reporting a bug, but I do not
see one in your report?
Greetings,
Andres Freund
| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | sennirban89(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #15253: DROP/select/update query waiting for pg_dump |
| Date: | 2018-06-27 15:02:50 |
| Message-ID: | CAMkU=1yQfwuTdGMBYhBWrVAdonN9Dg-TuRfD6Mh4KHbp3BCj3A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Wed, Jun 27, 2018 at 10:01 AM, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15253
> Logged by: NIRBAN SEN
> Email address: sennirban89(at)gmail(dot)com
> PostgreSQL version: Unsupported/Unknown
> Operating system: rhel7
> Description:
>
> DROP/select/update queries are going into waiting state when pg_dump is
> running.
>
> I'm using 9.2.18 version.
>
>
That's not a bug. Selects and Updates alone should not block on a pg_dump,
but in conjunction with DROP they certainly can. You can't DROP a table
while it is being dumped, and you can't select from a table while it is
waiting to be dropped.
Cheers,
Jeff