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

Dittmar, Daniel wrote:
> > By the way: Why do I get the 700 Error
> > (700, 'Session inactivity timeout (work rolled back)', 'I888')
>
>
> When the connection is broken and the driver can reconnect, a timeout is
> assumed as there is no way of knowing what was the real reasong for the
> disconnect.

so I am pretty sure that there is a big bug uin the python-driver
(Perhaps a threading-proble or a global variable , ....)

could you please give me a hint where the problem could be located?

It most times starts with an I8888

and then it comes to a segfault.

the server says that it is the applications fault:

2005-02-28 17:34:43 17809     11561 COMMUNIC Connecting T37 gemini.intra 752
2005-02-28 17:34:43 17851     11561 COMMUNIC Connected  T37 gemini.intra 752
2005-02-28 17:34:49 17809     11561 COMMUNIC Connecting T38 gemini.intra 752
2005-02-28 17:34:49 17847     11561 COMMUNIC Connected  T38 gemini.intra 752
2005-02-28 17:34:53 17809     11561 COMMUNIC Connecting T39 gemini.intra 752
2005-02-28 17:34:53 17848     11561 COMMUNIC Connected  T39 gemini.intra 752
2005-02-28 17:34:59 17809     11561 COMMUNIC Connecting T40 gemini.intra 752
2005-02-28 17:34:59 17847     11561 COMMUNIC Connected  T40 gemini.intra 752
2005-02-28 17:35:00 17809     11561 COMMUNIC Connecting T41 gemini.intra 752
2005-02-28 17:35:00 17850     11561 COMMUNIC Connected  T41 gemini.intra 752
2005-02-28 17:35:02 17809     11561 COMMUNIC Connecting T42 gemini.intra 752
2005-02-28 17:35:02 17851     11561 COMMUNIC Connected  T42 gemini.intra 752
2005-02-28 17:35:02 17809     11561 COMMUNIC Connecting T43 gemini.intra 752
2005-02-28 17:35:02 17852     11561 COMMUNIC Connected  T43 gemini.intra 752
2005-02-28 17:35:03 17809     11561 COMMUNIC Connecting T44 gemini.intra 752
2005-02-28 17:35:03 17847     11561 COMMUNIC Connected  T44 gemini.intra 752
2005-02-28 17:35:04 17809     11561 COMMUNIC Connecting T45 gemini.intra 752
2005-02-28 17:35:04 17854     11561 COMMUNIC Connected  T45 gemini.intra 752
2005-02-28 17:35:04 17848     11509 COMMUNIC Connection broken by appl state 10 T38   
<<<<<<<<---------
2005-02-28 17:35:04 17848 WNG 11824 COMMUNIC Releasing  T38 connection aborted
2005-02-28 17:35:04 17848     12929 TASKING  Task T38 started
2005-02-28 17:35:04 17848     11007 COMMUNIC wait for connection T38
2005-02-28 17:35:04 17847     11509 COMMUNIC Connection broken by appl state 10 
T37
2005-02-28 17:35:04 17847 WNG 11824 COMMUNIC Releasing  T37 connection aborted
2005-02-28 17:35:04 17847     12929 TASKING  Task T37 started
2005-02-28 17:35:04 17847     11007 COMMUNIC wait for connection T37
2005-02-28 17:35:04 17852     11509 COMMUNIC Connection broken by appl state 10 
T42
2005-02-28 17:35:04 17852 WNG 11824 COMMUNIC Releasing  T42 connection aborted
2005-02-28 17:35:04 17852     12929 TASKING  Task T42 started
2005-02-28 17:35:04 17852     11007 COMMUNIC wait for connection T42
2005-02-28 17:35:04 17849     11509 COMMUNIC Connection broken by appl state 10 
T39
2005-02-28 17:35:04 17849 WNG 11824 COMMUNIC Releasing  T39 connection aborted
2005-02-28 17:35:04 17849     12929 TASKING  Task T39 started
2005-02-28 17:35:04 17849     11007 COMMUNIC wait for connection T39
2005-02-28 17:35:04 17850     11509 COMMUNIC Connection broken by appl state 10 
T40
2005-02-28 17:35:04 17850 WNG 11824 COMMUNIC Releasing  T40 connection aborted
2005-02-28 17:35:04 17850     12929 TASKING  Task T40 started
2005-02-28 17:35:04 17850     11007 COMMUNIC wait for connection T40
2005-02-28 17:35:04 17851     11509 COMMUNIC Connection broken by appl state 10 
T41
2005-02-28 17:35:04 17851 WNG 11824 COMMUNIC Releasing  T41 connection aborted
2005-02-28 17:35:04 17851     12929 TASKING  Task T41 started
2005-02-28 17:35:04 17851     11007 COMMUNIC wait for connection T41
2005-02-28 17:35:04 17854     11509 COMMUNIC Connection broken by appl state 10 
T44
2005-02-28 17:35:04 17854 WNG 11824 COMMUNIC Releasing  T44 connection aborted
2005-02-28 17:35:04 17854     12929 TASKING  Task T44 started
2005-02-28 17:35:04 17854     11007 COMMUNIC wait for connection T44
2005-02-28 17:35:04 17855     11509 COMMUNIC Connection broken by appl state 10 
T45
2005-02-28 17:35:04 17855 WNG 11824 COMMUNIC Releasing  T45 connection aborted
2005-02-28 17:35:04 17855     12929 TASKING  Task T45 started
2005-02-28 17:35:04 17855     11007 COMMUNIC wait for connection T45
2005-02-28 17:35:04 17853     11509 COMMUNIC Connection broken by appl state 10 
T43
2005-02-28 17:35:04 17853 WNG 11824 COMMUNIC Releasing  T43 connection aborted
2005-02-28 17:35:04 17853     12929 TASKING  Task T43 started
2005-02-28 17:35:04 17853     11007 COMMUNIC wait for connection T43



Thank you very much in advance,
greetings, andre

> > ... an why is the string I888 and not I8888?
>
>
> Because of an error in vin77.c:raiseSQLError. sizeof (sqlStateStr) is
> being used, but sizeof (tsp00_C5) would be the right thing, as
> sqlStateStr is an pointer. This has been already fixed in 7.5.
>
> Daniel Dittmar


--
__________________________________________________________________________

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