[MDEV-24427] the mariadb service is restarted unexpectedly, checking the tables, none have errors Created: 2020-12-17  Updated: 2022-11-23  Resolved: 2022-11-23

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Delete
Affects Version/s: 10.3.24
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Dionnys bonalde Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: crash
Environment:

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



 Comments   
Comment by Daniel Black [ 2022-10-19 ]

Sorry for the late reply. From the stack trace this is obviously a DELETE. Do you have the DELETE SQL, table structures of related tables and query plan EXPLAIN DELETE .... Is it still occuring on newer MariaDB versions?

Generated at Thu Feb 08 09:29:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.