1) are you running the app on a multiprocessor server? 2) are your app threads synchronized (server side)?
3) is your app queries (server side) using locks during data manipulation? 4) what version of sapdb? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Gutknecht (SAPDB) Sent: Saturday, June 14, 2003 1:05 PM To: Olivier Fournier; sapdb Subject: RE: Please Help: Deadlock, Database is blocking I will throw my experience in... SAPDB protocol between client driver and server is not very robust. Our testing between Windows 2000 client (ODBC) <---> Windows 2000 Server or even <---> Linux server shows all kinds of problems. Stress testing (forced packet loss) reveals all kinds of problems. 1. Drivers stall waiting for a database server result that never comes. 2. ODBC driver DLL crashes. 3. One client session will bind up other concurrent sessions on the same driver. Stephen Gutknecht -----Original Message----- From: Olivier Fournier [mailto:[EMAIL PROTECTED] Sent: Saturday, June 14, 2003 2:08 AM To: sapdb Subject: RE: Please Help: Deadlock, Database is blocking hello, I have the same pblm with python but i think the program freeze if the link betwen the client and the server is broken during the connect it wait, wait, wait the response, a timeout shall be a good kind olivier fournier -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de Andre Reitz Envoy� : mardi 10 juin 2003 20:19 � : [EMAIL PROTECTED] Objet : Please Help: Deadlock, Database is blocking We have a big problem, We have a client-server Application running on sapdb with a multithreaded python server as a middleware. This means: one Multithreaded program which has several connections on the database (all under the same database user account). Our Problem: - Sometimes the System blocks The possible causes: (we think so) - We forgot a "commit" in our application - Sapdb runs out of free locks or any other resources Our Questions: - Is Isolation Level 1 (or 10) the default of the python driver? - Do selected rows also get locked in Isolation Level 1? - If they get locked, is there a limit (maximum of row locks) which can lead to the blocking because the system runs out of resources (or something similar)? (in other words:) - Our applications sends many many selects without a following commit/rollback. Only when data is inserted/updated/deleted, the clients send a commit/rollback. Is it possible that the selects will lead to a deadlock? - What about the parameter DEADLOCK_DETECTION (my value currently: 4)? does it use very much resources if i set it to a higher value? does it make sense to set it highter? Thank you very much in advance, Greetings and best regards, Andre' -- _____________________________________________ inworks GmbH Andre Reitz H�rvelsinger Weg 39 Tel. 0731/93 80 7-21 89081 Ulm http://www.inworks.de _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
