| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: reindex from pgadmin issue |
| Date: | 2024-07-08 11:17:53 |
| Message-ID: | 52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wasim Devale | 2024-07-08 12:48:15 | Re: reindex from pgadmin issue |
| Previous Message | Sathish Reddy | 2024-07-08 09:43:15 | Detach partition concurrently from pg cron |