invispix 10x10

Fix list for Informix Server 12.10.xC7

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.


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


invispix 10x10