توجه ! این یک نسخه آرشیو شده میباشد و در این حالت شما عکسی را مشاهده نمیکنید برای مشاهده کامل متن و عکسها بر روی لینک مقابل کلیک کنید : مشکل اجرا mysql - mariadb
tikweb.ir
October 14th, 2016, 19:38
بصورت ناگهانی دیگه 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
October 14th, 2016, 19:47
محتویات دستور زیر را لطفا قرار دهید
etc/my.cnf
tikweb.ir
October 14th, 2016, 19:53
محتویات دستور زیر را لطفا قرار دهید
etc/my.cnf
mariadb هستش و محتویات فایل ارو از my.cnf.d میگیره که ربطی به اینا نداره
این مشکل دقیقا بعد از پر شدن پارتیشن روت پیش اومد ؛ mysql داون شد و دیگه ران نشده
tikweb.ir
October 15th, 2016, 00:25
up
مشکل فوریه
ali.arabi
October 15th, 2016, 00:28
سلام
زمانی که سرویس را ریستارت میکنید چه اروری دریافت میکنید ؟
tikweb.ir
October 15th, 2016, 09:32
سلام
زمانی که سرویس را ریستارت میکنید چه اروری دریافت میکنید ؟
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
October 15th, 2016, 12:10
لاگ فایلی که ایجاد شده است را بررسی کنید ، ببینید که چه اروری داخلش اومده .
tikweb.ir
October 15th, 2016, 19:20
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
October 15th, 2016, 19:36
سلام
به فایل my.cnf این دستور را اد کنید .
innodb_buffer_pool_size = 20M
یک بار هم سرور رو ریستارت کنید که رم آن آزاد شود ، ممکن است مشکل برطرف گردد .
tikweb.ir
October 15th, 2016, 19:41
سلام
به فایل 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
داخلش گذاشتم حل نشده
tikweb.ir
October 15th, 2016, 22:17
کسی از همکاران و دوستان نمیتونن حتی با هزینه مشکل رو رفع کنن؟
tikweb.ir
October 16th, 2016, 10:47
مشکل با کمک allbert (http://www.webhostingtalk.ir/member.php?u=20784) عزیز کامل حل شد
واقعا تشکر از ایشون بابت حل مشکل