From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
---|---|
To: | Alvaro Aguayo <aaguayo(at)opensysperu(dot)com> |
Cc: | Pepe TD Vo <pepevo(at)yahoo(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: database lagging |
Date: | 2021-07-23 18:40:07 |
Message-ID: | CAM+6J947jMMhHBbRYgx85ni8EdfXxS95C5WaQKFQ7N3Yd-X=NA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, 23 Jul 2021 at 23:59, Vijaykumar Jain <
vijaykumarjain(dot)github(at)gmail(dot)com> wrote:
>
> On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo <aaguayo(at)opensysperu(dot)com>
> wrote:
>
>> Is there any other thing running with that database? If so, I would
>> consider a locking problem. CREATE/ALTER ROLE should never take too much
>> time, unless there is some kind of lock in a global catalog.
>>
>>
> I am not so sure this is lock issue? Ctrl C would not complete the command
> if it were a lock issue?
> Pepe can confirm if he sees any locks though ?
>
> Hey Pepe,
> Can you let us know
> what postgres version?
> what psql version?
> what OS?
>
> also, is it possible for you to collect stack trace of the hanging process?
> Getting a stack trace of a running PostgreSQL backend on Linux/BSD -
> PostgreSQL wiki
> <https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Collecting_a_stack_trace>
>
> also is it only hanging in interactive mode?
> psql -c 'alter role foobar superuser;'
> does this complete fine ?
>
>
also forgot to ask.
does this only hang only alter role commands ?
or any other command /query like
\du
select 1;
create table t(id int);
From | Date | Subject | |
---|---|---|---|
Next Message | Pepe TD Vo | 2021-07-23 18:58:21 | Re: database lagging |
Previous Message | Vijaykumar Jain | 2021-07-23 18:29:29 | Re: database lagging |