Bug 1489597 - pg_view 1.3 does not work with postgresql 9.6
Summary: pg_view 1.3 does not work with postgresql 9.6
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: pg_view
Version: 26
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Lorenzo Dalrio
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-09-07 20:40 UTC by Reto Zingg
Modified: 2017-09-17 03:51 UTC (History)
1 user (show)

Fixed In Version: pg_view-1.4.0-1.fc26
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-09-17 03:51:12 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github /zalando pg_view issues 68 0 None None None 2017-09-07 20:41:33 UTC

Description Reto Zingg 2017-09-07 20:40:33 UTC
Description of problem:
pg_view 1.3 does not work with postgresql 9.6

Version-Release number of selected component (if applicable):
pg_view-1.3.0-4.fc26.noarch

How reproducible:
Steps to Reproduce:
1. Install postgres 9.6 via dnf and set it up
2. dnf install pg_view
3. su - postgres
4. pg_view

Actual results:
# su - postgres
-bash-4.4$ pg_view 
Traceback (most recent call last):
  File "/usr/bin/pg_view", line 3432, in main
    loop(collectors, consumer, groups, output_method)
  File "/usr/bin/pg_view", line 2748, in loop
    curses.wrapper(do_loop, groups, output_method, collectors, consumer)
  File "/usr/lib64/python3.6/curses/__init__.py", line 94, in wrapper
    return func(stdscr, *args, **kwds)
  File "/usr/bin/pg_view", line 2816, in do_loop
    process_single_collector(st)
  File "/usr/bin/pg_view", line 2845, in process_single_collector
    st.refresh()
  File "/usr/bin/pg_view", line 1187, in refresh
    stat_data = self._read_pg_stat_activity()
  File "/usr/bin/pg_view", line 1408, in _read_pg_stat_activity
    """)
  File "/usr/lib64/python3.6/site-packages/psycopg2/extras.py", line 223, in execute
    return super(RealDictCursor, self).execute(query, vars)
psycopg2.ProgrammingError: column "waiting" does not exist
LINE 8:                            waiting,
                                   ^


Expected results:
pg_view works

Additional info:
Upstream bug:
https://github.com/zalando/pg_view/issues/68

Should be fixed in version 1.4 which was released in March 2017

Comment 1 Fedora Update System 2017-09-08 13:20:10 UTC
pg_view-1.4.0-1.fc26 has been submitted as an update to Fedora 26. https://bodhi.fedoraproject.org/updates/FEDORA-2017-790c223fac

Comment 2 Fedora Update System 2017-09-08 22:24:04 UTC
pg_view-1.4.0-1.fc26 has been pushed to the Fedora 26 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-790c223fac

Comment 3 Fedora Update System 2017-09-17 03:51:12 UTC
pg_view-1.4.0-1.fc26 has been pushed to the Fedora 26 stable repository. If problems still persist, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.