BUG #15958: All queries return "not enough values to unpack (expected 5, got 4)"

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

BUG #15958: All queries return "not enough values to unpack (expected 5, got 4)"

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15958
Logged by:          Dave Stewart
Email address:      [hidden email]
PostgreSQL version: 11.4
Operating system:   Postgres:Amazon RDS instance, probably linux based
Description:        

pgAdmin4 upgraded from 4.10 to 4.11-2.pgdg16.04+1 using Linux Mint upgrader
(Ubuntu variant).  
Start-Date: 2019-08-13  21:19:26
Commandline: /usr/sbin/synaptic
Requested-By: davs2rt (1000)
Reinstall: pgadmin4:amd64 (4.11-2.pgdg16.04+1), pgadmin4-common:amd64
(4.11-2.pgdg16.04+1)
End-Date: 2019-08-13  21:19:30

All queries respond "not enough values to unpack (expected 5, got 4)"  
e.g.   select version();  or select * from everytable;
My system python3 is
>>> sys.version
'3.5.2 (default, Nov 12 2018, 13:43:14) \n[GCC 5.4.0 20160609]

Right click on a table in tree view, View/Edit Data works just fine.

.pgAdmin4.startup.log:
13.08.2019 21:49:50 Checking for system tray...
13.08.2019 21:49:50 Starting pgAdmin4 server...
13.08.2019 21:49:50 Creating server object, port:34553,
key:cdb3f469-bbbd-460c-b749-59a3c349b5c4, logfile:/home/davs2rt/
.pgAdmin4.12043198322513793213.log
13.08.2019 21:49:50 Python Path:
/home/davs2rt/work/betablender-cl/pyscripts/venv/lib64/python3.5/site-packages:/usr/lib
/python3/dist-packages
13.08.2019 21:49:50 Python Home:
13.08.2019 21:49:50 Initializing Python...
13.08.2019 21:49:50 Python initialized.
13.08.2019 21:49:50 Adding new additional path elements
13.08.2019 21:49:50 Redirecting stderr...
13.08.2019 21:49:50 stderr redirected successfully.
13.08.2019 21:49:50 Initializing server...
13.08.2019 21:49:50 Webapp Path: /usr/share/pgadmin4/web/pgAdmin4.py
13.08.2019 21:49:50 Server initialized.
13.08.2019 21:49:50 Starting Server Thread...
13.08.2019 21:49:50 Open the application code and run it.
13.08.2019 21:49:50 Set the port number, key and force SERVER_MODE off
13.08.2019 21:49:50 PyRun_SimpleFile launching application server...
13.08.2019 21:49:51 Application Server URL:
http://127.0.0.1:34553/?key=cdb3f469-bbbd-460c-b749-59a3c349b5c4
13.08.2019 21:49:51 The server should be up, we'll attempt to connect and
get a response. Ping the server
13.08.2019 21:49:51 Attempt to connect one more time in case of a long
network timeout while looping
13.08.2019 21:49:51 Everything works fine, successfully started pgAdmin4.

davs2rt@oryx ~ $ cat .pgAdmin4.11250296771855179612.log
2019-08-13 21:20:45,879: ERROR pgadmin: not enough values to unpack
(expected 5, got 4)
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1475, in
full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1461, in
dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/lib/python3/dist-packages/flask_login/utils.py", line 228, in
decorated_view
    return func(*args, **kwargs)
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/__init__.py", line
416, in poll
    if trans_obj.check_updatable_results_pkeys_oids():
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/command.py", line
910, in check_updatable_results_pkeys_oids
    pk_names, table_oid = is_query_resultset_updatable(conn, sql_path)
ValueError: not enough values to unpack (expected 5, got 4)
2019-08-13 21:30:34,585: ERROR pgadmin: Failed to execute query
(execute_async) for the server #9 - CONN:9505462(Query-id: 4509956):
Error Message:ERROR:  canceling statement due to user request
SQL state: 57014
2019-08-13 21:30:45,215: ERROR pgadmin: not enough values to unpack
(expected 5, got 4)
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1475, in
full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1461, in
dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/lib/python3/dist-packages/flask_login/utils.py", line 228, in
decorated_view
    return func(*args, **kwargs)
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/__init__.py", line
416, in poll
    if trans_obj.check_updatable_results_pkeys_oids():
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/command.py", line
910, in check_updatable_results_pkeys_oids
    pk_names, table_oid = is_query_resultset_updatable(conn, sql_path)
ValueError: not enough values to unpack (expected 5, got 4)
2019-08-13 21:31:54,883: ERROR pgadmin: not enough values to unpack
(expected 5, got 4)
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1475, in
full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1461, in
dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/lib/python3/dist-packages/flask_login/utils.py", line 228, in
decorated_view
    return func(*args, **kwargs)
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/__init__.py", line
416, in poll
    if trans_obj.check_updatable_results_pkeys_oids():
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/command.py", line
910, in check_updatable_results_pkeys_oids
    pk_names, table_oid = is_query_resultset_updatable(conn, sql_path)
ValueError: not enough values to unpack (expected 5, got 4)
2019-08-13 21:32:37,811: ERROR pgadmin: not enough values to unpack
(expected 5, got 4)
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1475, in
full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/python3/dist-packages/flask/app.py", line 1461, in
dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/lib/python3/dist-packages/flask_login/utils.py", line 228, in
decorated_view
    return func(*args, **kwargs)
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/__init__.py", line
416, in poll
    if trans_obj.check_updatable_results_pkeys_oids():
  File "/usr/share/pgadmin4/web/pgadmin/tools/sqleditor/command.py", line
910, in check_updatable_results_pkeys_oids
    pk_names, table_oid = is_query_resultset_updatable(conn, sql_path)
ValueError: not enough values to unpack (expected 5, got 4)