SMT MySQL Error: Failed: Can't connect to local MySQL server through socket
On one fine day someone reported that the SMT server is not able to get the repository catalogue. While i checked i found that the queries are not being responded by the DB. So, I've decided to do a service restart. As expected it did not completed within stipulated time. So what i did is that I've killed all the MySQL DB process. Then the unexpected happened. The DB got crashed and did not came up. When i tried to start to start the DB i've been welcomed by the error that i've noted above.
At first what i did is to run "mysqld_safe" to recover the database. That did not end up in a sweet note. But definitely gave me hints that where should i look.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAApwAAAAdCAIAAACIWiumAAAGf0lEQVR4nO2d0YGDIAyGmcdVnIRBGIQ5XO4eVAiQBLBisfd/T3dWkxAigWipMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADMxGK9twvk38Vs9oD7Wd22bRvfzftn27Ztbj2PLdYXxzQ5mvz9w1SORK9eiSAmu0SSr8LYvxAFzXJGEYyR/bO6YabG8Oly6oPc65/Z2ru6se0q5Tf4s5fVjfXl2+UntMXzbPZ8Ov7cFedXlXfJH23P7nS3mtWVTlmsZ4am1QWDaHRIchT5xhjrN2etb4mxTr2qmOX8kzRPkK9T2r+62GHzzIhrlqxuRJAt1k8wrWnhHv+8p70no9p1Y+S/fRn9lUFAUTqbPcaYUePPvPJH2xO1pE4X7uTkxKXIx1Jy5Y4f+bUUUjWwVe++wBClUzGqfF5O1f5KKO+TWO8P4cdqyK3ho3P6Ef7brwuFgM172kek0JBPBhlLYj1hc2tTkPF6ySKOqqBru6RoQfRWpquv8o/U3mDoKS/GCnEEaRTbXoH9Amtd1Ho2Qlwh3dQufQWm+7NzWZNMvKNS8k9mKFWt+L+UL52//72fR+uCx3HHlDMZ+d+N59ns6YnDB+KcjU+tfyX5Upz3j7cfUybF1XnnykJ1nvwy45qT+rHCNlyGrhrYqldP6olnVfmMHNX+c4BpiyS3xqpBFJa2KBymtwetClifVCAy1cVNRetVTeUgSa9ZV5qlch8VYqkhi/Utef0V/pHaGwSE3LMbSuwhVSKlvQIk3dCgfKRdcvIoj/f1uywnOUIzshKHnP81+7nzk44gsUfLmRVrzRfjeTZ7uuNwdJxL8Sn0ryhfkHPpvvsUNunSqVosTd+T1LMVQLUidFGvRPFooSKfsaduv/qkJ1V0Dk907Ih/JsZxzzczg8mjBPL5Qk/I7+16kAnPVenMtJz4ZGLTk8srct7kHy2pM8uI/L0Qb5dKe1my4S07f2y7OpNHR78Hc9W1b6JEiUNxcBCeswnPIqWkzh7n5X8rnmezpz8Ox8a5HJ98/0ryJTnX7rtPYZN6UloJzUlfmfug/C4K4Q28pFdQWGbhinxdnHhyrcyiD+Jno0QFdIWXlXpGJK1SbzpvyT3BiO2sO73LP99J6rmlMyb13n6vCT8Wl9kbMVIcCoODJP+upM7I/1Y8z2bPlaQ+NM7F+OxL6pKcSZK6SSZHyTMDR+oIZeF5UFK/pJcpmyel41b5ahk/tZ/OKNM38YRr1UHc+v35C62DpZPm8+ysKtlQ/kpGxK7yVLyaRmdR/GBjt169KOymGqf1T2JtBn9z0WPn/XVppZ5Ovqtlyfva1ZHUO/u9MDX/yNt8ma7EoTg4iLlKy4jpmkBO6pz8r8XzbPbocciMt6PjXIpPoX9F+YKcS/fdZbIyMufc3MH0iX9Vjio/ftpyw3fpJR+KteKWdvFyNPuJRY01H7ea4znL8XpO2v9FcLPm06Y5d07CcvfES5Iqmqs+5pH0ErXHOxj7Z4qjxSb8jn+CmFw+67iNvo6lt5fRS159iXH4dLvS18j4Frf2++keZUxY8oeqUhyK/pcL1NX+Ot7Y8vFluvBYOnYBvywOZz8ez7PZo8Yhm9THxjnbNKV/Ffm8i/rtAT9K77sC5LL7jZmQf+8fNfe9l/6F/W/IHxXPs9nTzY/GOfhPCK+l9Vz4K3mLBf4xyZeLXt+Wf85s8TyVPYhzAAAAAADwn2G+j3Fhpg4AAAAAAAAAAAAAAAAAAAAAAAAAAAB4HH0PA8g35vwSgrQTXPm2VHyhitt3rZSjyd8/bHsTq1evBNlForiE326nX05Pu4YSnCb7Zx23E8LlL8ZQyKZA7uHvl4/+OvM4BvT7wDgZTWM/Vrf6qSkZ8b2yGQPwlvv6A+VDdeY7hiv3URZXbf012v6wNxN+T11qb78c09WuR6jNDef9PXVqeba94l3+naif7ubufv+dTXuM0O9dP/tQ0PgTxh0aZtx05aGtyxXlTy+j25VWT3ximX7w739PXY3UHjnt7Vpe83vGmt5kV9xs0kpIt+bOD6pOYnpW2e5XsCc49LyU+pmRw87QF+X3lemWwVadsb+r36XzBT8z/au0N2sX2dNU9jMD7dJomrdG6Ee9350VSoKf++dK3Hq7cjVByf9SnMj3nRRXLNJ9zd9fmXwa5HI81PQzPvN2of+o/hTtLOUHyvtIWsGL/VXKHzYO/AHVCctclUzavAAAAABJRU5ErkJggg==)
Then i head towards "/var/log/mysql/mysqld.log" for clues and definite got some of them. The error was saying that my last binary file was corrupted.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAjwAAADwCAIAAACL2CkrAAAgAElEQVR4nO2d0cGkIAyErcdWthILsRDr+Ju7h101wEwkirvqzfd05+9CCEgENdN136Ifpr+/v7+/v2noySmv8e/vbxrOqP01/i2MrzNqOEpb/1ytva/x3HaV5Vf4M8prPNeXdy8/oW48X82eo/NPq3G+t/JQ+Wfb8xT6YXInkdd4hhP7YbpJ37Txz33aO3NWu7b8+ZuiHll+tNKr2dN13Vnzz3XLP9ue83jfhEzT+L5//dzNjq/lT/Pdw/K/9+/me5e/v2mys8ly/FOW+RMYNP1azPiqciKu19yE2yrsvbk13ta7cbtxK/+w9i6GzuWtN7nGEaZRsL2E9w+GYVxrnRtB73Abtcu/g/b9GbwtXT2wGDMNvf1PZqit2vF/WT47//3v93nvet5VfI6PS9VlZ5nyfzuer2ZPZBx+YZzD8en1LyufjfP4fHtV+mF6e+I1LpfHxzGvMb32Podt97/GZCTNx8Hysxg0dj1dtVxl9Xavl52Fk6sW3aFbQ/phqolbt/APa+9SwDK3vg019nxq22gvwUyn75+XPXBau/jkWB6P9TsvJzliI44zDpH/PfvR+UlHmLG39Ni2td0Px/PV7AmPw7PHORufpH9p+aScXdfdRVmmg/nys9fG+s9kAKHnC9m0skyCST29PSEfu9tOJM817J3F31bQSk8uf5FzJ/94QQvcBqbt/pzitheSXb7Z+ee2Kzg5Bvp9MddduySVOOOw9L9XPj7fCVrwOC7/V+P5avbEx+G545yPT9y/rHxWzr7r7qL4k9TcVDpx2Tv0bCl6xqRc1ps+Ac1nWFBscF18L//8Jmjlll4xaO3axHcK/ywOko1DPg5J0KJ7aI2CFt4T+8l4vpo9e4LWqeOcjs9Y0GLl/EdB6z1c8nV6etMzn53tmlQsz9NHBaFBs/zaet8upLPWpRWT217EffyTWJuBJsG0wnms71ppWdvQbcNp7QoErWC/F6bmf5qGfJnljEMctHj5JGjZJzwVQQuV/7PxfDV7/HH4GovV8tnjnI1P0r+0fFLOruvuiixryfE173N+Hv+m7Ss6b3ObbhzHJfKzbZlklT9ubrOyek210ziuxufrZGMpbcJz/LMUk5cPHfdnH/f77QX1ftz+6QP7XOGL7UpfU8Atru332T1OkOvzhxpsHFL/8w20zf76vBEwrS9rLI+F1i7Ay5rl7K+P56vZ445DGLTOHeewaU7/OuVjF8XtuS10O377Z+2NuSD/vX/cuf2+xBdmzyj/rPF8NXvCPHScPwvy2kPkh0+ZlyHyT5e8fHz7tvznXG08X8oejXMhhBBC3B3wvuaOOy0hhBBCCCGEEEIIIYQQQgghhBDiP8b/hk/l357l7QruphMTOO5+cdZi0iOPX/6+6uzPec7jhH6/caLPyn7c/JR7q5Iz3ju/4gBscl0fqPzUOpPy/esoG1d1/XW2/QkV88BV2Yrt19XTspZn6U+2MhzV0qqcC9K635/zUXZH+n0zb5ZLpcRPoIYr3pT/NHXeT5ZB9ZVunviTZVa7Svvb6Nl49ZqbruKmw5Cmhqv/VBC7u3g7P008A+zBukq8HHiH0nv6SUvFa5of2qQb9Ts7n/gZ9K/T3qxdJucQ9zMgk8r61DANHbvTdPt9HIxHN7wT9M+ecTsNL5NBqt84v2PjhF93bFxB2HWNr6+sfDvII7pxaf3AZ9Nwlr7a4rzMyWwFQ/urLP+388B+luSec46v9UbvYno2dMVzqp7WXCy52NBAj+sqOXe+ZLCCvljrShOq0nLv0e/8fOJn3L+8vQPUFeN+xhTrI5RWu8xZjKcnO1lsXeph/7B6uT/N3GdTLpLz+TjB152zk0FhKy10feH+dcb/ds359ZiUv5TSUF8tcpz2Fzz/Z/PAEdwsy5fSs6H72GXiV6dY8P1yYKskC3J4nDv2kERq0aBl7/Ts9Ob8Cpb7LuHS/e6cD/3M+pe1lwcb7GfO+/Q5F3i+ggwFrUC9Uf/wetn5A9ORouWTcUKvu/jzKR60wLIe9q87/jlwGbQezBP/B+cB52lTKGjh/oLl/2oeOITfeVfSs8H1pk8i85EHij34UCTpdeQW155vBa3tye4u/e7oBmE/k/49P2i9xmnoX+M0vMZpeOXFfj1oeeMwNG7LW/PxtVF+VupiqNeQ/HyXHwUtJ3J8FivJxmF4HnBm9kjQgv1FCvnVPHCIrc67jl4Urre4tdzcHgy+j5eennpnNWleXG/YQ4NWUU7Sgoqglfon2RKB3Kbfyfncz7h/eXtTA9e5NRq0utc4juM09N1rnKb8KidBC/R7sN6wf3C9/Px57bj8afN8PE7YdcfO96gPWu1041zjTtZXC660QH+x8n82D+xmWcCOV9OzAbB6TbWt9bSA/cUMXGtP7odsEBeHsd9sjy2nrEuDpeLJHSK36nd2Put3YKrfXrSN4/nZ8+r7lOI5E/RDB/p9T71x/9SP27e3jI5U+lwKle9cXPBPkYuxPH/5Bb++yv6tGf8F/rSbRAfPP9ROUj4bP/i4319gmbXph/PmgRO5jJ6NqKfBfY36XYiV4AbNY8q/1zwQfzxa/FDz13dhbzmGUL8LITQPCCGEEA+jz/erv7gNKoQQQgghhBBCCCGEEEIIIYQQQghxHPer18Pk71bkH1Gub0fu+kYBvboxDX23+algPbf2z9Vo2C/7aPo5DEgMerD8+RNP8KdlSMTLB3YKcXua5oZKSTIf03Q1+y6qxeylkqUdNcnEdlTUnjP9c0Ha9suvaf8RpT/Q9o5DffQtHkd2MXzuiAs9IXb8Ta5b8yZNebVUlE/KIK9RYHIr82r1TJfIrmKqr+SL+acw7o/rA5Xt9c8ndmIdoN7T3WHGxvrFLHVNosW/RTascvnhrFSYPtBGQW/fJVImkfJRu7otPSQvGU/mN2KnEA8BJmaFekLsONMlyidck5nxbyWbktsELahLxHR9fC7mH2Qf0cXB7fXOJ3Z2c7dkOkBEd8e1NNIvns6TDcxVowX2Y5IocLe+V7T8qH4VKZ/4bcNOIW4PvNjsnb6dlMHxYtNn/QWflNO0jIe23/BKC9r5l7F/sruQf1i2ZtZe53xmZ/6fFaK7Qy2N9QuJ3q5ukO+nzMJIwpotaZVA+bvalZfP/HZQ+keI6/O1SRlvfx1+1FEbtPZu7l/dPywIsfY2DVrL8Zo+DPbLK6jztF27F1Y3nx3uCVqw/J3tKsonflPQEo/n6KTMdYnSSXn9T3o1Zm9dNXqmhezc937XxfyD7bMFLD/Hv+TnUzs7HrSQ7o5jaaBf7GxrN14z3aC6eNmhfgzqOeW9tbk9GNWB43pIuHwyMjbsFOLGwFe6l12H+bHH+1lGz4539jd2u6PYvliu2WxTI79/rA5afrXAzqCEzyX9Q1wwYl2c4/pSxA2Zm6qWWdF+MeZkuk1WN2jzRoTq+kT1nNLdvkW/Klw+bBfXQ/J0iXAVRGdLCCFE1dOstpz3DYIQQojHslt35whNlMOEEEIIIYQQQgghhBBCCCGEEEIIIYQQQgghhBA34M56UXMC1z4/0Mr8a/PVRKhLlx38PCpJCHtt7Iv19ju09ZKZBpvggx3/Iefpe0Xr3Td+muqfiWexkTPtCKfqRdnED133GqepYq64xnzShG9LTjQZJ7f4LthOlzYzvU39YUcfO76DS43Ptp0Fx8+l2ituQzaY+rvoafXDNL4+JZl/57MJyaX0R/LqpMnf5tM+N9JWNqI4P/NDjT4T0lXy/GzqrdFJgjpYVhKrMy3bMJVOOqjf05WH/d3730k7snK2/Eb71ymH9xdrJz4OR+WOhRXU03LGZ+nn3tNFc1Y2rF8gUN/L8b+/otrMUr+0F5ZTO//UXHfi7sCEsDfQ03pPFq9xGvp3wcvkwRKzduTOjuo59XPL8sSm+Hzrk6pEpURXifh5l05SqYPlZ3PnoISwuN+LlQcMWsk9Q8hvTsJiWE5MR20rn33tca8K3O8dHZ/Iz4sTC120NzDBLusXCNP3cq4vWK9z3An4oXkpdt2Ju3M0i7kzCZ6qp/UpZZ2+dwatMkMtWNyYMrzzg4mNSPTG9u+TnEBT6rv4Oad47TYjuFPG/e4V+GlwfkLMb7x/UTl+/5Ykw9f8omHQ4ndteHxCPy8DAF5W4LoO7yczfa8fBq1Av4sH87WghbcHd+2vJD+b71v3rrTci3m+HJJNz8olTkAJN7H57KD1WZ2+XzF41Xq/VdAaRzcrfMUzTn/SLMoJTtabQaI8PxYMaL93lwtauMOvF7QMu5+RixtxNGj9Sk+ruJht0LIb8GnQsrfRn/PZe0pmOyJZD7LzY/pMdrJL98uIn3fpJMFr+zWO4zgNfe3rK6u92fYg7vfUP4lyyecnqZpJUNeK9i8rJ/oeWtZQc9uA2+W0l1m//jtfaYHxif0cDlpBO7m+l3N9wXqd47C97Pyq+adi/Igbc0m9qLqgtZayPnMCbfibhiF9dXdtM3mQO//Jay/RMYrqMxlXrLpKXr0xnST+RcPyrK5qPud6Tt42Fzi+PCNZSnzXHda1Iv3rlBOroqenw3Y5x7eKT3TCuo6Mz9LPdpTkumi1+lu+nVzfi/mf1evZg9qLz3eui/D4EUIIIYQQQgghhBBCCCHEXQHvhesJgRBCCCGEEEIIIYQQQgghhBBCCBHiznpaHy6oY9SU9rpZjk7S0jWHuuR6+O1CGVniKXCLfPM+ee70upMf2TtChGFpVxpwqp4WyFr9yHfdqlLGheK13+EnjoefUt+uqAM+GY6qM+eaMLmdS6lLO/epvSNEgOwy6G+lp8X+WK8/9MktNNglW1LIlOpRrb6YT8f1pro+MZ0nc3xbN4uky1p9WdyeQ50kWx44FGwvM9Mm9klNivin0hPpT2AuO+gC3z+UHene49miH7ibIEQUcjEXyTH58d/oafE5Iqo/lCzSTGLQ1RyrRxXX02LHSTl7dLPwXEZ0m5hOUmmtaydtF8NJxBzxT0X5fTIEWLvYcd8/lD1B62gGeiH+R45meacSFV7QytOV79jwYHNEXMqB6QbhWsB3uDDXZ9by4jgrZ5cECZ7MyN2B195yPOxpL4Y7toUOVmIwGBqhoOX4hxINWkWK95pfKGYJ8b2ghbcHd1+KbDbfE7TyWdoLWpV3x+xZ3abOU7OgRXWbfGGsYjy00g/bdGxWTlj/6VMHf82kOmh5/qFEglZfIRxcopglRNcdD1q/0tPi+kBR/aFENyibGrCIYkxPK6jztEc3C+gS2WiX3tQznaTlgKvDtN1exlpyOme30sFKI1Ye82Lbg9w/FBy0wHh2+5SPf62zhLixntYM1gcq7bHW5/pD3TBZ3aDkzS62ORXS0wrrPMV0s7KfQDesuk1cJ6lWh2m3fpgx6BQdrLwB6zNC2C583NORitVr/5huODAvw/PN7xSzhBBdF3/FWQghhPgNZjXS8hteIYQQQgghhBBCCCGEEEIIIYQQQgghhBBCCCGEEIe4u57WPvujeRbqz2dZw8+uN8Q+vagu++J5I6/itfD7pRUn9dc+mL4Xy12Pvk33WK/iz/lFhTbTtBBtOVGh52Q9rW4u7bj9DbMNnOjPRuwx0Mn0eJOJ6fr90oqe6HsxHS+bqaoiG1dyzSbJ2f5sUpdpUgYPcRLZxdzfRU8raH/H7rh5Wh16h050qqA9Tjl5zUbyozzf9f9iUJIeiQH1ouyck902szRFNH2RbVghKjaV+mTYyLU5pfPweOPHu2Y3N4s5q+5XtH+ZfyAg2X3lktFN4Guvwezfm4UnBS8/7odpfH3+Y/8tRHPIJLvGKpsw90J6WnH72fmdu9IC5xOdKqd8Zom5I9jWf3L8b+8sNicdphflZWGPrLQ8HSykT+baaZVK1pyHcLzRcbhaeiho2RLKpLf1/RvVCduJF7SybMLJXVis4GUAvFv7Gqehf1/oClriLL4mTVKmV/8cPPYsoN5+dn4XDVpu1K0PWqY08JfadqVho2ZqZnpRbYIWWBpsZM2P2cnGmzMOV0sPrrS853e1/ev7B/667UrL3vvMZ5qV1liRIJgHrfmZaSchFXEeXwtaeHvwcPrqrwctqlPllE+Pk4gFz68JWjVRgelFNVppuTpYsaCF7Pxl0EpKr1rJgf7dpRO2A+RquBTP9DgrtgfTPfds9Mz7EApa4iyOBq3f6WlF7WfnJ01IHlGj8+00Xd60hoJWMqNt6z/V+J/GQAPTi1prLOe2yPag9x5dcKUFdc7YeKPjcLW0qDoy3Hz9sPr+/dJ7huhFDLj7514vyEFmOcau6k5BS5zB3fW0Qvb7elHonV96vmnCqlMV1W0Cf3D1nyr9P00b6wlPL2otx9G7Wj3kCEMhHazwFwpE54xvz+LjXr+HPgAg4l7R/nWKagOul1yPxS+qnjGvZeVX9bzqPadpQoin0XgT7Kd8oSk1C1MhhBCNeZ4q2DdaZLZGhRBCCCGEEEIIIYQQQgghhBBCCCGEEEIIIYQQl+PuelqdbcI0HEwHVbKYev6nPGvGtppTQ/bcRT8syq/0qyr1w6RbJsRZnPg56sl6WjbjUp+kBG9JyD8H4ua3UtJ1XXcf/bDLpQJi6awQ0i0T4hSyQdbfRU/LXVjl9rytn6ZP4Z+71vG1pdtU+mf1xXw6OJg5Ap6fHh9f20EL3sk6/YLvfLmd9E75ZP0wXP4OO9E49MctA45nJy0TKUS6ZUKcAJl0iiSq/Phv9LR46lVsz2L9vEBboh7TbWL+cfSQYCAl59v9rcD2YH1/sfOZnfT8s/XDePkhO9k49P1T4ulyxVZaJgakiYlbZNN/rG6ZEBsczfLuSEKcqqflyAUx6Yr5Gs7MYPpSy3/9lYoNsWCSZedXzlaofS2y2keClnuXEchqv5aW/oWXH7CTj0PfP6BcNp67QDd10i0T4iS+FrTw9uDGPt+G3fh4OGh5s1/hH28fDzWFnH+boHW2fphX/s2DFjaw0Urr/9AtE6LkaND6nZ5W+sv1tQxsj7vScrb4Sv84761BXS5yfu6dI9uD8aAF7MTn2+nSbrS55ePjScQq+gWVH7CTj8NY0PJ1uaLbg9ItE6Ihd9fT6lJdIvziQ6lGNb+M3M97+US3ydNhonpIQJeLn5+8xTxuPdaK6mzdRT+MlR+2E45Db9wyyHalI0hFeku6ZUKIE9Ctofif0fgX4k48T4lKiHo0/oUQQgghhBBCCCGEEEIIIYQQQgghhBBCCCHEdbm1ntbyaTCjUm9psxxRQUwPDI64sr+WodLkM6Lr61G9OagT1ur6+i6B8SPEmWlXTtbT2pm08LRyugvqPwU5XQ8skgbJ/OLw+IzX24SfjIdW19d3+aqenLg32aTQ30VP613OsNQMsswUk91yt52kz2HlJHet6RVlPsmcJiN9El24luXYlZ/VW2K6Rzv0kLDekmM/84M5XqMHtpnGKZLDEPdLqN6Af3qqx5ZVwHIg/VWMB8cPYLy55eDri+iiMf0tqsvF9dWskvi739h4zlyUjB9Xv00InID1BnpaabpR2IoioWoSgdN2gXKYXpE9J0t0G7qzZuXwxMTGMyYBa1QPaa4P6C2drgfGVzz1iXc9HalIvTH/LKO/0GPbpwfmWkpHck1iZXp9ObpoTH8LHiflFErifpZ9Pn5c/TYhDmd5d6QKTtXTimY3T6etLBjjdv1lwJyt2YozdInhcpygZUu3WerBcadf8v+49jM/7JNWOR60vH6J1Bv1z1JCOYz5XViToBV9HkevL+dukWWFh8dZwlzes2A8O+PHvasV4ntBC28PHnikdCRobbercpM9vUPf/wwjVdolQStv0By00PFWQYv54VdBa9/DjxOD1k49MNdSfhNX8YyKXF+uLlogaLFyWgWtDf02IQ4Hrd/pacWCVmqn3Rpi5bD3uJKC08Ds6D/Vl7Nanm5jct2jmB5S1kxs0kl6YC22B/e8X4e3ByP+YUGrWCKkQSswHkw9dNwWz4BxCeD6cu0MBC1eDtO3I+OZjB/fzsj8IB7IrfW0uD1VekvTtC77aLuIDhYV00p8ut0EWs5qZ6a3hHWPgnpI7pcOJ+qBMV2osC7XRhfU1hvxjx0lhR6bHVYVemAM2t5QY53ri9jJxgMdJ057t/TtkvHMxo/nTwUt8d+ysQlzSZjJN2yKEEKICu6rHsQsv2+LhBBCCCGEEEIIIYQQQgghhBBCCCGEEEIIIYQQYg931tkyedztd8YVTYjmWTioe1RT/kk9AFk+lT3Ia9zddzmfBPZX/ARtv/5TKz/XIZ0q8T9x4ue3p+psFYlnjrTjZ5nPKlP57QW2q1Wet4YD58LfTVelQDzVz3Uc0qk629JW5StDoei6Imj1d9HZmktZsgvalJ5wHbcs8vxs4mUamxr/pBWnaWwIDfSffP/wdkV1xSDDNA0vk7knSUcH/J/8ZdZhWovqbf1ZhqcszRX1Q+k3u+KxOk9ePyZ2bAWDuJ+p/cz/zJ/czoAuF7cf+tMH1OuUH9L9cu0U/xcwke4NdLY+a5TXOE3j5x9VOj1wZencwdX7h+l4VbQiMyasj8VgK4CQrhgv3Mw2vfF0UIepS4LWCH5b+hP5gfnNSQyN+nGPfljIz9x+4n/sT2qnrasywTHRV+PjEOHUi6+vuO6XVlqi645nf3ekH87V2XqN0/CubJimoTdBy42KTYIW9gPR8fIog5bjz/w/22xvW1XpirHCse4XTVDLZ73PDzK5ZMefMCs58VtsPO+SYgn42bGf+R/607Mz/JwU66s54xAT1J9zrtOApI74//ha0MLbgwe2/odpHMdP+u1pHBd9WV+n5ztBqza6XCdoxR+KEN2vsA5T945/45jv0Tn+fF7Qov4h/qy0s+6ZcaOgRevF+m1x3S8FLdF1x4PW73S2hmmapnXDEQSPbL+JtDdpQqGHVO8fpuPlgbcHiT+7HUELtIvZH31PMtH3WrYHuf+ZDtNqZ+p8z5/ID8xvaw+m24w0eMf1w0J+ZvZj/1N/UjujulzMfm8c+oUU9YLy/es0ogMn/iNurbPVpeN2SMUel7IdPSEg35McxOdX+mHR8XJooP9U5SPcLcD+iKTT+ymK0fdKn8cA/+flpwenoV+Ndf3J/cC2m9bj6wsdnh+C+mFBP3v9CP1P/UnsDOlyMfs9fxK8elH5ldcpeNZV3y4hRCW1z7REHfKnEEK0R6pXbZE/hRBCCCGEEEIIIYQQQgghhBBCCCGEEEIIIYR4PnfWzSrLqrA+en76+ak9bvOC35lDekuLc+7vh/vRULfMwR//+WXEry/27S87vpaEzifNfo3V57N2iXtw4ueZp+pm5QW1P9+mwLFe+mQmCmZOglxAT+iQ3lKnz3t/x9mOZ+PfXrMbCT398+uOJwlh+HU3TH/jkBjAzqftEnch67b+LrpZeUEnnJ/+NB/ckaD1Gz0h+6csUfp6cha0wmtIkrMR3nHHdMWw35x2mfPH17wUIbpZrBx/nGPdL24PdBcsH9v5PjpNo2lTkgMQ6pYRe6heVwXZTVtykdt+QUWy89nx5MIqy3TSM0ID3OtUQeuWwMSvN9DNygs6ZXvQpocr/1I53K2vvqknRHSYfF2oBkGLjYeorhjzG9OXMvXmOlKbiYxtOWycM92vqN6Yc30BO5ez5+qX05humWdPUHcNj/9Uk4xIpaQ3r/B8cjwPWpk/i+tubXogaPHrWlyf+mzl9KLK95FhXuwkaOVpqI/f69Rlrd59Psi0HVhp/UJPqMxAPOcdTUooJ4Ug+fhh4yGtqO4OF/mNtStryGtL7JGV42R5h47i5TDC19ccY7LLB+uW+fbs3dPOxn+SahjfeOW7LPB8eDwatLJn86HrNKpgIC7B14IW3h48tGmXV/vV8/dd/9/TEyINvEbQCntv9RsPHkQrMhaEwueHHwq2C1rQ8a49+x/ERpu//3gybdRtD9KT/fM9e8SFORq0fqmblcqObD0b23E+eo/ENrTq+v+VnhC5i3R1oez2UR1oexCPh6iuGPMbuzvO3hUAD9vTbUlWDhvnL6L7Fb1bd64vYKe70gK6Zb49wQex3vifj5s9auf6AufT4/0wGp/n5x8OWjXtEhcFvvK+LNjnbfTPipsd7+xvsk0WtElR7l6kQyryTMvL9o3LCZ6fvBFB/bYtgle6oSwL7Zkc1hPCVXNdKPDWMCW3h+3g4YaFdcUq2mXrHccxjf2frkpfACnL8cY50f3yTc2ou45mOxddsvHVzW+WlMMjtZHZs+MLFzz++W43ub7Y+TXlpLe3CeQt/PSBLTyftEsIcTe+t8N//ltb2vYRQghxjO/oYNkX08+rRQghhBBCCCGEEEIIIYQQQgghhBBCCCHEY1ACTSGEuCjLV4p8mi4TqgYok6AVWTTLRL2+PfXsszyawfAQofa+xo0Tm3xjtX64mrqh1fHZUn4+/Oj7Sm+u8y9iW1cSaXWaTMP7CPcrnNVrLJ0zHj+HU5SJi7K1tjj0kWaub1Nxlbda6yRJbur4yTKrvtIvfI8LdYyaHe+6Duke4ZRL5vzzpt1w2svvzYOR644k+Vz+09q2Opta19vH9bG+ehMqziO7CQKTZm+zqEC9pfo0S5/UODBFNMv85thTP38Vafs2MSO85zpG/SJL1Nn/rZV+7JzsZFHqPHntpS3C+knQn72rC0Xan2bXXrM+tTneLctBfvuCg1bdvY7TXqDvRdKMOThphMrye6Lj5dnpXXceZbr3aejLsMH0tBydLfuZdpY6MmC/d/3G5pP3L5zrBaRv1mLrAWTjppgmavSWwrkB4Yq+MmhF9YrKZtQAhjvRMcoum+WwLSHVf8I6T7heDtNPYuXYdLs1tTBJiFbHV5NB0KL6RvX9yNrL9L26RistVr6TGBfZ6V93Dvlygu+1pgmRrZ4WOm6TydoUvqS91H73+m0VtNj4kfbII9iYNJtKV8CVFq6XHQeb9Ges+IuNBJ5du7OTXeIuov9EdJ7M38uUwaC9WD+JlkMnTe6Cc4PWhu7RfL+sPrcAAAk1SURBVM7uOQa3twiQ1rwGQYuX7wQtcHz3dUdvX9BajQ0DcJxLwMD2MvubX79BfSySbl7ciunrQQtSvdL6RuZTvCfJg9biJdrAJThlDiz8ufuZ1glBC+sYtTpOTc+s2NvdClrmp0FpkvOCVvPrN6iPpaD1BCru9NNtg8PPtCD124NNV/hMgqSw0w9a76bl+4Tpoms+m+k8mXqqtweRfhIrxw1ayA9Mx6jVcWxZM30j1l6q90Z0yDbqANuDuPy1R+zmGrXTv+4cwPYg3L5Oq8vLKI8z/TDSXmq/e/022B50x4+2Bx+BGWRk2c71lkKDLHn8akc5rpfbE9Er2gLY7736MeY6Rul1yZ72p1XYHZJV58lrL7Eb6ifhcmwLzIZ/tpOZ1wh1jBoet+bibdUDyyza3nSHKp/TKpyfNyr7BSvfPlwaklGE7fSuuw3DiC3WIqan5elsYf0w1l5uP79+A/PJHn0svYjxDKQzlLL3Xmyncrl0nkRr9GY3QY55COB+RETY/XmpdJ7ESSiRC0DLLCGEEEIIIYQQQgghhBBCCCGEEEIIIYQQX6H+U3EhxE7mLwXhh5jm/ewic9zn9+x49seq8z9/iySQTal4A738LGtpcny6uZza0xkc8E+Ycs5nHxg07ceSfT371e+CQu2dP5H3Tjjut3X2KBJ5Njk+W3pjPbYmWN0AC/bD8179h+l/krTMSKvGDnF2PM8SvVUOs8dhh14XY+89ctXHwocsuwbfWEOUc378emtlp/TYwrz+Oz22n9BLV4wHrXw6zoNZkse8OF5MN4vjWDnMHgecRT7J6rIe9+9MvWRO5Z3Leu+/FbSKpStJkxPNjDW+1iOfLEF545D9fVxna/lh6Tdiv0nVNGzd4aelwVJgExr045Yx0mP7f/TYPMj4CemT+f6MzgNdt5GRJ/fDwxZbMGjBK9yemaU7K4+Da2n2MiuH2eOA9bpeL5u0sLJ8NNzTC3tLN8i1E4xFR+eJFILPT3IimkS6TMeoD+psLb8qpwNmz1p6YLPOTVtcYQ+3E/th05rQwgRME9Jja3q8H87VY2N442fep3v/O0/DmB5n/ozOA8uZqF3/h65YaKVlbjjACsYe94MWLIf+kINXWk6C1PrJDjzcG19dMVbqbmFA0CouvI1chvx8rLPF7M9Kqs6gCPwD7UkdEujNYhpdfl9lj2Mn8UNTpMd2etA6W48N44+fSNZ87M/oPFB33sN1xXjQ4memCc7x8ZrtQaQHsSNopST9Vd6TVd+hk32/KwYtGE3ovuU3g1YgrfBJQesrGYrxnqT02Joep6ZnVjTubrfAqwat0uz/K2jB7Qs7w7DjNS9ilDPV0aBlr2q7IN8qvzxO7tr26B5B3SZH52mjkPT87FGz2YWiT30aBC3PnvV4svWxwVnbg03vvqGUhms5DFrSY9txHFu2S48tIuPljZ/jQSs+D7Aq/iNdsWywgtXwvC22LMvfZ36uAXa86+yPwCvvZM4N7tGDrQLThI8AVdqAbJnv6VphHaAdukdQt8ndxgSQ84fJ6mz9pfNgbv9Sxvy4pXAfNz2vmdlvO2CKPaFMp3VYbbt+3AOY7fAya6lqftm8T549gnmFGmn9LD22Fnpsmx8AZKCuyf2GZof1uOfP4DzAXlDy/FC3IXQbQiubL3A1e67PlR0W681bvpm79x5Wemy/I7IB8ARueWE5zGH+Cp0Y+7hYdMlL0heay3ZbdeUA3Ar2uXTgh1fq6/sBn54+mIcts4QQQgghhBBCCCGEEEIIIYQQQgghhBBCCPEfkr3yDj4uvqqeVla+l9ulygNOvc9U5amkwj8NYC+CQ/GaL9gjhLgoG2mczDv+9vgV9LTy8o+lOtiq95SPOm+ks3XuR9/xT0n0EboQ/yk8aF1bT8tdWJX6NDaqzboBW8Gyt9lkNoJWH9XLKZa0NeHrkXpav9XNEkLcDBi04JVvz/y9nhbPgsP0afxEsSA7eFA3y6bnzdoI7emCK60n62m1SIy7TzdLCHEzQistcyOLc+zCPcMPbfW0WNDiqf5jQSsuQbJDeiAQtHg5T9DTOh60eHuFEI9i45kWPH4FPS02zf2PQQtGk1vpaTVYaSmTrBD/B5tB67J6WulLHGttTJ9mLRltW6HtwZhuFgsGjl4O1NliPFlPq8X24LMkg4QQhOziB7ssV9XT6lKdG6jnRI7bFwS4LlFEN2spO6aXA3W2NutIf3B3Pa1L6mYJIa7K1V4dvpo91+fKDlNvCiEaM98WX2FukZ5WmIfpaQkhhBBCCCGEEEIIIYQQQgghhBBCCCGEEEIIIURC9so7+Lj46Xpaa0kt3s+O5mW4Th4HP6u6EEJcgo00Tia/jj3+PD2tLDHHfPA3WRWi9Ta0U58DCyEuTSjLexLMLqunZRZzSZJDV0fK6HWYH0SSAsGVilMvXtlE63XPtyvRSCLi/LwmullCCNEAGLTgXl+mEXVZPa3u9bLJ6Kydjo4U3KbbsYIh/qT1kiDRYKVVrER3Bq2WullCCHGQ0EqrXMGw437QguXQH0KcoEUSue7Ibt4qaEXEJ/fUi87fKdVxrm6WEEIc5Gl6WumSyU65Clo1nKubJYQQB3manpadTPvkQdWuoBXQu2L27wpasXrh+UxvLGp/S90sIYQ4yPP0tKyc01toanzt0JHKGrA54WOdJ16vpwsV09ni52O9sYj9XddMN0sIIRpwtacRV7NH1KBeE0J8Celpid1IN0sIIYQQQgghhBBCCCGEEEIIIYQQQgghhBBCCHEut9XTSnK5p0e/8c78dXSwhBDiP+K+elrL2VlqpIbfuf5KT0sIIQTmrnpa9tdp1BqmaXgZeZUknoFsRO+D09DPq8zx1Xk6VVHdLOlOCSFEM+6qp/X5+fvXSXwdJhMXTEZepgv1+a/ZCF1MclZa9bpZ0p0SQohm3FVPqzNrt+SfeSD8rMaYxAb4z0o0aIFs7tKdEkKIhtxVT6tMSz6XhAWhrhG0pDslhBCHuK2eVr4QXOxMtE6S7UGsCzX/DwYtqmtVr5sl3SkhhGjGLfW0+uw9i7XQafpbZLTyDUisC8UWbNkfl8NR3SzpTgkhRDuu9pTlava05dmtE0KI05Ge1heQ7pQQQgghhBBCCCGEEEIIIYQQQgghhBBCCCGEEELU8A8JyePxNB/HkQAAAABJRU5ErkJggg==)
Then i moved on to check the Indexing of MySQL Binary files. That information is stored in the file "/var/lib/mysql/mysql-bin.index". Then i removed the corrupted index from the file and move the binary file .
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWkAAAAiCAIAAAAS8b8CAAADQUlEQVR4nO2cwYGsIAxAqYdWqIRCKIQ6bO4fFAwIAo7u8Mf3TrOsZkKSDYHVKAUAAAAAAAAAAAAAAAAAANCJtn5ZlmVZvNXNi41rXGhcl5xOlRZnnhgPmtav9/bDKXwOfilc/4FfOuy5WfHyV7wUbX1nbHVfeBXjov+ME1F017hSSinrF2etF6PG7XHTb42nwS/3+qUlwbgv5441xXnv1tRqXMyx28c1+YkfRuWELLrZIf603hfT9OK9F8JFus9T7FiMGrEQhJuKeX0ddC7MtLTQZBgnBOg9jO4aV3ERTgclDWvglzn9EtjtfJhXQcJe1SzOfD13BIVCtnBGWCnR/ph4u+WkTlBxWMqXOdv6GD2F2mwkRkUcauvTCRzlxBl0fkseW/sadc/4rnIhRkM6bwYQfpnTL4k9kxpHfKGcqdzMTbJniUYJ2SHJvMFnbZedyVGVZB7rGZF3hZO2S9o2zYg6J1GZOboYo7Je/XqMZhMr6tM+HcAv0/olzTvZzHI7lH59Jv8vOI2t7XOz6GjJiTOvFnkxFjOjHGx0eV/9QIwKqxQz7mfjVdUzLc5jCL9M65ffzh2ryl1R0ZCjrF/3aLJITpe6cHW2VfqoNo739tXG9Rg17rgp1daJIlLG2T3jZc2SdTtsROrglyn8UtAznWiea0p1XHKM++09Szx9cSbsofR2OiVKj66ioyXnaE5xUJSaVcsjJBdsWq2Bi6xaOLcf+iV7xYMcOQOxac3K+Pwb5eHVE+NS3fKeorm44ZcHxtWwX8o5TlpalDsVeyZbSTfHkcff0FFt1m67XxmI4BeYltLJ2+CNhOkD4BcAAAAAAAAAAAAAAACAGbmln8ItxEdp5ukTcVXOJO8yAbyJy+9NTAbPVsF/zkmfjoF1Xr+xT8SwHC0fcRa5Qz6bfBgUz2LPnArhlejsJafDQ/ddMfu+PhGDcqr9F6QAbX2aPrzVqUSAmTjr0zGQO17WJ2JMTu0d6vSFqEqpQsUBs3LSp+OW3PGTfSLG5FT7L5wefITESNEB01Lt03FP7vjJPhFjcqr9F2r/qRE7lfVyag+YksMf10hfhjf2iRiXU++/cDRFSx+A90CfCAAYgj4RAAAAr+MfyQ9GOOyPpisAAAAASUVORK5CYII=)
Now its time to test, if the DB recovers and yes it does. The Index has been recreated itself. Then i did a SMT service restart which Worked as expected.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAK0AAAAiCAIAAACiK84ZAAACCklEQVR4nO2a3ZWtIAyFrYdWqIRCKCR1pLl54McECYLDvWfG2d+bgDHGHWBJjgMAAAD4bbhAzMzMFNynfQGfxgX6vg4CRb/DmV12fjQp/Si4kojnO/vIXHIzEAUfiJmJYhqWu6M/ahbnb1ev5COYmYmoNMr2bEt0LemgY9+dbeUR17dSU04/DgM7LySFJkXQx/SqPp4v7QLloLlAqbl0u5osPuqw5mb5RX1U4ijtrQiOFR1Y9g8rj7335wD9XXtxMO28EP0Ja1NnpAtUwlQTphMvZVAkoFSWtO/jYx307Tf+NKat/O7EwbbzQjbpoNoxA1e/d6OD5vLx/kDrqeeGj2I1cM0I6OD6/ipgchkY6CCFrF0gtJkyWrY38/mxogPLvuqqi5wUXF3jhnHo23kdclJt50k5gWYR1Iu8puddld6FNZOzYV7OzzGW6af15zbupn1l7GwXj6UYq/OjOHTtgCFGSs3ctt8Z8P8xd2vzN0IKAAAAAAAAAADA3+VT/+dRf7DAQv2BU7cwl/N+d1uXsPCLyfRHmtJ/nFB/sIn5+gPrvH9Ql/Agn3r+SCG6QFUKqD/Yx/y5c+q6psdkXcJjfy55KTIT9Qe7WNOBGtXWE/wjHaz6Yz4X9QcD5usPrPP+Gx0snt/f+3OC+oMtrNQfXBrbzZRVl7Bwfj/rT+1B/QEAAAAAAAAAALCTLwUtuSzS9Sq2AAAAAElFTkSuQmCC)
Please do comment if any questions on this , I'll be happy to solve them if i can.
At first what i did is to run "mysqld_safe" to recover the database. That did not end up in a sweet note. But definitely gave me hints that where should i look.
Then i head towards "/var/log/mysql/mysqld.log" for clues and definite got some of them. The error was saying that my last binary file was corrupted.
Then i moved on to check the Indexing of MySQL Binary files. That information is stored in the file "/var/lib/mysql/mysql-bin.index". Then i removed the corrupted index from the file and move the binary file .
Now its time to test, if the DB recovers and yes it does. The Index has been recreated itself. Then i did a SMT service restart which Worked as expected.
Please do comment if any questions on this , I'll be happy to solve them if i can.
No comments