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

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL)
Fix Version/s: 10.0.23
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
None

Sprint:
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

MDEV-9260 Improve progress report on on-line alter table

Open

relates to

MDEV-9129 Server is restarting in the loop after crash

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2015-11-18 01:21

Elena Stepanova made changes - 2015-11-18 01:21

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-9129~~ [ ~~MDEV-9129~~ ]

Elena Stepanova made changes - 2015-11-18 01:29

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}

Elena Stepanova made changes - 2015-11-18 01:30

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.

Elena Stepanova made changes - 2015-11-18 01:30

Status

Open [ 1 ]

Confirmed [ 10101 ]

Rasmus Johansson (Inactive) made changes - 2015-12-09 13:15

Sprint

10.0.23-1 [ 23 ]

Rasmus Johansson (Inactive) made changes - 2015-12-09 13:15

Rank

Ranked higher

Jan Lindström (Inactive) made changes - 2015-12-10 11:37

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2015-12-10 16:37

Link

This issue is part of MDEV-9260 [ MDEV-9260 ]

Jan Lindström (Inactive) added a comment - 2015-12-10 16:55

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.

Jan Lindström (Inactive) added a comment - 2015-12-10 16:55 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.

Jan Lindström (Inactive) made changes - 2015-12-10 16:55

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 ]

Sergei Golubchik made changes - 2021-12-06 21:42

Workflow

MariaDB v3 [ 72627 ]

MariaDB v4 [ 149837 ]

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2015-11-18 01:21

Updated:: 2015-12-10 16:55

Resolved:: 2015-12-10 16:55

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration