Message-ID: <52093c45-0200-43ea-b5d2-9fab4de360c8@jakobs.com>
Date: Mon, 8 Jul 2024 13:17:53 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: reindex from pgadmin issue
To: pgsql-admin@lists.postgresql.org
References: 
 <CAB5fag610bnU5PcV+k1ktq+1UesXYYkoQmchxjTkPLcjBMCPQw@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAB5fag610bnU5PcV+k1ktq+1UesXYYkoQmchxjTkPLcjBMCPQw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/52093c45-0200-43ea-b5d2-9fab4de360c8%40jakobs.com>
Precedence: bulk


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