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

>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.

> 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

-- 
Daniel Dittmar
SAP Labs Berlin
daniel.dittmar@xxxxxxx  

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