Uploaded image for project: 'Apache HAWQ (Retired)'
  1. Apache HAWQ (Retired)
  2. HAWQ-1136

Disable .psqlrc in minirepro

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Command Line Tools
    • None

    Description

      .psqlrc can create unexpected output and changes in formatting that don't play nice with parse_oids().

      ```
      psql database --pset footer -Atq -h localhost -p 5432 -U gpadmin -f /tmp/20161012232709/toolkit.sql

      {"relids": "573615536", "funcids": ""}

      Time: 2.973 ms
      ```

      Generates an Exception:
      ```
      Traceback (most recent call last):
      File "/usr/local/greenplum-db/./bin/minirepro", line 386, in <module>
      main()
      File "/usr/local/greenplum-db/./bin/minirepro", line 320, in main
      mr_query = parse_oids(cursor, json_str)
      File "/usr/local/greenplum-db/./bin/minirepro", line 151, in parse_oids
      result.relids = json.loads(json_oids)['relids']
      File "/usr/local/greenplum-db/ext/python/lib/python2.6/json/_init_.py", line 307, in loads
      return _default_decoder.decode(s)
      File "/usr/local/greenplum-db/ext/python/lib/python2.6/json/decoder.py", line 322, in decode
      raise ValueError(errmsg("Extra data", s, end, len(s)))
      ValueError: Extra data: line 2 column 1 - line 3 column 1 (char 39 - 54)
      ```

      Attachments

        Issue Links

          Activity

            People

              hyuan Haisheng Yuan
              hyuan Haisheng Yuan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: