Product Documentation
Abstract
Informix Server provides periodic fixes for release12.10. The following list is the most recent report of fixes for customer-reported defects in Version 12.10.xC7. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.
Content
| Fix release date: 23 Jun 2016 Last modified: 28 Jun 2016 Status: Recommended  Download information | |
APAR | Description |
| IC96208 | UDR CALLING A TIMESERIES FUNCTION HAVING THE TIMESERIES DATATYPE AS AN ARGUMENT CAN ALLOCATE GBS OF MEMORY IF TRACING ENABLED |
| IT04588 | MANY GROUPER AND SPOOLER THREADS CAUSING HEAVY CONTENTION AND NIF SLOW-DOWN ON A SPOOLED SEND QUEUE |
| IT08863 | INSERTING INTO GRID CREATED AND REPLICATED TABLE THAT USES FRAGMENTATION CAUSES DATA SYNC THREAD TO CRASH ON TARGET SERVER |
| IT09006 | CONCURRENT QUERIES USING EXISTNODE() XML ROUTINE WILL CRASH THE INSTANCE |
| IT09446 | A PREPARED STATEMENT EXECUTED MANY TIMES IN THE SAME SESSION ON UPDATABLE SECONDARY MAY CAUSE SQSCB->NEXTID OVERFLOW ON PRIMARY. |
| IT09503 | PATH OF EXECUTABLE IN ONSTAT -G SES SESSID OUTPUT CAN BE WRONG |
| IT09504 | POOR PERFORMANCE IF SIMPLE- AND ANSI-JOINS COMBINED |
| IT09695 | ONCHECK -PP CHUNK No, OFFSET, NUMPAGES DOES NOT PRINT MULTIPLE PAGES PROPERLY FOR CHUNKS WITH NON-STANDARD PAGE SIZE |
| IT10535 | DDL_LOGPROCESS_ROUTINECACHE .. FAILED TO OPEN DATABASE ERROR MESSAGE ON RSS WHILE REGISTERING SPATIAL DATABLADE ON PRIMARY |
| IT10689 | STOP_APPLY = 1 IS NOT ALWAYS AFFECTIVE AND THE STAGING_DIR CAN REMAIN EMPTY |
| IT10709 | RSS SEEING TRANSACTION NOT FOUND AND AFS WHEN APPLYING ENDTRANS LOG TYPES |
| IT10729 | DBSCHEMA -SS AND SYSTRIGBODY BOTH REPORT DECIMAL 0 VALUES IN A DIFFERENT FORMAT THAN CREATE TRIGGER STATEMENT SPECIFIED |
| IT10778 | MEMORY VIOLATION WHEN CLOSING AN ODBC CONNECTION INVOLVED IN A DISTRIBUTED TRANSACTION |
| IT11403 | ERROR -874 IS SHOWN IF SYNTAX LEFT JOIN IS USED TO JOIN TWO BTS TABLES |
| IT11666 | SORT IN LVARCHAR IS ALWAYS ASCENDING REGARDLESS OF DESC KEYWORD |
| IT11910 | LOG ROLLFORWARD ERROR 126 ON HINSERT INTO A TABLE ON SECONDARY AFTER TABLE HAS BEEN TRUNCATED |
| IT11955 | VIEWS WITH ANSI JOINS RUN SIGNIFICANTLY SLOWER IN 12.10 THAN IN 11.70 |
| IT11984 | USING XTRACE -C XTF_READAHEAD -F XTF_DEBUG CAN CAUSE ASSERT FAILURE SEGV IN RA_INIT_ROLLBACK_LOGDATA_REQ |
| IT12008 | AUTO UPDATE STATISTICS EVALUATION TASK IS LOCKED AFTER RESTORE |
| IT12047 | QUERY WITH ANSI LEFT OUTER JOINS RUN SIGNIFICANTLY SLOWER IN 12.10 THAN IN 11.70 |
| IT12106 | WHEN AN ERROR OCCURS IN AN SPL WITH A SELECT, A -285 IS GENERATED INTERNALLY BY THE SERVER WHICH WILL BLOCK ANY CURSORS FROM BEI |
| IT12133 | THREAD CAN GET HUNG RUNNING FOREVER OR POSSIBLY CRASH WHEN EXECUTING JOINS ON SYSMASTER SYSSQEXPLAIN, SYSSCBLST |
| IT12138 | SDS / RSS SHOULD NOT LOG SCHAPI: DATABASE SCHEDULER OFF, IGNORING EXECTASK() MESSAGE SINCE SCHEDULER IS NOT ALLOWED |
| IT12141 | TIMESERIES PROJECTEDCLIP CAN SEGV ASSERT IN TS_AM_PUT_NTH_INTERNAL_INMEM |
| IT12158 | WINDOWS: SET EXPLAIN ON CAN CAUSE A MEMORY CORRUPTION IN MT POOL WITH VARIOUS ASSERT FAILURES BEING PRODUCED |
| IT12162 | SERVER CRASH WHEN CREATING DATA DICTIONARY ENTRY WHEN USING REFERENTIAL CONSTRAINTS |
| IT12169 | ASSERT FAILURE AND CRASH IN OPLOOKSUBQ DURING PREPARE OF QUERY USING STATEMENT CACHE WHEN BATCHEDREAD_TABLE IS CHANGED |
| IT12203 | REPLICATION OF INSERT/UPDATE FROM EN_US.UTF8 TO EN_US.819 CORRUPTS INDEX |
| IT12225 | ASSERT FAIL SEGV CAN OCCUR FREEING MEMORY FROM UDR_END_SEQUENCE_INTERNAL |
| IT12227 | ONBAR BACKUP WITH PSM FAILS WITH EXCEEDED AVAILABLE RESOURCES |
| IT12376 | RESTORE WITH RENAME OPTION CAN GENERATE ASSERT FAILS OR FAIL IMMEDIATELY WITH ROOTPATH MISMATCH |
| IT12505 | TIMESERIES PROJECTEDCLIP QUERIES USE HUGE EXE MEMORY POOL WHEN EXECUTED WITH HOST VARIABLES AND WHERE IN CLAUSE |
| IT12507 | DIFFERENT QUERY PLAN WHEN THE EXACT SAME SQL IS RUN WITHIN A STORED PROCEDURE |
| IT12614 | USING CONNECTION MANAGER FOR AUTOMATIC PROMOTION FROM RSS TO PRIMARY CAN MARK TEMP SMARTBLOB SPACES OFFLINE |
| IT12665 | CAN NOT SWITCH TO DB_NAME IN MESSAGE LOG |
| IT12678 | ERROR 212 / 793 WHEN CREATING AN INDEX IN A DBSPACE OF DIFFERENT PAGE SIZE ON AIX |
| IT12691 | SLOW ALTER ON A DATABASE CREATED BY ONLOAD FAILS WITH ERRORS -252/-102 |
| IT12708 | HITTING A SESSION_LIMIT_* TRIGGERS AN EVENT BUT THE EVENT ID IS NOT DOCUMENTED |
| IT12726 | SERVER HANGS WHILE RUNNING LARGE QUERY WITH A LOT OF CASE EXPRESSIONS |
| IT12727 | ASSERTION FAILURE IN MT_FREE POSSIBLE WHEN CLOSING DATABASE THAT HAD A PREVIOUSLY FAILED REMOTE SERVER CONNECTION |
| IT12810 | QUERY WITH OUTER JOIN RETURNS WRONG RESULTS |
| IT12812 | ONSTAT -G STK DOES NOT WORK ON WINDOWS IF THE INSTANCE IS USING A SERVICE RUNNING IN THE CONTEXT OF THE LOCAL SYSTEM ACCOUNT |
| IT12817 | LINUX: 12.10.XC6 INSTANCE FAILS TO START WITH COULD NOT DETERMINE ENCRYPTION MODE FROM PAGE ZERO MESSAGE |
| IT12824 | QUERY RESULTS IN ASSERT FAILURE |
| IT12838 | INSERT OF UTF8 CHARACTERS RETURN ERROR -271 IF THE COLUMN IS NVARCHAR WITH A FUNCTIONAL INDEX ON IT |
| IT12839 | BTSCANNER CODE ASSERTION WHEN ALICE CLEANING A TABLE/PARTITION THAT HAD A SINGLE ATTACHED INDEX |
| IT12909 | SELECT QUERY USING CONNECT BY CLAUSE WITH PRIOR APPLIED TO VARCHAR RETURNS 26079 |
| IT12918 | THE KNOWLEDGE CENTER CONTAINS MACHINE AND RELEASE NOTES FOR EXCALIBUR VERSION 1.13.XC3 BUT THIS VERSION WAS NOT RELEASED UNTIL Y |
| IT12919 | ASSERTION FAILURE: CONDITION FAILED (RW_MUTEX->RW_SLOCK > 0), IN MT_RW_UNLOCK) |
| IT12934 | QUERY RETURNS INCORRECT RESULTS WHEN SELECTING IN A SUBQUERY WITH A NOT IN CLAUSE |
| IT12944 | ASSERT SEGV IN RSIDXSCAN_READ CAN HAPPEN WHEN USING MULTI INDEX SCAN |
| IT13027 | DROPPING A DOWN TEMPORARY SMART BLOB SPACE CAN LEAD TO A BLOCKED CHECKPOINT OR FATAL ASSERTION FAILURE |
| IT13037 | SELECT FROM VIEW RETURNS WRONG RESULTS IF USING A SECOND UDR FUNCTION IN ORDER BY CLAUSE |
| IT13038 | COMPRESSION MEMID LEAK ON INSERT INTO TAB1 SELECT FROM TAB2 WITH BYTE BLOBS LARGER THAN BLOB SPACE PAGE SIZE |
| IT13041 | ENGINE CAN CRASH WITH ASSERT FAILED: INVALID MUTEX TYPE DURING AN ARCHIVE BACKUP |
| IT13091 | CURSOR USING MULTI COLUMN INDEX WILL CONTINUE PICKING UP THE UPDATED KEYS AND LOOP UNTIL ERROR IS THROWN |
| IT13202 | NEED INFORMATION IN THE INSTANCE MESSAGE LOG WHY UPDATABLE SDS STAYS IN FAST RECOVERY |
| IT13243 | INSERTING A BLOB VIA A STORED PROCEDURE CAN CORRUPT BLOB CONTENT |
| IT13256 | DOC : ONSTAT -G CKP DOCUMENTATION DOES NOT LIST IPL AS CHECKPOINT TRIGGER |
| IT13323 | ONBAR COLD RESTORE CAN FAIL, RETURNING 0, RIGHT AFTER BEGIN RESERVED PAGES READ |
| IT13448 | TSCREATEVIRTUALTAB FAILS SILENTLY ON A FRAGMENTED TABLE WHERE THE EXPRESSION IS TOO LARGE |
| IT13449 | BATCHED REMOTE INSERT WITH IFX_USEPUT WITHOUT QUESTION MARKS HANGS UP REMOTE SESSION |
| IT13451 | ASSERT FAILURE IN LOWMEMORYMGR THREAD WITHIN KILL_IDLE_SESSIONS WHICH ALSO RESULTS IN A SYSTEM HANG |
| IT13452 | ASSERT FAILURE POSSIBLE IN RIDL_SEEK() WHEN UPDATE STATISTICS HIGH IS OPERATING ON A COMPRESSED INDEX |
| IT13477 | DIRTY READ SELECT WHILE LOADING A TIMESERIES VIRTUAL TABLE CAN CAUSE SIGSEGV ASSERT IN MT_SHM_FREE_POOL |
| IT13478 | ADDING A DBSPACE IN 12.10.XC6 TO A MIGRATED/UPDATED INSTANCE WILL WRITE PAGES IN OLD (NON BIGCHUNK) FORMAT |
| IT13482 | THE ONCONFIG PARAMETER TLS_VERSION MIGHT NOT ENFORCE THE TLS VERSIONS LISTED |
| IT13511 | THE DECODE FUNCTION TO CONVERT WEEKDAY DOES NOT WORK PROPERLY IN SUBSELECT |
| IT13602 | DOC: REMOVE DEPRECATED TYPE CONV_STATE_T FROM ONLINE SAMPLE |
| IT13603 | TABLE NO LONGER COMPRESSED WHEN ALTER TABLE WITH SLOW ALTER IS DONE |
| IT13630 | CONTINUAL CMD MEMORY GROWTH DURING SELECT COUNT(*) ON TIMESERIES VIRTUAL TABLE CREATED IN ROLLING WINDOWS CONTAINERS |
| IT13643 | -392 ERROR IN COMPLEX OUTER JOIN QUERY WITH UNION ALL |
| IT13671 | ISSUE PROCESSING QUERY INVOLVING TRIGGERS WHEN RAN ON UPDATABLE SECONDARY |
| IT13692 | VARIATIONS OF SUCH QUERY: SELECT COL1 C1, COL2 FROM TEST GROUP BY C1, 1, 2 CRASHES ENGINE |
| IT13725 | AN INSERT FROM AN EXTERNAL TABLE INTO A FRAGMENTED RAW TABLE WITH PDQ SET DOESNT UPDATE THE CURRENT SERIAL VALUE |
| IT13727 | ASSERT FAILURE POSSIBLE IN CLOSE_PREFILL_RMAP_SORTS() WITH UNION ALL AND MULTI-INDEX SCAN PATH USED |
| IT13819 | CDR CHECK CAN FAIL WITH ERRNO -528 IF TABLE HAS BLOB OR SBLOB COLUMNS |
| IT13825 | LIGHT SCAN OF A TABLE WITH OPEN IN-PLACE ALTER CAN ASSERT FAIL IN ROWALTER |
| IT13833 | ROLLBACK ERROR 101 AFTER ONLINE FRAGMENT DETACH FOLLOWED BY A DROP OF THE DETACHED FRAGMENT |
| IT13845 | DBLOAD DOES NOT ACCEPT CERTAIN CONTROL CHARACTERS LIKE CRTL-X OR CRTL-B AS DELIMITER WHEN LOADING DATA FROM FILE |
| IT13846 | IDS CRASHES IN EVALCOLS() SELECTING FROM A VIEW AND A TEMP TABLE IF PDQPRIORITY IS SET |
| IT13854 | -768 INTERNAL ERROR IN ROUTINE OLAP_TEMPTAB_WRITE: NO FREE BUFFER W/ QUERY USING OLAP FUNCTIONS AND USING KAIO TO TEMP DBSPACES |
| IT13889 | ERROR 556 WHEN QUERY INVOLVES REMOTE TABLE AND LEFT JOIN |
| IT13966 | UPDATE STATISTICS LOW WITH USTLOW_SAMPLE SET CRASHES OR HANGS THE ENGINE WHEN INDEX CONTAINS MANY DELETED ITEMS |
| IT13994 | SMX_CONNECT FAILURE DURING BOUNCE IN HDR ENVIRONMENT FOLLOWED BY A MISLEADING ERROR ABOUT ROLLING UPGRADE VERSION MISMATCH |
| IT14058 | ASSERT FAILURE POSSIBLE ON SELECT WITH MANY GROUP BY COLUMNS WHEN CALLING RDATAVALSMINT FROM EV_COLRET |
| IT14061 | AF DURING INITIALIZATION OF PARALLEL SORTING WHEN MEMORY IS EXHAUSTED IN CREATION OF A MUTEX - ATTEMPT TO FREE MUTEX TWICE |
| IT14062 | DBSCHEMA -D -T -SS CORE DUMPS ON A FRAGMENTED TABLE |
| IT14081 | ASSERTION CRASH / AFCRASH IN FUNCTION P_SMCOL |
| IT14158 | MEMORY BLOCK HEADER CORRUPTION RUNNING QUERY WITH BSON_GET() |
| IT14159 | 9810 AND 12097 ERRORS WHEN SELECTING SMART BLOBS (SLOBS) THAT WERE JUST UPDATED ON RSS |
| IT14183 | RSS SECONDARY ASSERT LOGICAL LOG REPLAY ERROR ON CHALLOC WHEN ROLLFORWARD INSERTS AFTER A TRUNCATE TABLE |
| IT14184 | RENAME A TABLE WITH FOREIGN KEY CONSTRAINT MIGHT CRASH THE DATABASE SERVER |
| IT14187 | CHECKPOINT HANG UNABLE TO SWITCH INTO NEXT LOGICAL LOG DUE TO PREVIOUS LONG TRANSACTION ROLLBACK |
| IT14440 | MEMORY BLOCK HEADER CORRUPTION USING AGGREGATE FUNCTIONS ON SPATIAL DATABLADE FUNCTIONS IN A SELECT FROM A VIEW |
| IT14445 | TABLE REPACK TASK ON A FRAGMENTED TABLE WITH PARTITION BLOBS CAN GENERATE THE PHPOSITION:ISLAST:BAD PAGE TYPE OF ASSERTION |
| IT14446 | SERVER ASSERT FAILS IN FM_OPENANY AFTER UNEXPECTED CALL TO EXECUTE_BLOB_ASSIGN DUE TO UNINITIALIZED VALUE_T |
| IT14447 | MEMORY CORRUPTION WHEN USING ANSI OUTER JOIN POSSIBLE |
| IT14448 | THE DOCUMENTATION OF THE OUTPUT OF ONSTAT -S COULD BE IMPROVED |
| IT14450 | LEFT-OVER ERROR FROM JOIN PHASE CAN MAKE SORT OR FETCH FAIL INADVERTENTLY |
| IT14464 | ERROR 201 RETURNED WHEN EXECUTING A QUERY WITH SYNTACTICALLY CORRECT GROUP BY CLAUSE BUT CONTAINING TERM REPETITION |
| IT14468 | GLOBAL POOL CAN LEAK MEMORY IN LISTENER_ERR AT ASFERR.C:325 |
| IT14480 | CONNECTION MANAGER SEGVS WITH A VARIETY OF MEMORY ERRORS WHEN DBSERVERS OF AN HDR CLUSTER USE CSM ENCRYPTION |
| IT14519 | 1024 BYTE RALLOC MEMORY LEAK DURING EXECUTION OF STATEMENT WITH SUM (CASE WHEN EXISTS(SELECT...) IN PROJECTION LIST |
| IT14537 | SEGMENTATION VIOLATION IN PROCESS_AUTOKEY BECAUSE OF ZERO TD_ROWSIZE |
| IT14539 | AFTER IN-PLACE ALTER SCHEMA OF TABLE MISSING COMPRESSED KEYWORD |
| IT14542 | DBACCESS DOES NOT LOAD ALL RECORDS IF FET_BUF_SIZE SET TO 10240000 |
| IT14544 | ASSERT FAILED SEGV IN OPEQSAVEDGES DURING LOW MEMORY TESTING AND 208 ERROR MEMORY ALLOCATION FAILED |
| IT14564 | ASSERT FAILURE IN ELIST_TRACE WHEN TRACE ON IS EXECUTED IN A UDR THAT CONTAINS THE OVER CLAUSE |
| IT14644 | THE PRIMARY SERVER CAN CRASH WITH INVALID MUTEX TYPE WHEN DISCONNECTED WITH RSS SECONDARY SERVER |
| IT14707 | SQLTRACE DOES NOT TRACE FOR MORE THAN 1 USER |
| IT14719 | ASSERT FAILED: MEMORY FREED TWICE WHEN DRDA_PREPARE CALLS MT_FREE AND SQL ERROR -23103 IS RETURNED TO CLIENT |
| IT14753 | -7400 ERROR IN TS_OPEN_INTERNAL DUE TO POSSIBLE NULL SUBTYPE |
| IT14754 | SIGSEGV IN TS_GET_AM_PTR AFTER DEEP COPY OF TIMESERIES USING R/W CONTAINERS |
| IT14755 | ERROR: BLOBPAGE X:XXXXXXX NOT REFERRED TO BY ANY ROW AFTER LOADING BYTE DATA |
| IT14895 | SMX PIPES CONTINUALLY ALLOCATED IN HDR PAIR FOR EACH CALL TO DR_ISSECONDARYINCHECKPOINT AFTER HA_ALIAS SET DYNAMICALLY ON SECOND |
| IT14909 | ONMODE -D DELETE RSS CRASHES THE RS SECONDARY IT IS REMOVING FROM THE PRIMARY |
| IT15092 | ASSERT FAILED ROLLBACK ERROR 101 CAUSED BY ROLLING BACK WORK ON LOGGED TEMP TABLE THAT HAS BEEN DROPPED BY DIFFERENT SESSION |
| IT15179 | WHERE EXISTS (SUBQUERY) FILTER POTENTIALLY INCREASING RESULT SET BY PRODUCING DUPLICATE ROWS IF SUBQUERY RETURNS MORE THAN ONE |
| IT15386 | ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO WHEN LOCK TABLE DYNAMICALLY GROWS AND ALRM_ALL_EVENTS SET TO 1 |
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"12.1","Edition":"Developer;Enterprise;Express;Innovator;Workgroup","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27048152