ZFS, Boot Zones and data loss

Note to Self: One must remember not to accidently pull the power cord out of your OpenSolaris server.

Somewhere between the sudden power down, and booting into different Boot Zones my MySQL database has lost records and the Apache HTTP server logs are missing whole time periods in the access logs. I have been digging through the OpenSolaris Bible looking for a reason the data is missing. There appears to be no ZFS snapshots missing, and MySQL show there have been no deletions from the tables and they aren’t corrupt, the Data in the logs and MyISAM records are just missing.

I can point to the File buffering of the file system for the loss, except for the fact that the MySQL database records have been in the database for days, and the Apache Logs have lost whole days worth of records.

I’ll keep you posted, if I find out, as this does not bode well for OpenSolaris if it looses data. In the mean time I’ll be more careful of the power and switch the power connection to the Telecom USP.