مشکل اجرا mysql - mariadb

[tikweb.ir]

بصورت ناگهانی دیگه 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 هم وجود نداره

مشکل از چی هست و چطور میشه رفعش کرد

[sazsaz]

محتویات دستور زیر را لطفا قرار دهید
etc/my.cnf

[tikweb.ir]

محتویات دستور زیر را لطفا قرار دهید
etc/my.cnf

mariadb هستش و محتویات فایل ارو از my.cnf.d میگیره که ربطی به اینا نداره

این مشکل دقیقا بعد از پر شدن پارتیشن روت پیش اومد ؛ mysql داون شد و دیگه ران نشده

[tikweb.ir]

up
مشکل فوریه

[ali.arabi]

سلام

زمانی که سرویس را ریستارت میکنید چه اروری دریافت میکنید ؟

[tikweb.ir]

سلام

زمانی که سرویس را ریستارت میکنید چه اروری دریافت میکنید ؟

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]

[ali.arabi]

لاگ فایلی که ایجاد شده است را بررسی کنید ، ببینید که چه اروری داخلش اومده .

[tikweb.ir]

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

[ali.arabi]

سلام

به فایل my.cnf این دستور را اد کنید .

innodb_buffer_pool_size = 20M 

یک بار هم سرور رو ریستارت کنید که رم آن آزاد شود ، ممکن است مشکل برطرف گردد .

[tikweb.ir]

سلام

به فایل my.cnf این دستور را اد کنید .

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

داخلش گذاشتم حل نشده