[MDEV-15471] Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table - Jira

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.3.3, 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.4(EOL)
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB
Labels:

Description

https://api.travis-ci.org/v3/job/348679822/log.txt

10.3 d70573564cb2701076083ea7f55ae9539fad13b4
mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:9195: virtual bool ha_innobase::commit_inplace_alter_table(TABLE, Alter_inplace_info, bool): Assertion `new_clustered == ctx->need_rebuild()' failed.
180304 2:46:51 [ERROR] mysqld got signal 6 ;

Some pointers may be invalid and cause the dump to abort.
Query (0x7f24a001f4d8): ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 1163 CON_ID 17 */
Connection ID (thread ID): 17
Status: NOT_KILLED

#7  0x00007f2502363ca2 in __GI___assert_fail (assertion=0x5600de9ba0d0 "new_clustered == ctx->need_rebuild()", file=0x5600de9b80a0 "/home/travis/src/storage/innobase/handler/handler0alter.cc", line=9195, function=0x5600de9bff60 <ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool)::__PRETTY_FUNCTION__> "virtual bool ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool)") at assert.c:101

#8  0x00005600de1d62fd in ha_innobase::commit_inplace_alter_table (this=0x7f24a80d15b8, altered_table=0x7f24a00e7340, ha_alter_info=0x7f24ec93d200, commit=true) at /home/travis/src/storage/innobase/handler/handler0alter.cc:9195

#9  0x00005600ddf81e12 in handler::ha_commit_inplace_alter_table (this=0x7f24a80d15b8, altered_table=0x7f24a00e7340, ha_alter_info=0x7f24ec93d200, commit=true) at /home/travis/src/sql/handler.cc:4403

#10 0x00005600de6ff1b7 in ha_partition::commit_inplace_alter_table (this=0x7f24a80d0d08, altered_table=0x7f24a00e7340, ha_alter_info=0x7f24ec93d200, commit=true) at /home/travis/src/sql/ha_partition.cc:10025

#11 0x00005600ddf81e12 in handler::ha_commit_inplace_alter_table (this=0x7f24a80d0d08, altered_table=0x7f24a00e7340, ha_alter_info=0x7f24ec93d200, commit=true) at /home/travis/src/sql/handler.cc:4403

#12 0x00005600ddd616de in mysql_inplace_alter_table (thd=0x7f24a000c610, table_list=0x7f24a001f610, table=0x7f24a80d00c0, altered_table=0x7f24a00e7340, ha_alter_info=0x7f24ec93d200, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7f24ec93d370, alter_ctx=0x7f24ec93e020) at /home/travis/src/sql/sql_table.cc:7683

#13 0x00005600ddd679a0 in mysql_alter_table (thd=0x7f24a000c610, new_db=0x7f24a0010c58, new_name=0x7f24a0011008, create_info=0x7f24ec93ec00, table_list=0x7f24a001f610, alter_info=0x7f24ec93eb50, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9847

#14 0x00005600dddee17a in Sql_cmd_alter_table::execute (this=0x7f24a001fd30, thd=0x7f24a000c610) at /home/travis/src/sql/sql_alter.cc:334

#15 0x00005600ddc92ca3 in mysql_execute_command (thd=0x7f24a000c610) at /home/travis/src/sql/sql_parse.cc:6280

#16 0x00005600ddc9782a in mysql_parse (thd=0x7f24a000c610, rawbuf=0x7f24a001f4d8 "ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 1163 CON_ID 17 */", length=71, parser_state=0x7f24ec9405e0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009

#17 0x00005600ddc84f23 in dispatch_command (command=COM_QUERY, thd=0x7f24a000c610, packet=0x7f24a0016d11 "ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 1163 CON_ID 17 */ ", packet_length=72, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1838

#18 0x00005600ddc8396f in do_command (thd=0x7f24a000c610) at /home/travis/src/sql/sql_parse.cc:1383

#19 0x00005600ddde8bef in do_handle_one_connection (connect=0x5600e020a050) at /home/travis/src/sql/sql_connect.cc:1402

#20 0x00005600ddde897c in handle_one_connection (arg=0x5600e020a050) at /home/travis/src/sql/sql_connect.cc:1308

#21 0x00007f2502f25184 in start_thread (arg=0x7f24ec941700) at pthread_create.c:312

#22 0x00007f250243203d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

experimental e42a181399012909fbda32f7e9b7be8b416175c9

perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1520131581 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4

Not reproducible right away

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

dt.7z
4.02 MB
2018-09-04 16:30
MDEV-15471.test
0.5 kB
2019-03-22 17:28
threads
63 kB
2018-03-05 17:13

Issue Links

relates to

MDEV-16329 Engine-independent online ALTER TABLE

Closed

MDEV-22168 Supporting multiple engines with table partitioning

Stalled

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2018-03-05 16:51

Elena Stepanova made changes - 2018-03-05 17:13

Field	Original Value	New Value
Attachment		threads [ 45285 ]

Marko Mäkelä made changes - 2018-04-07 17:21

Labels

online-ddl

Alice Sherepa made changes - 2018-09-04 16:30

Attachment

dt.7z [ 46118 ]

Alice Sherepa made changes - 2018-09-04 16:34

Comment

[ Reproducible on 10.3 39c6775a3514d0e7edff9e9,
there is datadir attached in dt.7z (table t1 in db test, crashing query is
ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4(5)) )

{noformat}
mysqld: src/storage/innobase/handler/handler0alter.cc:9436: virtual bool ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool): Assertion `new_clustered == ctx->need_rebuild()' failed.
180904 17:41:55 [ERROR] mysqld got signal 6 ;

