InterBase 2009 Hotfix Update 4 Readme for Windows (version 9.0.4.443)

By: Sriram Balasubramanian

Abstract: InterBase 2009 Hotfix Update 4 Readme for Windows (version 9.0.4.443)

    InterBase 2009 Update 4 Readme

Updated: May, 2010

 

This file contains important information that may not appear in the available guides. Read this file in its entirety. This hotfix update is a cumulative hotfix and can be applied to any installation of InterBase 2009. It contains all the fixes done since the first release of InterBase 2009. You can download the updates from http://cc.codegear.com/reg/interbase

    Installation Instructions

    Windows

Run the executable InterBase2009Update4_Windows.exe, and then choose one of the following:

§         Server and Client
After you choose an install location; this will replace the binaries in the existing InterBase installation. Make sure to stop the InterBase Server before installing.

§         Client only
This will install IBConsole.exe and the type 4 InterBase JDBC Driver.

§         Extract Files only
This will extract the hotfix files in a single directory to be installed at a later time by the user.

    Resolved Defects

The following are InterBase bugs fixed since the InterBase 2009 Update 3 release:

Internal Defect #

External Defect # (QC)

Description

Hotfix Update 4: 03-May-2010, version 9.0.4.443 (Windows) 

275463

 

INTB-412: Running delete statement two times causes constraint error, which causes the server to crash. 

275462

 

INTB-411: Database corruption reported when deleting records from table with missing foreign key constraint index. 

INTB-384

 

Indexes entries lost on savepoint rollback for updates across nested savepoints. 

274857

274858

 

INTB-356: Table's current format descriptor can be garbage collected during sweep. 

273917

 

INTB-331: gds32.dll not getting installed in system 32 directory. 

INTB-305

 

During certification, ibserver often starts claiming errors into the interbase.log recursively until it has taken up the whole disk space.  

INTB-292

 

Prepared statement query fails on UTF8 database. 

INTB-281

 

InterBase server crashing with a batchupdate query from Java. 

272016

 

INTB-252: Event listener does not work with native OTW connection string in InterBase 2009 Update 2. 

INTB-249

 

Trying to connect to OTW port without OTW settings causes client hangup.  

270898

 

INTB-231: When executing SQL statements, JDBC driver returns SQLWarning beside the normal result, even on success.  

INTB-230

 

Client crashes on DSQL error when interbase.msg cannot be found. 

INTB-228

 

Wrong table name: Language Reference Manual, Table 5.3. refers to Table B-4. Should refer to Table 5.4  

Hotfix Update 3: 14-Aug-2009, version 9.0.3.437 (Windows, Linux, Solaris, MacOSX) 

263854

 

Hot links from within the PDF documents to other PDF documents come up with an error 

267667

 

Page xxxx wrong type (expected 7 and encountered 5) after many hours of stressful INSERT activity from numerous simultaneous clients.

268686

 

InterBase client on Windows Terminal Services reports "Cannot attach to Services Manager" when run for extended period of time, or if the server is subject to intense database activity.

268798

 

Inner join with Stored Procedure that selects from the same table results in "No current record for fetch operation".

269200

 

IBConsole Help is out of date on Windows Vista.

269555

 

Online Dump files have corrupted indexes and page errors when taken from an encrypted database during multi-client activity.

269558

 

Online Dumps are missing one (1) record after multi-client activity. The record is present in the source database, but is not included in the online dump.

270017

 

Multiple clients concurrently executing ALTER TABLE statement against different databases results in client error or hang.

270024

 

InterBase cannot use 2GB+ database cache even if Large Address Aware flag was set

Check Operations Guide PDF manual, chapter “InterBase Limits” section “Various InterBase Limits”, Table B.1, for new updates. Search for “Maximum number of cache pages per database” description.

270284

 

A complicated query involving joins between tables and stored procedures run very slowly.

270396

 

Java clients are unable to connect to databases that require a System Encryption Password, (SEP).

270898

 

