View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000563 | Pgpool-II | Bug | public | 2019-12-06 07:20 | 2020-01-16 09:46 |
| Reporter | eduarte | Assigned To | |||
| Priority | urgent | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | Tomcat | OS | Centos 7 | OS Version | 7 |
| Product Version | 4.0.7 | ||||
| Summary | 0000563: PGPool genera error y cierra la conexión cuando hay error en el master | ||||
| Description | Se tiene configurado el pgpool-II sólo para balanceo de carga y cuando hay un error de insert en el backend0, tambien se genera un error en la replica (backend1) y se cierra la conexion. Estamos trabajando con tomcat9, postgresql-10 y postgresql-42.2.5.jar en el tomcat. Este es el error en el master ----------------------------------------- < 2019-12-05 17:12:28 -05 192.168.179.7 sucursal aplivirtual > ERROR: llave duplicada viola restricción de unicidad «userrepository_pkey» < 2019-12-05 17:12:28 -05 192.168.179.7 sucursal aplivirtual > DETALLE: Ya existe la llave (userguid, repid)=(ec002f47-989c-43bd-8c77-546a2a615b94 , 2). < 2019-12-05 17:12:28 -05 192.168.179.7 sucursal aplivirtual > SENTENCIA: INSERT INTO gam.UserRepository(UserRepRecPwdAns, UserRepCreDate, UserRepCreUser, UserRepUpdDate, UserRepUpdUser, UserGUID, RepId, UserRepMainRoleId, UserRepSecPolId, UserRepQstUserId) VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) y este es el error en el standby --------------------------------------------- < 2019-12-05 17:12:03 COT 192.168.179.7 sucursal aplivirtual > ERROR: no hay un savepoint con ese nombre < 2019-12-05 17:12:03 COT 192.168.179.7 sucursal aplivirtual > SENTENCIA: ROLLBACK TO SAVEPOINT gxupdate Error en tomcat ----------------------------- org.postgresql.util.PSQLException: FATAL: failed to read kind from backend Detail: kind mismatch among backends. Possible last query was: "ROLLBACK TO SAVEPOINT gxupdate" kind details are: 0[C] 1[E: no hay un savepoint con ese nombre] Hint: check data consistency among db nodes La replicación se hace nativa en postgresql y los nodos están correctamente sincronizados (en línea) Adjunto logs de tomcat y archivo pgpool.conf | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Please do not post issues written in other than English. |
|
|
Sorry, I didn't know, I gonna open another thread Thanks |
|
|
Could you close this issue? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-12-06 07:20 | eduarte | New Issue | |
| 2019-12-06 07:20 | eduarte | File Added: localhost_access_log.2019-12-05.txt | |
| 2019-12-06 07:20 | eduarte | File Added: catalina.2019-12-05.log | |
| 2019-12-06 07:20 | eduarte | File Added: pgpool.conf | |
| 2019-12-06 07:47 | t-ishii | Note Added: 0003005 | |
| 2019-12-06 21:47 | eduarte | Note Added: 0003010 | |
| 2019-12-06 22:02 | eduarte | Issue cloned: 0000564 | |
| 2019-12-09 15:49 | pengbo | Note Added: 0003014 | |
| 2020-01-16 09:46 | pengbo | Status | new => closed |
| 2020-01-16 09:46 | pengbo | Description Updated |
