[pgpool-general: 4865] Pgpool2-ERROR: unable to read data from frontend

[Kanak Upadhyay]

Hi,
While making connection the pgool2 is giving error like:
DETAIL: socket read failed with an error "Connection reset by peer"
And the connection are getting rejected.
Is it an issue from pgpool2 end..or is it a connection issue as we are trying to make connection from the windows environment in order to test the load balancing through PGPOOL2.


Below are the specified logs:


Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 0 backend pid: 10402 statement: BEGIN

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 1 backend pid: 55023 statement: BEGIN

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: statement: SELECT * FROM topic WHERE name = 'painters' and ent_id = 1

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 0 backend pid: 10402 statement: SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname = 'topic' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 1 backend pid: 55023 statement: SELECT * FROM topic WHERE name = 'painters' and ent_id = 1

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: ERROR: unable to read data from frontend

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: DETAIL: socket read failed with an error "Connection reset by peer"

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: statement: ABORT

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 1 backend pid: 55023 statement: ABORT

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 0 backend pid: 10402 statement: ABORT

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: statement: DISCARD ALL

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 0 backend pid: 10402 statement: DISCARD ALL

Aug 4

19:12:51

HOSTNAME pgpool[8149]:

2016-08-04 19:12:51: pid 8195: LOG: DB node id: 1 backend pid: 55023 statement: DISCARD ALL



Thanks in advance.

Thanks and Regards,
Kanak Upadhyay
Xavient Information Systems

***DISCLAIMER*** This communication & accompanying documents ("this e-mail") contains confidential and/or privileged information for exclusive use of the individual to whom it is addressed. If you are not the intended recipient, please immediately notify the company & delete this e-mail. Any unauthorized use or disclosure of this e-mail is strictly prohibited. Representations in this e-mail are subject to contract. As an e-mail user please be cautious of the technical & other vulnerabilities of the internet which may result in malicious and/or unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160804/a9a10c86/attachment.html>