DB2 might crash during catalog migration when processing MQT
entry in the SYSTABLES. Once issue happens entries similar to
the following are being logged in the db2diag.log:
2015-01-12-05.47.04.140511-300 I214823E547 LEVEL:
Warning
PID : 23901 TID : 139641487353600 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DBNAME
APPHDL : 0-21 APPID:
*LOCAL.db2inst1.150112104658
AUTHID : DB2INST1 HOSTNAME: localhost
EDUID : 23 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate,
probe:4319
DATA #1 : <preformatted>
Start to migrate DB2 Release: 0xd00 database
...
2015-01-12-05.47.04.179506-300 I289464E544 LEVEL:
Warning
PID : 23901 TID : 139641487353600 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DBNAME
APPHDL : 0-21 APPID:
*LOCAL.db2inst1.150112104658
AUTHID : DB2INST1 HOSTNAME: localhost
EDUID : 23 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate,
probe:4452
DATA #1 : <preformatted>
Begin migrating catalog table: SYSTABLES
...
2015-01-12-05.47.05.355482-300 I294126E625 LEVEL:
Error
PID : 23901 TID : 139641487353600 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DBNAME
APPHDL : 0-21 APPID:
*LOCAL.db2inst1.150112104658
AUTHID : DB2INST1 HOSTNAME: localhost
EDUID : 23 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x00007F00D100F932 : 0000
During the occurrence DB2 produces FODC with following trap
stack:
0x00007F00DC08B1A5
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
0x00007F00DC08ADAC ossDumpStackTraceV98 + 0x002c
0x00007F00DC085EAD _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
0x00007F00E2519984 sqlo_trce + 0x0404
0x00007F00E256EF9A sqloEDUCodeTrapHandler + 0x027a
0x000000355D60F710 address: 0x000000355D60F710 ; dladdress:
0x000000355D600000 ; offset in lib: 0x000000000000F710 ;
0x00007F00E351C720
_ZN13SQLO_MEM_POOL10MemTreeGetEmmPP17SqloChunkSubgroupPj +
0x00a0
0x00007F00E351D71C
_ZN13SQLO_MEM_POOL19allocateMemoryBlockEmmjmPP17SqloChunkSubgrou
pPjP12SMemLogEvent + 0x005c
0x00007F00E351A6F3 sqlogmblkEx + 0x0743
0x00007F00E05CD82D sqloMemBlockReallocate + 0x00fd
0x00007F00E2D3DCAC
_Z25sqlrlm_101toKepler_miscpdP8sqeAgentP12v101sqlrg_pdPPcPj +
0x043c
0x00007F00E2D39821
_Z26sqlrlm_101toKepler_tablepdP8sqeAgenttP10SQLD_VALUEmP14sqlrg_
2pt_nameP12v101sqlrg_pdPPcb + 0x02c1
0x00007F00E2D35578
_Z28sqlrlm_101toKepler_systablesP8sqeAgenttP10SQLD_VALUEP8sqlr_t
idPcPS5_PlPbS8_ + 0x02a8
0x00007F00E2D1BC0E
_Z19sqlrlm_catalogFixupP8sqlrr_cbtllm17sqlrlm_catChangesPc8sqlr_
tidPS3_ + 0x18ee
0x00007F00E2BE9C8F _Z22sqlrlm_catalog_migrateP8sqeAgentsP5sqlca
+ 0x1c9f
0x00007F00E195BFEB _Z8sqlefmigPcP8SQLE_BWAP5sqlca + 0x02db
0x00007F00E195D402 _Z8sqlemigrP8SQLE_BWAP14db2UCinterface +
0x0bd2
0x00007F00DF65E5B1
_ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x1771
... |
