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.