DB2 - Problembeschreibung
Problem IC84314 | Status: Geschlossen |
NUMA API incompatibility on SLES11 and RHEL6 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
The NUMA APIs that DB2 uses to provide NUMA support have an undocumented dependency between the build platform used to create DB2 libraries, and the kernel used while running DB2. The kernels on SLES11 and RHEL6 violate this dependency and are thus incompatible with DB2's NUMA support. If you attempt to enable NUMA support (via the DB2_RESOURCE_POLICY registry variable) on either of these platforms, you will encounter either of the following errors during db2start or db2 activate database. Error #1: 2012-01-06-02.25.55.633828-300 E14095E469 LEVEL: Severe (OS) PID : 49981 TID : 139760697861888PROC : db2sysc INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, oper system services, sqloIsCpuSetContainedInNUMANode, probe:10 MESSAGE : ZRC=0x83000022=-2097151966 CALLED : OS, -, numa_node_to_cpus OSERR: ERANGE (34) DATA #1 : Hexdump, 8 bytes 0x00007F1C92BF9790 : 0000 0000 0000 0000 ........ Error #2: 2012-01-04-10.31.53.765427-360 E10417E1419 LEVEL: Severe PID : 10685 TID : 140228274677504PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-7 APPID: *LOCAL.sample.120104163153 AUTHID : DB2INST1 EDUID : 20 EDUNAME: db2agent (TPCC) 0 FUNCTION: DB2 UDB, SQO Memory Management, sqlo_numa_error, probe:10 DATA #1 : <preformatted> Error encountered during NUMA operation: 'mbind' errno = 22 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F8979F5F693 pdLogPrintf + 0x3B3 [1] 0x00007F897BA46D00 numa_error + 0x34 [2] 0x00007F897A4CB09D _ZN12SQLO_LIBNUMA22numa_interleave_memoryEPvmP10nodemask_t + 0x13 [3] 0x00007F897BA7D193 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x2871193 [4] 0x00007F897A4C9D28 _Z25sqloGetSharedMemoryFromOsP17SMemSharedOptions + 0x1B4 [5] 0x00007F897A4C9795 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x12BD795 [6] 0x00007F897A4C7322 sqlogmshr + 0x880 [7] 0x00007F897A0C2A74 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xEB6A74 [8] 0x00007F897A0C0BC3 _ZN16sqeLocalDatabase12FirstConnectEP8SQLE_BWARcP8sqeAgentP8sqlo _gmtii + 0x45B [9] 0x00007F897A0B8CF0 _ZN8sqeDBMgr23StartUsingLocalDatabaseEP8SQLE_BWAP8sqeAgentRccP8s qlo_gmt + 0xC7C | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * * The NUMA APIs that DB2 uses to provide NUMA support have an * * undocumented dependency between the build platform used to * * create DB2 libraries, and the kernel used while running DB2. * * * * The kernels on SLES11 and RHEL6 violate this dependency and * * are * * thus incompatible with DB2's NUMA support. * * * * If you attempt to enable NUMA support (via the * * DB2_RESOURCE_POLICY registry variable) on either of these * * platforms, you will encounter either of the following errors * * during db2start or db2 activate database. * * * * Error #1: * * * * 2012-01-06-02.25.55.633828-300 E14095E469 LEVEL: * * Severe * * (OS) * * PID : 49981 TID : 139760697861888PROC : * * db2sysc * * INSTANCE: db2inst1 NODE : 000 * * FUNCTION: DB2 UDB, oper system services, * * sqloIsCpuSetContainedInNUMANode, probe:10 * * MESSAGE : ZRC=0x83000022=-2097151966 * * CALLED : OS, -, numa_node_to_cpus OSERR: * * ERANGE * * (34) * * DATA #1 : Hexdump, 8 bytes * * 0x00007F1C92BF9790 : 0000 0000 0000 0000 * * ........ * * * * Error #2: * * * * 2012-01-04-10.31.53.765427-360 E10417E1419 LEVEL: * * Severe * * PID : 10685 TID : 140228274677504PROC : * * db2sysc 0 * * INSTANCE: db2inst1 NODE : 000 DB : * * SAMPLE * * APPHDL : 0-7 APPID: * * *LOCAL.sample.120104163153 * * * * AUTHID : DB2INST1 * * EDUID : 20 EDUNAME: db2agent (TPCC) 0 * * FUNCTION: DB2 UDB, SQO Memory Management, sqlo_numa_error, * * probe:10 * * DATA #1 : <preformatted> * * Error encountered during NUMA operation: 'mbind' errno = 22 * * CALLSTCK: (Static functions may not be resolved correctly, * * as * * they are resolved to the nearest symbol) * * [0] 0x00007F8979F5F693 pdLogPrintf + 0x3B3 * * [1] 0x00007F897BA46D00 numa_error + 0x34 * * [2] 0x00007F897A4CB09D * * _ZN12SQLO_LIBNUMA22numa_interleave_memoryEPvmP10nodemask_t + * * 0x13 * * [3] 0x00007F897BA7D193 * * /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x2871193 * * [4] 0x00007F897A4C9D28 * * _Z25sqloGetSharedMemoryFromOsP17SMemSharedOptions + 0x1B4 * * [5] 0x00007F897A4C9795 * * /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x12BD795 * * [6] 0x00007F897A4C7322 sqlogmshr + 0x880 * * [7] 0x00007F897A0C2A74 * * /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xEB6A74 * * [8] 0x00007F897A0C0BC3 * * _ZN16sqeLocalDatabase12FirstConnectEP8SQLE_BWARcP8sqeAgentP8 * * sqlo * * _gmtii + 0x45B * * [9] 0x00007F897A0B8CF0 * * _ZN8sqeDBMgr23StartUsingLocalDatabaseEP8SQLE_BWAP8sqeAgentRc * * cP8s * * qlo_gmt + 0xC7C * **************************************************************** * RECOMMENDATION: * * Discontinue the use of NUMA memory affinity support, but * * unsetting the DB2_RESOURCE_POLICY registry variable. * **************************************************************** | |
Local-Fix: | |
Disable NUMA support, by unsetting the DB2_RESOURCE_POLICY registry variable. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
This incompatiblity will be resolved in future releases through a combination of DB2 code changes and the use of newer build platforms. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
Will be addressed by DB2 code changes (use of NUMA v2 APIs) and upgrades to DB2 build environments (to avoid kernel/runtime data structure mismatch.) | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.06.2012 17.12.2012 17.12.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.1 | |
10.5.0.1 |