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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: davs2rt(at)gmail(dot)com
Subject: BUG #15958: All queries return "not enough values to unpack (expected 5, got 4)"
Date: 2019-08-14 05:04:49
Message-ID: 15958-5984a25a5a864f85@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15958
Logged by: Dave Stewart
Email address: davs2rt(at)gmail(dot)com
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(at)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)

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2019-08-14 05:32:03 Re: BUG #15954: Unable to alter partitioned table to set logged
Previous Message Keith Fiske 2019-08-14 03:41:46 Re: BUG #15954: Unable to alter partitioned table to set logged