Fix list for Informix Server 12.10.xC8 and PID 12.10.xC8W1
Informix Server provides periodic fixes for release 12.10. The following list is the most recent report of fixes for customer-reported defects in Version 12.10.xC8W1 and 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.
| xC8W1APARs |
Description
|
| IT12385 | SPATIAL: ST_UNION MAY RETURN WRONG RESULT |
| IT13967 | STORED PROCEDURE QUERYING SYSONLINELOG LEAKS AIO FILE HANDLES |
| IT16967 | EXCESSIVE READS ON SYSXTDYPEAUTH SYSTEM CATALOG |
| IT16971 | USING TEMP TABLES AND STORED PROCEDURES BY PREPARED STATEMENTS OR 4GL PCODE MAY LEAD TO SQL LAYER GETTING OUT OF SYNC WITH RSAM |
| IT17019 | AUDITING DOESNT TRACK A CREATE TABLE TAB_NEW AS SELECT * FROM TAB AS CRTB |
| IT17265 | SYNTAX ERROR -201 IF RUN INSERT INTO WITH THE OWNER IDENTIFIER OF THE RESULT TABLE |
| IT17533 | BFCHECK ERROR AFTER PGCOMPRESS / PAGE_REORG TO MAKE ROOM FOR AN INSERT OR A LARGER UPDATED SLOT |
| IT17540 | CREATE A FORIEGN KEY INDEX ON FOT PRIMARY KEY INDEXES CAUSES ERROR -245/105 |
| IT17634 | IFXCLONE UTILIZING ALL AVAILABLE MEMORY THEN CRASHING WHEN ATTEMPTING TO SET UP HDR |
| IT17763 | ST_POINT() COULD FAIL WITH ASSERT FAILED: CONDITION FAILED (BAD POOL POINTER) WHEN PDQ IS USED |
| IT17814 | MERGE STATEMENT INSERT VALUES CAN FAIL WITH -271/-151 AFTER ALTER TABLE ADD COL ON TABLE WITH VERCOLS |
| IT17852 | SEGVS AND MEMORY CORRUPTION USING SELECT FROM TABLE INTO STANDARD TABLE FEATURE |
| IT17943 | RUNNING SYSPURGE() ON A NONFRAGMENTED TABLE CAUSES SIGSEGV |
| IT18059 | CREATE TABLE COMPRESSED AS SELECT DOES NOT COMPRESS THE TABLE |
| IT18092 | DBSCHEMA DOES NOT FINISH IF THERE IS AN INDEX OWNER |
| IT18141 | TABLE CREATION WITH CAPITAL LETTERS IN NAME RESULTS IN A TABLE THAT CANNOT BE DROPPED/ALTERED/QUERIED |
| IT18142 | CREATION OF INDEX ON SDS PRIMARY CAN HANG IN IPL THREAD EVEN WHEN LOG_INDEX_BUILDS IS NOT ACTIVE |
| IT18143 | COUNT(*) ON SUBQUERY RESULTS USING IN CLAUSE AND CHAR VALUES WITH DIFFERENT LENGTH DEFINITION RETURN WRONG RESULTS |
| IT18144 | PDQ INSERT WHEN SELECT FROM AN EXTERNAL TABLE WITH WRONG DELIMITER CAN ASSERT AN XLCNV THREAD |
| IT18223 | QUERY THAT USED TO RUN FINE IN 11.50 NOW ALLOCATES SO MUCH MEMORY THAT THE INSTANCE RUNS OUT |
| IT18235 | IDS_INSTALL TO CREATE CLIENT RPMS FAILS BECAUSE IT CAN NOT FIND THE $INFORMIXDIR/EXTEND DIRECTORY |
| IT18295 | OPEN DATABASE HAS REDUNDANT DBSA CHECKING AND SHOULD LEVERAGE NS_CACHE GROUP CACHE IF ADMIN_USER_MODE_WITH_DBSA SET TO 1 |
| IT18403 | INDEX PAGES MAY NOT BE CLEANED ON SECONDARY SERVERS |
| IT18417 | HPUX-IA64 EXCESSIVE SPINLOCK CONTENTION CAN SLOW DOWN LOADING FROM EXTERNAL TABLES |
| IT18419 | UPGRADE OF SECONDARY SERVERS TO 12.10.XC8 FAILS |
| IT18480 | CONVERT THREAD HANGS WAITING FOR SQLUP CONVERTING TO 12.10.FC8 WHEN THERE IS A TENANT DATABASE |
| IT18533 | PN_SYSCATLOG FLAG MISSING FOR CERTAIN SYSTEM TABLES AFTER MIGRATING FROM 11.50/11.70 TO 12.10.FC8 |
| IT18549 | CLIP() RETURNS WRONG RESULTS WHEN READ AHEAD IS TURNED OFF (AUTO_READAHEAD=0) |
| IT18613 | NETWORK COMMUNICATION FAILURE DURING SDS CONNECTION TO PRIMARY MAY LEAD TO CHECKPOINT HANG |
| IT18719 | SELECTING FROM TIMESERIES VTI WITH COLUMN TIMESTAMP IN THE WHERE CLAUSE RETURNS A WRONG RESULT |
| IT18724 | ARCHIVE RESTORE FAILS VERY EARLY WITH PHYSICAL RESTORE FAILED |
| IT18740 | PARALLEL SHARD QUERY WHEN RUN FROM SECONDARY SERVER FAILS WITH ERROR CODE CLIXNOTACTIVE WHEN CONNECTING TO THE LOCAL SERVER |
| xC8APARs |
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 |