From: Pepe TD Vo <pepevo@yahoo.com>
To: Alvaro Aguayo <aaguayo@opensysperu.com>
To: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: database lagging
Date: Fri, 23 Jul 2021 18:58:21 +0000 (UTC)
Message-ID: <940238887.612531.1627066701703@mail.yahoo.com> (raw)
In-Reply-To: <CAM+6J947jMMhHBbRYgx85ni8EdfXxS95C5WaQKFQ7N3Yd-X=NA@mail.gmail.com>
References: <1396983439.574027.1627062741652.ref@mail.yahoo.com>
<1396983439.574027.1627062741652@mail.yahoo.com>
<SC1P15201MB223815E976EE2CACECFC7572AFE59@SC1P15201MB2238.LAMP152.PROD.OUTLOOK.COM>
<CAM+6J973p_7jNodoxjNw-v3O6RpYzQ_UtioKbimhpyEx5ion_A@mail.gmail.com>
<CAM+6J947jMMhHBbRYgx85ni8EdfXxS95C5WaQKFQ7N3Yd-X=NA@mail.gmail.com>
I'm running rh-postgresql12 psql version 12.5OS RHEL 7I can run select query but lagging to create role, table,
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
On Friday, July 23, 2021, 02:40:39 PM EDT, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:
On Fri, 23 Jul 2021 at 23:59, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:
On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo <aaguayo@opensysperu.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 knowwhat 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 ?
also forgot to ask.does this only hang only alter role commands ?or any other command /query like \duselect 1;create table t(id int);
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, aaguayo@opensysperu.com, vijaykumarjain.github@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: database lagging
In-Reply-To: <940238887.612531.1627066701703@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox