Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.3, 10.4.4, 10.4.5, 10.4.6, 10.4.7, 10.4.8, 10.4.9, 10.4.10
    • 10.4.11
    • None
    • Gentoo Linux
      GCC x86_64-pc-linux-gnu-9.2.0
      Linux Kernel 5.3.7

      2 x Intel(R) Xeon(R) Gold 6134 CPU's
      256GB RAM
      Intel 1.6TB P3700 NVME SSD

      also CentOS 7

    Description

      191119 10:57:17 [ERROR] mysqld got signal 11 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
       
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs
       
      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed,
      something is definitely wrong and this may fail.
       
      Server version: 10.4.10-MariaDB-log
      key_buffer_size=2147483648
      read_buffer_size=2097152
      max_used_connections=884
      max_threads=5002
      thread_count=58
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 32945674 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x7f04985d7678
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7f054f05fe78 thread_stack 0x49000
      /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x556eb5baefd9]
      /usr/sbin/mysqld(handle_fatal_signal+0x53d)[0x556eb56d5d0d]
      /lib64/libpthread.so.0(+0x153a0)[0x7f383c0803a0]
      /usr/sbin/mysqld(+0xa9577a)[0x556eb594e77a]
      /usr/sbin/mysqld(+0xa95904)[0x556eb594e904]
      /usr/sbin/mysqld(+0xa95fb5)[0x556eb594efb5]
      /usr/sbin/mysqld(+0xa993c0)[0x556eb59523c0]
      /usr/sbin/mysqld(+0x9c14fb)[0x556eb587a4fb]
      /usr/sbin/mysqld(+0x68785a)[0x556eb554085a]
      /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x173)[0x556eb5533b33]
      /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xc34)[0x556eb555e044]
      /usr/sbin/mysqld(_ZN4JOIN4execEv+0x2a)[0x556eb555e2ca]
      /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x133)[0x556eb555c523]
      /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x152)[0x556eb555cfd2]
      /usr/sbin/mysqld(+0x63bd56)[0x556eb54f4d56]
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x15ca)[0x556eb54fdc5a]
      /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1b4)[0x556eb5503a44]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xe8a)[0x556eb550515a]
      /usr/sbin/mysqld(_Z10do_commandP3THD+0xd9)[0x556eb5506d79]
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1bc)[0x556eb55e5abc]
      /usr/sbin/mysqld(handle_one_connection+0x32)[0x556eb55e5bf2]
      /lib64/libpthread.so.0(+0x83d7)[0x7f383c0733d7]
      /lib64/libc.so.6(clone+0x3f)[0x7f383b88014f]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f049812ee00): is an invalid pointer
      Connection ID (thread ID): 49237686
      Status: NOT_KILLED
       
      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=on,condition_pushdown_from_having=on
       
      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.
       
      We think the query pointer is invalid, but we will try to print it anyway.
      Query: SELECT COUNT(*) AS numrows
      FROM core_reviews
      WHERE core_reviews.sitearea = '2'
      AND core_reviews.siteareaid = '59106'
      AND MATCH (core_reviews.summary) AGAINST ('eren,,,')
       
      Writing a core file...
      Working directory at /var/lib/mysql
      Resource Limits:
      Limit                     Soft Limit           Hard Limit           Units
      Max cpu time              unlimited            unlimited            seconds
      Max file size             unlimited            unlimited            bytes
      Max data size             unlimited            unlimited            bytes
      Max stack size            8388608              unlimited            bytes
      Max core file size        0                    unlimited            bytes
      Max resident set          unlimited            unlimited            bytes
      Max processes             1032474              1032474              processes
      Max open files            70599                70599                files
      Max locked memory         65536                65536                bytes
      Max address space         unlimited            unlimited            bytes
      Max file locks            unlimited            unlimited            locks
      Max pending signals       1032474              1032474              signals
      Max msgqueue size         819200               819200               bytes
      Max nice priority         0                    0
      Max realtime priority     0                    0
      Max realtime timeout      unlimited            unlimited            us
      Core pattern: core
      

      Attachments

        Issue Links

          Activity

            Could you please get a stack trace from the coredump? It should be more meaningful than the crash report the server produces.

            Please also paste the output of

            SHOW CREATE TABLE core_reviews;
            SHOW INDEX IN core_reviews;
            

            and paste or attach your config file(s). Thanks.

            elenst Elena Stepanova added a comment - Could you please get a stack trace from the coredump? It should be more meaningful than the crash report the server produces. Please also paste the output of SHOW CREATE TABLE core_reviews; SHOW INDEX IN core_reviews; and paste or attach your config file(s). Thanks.
            gregnetau Greg M added a comment - - edited

            Hi,

            This crash seems to be time - bound. It occurs at a random period of time after MariaDB has been running, and only specific to this host. I have 4 servers running MariaDB 10.4.10 including this one (master), a slave, and a standalone.

            This crash occured approx 3.5 days after the service started.

            MariaDB [XXXX]> SHOW CREATE TABLE core_reviews;
            +--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            | Table        | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
            +--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            | core_reviews | CREATE TABLE `core_reviews` (
              `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT,
              `sitearea` tinyint(2) unsigned NOT NULL DEFAULT 1,
              `siteareaid` int(11) unsigned NOT NULL DEFAULT 1,
              `memberipid` varchar(39) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
              `rating` tinyint(2) unsigned NOT NULL DEFAULT 5,
              `countrating` tinyint(1) unsigned NOT NULL DEFAULT 1,
              `earlyaccess` tinyint(1) unsigned NOT NULL DEFAULT 0,
              `date` int(11) unsigned NOT NULL DEFAULT 0,
              `positive` smallint(6) NOT NULL DEFAULT 0,
              `negative` smallint(6) NOT NULL DEFAULT 0,
              `spoiler` smallint(5) unsigned NOT NULL DEFAULT 0,
              `summary` varchar(5000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
              PRIMARY KEY (`id`),
              UNIQUE KEY `sitearea_2` (`sitearea`,`siteareaid`,`memberipid`),
              KEY `sitearea` (`sitearea`,`siteareaid`),
              FULLTEXT KEY `summary` (`summary`)
            ) ENGINE=InnoDB AUTO_INCREMENT=719190 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
            +--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            1 row in set (0.000 sec)
            

            MariaDB [XXXX]> SHOW INDEX IN core_reviews;
            +--------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
            | Table        | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
            +--------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
            | core_reviews |          0 | PRIMARY    |            1 | id          | A         |      649746 |     NULL | NULL   |      | BTREE      |         |               |
            | core_reviews |          0 | sitearea_2 |            1 | sitearea    | A         |          10 |     NULL | NULL   |      | BTREE      |         |               |
            | core_reviews |          0 | sitearea_2 |            2 | siteareaid  | A         |       64974 |     NULL | NULL   |      | BTREE      |         |               |
            | core_reviews |          0 | sitearea_2 |            3 | memberipid  | A         |      649746 |     NULL | NULL   |      | BTREE      |         |               |
            | core_reviews |          1 | sitearea   |            1 | sitearea    | A         |          10 |     NULL | NULL   |      | BTREE      |         |               |
            | core_reviews |          1 | sitearea   |            2 | siteareaid  | A         |       72194 |     NULL | NULL   |      | BTREE      |         |               |
            | core_reviews |          1 | summary    |            1 | summary     | NULL      |        NULL |     NULL | NULL   |      | FULLTEXT   |         |               |
            +--------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
            7 rows in set (0.000 sec)
            

            MySQL Configuration file:

            port                                            = 3306
            socket                                          = /var/run/mysqld/mysqld.sock
            default-character-set                           = utf8mb4
             
             
            [mysqld_safe]
            err-log                                         = /var/log/mysql/mysql.err
            nice = -20
            open_files_limit = 65535
             
            [mysqld]
            skip_name_resolve
            performance_schema = OFF
            character-set-server            = utf8mb4
            collation-server                = utf8mb4_unicode_ci
            skip-character-set-client-handshake
            init-connect='SET NAMES utf8mb4'
            user                                            = mysql
            port                                            = 3306
            socket                                          = /var/run/mysqld/mysqld.sock
            pid-file                                        = /var/run/mysqld/mysqld.pid
            log-error                                       = /var/log/mysql/mysqld.err
            basedir                                         = /usr
            datadir                                         = /var/lib/mysql
            slow-query-log
            long_query_time = 15
            slave-skip-errors = 1062
            back_log = 1000
            max_connections = 5000
            key_buffer_size = 2048M
            myisam_sort_buffer_size = 8M
            join_buffer_size = 4M
            read_buffer_size = 2M
            sort_buffer_size = 4M
            table_open_cache = 32768
            thread_cache_size = 50
            wait_timeout = 45
            connect_timeout = 10
            tmp_table_size = 8192M
            max_heap_table_size = 8192M
            max_allowed_packet = 8192M
            net_buffer_length = 640000
            max_connect_errors = 999999
            concurrent_insert=ALWAYS
            low_priority_updates=1
            read_rnd_buffer_size = 4M
            bulk_insert_buffer_size = 16M
            query_cache_size = 32M
            query_cache_type = 1
            query_prealloc_size = 65536
            query_alloc_block_size = 131072
            query_cache_limit = 262144
            transaction_alloc_block_size = 8192
            transaction_prealloc_size = 4096
            default-storage-engine = MyISAM
            table_definition_cache = 4096
             
            bind-address                            = 10.200.1.249
             
            log-bin = /var/lib/mysql/XXXX-bin.log
            binlog-do-db=XXXX_site
            binlog_do-db=XXXX_site
             
            file_key_management = ON
            file_key_management_encryption_algorithm=aes_cbc
            file_key_management_filename = /etc/mysql/mariadb_encryption.key
            file_key_management_filekey = FILE:/etc/mysql/.keypass
            #loose_file_key_management_filename = /etc/mysql/mariadb_encryption.txt
            innodb_default_encryption_key_id = 1
            innodb_encrypt_tables = ON
            innodb_encrypt_log = ON
            aria_encrypt_tables = ON
            encrypt_tmp_disk_tables = ON
            innodb_encryption_threads = 8
            plugin_load_add=file_key_management
             
            server-id                                       = 9
            tmpdir                                          = /tmp/
            innodb_buffer_pool_size         = 192G
            innodb_io_capacity              = 55000
            innodb_read_io_threads          = 64
            innodb_write_io_threads         = 32
            innodb_doublewrite              = OFF
            innodb_flush_log_at_timeout     = 5
            innodb_max_dirty_pages_pct = 10
            innodb_buffer_pool_instances=64
            sync_binlog = 10
            innodb_thread_concurrency=0
            innodb_adaptive_hash_index=OFF
            expire_logs_days=7
             
            innodb_data_file_path           = ibdata1:10M:autoextend
            innodb_log_file_size            = 512M
            innodb_log_buffer_size          = 256M
            innodb_flush_log_at_trx_commit  = 1
            innodb_log_files_in_group      = 2
            innodb_file_per_table = 1
            innodb_open_files = 16384
             
            [mysqldump]
            quick
            max_allowed_packet                      = 512M
             
            [isamchk]
            key_buffer                                      = 20M
            sort_buffer_size                        = 40M
            read_buffer                             = 2M
            write_buffer                            = 2M
             
            [myisamchk]
            key_buffer                                      = 20M
            sort_buffer_size                        = 40M
            read_buffer                             = 2M
            write_buffer                            = 2M
             
            [mysqlhotcopy]
            interactive-timeout
            

            gregnetau Greg M added a comment - - edited Hi, This crash seems to be time - bound. It occurs at a random period of time after MariaDB has been running, and only specific to this host. I have 4 servers running MariaDB 10.4.10 including this one (master), a slave, and a standalone. This crash occured approx 3.5 days after the service started. MariaDB [XXXX]> SHOW CREATE TABLE core_reviews; + --------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | + --------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | core_reviews | CREATE TABLE `core_reviews` ( `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT, `sitearea` tinyint(2) unsigned NOT NULL DEFAULT 1, `siteareaid` int (11) unsigned NOT NULL DEFAULT 1, `memberipid` varchar (39) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' , `rating` tinyint(2) unsigned NOT NULL DEFAULT 5, `countrating` tinyint(1) unsigned NOT NULL DEFAULT 1, `earlyaccess` tinyint(1) unsigned NOT NULL DEFAULT 0, ` date ` int (11) unsigned NOT NULL DEFAULT 0, `positive` smallint (6) NOT NULL DEFAULT 0, `negative` smallint (6) NOT NULL DEFAULT 0, `spoiler` smallint (5) unsigned NOT NULL DEFAULT 0, `summary` varchar (5000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' , PRIMARY KEY (`id`), UNIQUE KEY `sitearea_2` (`sitearea`,`siteareaid`,`memberipid`), KEY `sitearea` (`sitearea`,`siteareaid`), FULLTEXT KEY `summary` (`summary`) ) ENGINE=InnoDB AUTO_INCREMENT=719190 DEFAULT CHARSET=utf8mb4 COLLATE =utf8mb4_unicode_ci | + --------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [XXXX]> SHOW INDEX IN core_reviews; + --------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | + --------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | core_reviews | 0 | PRIMARY | 1 | id | A | 649746 | NULL | NULL | | BTREE | | | | core_reviews | 0 | sitearea_2 | 1 | sitearea | A | 10 | NULL | NULL | | BTREE | | | | core_reviews | 0 | sitearea_2 | 2 | siteareaid | A | 64974 | NULL | NULL | | BTREE | | | | core_reviews | 0 | sitearea_2 | 3 | memberipid | A | 649746 | NULL | NULL | | BTREE | | | | core_reviews | 1 | sitearea | 1 | sitearea | A | 10 | NULL | NULL | | BTREE | | | | core_reviews | 1 | sitearea | 2 | siteareaid | A | 72194 | NULL | NULL | | BTREE | | | | core_reviews | 1 | summary | 1 | summary | NULL | NULL | NULL | NULL | | FULLTEXT | | | + --------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 7 rows in set (0.000 sec) MySQL Configuration file: port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8mb4     [mysqld_safe] err-log = /var/log/mysql/mysql.err nice = -20 open_files_limit = 65535   [mysqld] skip_name_resolve performance_schema = OFF character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci skip-character-set-client-handshake init-connect='SET NAMES utf8mb4' user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql slow-query-log long_query_time = 15 slave-skip-errors = 1062 back_log = 1000 max_connections = 5000 key_buffer_size = 2048M myisam_sort_buffer_size = 8M join_buffer_size = 4M read_buffer_size = 2M sort_buffer_size = 4M table_open_cache = 32768 thread_cache_size = 50 wait_timeout = 45 connect_timeout = 10 tmp_table_size = 8192M max_heap_table_size = 8192M max_allowed_packet = 8192M net_buffer_length = 640000 max_connect_errors = 999999 concurrent_insert=ALWAYS low_priority_updates=1 read_rnd_buffer_size = 4M bulk_insert_buffer_size = 16M query_cache_size = 32M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size = 131072 query_cache_limit = 262144 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM table_definition_cache = 4096   bind-address = 10.200.1.249   log-bin = /var/lib/mysql/XXXX-bin.log binlog-do-db=XXXX_site binlog_do-db=XXXX_site   file_key_management = ON file_key_management_encryption_algorithm=aes_cbc file_key_management_filename = /etc/mysql/mariadb_encryption.key file_key_management_filekey = FILE:/etc/mysql/.keypass #loose_file_key_management_filename = /etc/mysql/mariadb_encryption.txt innodb_default_encryption_key_id = 1 innodb_encrypt_tables = ON innodb_encrypt_log = ON aria_encrypt_tables = ON encrypt_tmp_disk_tables = ON innodb_encryption_threads = 8 plugin_load_add=file_key_management   server-id = 9 tmpdir = /tmp/ innodb_buffer_pool_size = 192G innodb_io_capacity = 55000 innodb_read_io_threads = 64 innodb_write_io_threads = 32 innodb_doublewrite = OFF innodb_flush_log_at_timeout = 5 innodb_max_dirty_pages_pct = 10 innodb_buffer_pool_instances=64 sync_binlog = 10 innodb_thread_concurrency=0 innodb_adaptive_hash_index=OFF expire_logs_days=7   innodb_data_file_path = ibdata1:10M:autoextend innodb_log_file_size = 512M innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_log_files_in_group = 2 innodb_file_per_table = 1 innodb_open_files = 16384   [mysqldump] quick max_allowed_packet = 512M   [isamchk] key_buffer = 20M sort_buffer_size = 40M read_buffer = 2M write_buffer = 2M   [myisamchk] key_buffer = 20M sort_buffer_size = 40M read_buffer = 2M write_buffer = 2M   [mysqlhotcopy] interactive-timeout
            juan.vera Juan added a comment - - edited

            I am able to reproduce it 100% of the time with a specific customer data-set. Additional error log / stack trace:

            2019-11-24 15:34:18 0x7feaa8112700  InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.10/storage/innobase/row/row0mysql.cc line 180
            InnoDB: Failing assertion: len < 256 * 256
            InnoDB: We intentionally generate a memory trap.
            InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
            InnoDB: If you get repeated assertion failures or crashes, even
            InnoDB: immediately after the mysqld startup, there may be
            InnoDB: corruption in the InnoDB tablespace. Please refer to
            InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
            InnoDB: about forcing recovery.
            191124 15:34:18 [ERROR] mysqld got signal 6 ;
            This could be because you hit a bug. It is also possible that this binary
            or one of the libraries it was linked against is corrupt, improperly built,
            or misconfigured. This error can also be caused by malfunctioning hardware.
             
            To report this bug, see https://mariadb.com/kb/en/reporting-bugs
             
            We will try our best to scrape up some info that will hopefully help
            diagnose the problem, but since we have already crashed,
            something is definitely wrong and this may fail.
             
            Server version: 10.4.10-MariaDB-log
            key_buffer_size=134217728
            read_buffer_size=131072
            max_used_connections=1
            max_threads=153
            thread_count=8
            It is possible that mysqld could use up to
            key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467738 K  bytes of memory
            Hope that's ok; if not, decrease some variables in the equation.
             
            Thread pointer: 0x7feaa4000a88
            Attempting backtrace. You can use the following information to find out
            where mysqld died. If you see no messages after this, something went
            terribly wrong...
            stack_bottom = 0x7feaa8111cf0 thread_stack 0x49000
            /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c1487d1f2e]
            /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55c1482683af]
            sigaction.c:0(__restore_rt)[0x7feaae5a85f0]
            :0(__GI_raise)[0x7feaac879337]
            :0(__GI_abort)[0x7feaac87aa28]
            /usr/sbin/mysqld(+0x5a1f92)[0x55c147f62f92]
            /usr/sbin/mysqld(+0xb169d7)[0x55c1484d79d7]
            /usr/sbin/mysqld(+0xb33430)[0x55c1484f4430]
            /usr/sbin/mysqld(+0x5a05d9)[0x55c147f615d9]
            /usr/sbin/mysqld(+0x5a0885)[0x55c147f61885]
            /usr/sbin/mysqld(+0xb361dd)[0x55c1484f71dd]
            /usr/sbin/mysqld(+0xa5404d)[0x55c14841504d]
            /usr/sbin/mysqld(+0x6df095)[0x55c1480a0095]
            /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1a9)[0x55c148094cd9]
            /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb9c)[0x55c1480b72ac]
            /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55c1480b7503]
            /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x186)[0x55c1480b5806]
            /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d7)[0x55c1480b6377]
            /usr/sbin/mysqld(+0x58fd84)[0x55c147f50d84]
            /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x449a)[0x55c14805db6a]
            /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x24b)[0x55c148062aeb]
            /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1b5e)[0x55c1480658ee]
            /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x55c14806707c]
            /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1fa)[0x55c148142afa]
            /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55c148142bdd]
            pthread_create.c:0(start_thread)[0x7feaae5a0e65]
            /lib64/libc.so.6(clone+0x6d)[0x7feaac94188d]
             
            Trying to get some variables.
            Some pointers may be invalid and cause the dump to abort.
            Query (0x7feaa4011f80): select count(*) from clients where MATCH(clients.first_name, clients.last_name) AGAINST("+MOJCA")AND clients.vin = "U5YPG812AKL682312"
            Connection ID (thread ID): 9
            Status: NOT_KILLED
             
            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=on,condition_pushdown_from_having=on
             
            The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
            information that should help you find out what is causing the crash.
            Writing a core file...
            Working directory at /var/lib/mysql
            Resource Limits:
            Limit                     Soft Limit           Hard Limit           Units
            Max cpu time              unlimited            unlimited            seconds
            Max file size             unlimited            unlimited            bytes
            Max data size             unlimited            unlimited            bytes
            Max stack size            8388608              unlimited            bytes
            Max core file size        unlimited            unlimited            bytes
            Max resident set          unlimited            unlimited            bytes
            Max processes             3875                 3875                 processes
            Max open files            16364                16364                files
            Max locked memory         65536                65536                bytes
            Max address space         unlimited            unlimited            bytes
            Max file locks            unlimited            unlimited            locks
            Max pending signals       3875                 3875                 signals
            Max msgqueue size         819200               819200               bytes
            Max nice priority         0                    0
            Max realtime priority     0                    0
            Max realtime timeout      unlimited            unlimited            us
            Core pattern: /tmp/corefiles/core
             
            2019-11-24 15:36:55 0 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used;  This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=MariaDB-10-4-10-141' or '--log-bin=MariaDB-10-4-10-141-bin' to avoid this problem.
            2019-11-24 15:36:55 0 [Note] InnoDB: Using Linux native AIO
            2019-11-24 15:36:55 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
            2019-11-24 15:36:55 0 [Note] InnoDB: Uses event mutexes
            2019-11-24 15:36:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
            2019-11-24 15:36:55 0 [Note] InnoDB: Number of pools: 1
            2019-11-24 15:36:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
            2019-11-24 15:36:55 0 [Note] InnoDB: Initializing buffer pool, total size = 640M, instances = 1, chunk size = 128M
            2019-11-24 15:36:55 0 [Note] InnoDB: Completed initialization of buffer pool
            2019-11-24 15:36:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
            2019-11-24 15:36:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2159350145
            2019-11-24 15:36:56 0 [Note] InnoDB: Last binlog file './MariaDB-10-4-10-141-bin.000003', position 1015149797
            2019-11-24 15:36:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
            2019-11-24 15:36:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
            2019-11-24 15:36:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
            2019-11-24 15:36:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
            2019-11-24 15:36:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
            2019-11-24 15:36:56 0 [Note] InnoDB: Waiting for purge to start
            2019-11-24 15:36:56 0 [Note] InnoDB: 10.4.10 started; log sequence number 2159350154; transaction id 8784061
            2019-11-24 15:36:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
            2019-11-24 15:36:56 0 [Note] Plugin 'FEEDBACK' is disabled.
            2019-11-24 15:36:56 0 [Note] Recovering after a crash using MariaDB-10-4-10-141-bin
            2019-11-24 15:36:56 0 [Note] Starting crash recovery...
            2019-11-24 15:36:56 0 [Note] Crash recovery finished.
            2019-11-24 15:36:56 0 [Note] Server socket created on IP: '::'.
            2019-11-24 15:36:56 0 [Note] Reading of all Master_info entries succeeded
            2019-11-24 15:36:56 0 [Note] Added new Master_info '' to hash table
            2019-11-24 15:36:56 0 [Note] /usr/sbin/mysqld: ready for connections.
            Version: '10.4.10-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
            2019-11-24 15:36:56 0 [Note] InnoDB: Buffer pool(s) load completed at 191124 15:36:56
            

            juan.vera Juan added a comment - - edited I am able to reproduce it 100% of the time with a specific customer data-set. Additional error log / stack trace: 2019-11-24 15:34:18 0x7feaa8112700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.10/storage/innobase/row/row0mysql.cc line 180 InnoDB: Failing assertion: len < 256 * 256 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 191124 15:34:18 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.   To report this bug, see https://mariadb.com/kb/en/reporting-bugs   We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.   Server version: 10.4.10-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467738 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.   Thread pointer: 0x7feaa4000a88 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7feaa8111cf0 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c1487d1f2e] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55c1482683af] sigaction.c:0(__restore_rt)[0x7feaae5a85f0] :0(__GI_raise)[0x7feaac879337] :0(__GI_abort)[0x7feaac87aa28] /usr/sbin/mysqld(+0x5a1f92)[0x55c147f62f92] /usr/sbin/mysqld(+0xb169d7)[0x55c1484d79d7] /usr/sbin/mysqld(+0xb33430)[0x55c1484f4430] /usr/sbin/mysqld(+0x5a05d9)[0x55c147f615d9] /usr/sbin/mysqld(+0x5a0885)[0x55c147f61885] /usr/sbin/mysqld(+0xb361dd)[0x55c1484f71dd] /usr/sbin/mysqld(+0xa5404d)[0x55c14841504d] /usr/sbin/mysqld(+0x6df095)[0x55c1480a0095] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1a9)[0x55c148094cd9] /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb9c)[0x55c1480b72ac] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55c1480b7503] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x186)[0x55c1480b5806] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d7)[0x55c1480b6377] /usr/sbin/mysqld(+0x58fd84)[0x55c147f50d84] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x449a)[0x55c14805db6a] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x24b)[0x55c148062aeb] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1b5e)[0x55c1480658ee] /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x55c14806707c] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1fa)[0x55c148142afa] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55c148142bdd] pthread_create.c:0(start_thread)[0x7feaae5a0e65] /lib64/libc.so.6(clone+0x6d)[0x7feaac94188d]   Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7feaa4011f80): select count(*) from clients where MATCH(clients.first_name, clients.last_name) AGAINST("+MOJCA")AND clients.vin = "U5YPG812AKL682312" Connection ID (thread ID): 9 Status: NOT_KILLED   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=on,condition_pushdown_from_having=on   The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /var/lib/mysql Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size unlimited unlimited bytes Max resident set unlimited unlimited bytes Max processes 3875 3875 processes Max open files 16364 16364 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 3875 3875 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /tmp/corefiles/core   2019-11-24 15:36:55 0 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=MariaDB-10-4-10-141' or '--log-bin=MariaDB-10-4-10-141-bin' to avoid this problem. 2019-11-24 15:36:55 0 [Note] InnoDB: Using Linux native AIO 2019-11-24 15:36:55 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-24 15:36:55 0 [Note] InnoDB: Uses event mutexes 2019-11-24 15:36:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-24 15:36:55 0 [Note] InnoDB: Number of pools: 1 2019-11-24 15:36:55 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-24 15:36:55 0 [Note] InnoDB: Initializing buffer pool, total size = 640M, instances = 1, chunk size = 128M 2019-11-24 15:36:55 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-24 15:36:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-24 15:36:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2159350145 2019-11-24 15:36:56 0 [Note] InnoDB: Last binlog file './MariaDB-10-4-10-141-bin.000003', position 1015149797 2019-11-24 15:36:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-24 15:36:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-24 15:36:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-24 15:36:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-24 15:36:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-24 15:36:56 0 [Note] InnoDB: Waiting for purge to start 2019-11-24 15:36:56 0 [Note] InnoDB: 10.4.10 started; log sequence number 2159350154; transaction id 8784061 2019-11-24 15:36:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-24 15:36:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-24 15:36:56 0 [Note] Recovering after a crash using MariaDB-10-4-10-141-bin 2019-11-24 15:36:56 0 [Note] Starting crash recovery... 2019-11-24 15:36:56 0 [Note] Crash recovery finished. 2019-11-24 15:36:56 0 [Note] Server socket created on IP: '::'. 2019-11-24 15:36:56 0 [Note] Reading of all Master_info entries succeeded 2019-11-24 15:36:56 0 [Note] Added new Master_info '' to hash table 2019-11-24 15:36:56 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.10-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2019-11-24 15:36:56 0 [Note] InnoDB: Buffer pool(s) load completed at 191124 15:36:56

            gregnetau, juan.vera, if EXPLAIN SELECT … displays fulltext|filter, then this ought to be a regression that was introduced by MDEV-16188. The rowid filter is supposed to be used for PRIMARY KEY access only, not for any other indexes. In that case, this report would be yet another duplicate of MDEV-20407,MDEV-21047,MDEV-21125,MDEV-21040.

            marko Marko Mäkelä added a comment - gregnetau , juan.vera , if EXPLAIN SELECT … displays fulltext|filter , then this ought to be a regression that was introduced by MDEV-16188 . The rowid filter is supposed to be used for PRIMARY KEY access only, not for any other indexes. In that case, this report would be yet another duplicate of MDEV-20407 , MDEV-21047 , MDEV-21125 , MDEV-21040 .
            gregnetau Greg M added a comment -

            Confirming 10.4.11 has resolved this bug.

            gregnetau Greg M added a comment - Confirming 10.4.11 has resolved this bug.

            People

              marko Marko Mäkelä
              gregnetau Greg M
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.