Oracle 9i on Red Hat 9 crash with SIGSEGV periodicaly.

Giganews Newsgroups
Subject: Oracle 9i on Red Hat 9 crash with SIGSEGV periodicaly.
Posted by:  Pavel Lokhmakov (pav…@krasinfo.ru)
Date: 11 Apr 2004

Hi.

Every half hour in database INSERT one record as:

INSERT INTO askue.telemetry_counters (tc_time, tc_ti, tc_p, tc_tele)
VALUES (TO_DATE('2004-04-12, 02:30:00 AM','RRRR-MM-DD, HH:MI:SS AM'),
1, 0, 73)

And one time in month Oracle crash with SIGSEGV.

First incident.

-- Part of alert_ASKUE.log

Fri Mar 19 07:40:49 2004
Errors in file /opt/oracle/admin/askue/udump/askue_ora_13032.trc:
ORA-07445: exception encountered: core dump [kgldafr()+33] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Fri Mar 19 07:40:53 2004
Errors in file /opt/oracle/admin/askue/bdump/askue_pmon_3514.trc:
ORA-07445: exception encountered: core dump [kgldafr()+33] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Fri Mar 19 07:41:20 2004
LGWR: terminating instance due to error 472
Instance terminated by LGWR, pid = 3518

-- Part of askue_ora_13032.trc (1 273 243 bytes)

/opt/oracle/admin/askue/udump/askue_ora_13032.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name:    Linux
Node name:    askue
Release:    2.4.20-8
Version:    #1 Thu Mar 13 17:54:28 EST 2003
Machine:    i686
Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 13032, image: oracle@askue (TNS V1-V3)

*** 2004-03-19 07:40:49.216
*** SESSION ID:(50.33965) 2004-03-19 07:40:49.101
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x8000008, PC: [0x95ffb11, kgldafr()+33]
Registers:
%eax: 0x08000000 %ebx: 0x0ab941ac %ecx: 0x0ab111a0
%edx: 0x00000002 %edi: 0x08000000 %esi: 0x0ab111a0
%esp: 0xbfff9360 %ebp: 0xbfff9378 %eip: 0x095ffb11
%efl: 0x00010202
  kgldafr()+21 (0x95ffb05) mov 0x8(%ebp),%esi
  kgldafr()+24 (0x95ffb08) mov 0xc(%ebp),%edi
  kgldafr()+27 (0x95ffb0b) mov 0x18(%ebp),%edx
  kgldafr()+30 (0x95ffb0e) and $2,%edx
> kgldafr()+33 (0x95ffb11) mov $0x0,0x8(%edi)
  kgldafr()+40 (0x95ffb18) movb $0x0,0x6(%edi)
  kgldafr()+44 (0x95ffb1c) cmp $0,(%edi)
  kgldafr()+47 (0x95ffb1f) jz 0x95ffbe0
  kgldafr()+53 (0x95ffb25) testb $0x3,0xc(%edi)
*** 2004-03-19 07:40:49.400
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgldafr()+33] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Current SQL statement for this session:
INSERT INTO askue.telemetry_counters (tc_time, tc_ti, tc_p, tc_tele)
VALUES (TO_DATE('2004-03-18, 12:00:00 PM','RRRR-MM-DD, HH:MI:SS AM'),
1, 0.803, 84)

-- Part of askue_pmon_3514.trc (askue_pmon_3514.trc)

/opt/oracle/admin/askue/bdump/askue_pmon_3514.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name:    Linux
Node name:    askue
Release:    2.4.20-8
Version:    #1 Thu Mar 13 17:54:28 EST 2003
Machine:    i686
Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 3514, image: oracle@askue (PMON)

*** 2004-03-19 07:40:53.796
*** SESSION ID:(1.1) 2004-03-19 07:40:53.674
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x8000008, PC: [0x95ffb11, kgldafr()+33]
Registers:
%eax: 0x08000000 %ebx: 0x0ab941ac %ecx: 0x0ab111a0
%edx: 0x00000000 %edi: 0x08000000 %esi: 0x0ab111a0
%esp: 0xbfffdc50 %ebp: 0xbfffdc68 %eip: 0x095ffb11
%efl: 0x00010246
  kgldafr()+21 (0x95ffb05) mov 0x8(%ebp),%esi
  kgldafr()+24 (0x95ffb08) mov 0xc(%ebp),%edi
  kgldafr()+27 (0x95ffb0b) mov 0x18(%ebp),%edx
  kgldafr()+30 (0x95ffb0e) and $2,%edx
