Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Re: Please Help! Pythondriver says: ERR -11608 COMMUNIC sql03_request: wron: msg#00297

db.maxdb

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

Andre Reitz wrote:
Dittmar, Daniel wrote:

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'



Please add some traces to vin77.c:requestReceive
#else
rc = i28requestForPython (session, NULL);
/* printf("<session %p>\n", session); */
+ printf("request: communication id: %d; threadid: %x; rc: %d\n",
+ session->reference, pthread_self (), rc);
if (rc == cin01_db_ok) {
Py_BEGIN_ALLOW_THREADS
rc = i28receiveForPython (session, NULL);
+ printf("receive: communication id: %d; threadid: %x; rc: %d\n",
+ session->reference, pthread_self (), rc);
/* printf("</session %p>\n", session); */
Py_END_ALLOW_THREADS
}

You need to include pthread.h somewhere in the file.

It could also be helpful to printf something in connect_sql:
printf ("Python object: %p\n", newObj) is hopefully the same hexid that
you get when printing a session object in python.
printf ("communication id: %d", newObj->nself->reference) would be the
same id that you output above.

Together, this might give some indication about which sessions are
having problems.



Hello, Daniel
This is not the Problem......


I did some more analyzing......
The Database sometimes seems to kick one thread with an error -8888.
Then my thread notifies the client and gets kicked.
Before it gets kicked the thread tries to disconnect the database:

try: self._connection.rollback()
except: pass
try:
_lock.acquire()
try: self._connection.release()
except: pass
finally:
_lock.release()
del self._connection


The complete thing gets killed by a segmentation fault.
It happens only in combination with the 8888 error.

I suspect that something in the destructor doesnt notice the
damaged connection and produces the seg-fault.


By the way: Why do I get the 700 Error
(700, 'Session inactivity timeout (work rolled back)', 'I888')

... an why is the string I888 and not I8888?

Greetings, Andre'


Thank you very much in advance for your help,
greetings, Andre'









By the way: What does the Garbagecollector with unclosed connections?



Sessions are closed when the last reference is dropped. This will send a
last ROLLBACK command to the kernel. So if a session gets released while
a command is pending, the error message above could happen. But unless
I've fouled up reference counting again, the session object should keep
at least one reference while in the execute call.

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




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation

Home | advertise | OSDir is an inevitable website. super tiny logo