Re: [Gnumed-bugs] <bug>: login after upgrade to 1.6.14

[Karsten Hilbert]

Hi Marc,

thanks for your report.

> user comment  : login after upgrade to 1.6.14
> 
> client version: 1.6.14

...

> 2017-09-18 21:15:00  DEBUG     gm.gui 
> (/usr/share/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #219): unhandled exception caught:
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main
>     "__main__", fname, loader, pkg_name)
>   File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
>     exec code in run_globals
>   File "/usr/share/gnumed/Gnumed/gnumed.py", line 717, in <module>
>     gmGuiMain.main()
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 4023, in main
>     app = gmApp(redirect = False, clearSigInt = False)
>   File "/usr/lib/python2.7/dist-packages/wx-3.0-gtk2/wx/_core.py", line 8628, 
> in __init__
>     self._BootstrapApp()
>   File "/usr/lib/python2.7/dist-packages/wx-3.0-gtk2/wx/_core.py", line 8196, 
> in _BootstrapApp
>     return _core_.PyApp__BootstrapApp(*args, **kwargs)
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3479, in OnInit
>     if not self.__establish_backend_connection():
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3650, in 
> __establish_backend_connection
>     require_version = not override
>   File "/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py", line 225, in 
> connect_to_database
>     seems_bootstrapped = gmPG2.schema_exists(schema = 'gm')
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 794, in 
> schema_exists
>     rows, idx = run_ro_queries(link_obj = link_obj, queries = [{'cmd': cmd, 
> 'args': args}])
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 1679, in 
> run_ro_queries
>     conn = get_connection(readonly=True, verbose=verbose)
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 2151, in 
> get_connection
>     [ _log.debug(line) for line in capture_conn_state(conn = 
> conn).split(u'\n') ]
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 1563, in 
> capture_conn_state
>     u'deferrable': conn.deferrable,

This problem is caused by the fact that psycopg2 recently
changed the way it handles readwrite vs readonly database
connections. That change contained a problem which is fixed
in version 2.7.3 which is available in Testing (Buster):

        python-psycopg2:
          Installiert:           2.7.3-1
          Installationskandidat: 2.7.3-1
          Versionstabelle:
         *** 2.7.3-1 990
                990 http://httpredir.debian.org/debian buster/main i386 Packages
                500 http://httpredir.debian.org/debian unstable/main i386 
Packages
                100 /var/lib/dpkg/status
             2.6.2-1 500
                500 http://httpredir.debian.org/debian stretch/main i386 
Packages

Once you install that GNUmed should not show this problem anymore.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346