Re: database lagging

[Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx>]

On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo <aaguayo@xxxxxxxxxxxxxxx> 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

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@xxxxxxxxx>
Sent: 23 July 2021 12:52
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
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