{"id":1851,"date":"2022-10-16T16:13:39","date_gmt":"2022-10-16T16:13:39","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=1851"},"modified":"2024-01-18T02:02:30","modified_gmt":"2024-01-17T23:02:30","slug":"mysql-crashes-i-o-error-reading-the-header-from-the-binary-log-hatasinin-cozumu","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/mysql-crashes-i-o-error-reading-the-header-from-the-binary-log-hatasinin-cozumu\/","title":{"rendered":"Mysql crashes-I\/O error reading the header from the binary log Hatas\u0131n\u0131n \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>Merhabalar,<\/p>\n<p>MySQL replikasyon s\u0131ras\u0131nda e\u011fer a\u015fa\u011f\u0131daki hatay\u0131 al\u0131yorsak yapmam\u0131z gereken i\u015flem \u00e7ok basit.<br \/>\n<code><br \/>\n121010 13:57:47 [ERROR] I\/O error reading the header from the binary log, errno=175, io cache code=0<br \/>\n121010 13:57:47 [ERROR] I\/O error reading the header from the binary log<br \/>\n121010 13:57:47 [ERROR] Can\u2019t init tc log<br \/>\n121010 13:57:47 [ERROR] Aborting<br \/>\n<\/code><br \/>\nBu, ikili g\u00fcnl\u00fck dosyalar\u0131yla ilgili bir sorununuz oldu\u011fu, ikili g\u00fcnl\u00fcklerin bozuldu\u011fu veya en az\u0131ndan sonuncusunun bozuldu\u011fu anlam\u0131na gelir. Genellikle \/var\/logs\/mysql\/ dizininde bulunurlar ve baz\u0131 eski g\u00fcnl\u00fckleri yeni adla kopyalamaya ba\u015flamamal\u0131s\u0131n\u0131z, \u00e7\u00fcnk\u00fc bu onu do\u011fru yapmaz, bu nedenle \u00e7\u00f6z\u00fcm,<\/p>\n<p>g\u00fcnl\u00fcklerinizi okuyun ve hangi *.bin dosyas\u0131n\u0131n bozuk oldu\u011funu g\u00f6r\u00fcn<br \/>\nbozuk olan .bin dosyas\u0131n\u0131 silin<br \/>\n\/var\/log\/mysql\/mysql-bin.index dosyas\u0131n\u0131 a\u00e7\u0131n ve bin dosyas\u0131n\u0131n bulundu\u011fu sat\u0131r\u0131 silin.<br \/>\nmysql&#8217;i yeniden ba\u015flatal\u0131m.<\/p>\n<p>T\u00fcm \u0130\u015flemler bu kadar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar, MySQL replikasyon s\u0131ras\u0131nda e\u011fer a\u015fa\u011f\u0131daki hatay\u0131 al\u0131yorsak yapmam\u0131z gereken i\u015flem \u00e7ok basit. 121010 13:57:47 [ERROR] I\/O error reading the header from the binary log, errno=175, io cache code=0 121010 13:57:47 [ERROR] I\/O error reading the header from the binary log 121010 13:57:47 [ERROR] Can\u2019t init tc log 121010 13:57:47 [ERROR] Aborting Bu, ikili g\u00fcnl\u00fck &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1856,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1851","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=1851"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1851\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1856"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}