博客

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/，如需转载，请注明出处，否则将追究法律责任。