Subject Anomalous behavior of sql server
Author Jack Cane
Post date 2014-03-16T12:33:43Z
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