Some of our customers faced this problem: After some time of heavy usage of one table (many inserts and deletes, but max about 200 rows in average table size) sometimes the primary key index of this table doesnt work any more. Selecting by id gives incorrect results.
Validating table and index doesnt show an error. Rebuilding the primary key index fixes this problem temporarily.
The problem appears in different intervals (sometimes hours, sometimes days, sometimes weeks). As a dirty workaround we used a database event rebuilding this index hourly.
Anybody facing this problem too? Any hints what can cause this problem?
Server version is SQL Anywhere 22.214.171.1242. Client software uses sajdbc4 driver.