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/[EMAIL PROTECTED]





--
__________________________________________________________________________

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/[EMAIL PROTECTED]



Reply via email to