Customer hit a non-severe log full error and DB2 crashed:
2014-02-27-14.43.53.095786-480 I905588A593 LEVEL: Error
PID : 18546702 TID : 22552 PROC :
db2sysc 0
INSTANCE: dbboss01 NODE : 000 DB :
BOSSPROD
APPHDL : 0-57714 APPID: GA01F447.B5E0.140227223720
AUTHID : BOSSPROD HOSTNAME: scldbbos01u
EDUID : 22552 EDUNAME: db2agent (BOSSPROD) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteLR,
probe:6680
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
2014-02-27-14.44.04.151471-480 I5853424A2683 LEVEL:
Severe
PID : 18546702 TID : 22552 PROC :
db2sysc 0
INSTANCE: dbboss01 NODE : 000 DB :
BOSSPROD
APPHDL : 0-57714 APPID: GA01F447.B5E0.140227223720
AUTHID : BOSSPROD HOSTNAME: scldbbos01u
EDUID : 22552 EDUNAME: db2agent (BOSSPROD) 0
FUNCTION: DB2 UDB, data management,
sqldFindRidFromPageCacheComplex,
probe:4421
MESSAGE : ZRC=0x87040055=-2029780907=SQLD_PRGERR "Unknown
PROGRAM ERROR"
DIA8576C A data management services programming error
occurred.
DATA #1 : String, 20 bytes
Invalid append cache
DATA #2 : unsigned integer, 8 bytes
0
DATA #3 : unsigned integer, 8 bytes
1
DATA #4 : unsigned integer, 8 bytes
4
CALLSTCK: (Static functions may not be resolved correctly, as
they are
resolved to the nearest symbol)
[0] 0x090000000767FBA4
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
TABLE_CA
CHET3 + 0xB1C
[1] 0x090000000767F384
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
TABLE_CA
CHET3 + 0x2FC
[2] 0x0900000007694114
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
TABLE_CA
CHET3 + 0x1400
[3] 0x0900000007692824 sqldInsertRow__FP13SQLD_DFM_WORKi +
0x3FC
[4] 0x090000000768CED0
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
0xB8C
[5] 0x0900000007699288
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
oFlags17
t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xBC
[6] 0x09000000076994E4 sqlriisr__FP8sqlrr_cb + 0x184
[7] 0x09000000078FFBCC
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x448
[8] 0x0900000008246590
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interfac
e + 0x3C7C
[9] 0x09000000082434E4
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interfac
e + 0xBD0
[10] 0x0900000008243810
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interfac
e + 0xEFC
[11] 0x090000000824D030
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x9C8
[12] 0x090000000824D030
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x9C8
[13] 0x090000000824CC3C
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x5D4
[14] 0x090000000904F240
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[15] 0x090000000904FD2C
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5E0
[16] 0x0900000007228210 RunEDU__8sqeAgentFv + 0x465D0
[17] 0x0900000007170624 RunEDU__8sqeAgentFv + 0xD8
[18] 0x0900000007F1D10C EDUDriver__9sqzEDUObjFv + 0x110
[19] 0x090000000719CC78 sqloEDUEntry + 0x38C
[20] 0x0900000000728E10 _pthread_body + 0xF0
[21] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2014-02-27-14.44.07.480016-480 I6556429A536 LEVEL:
Severe
PID : 18546702 TID : 22552 PROC :
db2sysc 0
INSTANCE: dbboss01 NODE : 000 DB :
BOSSPROD
APPHDL : 0-57714 APPID: GA01F447.B5E0.140227223720
AUTHID : BOSSPROD HOSTNAME: scldbbos01u
EDUID : 22552 EDUNAME: db2agent (BOSSPROD) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler,
probe:10
MESSAGE : DIA0505I Execution of a component signal handling
function has begun.
2014-02-27-14.47.12.800637-480 I9676984A2444 LEVEL: Info
PID : 18546702 TID : 29147 PROC :
db2sysc 0
INSTANCE: dbboss01 NODE : 000 DB :
BOSSPROD
APPHDL : 0-57449 APPID: GA01F447.B3DE.140227221250
AUTHID : BOSSPROD HOSTNAME: scldbbos01u
EDUID : 29147 EDUNAME: db2agent (BOSSPROD) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeLocalDatabase::ForceDBShutdown, probe:15039
MESSAGE : Regular agent EDU doing ForceDBShutdown. Force DB
shutdown agent ID
is:
DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes
0-57449
DATA #2 : sqeApplication_acbInfo,
PD_TYPE_sqeApplication_acbInfo, 4 bytes
x0
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x0900000008FE7CB0 ForceDBShutdown__16sqeLocalDatabaseFi +
0xC64
[1] 0x090000000A55F994
sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x9CC
[2] 0x090000000767B4CC
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
0x6D74
[3] 0x090000000768CA84
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
0x740
[4] 0x0900000007699288
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xBC
[5] 0x09000000076994E4 sqlriisr__FP8sqlrr_cb + 0x184
[6] 0x09000000078FFBCC
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x448
[7] 0x0900000008246590
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x3C7C
[8] 0x09000000082434E4
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0xBD0
[9] 0x0900000008243810
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0xEFC
[10] 0x090000000824D030
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x9C8
[11] 0x090000000824D030
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x9C8
[12] 0x090000000824CC3C
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x5D4
[13] 0x090000000904F240
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[14] 0x090000000904FD2C
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5E0
[15] 0x0900000007228210 RunEDU__8sqeAgentFv + 0x465D0
[16] 0x0900000007170624 RunEDU__8sqeAgentFv + 0xD8
[17] 0x0900000007F1D10C EDUDriver__9sqzEDUObjFv + 0x110
[18] 0x090000000719CC78 sqloEDUEntry + 0x38C
[19] 0x0900000000728E10 _pthread_body + 0xF0
[20] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2014-02-27-15.04.15.499949-480 E116514A495 LEVEL: Info
PID : 16056568 TID : 2829 PROC :
db2sysc 0
INSTANCE: dbboss01 NODE : 000 DB :
BOSSPROD
APPHDL : 0-8 APPID:
*LOCAL.dbboss01.140227230413
AUTHID : DBBOSS01 HOSTNAME: scldbbos01u
EDUID : 2829 EDUNAME: db2agent (BOSSPROD) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:200
MESSAGE : ADM1530I Crash recovery has been initiated.
NOTE: Any non-severe error, such as log full or interrupt, will
trigger this defect. |
