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.xC8. 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: 08 Dec 2016 Last modified: 09 Dec 2016 Status: Recommended  Download information | |
APAR | Description |
| IT05483 | INCORRECT RESULTS POSSIBLE FOR SELECT ON SMI TABLE SYSONLINELOG |
| IT05919 | INCORRECT RESULTS POSSIBLE FOR SIMPLE SELECT WITH GROUP BY ONLVARCHAR COLUMN |
| IT08865 | OBSCURE ERROR CODE PATH IN PARALLEL INDEX BUILDS CAN RESULT IN CRASHES FOR XCHG_2.* THREADS WHEN RUNNING OUT OF SORT SPACE |
| IT10492 | DBEXPORT -O SEGMENTATION FAULTS IF DIRECTORY SPECIFIED DOES NOT EXIST |
| IT12438 | A PREPARE OF SQL USING LIMIT COMMAND WITH HOST VARIABLE FAILS WITH PREPARE FAILED |
| IT13834 | RSS NODE ASSERT FAILURE / CRASH IN RSS_APPLY THREAD WITHIN DR_SECONDARY_APPLY |
| IT13887 | BTS INDEX CORRUPTION FROM A XA TRANSACTION |
| IT14643 | SELECT FROM SYSBUFHDR WILL ASSERT FAIL IN PSTPOSIT() |
| IT14738 | ONSMSYNC -G MIGHT CRASH WITH BAR_DEBUG TURNED ON |
| IT14770 | ALTERING TABLE TO ADD ROWIDS TO TABLE FRAGMENTED BY RANGE RETURNS -212/-772 ERROR |
| IT14894 | HIGH CONTENTION ON SESSION MUTEX WHEN LOTS OF SESSIONS SELECT DATA FROM SYSMASTER:SYSSESSIONS |
| IT14969 | DBACCESS MAY TRUNCATE A STRING IF CLIENT_LOCALE IS SET TO A MULTIBYTE CODESET |
| IT15002 | ON SOLARIS, A SEGMENTATION FAULT (SIGSEGV) RESULTS IN RECURSIVE EXCEPTION AND EXIT |
| IT15054 | INVALID MUTEX TYPE ASSERTION FAILURE ON POLL THREAD IN BREAK_SESSION DUE TO RACE CONDITION WITH THREAD EXITING VIA DESTROY_SESSI |
| IT15068 | THE TEXT ERROR MESSAGE FOR ERROR -860 CONTAINS SOME SPELLING MISTAKES |
| IT15183 | DBSPACES MISSING AFTER UPGRADE |
| IT15239 | MEMORY LEAK IN CSM VP WHEN OPENING AND CLOSING PASSWORD ENCRYPTED CONNECTIONS |
| IT15261 | HIGH PERFORMANCE LOAD JOBS CAN HANG WHEN USING A LARGE NUMBER OFDEVICES |
| IT15325 | -79728 UNKNOWN OBJECT TYPE ERROR WHEN QUERYING A BSON COLUMN IN A RELATIONAL TABLE |
| IT15342 | COMPRESSED KEYWORD MISSING FROM TABLE SCHEMA AFTER ALTER TABLE |
| IT15455 | AN ONINIT PROCESS CAN HANG WAITING FOR A DEBUGGER IF A PROXYDISPATCH THREAD HIT AN ERROR IN SMX_RECV |
| IT15514 | USING MORE THAN ONE COLLECTION IN A SINGLE SELECT CAN LEAD TO MEMORY CORRUPTION |
| IT15561 | UPDATE STATISTICS CAN FAIL WITH SQL CODE 959 ISAM 172 AND GENERATE AN ASSERTION FAILURE |
| IT15562 | JOINS ON COMPRESSED AND TEMP TABLES CAN CAUSE ASSERTIONS IN INSERTANDBUILDCOMPDICT |
| IT15608 | WHEN A TABLE HAS MUTLIPLE UPDATE TRIGGERS ON MUTLIPLE COLUMNS, THOSE TRIGGERS WILL FIRE ONCE PER COLUMN UPDATED PER TRIGGER |
| IT15623 | QUERY USING FOT INDEX RETURNS INCORRECT RESULTS |
| IT15624 | DELETES ON A REPLICATED TABLE WITH A DELETE TRIGGER CALLING A CUDR CAUSES VIRTUAL MEMORY LEAK IN TARGET CDRD_XXXX THREAD(S) |
| IT15625 | SDS SECONDARY STAYS IN UPDATES BLOCKED MODE AFTER SDS PRIMARY HAS CHANGED |
| IT15626 | INTERRUPTED UPDATE STATISTICS CAN LEAVE AN OUTDATED DD ENTRY AND RESULT IN -710 FOR OTHER CLIENTS ON THE SAME TABLE |
| IT15627 | OPTIMIZER NEEDS A LOT OF SHARED MEMORY |
| IT15662 | SERVER CANNOT USE THE LOGICAL NAME OF A RAW PARTITION IN THE ROOTPATH ON WINDOWS |
| IT15672 | WRONG COLUMN DEFAULT DISPLAY POSSIBLE IN DBACCESS TABLE INFO CONSTRAINTS DEFAULTS MENU |
| IT15813 | SELECT STATEMENT WITH A PATITION BY CLAUSE RETURNS ERROR -392 |
| IT15856 | PAGE CORRUPTIONS WITH BFCHECK: BAD PAGE: PG_FRPTR < SIZEOF(IFX_PAGE_T) MESSAGES ON SDS SECONDARY |
| IT15859 | LOG REPLAY ERROR ON SECONDARY WHEN ADDING A CHUNK TO AN SBSPACE WITH FULL METADATA |
| IT15877 | VARIOUS ASSERTION FAILURES FOR QUERY WITH WHERE IN-CLAUSE |
| IT15878 | DROPPING AN SBSPACE WHILE LEVEL 0 BACKUP IS RUNNING FAILS BUT LEAVES SBSPACE WITH NO USER DATA SPACE REFERENCE IN SHARED MEMORY |
| IT15915 | THREAD HANG CAUSED BY THREAD TRYING TO LOCK MUTEX IT ALREADY OWNED WHILE DOING A SYSMASTER QUERY WITH SQLTRACE ENABLED |
| IT15956 | AIX: ANY NON-CPU VPCLASS CONFIGURATION SPECIFYING NOAGE WOULD YIELD ONINIT PROCESSES WITH SCHEDULING PRIORITY ZERO |
| IT15958 | MEMORY LEAK IN GLOBAL MEMORY POOL USING ISTAR QUERIES WITH CONNECTION MANAGER AS PARTICIPANT |
| IT15959 | COMPRESSION WILL ONLY WORK FOR ONE FRAGMENT ON A TABLE, IF A PRIMARY KEY IS CREATED |
| IT16039 | LOADING DATA FROM AN EXTERNAL TABLE INTO A TABLE THAT IS FRAGMENTED BY ROUND ROBIN IS MUCH SLOWER IN 12.10 THAN 11.70 |
| IT16068 | NON-ROOT UPGRADE, ONRESTOREPT GIVES MUST BE USER INFORMIX OR ROOT TO RUN ONRESTOREPT |
| IT16099 | NETSTAT SHOWS CONNECTION IN CLOSE_WAIT AFTER PRIMARY RESTARTED AND RSS DISCONNECTED |
| IT16124 | QUERY WITH 2 OR MORE LEFT OUTER JOINS WILL RETURN WRONG RESULTS |
| IT16133 | QUERY JOINING 2 REMOTE TABLES USING 2 REMOTE PATH SCANS EXECUTING SIGNIFICANTLY SLOWER ON 12.10.XC6 THAN 12.10.XC5 |
| IT16176 | -768 ERROR IN OPJOIN WITH IFX_FOLDVIEW SET |
| IT16183 | FAILED UNCOMPRESSION OF SMX BUFFER NOT CHECKED LEADING TO RSS BLOCKED IN BLOCKLOGXMIT STATE |
| IT16184 | HDR SETUP USING ONTAPE ...-T STDIO -F MAY HANG HDR LATER |
| IT16206 | ASSERTION CONDITION FAILED (CACHE_ELM->MT_CACHE_ELEM_LOADER == NULL), IN (MT_CACHE_DONE) |
| IT16285 | OPTIMIZER CHOOSES INDEX PATH WITH NESTED LOOP JOIN OVER SEQUENTIAL SCAN WITH DYNAMIC HASH JOIN RESULTING IN SLOWER PERFORMANCE |
| IT16287 | SYSADMIN INTERNAL PROCEDURE AUS_SETUP_TABLE MISSING A COLUMN WHEN IT CREATES THE AUS_COMMAND TABLE RESULTING IN ERROR |
| IT16432 | TASKS STAY DISABLED WHEN SCHEDULER IS ONCE STARTED WITH $INFORMIXDIR/ETC/SYSADMIN/STOP FILE PRESENT |
| IT16467 | READAHEAD_ THREADS CAN BE CONTINUALLY ALLOCATED |
| IT16502 | ONCONFIG, ONSTAT -G CFG DISPLAY DIFFERENT VALUES FOR SQL CACHE SETTINGS |
| IT16503 | THE ENVIRONMENT VARIABLE IFX_SDSPAGING_THRESHOLD DOES NOT WORK PROPERLY WHEN SET TO VALUES 2^21 AND ABOVE |
| IT16556 | AF: INVALID MUTEX TYPE - WHEN RUNNING DROP SEQUENCE WHEN CONNECTING VIA DRDA |
| IT16588 | SUBSTRING OPERATOR DOES NOT WORK CORRECTLY WITH A GLOBALVARIABLE IN SPL |
| IT16617 | -9875 BAD INTERNAL STRUCTURE FOR COLLECTION DATA: UNKNOWN FLAG VALUE WHEN INSERTING INTO COLLECTION COLUMN WITHIN SPL |
| IT16652 | LOGICAL LOG FILE HAS LF_WAIT4FLUSH FLAG SET AND CANNOT BE BACKED UP (AFTER ONCLEAN -KY) |
| IT16653 | EXECUTING A REMOTE STORED PROCEDURE MAY RESULT IN -674 |
| IT16755 | ADDING A READAHEAD THREAD DURING TRANSITION FROM SECONDARY TO PRIMARY CAN HANG THE SERVER |
| IT16807 | HDR PRIMARY BLOCKS AT CHECKPOINT AFTER PING TIMEOUT AND FAILURE TO SUCCESSFULLY RECONNECT |
| IT16828 | INCREASE IN QUERY TIME AFTER UPGRADE TO 12.10 |
| IT16829 | ASSERT WARNING: CANNOT UPDATE PAGEZERO ON A HDR SECONDARY |
| IT16830 | UNCOMPRESS_ROW ERROR IN CDRGEVAL THREAD |
| IT16832 | SIGSEGV IN TS_AM_INIT_AMDESC AFTER UPGRADE FROM 11.70 TO 12.10 |
| IT16962 | ONBAR BACKUP USING COMMVAULT CRASHING WHEN BACKUP_FILTER IS USED |
| IT16964 | ASSERT FAILURE IN STLONG POSSIBLE WHEN RUNNING STORED PROCEDURE |
| IT16965 | ERROR -569 POSSIBLE FOR ARCHECKER TABLE LEVEL RESTORE OF MULTIPLE COMPRESSED TABLES |
| IT16968 | -768 DURING EXTERNAL TABLE LOAD CAUSES MEMORY BLOCK HEADER CORRUPTION |
| IT16969 | SESSIONS MAY BECOME BLOCKED WAITING ON DDH CHAIN MUTEX WHEN USING UPDATEABLE SECONDARY SERVERS |
| IT16975 | INSERTS INTO A TIMESERIES VTI TABLE CAUSE A MEMORY LEAK AFTER GETTING -937 ERROR |
| IT16991 | ARCHECKER ERROR -206/-111 IN AC MESSAGE LOG WHEN NON-INFORMIX USER ATTEMPTS MULTIPLE TABLE LEVEL RESTORE OF COMPRESSED TABLE |
| IT16992 | ONCONFIG_DIFF NOT PROPERLY ACCEPTING FILE NAMES LONGER THAN 63 CHARACTERS |
| IT17016 | RUNNING IDS_INSTALL -F FILE.PROPERTIES WORKS FINE BUT IT DOES NOT CREATE THE RPMS FILES |
| IT17017 | TIMESERIES ROLLING WINDOW CONTAINERS BECOME UNUSABLE CAUSING -937 ERRORS IF ACTIVE AND DORMANT INTERVALS OVERLAP |
| IT17068 | ASSERT FAILURE IN HASH_PROCESS_ALL_GROUPS POSSIBLE FOR QUERY WITH AGGREGATE FUNCTION AND GROUP BY CLAUSE |
| IT17086 | SELECT WITH LIKE ON A NVARCHAR COLUMN IN A UTF8 DATABASE CAUSES WRONG RESULTS |
| IT17087 | ERROR -5030 WHEN CONNECTING TO A SPWDCSM PASSWORD ENCRYPTED SERVER |
| IT17176 | SEGV AND MEMORY BLOCK HEADER CORRUPTION CAUSED BY VARIOUS OVERWRITES BY VALUE 0X7FFFFFFD DR_MSG_ACK |
| IT17177 | ENGINE CRASHES AND MEMORY CORRUPTION WHEN DOING DML STATEMENTS AND UPDATE STATISTICS AGAINST TABLES THAT HAVE REFERENTIAL CONSTR |
| IT17178 | ROLLBACKS FOR COMPRESS OR REPACK INDEX CAN HAVE THEIR READAHEAD THREADS CORRUPT MEMORY |
| IT17208 | PTHDRPAGE:PTALLOC ASSERT WARNINGS ON SECONDARY SERVER FROM NEW TABLOCK2 MECHANISM NOT AVOIDING NON-LOGGED TEMP TABLES |
| IT17263 | TASK DB_PURGE_TABLES MAY NOT RETURN TO THE CALLER IN CASE AN INTERNAL ERROR OCCURED |
| IT17264 | SELECT FIRST N WITH ORDER BY RETURNS THE WRONG NUMBER OF ROWS IF THE QUERY PLAN USES INDEX-SELF JOIN |
| IT17320 | ASSERT FAILED MEMORY BLOCK HEADER CORRUPTION DETECTED IN MT_SHM_FREE1 THE FREE IS HAPPENING IN RSTCB_CLEANUP |
| IT17331 | EXCESSIVE READS ON SYSPROCAUTH FOR PROCEDURES AND UDRS THAT HAVE GRANTEE OF PUBLIC |
| IT17362 | SMX UNCOMPRESSION FAILS LEADING TO RSS GETTING INTO BLOCKLOGXMIT STATE |
| IT17543 | WITH NON-ROOT INSTALL EXTENDED TYPE BY NAME CACHE CAN CONTINUE TO GROW DUE TO PUTTING DUPLICATE TYPES INTO THE CACHE |
| IT17545 | USING LINEAR CASE EXPRESSION IN THE FOLLOWING SELECT STATEMENT CAUSES ASSERT FAILURE IN COLLSUBQ_INIT() |
| IT17635 | RSCLOADLATESTDICT: DICTIONARY RETRIEVAL FAILED AND/OR -604/-172 ERRORS ACCESSING COMPRESSED TABLE /W BLOBS AFTER UPGRADE |
| IT17815 | COMMIT WORK RETURNS -745 WHEN TRANSACTION CONTAINS QUERIES ON TABLES WITH SELECT TRIGGERS AND CURSOR WITH HOLD SPANS TRANSACTION |
| IT17840 | MEMORY LEAK IN GLOBAL MEMORY POOL |
[{"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
swg27049036