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

Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_init

Details

    • 10.0.23

    Description

      10.0/sql/sql_class.cc:4088: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
      		 
      151117 21:41:17 [ERROR] mysqld got signal 6 ;

      Stack trace from 10.0 commit 4008a3e55bda76fab622de163b174008d2d58abb

      		 
      #6  0x00007efe3bf22311 in *__GI___assert_fail (assertion=0xf08270 "thd->stmt_arena != thd->progress.arena", file=<optimized out>, line=4088, function=0xf09ee0 "void thd_progress_init(THD*, uint)") at assert.c:81
      		 
      #7  0x0000000000649b98 in thd_progress_init (thd=0x7efe236f9070, max_stage=3) at 10.0/sql/sql_class.cc:4088
      		 
      #8  0x0000000000b00cdc in row_merge_sort (trx=0x7efe234ccb78, dup=0x7efe120b00c0, file=0x7efe234df8f8, block=0x7efe11006000 "\002\033aamzgmngfrmdthtdmdhlxkovjdz", tmpfd=0x7efe0cffedc4) at 10.0/storage/xtradb/row/row0merge.cc:2339
      		 
      #9  0x0000000000adb4ba in fts_parallel_tokenization (arg=0x7efe3b494878) at 10.0/storage/xtradb/row/row0ftsort.cc:854
      		 
      #10 0x00007efe3dd1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      		 
      #11 0x00007efe3bfd295d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      10.1 also fails, but differently, see MDEV-9129 (10.1 fails both on debug and release builds, while 10.0 only fails on release).

      To reproduce, download and unpack ftp://ftp.askmonty.org/public/MDEV-9129_data.gz

      create table t1 (groups varchar(255) DEFAULT NULL) ENGINE=InnoDB;
      		 
      load data local infile 't1.data' into table t1;
      		 
      ALTER TABLE t1 ADD FULLTEXT ft_qu_la_contacts_groups (groups);

      Default server settings are enough.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-9260 Improve progress report on on-line alter table

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9129 Server is restarting in the loop after crash

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Description {noformat}
            10.0/sql/sql_class.cc:4088: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
            151117 21:41:17 [ERROR] mysqld got signal 6 ;
            {noformat}
            {noformat:title=Stack trace from 10.0 commit 4008a3e55bda76fab622de163b174008d2d58abb}
            #6 0x00007efe3bf22311 in *__GI___assert_fail (assertion=0xf08270 "thd->stmt_arena != thd->progress.arena", file=<optimized out>, line=4088, function=0xf09ee0 "void thd_progress_init(THD*, uint)") at assert.c:81
            #7 0x0000000000649b98 in thd_progress_init (thd=0x7efe236f9070, max_stage=3) at 10.0/sql/sql_class.cc:4088
            #8 0x0000000000b00cdc in row_merge_sort (trx=0x7efe234ccb78, dup=0x7efe120b00c0, file=0x7efe234df8f8, block=0x7efe11006000 "\002\033aamzgmngfrmdthtdmdhlxkovjdz", tmpfd=0x7efe0cffedc4) at 10.0/storage/xtradb/row/row0merge.cc:2339
            #9 0x0000000000adb4ba in fts_parallel_tokenization (arg=0x7efe3b494878) at 10.0/storage/xtradb/row/row0ftsort.cc:854
            #10 0x00007efe3dd1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #11 0x00007efe3bfd295d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            {noformat}

            10.1 also fails, but differently, see MDEV-9129 (10.1 fails both on debug and release builds, while 10.0 only fails on release).

            To reproduce, download and unpack ftp://ftp.askmonty.org/public/MDEV-9129_data.gz

            {code:sql}
            create table t1 (groups varchar(255) DEFAULT NULL) ENGINE=InnoDB;
            load data local infile '/home/elenst/tmp/t1.data' into table t1;
            ALTER TABLE t1 ADD FULLTEXT ft_qu_la_contacts_groups (groups);
            {code}
            		 {noformat}
            10.0/sql/sql_class.cc:4088: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
            151117 21:41:17 [ERROR] mysqld got signal 6 ;
            {noformat}
            {noformat:title=Stack trace from 10.0 commit 4008a3e55bda76fab622de163b174008d2d58abb}
            #6 0x00007efe3bf22311 in *__GI___assert_fail (assertion=0xf08270 "thd->stmt_arena != thd->progress.arena", file=<optimized out>, line=4088, function=0xf09ee0 "void thd_progress_init(THD*, uint)") at assert.c:81
            #7 0x0000000000649b98 in thd_progress_init (thd=0x7efe236f9070, max_stage=3) at 10.0/sql/sql_class.cc:4088
            #8 0x0000000000b00cdc in row_merge_sort (trx=0x7efe234ccb78, dup=0x7efe120b00c0, file=0x7efe234df8f8, block=0x7efe11006000 "\002\033aamzgmngfrmdthtdmdhlxkovjdz", tmpfd=0x7efe0cffedc4) at 10.0/storage/xtradb/row/row0merge.cc:2339
            #9 0x0000000000adb4ba in fts_parallel_tokenization (arg=0x7efe3b494878) at 10.0/storage/xtradb/row/row0ftsort.cc:854
            #10 0x00007efe3dd1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #11 0x00007efe3bfd295d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            {noformat}

            10.1 also fails, but differently, see MDEV-9129 (10.1 fails both on debug and release builds, while 10.0 only fails on release).

            To reproduce, download and unpack ftp://ftp.askmonty.org/public/MDEV-9129_data.gz

            {code:sql}
            create table t1 (groups varchar(255) DEFAULT NULL) ENGINE=InnoDB;
            load data local infile 't1.data' into table t1;
            ALTER TABLE t1 ADD FULLTEXT ft_qu_la_contacts_groups (groups);
            {code}
            elenst Elena Stepanova made changes -
            Description {noformat}
            10.0/sql/sql_class.cc:4088: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
            151117 21:41:17 [ERROR] mysqld got signal 6 ;
            {noformat}
            {noformat:title=Stack trace from 10.0 commit 4008a3e55bda76fab622de163b174008d2d58abb}
            #6 0x00007efe3bf22311 in *__GI___assert_fail (assertion=0xf08270 "thd->stmt_arena != thd->progress.arena", file=<optimized out>, line=4088, function=0xf09ee0 "void thd_progress_init(THD*, uint)") at assert.c:81
            #7 0x0000000000649b98 in thd_progress_init (thd=0x7efe236f9070, max_stage=3) at 10.0/sql/sql_class.cc:4088
            #8 0x0000000000b00cdc in row_merge_sort (trx=0x7efe234ccb78, dup=0x7efe120b00c0, file=0x7efe234df8f8, block=0x7efe11006000 "\002\033aamzgmngfrmdthtdmdhlxkovjdz", tmpfd=0x7efe0cffedc4) at 10.0/storage/xtradb/row/row0merge.cc:2339
            #9 0x0000000000adb4ba in fts_parallel_tokenization (arg=0x7efe3b494878) at 10.0/storage/xtradb/row/row0ftsort.cc:854
            #10 0x00007efe3dd1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #11 0x00007efe3bfd295d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            {noformat}

            10.1 also fails, but differently, see MDEV-9129 (10.1 fails both on debug and release builds, while 10.0 only fails on release).

            To reproduce, download and unpack ftp://ftp.askmonty.org/public/MDEV-9129_data.gz

            {code:sql}
            create table t1 (groups varchar(255) DEFAULT NULL) ENGINE=InnoDB;
            load data local infile 't1.data' into table t1;
            ALTER TABLE t1 ADD FULLTEXT ft_qu_la_contacts_groups (groups);
            {code}
            		 {noformat}
            10.0/sql/sql_class.cc:4088: void thd_progress_init(THD*, uint): Assertion `thd->stmt_arena != thd->progress.arena' failed.
            151117 21:41:17 [ERROR] mysqld got signal 6 ;
            {noformat}
            {noformat:title=Stack trace from 10.0 commit 4008a3e55bda76fab622de163b174008d2d58abb}
            #6 0x00007efe3bf22311 in *__GI___assert_fail (assertion=0xf08270 "thd->stmt_arena != thd->progress.arena", file=<optimized out>, line=4088, function=0xf09ee0 "void thd_progress_init(THD*, uint)") at assert.c:81
            #7 0x0000000000649b98 in thd_progress_init (thd=0x7efe236f9070, max_stage=3) at 10.0/sql/sql_class.cc:4088
            #8 0x0000000000b00cdc in row_merge_sort (trx=0x7efe234ccb78, dup=0x7efe120b00c0, file=0x7efe234df8f8, block=0x7efe11006000 "\002\033aamzgmngfrmdthtdmdhlxkovjdz", tmpfd=0x7efe0cffedc4) at 10.0/storage/xtradb/row/row0merge.cc:2339
            #9 0x0000000000adb4ba in fts_parallel_tokenization (arg=0x7efe3b494878) at 10.0/storage/xtradb/row/row0ftsort.cc:854
            #10 0x00007efe3dd1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #11 0x00007efe3bfd295d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            {noformat}

            10.1 also fails, but differently, see MDEV-9129 (10.1 fails both on debug and release builds, while 10.0 only fails on release).

            To reproduce, download and unpack ftp://ftp.askmonty.org/public/MDEV-9129_data.gz

            {code:sql}
            create table t1 (groups varchar(255) DEFAULT NULL) ENGINE=InnoDB;
            load data local infile 't1.data' into table t1;
            ALTER TABLE t1 ADD FULLTEXT ft_qu_la_contacts_groups (groups);
            {code}

            Default server settings are enough.
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.23-1 [ 23 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            jplindst Jan Lindström (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            jplindst Jan Lindström (Inactive) added a comment -

            commit 311f0308d04f3a55ad18470ca39e9d44479c4782
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Thu Dec 10 16:41:46 2015 +0200

            MDEV-9148: Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_init

            Called thd_progress_init() from several threads used for FT-index
            creation. For FT-indexes, need better way to report progress,
            remove current one for them.

            jplindst Jan Lindström (Inactive) added a comment - commit 311f0308d04f3a55ad18470ca39e9d44479c4782 Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Thu Dec 10 16:41:46 2015 +0200 MDEV-9148 : Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_init Called thd_progress_init() from several threads used for FT-index creation. For FT-indexes, need better way to report progress, remove current one for them.
            jplindst Jan Lindström (Inactive) made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.0.23 [ 20401 ]
            Fix Version/s 10.0 [ 16000 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 72627 ] MariaDB v4 [ 149837 ]

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              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.