|
Problem IC90783
|
Status: Closed |
TRAP ON USING VARIABLE OBJECT AFTER UPGRADE TO V10.1 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
variable object based on anchor to row type or cursor type can
cause a trap after an upgrade to v10.1
$ db2 "set myschema.myvar = ( 1,1,1,1,1,CURRENT TIMESTAMP,
1,'c')"
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1224N The database manager is not able to accept new
requests, has
terminated all requests in progress, or has terminated the
specified request
because of an error or a forced interrupt. SQLSTATE=55032
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB255611A
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x020a
(/home/hostname/ginaulak/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB2555EAB ossDumpStackTraceV98 + 0x002b
(/home/hostname/ginaulak/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB2550DD3 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x0103
(/home/hostname/ginaulak/sqllib/lib64/libdb2osse.so.1)
0x00002AAAAE05A957 sqlo_trce + 0x0407
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE0A5937 sqloEDUCodeTrapHandler + 0x0277
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABD4D60 address: 0x00002AAAAABD4D60 ; dladdress:
0x00002AAAAABC7000 ; offset in lib: 0x000000000000DD60 ;
(/lib64/libpthread.so.0)
0x00002AAAABBC1D71 _Z9getNextCDP8sqlrg_cd + 0x0001
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC6CDB63
_Z27sqlnqBuildRowTypeDescriptorP20sqlnq_multipart_nameP8sqlrg_pd
RP12sqlrg_typepdbP3loc + 0x00d3
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC315337
_Z22sqlnnBuildVariableTypeR17sqlnn_dat_TYPTYPEP12sqlrg_var_pd +
0x0337
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC6FCD6F
_Z33sqlnq_handle_global_variable_name20sqlnq_multipart_namePP9sq
lnq_qunPP9sqlnq_qncP3locb + 0x045f
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC5257C6
_Z27sqlnq_resolve_variable_nameP8psm_ctrlP3locP9sqlnq_pid15psm_I
Ovar_usagebPP9sqlnq_qunPS4_ + 0x06f6
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC515B9A
_Z17sqlnq_psm_sem_actPP8stknode_i10actiontypePhP3loc + 0x0afa
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAEE6CC01 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0a51
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC4BD704 _Z12sqlnp_parserP8sqlnp_cb + 0x0224
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC4C2959
_Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0289
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC2FE327
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_enviiPP9sqlnq_qur + 0x0af7
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC2FD821
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_env + 0x0021
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACAF1DE2
_Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP
_LOCK_INFOP16sqlra_cached_varPi + 0x0822
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACAFEEAC
_Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj
jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK
_INFOPP16sqlra_cached_varS8_b + 0x066c
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACB393C6 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0876
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACA90ACD _Z23sqlrr_execute_immediateP8sqlrr_cbi +
0x00fd
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACA85085
_Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x0135
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC16D66B
_Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject +
0x05ab
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAEDD1C96
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x03a6
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAEDD206C
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x036c
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC1507AA address: 0x00002AAAAC1507AA ; dladdress:
0x00002AAAAACE0000 ; offset in lib: 0x00000000014707AA ;
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC14F59F address: 0x00002AAAAC14F59F ; dladdress:
0x00002AAAAACE0000 ; offset in lib: 0x000000000146F59F ;
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC14D383 address: 0x00002AAAAC14D383 ; dladdress:
0x00002AAAAACE0000 ; offset in lib: 0x000000000146D383 ;
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC14D113 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x00f3
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAABF0E950 _ZN8sqeAgent6RunEDUEv + 0x0710
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACEC9953 _ZN9sqzEDUObj9EDUDriverEv + 0x00f3
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAACEC9859 _Z10sqlzRunEDUPcj + 0x0009
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC95E8CF sqloEDUEntry + 0x029f
(/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABCD193 address: 0x00002AAAAABCD193 ; dladdress:
0x00002AAAAABC7000 ; offset in lib: 0x0000000000006193 ;
(/lib64/libpthread.so.0)
0x00002AAAB2F6A0DD __clone + 0x006d
(/lib64/libc.so.6)
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* variable object based on anchor to row type or cursor type *
* can *
* cause a trap after an upgrade to v10.1 *
* *
* $ db2 "set myschema.myvar = ( 1,1,1,1,1,CURRENT TIMESTAMP, *
* 1,'c')" *
* DB21034E The command was processed as an SQL statement *
* because *
* it was not a *
* valid Command Line Processor command. During SQL processing *
* it *
* returned: *
* SQL1224N The database manager is not able to accept new *
* requests, has *
* terminated all requests in progress, or has terminated the *
* specified request *
* because of an error or a forced interrupt. SQLSTATE=55032 *
* *
* <StackTrace> *
* -----FUNC-ADDR---- ------FUNCTION + OFFSET------ *
* 0x00002AAAB255611A *
* _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + *
* 0x020a *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2osse.so.1) *
* 0x00002AAAB2555EAB ossDumpStackTraceV98 + 0x002b *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2osse.so.1) *
* 0x00002AAAB2550DD3 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + *
* 0x0103 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2osse.so.1) *
* 0x00002AAAAE05A957 sqlo_trce + 0x0407 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAE0A5937 sqloEDUCodeTrapHandler + 0x0277 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAABD4D60 address: 0x00002AAAAABD4D60 ; dladdress: *
* 0x00002AAAAABC7000 ; offset in lib: 0x000000000000DD60 ; *
* (/lib64/libpthread.so.0) *
* 0x00002AAAABBC1D71 _Z9getNextCDP8sqlrg_cd + 0x0001 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC6CDB63 *
* _Z27sqlnqBuildRowTypeDescriptorP20sqlnq_multipart_nameP8sqlr *
* g_pd *
* RP12sqlrg_typepdbP3loc + 0x00d3 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC315337 *
* _Z22sqlnnBuildVariableTypeR17sqlnn_dat_TYPTYPEP12sqlrg_var_p *
* d + *
* 0x0337 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC6FCD6F *
* _Z33sqlnq_handle_global_variable_name20sqlnq_multipart_nameP *
* P9sq *
* lnq_qunPP9sqlnq_qncP3locb + 0x045f *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC5257C6 *
* _Z27sqlnq_resolve_variable_nameP8psm_ctrlP3locP9sqlnq_pid15p *
* sm_I *
* Ovar_usagebPP9sqlnq_qunPS4_ + 0x06f6 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC515B9A *
* _Z17sqlnq_psm_sem_actPP8stknode_i10actiontypePhP3loc + *
* 0x0afa *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAEE6CC01 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0a51 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC4BD704 _Z12sqlnp_parserP8sqlnp_cb + 0x0224 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC4C2959 *
* _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0289 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC2FE327 *
* _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP *
* 14sq *
* lrr_cmpl_enviiPP9sqlnq_qur + 0x0af7 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC2FD821 *
* _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP *
* 14sq *
* lrr_cmpl_env + 0x0021 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACAF1DE2 *
* _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14 *
* SQLP *
* _LOCK_INFOP16sqlra_cached_varPi + 0x0822 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACAFEEAC *
* _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt *
* _idj *
* jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_ *
* LOCK *
* _INFOPP16sqlra_cached_varS8_b + 0x066c *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACB393C6 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + *
* 0x0876 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACA90ACD _Z23sqlrr_execute_immediateP8sqlrr_cbi + *
* 0x00fd *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACA85085 *
* _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + *
* 0x0135 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC16D66B *
* _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + *
* 0x05ab *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAEDD1C96 *
* _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14 *
* db2U *
* Cinterface + 0x03a6 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAEDD206C *
* _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + *
* 0x036c *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC1507AA address: 0x00002AAAAC1507AA ; dladdress: *
* 0x00002AAAAACE0000 ; offset in lib: 0x00000000014707AA ; *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC14F59F address: 0x00002AAAAC14F59F ; dladdress: *
* 0x00002AAAAACE0000 ; offset in lib: 0x000000000146F59F ; *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC14D383 address: 0x00002AAAAC14D383 ; dladdress: *
* 0x00002AAAAACE0000 ; offset in lib: 0x000000000146D383 ; *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC14D113 *
* _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + *
* 0x00f3 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAABF0E950 _ZN8sqeAgent6RunEDUEv + 0x0710 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACEC9953 _ZN9sqzEDUObj9EDUDriverEv + 0x00f3 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACEC9859 _Z10sqlzRunEDUPcj + 0x0009 *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC95E8CF sqloEDUEntry + 0x029f *
* *
* (/home/hostname/ginaulak/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAABCD193 address: 0x00002AAAAABCD193 ; dladdress: *
* 0x00002AAAAABC7000 ; offset in lib: 0x0000000000006193 ; *
* (/lib64/libpthread.so.0) *
* 0x00002AAAB2F6A0DD __clone + 0x006d *
* (/lib64/libc.so.6) *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to product DB2 v10.1.0.3 before upgrading the *
* database. *
**************************************************************** |
| Local Fix: |
drop and recreate the variable object after upgrade |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem is fix in v10.1 fixpack 3 . Fix pack should be applied
to the server before the lower level database is upgraded. If
the database has already been upgraded to v10.1 GA or fixpack 1
or fixpack 2 . The variable object need to be drop and
recreated. |
| Workaround |
If the database has already been upgraded to v10.1 GA or fixpack
1 or fixpack 2 . The variable object need to be drop and
recreated. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.03.2013
27.09.2013
27.09.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
