SAPDB Dumping core
"Chandrasekaran x" <[email protected]> Wed, 10 Sep 2003 19:32:39 +0500
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Organization | Lycos Mail (http://www.mail.lycos.com:80) |
| Message-ID | <[email protected]> |
Dear All, In our multi-threaded Red Hat Linux (Version 7.1) based application, We declare static cursors with equal condition in where clause. While fetching data from database using these cursors, our application dumps core in FETCH statements frequently. We enabled the precompiler trace ( long trace ) for our application and found that, "SQLCODE: -602 System error: AK Datapart too short" error in precompiler trace file for FETCH statements. For some Fetch statement, mfIndex init is negative ( mfIndex init : -32757 ) and in such cases, our application dumps core and we have "ERR -11607 COMMUNIC sql03_receive: illegal reference: 0" error logged in appldiag file. For the above mentioned communication and system error, SAPDB error messages pdf file says that the database is in inconsistent state and we have to shutdown the database and contact the SAP LABS. This is happening in our client place. So please help us to solve the problem. The stack entries from the core dump is as follows: gdb output of core: #0 0x0821d234 in p01bmfentryadd () #1 0x0821b8bf in p01baparsen () #2 0x08205ef3 in pr01cParse () #3 0x0820552a in pr01cEnd () #4 0x0820c0fc in pr01SQLExecute () #5 0x0820a03c in pr01PrecomExecute () #6 0x08202b7f in sqlCPCExecute () When we went a little deeper, we found that the "p04trint2" function is causing the problem. Is there a problem with this function in SAPDB? If so, do we have any workaround for this? Moreover, Can anyone help us on the following : 1. What is the Maximum limit for FETCH statements that can be executed in a single connection? 2. What is the Meaning of mfIndex init variable used in precompiler trace ? 3. In which case will we get "System error: AK Datapart too short" and "COMMUNIC sql03_receive: illegal reference: 0" error ? Can any one throw some light please ? Regards Chandar ____________________________________________________________ Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005