View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000077 | Pgpool-II | General | public | 2013-10-14 23:48 | 2015-09-17 15:31 |
| Reporter | daniel.oliveira | Assigned To | t-ishii | ||
| Priority | urgent | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | Oracle Linux 64 bits | OS | 2.6.39-400.209.1.el6uek.x86_64 | OS Version | 6.4 |
| Summary | 0000077: Hibernate lost connection with pgpool without persistence | ||||
| Description | When hibernate does a search on the postgres database by using pgpool the system will always show this error menssage: ERROR [STDERR] org.hibernate.exception.GenericJDBCException: could not execute query Caused by: org.postgresql.util.PSQLException: ERROR: connection terminated due to client idle limit reached The pgpool.conf is configurated with these parameters: - num_init_children = 50 - max_pool = 4 - child_life_time = 300 - connection_life_time = 0 But the error still happenning before the 300 seconds timeout | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
"connection terminated due to client idle limit reached" is not related to child_life_time nor connection_life_time. You need to tweak client_idle_limit. See the manual for more details. |
|
|
logs.rar was attached pgpool.conf and it the parameter client_idle_limit is 300 I'm using jboss-4.2.2 |
|
|
Why don't you set client_idle_limit to 0 then? |
|
|
I can't, because I have other applications using same db, but just it I have this problem |
|
|
You could install separate pgpool for the dumb hibernate and set client_idle_limit to 0. |
|
|
No feedback over 1 year. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-10-14 23:48 | daniel.oliveira | New Issue | |
| 2013-10-14 23:48 | daniel.oliveira | File Added: logs.rar | |
| 2013-10-15 12:17 | t-ishii | Assigned To | => t-ishii |
| 2013-10-15 12:17 | t-ishii | Status | new => assigned |
| 2013-10-15 12:17 | t-ishii | Additional Information Updated | |
| 2013-10-15 12:18 | t-ishii | Note Added: 0000338 | |
| 2013-10-15 12:18 | t-ishii | Additional Information Updated | |
| 2013-10-15 12:18 | t-ishii | Status | assigned => feedback |
| 2013-10-15 21:09 | daniel.oliveira | Note Added: 0000340 | |
| 2013-10-15 21:09 | daniel.oliveira | Status | feedback => assigned |
| 2013-10-15 21:37 | daniel.oliveira | Note Edited: 0000340 | |
| 2013-10-15 21:38 | daniel.oliveira | Note Edited: 0000340 | |
| 2013-10-15 23:36 | t-ishii | Note Added: 0000341 | |
| 2013-10-15 23:37 | t-ishii | Status | assigned => feedback |
| 2013-10-15 23:46 | daniel.oliveira | Note Added: 0000342 | |
| 2013-10-15 23:46 | daniel.oliveira | Status | feedback => assigned |
| 2013-10-15 23:47 | daniel.oliveira | Note Edited: 0000342 | |
| 2013-10-16 09:26 | t-ishii | Note Added: 0000344 | |
| 2013-10-16 09:34 | t-ishii | Status | assigned => feedback |
| 2015-09-17 15:31 | t-ishii | Note Added: 0000565 | |
| 2015-09-17 15:31 | t-ishii | Status | feedback => closed |
