Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70OS-00087T-NA for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 18:59:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m70OR-0001LK-8H for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 18:59:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70OQ-0001E6-Qs for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 18:59:30 +0000 Received: from sonic317-32.consmr.mail.ne1.yahoo.com ([66.163.184.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m70OI-0004gi-6C for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 18:59:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627066761; bh=TwKFArF8iADSM46+HjyyypNJYplj+TJ+77ci358k3BM=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=N//pXIODFP9a5k38oqATyHzkb9CLt17nOYMy8/LZNGCklKk1I8N8Ssx0HGH1Jn530P2+yxJmxhwtMcomQuHsbKaIAYkk7unBdG/8rEWKsjXQSeIWM2sjlBz2eW4xK5Ne/ofisDyC9Dl+pNkdFjNv2bNKRsfbpYJm2D/Qkl6nhpHL2R9u+9yaLBNVX5s41ugcd77vvl0LVeImQveVkGJYS5XPM5eE7dO6pxqYPOTEfXsewiTNAA0vLqulr6Wdax3gPOrfdWrhUQ3ogcQ5a38CTKl/LZS5FnKyI1pRlnc0LbYzed9VynCaf0vQDB/tVCls7DMmVIGO5pEUAa/Mthhnkg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627066761; bh=U0pP+D9fPSi2RmR6aeHp+GSxc1/86gQ+Gie38TvqXKt=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=WnSymFhTJmKiRjPfTzTxt8dC7Y63tRDILmrgORIMPj0CJIBiH5UXnJctIMfCw/mbK95Nasmhae22W2stQmvdS3e3tPktAtZtCuoczEmZM6CZpsqc47uBNZuu0HNWC/+9fuQwgS7pywe8C5UiaenlDF+vZaQ2PQVI2i38oMkyirvlrB/ne3ko4RhclYHrcO31O2PPL1OixHDbjLRVI8Mp77J5llNe4QvXZDqPxt2eIapWVenGJJXHkG4vEAflmGubbBCEekh08ioC7OYmSIDds6yvC5DxXJLtx7HIW+VS0nIxLdfw4N1MOc/BJ5tzMIcYmJ+9PTrVjsHRwa98VPPADw== X-YMail-OSG: xfIckKcVM1mN3NB20hkXDiZJcj4RdauwhRTGRBo4LZ2QEg9eMUQwn1z6vBHyiKo WJLQB_7iXmPmB9ybo6KGvwRTgP5SngaFiJgN34._po5B9icCxi8YKlPQlzoZ_FmdibHVzMDeq3SA N8bKH5XqBngJW8ZEFXjw3PDQImofA5eT2.hJRAHCaQR.MjYu6xv1XcEbWUq09VRG8m8ay1C6S_h. 4YFy6AQzKNLKpVp1Xx..04_u27z8vhVTPS6yZZeotAmnl_oy7mvhGWQYbFIVP9vfDSZXVyg1egPI EC4whVAvvqKrmUkzwcmTXwUfPuiyZ5VE5bmZ2QqDdrAuJlHI.wpA1jUq5zKIEzz.gztPNj4TbPUg wqnu8zV62CGH1eXOYXf9.hfrwtOnWoZJkA0HhDyerqn9W2j7FxVZ513KJmK3GcbnAahW4.Dyt.ks DmFpJ82H8f68q3wFxCHjUOa1d9F0O.gY71E_ED5HyrLh4u_F8qxHDL2MUrNuhMGMhH6vMs86L_6o ZWAQdKix_q5EEsxbCem7GjRFkdFtiXhl7mSYfhbXSiY5WFhJ.K_FmUF5rAp6R_NcCEG1NM9b9Pji ND3CgFdFjjUHF0X01o7k_Wao7o3C4jMfPG3kosyiDd9YxKfNBtxPcCE56_7jrI37hHw3E866k760 jApyQd6HigYo24b9l84rg2pRJ4qCfsFYkkPqbpG7eLQTSb_bnljjUQcs6WV..PA4JIEC0kgS_fr. 0RLz5lIII_deC9ITgdcSKhBWpeY.jSbMpGtMCpDxq7qSPwDksOcqoZgJxOaVFW_JtEU6Vt3Vskup kE7fhQtz9WZGfkFhPLRKAP0P_nTo0kL89rgYHwpJnOHKrWlhbaDdZh2xjFpl5q3.GyRe_t8PwTZo DCjiTa3UwkFKniQ_8JAAznOk.q_a.abYdLvIo5dE0HkB.VdMcF9Xt8ZgY4WIND7Q5O9WEkWwTum9 a1eOUSWN48pdMhRT2IIBounStnooR8rIxuOvFTM3QOwGw3S.wmANQQNMF.RzZeyCZ3X2GR1_nm32 ib214Khn7yMPgH.WRGFzLo.RaTsj3ods8_qu6UPB4l.pIgWAjq2MdrSYCv3Jw.g7qleAXpaoNidl 7yiwEkZvMd835QJ_LixFLCeFA72uByvrLQWkGI604cWfgzzdKpv0R6LTrravUK54_j2h03vLQVwY xlbgT0WMQosgWQYDV.P4vSldrvmYBpolJmYixOpIrJynqkK6OZCOxj3dIFI21UsThqBh8QwqBG8O BfqLHxx4NruU9MKtYZ6NZPIhlrvO10K84m6EqYBfVMhr8ZPOjrPPRN1OGVNC2Ghze1M0dh9XHwdI C33ycU74ub.JHrHIkvm89u6HnbFH9dv77wRCc.I7MyjmZoFcnOod.WVb4xcnuXDj6ocKjHDI4_uv qghItUF1xMlyQ_8VgNRABo2mnEII14VsncQ67XdDpiZPGOkE8cdm8Gp6mkdAFRM2vv.USPkTy14w 5pXfBK8vA72lStprItDygrrqrupZUeirwapWunRnl8EabGFzJqsHGXMu5U2d73Y3DzzIt.kEX6mo 2z_0EQtXvyoax4pC_gkAFWEb6Z6lKspMLEGahuCPVrDjo9FeE3LGmOS3_bMCedpixCWL2e3ES3lP 9LdGtp57VvkfWBvt5kTE.PzdwCJenr3pgRVPlw6FJ0_Zf8nebKHpf4f6qFJkSZFH2Lhs5l4vUlf1 OUNUlJ4TPAheQwOkHVTi3kvc83mLTzeliTL980yIeoizWdiVF0FjSYt0k7h0E9iZjqT_b6PGEXY0 qhrsV_yz_s7VzK_2NEVEujw12AAZVIOoIxduCZwAu685_4q_4DhS6Lf7tg_LGVzQkFJDNLHQhoh7 gJlGSnVhpALgBYdMU3hn.fKYOao3XAx8dzLb63VlAPv0O_E6Ji2p0yT18RUOLs8Zpn2r6uhcPG5x Z_w3D4UT2l0sCvkk28aiwb0ppIXxKNYXT8VxcZ_9JDjNpmUpEQO93FGzBJGVP6TmHP1g7rQONCgs iM9szABh8SNogoUyzO9AmztwYqwNg2PgslolkxejGVlIebPYSF04ZgSeV2b0b3uOixEppxj9h2Fi ddeUvZBzxFf4FrTNnC1yb7AJaitNjV_IxC9oCE.RbKCtACahNjTURQ647wuGj0VUP6QTrn7Lu3Z_ cauCpspZ_1wfVmkXjBYh3ZL_zYcBvnVh5bPEjSf_TeOn6lfPNKcTIO_wZ8GQD2RlDG_Z.nPPS8pS xFqjjOatukDsrBQq7IAI1xGr.o6Z_YoT9ThMxfMe4yxIbjFgPMuBO9f42.BWbqe3onSA5JF5050u joXFT0eblPBja.XpJq2PTj.jX9iTp4M0rFZ9Hh8fhz.wbyHXjwIEGGMDSiop5JxL69FzgoXSGRz6 J06rpz16LWO01YinVDFY6ZecCa6OtL_l7Q_xLSDboniKzlnnuJYVKuL0Ni3Eyj1WW6Hn0KvQeCWF Ja2WnMfM2y_2XfvAzdkzDVYZpZQMFOEah1TzrNgcsHwQcpU_eTNx0Y6feRL03UKFgUADilMM9HY9 w487HMxoiJPvJ64Z.c2M.hUa26CzdmcwJ1BtjUiEXX7kfZHQgz4x2k9DiiVyUVWi.rk5V7FcIGA7 AsfHZH8OSwZCJIO4Xa4Bz4P_rwLZc5LkoigLHUMRa X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Fri, 23 Jul 2021 18:59:21 +0000 Date: Fri, 23 Jul 2021 18:58:21 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Alvaro Aguayo , Vijaykumar Jain Cc: "pgsql-admin@lists.postgresql.org" Message-ID: <940238887.612531.1627066701703@mail.yahoo.com> In-Reply-To: References: <1396983439.574027.1627062741652.ref@mail.yahoo.com> <1396983439.574027.1627062741652@mail.yahoo.com> Subject: Re: database lagging MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_612530_105717765.1627066701701" X-Mailer: WebService/1.1.18736 YMailNorrin Content-Length: 10302 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_612530_105717765.1627066701701 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I'm running rh-postgresql12=C2=A0psql 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.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l 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 =20 On Friday, July 23, 2021, 02:40:39 PM EDT, Vijaykumar Jain wrote: =20 =20 =20 On Fri, 23 Jul 2021 at 23:59, Vijaykumar Jain wrote: On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo wrote= : Is there any other thing running with that database? If so, I would conside= r a locking problem. CREATE/ALTER ROLE should never take too much time, unl= ess 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 - Postgr= eSQL wiki also is it only hanging in interactive mode?=C2=A0psql -c 'alter role fooba= r superuser;'=C2=A0 =C2=A0does this complete fine ? also forgot to ask.does this only hang only alter role commands ?or any oth= er command /query like=C2=A0\duselect 1;create table t(id int); =20 ------=_Part_612530_105717765.1627066701701 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I'm running rh-postgresql12 =
psql version 12.5
OS RHEL 7
I can run select query but lagging to create role, table,
<= div>
Bach-Nga

No one in this world is pure and perfect.  If you avoid peopl= e for their mistakes you will be alone. So judge less, love, and forgive mo= re.3D"Emoji"3D"Emoj=3D"Emoji"
To call him a dog hardly seems to do him justice though in as mu= ch 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 (He= rmione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.<= /div>
*** Genuinely rich *** Faithful talent *** Sharing= success




=20
=20
On Friday, July 23, 2021, 02:40:39 PM EDT, Vijaykumar J= ain <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 <aaguay= o@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 know
what pos= tgres version?
what psql version?
what OS?
also, is it possible for you to collect stack t= race of the hanging process?

<= /div>
also is it only hanging in interactive mode? 
psql= -c 'alter role foobar superuser;'   
does this complet= e 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);


------=_Part_612530_105717765.1627066701701--