Re: profile GNUmed database at publicdb.gnumed.de (PUBLIC)

> From: Bunny via <[email protected]>
>
> ich glaube wir können auf deutsch schreiben:)

Stimmt. Empfehlenswert wäre auch die Einschreibung auf der
Mailingliste, die wir normalerweise für solche Austausche
verwenden:

	https://lists.gnu.org/mailman/listinfo/gnumed-devel

> Ich nutze MacOS mit Catalina 10.15.4

Das kann interessant werden.

> Ich habe die Log Datei dabei...

Das ist gut, die Logdatei zeigt hingegen ein bekanntes
ungelöstes Problem:

Irgendwas ist verquer mit Python3.8 / psycopg2 2.8. Die
Ursache habe ich noch nicht ausreichend suchen können.

	2020-05-28 10:50:28  INFO      gm.db         [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmBackendListener.py::__start_thread() #172): starting listener thread
	2020-05-28 10:50:28  ERROR     gm.db         [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmPG2.py::run_ro_queries() #1551): query failed in RO connection
	2020-05-28 10:50:28  DEBUG     gm.db_pool    [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmConnectionPool.py::log_pg_exception_details() #685): exc.arg: extraneous data in "T" message
	2020-05-28 10:50:28  DEBUG     gm.db_pool    [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmConnectionPool.py::log_pg_exception_details() #688): pgerror: [extraneous data in "T" message]
	2020-05-28 10:50:28  DEBUG     gm.db_pool    [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmConnectionPool.py::log_pg_exception_details() #690): pgcode : None
	2020-05-28 10:50:28  DEBUG     gm.logging    [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmLog2.py::log_multiline() #220): Link state:
	: Cursor
	:  identity: 4474213696; name: None
	:  closed: False; scrollable: None; with hold: False; arraysize: 1; itersize: 2000;
	:  last rowcount: -1; rownumber: 0; lastrowid (OID): 0;
	:  last description: None
	:  statusmessage: SELECT 1
	: Connection
	:  identity: 4473824976; backend pid: 18378; protocol version: 3;
	:  closed: 0; autocommit: True; isolation level: None; encoding: UTF8; async: 0; deferrable: None; readonly: True;
	:  TX status: TRANSACTION_STATUS_IDLE; CX status: STATUS_READY; executing async op: False;
	: Query
	:  SELECT * FROM dem.v_praxis_branches WHERE true
	2020-05-28 10:50:28  DEBUG     gm.gui        [4535135680 MainThread]  (/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx() #198): unhandled exception caught:
	Traceback (most recent call last):
	  File "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmGuiMain.py", line 3457, in OnInit
	    if not self.__verify_praxis_branch():
	  File "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmGuiMain.py", line 3669, in __verify_praxis_branch
	    if not gmPraxisWidgets.set_active_praxis_branch(no_parent = True):
	  File "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmPraxisWidgets.py", line 412, in set_active_praxis_branch
	    branches = gmPraxis.get_praxis_branches()
	  File "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/business/gmPraxis.py", line 255, in get_praxis_branches
	    rows, idx = gmPG2.run_ro_queries(queries = [{'cmd': cmd}], get_col_idx = True)
	  File "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmPG2.py", line 1547, in run_ro_queries
	    curs.execute(query['cmd'], args)
	  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/psycopg2/extras.py", line 143, in execute
	    return super(DictCursor, self).execute(query, vars)
	psycopg2.DatabaseError: extraneous data in "T" message

Es scheint mir, es könnte mit fehlerhafter Threadnutzung
zusammenhängen. Das schaue ich nochmal nach. Ich habe
denselben Report von zwei weiteren Nutzern (immer nur mit
psycopg2.8 auf python3.8)

> im Log steht:

Bzw in der Konsolenausgabe ?

> CRITICAL ERROR: Program halted.
>
> Please make sure you have:
>
>  1) the required third-party Python modules installed
>  2) the GNUmed Python modules linked or installed into site-packages/
>     (if you do not run from a CVS tree the installer should have taken care
> of that)
>  3) your PYTHONPATH environment variable set up correctly
>
> <sys.path> is currently set to:
>
>  %s

Interessanterweise findet gnumed.py (anhand des Logs) aber
dennoch die nötigen Module und führt den Startprozeß fort.

> Aus der check-prerequisites.sh sieht es so aus:
>
> sys.path (press <ENTER> key to show):
>
>   /Users/alex/gnumed/gnumed-client.1.8.1/external-tools
>   /Library/Frameworks/Python.framework/Versions/3.8/lib/python38.zip
>   /Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8
>
>
> /Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/lib-dynload
> /Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages
>
>
> ${PATH} (press <ENTER> key to show):
>
> /Library/Frameworks/Python.framework/Versions/3.8/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Library/Apple/usr/bin
>
> /Users/alex/gnumed/gnumed-client.1.8.1/external-tools

Das ist OK so.


> *alex@MacBook-Pro client % ./gm-from-vcs.sh  *
>
> -------------------------------------------------
>
> fatal: Kein Git-Repository (oder irgendeines der Elternverzeichnisse): .git

Das ist unproblematisch, ich habe es aber jetzt verschönert.

> 10:50:28: Debug:
> /Users/robind/projects/bb2/dist-osx-py38/build/ext/wxWidgets/src/osx/cocoa/
> utils.mm(561): assert ""gs_wxBusyCursorCount > 0"" failed in
> wxEndBusyCursor(): no matching wxBeginBusyCursor() for wxEndBusyCursor()
>
> Error in sys.excepthook:
>
> Traceback (most recent call last):
>
>   File
> "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmExceptionHandlingWidgets.py",
> line 235, in handle_uncaught_exception_wx
>
>     wx.EndBusyCursor()
>
> wx._core.wxAssertionError: C++ assertion ""gs_wxBusyCursorCount > 0""
> failed at
> /Users/robind/projects/bb2/dist-osx-py38/build/ext/wxWidgets/src/osx/cocoa/
> utils.mm(561) in wxEndBusyCursor(): no matching wxBeginBusyCursor() for
> wxEndBusyCursor()

Good to know this happens on MacOSX as well. There's already
code working around the issue on Windows:

	def setup_safe_wxEndBusyCursor():
		# monkey patch wxPython, needed on Windows ...
		if os.name != 'nt':
			return
		print('GNUmed startup: Monkey patching wx.EndBusyCursor...')
		global _original_wxEndBusyCursor
		_original_wxEndBusyCursor = wx.EndBusyCursor
		wx.EndBusyCursor = _safe_wxEndBusyCursor
		_log.debug('monkey patched wx.EndBusyCursor:')
		_log.debug('[%s] -> [%s]', _original_wxEndBusyCursor, _safe_wxEndBusyCursor)

which I will activate for OSX as well now. If you want to
test that right now you can comment out the lines

		if os.name != 'nt':
			return

to

		#if os.name != 'nt':
		#	return

in the function "setup_safe_wxEndBusyCursor()" inside

	/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmGuiMain.py

That will, however, simply uncover the original exception:

> Original exception was:
>
> Traceback (most recent call last):
>
>   File
> "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmGuiMain.py", line
> 3457, in OnInit
>
>     if not self.__verify_praxis_branch():
>
>   File
> "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmGuiMain.py", line
> 3669, in __verify_praxis_branch
>
>     if not gmPraxisWidgets.set_active_praxis_branch(no_parent = True):
>
>   File
> "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/wxpython/gmPraxisWidgets.py",
> line 412, in set_active_praxis_branch
>
>     branches = gmPraxis.get_praxis_branches()
>
>   File
> "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/business/gmPraxis.py", line
> 255, in get_praxis_branches
>
>     rows, idx = gmPG2.run_ro_queries(queries = [{'cmd': cmd}], get_col_idx
> = True)
>
>   File "/Users/alex/gnumed/gnumed-client.1.8.1/Gnumed/pycommon/gmPG2.py",
> line 1547, in run_ro_queries
>
>     curs.execute(query['cmd'], args)
>
>   File
> "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/psycopg2/extras.py",
> line 143, in execute
>
>     return super(DictCursor, self).execute(query, vars)
>
> psycopg2.DatabaseError: extraneous data in "T" message

den ich noch nicht beheben konnte.

(Python 3.7 / psycopg2 2.7 funktionieren normal)


Karsten