|
Problem IT37209
|
Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Db2 Server may terminate abnormally with select from a table,
after creating column mask and activating column access control
for the table.
When the select query is involved in a package, the same issue
may occur when rebind the package.
The stack looks similar to this example:
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007FA3A99D8FD6
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
(/home/db2di/sqllib/lib64/libdb2osse.so.1)
0x00007FA3A99D8C1B ossDumpStackTraceV98 + 0x002b
(/home/db2di/sqllib/lib64/libdb2osse.so.1)
0x00007FA3A99D49C7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
(/home/db2di/sqllib/lib64/libdb2osse.so.1)
0x00007FA3B1294A29 sqlo_trce + 0x03e9
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1408851 sqloEDUCodeTrapHandler + 0x03d1
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B9065630 address: 0x00007FA3B9065630 ; dladdress:
0x00007FA3B9056000 ; offset in lib: 0x000000000000F630 ;
(/lib64/libpthread.so.0)
0x00007FA3B0DA87D1 address: 0x00007FA3B0DA87D1 ; dladdress:
0x00007FA3A9F35000 ; offset in lib: 0x0000000006E737D1 ;
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B0D9E183 address: 0x00007FA3B0D9E183 ; dladdress:
0x00007FA3A9F35000 ; offset in lib: 0x0000000006E69183 ;
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B0DA6C92 address: 0x00007FA3B0DA6C92 ; dladdress:
0x00007FA3A9F35000 ; offset in lib: 0x0000000006E71C92 ;
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B0D9D151 _Z18sqlnq_compile_fgacP9sqlnq_qur + 0x0791
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B10DCF9C _Z9sqlns_qgsP9sqlnq_qur17sqlnq_requestTypePc
+ 0x02ac
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B027B78A
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_enviiPP9sqlnq_qur + 0x46da
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B02770A1
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_env + 0x0021
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1ADF6C6
_Z10sqlrr_cmplP8sqlrr_cbP11sqlrrstrings17sqlnn_compileModehP5sql
daPiPjPP9sqlri_shdP11compileInfo + 0x0516
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1D8BA4F
_Z18sqlra_recreate_pkgP8sqlrr_cbiicP15sqlra_func_pathh + 0x2b3f
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1D1016D
_Z16sqlra_rebind_pkgP8sqlrr_cbPhsS1_sS1_iicP15sqlra_func_pathb +
0x023d
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1D9E72E
_Z37sqlraFindInvalidPackagesAndRebindThemP8sqlrr_cb + 0x07ce
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1D9D8DC
_Z35sqlraPackageRebinderDaemonInnerMainP8sqeAgent + 0x04fc
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1D9C7F5
_Z35sqlraPackageRebinderDaemonOuterMainP8sqeAgent + 0x01d5
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3AF571343 _Z26sqleIndCoordProcessRequestP8sqeAgent +
0x0463
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3AF5984E1 _ZN8sqeAgent6RunEDUEv + 0x05a1
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B2EF048E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B1405D2A sqloEDUEntry + 0x057a
(/home/db2di/sqllib/lib64/libdb2e.so.1)
0x00007FA3B905DEA5 address: 0x00007FA3B905DEA5 ; dladdress:
0x00007FA3B9056000 ; offset in lib: 0x0000000000007EA5 ;
(/lib64/libpthread.so.0)
0x00007FA3A89D69FD clone + 0x006d
(/lib64/libc.so.6) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Comment |
Upgrade to 11.1.4.7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.06.2021
17.04.2022
17.04.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
