{"id":1090,"date":"2009-07-02T22:08:27","date_gmt":"2009-07-02T21:08:27","guid":{"rendered":"http:\/\/www.branedy.net\/?p=1090"},"modified":"2009-07-02T22:08:27","modified_gmt":"2009-07-02T21:08:27","slug":"zfs-boot-zones-and-data-loss","status":"publish","type":"post","link":"https:\/\/www.branedy.net\/?p=1090","title":{"rendered":"ZFS, Boot Zones and data loss"},"content":{"rendered":"<p><strong>Note to Self:<\/strong> <i>One must remember not to accidently pull the power cord out of your OpenSolaris server.<\/i><\/p>\n<p>Somewhere between the sudden power down, and booting into different <a href=\"http:\/\/docs.sun.com\/app\/docs\/doc\/817-1592\/6mhahup1j?a=view\">Boot Zones<\/a> my  <a href=\"http:\/\/www.mysql.com\/\">MySQL<\/a> database has lost records and the <a href=\"http:\/\/www.apache.org\/\"> Apache<\/a> HTTP server logs are missing whole time periods in the access logs.  I have been digging through the <a href=\"http:\/\/www.amazon.com\/OpenSolaris-Bible-Wiley-Nicholas-Solter\/dp\/0470385480\"> OpenSolaris Bible<\/a> 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&#8217;t corrupt, the Data in the logs and MyISAM records are just missing. <\/p>\n<p>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.<\/p>\n<p>I&#8217;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&#8217;ll be more careful of the power and switch the power connection to the Telecom USP. <\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>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<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/www.branedy.net\/?p=1090\">Read more <span class=\"screen-reader-text\">ZFS, Boot Zones and data loss<\/span><span class=\"meta-nav\"> &#8250;<\/span><\/a><\/div>\n<p><!-- end of .read-more --><!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[220,2,198,83],"tags":[213,261,219,229],"class_list":["post-1090","post","type-post","status-publish","format-standard","hentry","category-diy-server","category-general-it-issues","category-mysql","category-rdbms","tag-apache","tag-data-loss","tag-opensolaris","tag-zfs"],"_links":{"self":[{"href":"https:\/\/www.branedy.net\/index.php?rest_route=\/wp\/v2\/posts\/1090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.branedy.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.branedy.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.branedy.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.branedy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1090"}],"version-history":[{"count":6,"href":"https:\/\/www.branedy.net\/index.php?rest_route=\/wp\/v2\/posts\/1090\/revisions"}],"predecessor-version":[{"id":1096,"href":"https:\/\/www.branedy.net\/index.php?rest_route=\/wp\/v2\/posts\/1090\/revisions\/1096"}],"wp:attachment":[{"href":"https:\/\/www.branedy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.branedy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.branedy.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}