Re: Oracle 9i core dump on hp-ux

In article <a3e48067.0210080910.57ba7242_at_posting.google.com>, lyzh241_at_yahoo.com says...
>
>Hi,
>
>Currently I hit a core dump with Oracle9i on HP-UX11.Here are some
>info, can someone through me some light?
>This dump happens randomly.
>[Env]
>Os: HP-UX 11.11 for 9000/800 machine 64bit
>DB: Oracle 9i
>We are compile and link our code in 32bit mode, using Oracle 32bit
>library and running under HP-UX 64bit
>
>[Code]
>EXEC SQL
> INSERT INTO ESS_PRICE_SEGMENT
> (
> CPO_Id,
> Batch_Id,
> Batch_Index,
> Tariff_History_Id,
> Bill_Classification_Id,
> Billing_Currency_Amount,
> Price_segment_index,
> Data_Units,
> Data_Volume,
> Duration,
> GL_Reference,
> Price ,
> Active_Currency,
> Operational_Currency_Price,
> Start_Date_Time,
> Starting_Data_Volume,
> Tariff_Id
> )
> VALUES ( :pricedSegments[k].cpoId:pricedSegments_ind[k].cpoId,
> :pricedSegments[k].batchId:pricedSegments_ind[k].batchId,
> :pricedSegments[k].batchIndex:pricedSegments_ind[k].batchIndex,
> :pricedSegments[k].tariffHistoryId:pricedSegments_ind[k].tariffHistoryId,
>:pricedSegments[k].billClassificationId:pricedSegments_ind[k].billClassificationId,
>:pricedSegments[k].billingCurrencyAmount:pricedSegments_ind[k].billingCurrencyAmount,
>:pricedSegments[k].priceSegmentIndex:pricedSegments_ind[k].priceSegmentIndex,
> :pricedSegments[k].dataUnits:pricedSegments_ind[k].dataUnits,
> :pricedSegments[k].dataVolume:pricedSegments_ind[k].dataVolume,
> :pricedSegments[k].duration:pricedSegments_ind[k].duration,
> :pricedSegments[k].GLReference:pricedSegments_ind[k].GLReference,
> :pricedSegments[k].price:pricedSegments_ind[k].price,
> :pricedSegments[k].activeCurrency:pricedSegments_ind[k].activeCurrency,
>:pricedSegments[k].operational_currency_price:pricedSegments_ind[k].operational_currency_price,
> :pricedSegments[k].dateTime:pricedSegments_ind[k].dateTime,
>:pricedSegments[k].startingDataVolume:pricedSegments_ind[k].startingDataVolume,
> :pricedSegments[k].tariffId:pricedSegments_ind[k].tariffId);
>We use proc to convert code into c++ code.
>The converted code looks looks
>{
> struct sqlexd sqlstm;
> sqlstm.sqlvsn = 12;
> sqlstm.arrsiz = 38;
> sqlstm.sqladtp = &sqladt;
> sqlstm.sqltdsp = &sqltds;
> sqlstm.stmt = "insert into ESS_PRICE_SEGMENT
>(CPO_Id,Batch_Id,Batch_Ind\
>ex,Tariff_History_Id,Bill_Classification_Id,Billing_Currency_Amount,Price_segm\
>ent_index,Data_Units,Data_Volume,Duration,GL_Reference,Price,Active_Currency,O\
>perational_Currency_Price,Start_Date_Time,Starting_Data_Volume,Tariff_Id)
>valu\
>es (:b0:b1,:b2:b3,:b4:b5,:b6:b7,:b8:b9,:b10:b11,:b12:b13,:b14:b15,:b16:b17,:b1\
>8:b19,:b20:b21,:b22:b23,:b24:b25,:b26:b27,:b28:b29,:b30:b31,:b32:b33)";
>
>............
>
>sqlstm.sqptdso = sqlstm.sqtdso;
> sqlcxt(&context, &sqlctx, &sqlstm, &sqlfpn);
>}
>The dump happend on the last line sqlctx()
>
>[Stack]
>#0 0xc4ca3a70 in kghpmfal () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#1 0xc4ca3768 in kghfnd () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#2 0xc4ca45f4 in kghalo () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#3 0xc46b61c4 in kpuhhalo () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#4 0xc46b5fec in kpuridalo () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#5 0xc4b065b0 in ttcrd2r () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#6 0xc4afc858 in ttcrbur () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#7 0xc4afcbe8 in ttcbur () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#8 0xc4aec844 in ttcdrv () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#9 0xc49aa1e0 in nioqwa () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#10 0xc46eb110 in upirtrc () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#11 0xc475b870 in kpurcsc () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#12 0xc4717e58 in kpuexecv8 () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#13 0xc47190bc in kpuexec () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#14 0xc46c8148 in OCIStmtExecute () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#15 0xc467649c in sqlcucExecute () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#16 0xc4669788 in sqlall () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#17 0xc466d038 in sqlatm () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#18 0xc46578b4 in sqlnst () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#19 0xc4651378 in sqlcmex () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#20 0xc4651a1c in sqlcxt () from
>/sepro/parisora/u01/app/oracle/product/oracle9i/lib32/libclntsh.sl.9.0
>#21 0xc3056ec8 in StoreTariffHistory (cpo=0x416af2f8, conn=0x401ff460)
>at Sources/STESSQueries_sql.cpp:2448
>#22 0xc305416c in StoreCPO (cpo=0x416af2f8, conn=0x401ff460,
>cache=0x403a4ff0, essStore=0x7ad8ce50) at
>Sources/STESSQueries_sql.cpp:1883
>#23 0xc2dd9f98 in STEventStorageService::DS_INSERT_TRANSACTION
>(this=0x7ad8cd00, context=0x40055068, parentObject=0x403c2010,
>rule={conversionBuffer = 0x0, length = 12, currentSplitElement = 0,
>theString = 0x0, theSplitArray = 0x0, theFeatureArray = 0x0,
>automaticFeatures = ST_FALSE, localBuffer = "##ruleName##", '\000'
><repeats 51 times>, stringBufferLen = 64}) at
>Sources/SeproEventStorageService.cpp:429
>#24 0xc2ddfa50 in STEventStorageService::ProcessMessages
>(this=0x7ad8cd00, parentObject=0x403c2010, context=0x40055068) at
>Sources/SeproEventStorageService.cpp:1195
>#25 0xc2ddf7bc in ServiceProcessMessages (parentObject=0x403c2010,
>context=0x40055068) at Sources/SeproEventStorageService.cpp:1178
>#26 0xc2bb2ca4 in STMessageProcessor::RunThread (this=0x403c2010) at
>Sources/STMessageProcessor.cpp:508
>#27 0xc2da42c4 in STObject::ExecuteThreadBody (this=0x403c2010) at
>Sources/STObject.cpp:107
>#28 0xc2db5ef4 in SeproGlobalThreadCallback (objectPointer=0x403c2010)
>at Sources/STThread.cpp:130
>#29 0xc005aec8 in __pthread_body () from /usr/lib/libpthread.1
>#30 0xc0064494 in __pthread_start () from /usr/lib/libpthread.1
Form the stack, it looks like the fault is occurring on the Oracle side. Have you contacted Oracle support?

                                          Rick

                                Rick Wessman
                                Oracle Corporation

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.