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