Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle 9i core dump on hp-ux

Oracle 9i core dump on hp-ux

From: LYZh <lyzh241_at_yahoo.com>
Date: 8 Oct 2002 10:10:34 -0700
Message-ID: <a3e48067.0210080910.57ba7242@posting.google.com> 





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
Received on Tue Oct 08 2002 - 12:10:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US