Re: Please Help! Pythondriver says: ERR -11608 COMMUNIC sql03_request: wrong connection state, state is 'requested'

Robert Klemme wrote:
> Hi,
>
> just from gut feeling: this sounds like an improper synchronization in the
> application layer.  Maybe you're using the same connection from two
> different threads at the same time.  Just my 0.02EUR.
Im am completely sure that I dont do this.

But thank you for the hint,

By the way: What does the Garbagecollector with unclosed connections?
Does this anybody (Daniel Dittmar :-)) know?


Greetings, Andre'



> HTH
>
> robert
>
>
> > Hello all,
> >
> > We are using a multithreaded python application as a middleware
> > to the database.
> >
> > sometimes (when many clients are working intensively at the same time)
> > I get the following error to the console of the server:
> >
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> > ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> > 'requested'
> >
> > The main python process (we are using python 2.2.3 on a suse 7.3 system
> > which uses libpthread)
> > suddenly disappears (gets killed because of an evil error in the python
> > driver?)
> >
> > We are using
> > - sapdb-srv74-7.4.3.27-1   (database is on the same server like the
> > middleware)
> >
> > I suspect a problem with the thead-safity of the python-driver.
> >
> >
> > Additional information:
> >
> > - Each thread has its own connection-object
> > - Threads do *not* share connections or cursors
> > - before opening or releasing a connection we aquiere a threading.lock.
> >
> > What could the problem be?
> >
> > Does it help if we upgrade the database server to
> > 7.4.3.32?
> >
> > Thank you very much in advane for your Help.
> >
> > Greetings, Andre' Reitz
> >
> > --
> > MaxDB Discussion Mailing List
> > For list archives: http://lists.mysql.com/maxdb
> > To unsubscribe:    http://lists.mysql.com/maxdb?unsub=bob.news@xxxxxxx


--
__________________________________________________________________________

Als Technologieunternehmen konzipieren und entwickeln wir maßgeschneiderte 
Feedback- und
Monitoring-Systeme - wie beispielsweise Lösungen für Beschwerde- und 
Ideenmanagement.
Mit dem Inquery® Survey Server bieten wir eine der leistungsfähigsten 
Standardlösungen für
Online-Umfragen mit dem Schwerpunkt auf der Messung von Kundenzufriedenheit an.
__________________________________________________________________________


Inworks GmbH
Andre Reitz, Leiter Entwicklung
Hörvelsinger Weg 39, 89081 Ulm, Germany
Tel +49 (0) 731 / 93807-21
Fax +49(0)731/93807-18
Internet: http://www.inworks.de



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx