ORA-07445: core dump [kpopfr()+673] [SIGFPE] [Integer divide by zero]

Fri Mar 21 15:13:30 2008
Errors in file /u01/oracle/admin/hpdb/udump/hpdb_ora_2328.trc:
ORA-07445: exception encountered: core dump [kpopfr()+673] [SIGFPE] [Integer divide by zero] [0x4000000001EB4AE1] [] []

看來今天運氣不錯,偶又見BUG.
正在和同事悠閒地吹牛,突然收到以上這個條這個資訊,下意識反映,su - oracle ;ps -ef | grep ora_.
hehe,一切還好,該在的都在.
根據alert.log資訊去看了一下trace.如下

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
ORACLE_HOME = /u01/oracle/product/10.2.0.3
System name:    HP-UX
Node name:      hpdb
Release:        B.11.23
Version:        U
Machine:        ia64
Instance name: hpdb
Redo thread mounted by this instance: 1
Oracle process number: 547
Unix process pid: 2328, image: oraclehpdb@hpdb

*** 2008-03-21 15:13:30.931
*** SERVICE NAME:(hpdb) 2008-03-21 15:13:30.795
*** SESSION ID:(767.2808) 2008-03-21 15:13:30.795
Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero), addr: 0x4000000001eb4ae1, PC: [0x4000000001eb4ae1, kpopfr()+6
73]
  r1: 60000000000a8128       r20: 9fffffff7fbaa744       br5:                0
  r2:                0       r21:             46e0       br6: c00000000033a6f0
  r3:            1825d       r22: 9fffffff7fba60a0       br7: e0000000014a17e0
  r4:                0       r23:                0        ip: 4000000001eb4ae1
  r5: c000000000000408       r24:         42222008      iipa: c000000450ec02e0
  r6: c0000000000500e0       r25:                0       cfm:                8
  r7: 9fffffff7fff8e48       r26:             6e40        um:               1a
  r8:        100000000       r27: 6000000000232ab1       rsc:               1f
  r9:          2000000       r28:        37485637f       bsp: 9fffffff7ffffd58
 r10: 9fffffff7fbaa784       r29:            22c24  bspstore: 9fffffff7ffffd58
 r11:                0       r30: c00000048b338dd8      rnat: 4000000002dc7660
 r12: 9fffffffffff73e0       r31: c000000000001028       ccv:                0
 r13: 9fffffff7fc65420      NaTs:                0      unat:                0
 r14:                0       PRs:            183d3      fpsr:    9804c8a74433f
 r15:                0       br0: 4000000001eb8700       pfs: c00000000000099b
 r16: 600000000003ffd0       br1: 400000000b63cd70        lc:                0
 r17: 9fffffffffff7480       br2:                0        ec:                0
 r18:             46e4       br3:                0       isr: 9fffffff7ffffd58
 r19:             46a4       br4:                0       ifa: c00000047352e180
Reason code: 002c
*** 2008-03-21 15:13:30.972
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kpopfr()+673] [SIGFPE] [Integer divide by zero] [0x4000000001EB4AE1] [] []
Current SQL statement for this session:
select highgroup, itgroup, studentgroup, defaultlang, openstatus, rsmname, isdefault, readednumber from s_reme where userid
=:x1
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64          call     0000000000000001     000000001 ? 000000001 ?
ksedmp()+2160        call     0000000000000001     000000001 ?
                                                   C000000000000C9F ?
                                                   400000000510CAA0 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ?
ssexhd()+1280        call     0000000000000001     000000003 ?
                                                   9FFFFFFFFFFEDFA0 ?
                                                   60000000000A8128 ?
                                                   9FFFFFFFFFFEE570 ?
                                                   C000000000000B9F ?
                                                   4000000003D863C0 ?
                                                   00001905D ?
                                                   60000000000B33D8 ?
             call     0000000000000001     C00000048A45E078 ?
                                                   60000000000B5268 ?
                                                   C000000440007728 ?
                                                   60000000000A8128 ?
kpopfr()+673         call     0000000000000001     9FFFFFFFFFFF2400 ?

 

在trace中看到一條SQL,難道是這條SQL造成的? 不像呀,這麼簡單的一條SQL.於是想看下Cause和oracle給出的Action資訊

oracle@hpdb:/home/oracle #oerr ora 07445
07445, 00000, "exception encountered: core dump [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause: An OS exception occurred which should result in the creation of a
//         core file.  This is an internal error.
// *Action: Contact your customer support representative.

差點眼鏡跌下來,oracle就是牛比,將錯誤推薦到OS上去了,看下OS日誌,沒有任何錯誤.

會不會是oracle的BUG呀?

到metalink上一看,哈哈,果然是中獎了.(Note:421203.1,Note:468274.1),哎,啥也不說了,繼續用吧,只要不當機就Thanks Goodness!

Subject:  ORA-7445 [KPOPFR] [SIGFPE] [INTEGER DIVIDE BY ZERO] When Repeatedly Executing a Query
  Doc ID:  Note:421203.1 Type:  PROBLEM
  Last Revision Date:  09-JUL-2007 Status:  PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

--------------------------------------------------------------------------------

@ (AuthWiz 2.5.2) Created from SR 6149439.992
@ Click here to edit in wizard.  

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.

Symptoms
1. Repeatedly executing a query can lead to the following error:

ORA-7445 [kpopfr] [SIGFPE] [INTEGER DIVIDE BY ZERO]

2. The call stack from the ORA-07445 trace file should contain the following functions:

kposdi  kpopsdi

 

 

Cause
The error is caused by Bug 5753629.

Abstract: QUERY FAILS BY ORA-7445 [KPOPFR]

Repeatedly executing a query can lead to an ORA-7445[kpopfr] error.

Solution
To implement the solution, do one of the following:

1. Upgrade to 11.1 or 10.2.0.4, when available. At the time of writing the article these version were not yet available. (July 2007).

2. Apply one-off Patch 5753629 from MetaLink, if available for your platform. and version.

There is no known workaround available for this bug.

References
Bug 5753629 - QUERY FAILS BY ORA-7445 [KPOPFR].

Errors
ORA-7445[KPOPFR]
ORA-7445 "exception encountered: core dump [%s] [%s]"

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7364032/viewspace-214940/，如需轉載，請註明出處，否則將追究法律責任。