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

"Pavel Lokhmakov" <pavel_at_krasinfo.ru> wrote in message news:263e0b56.0404112025.77a942e1_at_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] [] []

raise a tar Received on Mon Apr 12 2004 - 04:57:56 CDT