Server version: 10.3.10-MariaDB-debug
linux/raise.c:54(__GI_raise)[0x7fe092d94428]
stdlib/abort.c:91(__GI_abort)[0x7fe092d9602a]
assert/assert.c:92(__assert_fail_base)[0x7fe092d8cbd7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fe092d8cc82]
handler/handler0alter.cc:9438(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55aa756fd217]
sql/handler.cc:4481(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55aa75425f9e]
sql/ha_partition.cc:10089(ha_partition::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55aa75aea4e7]
sql/handler.cc:4481(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55aa75425f9e]
sql/sql_table.cc:7618(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55aa752720ab]
sql/sql_table.cc:9712(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x55aa7527c6a9]
sql/sql_alter.cc:495(Sql_cmd_alter_table::execute(THD*))[0x55aa752e6a70]
sql/sql_parse.cc:6285(mysql_execute_command(THD*))[0x55aa751d0156]
sql/sql_parse.cc:8089(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55aa751d1db8]
sql/sql_parse.cc:1874(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55aa751d43e7]
sql/sql_parse.cc:1395(do_command(THD*))[0x55aa751d7485]
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55aa752e2d49]
sql/sql_connect.cc:1310(handle_one_connection)[0x55aa752e2efb]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe0937bb6ba]
x86_64/clone.S:111(clone)[0x7fe092e6641d]

Query (0x7fe0200137c8): ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4(5))
{noformat} ]

Alice Sherepa made changes - 2018-09-04 16:35

Fix Version/s

10.3 [ 22126 ]

Alice Sherepa made changes - 2018-09-04 16:35

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2018-09-04 16:36

Assignee

Elena Stepanova [ elenst ]

Marko Mäkelä [ marko ]

Alice Sherepa made changes - 2018-09-04 16:36

Summary

[Draft] Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table

Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table

Marko Mäkelä made changes - 2019-03-22 08:49

Link

This issue relates to ~~MDEV-16329~~ [ ~~MDEV-16329~~ ]

Marko Mäkelä made changes - 2019-03-22 08:50

Labels

online-ddl

need_testcase online-ddl

Elena Stepanova made changes - 2019-03-22 11:46

Assignee

Marko Mäkelä [ marko ]

Elena Stepanova [ elenst ]

Elena Stepanova made changes - 2019-03-22 11:46

Summary

Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table

[Draft] Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table

Matthias Leich made changes - 2019-03-22 17:28

Attachment

MDEV-15471.test [ 47871 ]

Matthias Leich made changes - 2019-03-22 17:30

Fix Version/s		10.4 [ 22408 ]
Affects Version/s		10.3.14 [ 23216 ]
Affects Version/s		10.4.4 [ 23310 ]
Assignee	Elena Stepanova [ elenst ]	Marko Mäkelä [ marko ]
Labels	need_testcase online-ddl	online-ddl
Summary	[Draft] Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table	Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table

Marko Mäkelä made changes - 2019-09-30 16:11

Assignee

Marko Mäkelä [ marko ]

Thirunarayanan Balathandayuthapani [ thiru ]

Thirunarayanan Balathandayuthapani made changes - 2019-10-01 10:44

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Thirunarayanan Balathandayuthapani made changes - 2019-10-01 10:45

Affects Version/s		10.3.3 [ 22644 ]
Affects Version/s	10.3.14 [ 23216 ]

Thirunarayanan Balathandayuthapani made changes - 2019-10-01 10:45

Affects Version/s		10.4 [ 22408 ]
Affects Version/s	10.4.4 [ 23310 ]

Thirunarayanan Balathandayuthapani made changes - 2019-10-01 10:55

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Marko Mäkelä made changes - 2019-10-01 11:02

Component/s		Data Definition - Alter Table [ 10114 ]
Assignee	Thirunarayanan Balathandayuthapani [ thiru ]	Oleksandr Byelkin [ sanja ]
Labels	online-ddl	crash fulltext online-ddl

Ralf Gebhardt made changes - 2020-02-20 07:50

Link

This issue relates to MDEV-21783 [ MDEV-21783 ]

Elena Stepanova made changes - 2020-04-04 21:30

Link

This issue relates to MENT-692 [ MENT-692 ]

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

Workflow

MariaDB v3 [ 85834 ]

MariaDB v4 [ 143533 ]

Julien Fritsch made changes - 2023-04-27 14:19

Fix Version/s

10.3 [ 22126 ]

Marko Mäkelä made changes - 2024-09-24 04:45

Link

This issue relates to MDEV-22168 [ MDEV-22168 ]

People

Assignee:: Oleksandr Byelkin

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2018-03-05 16:51

Updated:: 2024-09-24 04:45

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration