FairCom DB V12 Release Notes

Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Automatic Recovery

Automatic recovery - Improved handling of duplicate file IDs and transaction-dependent operations

Automatic recovery and duplicate file IDs

Automatic recovery error L64, 1120 fixed

Automatic recovery failure with code L64 or error 1120 with unusual index conditions

Automatic recovery failure with error 413 fixed

Automatic recovery may fail with error 8776 after delete and rename of superfile member

CHECKLOCK_FILE configuration option now supports wildcard characters

Client no longer loses connection to server after a failed CompactIFile() call when using TCP/IP protocol

Communications Layer

Core Engine

Critical Fixes

ctCopyFile function now opens files in exclusive mode to ensure a clean copy is made

ctdbAlterTable in a CTSESSION_SQL session no longer removes synonyms and table granted permissions

ctdbGetRecordKeyPos no longer causes ctdbNextRecord unexpected behavior on partitioned files

c-tree Server no longer logs immediate restore error message on Unix even when immediate restore is successful

c-tree Server no longer terminates with unhandled exception when DISK_FULL_ACTION causes shutdown

c-tree Server rare abnormal termination with Dynamic Dump !PROTECT option fixed

c-treeDB - ctdbNextBatch() no longer returns last record twice when filters are in place

Data Integrity

Deferred Index thread now retries in case of log read error

Deferred index thread shutdown delay fixed

Delayed durability log flush no longer causes rare invalid transaction log entry

Delete Node Reuse List Default Behavior Change

DSQL - Corrected bad behavior when getting data with wrong datatype function

DSQL - ctsqlSetParameter() properly handles strings without null terminator

Dump restore immediately after dump backup may skip rolling files back to the dump start time

Dynamic Dump and Backup/Restore

Dynamic Dump fixes

Enabling function timing no longer reduces server throughput

Enhanced Detection and Reporting of Filesystem Flush Errors to Protect Data Integrity

Ensure recoverability if server terminates while changing master encryption key

Error 160 after switching an index's transaction mode fixed

FairCom DB SQL Server

FairCom DB V12 Release Notes

FairCom Server

FairCom Server file permission inheritance changes

File compact no longer changes compression type to the database default

File Management

File open optimization no longer causes errors opening or deleting files

Fix to preserve encryption when compacting files

Fixed automatic recovery error 12 if server terminated after PUTHDR() ctTIMEIDhdr

Fixed crash and recovery errors due to transaction logs exceeding 2GB

Fixed c-tree Server unhandled exception when using background flush

Fixed error reading transaction logs using advanced encryption

Fixed FairCom Server unhandled exception when using preimage swap file and log encryption

Fixed rare server crash following errors during index node split

Fixed server crash from corrupted Resource Definition Map

Fixed transaction log read errors when using delayed durability and encrypted transaction logs

Fixed unexpected c-tree core activity while server is in Quiet state

Immediate restore - Fixed incorrect parsing of local directory name from script name command-line option

Improve Automatic Recovery detection of a mismatched file caused by copying a file outside the server

Improve batch read resilience to errors caused by record updates

Improved Detection of Logically Equivalent Filenames during Automatic Recovery

Improved Large Transaction Performance

Improved recovery handling of system file copy followed by deleting the file

Improved shared memory performance on system with one CPU core

In case of L64 recovery failure, log a message to CTSTATUS.FCS and return an error rather than exiting the process

Index create or rebuild now requires much less time when using large SORT_MEMORY values

Index Node Split Error

Indexing

Infinite loop when IICT updates index member more than once

Invalidate variable-length data file space management index in case of error

Java Hibernate driver now correctly executes SQL statement with SKIP clause

Logging, Error Reporting, and Messaging

LOKREC() ctCHKLOK mode now returns lock information for lock acquired using co-file

Memory corruption during multi-member index file open fixed

More Batch Operations Improve Network Traversal Performance

Notable Compatibility Changes

Open of transaction-controlled mirrored file on Unix no longer fails with error 549

Performance

PREIMAGE_DUMP and ctDEFERBEG interaction no longer causing long dump delay

Rare automatic recovery failure fixed

Rare index corruption following recovery fixed

Rare KDUP_ERR resolved

Rare missing index keys after Create or Rebuild fixed

Rare unexpected shutdown with error 8757 fixed

Relational FairCom DB SQL

Security

Server no longer crashes if ctSysQueueClose() is called while queue in use

Slow connection or shared memory error fixed in specific situation

SQL

SQL - Enforce record size checking

SQL - Failed update statement now returns correct error

SQL - LIKE now returns correct result in Unicode server

SQL - LONG field handle validation

SQL - OVERLAY function now compliant with SQL:1999 standard, LPAD/RPAD do not overflow

SQL - Rare server crash after network error fixed

SQL columns defined as money(17) or money(18) no longer silently overflow

SQL crash after PANIC with unusual query

SQL now considers string literal as VARCHAR during parsing

SQL Stored Procedures

SQL Stored Procedures - Close cursors that were left open

Startup/Recovery no longer fails (error 66, RCHK_ERR) in rare circumstances involving large forward roll

Superfile member open no longer fails with POPN_ERR

Table locks no longer prevent reuse of empty index nodes

TLOG_ERR after turning off transaction control for a file fixed

Transaction Processing

TransactionHistory() fixes

Turning background flush for TRNLOG files off and on may cause memory overwrite

Unhandled exception shutting down database engine using Server DLL

Unlock failure while closing file no longer causes infinite loop

Unusual SQL query no longer causes panic and server crash

Using c-tree library without transaction support to rebuild or compact a file no longer removes ctTRANMODE / ctPIMGMODE mode

When a transaction deletes a key and adds it with a different offset then aborts, subsequent add of the key no longer fails with KDUP_ERR