Re: reindex from pgadmin issue

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