Icon View Incident Report

Serious Serious
Reported By: Jim Garrity
Reported On: 12/6/2012
For: Version 2.11 Build 3
# 3731 Trying to Read the Same Store File from Multiple Sessions Can Cause 1306 File Read Error

I am trying to isolate a problem I am having with my replication updates. I am copying files from a Remote Store to a local store. The Remote Store in located on a dedicated server. When I run the update either here or on a customer site (remotely) all is good (all files are copied normally). However, when I run as a job in the miidle of the night some sites work normally and others download some files and not others or even no files at all. When I remote in to those sites and run the updater it works every time.

In looking at a Log file for the Updater where I know it did not work, I see I am getting error 1306. In this case it looks like none of the files copied. They all are reporting 1306.

Furthermore, I just tried to following:

1) Opened 2 instances of EDBMgr
2) Started a copy of a file from a remote store to a local store on both instances.
3) Eventually, both errored out with the 1306 error "Error reading from the file <filename>


Comments Comments
The problem was that the file streams for the store files were not getting locked propery during a file read, so they were interfering with each other's positioning.


Resolution Resolution
Fixed Problem on 12/18/2012 in version 2.12 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image