You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Xiang Sheng (JIRA)" <ji...@apache.org> on 2017/02/09 08:23:41 UTC
[jira] [Commented] (HAWQ-1238) Can not get any data when the
network is connected again after a while disconnected.
[ https://issues.apache.org/jira/browse/HAWQ-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15859195#comment-15859195 ]
Xiang Sheng commented on HAWQ-1238:
-----------------------------------
This problem is duplicated with the HAWQ-1279 and the it has been fixed by the commits in the JIRA [HAWQ-1279|http://issues.apache.org/jira/browse/HAWQ-1279] and [HAWQ-1286|https://issues.apache.org/jira/browse/HAWQ-1286]. So I will close this JIRA.
> 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
> Fix For: 2.2.0.0-incubating
>
>
> 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)