Chunling Wang created HAWQ-1238:
-----------------------------------
Summary: Can not get any data when the network is connected again
after a while disconnected.
Key: HAWQ-1238
URL: https://issues.apache.org/jira/browse/HAWQ-1238
Project: Apache HAWQ
Issue Type: Bug
Components: Security
Reporter: Chunling Wang
Assignee: Ed Espino
Can not get any data when the network is connected again after a while
disconnected.
1. Psql postgres, run "\d" and find relations in database.
{code}
psql postgres
psql (8.2.15)
Type "help" for help.
postgres=# \d
List of relations
Schema | Name | Type | Owner | Storage
--------+----------------+-------+--------------+-------------
public | sales1 | table | wangchunling | append only
public | sales1_1_prt_1 | table | wangchunling | append only
public | sales1_1_prt_2 | table | wangchunling | append only
public | t | table | wangchunling | append only
public | tv | view | wangchunling | none
(5 rows)
{code}
2. Quit the session and disconnect the network. Then psql postgres, run "\d"
and get expected error.
{code}
$ psql postgres
psql (8.2.15)
Type "help" for help.
postgres=# \d
WARNING: curl_easy_perform() failed: Couldn't connect to server
LINE 1: select version()
^
WARNING: curl_easy_perform() failed: Couldn't connect to server
ERROR: permission denied for function version
WARNING: curl_easy_perform() failed: Couldn't connect to server
ERROR: permission denied for function version
WARNING: curl_easy_perform() failed: Couldn't connect to server
LINE 5: FROM pg_catalog.pg_class c
^
ERROR: permission denied for schema pg_catalog
LINE 5: FROM pg_catalog.pg_class c
^
{code}
3. Connect the network and run "\d", but find no relations.
{code}
postgres=# \d
No relations found.
{code}
4. Quit the session again. Then psql postgres, run "\d" and find relations
correctly.
{code}
$ psql postgres
psql (8.2.15)
Type "help" for help.
postgres=# \d
List of relations
Schema | Name | Type | Owner | Storage
--------+----------------+-------+--------------+-------------
public | sales1 | table | wangchunling | append only
public | sales1_1_prt_1 | table | wangchunling | append only
public | sales1_1_prt_2 | table | wangchunling | append only
public | t | table | wangchunling | append only
public | tv | view | wangchunling | none
(5 rows)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
