reindex from pgadmin issue

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: reindex from pgadmin issue
Date: 2024-07-04 19:49:31
Message-ID: CAB5fag610bnU5PcV+k1ktq+1UesXYYkoQmchxjTkPLcjBMCPQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Attachment Content-Type Size
IMG_20240705_001658156~3.jpg image/jpeg 882.8 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kashif Zeeshan 2024-07-05 04:16:02 Re: Roll forward the replica instance
Previous Message nikhil kumar 2024-07-04 18:08:56 Re: Roll forward the replica instance