Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3.7
    • N/A
    • N/A
    • None
    • centos 7 latest

    Description

      Jun 07 12:19:58 db01 mysqld[15879]: 2018-06-07 12:19:58 0 [Note] InnoDB: Buffer pool(s) load completed at 180607 12:19:58
      Jun 07 12:22:33 db01 mysqld[15879]: 180607 12:22:33 [ERROR] mysqld got signal 11 ;
      Jun 07 12:22:33 db01 mysqld[15879]: This could be because you hit a bug. It is also possible that this binary
      Jun 07 12:22:33 db01 mysqld[15879]: or one of the libraries it was linked against is corrupt, improperly built,
      Jun 07 12:22:33 db01 mysqld[15879]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Jun 07 12:22:33 db01 mysqld[15879]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Jun 07 12:22:33 db01 mysqld[15879]: We will try our best to scrape up some info that will hopefully help
      Jun 07 12:22:33 db01 mysqld[15879]: diagnose the problem, but since we have already crashed,
      Jun 07 12:22:33 db01 mysqld[15879]: something is definitely wrong and this may fail.
      Jun 07 12:22:33 db01 mysqld[15879]: Server version: 10.3.7-MariaDB-log
      Jun 07 12:22:33 db01 mysqld[15879]: key_buffer_size=20971520
      Jun 07 12:22:33 db01 mysqld[15879]: read_buffer_size=131072
      Jun 07 12:22:33 db01 mysqld[15879]: max_used_connections=38
      Jun 07 12:22:33 db01 mysqld[15879]: max_threads=502
      Jun 07 12:22:33 db01 mysqld[15879]: thread_count=46
      Jun 07 12:22:33 db01 mysqld[15879]: It is possible that mysqld could use up to
      Jun 07 12:22:33 db01 mysqld[15879]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1124002 K bytes of memory
      Jun 07 12:22:33 db01 mysqld[15879]: Hope that's ok; if not, decrease some variables in the equation.
      Jun 07 12:22:33 db01 mysqld[15879]: Thread pointer: 0x7f0c5c0009a8
      Jun 07 12:22:33 db01 mysqld[15879]: Attempting backtrace. You can use the following information to find out
      Jun 07 12:22:33 db01 mysqld[15879]: where mysqld died. If you see no messages after this, something went
      Jun 07 12:22:33 db01 mysqld[15879]: terribly wrong...
      Jun 07 12:22:33 db01 mysqld[15879]: stack_bottom = 0x7f0d044e2d30 thread_stack 0x49000
      Jun 07 12:22:33 db01 mysqld[15879]: *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      Jun 07 12:22:33 db01 mysqld[15879]: ======= Backtrace: =========
      Jun 07 12:22:33 db01 mysqld[15879]: /lib64/libc.so.6(__fortify_fail+0x37)[0x7f12565fc6e7]
      Jun 07 12:22:33 db01 mysqld[15879]: /lib64/libc.so.6(+0x116862)[0x7f12565fa862]
      Jun 07 12:22:33 db01 mysqld[15879]: /lib64/libc.so.6(+0x118647)[0x7f12565fc647]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(my_addr_resolve+0xda)[0x7f125936d11a]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x7f12593567a2]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(handle_fatal_signal+0x357)[0x7f1258df5117]
      Jun 07 12:22:33 db01 mysqld[15879]: /lib64/libpthread.so.0(+0xf6d0)[0x7f12582466d0]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_ZN6st_key18actual_rec_per_keyEj+0x42)[0x7f1258cd4332]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_ZN13st_join_table21choose_best_splittingEdy+0x19d)[0x7f1258d602ed]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(Z16best_access_pathP4JOINP13st_join_tableyjbdP11st_positionS4+0xf2)[0x7f1258c527f2]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(+0x5ddc4a)[0x7f1258c54c4a]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(+0x5ddfb1)[0x7f1258c54fb1]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(+0x5ddfb1)[0x7f1258c54fb1]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(+0x5de221)[0x7f1258c55221]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z11choose_planP4JOINy+0xdd)[0x7f1258c556cd]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(+0x5f63bc)[0x7f1258c6d3bc]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x8b6)[0x7f1258c75e66]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x37)[0x7f1258c76107]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x7f1258c776d4]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x7f1258c7826c]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(+0x4b8e1f)[0x7f1258b2fe1f]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x69cd)[0x7f1258c2465d]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x7f1258c26f4b]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1d2c)[0x7f1258c29b4c]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x7f1258c2a97e]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x7f1258cf95ba]
      Jun 07 12:22:33 db01 mysqld[15879]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x7f1258cf96dd]
      Jun 07 12:22:33 db01 mysqld[15879]: /lib64/libpthread.so.0(+0x7e25)[0x7f125823ee25]
      Jun 07 12:22:33 db01 mysqld[15879]: /lib64/libc.so.6(clone+0x6d)[0x7f12565e2bad]
      Jun 07 12:22:33 db01 mysqld[15879]: ======= Memory map: ========
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0bd8000000-7f0bd8021000 rw-p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0bd8021000-7f0bdc000000 ---p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0be0000000-7f0be1932000 rw-p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0be1932000-7f0be4000000 ---p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0be4000000-7f0be4074000 rw-p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0be4074000-7f0be8000000 ---p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0be8000000-7f0be8078000 rw-p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0be8078000-7f0bec000000 ---p 00000000 00:00 0
      Jun 07 12:22:33 db01 mysqld[15879]: 7f0bec000000-7f0bed935000 rw-p 00000000 00:00 0
      Jun 07 12:22:33 db01 systemd[1]: mariadb.service: main process exited, code=killed, status=6/ABRT
      Jun 07 12:22:33 db01 systemd[1]: Unit mariadb.service entered failed state.
      Jun 07 12:22:33 db01 systemd[1]: mariadb.service failed.
      Jun 07 12:22:38 db01 systemd[1]: mariadb.service holdoff time over, scheduling restart.
      Jun 07 12:22:38 db01 systemd[1]: Starting MariaDB 10.3.7 database server...
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] /usr/sbin/mysqld (mysqld 10.3.7-MariaDB-log) starting as process 16071 ...
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Using Linux native AIO
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Uses event mutexes
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Number of pools: 1
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Initializing buffer pool, total size = 20G, instances = 8, chunk size = 128M
      Jun 07 12:22:39 db01 mysqld[16071]: 2018-06-07 12:22:39 0 [Note] InnoDB: Completed initialization of buffer pool
      Jun 07 12:22:40 db01 mysqld[16071]: 2018-06-07 12:22:40 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      Jun 07 12:22:40 db01 mysqld[16071]: 2018-06-07 12:22:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18083751357604
      Jun 07 12:22:40 db01 mysqld[16071]: 2018-06-07 12:22:40 0 [Note] InnoDB: Transaction 3219645083 was in the XA prepared state.
      Jun 07 12:22:40 db01 mysqld[16071]: 2018-06-07 12:22:40 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
      Jun 07 12:22:40 db01 mysqld[16071]: 2018-06-07 12:22:40 0 [Note] InnoDB: Trx id counter is 3219645084
      Jun 07 12:22:40 db01 mysqld[16071]: 2018-06-07 12:22:40 0 [Note] InnoDB: Starting final batch to recover 27 pages from redo log.
      Jun 07 12:22:41 db01 mysqld[16071]: 2018-06-07 12:22:41 0 [Note] InnoDB: Last binlog file './mysql-bin.003573', position 215262
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Rollback of non-prepared transactions completed
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: 10.3.7 started; log sequence number 18083751489551; transaction id 3219645086
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Plugin 'FEEDBACK' is disabled.
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Recovering after a crash using mysql-bin
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Starting crash recovery...
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Starting recovery for XA transactions...
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Transaction 3219645083 in prepared state after recovery
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: Transaction contains changes to 1 rows
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] InnoDB: 1 transactions in prepared state after recovery
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Found 1 prepared transaction(s) in InnoDB
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Crash recovery finished.
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Server socket created on IP: '::'.
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Warning] Checking table: './mysql/event'
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 7 [Note] Event Scheduler: scheduler thread started with id 7
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Reading of all Master_info entries succeded
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] Added new Master_info '' to hash table
      Jun 07 12:22:43 db01 mysqld[16071]: 2018-06-07 12:22:43 0 [Note] /usr/sbin/mysqld: ready for connections.
      Jun 07 12:22:43 db01 mysqld[16071]: Version: '10.3.7-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      Jun 07 12:22:43 db01 systemd[1]: Started MariaDB 10.3.7 database server.

      Attachments

        1. dmidecode.txt
          21 kB
        2. journal.txt
          3.51 MB
        3. my.cnf
          2 kB

        Issue Links

          Activity

            People

              alice Alice Sherepa
              robjuffermans Rob Juffermans
              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.