invispix 10x10

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


invispix 10x10