Re: CannotAcquireResourceException in Junit

[Rob Sargent]

> On Jan 24, 2018, at 9:32 PM, Abhra Kar  wrote:
> 
> Thanks Rob.
> 
> OS -- RHEL 6.7(Santiago)
> Postgres Version -- 9.5
> Location --/usr/pgsql-9.5/bin/psql
> 
> Can you please guide me , how to stop all those connection manually(From psql 
> prompt or linux shell or any .sh file with in postgres directory)
> 
> Regards,
> Abhra
> 
> On Thu, Jan 25, 2018 at 9:36 AM, Rob Sargent  wrote:
> 
> > On Jan 24, 2018, at 9:57 AM, Abhra Kar  wrote:
> >
> >
> > Hi,
> >  I am getting the following error while running bunch of Junit test 
> > cases through “ant test” command
> >  Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A 
> > ResourcePool could not acquire a resource from its primary factory or 
> > source.
> > PFA full stack trace.
> >
> > After execution of 300 test cases I got this error. The setup() method code 
> > snippet is ---
> >
> > @Before
> > public void setUp() throws Exception {
> > entityManager = 
> > entityManagerFactory.createEntityManager();//javax.persistence.EntityManager
> > entityManager.getTransaction().begin();
> > }
> >
> > this method ran for all 300 test cases but didn’t get error .
> >
> > Another 900 test cases are remaining. I tried running single test cases 
> > from those test cases, getting same error for all.
> > What is root cause of this error.
> >
> > Thanks and Regards,
> > Abhra
> > 
> Apparently Merlin is busy elsewhere.  You need to name the OS, the postgres 
> version, and the stack you’re using.
> 
> But my guess is you’re not closing those connections and have hit a 
> configuration limit for maximum connection.
> 
> 
> 
Please don’t top post in the forum.

Something like this from 
https://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it

 You might want a bunch of 
select pg_terminate_backend();


WARNING: this kills all connections. 
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM
 pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB'
AND pid <> pg_backend_pid();

Re: CannotAcquireResourceException in Junit

[Abhra Kar]

Thanks Rob.


OS -- RHEL 6.7(Santiago)

Postgres Version -- 9.5

Location --*/usr/pgsql-9.5/bin/psql*


Can you please guide me , how to stop all those connection manually(From
psql prompt or linux shell or any .sh file with in postgres directory)


Regards,

Abhra

On Thu, Jan 25, 2018 at 9:36 AM, Rob Sargent  wrote:

>
> > On Jan 24, 2018, at 9:57 AM, Abhra Kar  wrote:
> >
> >
> > Hi,
> >  I am getting the following error while running bunch of Junit
> test cases through “ant test” command
> >  Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
> A ResourcePool could not acquire a resource from its primary factory or
> source.
> > PFA full stack trace.
> >
> > After execution of 300 test cases I got this error. The setup() method
> code snippet is ---
> >
> > @Before
> > public void setUp() throws Exception {
> > entityManager = entityManagerFactory.
> createEntityManager();//javax.persistence.EntityManager
> > entityManager.getTransaction().begin();
> > }
> >
> > this method ran for all 300 test cases but didn’t get error .
> >
> > Another 900 test cases are remaining. I tried running single test cases
> from those test cases, getting same error for all.
> > What is root cause of this error.
> >
> > Thanks and Regards,
> > Abhra
> > 
> Apparently Merlin is busy elsewhere.  You need to name the OS, the
> postgres version, and the stack you’re using.
>
> But my guess is you’re not closing those connections and have hit a
> configuration limit for maximum connection.
>
>
>

Re: CannotAcquireResourceException in Junit

[Rob Sargent]

> On Jan 24, 2018, at 9:57 AM, Abhra Kar  wrote:
> 
>  
> Hi,
>  I am getting the following error while running bunch of Junit test 
> cases through “ant test” command
>  Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A 
> ResourcePool could not acquire a resource from its primary factory or source. 
> PFA full stack trace.
>  
> After execution of 300 test cases I got this error. The setup() method code 
> snippet is ---
> 
> @Before
> public void setUp() throws Exception { 
> entityManager = 
> entityManagerFactory.createEntityManager();//javax.persistence.EntityManager
> entityManager.getTransaction().begin();
> }
> 
> this method ran for all 300 test cases but didn’t get error .
>  
> Another 900 test cases are remaining. I tried running single test cases from 
> those test cases, getting same error for all.
> What is root cause of this error.
> 
> Thanks and Regards,
> Abhra
> 
Apparently Merlin is busy elsewhere.  You need to name the OS, the postgres 
version, and the stack you’re using.

But my guess is you’re not closing those connections and have hit a 
configuration limit for maximum connection.