FairCom Corporation
 
FairCom Start PageFairCom ProductsDownloadsDeveloper SupportSales InformationFairCom CustomersFairCom Company InformationContact FairCom

Homebulletgrey.gifTechnical Newsbulletgrey.gifPrevent Data Corruption from Concurrent FPUTFGET Updates


Prevent FPUTFGET Data Corruption with Concurrent Updates

20 January 2010

Affected Builds: All builds between 050722 through 100120
Criteria: Concurrent FPUTFGET record add/updates to variable length files.
Indications: Unexpected ITIM_ERROR (160) errors

In c-tree multi-user standalone (FPUTFGET) mode, when a process updates a record, increasing the size of the record, while at the same time another process adds a record, and if there is deleted space available after the record that is being updated, the update logic could reuse that space even though the add operation has already used the space for the newly-added record.

This issue only affects the c-tree multiuser standalone mode (FPUTFGET) and does not affect the c-tree Server.

A code change applied in July 2005 modified previously correct behavior. As a result, the logic in RWTVREC() that reads the key from the space management index after locking the space that is a candidate for reuse skips the call to read the key from the space management index. This omission can cause the update to enlarge the record into space that has been reused by a record add operation. The ITIM_ERR (160) was observed in that an index key entry pointed to an offset in the data file that was within another record. That record had been enlarged by an update operation, and it overwrote a record that was added at the same time the record was updated. A simple rearrangement of code prevents this behavior.

FairCom customers on current maintenance can request an updated V9 c-treeACE line at any time. Please contact your nearest FairCom office should you have any concerns that you are impacted by this update.

Microsiga Software is a Brazilian Company specializing in technology and systems development for enterprise management, with its sole focus on the corporate sector. With over 20 years of proven technology and services, Microsiga is the undisputed market leader in Brazil and a key player in other Latin American countries. One of the main factors that contribute to Microsiga's ongoing success is that they offer products and solutions to companies of all sizes in all market segments. Microsiga integrates FairCom as one of the database partners. Microsiga has chosen FairCom due to its flexibility, portability, reliability, and performance..

FairCom is the only database available for use on Unix platforms (including Linux) for the control of the data dictionary, and it is now the default database for Windows as well. Microsiga and FairCom worked closely for over a year on a number of aspects related to the Advanced Protheus project, including the integration of Microsiga's application server and the c-tree Server into a single executable, allowing for unprecedented scalability.

(860KB PDF)

FairCom Start PageSite MapContact FairComThe FairCom Privacy Policy Your Location: USA | Europe | Brazil | Japan
Copyright 2010 FairCom Corporation. All rights reserved.