مشکل اجرا mysql - mariadb
بصورت ناگهانی دیگه mysql سرور که از نوع mariadb هست دیگه ران نمیشه و ارور زیر رو میده
کد:
Giving mysqld a few seconds to start up...
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
MySQL server PID file could not be found![FAILED]
Starting MySQL.161014 12:06:50 mysqld_safe Logging to '/var/lib/mysql/s1.hsotname.net.err'.
..[FAILED]
Failed to restart server.[FAILED]
هرکاری کردیم درست نشده
پارتیشن root هم نزدیک به دو گیگ خالی داره (اما وقتی این مشکل پیش اومد صددرصد اشغال شده بود که خالی کردیم)
پارتیشن های دیگه هم خالی دارن
کنتر پنل دایرکت ادمین هست
مشکل با حذف فایل my.cnf و بیلد مجدد و ریبوت هم حل نشده
فایل /var/lib/mysql/mysql.sock هم وجود نداره
مشکل از چی هست و چطور میشه رفعش کرد
پاسخ : مشکل اجرا mysql - mariadb
محتویات دستور زیر را لطفا قرار دهید
etc/my.cnf
پاسخ : مشکل اجرا mysql - mariadb
نقل قول:
نوشته اصلی توسط
sazsaz
محتویات دستور زیر را لطفا قرار دهید
etc/my.cnf
mariadb هستش و محتویات فایل ارو از my.cnf.d میگیره که ربطی به اینا نداره
این مشکل دقیقا بعد از پر شدن پارتیشن روت پیش اومد ؛ mysql داون شد و دیگه ران نشده
پاسخ : مشکل اجرا mysql - mariadb
پاسخ : مشکل اجرا mysql - mariadb
سلام
زمانی که سرویس را ریستارت میکنید چه اروری دریافت میکنید ؟
پاسخ : مشکل اجرا mysql - mariadb
نقل قول:
نوشته اصلی توسط
ali.arabi
سلام
زمانی که سرویس را ریستارت میکنید چه اروری دریافت میکنید ؟
Restarting MySQL.
MySQL server PID file could not be found![FAILED]
Starting MySQL.161014 12:06:50 mysqld_safe Logging to '/var/lib/mysql/s1.hsotname.net.err'.
..[FAILED]
Failed to restart server.[FAILED]
پاسخ : مشکل اجرا mysql - mariadb
لاگ فایلی که ایجاد شده است را بررسی کنید ، ببینید که چه اروری داخلش اومده .
پاسخ : مشکل اجرا mysql - mariadb
کد:
2016-10-15 15:52:01 140671150114848 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-10-15 15:52:01 140671150114848 [Note] InnoDB: Completed initialization of buffer pool
2016-10-15 15:52:01 140671150114848 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-15 15:52:01 140671150114848 [Note] InnoDB: 128 rollback segment(s) are active.
2016-10-15 15:52:01 140671150114848 [Note] InnoDB: Waiting for purge to start
2016-10-15 15:52:01 140671150114848 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-78.1 started; log sequence number 27991607519
2016-10-15 15:52:01 140670379489024 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-10-15 15:52:01 140671150114848 [Note] Plugin 'FEEDBACK' is disabled.
2016-10-15 15:52:01 140671150114848 [Note] Recovering after a crash using tc.log
2016-10-15 15:52:01 140671150114848 [ERROR] Can't init tc log
2016-10-15 15:52:01 140671150114848 [ERROR] Aborting
161015 15:52:03 mysqld_safe mysqld from pid file /var/lib/mysql/ns1.hostname.net.pid ended
161015 15:52:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-10-15 15:52:09 139906285967392 [Note] /usr/sbin/mysqld (mysqld 10.1.18-MariaDB) starting as process 27327 ...
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Using Linux native AIO
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Using SSE crc32 instructions
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Completed initialization of buffer pool
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: 128 rollback segment(s) are active.
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Waiting for purge to start
2016-10-15 15:52:09 139906285967392 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-78.1 started; log sequence number 27991607529
2016-10-15 15:52:09 139905514600192 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-10-15 15:52:09 139906285967392 [Note] Plugin 'FEEDBACK' is disabled.
2016-10-15 15:52:09 139906285967392 [Note] Recovering after a crash using tc.log
2016-10-15 15:52:09 139906285967392 [ERROR] Can't init tc log
2016-10-15 15:52:09 139906285967392 [ERROR] Aborting
161015 15:52:11 mysqld_safe mysqld from pid file /var/lib/mysql/ns1.hostname.net.pid ended
161015 15:52:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-10-15 15:52:36 140297846446112 [Note] /usr/sbin/mysqld (mysqld 10.1.18-MariaDB) starting as process 27500 ...
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Using Linux native AIO
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Using SSE crc32 instructions
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Completed initialization of buffer pool
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: 128 rollback segment(s) are active.
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Waiting for purge to start
2016-10-15 15:52:37 140297846446112 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-78.1 started; log sequence number 27991607539
2016-10-15 15:52:37 140297086433024 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-10-15 15:52:37 140297846446112 [Note] Plugin 'FEEDBACK' is disabled.
2016-10-15 15:52:37 140297846446112 [Note] Recovering after a crash using tc.log
2016-10-15 15:52:37 140297846446112 [ERROR] Can't init tc log
2016-10-15 15:52:37 140297846446112 [ERROR] Aborting
161015 15:52:39 mysqld_safe mysqld from pid file /var/lib/mysql/ns1.hostname.net.pid ended
161015 15:53:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-10-15 15:53:01 140561413646368 [Note] /usr/sbin/mysqld (mysqld 10.1.18-MariaDB) starting as process 27769 ...
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Using Linux native AIO
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Using SSE crc32 instructions
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Completed initialization of buffer pool
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: 128 rollback segment(s) are active.
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Waiting for purge to start
2016-10-15 15:53:01 140561413646368 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-78.1 started; log sequence number 27991607549
پاسخ : مشکل اجرا mysql - mariadb
سلام
به فایل my.cnf این دستور را اد کنید .
کد PHP:
innodb_buffer_pool_size = 20M
یک بار هم سرور رو ریستارت کنید که رم آن آزاد شود ، ممکن است مشکل برطرف گردد .
پاسخ : مشکل اجرا mysql - mariadb
نقل قول:
نوشته اصلی توسط
ali.arabi
سلام
به فایل my.cnf این دستور را اد کنید .
کد PHP:
innodb_buffer_pool_size = 20M
یک بار هم سرور رو ریستارت کنید که رم آن آزاد شود ، ممکن است مشکل برطرف گردد .
mariadbهستش و بنده نمیدونم فایل کانفیگ رو دقیقا از کجا میخونه
داخل اون فایل کانفیگ به شکل زیر هست
کد:
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
innodb_buffer_pool_size = 20M
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
داخلش گذاشتم حل نشده
پاسخ : مشکل اجرا mysql - mariadb
کسی از همکاران و دوستان نمیتونن حتی با هزینه مشکل رو رفع کنن؟
پاسخ : مشکل اجرا mysql - mariadb
مشکل با کمک allbert عزیز کامل حل شد
واقعا تشکر از ایشون بابت حل مشکل
پاسخ : مشکل اجرا mysql - mariadb
