[ https://issues.apache.org/jira/browse/HAWQ-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiang Sheng updated HAWQ-1238: ------------------------------ Fix Version/s: 2.2.0.0-incubating > 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)