> kgldafr()+33 (0x95ffb11) mov $0x0,0x8(%edi)
  kgldafr()+40 (0x95ffb18) movb $0x0,0x6(%edi)
  kgldafr()+44 (0x95ffb1c) cmp $0,(%edi)
  kgldafr()+47 (0x95ffb1f) jz 0x95ffbe0
  kgldafr()+53 (0x95ffb25) testb $0x3,0xc(%edi)
*** 2004-03-19 07:40:53.830
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgldafr()+33] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []

--

Second incident.

-- Part of alert_ASKUE.log

Mon Apr 12 02:40:03 2004
Errors in file /opt/oracle/admin/askue/udump/askue_ora_20128.trc:
ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Mon Apr 12 02:40:07 2004
Errors in file /opt/oracle/admin/askue/bdump/askue_pmon_5771.trc:
ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
Mon Apr 12 02:40:56 2004
CKPT: terminating instance due to error 472
Instance terminated by CKPT, pid = 5777

-- Part of askue_ora_20128.trc (1 273 243 bytes)

/opt/oracle/admin/askue/udump/askue_ora_20128.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name:    Linux
Node name:    askue
Release:    2.4.20-8
Version:    #1 Thu Mar 13 17:54:28 EST 2003
Machine:    i686
Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 20128, image: oracle@askue (TNS V1-V3)

*** SESSION ID:(9.29464) 2004-04-12 02:40:02.769
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x8000008, PC: [0x9609de0, kglhdde()+144]
Registers:
%eax: 0x08000000 %ebx: 0x0ab941ac %ecx: 0x00000000
%edx: 0x0ab111a0 %edi: 0x53f66bec %esi: 0x00000001
%esp: 0xbfff8d70 %ebp: 0xbfff8d88 %eip: 0x09609de0
%efl: 0x00010202
  kglhdde()+131 (0x9609dd3) jmp 0x9609dfc
  kglhdde()+133 (0x9609dd5) test %esi,%esi
  kglhdde()+135 (0x9609dd7) je 0x9609df0
  kglhdde()+137 (0x9609dd9) lea 0x0(%esi),%esi
> kglhdde()+144 (0x9609de0) movb 0x8(%eax),%dl
  kglhdde()+147 (0x9609de3) orb %dl,0xffffffff(%ebp)
  kglhdde()+150 (0x9609de6) add $12,%eax
  kglhdde()+153 (0x9609de9) dec %esi
  kglhdde()+154 (0x9609dea) jnz 0x9609de0
*** 2004-04-12 02:40:02.999
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []
No current SQL statement being executed.

-- Part of askue_ora_pmon_5771.trc (816 284 bytes)

/opt/oracle/admin/askue/bdump/askue_pmon_5771.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name:    Linux
Node name:    askue
Release:    2.4.20-8
Version:    #1 Thu Mar 13 17:54:28 EST 2003
Machine:    i686
Instance name: ASKUE
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 5771, image: oracle@askue (PMON)

*** 2004-04-12 02:40:07.007
*** SESSION ID:(1.1) 2004-04-12 02:40:06.865
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x8000008, PC: [0x9609de0, kglhdde()+144]
Registers:
%eax: 0x08000000 %ebx: 0x0ab941ac %ecx: 0x00000000
%edx: 0x0ab111a0 %edi: 0x53f66bec %esi: 0x00000001
%esp: 0xbfffcfc0 %ebp: 0xbfffcfd8 %eip: 0x09609de0
%efl: 0x00010202
  kglhdde()+131 (0x9609dd3) jmp 0x9609dfc
  kglhdde()+133 (0x9609dd5) test %esi,%esi
  kglhdde()+135 (0x9609dd7) je 0x9609df0
  kglhdde()+137 (0x9609dd9) lea 0x0(%esi),%esi
> kglhdde()+144 (0x9609de0) movb 0x8(%eax),%dl
  kglhdde()+147 (0x9609de3) orb %dl,0xffffffff(%ebp)
  kglhdde()+150 (0x9609de6) add $12,%eax
  kglhdde()+153 (0x9609de9) dec %esi
  kglhdde()+154 (0x9609dea) jnz 0x9609de0
*** 2004-04-12 02:40:07.038
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kglhdde()+144] [SIGSEGV]
[Address not mapped to object] [0x8000008] [] []

Replies