Re: database lagging

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 ?

>
>
> Regards,
>
>
>
> *Alvaro Aguayo*
>
> Operations Manager
>
> Open Comb Systems E.I.R.L.
>
>
>
> *From:* Pepe TD Vo <pepevo(at)yahoo(dot)com>
> *Sent:* 23 July 2021 12:52
> *To:* pgsql-admin(at)lists(dot)postgresql(dot)org
> *Subject:* database lagging
>
>
>
> I am doing CIS Benchmart on Postgreql 12. After alter parameters and when
> I tried to create a new role. It's lagging and didn't prompt out the
> result, until I hit the ctl C key. Even alter role. All I needed to hit
> ctl C key if not, it hung there for ever. Is there a way to fix it?
>
>
>
> postgres=# create role appuser;
>
> ^CCancel request sent
>
> CREATE ROLE
>
>
>
> postgres=# ALTER ROLE appuser NOSUPERUSER;
>
> ^CCancel request sent
>
> ALTER ROLE
>
>
>
>
>
> postgres=# ALTER ROLE appuser NOREPLICATION;
>
> ^CCancel request sent
>
> ALTER ROLE
>
>
>
> postgres=# ALTER ROLE appuser NOCREATEROLE;
>
> ^CCancel request sent
>
> ALTER ROLE
>
>
>
> postgres=# ALTER ROLE appuser NOHERIT;
>
> ^CCancel request sent
>
> ALTER ROLE
>
>
>
>
>
>
>

--
Thanks,
Vijay
Mumbai, India