Bug #4795 | Data removed from MyISAM tables when running SELECT queries | ||
---|---|---|---|
Submitted: | 28 Jul 2004 20:47 | Modified: | 28 Jul 2004 20:52 |
Reporter: | Greg Wolgemuth | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S1 (Critical) |
Version: | 4.1.3-beta-nt | OS: | Windows (Windows 2000 SP 4) |
Assigned to: | Matthew Lord | CPU Architecture: | Any |
[28 Jul 2004 20:47]
Greg Wolgemuth
[28 Jul 2004 20:52]
Matthew Lord
Dear Sir, We need to have a repeatable test case to proceed in this avenue. This seems very strange. I would enable the general log so that you can see if someone is executing these sql statements w/o your knowledge. Best Regards
[28 Jul 2004 21:02]
Greg Wolgemuth
For all future testing, we've enabled --log and --log-bin on the server daemon. However, I can guarantee that no other SQL commands were being run on this server - only about ten people know this 'server' (an old PIII 500) exists, then only four know that the database is loaded on it, and then only one system/person was ever running commands on the database.
[10 Jun 2005 3:52]
Santhanam Veerasamy
Dear Friends, This problem happens in MySQL 4.0.17 on Redhat Linux 9 / RHEL 3 AS also. Please suggest a solution. We are using MySQL for very critical and sensitive purpose. Thanks in Advance With Regards SAnthanam