Subject Re: [IBO] Anomalous behavior of sql server
Author Jack Cane
Post date 2014-03-16T20:00:38Z
By deleting and re-inserting all after #204, all requested records are now being returned. Now there is a gap in primary key values between 204 and 217, which I can live with but will be curious to see if that continues.

Best,
jwc

On Mar 16, 2014, at 8:33 AM, Jack Cane <jwcane@...> wrote:


Good morning,

I use a Delphi app to scan image files for metadata and post data (not images) to fb table using an instance of TIB_dSql. This has been airtight for months. 

I just found that a select query fails to return all of the last dozen records recently posted. Although the sql management app is still under development, methods to form the dynamic query and post to FB have not been touched recently (as far as I know).

Select requests are passed to a web application on local machine for display of results on Chrome browser. Results (repeated in attached graphic):

PKs 1-204 are OK.
PKs 205, 208, 209, 211 and 215 are not assigned at all.
PKs 206, 207, 212-214 and 216 (last record on table) do not show up.

Questions:
  1. Will Firebird periodically clean the trash and realign PK values so that there are no gaps?
  2. What is my best approach to find reason for non-display of some records?

Best,
jwc