Fix list for Informix Server 14.10.xC9 release

Release Notes


Abstract

Informix Server provides periodic fixes for release 14.10. The following list is the most recent report of defect fixes for customer-reported defects in 14.10.xC9 releases. 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 Pack 14.10.xC9

Fix release date: 21 October 2022

Status: Recommended

APAR

Abstract

IT32364

ONMODE -P START <SERVERNAME> on a port in use creates an assert warning instead of a simple error message

IT33601

DOC: ENCODEBASE64 FUNCTION SYNTAX IS WRONG

IT34407

WINDOWS: "STAT() FAILED FOR CHUNK FILE..." messages while creating a chunk larger tan 2GB

IT34842

Connection errors are not reported by drda-listener

IT36381

Exporting a backup from PSM with BACKUP_FILTER/RESTORE_FILTER reporting "(-43082) Writing to backup and restore filter failed"

IT37866

Various assertions seen in restorerow() on a nonlogged compressed interval rolling window table during a rollback of work

IT37894

HDR: Server crashes trying to change the type of an old primary to secondary with hdrmksec.sh if a logical log was not backed up

IT38830

COMPLEX QUERY WITH A MIX OF LEFT AND STANDARD joins CAUSE -768 IN OPJOIN

IT39100

MORE EXPLANATION IS NEEDED REGARDING WHAT AN ERROR OR WARNING IS (NEXT TO ONLINE.LOG IN SERVER STATUS)

IT39132

Informix HQ DBSchema SPF is displaying all the system defined functions and procedures in a user-defined database

IT39292

Running update statistics on a stored procedure that references a missing column throws error -217

IT39529

959/172 occurs when delete data from tables through synonyms

IT39652

count(distinct) over' in a 'case' statement with multiple 'when' clauses causing 768 in buildolapcol

IT39865

ONSMSYNC reports error 100 handling an older space from a different timeline, which does not exist

IT39982

On mode -c block or unblock on an empty RSS fails

IT40025

CDR sync REPL ON A TABLE IN A dbspace with 0 free pages can cause an AF on the target server

IT40075

"CDR DS CDRD_<##> THREAD IS ABORTING." messages with er target apply transaction aborts.

IT40127

"... FRAGMENT BY RANGE ... STORE IN" does not throw error -794 when dbspace does not exist

IT40128

"... FRAGMENT BY RANGE ...  STORE IN(D1, D2)" works when the dbspace have a different size page

IT40129

Conversion failed on RSS server when any logical log is not marked as backed up on RSS

IT40297

When online.log is empty Logs -> online log is throwing, "Could not position within a file via an index. "

IT40327

Query runs slower in 14.10 as compared to 11.50 with same distribution.

IT40423

"UDI Counter" doesn't seem to be useful

IT40493

AFTER A MODE CHANGE TO QUIESCENT/SINGLE-USER, CONNECTION MANAGER
NO LONGER ALLOWS DIRECT ACCESS TO THE SERVER

IT40516

Switching from secondary to primary role can hang in 'cond wait drcb_cond'

IT40623

Repack and shrink is not successful if table contains partition blobs with large addresses.

IT40736

Stressing shmtotal with disk_encryption turned on can crash server during physical or logical logging.

IT40737

Assert possible in ssc_link with stmt_cache enabled if shmtotal is stressed.

IT40738

A listen thread can assert mt_free_mutex call on already freed mutex and crash the server if SHMTOTAL stressed

IT40747

IN TIMESERIES AND VIRTUAL TABLE INSERT INTO TABLENAME SELECT * FROM TABLENAME WON'T POPULATE ANY ROW IN THE NEW TABLES USING SP

IT40774

-410 AFTER TRUNCATING A TABLE WITH INTERVAL FRAGMENTS WITH ATTACHED INDEXES WHEN TABLE WAS RUNNING OUT SPACE BEFORE

IT40805

AF on rss server after upgrade from 11.70 to 14.10.FC6.

IT40812

External table is not accepting "\" as an empty string when next field is TEXT

IT40822

MULTISET query produces memory leaks and crashes

IT40864

Error -768 on Table with count of rows > MAXINT

IT40875

Nested collection subquery returning empty with 'order by' on main query

IT40931

ONBAR -B -W -L 0 CAN FAIL WITH ERROR -131 DURING PARALLEL WORKLOAD ON THE DB SERVER

IT40932

Lock table in exclusive mode not propogated to rss/sds secondary.

IT40986

Enhancement for checkpoint processing

IT40999

Connection Manager throws syntax error in $INFORMIXDIR/etc/cmalarmprogram.sh on startup

IT41016

Defining DBSERVERNAME to create multiple listener threads is throwing Assert Warning

IT41041

Configuring multiple listen threads for an ONSOCTCP DBSERVER does not work

IT41114

Crash on ev_jnchar in a query with OLAP OVER (PARTITION BY) when aggregate function has a subquery

IT41138

HQ server writes to console

IT41196

Dropping an external table in a stored procedure can fail with -214/-106 when it is run with PDQ

IT41236

SIGBUS ASSERTION CRASH SEEN IN SQLISDRDAASCBGETDATAPTR WHEN USING DRDA AND AN INT8 PLACEHOLDERS

IT41351

Hash joins requiring overflow now failing with -208

IT41355

CLR SERVER CAN GET ASSERTION WHILE APPLYING LOG RECORDS PERASE AND PTRUNCATE DUE TO BREAK FLAG SET

IT41363

INFO when HQServer is started is displaying ssl.key.password in plain text

IT41365

AUS: AUS_CMD_ERR_SQL/AUS_CMD_ERR_ISAM IN AUS_COMMAND ARE NOT
FILLED PROPERLY

IT41368

HQ user interface might not show server information in a cluster setup with more DBSERVERALIAS

IT41374

Migrating H2 database for HQ 2.0.0 can corrupt H2 database

IT41405

INFO in HQ server logfile is still showing keystore password in plain text when intialAdminPassword commented out

IT41463

Query on columns sql_hvar_type and sql_hvar_data of table syssqltrace_hvar shows invalid information

IT41564

Syscluster entries are not consistent when HDR is defined between DBSERVERALIASES servers

IT41586

CDR CHECK REPL FAILS WITH "COMMAND FAILED -- WARNING: REPLICATE IS NOT IN SYNC (178)" FOR LOOPBACK REPLICATE.

IT41587

Command "cdr list catalog -r" should include option "--erkey" if the replicate was created with that option

IT41634

Assertion crash in doinsert

IT41708

Writing a shared memory dump with many shared memory segments causes exception recursion

IT41722

InformixHQ:  Clicking Performance -> Sessions -> Session ID hangs and throws "An attempt was made to divide by zero" exception

IT41728

Possible wrong results by using a compressed index depending upon isolation level

IT41816

SQL with "CONNECT BY" clause throws error -264 Could not write to a temporary file. / ISAM Error -112

IT41844

Onsmsync exits with 0x3 (Aborted) when exporting cloud (AWS) with split objects into multiple pieces.

IT41941

Backup data version is not compatible with Online version if using STDIO within different Special Build versions

IT42087

Onstat -g laq potentially showing garbage latency value


Document Information

Component:
Informix Publications->14.10

Software version:
14.10.0

Operating system(s):
AIX, HP-UX, Linux, Mac OS, Solaris, Windows

Document number:
6832820

Modified date:
03 November 2022

UID

ibm16832820