yashar313
July 20th, 2021, 15:06
سلام و درود
mysql استارت نمیشه! ارور سی پنل
Waiting for “mysql” to start ……………failed.
Cpanel::Exception::Services::StartError Service Status
undefined status from Cpanel::ServiceManager::Services::Mysql
Service Error
(XID y78mmm) The “mysql” service failed to start.
Startup Log
Jul 20 11:30:38 server.com systemd[1]: Failed to start MySQL Server.
Jul 20 11:30:38 server.com systemd[1]: Unit mysqld.service entered failed state.
Jul 20 11:30:38 server.com systemd[1]: mysqld.service failed.
Log Messages
Jul 20 11:30:38 server mysqld: Unable to determine if daemon is running: Success
mysql has failed. Contact your system administrator if the service does not automagically recover.
محتویان my.conf
[mysqld]
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
innodb_buffer_pool_size = 134217728
max_allowed_packet = 268435456
open_files_limit = 40000
لاگ های mysql
09:24:51 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68202 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7f2c14000900
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f2c0e7fbcb0 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xeedadb]
/usr/sbin/mysqld(handle_fatal_signal+0x486)[0x79cb16]
/lib64/libpthread.so.0(+0xf630)[0x7f2c3cb32630]
/usr/sbin/mysqld(_Z20rec_get_offsets_funcPKhPK12dict_index_t PmmPP16mem_block_info_t+0x24)[0xfe03d4]
/usr/sbin/mysqld(_Z32page_cur_search_with_match_bytesPK11buf _block_tPK12dict_index_tPK8dtuple_t15page_cur_mode _tPmS9_S9_S9_P10page_cur_t+0x485)[0xfb9b45]
/usr/sbin/mysqld(_Z27btr_cur_search_to_nth_levelP12dict_inde x_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP 5mtr_t+0x97d)[0x10e62bd]
/usr/sbin/mysqld(_Z21row_search_on_row_refP10btr_pcur_tmPK12 dict_table_tPK8dtuple_tP5mtr_t+0xbf)[0x1030b7f]
/usr/sbin/mysqld(_Z18row_purge_poss_secP12purge_node_tP12dic t_index_tPK8dtuple_t+0x2df)[0x102baff]
/usr/sbin/mysqld[0x102d082]
/usr/sbin/mysqld(_Z14row_purge_stepP9que_thr_t+0x895)[0x102e9d5]
/usr/sbin/mysqld(_Z15que_run_threadsP9que_thr_t+0x87c)[0xfda10c]
/usr/sbin/mysqld(_Z9trx_purgemmb+0x699)[0x1092349]
/usr/sbin/mysqld(srv_purge_coordinator_thread+0xded)[0x106786d]
/lib64/libpthread.so.0(+0x7ea5)[0x7f2c3cb2aea5]
/lib64/libc.so.6(clone+0x6d)[0x7f2c3af0d9fd]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 0
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2021-07-20T09:29:45.174735Z 0 [Note] libgovernor.so found
mysql استارت نمیشه! ارور سی پنل
Waiting for “mysql” to start ……………failed.
Cpanel::Exception::Services::StartError Service Status
undefined status from Cpanel::ServiceManager::Services::Mysql
Service Error
(XID y78mmm) The “mysql” service failed to start.
Startup Log
Jul 20 11:30:38 server.com systemd[1]: Failed to start MySQL Server.
Jul 20 11:30:38 server.com systemd[1]: Unit mysqld.service entered failed state.
Jul 20 11:30:38 server.com systemd[1]: mysqld.service failed.
Log Messages
Jul 20 11:30:38 server mysqld: Unable to determine if daemon is running: Success
mysql has failed. Contact your system administrator if the service does not automagically recover.
محتویان my.conf
[mysqld]
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
innodb_buffer_pool_size = 134217728
max_allowed_packet = 268435456
open_files_limit = 40000
لاگ های mysql
09:24:51 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68202 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7f2c14000900
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f2c0e7fbcb0 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xeedadb]
/usr/sbin/mysqld(handle_fatal_signal+0x486)[0x79cb16]
/lib64/libpthread.so.0(+0xf630)[0x7f2c3cb32630]
/usr/sbin/mysqld(_Z20rec_get_offsets_funcPKhPK12dict_index_t PmmPP16mem_block_info_t+0x24)[0xfe03d4]
/usr/sbin/mysqld(_Z32page_cur_search_with_match_bytesPK11buf _block_tPK12dict_index_tPK8dtuple_t15page_cur_mode _tPmS9_S9_S9_P10page_cur_t+0x485)[0xfb9b45]
/usr/sbin/mysqld(_Z27btr_cur_search_to_nth_levelP12dict_inde x_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP 5mtr_t+0x97d)[0x10e62bd]
/usr/sbin/mysqld(_Z21row_search_on_row_refP10btr_pcur_tmPK12 dict_table_tPK8dtuple_tP5mtr_t+0xbf)[0x1030b7f]
/usr/sbin/mysqld(_Z18row_purge_poss_secP12purge_node_tP12dic t_index_tPK8dtuple_t+0x2df)[0x102baff]
/usr/sbin/mysqld[0x102d082]
/usr/sbin/mysqld(_Z14row_purge_stepP9que_thr_t+0x895)[0x102e9d5]
/usr/sbin/mysqld(_Z15que_run_threadsP9que_thr_t+0x87c)[0xfda10c]
/usr/sbin/mysqld(_Z9trx_purgemmb+0x699)[0x1092349]
/usr/sbin/mysqld(srv_purge_coordinator_thread+0xded)[0x106786d]
/lib64/libpthread.so.0(+0x7ea5)[0x7f2c3cb2aea5]
/lib64/libc.so.6(clone+0x6d)[0x7f2c3af0d9fd]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 0
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2021-07-20T09:29:45.174735Z 0 [Note] libgovernor.so found