Informix - Problem description
Problem IT14158 | Status: Closed |
MEMORY BLOCK HEADER CORRUPTION RUNNING QUERY WITH BSON_GET() | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Memory block header corruption running query with bson_get() The af file block header dump looked like the following: 13:48:44 Found during mt_shm_free 1 13:48:44 Pool '44' (0x468af040) 13:48:44 Bad block header 0x47771050 blk-64 0000000047771010: 00000000 00000000 00000000 00000000 ........ ........ 0000000047771020: 00000000 00000000 00000000 00000000 ........ ........ 0000000047771030: 00000000 00000000 00000000 00000000 ........ ........ 0000000047771040: 00000000 00000000 00000038 00000000 ........ ...8.... blk+64 0000000047771050: 01000000 2c000000 2c000000 02636f6e ....,... ,....con 0000000047771060: 66696749 64001900 00003536 63663535 figId... ..56cf55 0000000047771070: 32636534 62306539 31613066 37333033 2ce4b0e9 1a0f7303 0000000047771080: 37620000 00000000 78107747 00000000 7b...... x.wG.... 13:48:44 Bad block removed from pool And was produced by the following SQL statement: SELECT SKIP 0 LIMIT 2 data FROM foo WHERE (bson_get(data, 'orgId') = '{ "orgId" : "5592bfade4b0cc601fe23133" }'::json::bson ) AND (bson_get(data, 'refId') = '{ "refId" : "55688e84e4b01e28da75d233" }'::json::bson ) AND (bson_get(data, 'refVersion') = '{ "refVersion" : 14 }'::json::bson ) AND ((bson_get(data, 'name') = '{ "name" : "56cf552ce4b0e91a0f73037b" }'::json::bson) OR (bson_get(data, 'configId') = '{ "configId" : "56cf552ce4b0e91a0f73037b" }'::json::bson ) ) So, it appears that the last part of the query string has overwritten the block header. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.03.2016 29.06.2016 29.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |