نمایش نسخه قابل چاپ
سلام
این ارور را میده و استارت نمیخوره
service mysqld restart
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL............................................. ........
همین طور نقطه میذاره و هیچ اتفاقی نمی افته
چیکارش کنم؟
ممنون
این دستورات رو تست کنید ببینید به نتیجه میرسید یا نه :
کد:kill -15 1666
kill -15 1599
rm /var/lib/mysql/tent.pid
rm /var/lib/mysql/tent.pegproductions.com.pid
service mysqld start
سرور رو یه بار ریست کنید ببینید درست نمیشه
خیر حل نشد
اون دستورات رو هم زدید بازم حل نشد ؟
این فایل ببینید وجود داره ؟
/var/run/mysqld
error log هاتون رو هم بررسی کنید
نه قربان این فایل وجود نداره
/var/run/mysqld
چطوری باید لوگ بررسی کنم؟
ای دوتا دستور رو بزنید
بعد ببینید استارت میشه یا نه
خروجی این دستور رو هم قرار بدید
mkdir /var/run/mysqld
chown mysql.mysql /var/run/mysqld
tail -n 50 /var/lib/mysql/my.server.com.err
نه بازم استارت نشد
اینم میزنم این ارور میاد
tail -n 50 /var/lib/mysql/my.server.com.err
tail: cannot open `/var/lib/mysql/my.server.com.err' for reading: No such file or directory
دیروز دایرکت ادمین نصب کردم، سایت را آوردم بالا کار هم کرد
امروز دیدم سایت بالا نمیاد
خواستم برم توی ادمین دیدم توی ادمین هم نمیره و دیدم دیتابیس استارت نمیخوره!
به جای my.server.com اسم هاست نیم خودتون رو بزنید
نتیجش این شد
[root@server ~]# tail -n 50 /var/lib/mysql/server.datisserver.ir.err
130217 11:21:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
130217 11:21:02 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
130217 11:21:02 [Note] Plugin 'FEDERATED' is disabled.
130217 11:21:02 InnoDB: Initializing buffer pool, size = 8.0M
130217 11:21:02 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
130217 11:21:02 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
[root@server ~]# tail -n 50 /var/lib/mysql/my.server.com.err
tail: cannot open `/var/lib/mysql/my.server.com.err' for reading: No such file or directory
[root@server ~]# tail -n 50 /var/lib/mysql/server.datisserver.ir.err
130217 11:21:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130217 11:21:02 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
130217 11:21:02 [Note] Plugin 'FEDERATED' is disabled.
130217 11:21:02 InnoDB: Initializing buffer pool, size = 8.0M
130217 11:21:02 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
130217 11:21:02 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
میتونم سرور را ریلود کنم ولی مشکل اینجاس که صورت مسئله پاک کردنه، بعید نیست باز این مشکل برای من یا هر کس دیگه ای پیش بیاد اگه به جواب برسه خیلی بهتره چون سرچ کردم خیلی ها همین مشکل را داشتند و تاپیک آخرشم به نتیجه نرسیده بود!