Re: [Gnumed-devel] Some unhandled exceptions, also console output

[Karsten Hilbert]

On Mon, Jun 28, 2010 at 10:10:48PM -0700, Jim Busser wrote:

> I generated two reports (as jim @ ca) to gnumed-bugs. If
> those could be consulted, I assume that they reflect excess
> inactivity, and I just wondered whether such errors (or a
> subset thereof) -- if identifiable with some confidence
> --could in future be more cleanly "trapped" and presented to
> the user as a dialog that says:
> 
>       While you were last working on patient <name>, your database connection 
> timed out. This GNUmed session is now expired.
> 
>       <ok button>

I added this logic:


        # lost connection ?
        try:
                msg = gmPG2.extract_message_from_pg_exception(exc = v)
        except:
                msg = u'cannot extract msg from PostgreSQL exception'
                print msg
                print v

        conn_loss_on_operational_error = (
                (t == gmPG2.dbapi.OperationalError)
                        and
                ('erver' in msg)
                        and
                (('term' in msg) or ('abnorm' in msg) or ('end' in msg))
        )
        conn_loss_on_interface_error = (
                (t == gmPG2.dbapi.InterfaceError)
                        and
                ('onnect' in msg)
                        and
                (('close' in msg) or ('end' in msg))
        )
        lost_connection = conn_loss_on_operational_error or 
conn_loss_on_interface_error
        if lost_connection:
                gmGuiHelpers.gm_show_error (
                        aTitle = _('Lost connection'),
                        aMessage = _(
                                'Since you were last working in GNUmed,\n'
                                'your database connection timed out.\n'
                                '\n'
                                'This GNUmed session is now expired.\n'
                                '\n'
                                'You will have to close this client and\n'
                                'restart a new GNUmed session.'
                        )
                )
                _log2.panic('lost connection')
                gmLog2.log_stack_trace()
                return


(we don't know the patient name at this point in the code and
 we should not try to find out lest we provoke follow-on
 errors)

which will show the attached friendly screenshot.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

screenshot_001.png
Description: PNG image