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