When executing SQL statements, JDBC driver returns SQLWarning beside the normal result, even on success.

270959

 

Accessing ODS 10.x database leads to server crash.

271600

75571

"Request Synchronization error" reported on 8-core system with heavy activity.

272016

 

Event listener does not work with native OTW connection string in InterBase 2009 Update 2

INTB-159

 

OTW/SSL connections do not work via InterBase JDBC driver.

Check Developer’s Guide PDF manual, chapter “Programming with JDBC” section “SSL file properties” for new updates.

INTB-230

 

Client crash on DSQL error when interbase.msg cannot be found.

 

Many IBConsole usability issues in the Metadata/DDL UI

Hotfix Update 2: 20-Mar-2009, version 9.0.2.369 (Windows, Linux, Solaris, MacOSX)

254988

 

Query with explicit and implicit joins results in “no current record for fetch operation” error

256996

 

Distinct in nested queries can return incorrect results

257272

65388

concurrent delete and select (and probably insert) cause database to be corrupted. "internal gds software consistency check (exceeded index level)" error in interbase.log

257670

57839

Join with Stored Procedure returns incorrect results

259585

 

Inner Join between two views which both have left joins results in error “no current record for fetch operation”

260489

 

If journal files are lost, connecting to the database may fail.

Fix notes: A new GFIX switch (-disable wal) is provided to disassociate a database from its journal files. No cleanup of the journal files or journal archive files is attempted and it is the case that committed data may have been lost. This could occur because the lost or inaccessible journals may have committed data that was never applied to the database files proper. However, it becomes possible to attach the database to access existing data contained therein.

261953

 

Rogue TCP packet could cause server crash

261974

 

Server crash with big SORTMEM_BUFFER_SIZE on restore

263533

OTW: malformed connection string leads to server hang

265145

Invalid data entered into a Unicode column hangs client on retrieval operation

265481/2

Journaling and encryption combination fails with “decryption of encryption value failed”

265601

 

Running GBAK as a service incurs high CPU usage in the server

265824

 

Queries based on fields where the character_set_name and collation_name do not match and there is an index return no records

265905

 

Security vulnerabilities exploited by rogue clients

267372

 

InterBase cannot propogate events on both interfaces of a multihomed host

267433

 

Exceptions only displays first 67 characters. They should display 78 characters

267550

 

Server crashes with BUS alignment error on Solaris 10

267860

70915

Sweep under some conditions causes error "Maximum user count exceeded" and "Request depth exceeded for IRQ_93" in interbase.log

267874

 

Many users doing many inserts causes InterBase server crash with seg fault on Windows or Solaris if there are multiple CPUs

267963

 

After connecting to employee.gdb, subsequent validation of the database with gfix results in interbase.log having numerous "Page xxx is use but marked free"

268016

 

InterBase Services API has problems working on Windows Terminal Services

Hotfix Update 1: 23-Sep-2008, version 9.0.0.226 (Windows) : 9.0.0.228 (Linux, Solaris, MacOSX)

65959

Backup/Restore of encrypted databases not supported in IBConsole

265043

Encryption failed when database or column has a character set

265241

Re-encrypting a column crashes the server

258311

Restore using gbak with buffers set high and -o (one at a time) causes server to crash.

JDBC: DataBaseMetadata.getTables() does not work with delimited tables/columns

JDBC: DataBaseMetadata.getTables() wrong ordering of result set

JDBC: does not recognize InterBase 2009 reserved words

    File List

Following are files in this update:

    Windows

§         bin\ibserver.exe

§         bin\gfix.exe

§         bin\isql.exe

§         bin\gstat.exe

§         bin\IBConsole.exe

§         bin\gds32.dll

§         SDK\lib\interclient.jar

§         Doc\readme.html

§         Doc\*.pdf

 

Copyright © 2009 Embarcadero Technologies Inc. All CodeGear brand and product names are trademarks or registered trademarks of Embarcadero Technologies in the United States and other countries. All other marks are the property of their respective owners.

Server Response from: ETNASC04