Re: reindex from pgadmin issue

Sure, Thanks

On Mon, 8 Jul, 2024, 4:48 pm Holger Jakobs, <holger(at)jakobs(dot)com> wrote:

>
> 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
>
>
>
>