Re: [Gnumed-bugs] <bug>: add a medication

[Karsten Hilbert]

Hello Gary,

thanks for your report !

> user comment  : add a medication

The problem you saw:

> 2011-02-05 13:40:15  ERROR     gm.db 
> (/usr/share/gnumed/Gnumed/pycommon/gmPG2.py::run_ro_queries() #1000): cannot 
> close cursor
> Traceback (most recent call last):
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 998, in 
> run_ro_queries
>     curs_close()
> InterfaceError: cursor already closed
> 2011-02-05 13:40:15  ERROR     gm.gui 
> (/usr/share/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #97): enabling debug mode
> 2011-02-05 13:40:15  DEBUG     gm.gui 
> (/usr/share/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #101): unhandled exception caught:
> Traceback (most recent call last):
>   File "/usr/share/gnumed/Gnumed/wxpython/gmMedicationWidgets.py", line 1547, 
> in __on_mouse_over_cells
>     evt.GetEventObject().SetToolTipString(self.get_row_tooltip(row = row))
>   File "/usr/share/gnumed/Gnumed/wxpython/gmMedicationWidgets.py", line 1363, 
> in get_row_tooltip
>     allg = emr.is_allergic_to(atcs = tuple(atcs), inns = 
> (entry['substance'],), brand = entry['brand'])
>   File "/usr/share/gnumed/Gnumed/business/gmClinicalRecord.py", line 841, in 
> is_allergic_to
>     if self.allergy_state is None:
>   File "/usr/share/gnumed/Gnumed/business/gmClinicalRecord.py", line 898, in 
> _get_allergy_state
>     return gmAllergy.ensure_has_allergy_state(encounter = 
> self.current_encounter['pk_encounter'])
>   File "/usr/share/gnumed/Gnumed/business/gmAllergy.py", line 56, in 
> ensure_has_allergy_state
>     return cAllergyState(aPK_obj = rows[0][0])
>   File "/usr/share/gnumed/Gnumed/pycommon/gmBusinessDBObject.py", line 198, 
> in __init__
>     self.__init_from_pk(aPK_obj=aPK_obj)
>   File "/usr/share/gnumed/Gnumed/pycommon/gmBusinessDBObject.py", line 217, 
> in __init_from_pk
>     result = self.refetch_payload()
>   File "/usr/share/gnumed/Gnumed/pycommon/gmBusinessDBObject.py", line 369, 
> in refetch_payload
>     get_col_idx = True
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 1001, in 
> run_ro_queries
>     tx_rollback()             # need to rollback so ABORT state isn't 
> preserved in pooled conns
> InterfaceError: connection already closed

very much suggests a spurious connection problem which
should be gone the next time you run GNUmed.

If you can reproduce it then please tell us how - we would
then like to fix it.

You should also try:

> 2011-02-04 20:17:11  INFO      gm.launcher 
> (/usr/share/gnumed/Gnumed/gnumed.py::log_startup_info() #200): GNUmed client 
> version [0.7.9] on branch [0.7]

- running 0.7.10

> 2011-02-04 20:17:11  INFO      gm.launcher 
> (/usr/share/gnumed/Gnumed/gnumed.py::log_startup_info() #201): Platform: 
> ('Linux', 'UBUNB', '2.6.35-23-generic', '#41-Ubuntu SMP Wed Nov 24 10:18:49 
> UTC 2010', 'i686', '')
> 2011-02-04 20:17:11  INFO      gm.launcher 
> (/usr/share/gnumed/Gnumed/gnumed.py::log_startup_info() #202): Python 2.6.6 
> (r266:84292, Sep 15 2010, 15:52:39) 
> [GCC 4.4.5] on linux2 (posix)
> 2011-02-04 20:17:11  INFO      gm.launcher 
> (/usr/share/gnumed/Gnumed/gnumed.py::log_startup_info() #205): {'RELEASE': 
> '10.10', 'CODENAME': 'maverick', 'ID': 'Ubuntu', 'DESCRIPTION': 'Ubuntu 
> 10.10'}

You should also go ahead any try one of the newer versions.
0.7.10 will not require a database upgrade. 0.8.6 will
require a database upgrade but also contains a lot of fixes
and improvements.

        http://wiki.gnumed.de/bin/view/Gnumed/UbuntuGuideShort

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346