If the problem occurs gradually (like leaking 20 connections per hour during
ETL), you can check pg_stat_activity every hour or so to try to observe the
problem before all the connection slots are used up, to collect diagnostic
information.
Alternately, leave a connection opened to the DB and wait
Hi Justin,
Yes , I have checked pg_stat_activity from both the master node and the
standby node server and the total rows of the connection doesn't even
exceed 10.
Sorry the OS is Red Hat Enterprise Linux Server 7.5 (Maipo).
Does the streaming replication between the master and standby node have
On Wed, May 11, 2022 at 09:52:10AM +0800, Sudhir Guna wrote:
> Hi Justin,
>
> Thank you for reviewing.
>
> I have tried to run the below query and could see only less than 5
> connections active when I get this error. The total rows I see is only 10
> including idle and active sessions for this o
Em qua., 11 de mai. de 2022 às 04:18, Sudhir Guna
escreveu:
> Hi MichaelDBA,
>
> Thank you for reviewing.
>
> I had validated the show max_connections and its 1000.
>
I think that you are wasting resources with this configuration.
Try enabling Connection Pool at Pentaho configuration.
And set the
Hi Ranier,
We have tried to upgrade the postgresql- 42.3.5 .jarand unfortunately the
issue still persists.
Regards,
Guna
On Wed, May 11, 2022 at 9:44 AM Sudhir Guna
wrote:
> Hi Ranier,
>
> Thank you for reviewing this.
>
> Yes this is Pentaho and SSRS application.
>
> We are currently using po
Hi Justin,
Thank you for reviewing.
I have tried to run the below query and could see only less than 5
connections active when I get this error. The total rows I see is only 10
including idle and active sessions for this output.
select pid as process_id,
usename as username,
datname as database_
Hi MichaelDBA,
Thank you for reviewing.
I had validated the show max_connections and its 1000.
[image: image.png]
Regards,
Guna
On Wed, May 11, 2022 at 2:13 AM MichaelDBA Vitale
wrote:
> Please show output of "show max_connections" to validate your assumptions.
>
> On 05/10/2022 12:59 PM Su
Hi Ranier,
Thank you for reviewing this.
Yes this is Pentaho and SSRS application.
We are currently using postgresql-42.2.4.jar currently.
Regards,
Guna
On Wed, May 11, 2022 at 2:55 AM Ranier Vilela wrote:
>
>
> Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna <
> sudhir.guna...@gmail.com>
Dear team,
Can you confirm whether, post upgrade activity, all the post-upgrade steps
including stats update on all the relations is complete. Upgrade doesn’t carry
over the stats to the new upgraded cluster.
Regards,
Anbazhagan M
> On 11-May-2022, at 11:43 AM, Laurenz Albe wrote:
>
> On Wed
On Wed, 2022-05-11 at 00:59 +0800, Sudhir Guna wrote:
> We have recently upgraded Postgresql 9.4 standalone server to Postgresql 11.2
> with High Availability (2 servers : Master and Standby).
>
> While trying to test using ETL applications and reports, we observe that the
> ETL jobs fails with
Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna
escreveu:
> Dear All,
>
> We have recently upgraded Postgresql 9.4 standalone server to Postgresql
> 11.2 with High Availability (2 servers : Master and Standby).
>
> While trying to test using ETL applications and reports, we observe that
> the E
On Wed, May 11, 2022 at 12:59:01AM +0800, Sudhir Guna wrote:
> Dear All,
>
> We have recently upgraded Postgresql 9.4 standalone server to Postgresql
> 11.2 with High Availability (2 servers : Master and Standby).
>
> While trying to test using ETL applications and reports, we observe that
> the
Please show output of "show max_connections" to validate your assumptions.
On 05/10/2022 12:59 PM Sudhir Guna wrote:
Dear All,
We have recently upgraded Postgresql 9.4 standalone server to Postgres
Dear All,
We have recently upgraded Postgresql 9.4 standalone server to Postgresql
11.2 with High Availability (2 servers : Master and Standby).
While trying to test using ETL applications and reports, we observe that
the ETL jobs fails with below error,
2022/05/06 16:27:36 - Error occurred whi
14 matches
Mail list logo
