Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

why psql remote connection to HAWQ will be reset when execuete SQL command?

Highlighted

why psql remote connection to HAWQ will be reset when execuete SQL command?

New Contributor

@Shyam Sunder Rai

HDP version: 2.5.0.0

HAWQ version: 2.1.1.0

Remote connection configuration refered to https://community.hortonworks.com/content/kbentry/77774/hawq-accessing-hawq-via-clientedge-node.html

In my environment

Remotely connect to HAWQ master from HAWQ standbymaster, here's my cmd print out:

psql (8.2.15) Type "help" for help.

gpadmin=# \l

List of databases

Name | Owner | Encoding | Access privileges

-----------+---------+----------+-------------------

gpadmin | gpadmin | UTF8 |

postgres | gpadmin | UTF8 |

sandbox | gpadmin | UTF8 |

template0 | gpadmin | UTF8 |

template1 | gpadmin | UTF8 |

(5 rows)

gpadmin=# \c sandbox

You are now connected to database "sandbox" as user "gpadmin".

sandbox=# \d

List of relations Schema

| Name | Type | Owner | Storage

--------+--------+-------+---------+---------

public | yjhawq | table | gpadmin | parquet

(1 row)

sandbox=# select * from yjhawq;

server closed the connection unexpectedly

This probably means the server terminated abnormally before or while processing the request.

The connection to the server was lost. Attempting reset: Succeeded.

Don't have an account?
Coming from Hortonworks? Activate your account here