crash when trying to get snapshot size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steingold - 07 May 2006 08:04 GMT

Hi all
I have a multi-threaded application running on AIX 5.3 and DB2 8.2 that
takes snapshots from different threads. Each thread that takes snapshot
allocates an application context (using sqleBeginCtx), and frees it
when the thread goes down (using sqleEndCtx).
The application runs well for a while and after a couple of hours it
crashes when it tries to get the snapshot size. After the application
crashes at the first time, it keeps crashing until I restart the
database instance.

I attached at the end a code snippet and the core dump; I'll
appreciate any help with solving this issue.
TIA
YaronG

Reply to this Message

steingold - 07 May 2006 08:08 GMT

the code snippet :
RefPtr<SqlmaWrapper> sqlma = new SqlmaWrapper();
sqlma->setSnapshotType(snapshotType);
sqlma->setSnapshotParam(snapshotParam);
memset(&getSnapshotSizeParam,0,sizeof(getSnapshotSizeParam));
getSnapshotSizeParam.piSqlmaData = sqlma->getSqlma();
getSnapshotSizeParam.iVersion = SQLM_CURRENT_VERSION;
getSnapshotSizeParam.iNodeNumber = SQLM_ALL_NODES;
getSnapshotSizeParam.iSnapshotClass = SQLM_CLASS_DEFAULT;
getSnapshotSizeParam.poBufferSize = &buffer_sz;
db2GetSnapshotSize(db2Version820, &getSnapshotSizeParam, &sqlca);

Reply to this Message

steingold - 07 May 2006 08:09 GMT

the core dump:
sqlowque(??, ??, ??) at 0xdba71b3c
sqlccipcconnr__FP13sqlcc_connectP15sqlcc_comhandleP10sqlcc_cond(??, ??,
??) at 0xdbab938c
sqlccconnr__FP13sqlcc_connectP15sqlcc_comhandleP10sqlcc_cond(??, ??,
??) at 0xdbab3ec4
sqljrInternalConnect__FP11UCconHandleP13sqlcc_connectP10sqlcc_condPb(??,
??, ??, ??) at 0xdbb9e9f4
sqljrConnectCCLayer__FP11UCconHandle(??) at 0xdbb9e8fc
sqljrPreConnect__FP7UCintfcPP13sqljrDrdaArCb(??, ??) at 0xdbba06d8
sqljrDrdaArAuthenticate__FP7UCintfclPUl(??, ??, ??) at 0xdb9c5470
sqlexAppAuthenticate__FP7UCintfc__fdpr_1(??) at 0xdb9bfc48
sqljrDrdaArAttach__FP7UCintfc(??) at 0xdbaca860
sqleUCdrdaARinit__FP11UCconHandle(??) at 0xdb9fc2e4
sqleUCappAttach(??, ??, ??, ??, ??) at 0xdbaf2bb8
sqleatin__FPcN41sP5sqlca(??, ??, ??, ??, ??, ??, ??) at 0xdb9edaac
sqleimat__FPcT1iP5sqlca(??, ??, ??, ??) at 0xdb9ee084
sqleriar__FP10sqle_db2ra(??) at 0xdb9ef560
sqlm_send_est_buf_size_db2ra__FUlPUlP5sqlmasT1P5sqlca(0x7, 0x0,
0x20386190, 0xfffefffe, 0x0, 0x2) at 0xdbcec458
db2GetSnapshotSize(??, ??, ??) at 0xdbcebfe4

Reply to this Message