Dear all,

We are running mysql 4.0.17 on linux environment.  Our database resides
on external disk connected via FC cables.   We recently noticed a loss
of data in the following scenario.

Inserted a row in a table in a separate transaction by a java
application,
queried a row in the table in a separate transaction by a java
application and was successful.
Then the FC cable connecting to external db disks was pulled and after
sometime put it back
Now the inserted row is missing in the database.

>From our logs, we have a query log that shows the inserted statement
prior to FC cable disconnection.  After cable pull, we have taken
database dump that reveals the missing row that was inserted prior to FC
cable disconnection. 

If somebody would have accidentally deleted, then we can expect the
delete statement in the query log.  But there is no delete statement in
the query log.

Can anybody help.   

With Regards,
Ravi





Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or 
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL 
PROTECTED] immediately
and destroy all copies of this message and any attachments.

Reply via email to