Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
-
None
Description
Upd: See Roel's comment for a test case.
10.4 4edb29380c9 |
mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:5690: bool innobase_instant_try(const Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, const TABLE*, trx_t*): Assertion `!"wrong page type"' failed.
|
190120 22:00:51 [ERROR] mysqld got signal 6 ;
|
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd67eaf1c82]
|
/home/travis/server/bin/mysqld(+0x1d5d7d4)[0x55c8a1f2e7d4]
|
handler/handler0alter.cc:5695(innobase_instant_try(Alter_inplace_info const*, ha_innobase_inplace_ctx*, TABLE const*, TABLE const*, trx_t*))[0x55c8a1f6e80b]
|
handler/handler0alter.cc:10160(commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, TABLE*, TABLE const*, trx_t*, char const*))[0x55c8a1f4e097]
|
handler/handler0alter.cc:10793(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a19c864e]
|
sql/handler.cc:4493(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a14b3fb4]
|
sql/sql_table.cc:7590(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55c8a14c085e]
|
sql/sql_table.cc:9688(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))[0x55c8a16015ea]
|
sql/sql_alter.cc:497(Sql_cmd_alter_table::execute(THD*))[0x55c8a12b8346]
|
sql/sql_parse.cc:6314(mysql_execute_command(THD*))[0x55c8a12c2b9a]
|
sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c8a129d915]
|
sql/sql_parse.cc:1854(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c8a129aaad]
|
sql/sql_parse.cc:1397(do_command(THD*))[0x55c8a15f272f]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c8a15f210c]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd67f7366ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd67ebcb41d]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x62b00015e288): ALTER ONLINE TABLE `t014` /*!100301 */ DROP COLUMN IF EXISTS `col_int_nokey`, ALGORITHM=INPLACE /* QNO 5151 CON_ID 19 */
|
Connection ID (thread ID): 19
|
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=off,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
|
elenst-jira-refs 19e81706f Toolbox: dbef832b2 |
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548021243 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/modules/alter_table_indexes.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/partitioning/partitions.yy --gendata=conf/mariadb/innodb.zz --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter-asan.ff --mysqld=--innodb-page-size=8K
|
Not reproducible so far, hitting MDEV-18321 instead.
Attachments
Issue Links
- relates to
-
MDEV-26141 Crash in instant ALTER TABLE after IMPORT TABLESPACE
-
- Confirmed
-
-
MDEV-29034 Assertion (o->ind == vers_start) upon inplace ALTER with virtual columns
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
https://travis-ci.org/elenst/travis-tests/jobs/482032772
{noformat:title=10.4 4edb29380c9} mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:5690: bool innobase_instant_try(const Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, const TABLE*, trx_t*): Assertion `!"wrong page type"' failed. 190120 22:00:51 [ERROR] mysqld got signal 6 ; /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd67eaf1c82] /home/travis/server/bin/mysqld(+0x1d5d7d4)[0x55c8a1f2e7d4] handler/handler0alter.cc:5695(innobase_instant_try(Alter_inplace_info const*, ha_innobase_inplace_ctx*, TABLE const*, TABLE const*, trx_t*))[0x55c8a1f6e80b] handler/handler0alter.cc:10160(commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, TABLE*, TABLE const*, trx_t*, char const*))[0x55c8a1f4e097] handler/handler0alter.cc:10793(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a19c864e] sql/handler.cc:4493(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a14b3fb4] sql/sql_table.cc:7590(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55c8a14c085e] sql/sql_table.cc:9688(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))[0x55c8a16015ea] sql/sql_alter.cc:497(Sql_cmd_alter_table::execute(THD*))[0x55c8a12b8346] sql/sql_parse.cc:6314(mysql_execute_command(THD*))[0x55c8a12c2b9a] sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c8a129d915] sql/sql_parse.cc:1854(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c8a129aaad] sql/sql_parse.cc:1397(do_command(THD*))[0x55c8a15f272f] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c8a15f210c] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd67f7366ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd67ebcb41d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x62b00015e288): ALTER ONLINE TABLE `t014` /*!100301 */ DROP COLUMN IF EXISTS `col_int_nokey`, ALGORITHM=INPLACE /* QNO 5151 CON_ID 19 */ Connection ID (thread ID): 19 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=off,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 {noformat} {noformat:title=elenst-dev 19e81706f Toolbox: dbef832b2} perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548021243 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/modules/alter_table_indexes.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/partitioning/partitions.yy --gendata=conf/mariadb/innodb.zz --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter-asan.ff --mysqld=--innodb-page-size=8K {noformat} Not reproducible so far, hitting |
https://travis-ci.org/elenst/travis-tests/jobs/482032772
{noformat:title=10.4 4edb29380c9} mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:5690: bool innobase_instant_try(const Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, const TABLE*, trx_t*): Assertion `!"wrong page type"' failed. 190120 22:00:51 [ERROR] mysqld got signal 6 ; /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd67eaf1c82] /home/travis/server/bin/mysqld(+0x1d5d7d4)[0x55c8a1f2e7d4] handler/handler0alter.cc:5695(innobase_instant_try(Alter_inplace_info const*, ha_innobase_inplace_ctx*, TABLE const*, TABLE const*, trx_t*))[0x55c8a1f6e80b] handler/handler0alter.cc:10160(commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, TABLE*, TABLE const*, trx_t*, char const*))[0x55c8a1f4e097] handler/handler0alter.cc:10793(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a19c864e] sql/handler.cc:4493(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a14b3fb4] sql/sql_table.cc:7590(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55c8a14c085e] sql/sql_table.cc:9688(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))[0x55c8a16015ea] sql/sql_alter.cc:497(Sql_cmd_alter_table::execute(THD*))[0x55c8a12b8346] sql/sql_parse.cc:6314(mysql_execute_command(THD*))[0x55c8a12c2b9a] sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c8a129d915] sql/sql_parse.cc:1854(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c8a129aaad] sql/sql_parse.cc:1397(do_command(THD*))[0x55c8a15f272f] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c8a15f210c] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd67f7366ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd67ebcb41d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x62b00015e288): ALTER ONLINE TABLE `t014` /*!100301 */ DROP COLUMN IF EXISTS `col_int_nokey`, ALGORITHM=INPLACE /* QNO 5151 CON_ID 19 */ Connection ID (thread ID): 19 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=off,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 {noformat} {noformat:title=elenst-jira-refs 19e81706f Toolbox: dbef832b2} perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548021243 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/modules/alter_table_indexes.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/partitioning/partitions.yy --gendata=conf/mariadb/innodb.zz --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter-asan.ff --mysqld=--innodb-page-size=8K {noformat} Not reproducible so far, hitting |
Workflow | MariaDB v3 [ 91942 ] | MariaDB v4 [ 141110 ] |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.8 [ 26121 ] | |
Fix Version/s | 10.9 [ 26905 ] | |
Fix Version/s | 10.10 [ 27530 ] | |
Fix Version/s | 10.11 [ 27614 ] | |
Fix Version/s | 11.0 [ 28320 ] | |
Affects Version/s | 10.5 [ 23123 ] | |
Affects Version/s | 10.6 [ 24028 ] | |
Affects Version/s | 10.7 [ 24805 ] | |
Affects Version/s | 10.8 [ 26121 ] | |
Affects Version/s | 10.9 [ 26905 ] | |
Affects Version/s | 10.10 [ 27530 ] | |
Affects Version/s | 10.11 [ 27614 ] | |
Affects Version/s | 11.0 [ 28320 ] | |
Affects Version/s | 11.1 [ 28549 ] | |
Assignee | Elena Stepanova [ elenst ] | Marko Mäkelä [ marko ] |
Summary | [Draft] Assertion `!"wrong page type"' failed in innobase_instant_try | Assertion `!"wrong page type"' or Assertion `"wrong page type" == 0' failed in innobase_instant_try on ALTER |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Link |
This issue relates to |
Link | This issue relates to MDEV-26141 [ MDEV-26141 ] |
Fix Version/s | 10.8 [ 26121 ] |
Description |
https://travis-ci.org/elenst/travis-tests/jobs/482032772
{noformat:title=10.4 4edb29380c9} mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:5690: bool innobase_instant_try(const Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, const TABLE*, trx_t*): Assertion `!"wrong page type"' failed. 190120 22:00:51 [ERROR] mysqld got signal 6 ; /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd67eaf1c82] /home/travis/server/bin/mysqld(+0x1d5d7d4)[0x55c8a1f2e7d4] handler/handler0alter.cc:5695(innobase_instant_try(Alter_inplace_info const*, ha_innobase_inplace_ctx*, TABLE const*, TABLE const*, trx_t*))[0x55c8a1f6e80b] handler/handler0alter.cc:10160(commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, TABLE*, TABLE const*, trx_t*, char const*))[0x55c8a1f4e097] handler/handler0alter.cc:10793(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a19c864e] sql/handler.cc:4493(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a14b3fb4] sql/sql_table.cc:7590(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55c8a14c085e] sql/sql_table.cc:9688(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))[0x55c8a16015ea] sql/sql_alter.cc:497(Sql_cmd_alter_table::execute(THD*))[0x55c8a12b8346] sql/sql_parse.cc:6314(mysql_execute_command(THD*))[0x55c8a12c2b9a] sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c8a129d915] sql/sql_parse.cc:1854(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c8a129aaad] sql/sql_parse.cc:1397(do_command(THD*))[0x55c8a15f272f] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c8a15f210c] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd67f7366ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd67ebcb41d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x62b00015e288): ALTER ONLINE TABLE `t014` /*!100301 */ DROP COLUMN IF EXISTS `col_int_nokey`, ALGORITHM=INPLACE /* QNO 5151 CON_ID 19 */ Connection ID (thread ID): 19 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=off,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 {noformat} {noformat:title=elenst-jira-refs 19e81706f Toolbox: dbef832b2} perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548021243 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/modules/alter_table_indexes.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/partitioning/partitions.yy --gendata=conf/mariadb/innodb.zz --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter-asan.ff --mysqld=--innodb-page-size=8K {noformat} Not reproducible so far, hitting |
Upd: See [Roel's comment|https://jira.mariadb.org/browse/MDEV-18322?focusedCommentId=255578&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-255578] for a test case.
{noformat:title=10.4 4edb29380c9} mysqld: /home/travis/src/storage/innobase/handler/handler0alter.cc:5690: bool innobase_instant_try(const Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, const TABLE*, trx_t*): Assertion `!"wrong page type"' failed. 190120 22:00:51 [ERROR] mysqld got signal 6 ; /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd67eaf1c82] /home/travis/server/bin/mysqld(+0x1d5d7d4)[0x55c8a1f2e7d4] handler/handler0alter.cc:5695(innobase_instant_try(Alter_inplace_info const*, ha_innobase_inplace_ctx*, TABLE const*, TABLE const*, trx_t*))[0x55c8a1f6e80b] handler/handler0alter.cc:10160(commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, TABLE*, TABLE const*, trx_t*, char const*))[0x55c8a1f4e097] handler/handler0alter.cc:10793(ha_innobase::commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a19c864e] sql/handler.cc:4493(handler::ha_commit_inplace_alter_table(TABLE*, Alter_inplace_info*, bool))[0x55c8a14b3fb4] sql/sql_table.cc:7590(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55c8a14c085e] sql/sql_table.cc:9688(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))[0x55c8a16015ea] sql/sql_alter.cc:497(Sql_cmd_alter_table::execute(THD*))[0x55c8a12b8346] sql/sql_parse.cc:6314(mysql_execute_command(THD*))[0x55c8a12c2b9a] sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c8a129d915] sql/sql_parse.cc:1854(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c8a129aaad] sql/sql_parse.cc:1397(do_command(THD*))[0x55c8a15f272f] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c8a15f210c] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd67f7366ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd67ebcb41d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x62b00015e288): ALTER ONLINE TABLE `t014` /*!100301 */ DROP COLUMN IF EXISTS `col_int_nokey`, ALGORITHM=INPLACE /* QNO 5151 CON_ID 19 */ Connection ID (thread ID): 19 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=off,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 {noformat} {noformat:title=elenst-jira-refs 19e81706f Toolbox: dbef832b2} perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548021243 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/modules/alter_table_indexes.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/partitioning/partitions.yy --gendata=conf/mariadb/innodb.zz --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter-asan.ff --mysqld=--innodb-page-size=8K {noformat} Not reproducible so far, hitting |
Fix Version/s | 10.9 [ 26905 ] |
Fix Version/s | 10.10 [ 27530 ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
issue.field.resolutiondate | 2023-12-14 14:17:46.0 | 2023-12-14 14:17:46.103 |
Fix Version/s | 10.4.33 [ 29516 ] | |
Fix Version/s | 10.5.24 [ 29517 ] | |
Fix Version/s | 10.6.17 [ 29518 ] | |
Fix Version/s | 10.11.7 [ 29519 ] | |
Fix Version/s | 11.0.5 [ 29520 ] | |
Fix Version/s | 11.1.4 [ 29024 ] | |
Fix Version/s | 11.2.3 [ 29521 ] | |
Fix Version/s | 11.3.2 [ 29522 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.11 [ 27614 ] | |
Fix Version/s | 11.0 [ 28320 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |