AW: [egenix-users] ProgrammingError

[Erich Birrer-Uster]

Dear Mr. Lemburg

Thank you for your reply.
The application is now in the productive state and the error is very bothering so I have to present a solution to the customer.
- is a release where HY000 is a OperationalError already available?
- can you provide a patch that does this?
- are there any other solutions (like periodically reconnect with a script) possible?

Sincerely yours

Erich Birrer-Uster

Birrer EDV-Beratung
Strategie > Organisation > Betrieb
Oberdürntnerstrasse 5a
8635 Dürnten
 
055 240 44 12
erich.birrer at birrer-edv.ch
www.birrer-edv.ch

-----Ursprüngliche Nachricht-----
Von: M.-A. Lemburg [mailto:mal at egenix.com] 
Gesendet: Montag, 29. August 2005 21:09
An: Erich Birrer-Uster
Cc: egenix-users at lists.egenix.com
Betreff: Re: [egenix-users] ProgrammingError

[egenix-users ist eine englischsprachige Liste, daher die Anwort
in Englisch]

> Ab und zu (aber leider immer wieder) tritt bei einer Anwendung folgender Fehler auf:
> 
>   	Site Error
> An error was encountered while publishing this resource. 
> mx.ODBC.Error.ProgrammingError
> Sorry, a site error occurred.
> Traceback (innermost last): 
> •	Module ZPublisher.Publish, line 163, in publish_module_standard
> •	Module Products.PlacelessTranslationService.PatchStringIO, line 51, in new_publish
> •	Module ZPublisher.Publish, line 108, in publish
> •	Module Zope.App.startup, line 226, in abort
> •	Module ZODB.Transaction, line 134, in abort
> •	Module Shared.DC.ZRDB.TM, line 63, in abort
> •	Module Products.mxODBCZopeDA.ZopeDA, line 1064, in _abort
> •	Module Products.mxODBCZopeDA.ZopeDA, line 939, in errorhandler
> ProgrammingError: ('HY000', 9114, '[Pervasive][ODBC Client Interface][Client LNA]Your connection to the server is no longer
working.
> To continue, disconnect from the data source and re-connect again. Contact your system administrator if you still need
assistance.',
> 1094) 

We have had similar reports from users with other driver/database
combinations. Unfortunately, there's nothing much we can do
about it since these errors are usually related to network
or timeout problems with the ODBC driver and database.

In the next release, we'll map the HY000 error to an OperationalError
which will then cause the Zope DA to try an automatic reconnect.

________________________________________
> Troubleshooting Suggestions
> •	The URL may be incorrect.
> •	The parameters passed to this resource may be incorrect.
> •	A resource that this resource relies on may be encountering an error.
> For more detailed information about the error, please refer to error log. 
> If the error persists please contact the site maintainer. Thank you for your patience. 
> 
> 
> Meine Installation sieht wie folgt aus:
> 
> Zope Version (unreleased version, python 2.3.3, win32)
> Python Version 2.3.3 (#51, Dec 18 2003, 20:22:39) [MSC v.1200 32 bit (Intel)]
> System Platform win32
> SOFTWARE_HOME C:\Programme\Plone 2\Zope\lib\python
> ZOPE_HOME C:\Programme\Plone 2\Zope
> INSTANCE_HOME C:\Programme\Plone 2\Data
> CLIENT_HOME C:\Programme\Plone 2\Data\var
> Network Services ZServer.HTTPServer.zhttp_server (Port: 8080) ZServer.HTTPServer.zhttp_server (Port: 80)
> 
> Connection Id  	 w-e3000  	 
> Connection Title 	e3000-DB 	 
> Database Connection Source 	DSN=webudc01 	 
> ODBC Manager/Driver 	Platform Default 	 
> Connection Information 	Connected database: Pervasive.SQL, 7.94
> ODBC driver: W3ODBCCI.DLL, 7.82.197 	 
> Database Timezone 	Local Time Zone 	 
> Connection Options 	
>     * Database Warnings are reported as Python exceptions.
>     * Connection uses transactions.
>     * Time columns are returned as DateTime values.
>     * Date/time columns are returned as Zope DateTime values.
>     * Short integers are fetched as short integers.
>     * NULL values are returned as None.
>     * Scale 0 floats are converted to integers.
>     * The first available result set is fetched in queries.
> Connection Pool 	Pool size: 20
> Physical connections: 1 open
> Connection State 	connected (since 2005/08/29 20:07:46.640 GMT+2)
> mxODBC Zope DA 1.0.8
> 
> Wo beginne ich am Besten mit der Fehlersuche?
> 
> Besten Dank für eure Tipps

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Aug 29 2005)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::