{"id":11150,"date":"2024-10-21T11:34:06","date_gmt":"2024-10-21T08:34:06","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=11150"},"modified":"2024-12-06T15:15:53","modified_gmt":"2024-12-06T12:15:53","slug":"error-mysql-is-not-running-but-lock-exists-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/error-mysql-is-not-running-but-lock-exists-hatasi-cozumu\/","title":{"rendered":"ERROR! MySQL is not running, but lock exists Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"

MySQL sunucular\u0131nda g\u00fcncelleme sonras\u0131 d\u00fczg\u00fcn ba\u015flat\u0131lamamas\u0131 ve ani kapanmalar gibi sorunlar meydana gelebilir. Bu hatalardan biri de ERROR! MySQL is not running, but lock exists hata \u00e7\u0131kt\u0131s\u0131 ile kar\u015f\u0131m\u0131za \u00e7\u0131kar. ERROR! MySQL is not running, but lock exists hatas\u0131n\u0131n \u00e7\u00f6z\u00fcm\u00fc i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz.<\/p>\n

\"ERROR!
\nMySQL son s\u00fcr\u00fcm destekli hosting<\/a> hizmetlerimizi inceleyin.<\/p>\n

\u00d6rnek Hata \u00c7\u0131kt\u0131lar\u0131<\/h2>\n

ERROR 2002 (HY000): Can\u2019t connect to local MySQL server through socket \u2018\/var\/lib\/mysql\/mysql.sock\u2019 (2)<\/code>
\nERROR! MySQL is not running, but lock exists<\/code>
\nActive: failed (Result: exit-code)<\/code>
\nInnoDB: Unable to lock .\/ibdata1, error: 11<\/code>
\nERROR 1040 (HY000): Too many connections<\/code><\/p>\n

Hatan\u0131n \u00c7\u00f6z\u00fcm\u00fc<\/h2>\n

MySQL Durumunu Kontrol Edin<\/h3>\n

systemctl status mysql<\/code><\/p>\n

Socket veya Kilit Dosyalar\u0131n\u0131 Silin<\/h3>\n

rm -rf \/var\/lib\/mysql\/mysql.sock
\nrm -rf \/var\/lock\/subsys\/mysql<\/code><\/p>\n

\u00c7al\u0131\u015fan MySQL S\u00fcre\u00e7lerini Kontrol Edin ve Durdurun<\/h3>\n

ps aux | grep mysql
\nkillall -9 mysqld<\/code><\/p>\n

MySQL Servisini Yeniden Ba\u015flat\u0131n<\/h3>\n

systemctl start mysql
\n\/etc\/init.d\/mysql restart<\/code><\/p>\n

Yukar\u0131daki ad\u0131mlar\u0131 s\u0131ras\u0131yla uygulad\u0131\u011f\u0131n\u0131zda hatan\u0131z \u00e7\u00f6z\u00fcmlenecektir. Daha fazla hata \u00e7\u00f6z\u00fcm\u00fc i\u00e7in bizi takip etmeyi unutmay\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL sunucular\u0131nda g\u00fcncelleme sonras\u0131 d\u00fczg\u00fcn ba\u015flat\u0131lamamas\u0131 ve ani kapanmalar gibi sorunlar meydana gelebilir. Bu hatalardan biri de ERROR! MySQL is not running, but lock exists hata \u00e7\u0131kt\u0131s\u0131 ile kar\u015f\u0131m\u0131za \u00e7\u0131kar. ERROR! MySQL is not running,...<\/p>\n","protected":false},"author":2,"featured_media":11165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-11150","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=11150"}],"version-history":[{"count":14,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11150\/revisions"}],"predecessor-version":[{"id":11167,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11150\/revisions\/11167"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/11165"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=11150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=11150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=11150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}