Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1238

Can not get any data when the network is connected again after a while disconnected.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 2.1.0.0-incubating
    • Component/s: Security
    • Labels:
      None

      Description

      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.

      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)
      
      

      2. Quit the session and disconnect the network. Then psql postgres, run "\d" and get expected error.

      $ 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
                   ^
      

      3. Connect the network and run "\d", but find no relations.

      postgres=# \d
      No relations found.
      

      4. Quit the session again. Then psql postgres, run "\d" and find relations correctly.

      $ 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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                xsheng Xiang Sheng
                Reporter:
                wcl14 Chunling Wang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: