Number of column was more in source (binary header file meta
data) then column referenced in target table.
below is the trap stack:
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F6CDA06C16C
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x04ea
(/home/ngupta4k/sqllib/lib64/libdb2osse.so.1)
0x00007F6CDA06C9DB ossDumpStackTraceV98 + 0x007f
(/home/ngupta4k/sqllib/lib64/libdb2osse.so.1)
0x00007F6CDA066D32 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x04e0
(/home/ngupta4k/sqllib/lib64/libdb2osse.so.1)
0x00007F6CDA06683F _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x006b
(/home/ngupta4k/sqllib/lib64/libdb2osse.so.1)
0x00007F6CDC58A5CC sqlo_db2fmp_trca_nokill + 0x0862
(/home/ngupta4k/sqllib/lib64/libdb2.so.1)
0x00007F6CD9B5F850 address: 0x00007F6CD9B5F850 ; dladdress:
0x00007F6CD9B50000 ; offset in lib: 0x000000000000F850 ;
(/lib64/libpthread.so.0)
0x00007F6CDCBAA546 _ZNK17sqlExternalColRef16getColumnSQLTypeEv +
0x001e
(/home/ngupta4k/sqllib/lib64/libdb2.so.1)
0x00007F6CD0F6595C
_ZN16ExtblFormatterCb36ExtblCheckNzDb2TblShapeCompatibilityEP18s
qlExternalColRefs + 0x009a
(/home/ngupta4k/sqllib/lib64/libdb2nzexttblio.so)
0x00007F6CD0F5DCF4
_ZN16ExtblFormatterCb30extblFormatParseRecordNZBinaryEv + 0x0db8
(/home/ngupta4k/sqllib/lib64/libdb2nzexttblio.so)
0x00007F6CD0F5AACA extblNZInternalFormatParseRecords + 0x0026
(/home/ngupta4k/sqllib/lib64/libdb2nzexttblio.so)
0x00007F6CD0F59FDD extblFormatterEntry + 0x0fa2
(/home/ngupta4k/sqllib/lib64/libdb2nzexttblio.so)
0x00007F6CD9B57806 address: 0x00007F6CD9B57806 ; dladdress:
0x00007F6CD9B50000 ; offset in lib: 0x0000000000007806 ;
(/lib64/libpthread.so.0)
0x00007F6CD911A64D clone + 0x006d
(/lib64/libc.so.6)
and the db2diag.log entry:
2020-09-19-10.16.27.983861-240 I124933E1282 LEVEL:
Warning
PID : 13856 TID : 140105199945472 KTID :
15506
PROC : db2fmp (
INSTANCE: ngupta4k NODE : 000
HOSTNAME: hotellnx120
FUNCTION: DB2 UDB, oper system services, sqloCoreDumpIsRequired,
probe:1010
MESSAGE : bCoreDumpRequired/uiCoreLimit/pdDumpCoreSetting
DATA #1 : Boolean, 1 bytes
true
DATA #2 : Hex integer, 8 bytes
0xFFFFFFFFFFFFFFFF
DATA #3 : Hex integer, 4 bytes
0x00000001
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007F6CDB6706DA pdLog + 0x3CA
[1] 0x00007F6CDC585B79 sqloCoreDumpIsRequired + 0x4F0
[2] 0x00007F6CDC589EA4 sqlo_db2fmp_trca_nokill + 0x13A
[3] 0x00007F6CD9B5F850 /lib64/libpthread.so.0 + 0xF850
[4] 0x00007F6CDCBAA546
_ZNK17sqlExternalColRef16getColumnSQLTypeEv + 0x1E
[5] 0x00007F6CD0F6595C
_ZN16ExtblFormatterCb36ExtblCheckNzDb2TblShapeCompatibilityEP18s
qlExternalColRefs + 0x9A
[6] 0x00007F6CD0F5DCF4
_ZN16ExtblFormatterCb30extblFormatParseRecordNZBinaryEv + 0xDB8
[7] 0x00007F6CD0F5AACA extblNZInternalFormatParseRecords +
0x26
[8] 0x00007F6CD0F59FDD extblFormatterEntry + 0xFA2
[9] 0x00007F6CD9B57806 /lib64/libpthread.so.0 + 0x7806
[10] 0x00007F6CD911A64D clone + 0x6D
2020-09-19-10.16.27.987749-240 E126216E836 LEVEL:
Critical
PID : 13856 TID : 140105199945472 KTID :
15506
PROC : db2fmp (
INSTANCE: ngupta4k NODE : 000
HOSTNAME: hotellnx120
FUNCTION: DB2 UDB, oper system services,
sqlo_db2fmp_trca_nokill, probe:10
MESSAGE : ADM14001C An unexpected and critical error has
occurred: "FmpTrap".
The instance may have been shutdown as a result.
"Automatic" FODC
(First Occurrence Data Capture) has been invoked and
diagnostic
information has been recorded in directory
"/home/ngupta4k/sqllib/db2dump/FODC_FmpTrap_2020-09-19-10.16.27.
98754
8_0000/". Please look in this directory for detailed
evidence about
what happened and contact IBM support if necessary to
diagnose the
problem. |
