5 Replies Latest reply: May 1, 2012 10:03 AM by Laurenfoutz-Oracle RSS

    Locking error with BDSQL 5.2.36

    user11188564
      I am using BDB 5.2.36 . My application uses the SQL interface and has multiple process & some of the processes have multiple threads. Occasionally, pne of the threads get stuck with the following stack trace -

      0: 60000000c01e2930 : __lwp_cond_wait_sys() + 0x30 (/lib/hpux32/libpthread.so.1)
      1: 60000000c00f99c0 : __pthread_cond_wait_spin() + 0x7b0 (/lib/hpux32/libpthread.so.1)
      2: 60000000c00f57c0 : pthread_cond_wait() + 0x2660 (/lib/hpux32/libpthread.so.1)
      3: 60000000c00f3230 : pthread_cond_wait() + 0xd0 (/lib/hpux32/libpthread.so.1)
      4: 60000000d0618ff0 : __db_pthread_mutex_lock() + 0x8b0 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      5: 60000000d06c1b50 : __lock_get_internal() + 0x3280 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      6: 60000000d0988be0 : __lock_get_api() + 0x520 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      7: 60000000d09884b0 : __lock_get_pp() + 0x690 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      8: 60000000d0c8b570 : btreeDbHandleLock() + 0x3f0 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      9: 60000000d0c8a6d0 : btreeCleanupCachedHandles() + 0x960 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      10: 60000000d0c9a4c0 : sqlite3BtreeBeginTrans() + 0x3c0 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      11: 60000000d0d12680 : sqlite3VdbeExec() + 0x11230 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      12: 60000000d0cfde90 : sqlite3Step() + 0x410 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      13: 60000000d0cfbc60 : sqlite3_step() + 0x180 (/opt/fin/unn/lib/libdb_sql-5.2.so)
      14: 00000000005735e0 : DbStatement::step()() at DbStatement.cpp:119
      15: 0000000000631e60 : LoglNode::get(sdm_ln_ds&) const() at LoglNode.cpp:81
      16: 000000000058b060 : getLoglNode(sdm_ln_ds&)() at SandmAccessApi.cpp:1048
      17: 0000000000590350 : getPhysIdentFromLoglIdent(int,int&)() at SandmAccessApi.cpp:1287
      18: 000000000038a6b0 : UNNLifeSignal::Run()() at /opt/aCC/include_std/memory:250
      19: 60000000d2feb9d0 : SwMTThread::ThreadFunction(void*)() + 0x3b0 (/opt/fin/unn/otherlib/libswfrmcom.so)
      20: 60000000c010f6e0 : __pthread_bound_body() + 0x190 (/lib/hpux32/libpthread.so.1)


      I was wondering whether the change #20862 (in 5.3.15) addresses this issue. Will appreciate if you could give me the patch.


      Regards,

      Rittick