agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: reindex from pgadmin issue
Date: Mon, 8 Jul 2024 13:17:53 +0200
Message-ID: <52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com> (raw)
In-Reply-To: <CAB5fag610bnU5PcV+k1ktq+1UesXYYkoQmchxjTkPLcjBMCPQw@mail.gmail.com>
References: <CAB5fag610bnU5PcV+k1ktq+1UesXYYkoQmchxjTkPLcjBMCPQw@mail.gmail.com>
Am 04.07.24 um 21:49 schrieb Wasim Devale:
> Hi can anyone let me know what this issue is the screenshot is
> attached this had come when I was doing reindexing from pgadmin.
> Also the java web application has experienced "thread pool exhausted"
> issue and application went down for 10 minutes.
>
> The major cause is that reindexing was not happening properly as I can
> not see the verbose messages of happening reindexing on tables in the
> screenshot.
>
> Reindexing has caused endless lock on tables unless I terminated it
> via kill -9 command on Linux.
>
> Thanks,
> Wasim
Hi Wasim,
In order to rule out other causes it's always a good idea to issue
commands via psql and not some other software. Especially GUI tools
might hide some important information or add confusing messages.
Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach
view thread (3+ messages) latest in thread
Message-ID: <52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com>
Permalink: ../52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com/
Also on: postgresql.org/message-id/52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com
reply
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: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: reindex from pgadmin issue
In-Reply-To: <52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox