[MDEV-34156] InnoDB fails to apply the redo log to page_compressed tablespace - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL)
Fix Version/s: 10.11.9, 11.1.6, 11.2.5, 11.4.3
Component/s: Storage Engine - InnoDB
Labels:
None

Description

Alter table rebuild fails when it fails to read the externally stored colum
for the compressed tablespace. Before alter operation, InnoDB just started
after crash recovery. This could lead some issue in crash recovery.

While analysing the recovery, InnoDB fails to apply the redo log for compressed tablespace.
The reason is that InnoDB assumes that pages has been freed while applying
the redo log for it. Problematic page has been freed and reinitialize multiple
times. InnoDB needs to do multiple scan due to small buffer pool size.
InnoDB stores the freed page information only when we don't run out
of buffer pool. But InnoDB assigns the freed page ranges even though
we don't have complete freed range information.

This issue should persist from 10.5 onwards.

Crash happens due to skip of redo log apply:

#3  0x00007ffff7842476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#4  0x00007ffff78287f3 in __GI_abort () at ./stdlib/abort.c:79

#5  0x0000555556a600b9 in ut_dbg_assertion_failed (expr=0x5555572ef4a9 "buf != field_ref_zero",

    file=0x5555572eef38 "/home/thiru/mariadb_parent/server/11.0/storage/innobase/row/row0merge.cc", line=781)

    at /home/thiru/mariadb_parent/server/11.0/storage/innobase/ut/ut0dbg.cc:60

#6  0x000055555698586d in row_merge_buf_add (buf=0x7fffa001f638, fts_index=0x0, old_table=0x5555588e7df8, new_table=0x7fffa002f798,

    psort_info=0x0, row=0x7fffa00ae778, ext=0x7fffa00ae888, doc_id=0x7ffff40745a8, conv_heap=0x0, err=0x7ffff4074590,

    v_heap=0x7ffff40745a0, my_table=0x7ffff4075dc0, trx=0x7ffff4bc7b80, col_collate=0x0)

    at /home/thiru/mariadb_parent/server/11.0/storage/innobase/row/row0merge.cc:781

#7  0x000055555698d19f in row_merge_read_clustered_index (trx=0x7ffff4bc7b80, table=0x7ffff4075dc0, old_table=0x5555588e7df8,

    new_table=0x7fffa002f798, online=true, index=0x7fffa002f4d8, fts_sort_idx=0x0, psort_info=0x0, files=0x7fffa00315b8,

    key_numbers=0x7fffa002f4e0, n_index=1, defaults=0x0, add_v=0x0, col_map=0x7fffa002f640, add_autoinc=18446744073709551615, sequence=...,

    block=0x7fffe0149000 "", skip_pk_sort=true, tmpfd=0x7ffff4074ef0, stage=0x7fffa0025498, pct_cost=50, crypt_block=0x0,

    eval_table=0x7ffff4075dc0, allow_not_null=false, col_collate=0x0)

    at /home/thiru/mariadb_parent/server/11.0/storage/innobase/row/row0merge.cc:2567

#8  0x0000555556994cc8 in row_merge_build_indexes (trx=0x7ffff4bc7b80, old_table=0x5555588e7df8, new_table=0x7fffa002f798, online=true,

    indexes=0x7fffa002f4d8, key_numbers=0x7fffa002f4e0, n_indexes=1, table=0x7ffff4075dc0, defaults=0x0, col_map=0x7fffa002f640,

    add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7fffa0025498, add_v=0x0, eval_table=0x7ffff4075dc0,

    allow_not_null=false, col_collate=0x0) at /home/thiru/mariadb_parent/server/11.0/storage/innobase/row/row0merge.cc:4777

#9  0x000055555682a4c4 in ha_innobase::inplace_alter_table (this=0x7fffa001d4f0, altered_table=0x7ffff4075dc0, ha_alter_info=0x7ffff4075d00)

    at /home/thiru/mariadb_parent/server/11.0/storage/innobase/handler/handler0alter.cc:8827

#10 0x00005555560ee9c1 in handler::ha_inplace_alter_table (this=0x7fffa001d4f0, altered_table=0x7ffff4075dc0, ha_alter_info=0x7ffff4075d00)

    at /home/thiru/mariadb_parent/server/11.0/sql/handler.h:4879

#11 0x00005555560ddab1 in mysql_inplace_alter_table (thd=0x7fffa0000d58, table_list=0x7fffa0013570, table=0x7fffa001a148,

    altered_table=0x7ffff4075dc0, ha_alter_info=0x7ffff4075d00, target_mdl_request=0x7ffff4076620, ddl_log_state=0x7ffff4075ca0,

    trigger_param=0x7ffff40761c0, alter_ctx=0x7ffff4077250, partial_alter=@0x7ffff4075ba6: false, start_alter_id=@0x7ffff4075be0: 0,

    if_exists=false) at /home/thiru/mariadb_parent/server/11.0/sql/sql_table.cc:7871

#12 0x00005555560e7d58 in mysql_alter_table (thd=0x7fffa0000d58, new_db=0x7fffa0005ad0, new_name=0x7fffa0005f30,

    create_info=0x7ffff4078100, table_list=0x7fffa0013570, recreate_info=0x7ffff4077f50, alter_info=0x7ffff4077f90, order_num=0, order=0x0,

    ignore=false, if_exists=false) at /home/thiru/mariadb_parent/server/11.0/sql/sql_table.cc:11076

#13 0x00005555561a4f88 in Sql_cmd_alter_table::execute (this=0x7fffa0013c88, thd=0x7fffa0000d58)

    at /home/thiru/mariadb_parent/server/11.0/sql/sql_alter.cc:688

#14 0x0000555555fb8543 in mysql_execute_command (thd=0x7fffa0000d58, is_called_from_prepared_stmt=false)

    at /home/thiru/mariadb_parent/server/11.0/sql/sql_parse.cc:6125

--Type <RET> for more, q to quit, c to continue without paging--

#15 0x0000555555fbe5b8 in mysql_parse (thd=0x7fffa0000d58, rawbuf=0x7fffa0013490 "alter table test.t6 force", length=25,

    parser_state=0x7ffff40792b0) at /home/thiru/mariadb_parent/server/11.0/sql/sql_parse.cc:8123

#16 0x0000555555faa4cd in dispatch_command (command=COM_QUERY, thd=0x7fffa0000d58, packet=0x7fffa000b159 "alter table test.t6 force",

    packet_length=25, blocking=true) at /home/thiru/mariadb_parent/server/11.0/sql/sql_parse.cc:1894

#17 0x0000555555fa8e83 in do_command (thd=0x7fffa0000d58, blocking=true) at /home/thiru/mariadb_parent/server/11.0/sql/sql_parse.cc:1407

#18 0x0000555556198fb5 in do_handle_one_connection (connect=0x555558b78608, put_in_cache=true)

    at /home/thiru/mariadb_parent/server/11.0/sql/sql_connect.cc:1415

#19 0x0000555556198d16 in handle_one_connection (arg=0x555558b78608) at /home/thiru/mariadb_parent/server/11.0/sql/sql_connect.cc:1317

#20 0x00005555566eea67 in pfs_spawn_thread (arg=0x555558ad6f48) at /home/thiru/mariadb_parent/server/11.0/storage/perfschema/pfs.cc:2201

#21 0x00007ffff7894ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#22 0x00007ffff7926a40 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Attachments

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

encryption_keys.txt
2024-05-20 09:58
0.4 kB
Thirunarayanan Balathandayuthapani
data_1.tar.gz
2024-05-23 09:43
2.54 MB
Thirunarayanan Balathandayuthapani
CR-2098--MDEV-34156.cfg
2024-05-29 16:32
47 kB
Matthias Leich
CR-2098.yy
2024-05-29 16:32
0.6 kB
Matthias Leich

Issue Links

is duplicated by

MDEV-34225 InnoDB: Failing assertion: entry in row0umod.cc

Closed

relates to

MDEV-29911 InnoDB recovery and mariadb-backup --prepare fail to report detailed progress

Closed

MDEV-31803 InnoDB aborts during recovery when immediate_scrub_data_uncompressed is enabled

Closed

Activity

Transition	Time In Source Status	Execution Times

Thirunarayanan Balathandayuthapani made transition - 2024-05-15 10:06

Open

Confirmed

18h 51m

Thirunarayanan Balathandayuthapani made transition - 2024-05-15 10:07

Confirmed

In Review

39s

Marko Mäkelä made transition - 2024-05-24 08:06

In Review

Stalled

8d 21h 59m

Thirunarayanan Balathandayuthapani made transition - 2024-06-11 11:39

Stalled

Closed

18d 3h 33m

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Thirunarayanan Balathandayuthapani

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-05-14 15:14

Updated:: 2024-09-12 09:30

Resolved:: 2024-06-11 11:39

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