Thread: Local variable 'debugger_version' referenced before assignment

Hello:
After enabling en file postgresql.conf  shared_preload_libraries = '$
libdir/plugin_debugger.dll'
and installing the pldbgapi extension.
I try to debug a created function and pgadmin4 displays the following error.

Local variable 'debugger_version' referenced before assignment.

This variable is not in my function, what is the error.

PostgreSQL 12.2, compiled by Visual C++ build 1914, 64-bit (Windows 2019)
PgAdmin 4.23

The pgadmin4 log says:

---------------------------------
2020-08-04 18:11:33,826: ERROR  flask.app:      Failed to execute query
(execute_scalar) for the server #2 - CONN:9214613 (Query-id: 1047347):
Error Message:ERROR:  no existe la funci├│n pldbg_get_proxy_info() LINE
1: SELECT proxyapiver FROM pldbg_get_proxy_info();
                                ^
HINT:  Ninguna funci├│n coincide en el nombre y tipos de argumentos.
Puede ser necesario agregar conversión explícita de tipos.

2020-08-04 18:11:33,827: ERROR  flask.app:      local variable
'debugger_version' referenced before assignment
Traceback (most recent call last):
  File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-
packages\flask\app.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-
packages\flask\app.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-
packages\flask_login\utils.py", line 261, in decorated_view
    return func(*args, **kwargs)
  File "C:\Program Files\PostgreSQL\12\pgAdmin
4\web\pgadmin\tools\debugger\__init__.py", line 747, in initialize_target
    current_app.logger.debug("Debugger version is: %d", debugger_version)
UnboundLocalError: local variable 'debugger_version' referenced before
assignment
---------------------------------

I found the problem. If the scheme is "pulic" it works correctly, with
another scheme the error occurs.
Why can't I use another scheme?
Note that SELECT proxyapiver FROM pldbg_get_proxy_info ();
It is not placing the schema correctly where I am working, in my case "dba"
And now what do I do?

Hi Fontana,

It may be possible that you've set the search_path to something other than public. And so, the function pldbg_get_proxy_info is not found.

Please report the bug here - https://redmine.postgresql.org/projects/pgadmin4/issues/new.  I think the function pldbg_get_proxy_info should be called with the apt. schema qualified name.

On Wed, Aug 5, 2020 at 3:41 AM Fontana Daniel C (Desartec S.R.L.) <desartecsrl@gmail.com> wrote:

Hello:
After enabling en file postgresql.conf  shared_preload_libraries = '$
libdir/plugin_debugger.dll'
and installing the pldbgapi extension.
I try to debug a created function and pgadmin4 displays the following error.

Local variable 'debugger_version' referenced before assignment.

This variable is not in my function, what is the error.

PostgreSQL 12.2, compiled by Visual C++ build 1914, 64-bit (Windows 2019)
PgAdmin 4.23

The pgadmin4 log says:

---------------------------------
2020-08-04 18:11:33,826: ERROR  flask.app:      Failed to execute query
(execute_scalar) for the server #2 - CONN:9214613 (Query-id: 1047347):
Error Message:ERROR:  no existe la funci├│n pldbg_get_proxy_info() LINE
1: SELECT proxyapiver FROM pldbg_get_proxy_info();
                                ^
HINT:  Ninguna funci├│n coincide en el nombre y tipos de argumentos.
Puede ser necesario agregar conversión explícita de tipos.

2020-08-04 18:11:33,827: ERROR  flask.app:      local variable
'debugger_version' referenced before assignment
Traceback (most recent call last):
  File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-
packages\flask\app.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-
packages\flask\app.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-
packages\flask_login\utils.py", line 261, in decorated_view
    return func(*args, **kwargs)
  File "C:\Program Files\PostgreSQL\12\pgAdmin
4\web\pgadmin\tools\debugger\__init__.py", line 747, in initialize_target
    current_app.logger.debug("Debugger version is: %d", debugger_version)
UnboundLocalError: local variable 'debugger_version' referenced before
assignment
---------------------------------

I found the problem. If the scheme is "pulic" it works correctly, with
another scheme the error occurs.
Why can't I use another scheme?
Note that SELECT proxyapiver FROM pldbg_get_proxy_info ();
It is not placing the schema correctly where I am working, in my case "dba"
And now what do I do?

--

Thanks,

Aditya Toshniwal

pgAdmin hacker | Sr. Software Engineer | edbpostgres.com

"Don't Complain about Heat, Plant a TREE"