Hello Tim,

> We are currently having an issue with a client database that keeps both losing data and getting black entries on certain tables.
>
> We have an Options table which stores all of the system wide settings for our application. For this client their options table is being cleared and all settings are being lost. We also have a Members table which stores all of the user information that is getting black users added to it.
>
> Using Gfix, we have run a validate on the database which didn't show any errors. We then tried a Mend followed by a Backup and Restore to see if this would prevent the issue. However only 10mins after performing these steps the options table was blank again.
>
> Any suggestions as to what may be the cause would be greatly appreciated.

Jump on the monitoring train. Either with a trigger based solution like
IBLogManager or if you are using Firebird 2.5, the Trace API might be an
other option.


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!