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

From: Pavel Lokhmakov <pavel_at_krasinfo.ru>
Date: 11 Apr 2004 21:25:12 -0700
Message-ID: <263e0b56.0404112025.77a942e1@posting.google.com>

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_at_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_at_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_at_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_at_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] [] []

Received on Sun Apr 11 2004 - 23:25:12 CDT