View Issue Details

IDProjectCategoryView StatusLast Update
0000564Pgpool-IIBugpublic2020-01-20 22:10
ReportereduarteAssigned Topengbo 
PriorityurgentSeveritycrashReproducibilityalways
Status assignedResolutionopen 
PlatformTomcatOSCentos 7OS Version7
Product Version4.0.7 
Target VersionFixed in Version 
Summary0000564: PGPool generates error and close the conection where there is an error in the master
DescriptionI have pgpool-II configured only for load balancing and when there is an error in an insert in the backend0 (master) also it generates an error in the replication node (backend1) and then pgpool closes the conection. We are working with Tomcat 9, PostgreSQL 10 and in the tomcat we use the postgresql-42.2.5.jar as a driver.

THIS IS THE LOG IN THE 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)

THIS IS THE LOG IN 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

THIS IS PART OF CATALINA.OUT IN 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

We are using the PostgreSQL native replication, and the nodes are uptime correctly

Tagserror, master slave, pgpool in load balancing mode

Activities

eduarte

2019-12-06 22:02

reporter  

catalina.2019-12-05.log (17,108 bytes)
pgpool.conf (40,652 bytes)
localhost_access_log.2019-12-05.txt (24,700 bytes)
[05/Dec/2019:17:06:56 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/servlet/coop.crediservir.sucursalvirtual.web.wplogin HTTP/1.1 3851 200 2211 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/bootstrap/css/bootstrap.min.css?2019112816502638 HTTP/1.1 121457 200 46 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/bootstrap/js/bootstrap.min.js?2019112816502638 HTTP/1.1 39680 200 13 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/jquery.js?132732 HTTP/1.1 92629 200 20 https-jsse-nio-443-exec-3 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gpxReCAPTCHA/gpxreCAPTCHARender.js HTTP/1.1 628 200 11 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gxcfg.js?2019112816423955 HTTP/1.1 987 200 9 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Carmine.css?2019112816502638 HTTP/1.1 431031 200 48 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/LogoSV.png HTTP/1.1 - 304 13 https-jsse-nio-443-exec-1 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/ChatIconWeb.png HTTP/1.1 - 304 14 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gxgral.js?132732 HTTP/1.1 603293 200 53 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/messages.spa.js?2019112816502638 HTTP/1.1 54625 200 6 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/sucursalvirtual/web/wplogin.js?2019112816424657 HTTP/1.1 10572 200 6 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/PlayStore.png HTTP/1.1 - 304 3 https-jsse-nio-443-exec-3 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Vigilado.png HTTP/1.1 - 304 3 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/MockupApp.png HTTP/1.1 - 304 3 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/sucursalvirtual/web/mplogin.js?2019112816423361 HTTP/1.1 2667 200 4 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/FondoLogin.jpg HTTP/1.1 232274 200 13 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Regular.ttf HTTP/1.1 170984 200 13 https-jsse-nio-443-exec-1 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Medium.ttf HTTP/1.1 171320 200 14 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:06:58 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Light.ttf HTTP/1.1 169680 200 16 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:07:19 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Rolling.gif HTTP/1.1 68475 200 6 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:07:28 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 POST POST /sucursalvirtual/servlet/coop.crediservir.sucursalvirtual.web.wplogin?98f75e79f46a729cc1c33767d3bc30b1,gx-no-cache=1575583639686 HTTP/1.1 781 200 8434 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:07:56 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 POST POST /sucursalvirtual/servlet/coop.crediservir.sucursalvirtual.web.wplogin?98f75e79f46a729cc1c33767d3bc30b1,gx-no-cache=1575583674421 HTTP/1.1 114 200 2126 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:07:57 -0500] - RPT-HTTPClient/0.3-3I 127.0.0.1 POST POST /sif/servlet/pkgcredisoft.sucursalvirtual.awssucursalvirtual HTTP/1.1 350 200 490 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/servlet/coop.crediservir.sucursalvirtual.web.wpinicio HTTP/1.1 6813 200 1086 https-jsse-nio-443-exec-3 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/LogoSV.png HTTP/1.1 - 304 6 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Vigilado.png HTTP/1.1 - 304 5 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Carmine.css?2019112816502638 HTTP/1.1 16384 200 7 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/bootstrap/css/bootstrap.min.css?2019112816502638 HTTP/1.1 16384 200 7 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/messages.spa.js?2019112816502638 HTTP/1.1 - 304 5 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:07:57 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:07:57 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/LogoSV.png HTTP/1.1 16150 200 4 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:07:57 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:07:57 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Cerrar_Sesion.png HTTP/1.1 356 200 8 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:07:57 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_inicio_productos_web.png HTTP/1.1 152 200 9 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_aportes_web.png HTTP/1.1 384 200 6 https-jsse-nio-443-exec-1 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_ahorros_web.png HTTP/1.1 451 200 5 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_creditos_web-1x.png HTTP/1.1 307 200 6 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Carmine.css?2019112816502638 HTTP/1.1 431031 200 40 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_simulador_web.png HTTP/1.1 258 200 5 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_seguridad_web.png HTTP/1.1 256 200 5 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Icon_web_Aportes.png HTTP/1.1 937 200 4 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Vigilado.png HTTP/1.1 1762 200 3 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Icon_creditos_grisOscuro.png HTTP/1.1 682 200 6 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/icon_ahorros_web_negro.png HTTP/1.1 1089 200 8 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Icon_fianzas_grisOscuro.png HTTP/1.1 678 200 9 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/ImagenPublicidad.png HTTP/1.1 102688 200 10 https-jsse-nio-443-exec-3 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Bold.ttf HTTP/1.1 170064 200 11 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gxdec.js?132732 HTTP/1.1 19810 200 5 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Bold.ttf HTTP/1.1 - 304 1 https-jsse-nio-443-exec-1 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Medium.ttf HTTP/1.1 - 304 4 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Regular.ttf HTTP/1.1 - 304 3 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/sucursalvirtual/web/wpinicio.js?2019112816423894 HTTP/1.1 38693 200 5 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/sucursalvirtual/web/mpmain.js?2019112914591348 HTTP/1.1 7358 200 3 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Icon_block_web.png HTTP/1.1 434 200 2 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:07:57 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Roboto-Light.ttf HTTP/1.1 - 304 2 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:11:58 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/servlet/coop.crediservir.sucursalvirtual.web.wplogin HTTP/1.1 3854 200 1881 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - - 0:0:0:0:0:0:0:1 null - - 400 0 null -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/bootstrap/css/bootstrap.min.css?2019112816502638 HTTP/1.1 121457 200 49 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Spanish/Carmine.css?2019112816502638 HTTP/1.1 - 304 17 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/jquery.js?132732 HTTP/1.1 - 304 13 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gpxReCAPTCHA/gpxreCAPTCHARender.js HTTP/1.1 - 304 7 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gxcfg.js?2019112816423955 HTTP/1.1 - 304 9 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/gxgral.js?132732 HTTP/1.1 - 304 5 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/ChatIconWeb.png HTTP/1.1 - 304 8 https-jsse-nio-443-exec-1 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/bootstrap/js/bootstrap.min.js?2019112816502638 HTTP/1.1 - 304 11 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/LogoSV.png HTTP/1.1 - 304 10 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/messages.spa.js?2019112816502638 HTTP/1.1 - 304 2 https-jsse-nio-443-exec-4 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/sucursalvirtual/web/wplogin.js?2019112816424657 HTTP/1.1 - 304 6 https-jsse-nio-443-exec-9 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/sucursalvirtual/web/mplogin.js?2019112816423361 HTTP/1.1 - 304 4 https-jsse-nio-443-exec-3 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/MockupApp.png HTTP/1.1 - 304 4 https-jsse-nio-443-exec-6 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Vigilado.png HTTP/1.1 - 304 3 https-jsse-nio-443-exec-10 -
[05/Dec/2019:17:12:00 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/PlayStore.png HTTP/1.1 - 304 3 https-jsse-nio-443-exec-7 -
[05/Dec/2019:17:12:17 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/static/sucursalvirtual/Resources/Rolling.gif HTTP/1.1 68475 200 6 https-jsse-nio-443-exec-1 -
[05/Dec/2019:17:12:20 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 POST POST /sucursalvirtual/servlet/coop.crediservir.sucursalvirtual.web.wplogin?9ad2c1e99d900b9ca288743eeeb99356,gx-no-cache=1575583937659 HTTP/1.1 1463 500 2547 https-jsse-nio-443-exec-5 -
[05/Dec/2019:17:12:20 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/errorpages/style.css HTTP/1.1 2120 200 5 https-jsse-nio-443-exec-2 -
[05/Dec/2019:17:12:20 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/errorpages/sucursa-virtual.png HTTP/1.1 11814 200 5 https-jsse-nio-443-exec-8 -
[05/Dec/2019:17:12:20 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/errorpages/vigilada.png HTTP/1.1 1762 200 5 https-jsse-nio-443-exec-3 -
[05/Dec/2019:17:12:20 -0500] - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 0:0:0:0:0:0:0:1 GET GET /sucursalvirtual/errorpages/credisito.png HTTP/1.1 33596 200 6 https-jsse-nio-443-exec-4 -

eduarte

2019-12-06 23:23

reporter   ~0003011

File localhost from tomcat

localhost.2019-12-05.log (48,170 bytes)

pengbo

2019-12-09 15:28

developer   ~0003013

I want to check the query sent by client.

If it is possible, could you enable "log_client_messages" parameter, and run that query again to log the client query to pgpool.log?
-----
log_client_messages = on
-----

eduarte

2019-12-09 23:05

reporter   ~0003015

Hi pengbo, here I add the output file. We are use Genexus as development tool, then we can´t manipulate the querys that this tool generates

salida.log (128,534 bytes)

pengbo

2019-12-11 15:46

developer   ~0003018

Thank you.

I found the "kind mismatch" error in pgpool.log.

===
dic 09 08:53:58 contenedorwebapp1.crediservir.com pgpool[41460]: 2019-12-09 08:53:58: pid 41488: FATAL: failed to read kind from backend
dic 09 08:53:58 contenedorwebapp1.crediservir.com pgpool[41460]: 2019-12-09 08:53:58: pid 41488: 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]
===

Normally SAVEPOINT are sent to both primary and standby.
May I see the both PostgreSQL primary and standby log?

eduarte

2020-01-20 22:10

reporter   ~0003076

Hi pengbo, sorry but I didn't see the previous message. Here I add file with 2 messages one in master and another in standby.

This files are of december 19, in this moment I can't generate more test because we are in production with our application, and the solution was we don't use pgpool and pointing directly to the database.

Well, I could, but I have to configure this setting in a test environment, if you need it, let me know

Issue History

Date Modified Username Field Change
2019-12-06 22:02 eduarte New Issue
2019-12-06 22:02 eduarte File Added: localhost_access_log.2019-12-05.txt
2019-12-06 22:02 eduarte File Added: pgpool.conf
2019-12-06 22:02 eduarte File Added: catalina.2019-12-05.log
2019-12-06 22:02 eduarte Issue generated from: 0000563
2019-12-06 22:02 eduarte Tag Attached: error
2019-12-06 22:02 eduarte Tag Attached: master slave
2019-12-06 22:02 eduarte Tag Attached: pgpool in load balancing mode
2019-12-06 23:23 eduarte File Added: localhost.2019-12-05.log
2019-12-06 23:23 eduarte Note Added: 0003011
2019-12-09 13:21 pengbo Assigned To => pengbo
2019-12-09 13:21 pengbo Status new => assigned
2019-12-09 13:21 pengbo Description Updated View Revisions
2019-12-09 15:28 pengbo Note Added: 0003013
2019-12-09 23:05 eduarte File Added: salida.log
2019-12-09 23:05 eduarte Note Added: 0003015
2019-12-11 15:46 pengbo Note Added: 0003018
2020-01-20 12:31 pengbo Status assigned => feedback
2020-01-20 22:10 eduarte File Added: error master-standby.txt
2020-01-20 22:10 eduarte Note Added: 0003076
2020-01-20 22:10 eduarte Status feedback => assigned