最近数据库经常报ORA-07445错误:
2006-11-2111:39:56TueErrorsinfile/opt/oracle/admin/sc1/udump/sc1_ora_10025.trc:
2006-11-2111:39:56TueORA-07445:exceptionencountered:coredump[insart()+781][SIGSEGV][Addressnotmappedtoobject][0x4][][]
2006-11-2412:27:28FriErrorsinfile/opt/oracle/admin/sc1/udump/sc1_ora_28441.trc:
2006-11-2412:27:28FriORA-07445:exceptionencountered:coredump[kghalo()+1527][SIGSEGV][Addressnotmappedtoobject][0xDCCEAFB6][][]
……
摘录一些trace内容:
这是ORA-07445:exceptionencountered:coredump[insart()+781] 的
*** 2006-11-21 11:39:56.266
*** SESSION ID
9.36836) 2006-11-21 11:39:56.207
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x4, PC: [0x8e1aced, insart()+781]
Registers:
%eax: 0x00000028 %ebx: 0x00000049 %ecx: 0x79811340
%edx: 0x6a82bbe8 %edi: 0x00000000 %esi: 0x788c876c
%esp: 0xbfffc3e0 %ebp: 0xbfffc438 %eip: 0x08e1aced
%efl: 0x00010246
insart()+770 (0x8e1ace2) jmp 0x8e1ad54
insart()+772 (0x8e1ace4) mov 0xffffffb4(%ebp),%edx
insart()+775 (0x8e1ace7) mov 0x4c(%edx),%ecx
insart()+778 (0x8e1acea) mov (%ecx,%eax,4),%edi
> insart()+781 (0x8e1aced) movzw 0x4(%edi),%eax
insart()+785 (0x8e1acf1) mov 0x58(%edx),%ecx
insart()+788 (0x8e1acf4) mov (%ecx,%eax,4),%edx
insart()+791 (0x8e1acf7) test %edx,%edx
insart()+793 (0x8e1acf9) jz 0x8e1ae71
*** 2006-11-21 11:39:56.397
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [insart()+781] [SIGSEGV] [Address not mapped to object] [0x4] [] []
Current SQL statement for this session:
insert into ITEM (ITEM_CODE, ITEM_NAME, ITEM_SUMMARY, ITEM_IMAGE_URL, ITEM_REF_URL, ITEM_STATE, CREATE_DATE, INDEX_DATE, UPDA
TE_DATE, ITEM_CLICKCOUNT, FULL_TEXT_INDEX_STATE, ITEM_BRAND, ITEM_REGION, ITEM_Category, INFO_EXPIRED_DATE, START_DATE, PRICE
, SKU, MERCHANDISE_IN_STOCK, ITEM_DETAIL_DESCRIPTION, USER_ID, ITEM_TYPE, ITEM_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9
, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, 'm', :22)
这是ORA-07445:exceptionencountered:coredump[kghalo()+1527]的:
*** 2006-11-24 12:27:28.467
*** SESSION ID
49.50365) 2006-11-24 12:27:28.435
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xdcceafb6, PC: [0x9849d25, kghalo()+1527]
Registers:
%eax: 0x0ad58078 %ebx: 0x0a4b929c %ecx: 0x00002040
%edx: 0xdcceafb6 %edi: 0x0ad58fa0 %esi: 0x0ad57fa0
%esp: 0xbfffc5e8 %ebp: 0xbfffc654 %eip: 0x09849d25
%efl: 0x00010246
kghalo()+1517 (0x9849d1b) jmp 0x9849d27
kghalo()+1519 (0x9849d1d) mov 0x4(%eax),%edx
kghalo()+1522 (0x9849d20) mov (%eax),%eax
kghalo()+1524 (0x9849d22) mov %edx,0x4(%eax)
> kghalo()+1527 (0x9849d25) mov %eax,(%edx)
kghalo()+1529 (0x9849d27) mov 0xffffffa4(%ebp),%eax
kghalo()+1532 (0x9849d2a) mov 0xffffffbc(%ebp),%ecx
kghalo()+1535 (0x9849d2d) mov (%eax),%edx
kghalo()+1537 (0x9849d2f) and $0x3fffffc,%edx
*** 2006-11-24 12:27:28.584
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kghalo()+1527] [SIGSEGV] [Address not mapped to object] [0xDCCEAFB6] [] []
Current SQL statement for this session:
select it.TAG_ID tag_id,count(it.TAG_ID) count_Tag_id from item_tag it where it.ITEM_ID in (select item.ITEM_ID from Item ite
m where item.ITEM_TYPE ='p' and item.ITEM_CATEGORY='Êé' anditem.ITEM_STATE = 'PU'Anditem.UPDATE_DATE Is Not Null)
And It.tag_id In(select tag_id from tag_tag_group where tag_group_id in (select tag_group_id from tag_group where category_id
=13489)) group by it. TAG_ID
上metalink也查不出什么来(可能是我的查询方法有问题)
大家有遇到过这个问题吗?
我的环境是redhat as3 + oracle9204
|