[jira] [Created] (HAWQ-1238) Can not get any data when the network is connected again after a while disconnected.

["Chunling Wang (JIRA)" <ji...@apache.org>]

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)