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

["Xiang Sheng (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xiang Sheng reassigned HAWQ-1238:
---------------------------------

    Assignee: Xiang Sheng  (was: Ed Espino)

> 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: Xiang Sheng
>
> 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.15#6346)