Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.3.24
-
CENTOS 7.8 cpanel v90.0.12 ram: 48 GB ssd tamaño:915G disponible 209G
Description
201217 5:00:32 [ERROR] mysqld got signal 6 ;
|
It is possible that mysqld could use up to
|
where mysqld died. If you see no messages after this, something went
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x56381102051e]
|
/usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x563810ab5a4f]
|
/usr/sbin/mysqld(+0x4ed8a0)[0x5638107f08a0]
|
/usr/sbin/mysqld(+0xa657c6)[0x563810d687c6]
|
/usr/sbin/mysqld(+0xb132a4)[0x563810e162a4]
|
/usr/sbin/mysqld(+0xb34cbb)[0x563810e37cbb]
|
/usr/sbin/mysqld(+0xad4ddf)[0x563810dd7ddf]
|
/usr/sbin/mysqld(+0xb02174)[0x563810e05174]
|
/usr/sbin/mysqld(+0xb03f8b)[0x563810e06f8b]
|
/usr/sbin/mysqld(+0xb0480c)[0x563810e0780c]
|
/usr/sbin/mysqld(+0xae4965)[0x563810de7965]
|
/usr/sbin/mysqld(+0xb05ba0)[0x563810e08ba0]
|
/usr/sbin/mysqld(+0xb06b39)[0x563810e09b39]
|
/usr/sbin/mysqld(+0xae802b)[0x563810deb02b]
|
/usr/sbin/mysqld(+0xace2b7)[0x563810dd12b7]
|
/usr/sbin/mysqld(+0xa392e4)[0x563810d3c2e4]
|
/usr/sbin/mysqld(+0x95be77)[0x563810c5ee77]
|
/usr/sbin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x10f)[0x563810aba92f]
|
/usr/sbin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x1c)[0x563810be62ac]
|
/usr/sbin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x12dd)[0x563810bfcebd]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6794)[0x5638108d6ca4]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x36d)[0x5638108d963d]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xfe1)[0x5638108daed1]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x11b)[0x5638108dd16b]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1d6)[0x5638109b3a86]
|
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x5638109b3b9d]
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
Working directory at /var/lib/mysql
|
2020-12-17 5:01:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2020-12-17 5:01:48 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
2020-12-17 5:01:48 0 [Note] /usr/sbin/mysqld: ready for connections.
|
Version: '10.3.24-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
|
2020-12-17 5:01:54 17 [ERROR] mysqld: Table './angular_angular/sesiones_usuarios' is marked as crashed and should be repaired
|
2020-12-17 5:01:54 19 [ERROR] mysqld: Table './angular_angular/log_monitoreo' is marked as crashed and should be repaired
|
2020-12-17 5:01:56 19 [ERROR] mysqld: Table './angular_angular/log_actividades' is marked as crashed and should be repaired
|
2020-12-17 5:02:09 1358 [ERROR] mysqld: Table './angular_scj_ar/usuarios_log_sincronizacion_equipo' is marked as crashed and should be repaired
|
2020-12-17 5:05:19 3196 [ERROR] mysqld: Table './angular_pepsico_ar/log_sql' is marked as crashed and should be repaired
|
2020-12-17 5:05:19 3232 [ERROR] mysqld: Table './angular_pepsico_ar/archivos_tarea' is marked as crashed and should be repaired
|
2020-12-17 5:08:53 7684 [ERROR] mysqld: Table './angular_scj_br/usuarios_log_sincronizacion_equipo' is marked as crashed and should be repaired
|
2020-12-17 5:11:23 11681 [ERROR] mysqld: Table './angular_angular/log_sql' is marked as crashed and should be repaired
|
2020-12-17 5:17:42 21397 [ERROR] mysqld: Table './angular_scj/usuarios_log_sincronizacion_equipo' is marked as crashed and should be repaired
|
2020-12-17 5:28:27 40491 [ERROR] mysqld: Table './angular_pepsico_ar/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:27 45728 [ERROR] mysqld: Table './angular_scj_ar/reporte_diario_operativo_asistencia' is marked as crashed and should be repaired
|
2020-12-17 5:30:27 45729 [ERROR] mysqld: Table './angular_scj_ar/reporte_dashboard' is marked as crashed and should be repaired
|
2020-12-17 5:30:27 45729 [ERROR] mysqld: Table './angular_scj_ar/reporte_notificaciones_ausencias' is marked as crashed and should be repaired
|
2020-12-17 5:30:28 45729 [ERROR] mysqld: Table './angular_skechers/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:29 45729 [ERROR] mysqld: Table './angular_pepsico_uy/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:29 45729 [ERROR] mysqld: Table './angular_pepsico_ar/informes_fotos_dashboard' is marked as crashed and should be repaired
|
2020-12-17 5:30:29 45729 [ERROR] mysqld: Table './angular_pepsico_ar/informes_mes_dashboard' is marked as crashed and should be repaired
|
2020-12-17 5:30:29 45729 [ERROR] mysqld: Table './angular_bgr_demaria/reporte_diario_operativo_asistencia' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_demo1/reporte_diario_operativo_asistencia' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_demo1/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_softys/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_bsale/reporte_diario_operativo_asistencia' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_scj_br/reporte_diario_operativo_asistencia' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_cordillera/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:30 45729 [ERROR] mysqld: Table './angular_mondelez/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:31 45729 [ERROR] mysqld: Table './angular_knowhow/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:31 45729 [ERROR] mysqld: Table './angular_pepsico/log_sql' is marked as crashed and should be repaired
|
2020-12-17 5:30:32 45729 [ERROR] mysqld: Table './angular_pepsico/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:32 45729 [ERROR] mysqld: Table './angular_procter/tablas_sincronizacion' is marked as crashed and should be repaired
|
2020-12-17 5:30:32 45729 [ERROR] mysqld: Table './angular_genomma/reporte_diario_operativo_asistencia' is marked as crashed and should be repaired
|
2020-12-17 7:00:13 570110 [ERROR] mysqld: Table './angular_angular/log_cron_jobs' is marked as crashed and should be repaired
|
2020-12-17 8:28:02 1875450 [ERROR] mysqld: Table './angular_arcor/log_sql' is marked as crashed and should be repaired
|
CONFIG
[mysqld]
|
# WNPower pre-configured values
|
max_heap_table_size=256M
|
tmp_table_size=256M
|
join_buffer_size=128M
|
query_cache_size=128M
|
query_cache_type=1
|
local-infile=0
|
federated
|
sql_mode = PIPES_AS_CONCAT
|
tmpdir = /tmp_maria_db
|
|
performance-schema=0
|
|
#max_sort_length = 128M
|
query_cache_limit = 2M
|
tmp_table_size = 128M
|
table_open_cache = 400
|
key_buffer_size = 10240M
|
innodb_buffer_pool_size = 20480M
|
myisam_sort_buffer_size = 256M
|
innodb_sort_buffer_size = 256M
|
read_buffer_size = 1M
|
sort_buffer_size = 2M
|
|
datadir=/var/lib/mysql
|
socket=/var/lib/mysql/mysql.sock
|
|
# Disabling symbolic-links is recommended to prevent assorted security risks
|
symbolic-links=0
|
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G
|
log-error=/var/log/mysqld.log
|
# pid-file=/var/run/mysqld/mysqld.pid
|
max_allowed_packet=268435456
|
open_files_limit=40000
|
innodb_file_per_table=1
|
|
group_concat_max_len=90000
|