Andre Reitz wrote:
Andre Reitz wrote:
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
Also som additional information:
My console where the multithreaded application runs:
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 -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_release: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_release: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_request: illegal reference: 214
ERR -11607 COMMUNIC sql03_release: illegal reference: 214
Speicherzugriffsfehler
... and sometimes I get this:
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 -11607 COMMUNIC sql03_request: illegal reference: 235
ERR -11607 COMMUNIC sql03_request: illegal reference: 235
ERR -11607 COMMUNIC sql03_request: illegal reference: 235
ERR -11607 COMMUNIC sql03_release: illegal reference: 235
Fatal Python error: GC object already in linked list
Abgebrochen
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
|