agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedreindex from pgadmin issue
3+ messages / 2 participants
[nested] [flat]
* reindex from pgadmin issue
@ 2024-07-04 19:49 Wasim Devale <wasimd60@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Wasim Devale @ 2024-07-04 19:49 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>; 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
Attachments:
[image/jpeg] IMG_20240705_001658156~3.jpg (882.8K, ../../CAB5fag610bnU5PcV+k1ktq+1UesXYYkoQmchxjTkPLcjBMCPQw@mail.gmail.com/3-IMG_20240705_001658156~3.jpg)
download | view image
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: reindex from pgadmin issue
@ 2024-07-08 11:17 Holger Jakobs <holger@jakobs.com>
parent: Wasim Devale <wasimd60@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Holger Jakobs @ 2024-07-08 11:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: reindex from pgadmin issue
@ 2024-07-08 12:48 Wasim Devale <wasimd60@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 3+ messages in thread
From: Wasim Devale @ 2024-07-08 12:48 UTC (permalink / raw)
To: holger@jakobs.com; +Cc: pgsql-admin@lists.postgresql.org
Sure, Thanks
On Mon, 8 Jul, 2024, 4:48 pm Holger Jakobs, <holger@jakobs.com> wrote:
>
> 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
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-07-08 12:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-04 19:49 reindex from pgadmin issue Wasim Devale <wasimd60@gmail.com>
2024-07-08 11:17 ` Holger Jakobs <holger@jakobs.com>
2024-07-08 12:48 ` Wasim Devale <wasimd60@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox