|
Problem IT18502
|
Status: Closed |
DB2 MAY RETURN SQLCODE:-901 OR RETURN WRONG RESULTS ON QUERIES WITH PLANS THAT INVOVLE SORT ON AN ENCRYPTED DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
DB2 may return sqlcode -901 or wrong results or hit a
panic/crash
when running a query which contains a sort which spilled to
disk.
Users may see one of the following sqlcodes:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "outer > inner, input out of order".)
SQLSTATE=58004
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "bad outer compare".) SQLSTATE=58004
Wrong results can manifest in either invalid data values coming
back to the user, or aggregation generating duplicate rows, when
not expected.
Sample stack when hitting the -901 sqlcode:
0x00007FFFF117665D sqlrrSqlCode + 0x00dd
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFF16A5B49 _Z8sqlri_mjP8sqlrr_cb + 0x0729
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFF163AB08 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x04f8
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFF10A0C77
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0d87
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFEEC35B8D address: 0x00007FFFEEC35B8D ; dladdress:
0x00007FFFE990A000 ; offset in lib: 0x000000000532BB8D ;
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFEEC3447A _Z21sqleProcessSubRequestP8sqeAgent + 0x03da
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFEEC67C7B _ZN8sqeAgent6RunEDUEv + 0x05ab
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFF2426DD6 _ZN9sqzEDUObj9EDUDriverEv + 0x0116
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFF0A76AF8 sqloEDUEntry + 0x0578
(/home/sbhalla/sqllib/lib64/libdb2e.so.1)
0x00007FFFF7BC7806 address: 0x00007FFFF7BC7806 ; dladdress:
0x00007FFFF7BC0000 ; offset in lib: 0x0000000000007806 ;
(/lib64/libpthread.so.0)
0x00007FFFE849464D clone + 0x006d
(/lib64/libc.so.6)
A stack for instance crash would look like the following:
0x00007F4E28DD54B7 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00a7
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E28DD4B80
_Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb + 0x0940
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E27B26CF5 _Z11sqlrrMapZrcP8sqlrr_cbjmi + 0x0035
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E280C5A5C _Z17sqlriPrefetchRIDsP8sqlrr_cbP8sqlri_lfl +
0x042c
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E280C3956 _Z14sqlriListFetchP8sqlrr_cb + 0x0466
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E28134AD0 _Z9sqlrihsjnP8sqlrr_cb + 0x0690
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E28134AD0 _Z9sqlrihsjnP8sqlrr_cb + 0x0690
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E28134AD0 _Z9sqlrihsjnP8sqlrr_cb + 0x0690
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E27FECF18 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x04f8
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E27A52387
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0d87
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E255E684D address: 0x00007F4E255E684D ; dladdress:
0x00007F4E202BB000 ; offset in lib: 0x000000000532B84D ;
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E255E513A _Z21sqleProcessSubRequestP8sqeAgent + 0x03da
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E2561893B _ZN8sqeAgent6RunEDUEv + 0x05ab
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E28DD5A16 _ZN9sqzEDUObj9EDUDriverEv + 0x0116
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x00007F4E274289A8 sqloEDUEntry + 0x0578
(/db2home/db2edwp1/sqllib/lib64/libdb2e.so.1)
0x0000003387A07AA1 address: 0x0000003387A07AA1 ; dladdress:
0x0000003387A00000 ; offset in lib: 0x0000000000007AA1 ;
(/lib64/libpthread.so.0)
0x00000033872E893D clone + 0x006d
(/lib64/libc.so.6) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Install this fix *
**************************************************************** |
| Local Fix: |
If it is possible to force a different plan that avoids sort,
this will avoid the issue. |
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
See Error Description |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.12.2016
23.06.2017
23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
