Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24427

the mariadb service is restarted unexpectedly, checking the tables, none have errors

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.3.24
    • N/A
    • 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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            dionnys Dionnys bonalde
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.