|
Problem IT29646
|
Status: Closed |
'ALTER TABLE ALTER COLUMN SET DATA TYPE' MAY CRASH THE INSTANCE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Db2 instance may crash while running 'ALTER TABLE ALTER COLUMN
SET DATA TYPE'.
db2diag.log
2019-02-05-14.14.51.936032+330 I14859058525A942 LEVEL: Severe
PID : 3211652 TID : 160198 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-45123 APPID: *LOCAL.db2inst1.190205084324
AUTHID : DB2INST1 HOSTNAME: XXXX
EDUID : 160198 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging function), probe:50
MESSAGE : RDS UCINTFC: pStatementText =
DATA #1 : Hexdump, 77 bytes
0x000000013F4D5020 : 414C 5445 5220 5441 424C 4520 4C44 494C
ALTER TABLE DB2IN
0x000000013F4D5030 : 4C4D 5353 4249 2E4C 524D 5F54 5820 414C
ST1.EMPOLYEE AL
0x000000013F4D5040 : 5445 5220 434F 4C55 4D4E 2052 4547 5F43 TER
COLUMN SERIAL_ID
0x000000013F4D5050 : 4F44 4520 5345 5420 4441 5441 2054 5950 ODE
SET DATA TYP
0x000000013F4D5060 : 4520 2044 4543 494D 414C 2837 29 E
DECIMAL(7)
2019-02-05-14.14.53.532725+330 E14859064517A804 LEVEL: Error
PID : 3211652 TID : 160198 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-45123 APPID: *LOCAL.db2inst1.190205084324
AUTHID : DB2INST1 HOSTNAME: XXXX
EDUID : 160198 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30
MESSAGE : ADM14005E The following error occurred: "AppErr".
First Occurrence
Data Capture (FODC) has been invoked in the following mode:
"Automatic". Diagnostic information has been recorded in the
directory named
"/FODC_PATH/FODC_AppErr_2019-02-05-14.14.53.530903_321
1652_160198_000/".
```
The FODC stacktrace shows :
```
DB2 build information: DB2 v10.5.0.10 s180615 SQL1005A
timestamp: 2019-02-05-14.14.53.540843
instance name: db2inst1.000
EDU name : db2agent (SAMPLE) 0 [-]
EDU ID : 160198
Signal #31
uname: S:AIX R:1 V:7 M:XXXXXXXXX N:XXXX
process id: 3211652
parent process id: 3605732
thread id : 160198 (0x271C6)
kthread id : 78054573
-------Frame------ ------Function + Offset------
0x0900000000583F94 pthread_kill + 0xD4
0x0900000010B2EEF0 sqloDumpEDU + 0xC4
0x0900000010B51854 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
0x110
0x090000000EC9D7CC sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x958
0x090000000EC9CCFC sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28
0x090000000F58350C
sqlzeMapZrc__FP8sqeAgentUiUlT2P5sqlcaiPC12sqlzeContextb + 0x20
0x09000000129FE80C
sqlrlalt__FP8sqlrr_cbPUcsT2T3T2T3T2T3P8sqlrg_pdP17sqlrl_table_pa
rmsilP18sqlrg_datapartinfoPbbP9sqlnq_ftbT16_ + 0x20EC
0x0900000012A4CF18 sqlnq_alter_table_end__FP9sqlnq_qtb + 0x3FD8
0x0900000012A6187C
sqlnq_alter_table_stmt__FPP8stknode_i10actiontypePUcP3loc +
0x1DC
0x090000000EA5C70C sqlnp_parser__FP8sqlnp_cb + 0x1A4
0x090000000EA4CDBC sqlnp_parser__FP8sqlnp_cb + 0x51C
0x090000000EC56D60
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x270
0x090000000E6FC5FC
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x4ED4
0x090000000F538330
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x3C
0x090000000F53C7B0
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0x860
0x090000000DF0ABC0
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x116C
0x090000000DF10278 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x22B4
0x090000000DEFA0FC sqlri_ddl_common__FP8sqlrr_cb + 0xD64
0x090000000DEF9680 sqlri_ddl_common__FP8sqlrr_cb + 0x2E8
0x090000000DEF927C sqlriddl__FP8sqlrr_cb + 0x34
0x090000000EFE1C7C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0xA0
0x090000000DEFD070
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x11E8
0x090000000DEFBF74
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0xEC
0x090000000F699374
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0xBA90
0x090000000F663880 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x694
0x090000000F663880 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x694
0x090000000F663478 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x28C
0x090000001050AA54
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
0x090000001050B570
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC
0x090000000FF6C15C RunEDU__8sqeAgentFv + 0x4E144
0x090000000FF79E74 RunEDU__8sqeAgentFv + 0x128
0x090000000E9D4E14 EDUDriver__9sqzEDUObjFv + 0x134
0x090000000E625154 sqloEDUEntry + 0x394
``` |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher *
**************************************************************** |
| Local Fix: |
Perform REORG on table if it is in reorg pending state. And
rerun ALTER TABLE ALTER COLUMN statement. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.07.2019
16.01.2020
16.01.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
