Re: CannotAcquireResourceException in Junit

Поиск
Список
Период
Сортировка
От Abhra Kar
Тема Re: CannotAcquireResourceException in Junit
Дата
Msg-id CAFNULEfLtBV+A8qOzuXWcEWdLih6LLFd1FbWCcCGAKfCqSkOiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CannotAcquireResourceException in Junit  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: CannotAcquireResourceException in Junit  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general

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 <robjsargent@gmail.com> wrote:

> On Jan 24, 2018, at 9:57 AM, Abhra Kar <abhra.kar@gmail.com> 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
> <StackTrace.doc>
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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: CannotAcquireResourceException in Junit
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: CannotAcquireResourceException in Junit