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

Fails on Alter statements against large tables

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.11, 10.11.12
    • 10.11, 11.4
    • None
    • RHEL 8.10 MariaDB 10.11.11 VMware VM

    Description

      mariadb.err

      InnoDB: about forcing recovery.
      250522 16:17:10 [ERROR] /usr/sbin/mariadbd got signal 6 ;
      Sorry, we probably made a mistake, and this is a bug.
       
      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.
       
      Please include the information from the server start above, to the end of the
      information below.
       
      Server version: 10.11.11-MariaDB source revision: e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4
       
      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      contains instructions to obtain a better version of the backtrace below.
      Following these instructions will help MariaDB developers provide a fix quicker.
       
      Attempting backtrace. Include this in the bug report.
      (note: Retrieving this information may fail)
       
      Thread pointer: 0x7f0464001998
      stack_bottom = 0x7f04997b7000 thread_stack 0x49000
      Printing to addr2line failed
      /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x558d76d3343e]
      /usr/sbin/mariadbd(handle_fatal_signal+0x2fd)[0x558d7681978d]
      /lib64/libpthread.so.0(+0x12990)[0x7f66ab362990]
      /lib64/libc.so.6(gsignal+0x10f)[0x7f66aa49552f]
      /lib64/libc.so.6(abort+0x127)[0x7f66aa468e65]
      /usr/sbin/mariadbd(+0x6b9812)[0x558d76445812]
      /usr/sbin/mariadbd(+0x6aba11)[0x558d76437a11]
      /usr/sbin/mariadbd(+0xe0bf17)[0x558d76b97f17]
      /usr/sbin/mariadbd(+0xe0c572)[0x558d76b98572]
      /usr/sbin/mariadbd(+0xe03f8b)[0x558d76b8ff8b]
      /usr/sbin/mariadbd(+0xe16727)[0x558d76ba2727]
      /usr/sbin/mariadbd(+0xd5fe42)[0x558d76aebe42]
      /usr/sbin/mariadbd(_ZN7handler12ha_write_rowEPKh+0x1cf)[0x558d76828e1f]
      /usr/sbin/mariadbd(+0x8e975a)[0x558d7667575a]
      /usr/sbin/mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x4e97)[0x558d76680127]
      /usr/sbin/mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x339)[0x558d766edcb9]
      /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x132c)[0x558d765bd5ec]
      /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x275)[0x558d765ac9d3]
      /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x13f4)[0x558d765b9543]
      /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x558d765bb51f]
      /usr/sbin/mariadbd(_Z11tp_callbackP13TP_connection+0x83)[0x558d767a2c73]
      /usr/sbin/mariadbd(+0xc0cb50)[0x558d76998b50]
      /usr/sbin/mariadbd(+0xcacbc5)[0x558d76a38bc5]
      /lib64/libpthread.so.0(+0x81ca)[0x7f66ab3581ca]
      /lib64/libc.so.6(clone+0x43)[0x7f66aa4808d3]
       
      Connection ID (thread ID): 4
      Status: NOT_KILLED
      Query (0x7f046402cf40): ALTER TABLE `redcap_data_import_rows`
        CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=off,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off
       
      Writing a core file...
      Working directory at /data/mariadb/data
      Resource Limits (excludes unlimited resources):
      Limit                     Soft Limit           Hard Limit           Units
      Max stack size            8388608              unlimited            bytes
      Max core file size        0                    unlimited            bytes
      Max processes             2061728              2061728              processes
      Max open files            32768                32768                files
      Max locked memory         65536                65536                bytes
      Max pending signals       2061728              2061728              signals
      Max msgqueue size         819200               819200               bytes
      Max nice priority         0                    0
      Max realtime priority     0                    0
      Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
       
      Kernel version: Linux version 4.18.0-553.51.1.el8_10.x86_64 (mockbuild@x86-64-02.build.eng.rdu2.redhat.com) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-26) (GCC)) #1 SMP Fri Apr 25 00:55:37 EDT 2025
       
      2025-05-22 16:17:18 0 [Note] Starting MariaDB 10.11.11-MariaDB source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid P6O4wCkGhYxkD0gP5KmUZBDlAvg= as process 581761
      2025-05-22 16:17:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2025-05-22 16:17:18 0 [Note] InnoDB: Number of transaction pools: 1
      2025-05-22 16:17:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2025-05-22 16:17:18 0 [Note] InnoDB: Using Linux native AIO
      2025-05-22 16:17:18 0 [Note] InnoDB: Initializing buffer pool, total size = 384.000GiB, chunk size = 6.000GiB
      2025-05-22 16:17:19 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-05-22 16:17:19 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      2025-05-22 16:17:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=20057013677338
      2025-05-22 16:17:21 0 [Note] InnoDB: End of log at LSN=20057652000155
      2025-05-22 16:17:21 0 [Note] InnoDB: To recover: 41013 pages
      2025-05-22 16:17:21 0 [Note] InnoDB: 128 rollback segments are active.
      2025-05-22 16:17:21 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
      2025-05-22 16:17:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2025-05-22 16:17:21 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2025-05-22 16:17:21 0 [Note] InnoDB: log sequence number 20057652000155; transaction id 7789494
      2025-05-22 16:17:21 0 [Note] InnoDB: Loading buffer pool(s) from /data/mariadb/data/ib_buffer_pool
      2025-05-22 16:17:21 0 [Note] Plugin 'FEEDBACK' is disabled.
      2025-05-22 16:17:21 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2025-05-22 16:17:21 0 [Warning] 'innodb-page-cleaners' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2025-05-22 16:17:21 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2025-05-22 16:17:21 0 [Note] DDL_LOG: Crash recovery executed 1 entries
      2025-05-22 16:17:21 0 [Note] Server socket created on IP: '0.0.0.0'.
      2025-05-22 16:17:21 0 [Warning] Failed to create a socket for IPv6 '::': errno: 97.
      2025-05-22 16:17:21 0 [Warning] 'proxies_priv' entry '@% root@redcap-tst8-db.pmacs.upenn.edu' ignored in --skip-name-resolve mode.
      2025-05-22 16:17:22 0 [Note] /usr/sbin/mariadbd: ready for connections.
      Version: '10.11.11-MariaDB'  socket: '/data/mariadb/data/mariadb.sock'  port: 3306  MariaDB Server
      2025-05-22 16:17:47 0 [Note] InnoDB: Buffer pool(s) load completed at 250522 16:17:47

      Attachments

        Activity

          People

            marko Marko Mäkelä
            turjames5 James Turner
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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