Уважаемые знатоки, прошу помощи!
Ситуация хуже не придумаешь, пару дней назад погиб УПС, заказали новый, а вебсервер (AMD Opteron 185/ASUS A8N-VM/RAID1 2*74GB HDD WD Raptor SATA/HDD WD80GB IDE backup) был временно подключён напрямую в сеть. И в этот момент случилось отключение электричества. Де факто падение MySQL, восстановление таблиц выдало:phpbb_attachments repair Error Can't find file: 'phpbb_attachments' (errno: 2)
phpbb_attachments repair status Operation failed
phpbb_bookmarks repair Error File './AHTEPO_velokuban/phpbb_bookmarks.MYD' not ...
phpbb_bookmarks repair Error Can't find file: 'phpbb_bookmarks' (errno: 2)
phpbb_bookmarks repair error Corrupt
phpbb_chat repair Error Can't find file: 'phpbb_chat' (errno: 2)
phpbb_chat repair status Operation failed
phpbb_chat_sessions repair Error File './AHTEPO_velokuban/phpbb_chat_sessions.MYD' ...
phpbb_chat_sessions repair Error Can't find file: 'phpbb_chat_sessions' (errno: 2)
phpbb_chat_sessions repair error Corrupt
phpbb_confirm repair Error File './AHTEPO_velokuban/phpbb_confirm.MYD' not fo...
phpbb_confirm repair Error Can't find file: 'phpbb_confirm' (errno: 2)
phpbb_confirm repair error Corrupt
и т.д.
День поисков "профессионалов" по *nix плодов не дал. Все их познания сводились к моему начальному уровню познаний freebsd, а именно fsck -y во single-user mode. В итоге выяснилось, что дело в падении /dev/ar0s1h
# fsck -y /dev/ar0s1h
** /dev/ar0s1h (NO WRITE)
** Last Mounted on /data
** Phase 1 - Check Blocks and Sizes
INCORRECT BLOCK COUNT I=23624 (55136 should be 54784)
CORRECT? no
INCORRECT BLOCK COUNT I=47912 (3648 should be 3744)
CORRECT? no
INCORRECT BLOCK COUNT I=47934 (1920 should be 1856)
CORRECT? no
INCORRECT BLOCK COUNT I=48014 (5024 should be 4736)
CORRECT? no
INCORRECT BLOCK COUNT I=48186 (768 should be 800)
CORRECT? no
INCORRECT BLOCK COUNT I=48196 (3936 should be 5088)
CORRECT? no
INCORRECT BLOCK COUNT I=119220 (1056 should be 480)
CORRECT? no
INCORRECT BLOCK COUNT I=2010317 (800 should be 480)
CORRECT? no
8020120 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020121 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020122 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020123 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020124 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020125 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020126 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
8020126 DUP I=2012405
UNEXPECTED SOFT UPDATE INCONSISTENCY
............сокращено....................
** Phase 2 - Check Pathnames
DUP/BAD I=2335000 OWNER=www MODE=100644
SIZE=275834 MTIME=Aug 14 13:35 2013
FILE=/lost+found/#2335000
UNEXPECTED SOFT UPDATE INCONSISTENCY
REMOVE? no
DUP/BAD I=2335002 OWNER=www MODE=100644
SIZE=311258 MTIME=Aug 14 13:37 2013
FILE=/lost+found/#2335002
UNEXPECTED SOFT UPDATE INCONSISTENCY
REMOVE? no
DUP/BAD I=2022703 OWNER=www MODE=100666
SIZE=452373 MTIME=Aug 22 13:39 2013
FILE=/lost+found/#2022703
UNEXPECTED SOFT UPDATE INCONSISTENCY
REMOVE? no
UNALLOCATED I=2335523 OWNER=root MODE=0
SIZE=0 MTIME=May 12 08:10 2012
FILE=/sites/vb/www/images/stories/virtuemart/category/resized/glory_1_enl[1][1]_250x250.jpg
UNEXPECTED SOFT UPDATE INCONSISTENCY
REMOVE? no
............сокращено....................
BAD/DUP FILE I=2708733 OWNER=root MODE=0
SIZE=0 MTIME=Jan 1 03:00 1970
CLEAR? no
BAD/DUP FILE I=2708734 OWNER=root MODE=0
SIZE=0 MTIME=Jan 1 03:00 1970
CLEAR? no
BAD/DUP FILE I=2708735 OWNER=root MODE=0
SIZE=0 MTIME=Jan 1 03:00 1970
CLEAR? no
** Phase 5 - Check Cyl groups
FREE BLK COUNT(S) WRONG IN SUPERBLK
SALVAGE? no
SUMMARY INFORMATION BAD
SALVAGE? no
BLK(S) MISSING IN BIT MAPS
SALVAGE? no
ALLOCATED FRAGS 263656-263663 MARKED FREE
ALLOCATED FRAGS 263688-263695 MARKED FREE
ALLOCATED FRAGS 263816-263823 MARKED FREE
ALLOCATED FRAGS 267984-267991 MARKED FREE
ALLOCATED FRAGS 268008-268015 MARKED FREE
............сокращено....................
ALLOCATED FRAGS 279344-279359 MARKED FREE
ALLOCATED FRAGS 279384-279391 MARKED FREE
ALLOCATED FRAGS 279432-279439 MARKED FREE
ALLOCATED FRAGS 279456-279463 MARKED FREE
ALLOCATED FILES 1884224-1884227 MARKED FREE
ALLOCATED FILES 1884229-1884243 MARKED FREE
ALLOCATED FILES 1884246-1884251 MARKED FREE
ALLOCATED FRAGS 7528157-7528159 MARKED FREE
ALLOCATED FRAGS 7528240-7528244 MARKED FREE
ALLOCATED FRAGS 7528270-7528277 MARKED FREE
ALLOCATED FRAG 7532962 MARKED FREE
ALLOCATED FRAGS 7534165-7534175 MARKED FREE
ALLOCATED FRAGS 7534184-7534190 MARKED FREE
ALLOCATED FRAG 7534310 MARKED FREE
ALLOCATED FRAG 7534383 MARKED FREE
ALLOCATED FRAG 7534412 MARKED FREE
ALLOCATED FRAG 7534571 MARKED FREE
ALLOCATED FRAG 7534606 MARKED FREE
ALLOCATED FRAG 7534648 MARKED FREE
ALLOCATED FRAG 7534651 MARKED FREE
ALLOCATED FRAG 7534713 MARKED FREE
ALLOCATED FRAG 7534766 MARKED FREE
ALLOCATED FRAGS 7534874-7534875 MARKED FREE
ALLOCATED FRAG 7534879 MARKED FREE
ALLOCATED FRAG 7535070 MARKED FREE
ALLOCATED FRAGS 7538629-7538631 MARKED FREE
ALLOCATED FRAGS 7550894-7550895 MARKED FREE
ALLOCATED FRAGS 7555424-7555447 MARKED FREE
ALLOCATED FRAGS 7555480-7555484 MARKED FREE
ALLOCATED FRAGS 7999268-7999271 MARKED FREE
ALLOCATED FRAGS 8060576-8060580 MARKED FREE
ALLOCATED FRAGS 9240328-9240383 MARKED FREE
ALLOCATED FRAGS 9243760-9244071 MARKED FREE
LOST 128 DIRECTORIES
UNEXPECTED SOFT UPDATE INCONSISTENCY
ALLOCATED FILES 2637888-2638079 MARKED FREE
ALLOCATED FRAGS 10538374-10538375 MARKED FREE
ALLOCATED FRAGS 10538400-10539142 MARKED FREE
ALLOCATED FRAGS 10539144-10539163 MARKED FREE
LOST 127 DIRECTORIES
UNEXPECTED SOFT UPDATE INCONSISTENCY
ALLOCATED FILES 2685120-2685247 MARKED FREE
ALLOCATED FILES 2685312-2685375 MARKED FREE
ALLOCATED FRAG 10726695 MARKED FREE
ALLOCATED FRAGS 10726715-10727308 MARKED FREE
ALLOCATED FRAGS 10727312-10727348 MARKED FREE
ALLOCATED FRAGS 10727641-10727952 MARKED FREE
ALLOCATED FILES 2708672-2708677 MARKED FREE
ALLOCATED FILES 2708679-2708681 MARKED FREE
ALLOCATED FILE 2708683 MARKED FREE
ALLOCATED FILES 2708685-2708686 MARKED FREE
ALLOCATED FILES 2708688-2708692 MARKED FREE
ALLOCATED FILES 2708695-2708718 MARKED FREE
ALLOCATED FILES 2708720-2708735 MARKED FREE
147953 files, 2838703 used, 24703928 free (58296 frags, 3080704 blocks, 0.2% fragmentation)
Гугл прямых ответов народа как восстановить систему после такого сбоя не дал, кроме умничанья "профиков" на тему "вовремя бэкапиться" (наш бэкап-винт теперь вообще не определяется ни одним компом, как будто ничего не подключено, слава Богу что data-винты целы остались - RAID1 упорно доказывает, что 2*74 WD Raptor - HEATHLY), или ответы из серии "чувак ты лох, а я умнее", но ни одного прямого ответа, что сделать в такой ситуации.
Друзья, прошу помочь в этой ситуации! На сервере несколько важных сайтов. "Сисадминов" у нас нет, одни "эникейщики" - надежда только на вас.
