Обсуждение: BUG #15958: All queries return "not enough values to unpack (expected 5, got 4)"
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: davs2rt@gmail.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@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)