Fix list for Informix Server 12.10.xC9
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.xC9. 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
|
| IT09405 | LONG CONNECTION TIME POSSIBLE WHEN LARGE GROUP LIST HAS TO BE SCANNED TO FIND OUT IF USER IS DBSA USER |
| IT10306 | WITH THREAD SUSPENSION ENABLED, CERTAIN MEMORY CORRUPTION CAN CAUSE THREAD SUSPENSION CODE TO INFINITELY LOOP ASSERT FAILING |
| IT12385 | SPATIAL: ST_UNION MAY RETURN WRONG RESULT |
| IT13967 | STORED PROCEDURE QUERYING SYSONLINELOG LEAKS AIO FILE HANDLES |
| IT14829 | SHOULD ALLOW FULL RANGE OF 64K REPLICATES PER SERVER |
| IT16966 | EXCESSIVE READS ON SYSUSERS SYSTEM CATALOG |
| 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 |
| IT17762 | IPLOAD/ONPLADM FAIL AT FAILPOINT 16144 AFTER 12.10.FC7 INSTALL ON HP-UX IA64 |
| IT17763 | ST_POINT() COULD FAIL WITH ASSERT FAILED: CONDITION FAILED (BAD POOL POINTER) WHEN PDQ IS USED |
| IT17797 | PROXYBTCLEAN THREADS CAN BE MISTAKENLY STARTED ON A STANDALONE SERVER |
| IT17814 | MERGE STATEMENT INSERT VALUES CAN FAIL WITH -271/-151 AFTER ALTER TABLE ADD COL ON TABLE WITH VERCOLS |
| IT17834 | TABLE LEVEL RESTORE POINT IN TIME FAILS FOR UNICODE DB |
| IT17852 | SEGVS AND MEMORY CORRUPTION USING SELECT FROM TABLE INTO STANDARD TABLE FEATURE |
| IT17943 | RUNNING SYSPURGE() ON A NONFRAGMENTED TABLE CAUSES SIGSEGV |
| IT17944 | SELECT FROM VIEW AND SUBQUERY RUNS MUCH SLOWER THAN A SELECT FROM THE UNDERLYING TABLES |
| 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 |
| IT18155 | PTHDRPAGE:PTALLOC:BAD PARTN PAGE ASSERTIONS POSSIBLE RUNNING PURGE_DICTIONARY TASK |
| IT18223 | QUERY THAT USED TO RUN FINE IN 11.50 NOW ALLOCATES SO MUCH MEMORY THAT THE INSTANCE RUNS OUT |
| IT18234 | ONMODE_MON THREAD IN PRIMARY CAN LOOP IN DR_MODE IF PROMOTE AN IFXCLONE RSS CREATION TOO QUICKLY TO AN HDR SERVER |
| IT18235 | IDS_INSTALL TO CREATE CLIENT RPMS FAILS BECAUSE IT CAN NOT FIND THE $INFORMIXDIR/EXTEND DIRECTORY |
| IT18273 | CONNECT BY IN A STORED PROCEDURE WITH MULTIPLE TEMP SPACES CAUSES 243/102 IN THE SECOND EXECUTION |
| IT18274 | LOW MEMORY MANAGER: LOWMEMORYRECONFIG USES THE WRONG VALUE FOR SHMTOTAL |
| IT18275 | REPACK_OFFLINE DOES NOT SWITCH TO REPACK |
| IT18280 | CONCURRENT READERS AND ALTER FRAGMENT ONLINE STATEMENTS CAN LEAD TO PERSISTENT ISAM -135 ERRORS |
| IT18294 | A SELECT ON A TABLE COULD MISS ROWS WHEN REPACK IS RUN IN PARALLEL |
| IT18295 | OPEN DATABASE HAS REDUNDANT DBSA CHECKING AND SHOULD LEVERAGE NS_CACHE GROUP CACHE IF ADMIN_USER_MODE_WITH_DBSA SET TO 1 |
| IT18318 | CURSOR ON DYNAMIC SQL RETURNED -661 INSTEAD OF -26053 |
| IT18331 | CDR_MONITOR THREAD HANGS |
| IT18403 | INDEX PAGES MAY NOT BE CLEANED ON SECONDARY SERVERS |
| IT18417 | HPUX-IA64 EXCESSIVE SPINLOCK CONTENTION CAN SLOW DOWN LOADING FROM EXTERNAL TABLES |
| IT18418 | ASSERT FAILURE IN GL_FULL_MBSCHR WHEN USING A LOCALE LIKE ZH_TW.57352 |
| 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) |
| IT18604 | ASSERT SEGV OR -768 ERROR CAN OCCUR ON QUERY AFTER RUNNING UPDATE STATISTICS ON THE LOCAL TABLES |
| IT18612 | ROLLFORWARD OF LOG RECORD FAILS WITH ISERRNO 101 AND IS SEEN IN HDR SECONDARY WHEN THE STAMP OF PNTORSFD HITS A NEGATIVE VALUE |
| 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 |
| IT18723 | MEMORY CORRUPTION IN CDR POOL |
| IT18724 | ARCHIVE RESTORE FAILS VERY EARLY WITH PHYSICAL RESTORE FAILED |
| IT18739 | SEGV IN RA_DO_ROLLBACK_REQ |
| IT18740 | PARALLEL SHARD QUERY WHEN RUN FROM SECONDARY SERVER FAILS WITH ERROR CODE CLIXNOTACTIVE WHEN CONNECTING TO THE LOCAL SERVER |
| IT18741 | SELECT FROM SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED |
| IT18792 | ALTER TABLE ADD ROWIDS FOR A TABLE FRAGMENTED BY ROWIDS GIVES ERROR : 212/100 |
| IT18894 | HDR SECONDARY XCHG THREAD CAN LOOP ENDLESSLY OR SEGV IN IXRFIND |
| IT18895 | WHEN BASE TABLE PRIVILEGES ARE REMOVED FOR USERS, ACTIONS ON THE TIMESERIES VIRTUAL TABLES RETURN UNINFORMITIVE ERROR MESSAGES |
| IT18945 | IFXCLONE ALLOWS NON-MATCHING ROOTPATH VALUES WHICH LEADS TO SPLIT ROOT-CHUNKS ON SECONDARY LEADING TO CORRUPTION |
| IT18958 | EXPANDING AN EXTENDABLE CHUNK FAILS AFTER A CERTAIN NUMBER OF EXPANDS |
| IT18960 | ERROR 408 SEEN WHEN SELECTING A TEXT FIELD WHICH CONTAINS MULTI BYTE DATA |
| IT18978 | SELECT INTO A TEMPORARY TABLE WITH PDQ COULD FAIL WITH -264/-770 |
| IT18980 | INSERT OF BSON DATA INTO EXTERNAL TABLE DOES NOT WORK WHEN DATABASE IS UTF8 |
| IT18982 | JAVA UDR THAT DELETES/INSERTS/SELECT AND RETURNS CLOB CAN CAUSE OOM OUTOFMEMORY ERRORS RUNNING ON JVP AND CRASH SERVER |
| IT19075 | UNABLE TO CREATE XA TRANSACTIONS WITH IBM DATA SERVER CLIENTS (VERSION 11.1) |
| IT19106 | UNDULY SENDING NEW INDEX ON RAW TABLE VIA IPL OR DRIDXAUTO |
| IT19131 | ONCHECK -PT DBNAME:TABNAME IS NOT REPORTING DETACHED INDEX FRAGMENT INFORMATION WHEN TABLE HAS FOREIGN KEY CONSTRAINTS |
| IT19140 | A PROXYTH THREAD CAN BE LEFT ORPHANED HOLDING LOCKS ON THE PRIMARY SERVER WHEN A PROXY DISPATCH THREAD FAILS |
| IT19178 | ONSMSYNC -E -P BASED ON PSM RETURNS THE LOCK CATALOG TABLE IS NOT OPEN ERROR |
| IT19199 | QUERY CAN RETURN 243/770 ERRORS WHEN TABLE IN ANOTHER DATABASE HAS DISABLED CONSTRAINTS AND FUNCTIONAL INDEXES |
| IT19200 | ERROR 9700 ROUTINE AMBIGUOUS: MORE THAN ONE ROUTINE RESOLVES TO GIVEN SIGNATURE WHEN EXECUTING A DATABASE ROUTINE FROM JDBC |
| IT19259 | EXECUTING A REMOTE PROCEDURE INVOLVING FOREACH .. SELECT FAILS WITH ERROR 556 |
| IT19260 | THE FUNCTION CREATED WITH RESUME CLAUSE RETURNS ERROR 1 NOT USER |
| IT19276 | ONPSM -C EXPORT RETURNS ERROR MESSAGE: ERROR -88186: A DEFECT IN THE PROGRAM WAS FOUND |
| IT19277 | QUERY WITH CORRELATION IN SELECT LIST RETURNS -294 BEGINNING WITH 12.10.FC8 |
| IT19278 | CDR GC: OPERATION OPEN ON TABLE USER TABLE FAILED (ISAM ERROR-135). MOVING FROM 12.10 PRE-XC7 TO XC7 OR HIGHER |
| IT19310 | ASSERT FAILED: UNCOMPRESS_ROW: COLUMN DATA LENGTH EXCEEDS THE MAXIMUM LENGTH |
| IT19311 | DBSCHEMA DOES NOT SHOW THE NOT NULL CONSTRAINTS |
| IT19313 | TIMESERIES PROJECTEDCLIP SPECIFYING NO NULL COLUMNS WITH (NN) SYNTAX ASSERTS IN TS_CLIP_AND_PROJECT |
| IT19351 | AFTER ONMODE -KY, ONCLEAN -KY THROWS ERROR MESSAGES THE SEMCTL() FUNCTION ON ID = ?????? FAILED WITH ERROR NUMBER = 22 |
| IT19353 | ASSERT FAILED IN EXECUTE_UNION_NODE() OF A QUERY WITH UNION ALL |
| IT19359 | SPL: FETCH INTO GLOBAL ROW TYPE VARIABLE ASSIGNS RANDOM GARBAGE |
| IT19360 | QUERY LOOPS IN OPLOOKSUBQ, WILL RESULST IN STACK OVERFLOW OR HANG |
| IT19376 | ASSERT FAILURE POSSIBLE ON SECONDARY SERVERS AFTER INDEX COMPRESSION AND FAILOVER |
| IT19415 | ERROR COMPRESSION OPERATION ALREADY IN PROGRESS ... WHEN PARALLEL INSERTS SIMULTANEOUSLY CROSS COMPRESSION THRESHOLD |
| IT19416 | MEMORY CORRUPTION ASSERTION FAILURE IN CRYPTO THREAD WHEN USING SSL BETWEEN A PRIMARY AND A RSS NODE |
| IT19490 | SPL CALLING A REMOTE STORED PROCEDURE REQUIRING CONVERSIONS OF DATATYPES TO A LVARCHAR CAUSES ENDLESS LOOP |
| IT19538 | MEMORY BLOCK HEADER CORRUPTION FOLLOWED BY SEGV AFTER MANY RECURSIVE CALLS TO ORIDXCLAUSECOST |
| IT19557 | CONCURRENT READ ACTIVITY WHILE ALSO PERFORMING ALTER FRAGMENT COMMAND CAN CAUSE SEGV ASSERTION FAILURE |
| IT19611 | PTMAP: BAD PAGENUM ASSERTION FROM RSTALLBLOBS/BLOBABORT WHEN ROLLING BACK WORK ON UNLOGGED TABLE WITH PARTITION BLOB COLUMN |
| IT19702 | TRANSACTION MIX WITH LOGGED TEMP TABS ROLLBACKS AND SQLEXIT CALLS CAN CAUSE RECOVERY ERRORS |
| IT19760 | IFXCLONE CAN CAUSE AN SMX PBACKUP THREAD TO ASSERT FAIL AND BRING THE PRIMARY DOWN |
| IT19806 | SELECT BSON_GET(DATA,ID)::JSON FROM TABNAME CAUSES ASSERTION FAILURE WHEN RUN AGAINST A COLLECTION TABLE |
| IT19869 | HUGE MEMORY LEAK IN MT POOL AT MTMUTEX |
| IT19870 | JDBC CLIENT THAT RETRIEVES AUTO GENERATED KEYS FOR INSERT INTO ... SELECT FROM ... STATEMENT LEAKS OPENTABLE MEMORY AND OPEN TAB |
| IT19896 | ASSERT FAILED WITH MEMORY BLOCK HEADER CORRUPTION IF THE SELECT QUERY USES TEMPSPACES WHERE THE NON PRIMARY CHUNK IS BAD |
| IT19897 | ERROR 9634 NO CAST FROM TYPE-NAME WHEN USING INSERT CURSORS AND SOME BUILT-IN FUNCTIONS |
| IT19989 | INSERT INTO REMOTE TABLE WITH FUNCTIONAL INDEX FAILS WITH -9753 |
| IT20024 | NEWLY ADDED FRAGMENTS IN RANGE PARTIONED TABLE CONTAIN THE WRONG DB NAME IN PARTION WHEN ADDED BY REMOTE INSERT |
| IT20026 | TRANSACTION COMMIT MAY BE DELAYED WHEN USING BUFFERED LOG DATABASE WITH HDR |
| IT20074 | CREATE TABLE AFTER A MERGE OF REMOTE TABLES COULD FAIL WITH -312/-101 |
| IT20075 | RSS PRIMARY SERVER CAN HANG/LOCK UP WITH RSS_SEND/RSS_RECV THREADS SPINNING ON THE BACKLOGWAITLOCK SPIN LOCK |
| IT20133 | A LISTENER THREAD ERROR IN SSL CAN CAUSE HIGH CPU UTILIZATION BY THE SSL POLL THREAD |
| IT20166 | SHARED LOCK HELD ON BLD REF ### WHEN DDL INSERT ON TABLE WITH REFERENTIAL CONSTRAINT WAITS ON LOCK HELD BY PARENT TABLE |
| IT20356 | ERROR CREATING THE RPM INSTALLER IN 32-BIT PRODUCT |
| IT20358 | AUTO_CRSD TASK TRIES TO COMPRESS ENTERPRISE REPLICATION DELTABS AND RETURNS ERROR 102 |
| IT20370 | HPL ONPLOAD LOAD JOB DOES NOT LOAD ALL ROWS INTO TABLE AND FAILS WITH ERROR HPL FAILPOINT 14100 |
| IT20428 | SOCSSLLST THREAD CAN BLOCK FOREVER DURING ACCEPT OF CLIENT CONNECTION, WAITING FOR RESPONSE FROM CLIENT |
| IT20482 | A SELECT STATEMENT USING LEFT JOIN, NVL AND OPTCOMPIND 2 IS SLOW AND LARGE VALUES ARE SHOWN IN SQEXPLAIN.OUT ESTIMATES |
| IT20484 | SERIAL VALUE GENERATION BROKEN FOR TEMP TABLES ON SECONDARY SERVERS |
| IT20525 | WHEN MULTIPLEX CLIENTS CONNECT USING ONSQLMUX PROTOCOL, 4 BYTES OF CORRUPTION CAN CORRUPT MEMORY YIELDING RANDOM SERVER FAILURES |
| IT20536 | ERROR 32504 REMOTE OPERATION NOT ALLOWED WHEN DOING A REMOTE QUERY AFTER ANOTHER SESSION CHANGED INDENTITIES |
| IT20537 | QUERY PLAN CHANGED AFTER UPGRADE FROM IDS 12.10.FC4 TO 12.10.FC7 |
| IT20579 | ONMODE -K HANGING, THEN ONCLEAN -K AND RESTART WOULD LEAD TO SAME INSTANCE RUNNING TWICE |
| IT20684 | MUTEX RELATED MEMORY LEAK IN MT POOL |