[MDEV-29589] MariaDB server crasesh when OPTIMIZING several tables (mysql_alter_table) Created: 2022-09-21  Updated: 2023-01-09  Resolved: 2022-11-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.9.3, 10.9.4, 10.10.2
Fix Version/s: 10.10.2, 10.11.1, 10.6.12, 10.7.8, 10.8.7, 10.9.5

Type: Bug Priority: Major
Reporter: Pablo Catalina Assignee: Thirunarayanan Balathandayuthapani
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu 20.04 + MariaDB as network server


Attachments: File dump.txt.xz     File error.log     Text File mariadbd_full_bt_all_threads-alldbg.txt     Text File mariadbd_full_bt_all_threads.txt    
Issue Links:
Duplicate
duplicates MDEV-28797 Assertion `page_rec_is_user_rec(rec)'... Closed

 Description   

Hi,

When I run mysqloptimize -A, MariaDB crashes. If I try to optimize the tables manually, one by one, it works fine. Only happens when I try to optimize several tables at the same time. I also tried with OPTIMIZE table1, table2, ... and it crashes.
The tables can be empty (without data, only structure) and crashes.

{{0x7fade406d700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.9.3/storage/innobase/page/page0zip.cc line 760
InnoDB: Failing assertion: i + PAGE_HEAP_NO_USER_LOW == n_heap
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mariadbd startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
220921 9:41:59 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.9.3-MariaDB-1:10.9.3+maria~ubu2004-log
key_buffer_size=268435456
read_buffer_size=131072
max_used_connections=2
max_threads=502
thread_count=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8564374 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7fac80000c58
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7fade406cd98 thread_stack 0x30000
??:0(my_print_stacktrace)[0x556e4767eb52]
??:0(handle_fatal_signal)[0x556e471522b5]
??:0(__restore_rt)[0x7fae2d865420]
??:0(gsignal)[0x7fae2d06f00b]
??:0(abort)[0x7fae2d04e859]
??:0(Wsrep_server_service::log_dummy_write_set(wsrep::client_state&, wsrep::ws_meta const&))[0x556e46d890f9]
??:0(Wsrep_server_service::log_dummy_write_set(wsrep::client_state&, wsrep::ws_meta const&))[0x556e46d74fa4]
??:0(std::pair<std::_Rb_tree_iterator<std::pair<unsigned long const, bool> >, bool> std::_Rb_tree<unsigned long, std::pair<unsigned long const, bool>, std::_Select1st<std::pair<unsigned long const, bool> >, std::less<unsigned long>, std::allocator<std::pair<unsigned long const, bool> > >::_M_emplace_unique<unsigned long&, bool>(unsigned long&, bool&&))[0x556e47555fe6]
??:0(std::pair<std::_Rb_tree_iterator<std::pair<unsigned long const, bool> >, bool> std::_Rb_tree<unsigned long, std::pair<unsigned long const, bool>, std::_Select1st<std::pair<unsigned long const, bool> >, std::less<unsigned long>, std::allocator<std::pair<unsigned long const, bool> > >::_M_emplace_unique<unsigned long&, bool>(unsigned long&, bool&&))[0x556e475563f4]
??:0(std::pair<std::_Rb_tree_iterator<std::pair<unsigned long const, bool> >, bool> std::_Rb_tree<unsigned long, std::pair<unsigned long const, bool>, std::_Select1st<std::pair<unsigned long const, bool> >, std::less<unsigned long>, std::allocator<std::pair<unsigned long const, bool> > >::_M_emplace_unique<unsigned long&, bool>(unsigned long&, bool&&))[0x556e47555923]
??:0(void std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char*>(char*, char*, std::forward_iterator_tag))[0x556e474d682d]
??:0(void std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char*>(char*, char*, std::forward_iterator_tag))[0x556e474df9ed]
??:0(void std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char*>(char*, char*, std::forward_iterator_tag))[0x556e474e06d4]
??:0(void std::this_thread::sleep_for<long, std::ratio<1l, 1l> >(std::chrono::duration<long, std::ratio<1l, 1l> > const&))[0x556e4744cdff]
??:0(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool, bool))[0x556e46fbf3f6]
??:0(mysql_recreate_table(THD*, TABLE_LIST*, bool))[0x556e46fc019f]
??:0(MDL_ticket::~MDL_ticket())[0x556e47031fcd]
??:0(fill_check_table_metadata_fields(THD*, List<Item>*))[0x556e47034844]
??:0(Sql_cmd_optimize_table::execute(THD*))[0x556e470361b5]
??:0(mysql_execute_command(THD*, bool))[0x556e46f059be]
??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556e46ef55d7]
??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556e46f01825]
??:0(do_command(THD*, bool))[0x556e46f03a7e]
??:0(do_handle_one_connection(CONNECT*, bool))[0x556e47026917]
??:0(handle_one_connection)[0x556e47026c6d]
??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x556e4737ac96]
??:0(start_thread)[0x7fae2d859609]
??:0(clone)[0x7fae2d14b133]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fac80058a90): OPTIMIZE TABLE `oc_cards`

Connection ID (thread ID): 94
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=on,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,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off

The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /var/lib/mysql
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 127942 127942 processes
Max open files 32768 32768 files
Max locked memory 8388608 8388608 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 127942 127942 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: core

Kernel version: Linux version 5.19.4-edge (github@pve-bullseye) (gcc (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP PREEMPT_DYNAMIC PVE Edge 5.19.4-1 (2022-08-25)}}



 Comments   
Comment by Marko Mäkelä [ 2022-09-21 ]

The posted stack trace is invalid. Can you please install the -dbgsym package and try to get a proper stack trace with GDB?

The failing assertion is this one, hinting corruption of a ROW_FORMAT=COMPRESSED InnoDB table.

	/* Ensure that each heap no occurs at least once. */
	ut_a(i + PAGE_HEAP_NO_USER_LOW == n_heap);

This assertion fails while a compressed page is being modified.

Please be aware that MariaDB Server 10.9.3 was affected by the recovery bug MDEV-29383. Even if restoring a backup or recovering a crash seemingly succeeded, some log records might not have been applied, and therefore you could have a corrupted database. You should upgrade to 10.9.4 to prevent further corruption of that kind.

Comment by Pablo Catalina [ 2022-09-21 ]

Hi,

I added the stack trace and the error log.

I will upgrade to 10.9.4 as soon as I can download the compiled binary for Ubuntu (ubuntu repos).

Comment by Marko Mäkelä [ 2022-11-07 ]

It is possible that this bug has been fixed by MDEV-29742. This was caused by MDEV-28457.

Comment by Thirunarayanan Balathandayuthapani [ 2022-11-07 ]

From stack trace, it looks like it is a duplicate of MDEV-28797

Thread 1 (Thread 0x7ff3d40be700 (LWP 13798)):
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
        pd = <optimized out>
        tid = 13798
        pid = 13681
        val = 0
#1  0x000055767540292f in my_write_core (sig=sig@entry=6) at ./mysys/stacktrace.c:424
No locals.
#2  0x0000557674ed62d0 in handle_fatal_signal (sig=6) at ./sql/signal_handler.cc:355
        curr_time = 1663773752
        tm = {tm_sec = 32, tm_min = 22, tm_hour = 15, tm_mday = 21, tm_mon = 8, tm_year = 122, tm_wday = 3, tm_yday = 263, tm_isdst = 0, tm_gmtoff = 0, tm_zone = 0x557677aa8d70 "UTC"}
        thd = 0x7ff24c000c58
        print_invalid_query_pointer = false
#3  <signal handler called>
No locals.
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
        set = {__val = {552967, 82, 10, 554050781309, 3208340570304, 93967258502819, 131200, 21008, 336152, 140678633881632, 336128, 140678641276896, 0, 336128, 336152, 0}}
        pid = <optimized out>
        tid = <optimized out>
        ret = <optimized out>
#5  0x00007ff41c2ff859 in __GI_abort () at abort.c:79
        save_stage = 1
        act = {__sigaction_handler = {sa_handler = 0x7ff41c4ca5c0 <_IO_2_1_stderr_>, sa_sigaction = 0x7ff41c4ca5c0 <_IO_2_1_stderr_>}, sa_mask = {__val = {93967264352392, 3432, 140686422099880, 398, 22, 32, 140686423532992, 398, 398, 1, 93967264352392, 140686423516320, 140686422049729, 140681653780480, 140686423533216, 140686423516320}}, sa_flags = 473297862, sa_restorer = 0x55767568a460}
        sigs = {__val = {32, 0 <repeats 15 times>}}
#6  0x0000557674b0d0f9 in ut_dbg_assertion_failed (expr=expr@entry=0x55767568a800 "i + PAGE_HEAP_NO_USER_LOW == n_heap", file=file@entry=0x55767568a460 "/home/buildbot/buildbot/build/mariadb-10.9.3/storage/innobase/page/page0zip.cc", line=line@entry=760) at ./storage/innobase/ut/ut0dbg.cc:60
No locals.
#7  0x0000557674af8fa4 in page_zip_dir_encode (recs=0x7ff24c70d860, buf=<optimized out>, page=0x7ff3a9760000 <error: Cannot access memory at address 0x7ff3a9760000>) at ./storage/innobase/page/page0zip.cc:760
        status = <optimized out>
        min_mark = <optimized out>
        i = <optimized out>
        offs = <optimized out>
        rec = <optimized out>
        heap_no = <optimized out>
        n_heap = <optimized out>
        rec = <optimized out>
        status = <optimized out>
        min_mark = <optimized out>
        heap_no = <optimized out>
        i = <optimized out>
        n_heap = <optimized out>
        offs = <optimized out>
        info_bits = <optimized out>
#8  page_zip_compress (block=0x7ff3a8f136a0, index=0x7ff24c30ff90, level=<optimized out>, mtr=mtr@entry=0x7ff24c3286c8) at ./storage/innobase/page/page0zip.cc:1431
        c_stream = {next_in = 0x7ff24c70d8a9 "", avail_in = 0, total_in = 9, next_out = 0x7ff24c70d8c9 "", avail_out = 7960, total_out = 17, msg = 0x0, state = 0x7ff24c70f860, zalloc = 0x55767522d380 <page_zip_zalloc(void*, uInt, uInt)>, zfree = 0x55767522ce70 <page_zip_free(void*, void*)>, opaque = 0x7ff24c70d7f8, data_type = 0, adler = 165675481, reserved = 16836317752301496064}
        err = <optimized out>
        fields = <optimized out>
        buf = 0x7ff24c70d8b8 "h\201\022Ô®\253\023`\020\254c\004"
        buf_end = <optimized out>
        n_dense = 8
        slot_size = <optimized out>
        recs = 0x7ff24c70d860
        heap = 0x7ff24c70d7f8
        trx_id_col = 1
        n_blobs = 0
        storage = <optimized out>
        ns = 1994864028065204
        cmp_per_index_enabled = 0 '\000'
        page = 0x7ff3a9760000 <error: Cannot access memory at address 0x7ff3a9760000>
        page_zip = 0x7ff3a8f136d8
        n_fields = <optimized out>
        ind_id = 148112
        time_diff = <optimized out>
#9  0x00005576752d9fe6 in PageBulk::compress (this=0x7ff24c3286b8) at ./storage/innobase/btr/btr0bulk.cc:579
No locals.
#10 BtrBulk::pageCommit (this=0x7ff24c303ca8, page_bulk=0x7ff24c3286b8, next_page_bulk=0x7ff3d40b7d70, insert_father=<optimized out>) at ./storage/innobase/btr/btr0bulk.cc:944
No locals.
#11 0x00005576752da3f4 in BtrBulk::pageSplit (this=0x7ff24c303ca8, page_bulk=0x7ff24c3286b8, next_page_bulk=0x7ff24c3f94c8) at ./storage/innobase/btr/btr0bulk.cc:897
        new_page_bulk = {m_heap = 0x7ff24c333f28, m_index = 0x7ff24c30ff90, m_mtr = {m_last = 0x7ff3a8f13880, m_last_offset = 117, m_log_mode = 0, m_modifications = 1, m_made_dirty = 1, m_latch_ex = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_crc = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7ff3d40b7db8, prev = 0x7ff3d40b7db8}}, size_ = 1}, m_size = 16, m_first_block = {<ilist_node<void>> = {next = 0x7ff3d40b7d98, prev = 0x7ff3d40b7d98}, m_data = "\200\070\361\250\363\177\000\000\022", '\000' <repeats 490 times>, m_used = 16}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7ff3d40b7fe8, prev = 0x7ff3d40b7fe8}}, size_ = 1}, m_size = 126, m_first_block = {<ilist_node<void>> = {next = 0x7ff3d40b7fc8, prev = 0x7ff3d40b7fc8}, m_data = "\024\300\247wc\024\300\247wc0d\300\247wc\b\377\377\377\377\377\377\377\377\000\000\000\000\000\000\000\000E\277\000\000\000\000\000\000\000\000\000\000\347\367\000\002\000x\200\002\000\000\000\000\000\000\000\005", '\000' <repeats 19 times>, "\002B\220", '\000' <repeats 20 times>, "h\201\022Ô®\253\023`\020\254c\004\000\000\000\377\377\003\000\t\340\001\331", '\000' <repeats 373 times>, m_used = 126}}, m_user_space = 0x7ff24c302bf8, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}, m_trx_id = 243034879, m_block = 0x7ff3a8f13880, m_page = 0x7ff3a976c000 <error: Cannot access memory at address 0x7ff3a976c000>, m_page_zip = 0x7ff3a8f138b8, m_cur_rec = 0x7ff3a976fd20 <error: Cannot access memory at address 0x7ff3a976fd20>, m_page_no = 99, m_level = 0, m_is_comp = true, m_heap_top = 0x7ff3a976fea5 <error: Cannot access memory at address 0x7ff3a976fea5>, m_rec_no = 8, m_free_space = 331, m_reserved_space = 1024, m_padding_space = 0, m_modify_clock = 0, m_err = DB_SUCCESS}
        err = <optimized out>
        split_rec = 0x7ff3a9760083 <error: Cannot access memory at address 0x7ff3a9760083>
#12 0x00005576752d9923 in BtrBulk::insert (this=this@entry=0x7ff24c303ca8, tuple=tuple@entry=0x7ff24c6fd7d0, level=level@entry=0) at ./storage/innobase/btr/btr0bulk.cc:1079
        sibling_page_bulk = 0x7ff24c3f94c8
        is_left_most = <optimized out>
        err = DB_SUCCESS
        page_bulk = 0x7ff24c3286b8
        n_ext = 0
        rec_size = 432
        big_rec = 0x0
        rec = 0x0
        offsets = 0x0
#13 0x000055767525a82d in BtrBulk::insert (tuple=0x7ff24c6fd7d0, this=0x7ff24c303ca8) at ./storage/innobase/include/btr0bulk.h:301
No locals.
#14 row_merge_insert_index_tuples (index=0x7ff24c30ff90, old_table=0x7ff24c2e5750, fd=@0x7ff3d40b8bb0: {m_file = -1, m_psi = 0x0}, block=0x0, row_buf=0x7ff24c2d15e0, btr_bulk=0x7ff24c303ca8, table_total_rows=613, pct_progress=0, pct_cost=25, crypt_block=0x0, space=59383, stage=0x0, blob_file=0x0) at ./storage/innobase/row/row0merge.cc:3898
        b = 0x0
        heap = 0x7ff24c6fd748
        tuple_heap = 0x7ff24c5c3438
        error = <optimized out>
        foffs = 0
        offsets = 0x7ff24c6fd7b0
        buf = 0x0
        n_rows = 136
        dtuple = 0x7ff24c6fd7d0
        inserted_rows = 135
        curr_progress = <optimized out>
        old_index = <optimized out>
        mrec = 0x0
        mtr = {m_last = 0x598800004000, m_last_offset = 6535, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_latch_ex = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_crc = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7ff3d40b84a8, prev = 0x7ff3d40b84a8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7ff3d40b8488, prev = 0x7ff3d40b8488}, m_data = "\230^\\\251\363\177\000\000a\243\\\251\363\177\000\000\360\204\v\324\363\177\000\000\370\204\v\324\363\177\000\000\311@\020uvU\000\000P\206\v\324\363\177\000\000\025J\\\251\363\177", '\000' <repeats 26 times>, "(k0L\362\177\000\000\000\000\000\000\000\000\000\000\213>7\034\364\177\000\000\272Y\272D\377\177\000\000\000\200\\\251\363\177\000\000\200\205\v\324\363\177", '\000' <repeats 18 times>, "\330woL\362\177\000\000\001\000\000\000\000\000\000\000\265\240;\034\364\177\000\000\220\205\v\324\363\177\000\000\220\205\v\324\363\177\000\000\030\367\360\250\363\177\000\000\252\317?uvU\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7ff3d40b86d8, prev = 0x7ff3d40b86d8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7ff3d40b86b8, prev = 0x7ff3d40b86b8}, m_data = "\000\000\000\000\000\000\000\000X\204\031\327\363\177\000\000X\213\v\324\363\177\000\000\003\000\000\000\000\000\000\000`\213\v\324\363\177\000\000\360\222\061L\362\177\000\000\001\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\243F\020uvU\000\000\300\270^L\362\177\000\000\a\020\000\000\000\000\000\000\200\000\001\000\000\000\000\000 \000\000L\362\177", '\000' <repeats 18 times>, "P\000\000\000\000\000\000\000*\000\000\000\000\000\000\000\220<0L\362\177\000\000\260\213\v\324\363\177\000\000p\211\v\324\363\177\000\000\341J\034uvU\000\000\250\207\v\324\363\177\000\000\001\000\000\000\000\000\000\000He\304uvU\000\000@&\305uvU\000\000"..., m_used = 0}}, m_user_space = 0x7ff3d40b8970, m_commit_lsn = 140678634287800, m_freed_space = 0x0, m_freed_pages = 0x0}
#15 0x00005576752639ed in row_merge_read_clustered_index (trx=<optimized out>, table=<optimized out>, old_table=<optimized out>, new_table=<optimized out>, online=<optimized out>, index=<optimized out>, fts_sort_idx=<optimized out>, psort_info=<optimized out>, files=<optimized out>, key_numbers=<optimized out>, n_index=<optimized out>, defaults=<optimized out>, add_v=<optimized out>, col_map=<optimized out>, add_autoinc=<optimized out>, sequence=<optimized out>, block=<optimized out>, skip_pk_sort=<optimized out>, tmpfd=<optimized out>, stage=<optimized out>, pct_cost=<optimized out>, crypt_block=<optimized out>, eval_table=<optimized out>, allow_not_null=<optimized out>, col_collate=<optimized out>) at ./storage/innobase/include/os0file.h:82
        buf = 0x7ff24c2d15e0
        rows_added = <optimized out>
        file = 0x7ff24c2bfc08
        k = 1
        i = 0
        ext = 0x0
        s_idx_cnt = 0
        rec = <optimized out>
        rec_trx_id = <optimized out>
        offsets = 0x7ff24c3192d0
        row = 0x0
        cur = 0x7ff3d40b8bf8
        skip_sort = <optimized out>
        clust_index = <optimized out>
        row_heap = 0x0
        merge_buf = <optimized out>
        v_heap = 0x0
        pcur = {btr_cur = {index = 0x7ff24c2feb60, page_cur = {index = 0x0, rec = 0x7ff3a95c8070 <error: Cannot access memory at address 0x7ff3a95c8070>, offsets = 0x0, block = 0x7ff3a8f0f6e0}, purge_node = 0x0, left_block = 0x0, thr = 0x0, flag = 0, tree_height = 0, up_match = 0, up_bytes = 0, low_match = 0, low_bytes = 0, n_fields = 0, n_bytes = 0, fold = 0, path_arr = 0x0, rtr_info = 0x0}, latch_mode = 1, old_stored = false, old_rec = 0x0, old_n_core_fields = 36176, old_n_fields = 0, rel_pos = 0, block_when_stored = {m_block = 0x0, m_page_id = {m_id = 0}}, modify_clock = 0, pos_state = BTR_PCUR_IS_POSITIONED, search_mode = PAGE_CUR_G, trx_if_known = 0x0, old_rec_buf = 0x0, buf_size = 0}
        mtr = {m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_latch_ex = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_crc = 1684957472, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7ff3d40b8ea8, prev = 0x7ff3d40b8ea8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7ff3d40b8e88, prev = 0x7ff3d40b8e88}, m_data = "\000\000\000\000\000\000\000\000 ", '\000' <repeats 15 times>, "\001\000\000\000\362\177\000\000\000\000\000\000\000\000\000\000\b\000\000\000\363\177\000\000\000\000\000\000\000\000\000\000\001\000\000\000\363\177\000\000\000\000\000\000\000\000\000\000\001\000\000\000vU\000\000\000\000\000\000\000\000\000\000\001", '\000' <repeats 15 times>, "\001", '\000' <repeats 15 times>, "\001\000\000\000\363\177\000\000\000\000\000\000\000\000\000\000\001", '\000' <repeats 15 times>, "\001\000\000\000\363\177\000\000\000\000\000\000\000\000\000\000\001\000\000\000\202\271\005\303\000\000\000\000\000\000\000\000\001\000\000\000\362\177\000\000\000\000\000\000\000\000\000\000"..., m_used = 496}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7ff3d40b90d8, prev = 0x7ff3d40b90d8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7ff3d40b90b8, prev = 0x7ff3d40b90b8}, m_data = "(\000\000\000\000\000\000\000\020\224\v\324\363\177\000\000\000\000\000\000\000\000\000\000)\000\006\000\b\a\000\000\003\000\000\000\000\000\000\001\360i1L\362\177\000\000\000\305+L\362\177\000\000\002\000\000\000\000\000\000\000Xp1L\362\177\000\000\240\373\060L\362\177\000\000\003", '\000' <repeats 15 times>, "\311@\020uvU\000\000\370+0L\362\177\000\000(\355\a\206L\000\000\000\340\221\v\324\363\177\000\000\035|\267tvU\000\000Б\v\324\363\177\000\000-\234@uvU\000\000\000\000\000\000\000\000\000\000\243F\020uvU\000\000\b\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\230\276?L\362\177\000\000\300\177Uv\221u[\265\330"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}
        mtr_started = false
        err = DB_SUCCESS
        n_nonnull = <optimized out>
        nonnull = <optimized out>
        fts_index = <optimized out>
        doc_id = 0
        max_doc_id = 0
        add_doc_id = <optimized out>
        fts_parallel_sort_cond = <optimized out>
        sp_tuples = <optimized out>
        sp_heap = <optimized out>
        num_spatial = <optimized out>
        clust_btr_bulk = 0x7ff24c303ca8
        clust_temp_file = false
        mtuple_heap = 0x7ff24c3b2238
        prev_mtuple = {fields = 0x7ff24c2c1ec8}
        conv_heap = 0x0
        curr_progress = <optimized out>
        read_rows = <optimized out>
        table_total_rows = <optimized out>
        new_sys_trx_start = "\000\000\000\000\016|j\377"
        new_sys_trx_end = "\377\377\377\377\377\377\377\377"
        any_autoinc_data = "\000\000\000\000\000\000\000"
        vers_update_trt = <optimized out>
        clust_dup = {index = 0x7ff24c30ff90, table = 0x7ff3d40b9c40, col_map = 0x7ff24c315828, n_dup = 0}
        prev_fields = <optimized out>
        n_uniq = <optimized out>
        path = <optimized out>
        old_trx_id_col = <optimized out>
        new_trx_id_col = <optimized out>
        n_rows = <optimized out>
#16 0x00005576752646d4 in row_merge_build_indexes (trx=0x7ff3d7197b80, old_table=0x7ff24c2e5750, new_table=0x7ff24c309990, online=true, indexes=0x7ff24c2e32e0, key_numbers=0x7ff24c2e32f8, n_indexes=3, table=0x7ff3d40b9c40, defaults=0x0, col_map=0x7ff24c315828, add_autoinc=18446744073709551615, sequence=@0x7ff24c05b548: {m_max_value = 0, m_increment = 0, m_offset = 0, m_next_value = 1232, m_eof = true}, skip_pk_sort=true, stage=0x557677e8dca8, add_v=0x0, eval_table=0x7ff3d40b9c40, allow_not_null=false, col_collate=0x0) at ./storage/innobase/row/row0merge.cc:4817
        merge_files = <optimized out>
        block = 0x7ff2aeb5e000 ""
        block_pfx = {m_key = 0, m_owner = 0x0, m_size = 3145728}
        block_size = <optimized out>
        crypt_pfx = {m_key = 2010874192, m_owner = 0x557677db6a48, m_size = 0}
        crypt_block = 0x0
        i = <optimized out>
        j = <optimized out>
        error = <optimized out>
        tmpfd = {m_file = -1, m_psi = 0x0}
        fts_sort_idx = <optimized out>
        psort_info = 0x0
        merge_info = 0x0
        fts_psort_initiated = <optimized out>
        total_static_cost = <optimized out>
        total_dynamic_cost = <optimized out>
        total_index_blocks = 0
        pct_cost = 25
        pct_progress = 0
        alloc = <optimized out>
        n_merge_files = <optimized out>
#17 0x00005576751d0dff in ha_innobase::inplace_alter_table (this=0x7ff24c2f5da0, altered_table=0x7ff3d40b9c40, ha_alter_info=0x7ff3d40b9b80) at /usr/include/c++/9/bits/stl_map.h:463
        error = <optimized out>
        add_v = <optimized out>
        s_templ = <optimized out>
        old_templ = <optimized out>
        eval_table = 0x7ff3d40b9c40
        rebuild_templ = <optimized out>
        ctx = 0x7ff24c05b498
        pk = <optimized out>
#18 0x0000557674d433f6 in handler::ha_inplace_alter_table (ha_alter_info=0x7ff3d40b9b80, altered_table=0x7ff3d40b9c40, this=<optimized out>) at ./sql/handler.h:4633
No locals.
#19 mysql_inplace_alter_table (target_mdl_request=0x7ff3d40ba410, if_exists=false, start_alter_id=@0x7ff3d40b9ac0: 0, partial_alter=@0x7ff3d40b9ab7: false, alter_ctx=0x7ff3d40bb580, trigger_param=0x7ff3d40ba000, ddl_log_state=0x7ff3d40b9b20, ha_alter_info=0x7ff3d40b9b80, altered_table=0x7ff3d40b9c40, table=0x7ff24c2b12a8, table_list=0x7ff24c058a90, thd=0x7ff24c000c58) at ./sql/sql_table.cc:7670
        db_type = 0x557677c65088
        alter_info = 0x7ff3d40bc240
        res = <optimized out>
        commit_succeded_with_error = false
        ot_ctx = {m_thd = 0x7ff24c000c58, m_failed_table = 0x0, m_start_of_statement_svp = {m_stmt_ticket = 0x7ff24c2db6c0, m_trans_ticket = 0x7ff24c2de170}, m_timeout = 31536000, m_flags = 34923, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = true, m_has_protection_against_grl = 0, vers_create_count = 0}
        reopen_tables = false
        inplace_supported = <optimized out>
        ot_ctx = <optimized out>
        db_type = <optimized out>
        alter_info = <optimized out>
        reopen_tables = <optimized out>
        res = <optimized out>
        commit_succeded_with_error = <optimized out>
        inplace_supported = <optimized out>
        trt = <optimized out>
        trx_start_id = <optimized out>
        trx_end_id = <optimized out>
#20 mysql_alter_table (thd=0x7ff24c000c58, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=<optimized out>, alter_info=<optimized out>, order_num=0, order=0x0, ignore=false, if_exists=false) at ./sql/sql_table.cc:10707
        org_count_cuted_fields = CHECK_FIELD_IGNORE
        res = <optimized out>
        ha_alter_info = {create_info = 0x7ff3d40bc330, alter_info = 0x7ff3d40bc240, key_info_buffer = 0x7ff24c05aa60, key_count = 3, index_drop_count = 0, index_drop_buffer = 0x7ff24c05b440, index_add_count = 0, index_add_buffer = 0x7ff24c05b458, index_altered_ignorability_buffer = 0x7ff24c05b468, index_altered_ignorability_count = 0, rename_keys = {m_root = 0x7ff24c006a00, m_array = 0x0, m_size = 0, m_capacity = 0}, handler_ctx = 0x7ff24c05b498, group_commit_ctx = 0x0, handler_flags = 1280, partition_flags = 93967305376080, modified_part_info = 0x0, ignore = false, online = true, inplace_alter_table_committed = 0x0, inplace_alter_table_committed_argument = 0x0, inplace_supported = HA_ALTER_INPLACE_COPY_NO_LOCK, unsupported_reason = 0x0, error_if_not_empty = false, mdl_exclusive_after_prepare = false}
        altered_share = {table_category = TABLE_CATEGORY_TEMPORARY, name_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0, m_psi_key = 0, malloc_flags = 0}, get_key = 0x0, hash_function = 0x0, free = 0x0, charset = 0x0}, mem_root = {free = 0x7ff24c30eb28, used = 0x7ff24c303888, pre_alloc = 0x0, min_malloc = 32, block_size = 1016, block_num = 9, first_block_usage = 0, flags = 0, error_handler = 0x557674d81260 <sql_alloc_error_handler()>, psi_key = 8}, keynames = {count = 3, name = 0x0, type_names = 0x7ff24c2f7ce0, type_lengths = 0x7ff24c2f7d2c}, fieldnames = {count = 8, name = 0x0, type_names = 0x7ff24c2f7c98, type_lengths = 0x7ff24c2f7d08}, intervals = 0x0, LOCK_ha_data = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, LOCK_share = {m_mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, m_psi = 0x0}, tdc = 0x0, tabledef_version = {str = 0x7ff24c3038a0 "6,9", length = 16}, option_list = 0x0, option_struct = 0x7ff24c303c40, field = 0x7ff24c2f7c50, found_next_number_field = 0x7ff24c2f7c50, key_info = 0x7ff24c3038b8, check_constraints = 0x7ff24c2f7c98, blob_field = 0x7ff24c303c60, vcol_defs = {str = 0x7ff24c2f7db0 "\360\270\262uvU", length = 0}, stats_cb = {stats_state = {state = 0}, hist_state = {state = 0}, mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, flags = 0, error_handler = 0x0, psi_key = 0}, table_stats = 0x0, have_histograms = false}, default_values = 0x7ff24c30dd40 "\377", comment = {str = 0x7ff24c303c10 "", length = 0}, table_charset = 0x557675cc1020 <my_charset_utf8mb4_bin>, check_set = 0x0, all_set = {bitmap = 0x7ff24c30efc0, last_word_ptr = 0x7ff24c30efc0, last_word_mask = 4294967040, n_bits = 8}, table_cache_key = {str = 0x7ff24c059178 "owncloud", length = 0}, db = {str = 0x7ff24c059178 "owncloud", length = 8}, table_name = {str = 0x7ff24c058a48 "oc_cards", length = 8}, path = {str = 0x7ff3d40bbfbf "./owncloud/#sql-alter-3571-52", length = 29}, normalized_path = {str = 0x7ff3d40bbfbf "./owncloud/#sql-alter-3571-52", length = 29}, connect_string = {str = 0x7ff24c3038b0 "", length = 0}, keys_in_use = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {7}}, ignored_indexes = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_for_keyread = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {7}}, min_rows = 0, max_rows = 0, avg_row_length = 0, mysql_version = 100903, reclength = 2218, stored_rec_length = 2218, db_plugin = 0x557677bac330, row_type = ROW_TYPE_COMPRESSED, table_type = TABLE_TYPE_NORMAL, tmp_table = INTERNAL_TMP_TABLE, transactional = HA_CHOICE_UNDEF, page_checksum = HA_CHOICE_UNDEF, key_block_size = 0, stats_sample_pages = 0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, null_bytes = 1, last_null_bit_pos = 5, null_bytes_for_compare = 1, fields = 8, stored_fields = 8, virtual_fields = 0, virtual_not_stored_blob_fields = 0, null_fields = 5, blob_fields = 1, varchar_fields = 3, default_fields = 0, visible_fields = 8, default_expressions = 0, table_check_constraints = 0, field_check_constraints = 0, rec_buff_length = 2224, keys = 3, key_parts = 4, ext_key_parts = 6, max_key_length = 1033, max_unique_length = 8, uniques = 0, db_create_options = 9, db_options_in_use = 9, db_record_offset = 1, rowid_field_offset = 1, primary_key = 0, next_number_index = 0, next_number_key_offset = 0, next_number_keypart = 0, error = OPEN_FRM_OK, open_errno = 0, column_bitmap_size = 4, frm_version = 10 '\n', check_set_initialized = TABLE_SHARE::NO_V_KEYS, use_ext_keys = true, null_field_first = true, system = false, not_usable_by_query_cache = true, online_backup = false, no_replicate = false, crashed = false, is_view = false, can_cmp_whole_record = false, table_creation_was_logged = false, non_determinstic_insert = false, has_update_default_function = false, can_do_row_logging = false, long_unique_table = false, table_map_id = 503, incompatible_version = 0, view_def = 0x0, sequence = 0x0, auto_partitioned = false, partition_info_str = 0x0, partition_info_str_len = 0, partition_info_buffer_size = 0, default_part_plugin = 0x0, versioned = VERS_UNDEFINED, vers = {start_fieldno = 0, end_fieldno = 0, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5576756196b9 "SYSTEM_TIME", length = 11}, <No data fields>}, <No data fields>}, constr_name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, unique_keys = 0}, period = {start_fieldno = 0, end_fieldno = 0, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, constr_name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, unique_keys = 0}, vers_skip_auto_create = false, table_field_def_cache = 0x0, ha_share = 0x0, m_psi = 0x0, frm_image = 0x0}
        altered_table = {s = 0x7ff3d40ba9d0, file = 0x7ff24c2dd0b0, next = 0x0, prev = 0x0, share_all_next = 0x0, share_all_prev = 0x0, global_free_next = 0x0, global_free_prev = 0x0, instance = 0, in_use = 0x7ff24c000c58, record = {0x7ff24c313fd0 "\377", 0x7ff24c313fd0 "\377", 0x7ff24c313fd0 "\377"}, write_row_record = 0x0, insert_values = 0x0, covering_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, intersect_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_in_use_for_query = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_in_use_for_group_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_in_use_for_order_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, constraint_dependent_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, key_info = 0x7ff24c3149a0, field = 0x7ff24c30d2a0, vfield = 0x0, default_field = 0x0, next_number_field = 0x0, found_next_number_field = 0x7ff24c30d360, check_constraints = 0x0, triggers = 0x0, pos_in_table_list = 0x0, pos_in_locked_tables = 0x0, internal_tables = 0x0, group = 0x0, alias = {<Charset> = {m_charset = 0x557675c55a40 <my_charset_bin>}, <Binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7ff24c30d290 "oc_cards", str_length = 8, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}, null_flags = 0x7ff24c313fd0 "\377", def_read_set = {bitmap = 0x7ff24c30d620, last_word_ptr = 0x7ff24c30d620, last_word_mask = 4294967040, n_bits = 8}, def_write_set = {bitmap = 0x7ff24c30d624, last_word_ptr = 0x7ff24c30d624, last_word_mask = 4294967040, n_bits = 8}, tmp_set = {bitmap = 0x7ff24c30d62c, last_word_ptr = 0x7ff24c30d62c, last_word_mask = 4294967040, n_bits = 8}, def_rpl_write_set = {bitmap = 0x7ff24c30d638, last_word_ptr = 0x7ff24c30d638, last_word_mask = 4294967040, n_bits = 8}, eq_join_set = {bitmap = 0x7ff24c30d630, last_word_ptr = 0x7ff24c30d630, last_word_mask = 4294967040, n_bits = 8}, cond_set = {bitmap = 0x7ff24c30d634, last_word_ptr = 0x7ff24c30d634, last_word_mask = 4294967040, n_bits = 8}, read_set = 0x7ff3d40bac20, write_set = 0x7ff3d40bac20, rpl_write_set = 0x0, has_value_set = {bitmap = 0x7ff24c30d628, last_word_ptr = 0x7ff24c30d628, last_word_mask = 4294967040, n_bits = 8}, query_id = 0, collected_stats = 0x0, used_stat_records = 0, opt_range_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, opt_range = 0x7ff24c30d2e8, const_key_parts = 0x7ff24c30d348, opt_range_condition_rows = 0, cond_selectivity = 1, cond_selectivity_sampling_explain = 0x0, map = 0, lock_position = 0, lock_data_start = 0, lock_count = 0, tablenr = 0, used_fields = 0, temp_pool_slot = 0, status = 3, db_stat = 0, derived_select_number = 0, maybe_null = 0, current_lock = 2, copy_blobs = false, next_number_field_updated = false, null_row = false, no_rows_with_nulls = false, null_catch_flags = 0 '\000', force_index = false, force_index_order = false, force_index_group = false, distinct = false, const_table = false, no_rows = false, used_for_duplicate_elimination = false, keep_row_order = false, no_keyread = false, locked_by_logger = false, locked_by_name = false, fulltext_searched = false, no_cache = false, open_by_handler = false, auto_increment_field_not_null = false, insert_or_update = false, alias_name_used = false, get_fields_in_item_tree = false, vcol_refix_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40b9ec8, elements = 0}, <No data fields>}, m_needs_reopen = false, created = false, master_had_triggers = false, reginfo = {join_tab = 0x0, lock_type = TL_UNLOCK, skip_locked = false, not_exists_optimize = false, impossible_range = false}, mem_root = {free = 0x7ff24c30d278, used = 0x7ff24c313fb8, pre_alloc = 0x0, min_malloc = 32, block_size = 1016, block_num = 9, first_block_usage = 6, flags = 0, error_handler = 0x557674d81260 <sql_alloc_error_handler()>, psi_key = 62}, blob_storage = 0x0, grant = {grant_table_user = 0x0, grant_table_role = 0x0, version = 0, privilege = NO_ACL, want_privilege = NO_ACL, orig_want_privilege = NO_ACL, m_internal = {m_schema_lookup_done = false, m_schema_access = 0x0, m_table_lookup_done = false, m_table_access = 0x0}}, expr_arena = 0x0, part_info = 0x0, all_partitions_pruned_away = false, max_keys = 0, stats_is_read = false, histograms_are_read = false, mdl_ticket = 0x0, spl_opt_info = 0x0, keys_usable_for_splitting = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, notnull_cond = 0x0, with_impossible_ranges = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, range_rowid_filter_cost_info_elems = 0, range_rowid_filter_cost_info = 0x0, range_rowid_filter_cost_info_ptr = 0x0, vers_write = false}
        use_inplace = true
        engine_changed = <optimized out>
        error = <optimized out>
        frm_is_created = <optimized out>
        error_handler_pushed = false
        no_ha_table = true
        table = 0x7ff24c2b12a8
        new_table = 0x0
        ddl_log_state = {list = 0x7ff24c0d78d8, execute_entry = 0x7ff24c056a98, main_entry = 0x7ff24c058668, flags = 0}
        errors_to_warnings = {<Internal_error_handler> = {_vptr.Internal_error_handler = 0x557675add1c8 <vtable for Turn_errors_to_warnings_handler+16>, m_prev_internal_handler = 0x0}, <No data fields>}
        partition_changed = false
        fast_alter_partition = false
        partial_alter = false
        start_alter_id = 0
        key_info = 0x7ff24c05aa60
        key_count = 3
        varchar = <optimized out>
        table_creation_was_logged = true
        binlog_as_create_select = false
        log_if_exists = false
        tables_opened = 1
        new_db_type = 0x557677c65088
        old_db_type = <optimized out>
        copied = 0
        deleted = 0
        frm = {str = 0x7ff24c301628 "\376\001\n\f\027", length = 4291}
        backup_name = {str = 0x7ff3d40ba3d0 "#sql-backup-3571-52", length = 19}
        index_file = "\000\246\v\324\363\177\000\000\000\000\000\000\000\000\000\000\060\246\v\324\363\177\000\000\200\206\031\327\363\177\000\000\310\371\060L\362\177\000\000\270\062\006L\362\177\000\000p\246\v\324\363\177\000\000O\322#uvU\000\000\000\213/L\362\177\000\000 3\006L\362\177\000\000ݼiuvU\000\000@\362iuvU\000\000\300\251\v\324\363\177\000\000]\322\062uvU\000\000ts\000\324\363\177\000\000\200\206\031\327\363\177\000\000\001", '\000' <repeats 15 times>, "@\247\v\324\363\177\000\000\067,+c\000\000\000\000owncloud\000\246\v\324\363\177\000\000\230\246\v\324\363\177\000\000\001", '\000' <repeats 15 times>, "x"...
        data_file = '\000' <repeats 24 times>, "\350\243\304uvU\000\000\350\243\304uvU\000\000 \250\v\324\363\177\000\000\000\000\000\000\000\000\000\000h\377-L\362\177\000\000`\251\v\324\363\177\000\000~\216@uvU\000\000\377\377\377\377\377\377\377\377\000\000\000\000\000\000\000\000X\020\061L\362\177\000\000\000\305+L\362\177\000\000\377\377\377\377\363\177\000\000cs%uvU\000\000X\020\061L\362\177\000\000\240aL\034\364\177\000\000\000\000\000\000\000\000\000\000\b\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\330\305+L\362\177\000\000`\356\t\234\362\177\000\000\311@\020uvU\000\000\340\r1L\362\177\000\000"...
        backup_name_buff = "#sql-backup-3571-52\000\000\000\000\000\000\247\210\a˝\246\351\000\000\000\000\000\000\000\000\024\336\350wvU\000\000`\267\v\324\363\177\000\000\240]/L"
        uuid_buffer = "6,9\000\071\301\021\355\240\271\212\034\035g\272", <incomplete sequence \312>
        target_mdl_request = {type = MDL_NOT_INITIALIZED, duration = 32754, next_in_list = 0x7ff3d40ba540, prev_in_list = 0x3, ticket = 0x0, key = {m_length = 48, m_db_name_length = 0, m_hash_value = 48, m_ptr = " \245\v\324\363\177\000\000P\244\v\324\363\177\000\000\000\247\210\a˝\246\351;\342\a\206L\000\000\000F\243!uvU\000\000\030\375\000\000\000\000\000\000\301\022\022\000\000\000\000\000\001\000\000\000\000\000\000\000\260\201\000\000n\000\000\000u", '\000' <repeats 15 times>, "\303\020\000\000\000\000\000\000\000\020\000\000\000\000\000\000\020\000\000\000\000\000\000\000\024\352]b\000\000\000\000\212E\005.\000\000\000\000\301\311*c\000\000\000\000\071\205\017\030\000\000\000\000\301\311*c\000\000\000\000\071\205\017\030", '\000' <repeats 28 times>, "\024\336\350wvU\000\000E@1uvU\000\000\200"..., static m_namespace_to_wait_state_name = {{m_key = 142, m_name = 0x5576754e70c1 "Waiting for backup lock", m_flags = 0}, {m_key = 143, m_name = 0x5576754e6db0 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 144, m_name = 0x5576754e6dd8 "Waiting for table metadata lock", m_flags = 0}, {m_key = 145, m_name = 0x5576754e6df8 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 146, m_name = 0x5576754e6e28 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 147, m_name = 0x5576754e6e58 "Waiting for stored package body metadata lock", m_flags = 0}, {m_key = 148, m_name = 0x5576754e6e88 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 149, m_name = 0x5576754e6eb0 "Waiting for event metadata lock", m_flags = 0}, {m_key = 101, m_name = 0x5576754bdfd6 "User lock", m_flags = 0}}}, m_src_file = 0x0, m_src_line = 126396160}
        mdl_ticket = 0x7ff24c2de170
        alter_prelocking_strategy = {<Prelocking_strategy> = {_vptr.Prelocking_strategy = 0x557675ad4c98 <vtable for Alter_table_prelocking_strategy+16>}, <No data fields>}
        trigger_param = {table = {s = 0x0, file = 0x0, next = 0x0, prev = 0x0, share_all_next = 0x0, share_all_prev = 0x0, global_free_next = 0x0, global_free_prev = 0x0, instance = 0, in_use = 0x0, record = {0x0, 0x0, 0x0}, write_row_record = 0x0, insert_values = 0x0, covering_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, intersect_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_in_use_for_query = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_in_use_for_group_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, keys_in_use_for_order_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, constraint_dependent_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, key_info = 0x0, field = 0x0, vfield = 0x0, default_field = 0x0, next_number_field = 0x0, found_next_number_field = 0x0, check_constraints = 0x0, triggers = 0x0, pos_in_table_list = 0x0, pos_in_locked_tables = 0x0, internal_tables = 0x0, group = 0x0, alias = {<Charset> = {m_charset = 0x0}, <Binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}, null_flags = 0x0, def_read_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, def_write_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, tmp_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, def_rpl_write_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, eq_join_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, cond_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, read_set = 0x0, write_set = 0x0, rpl_write_set = 0x0, has_value_set = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 0, n_bits = 0}, query_id = 0, collected_stats = 0x0, used_stat_records = 0, opt_range_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, opt_range = 0x0, const_key_parts = 0x0, opt_range_condition_rows = 0, cond_selectivity = 0, cond_selectivity_sampling_explain = 0x0, map = 0, lock_position = 0, lock_data_start = 0, lock_count = 0, tablenr = 0, used_fields = 0, temp_pool_slot = 0, status = 0, db_stat = 0, derived_select_number = 0, maybe_null = 0, current_lock = 0, copy_blobs = false, next_number_field_updated = false, null_row = false, no_rows_with_nulls = false, null_catch_flags = 0 '\000', force_index = false, force_index_order = false, force_index_group = false, distinct = false, const_table = false, no_rows = false, used_for_duplicate_elimination = false, keep_row_order = false, no_keyread = false, locked_by_logger = false, locked_by_name = false, fulltext_searched = false, no_cache = false, open_by_handler = false, auto_increment_field_not_null = false, insert_or_update = false, alias_name_used = false, get_fields_in_item_tree = false, vcol_refix_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0, elements = 0}, <No data fields>}, m_needs_reopen = false, created = false, master_had_triggers = false, reginfo = {join_tab = 0x0, lock_type = TL_UNLOCK, skip_locked = false, not_exists_optimize = false, impossible_range = false}, mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, flags = 0, error_handler = 0x0, psi_key = 0}, blob_storage = 0x0, grant = {grant_table_user = 0x0, grant_table_role = 0x0, version = 0, privilege = NO_ACL, want_privilege = NO_ACL, orig_want_privilege = NO_ACL, m_internal = {m_schema_lookup_done = false, m_schema_access = 0x0, m_table_lookup_done = false, m_table_access = 0x0}}, expr_arena = 0x0, part_info = 0x0, all_partitions_pruned_away = false, max_keys = 0, stats_is_read = false, histograms_are_read = false, mdl_ticket = 0x0, spl_opt_info = 0x0, keys_usable_for_splitting = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, notnull_cond = 0x0, with_impossible_ranges = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {0}}, range_rowid_filter_cost_info_elems = 0, range_rowid_filter_cost_info = 0x0, range_rowid_filter_cost_info_ptr = 0x0, vers_write = false}, upgrading50to51 = false, got_error = false}
        inplace_alter_table_committed = 0x0
        inplace_alter_table_committed_argument = 0x0
        table_kind = <optimized out>
        is_reg_table = true
        alter_ctx = {implicit_default_value_error_field = 0x0, error_if_not_empty = false, tables_opened = 1, db = {str = 0x7ff24c059178 "owncloud", length = 8}, table_name = {str = 0x7ff24c058a48 "oc_cards", length = 8}, storage_engine_name = {str = 0x7ff3d40bb6a0 "InnoDB", length = 6}, alias = {str = 0x7ff24c058a48 "oc_cards", length = 8}, new_db = {str = 0x7ff24c059178 "owncloud", length = 8}, new_name = {str = 0x7ff24c058a48 "oc_cards", length = 8}, new_alias = {str = 0x7ff24c058a48 "oc_cards", length = 8}, tmp_name = {str = 0x7ff3d40bbafc "#sql-alter-3571-52", length = 18}, tmp_storage_engine_name = {str = 0x7ff3d40bb760 "InnoDB", length = 6}, tmp_id = {str = 0x7ff3d40ba3c0 "6,9", length = 16}, id = {str = 0x7ff3d40bb690 "E\364*\241\277i\021\354\214ÙÅ \034\035g\272\312InnoDB", length = 16}, tmp_buff = "\200\000\000L\362\177\000\000\000\000\000\000\000\000\000\000\a\000\000\000\000\000\000\000\064\v\000L\362\177\000\000\070\023\000\000\000\000\000\000d\000\000\000\000\000\000\000`\022\000L\362\177\000\000`\023\000\000\000\000\000\000M\000\000\000\000\000\000\000\064\001\000\000}\000\000", id_buff = "E\364*\241\277i\021\354\214ÙÅ \034\035g\272", <incomplete sequence \312>, storage_engine_buff = "InnoDB\000\000|\000\000\000w\000\000\000o\000\000\000d\000\000\000\243F\020uvU", '\000' <repeats 11 times>, "\247\210\a˝\246\351\070\023\000\000\000\000\000\000\230\v0L\362\177\000\000\001\000\000\000\000\000\000\000\303\020\000\000\000\000\000\000\000 \000\000\000\000\000\000\000\020\000\000\000\000\000\000\301\311*c\000\000\000\000\301\311*c\000\000\000\000\024\352]b", '\000' <repeats 12 times>, "(\005\060L\362\177\000\000\000\247\210\a˝\246\351@\267\v\324\363\177\000\000\200\001\000\000\000\000\000\000\240]/L\362\177\000\000\003\000\000\000\000\000\000\000\220r-L\362\177\000\000\000\000\000\000\000\000\000", tmp_storage_engine_buff = "InnoDB\000\000'\277\033uvU\000\000`< I\362\177\000\000X\f\000L\362\177\000\000\002\000\000\000\000\000\000\000\360s-L\362\177\000\000È·\v\324\363\177\000\000\003\000\000\000\000\000\000\000PW.L\362\177\000\000\250\022+L\362\177\000\000\240]/L\362\177\000\000@Y.L\362\177", '\000' <repeats 14 times>, "vU\000\000owncloud/oc_cards\000arsubscriptions", '\000' <repeats 23 times>, "\363U7\034\364\177\000\000 \362+L\362\177\000\000\200\000\000L\362\177\000", storage_engine_partitioned = false, tmp_storage_engine_name_partitioned = false, fk_error_if_delete_row = false, fk_error_id = 0x0, fk_error_table = 0x0, modified_primary_key = false, tmp_table = false, new_filename = "./owncloud/oc_cards.frm\000bscriptions.fr\340\270\v\324\363\177\000\000\035|\267tvU\000\000\000\000\000\000\000\000\000\000|\000\000\000w\000\000\000n\000\000\000\\\000\000\000\243F\020uvU\000\000\023\000\000\000\000\000\000\000-\000\000\000\000\000\000\000\200\306\tL\362\177\000\000\200\330AuvU\000\000`\271\v\324\363\177\000\000\030\071\362wvU\000\000 9\362wvU\000\000qQ\262\000\000\000\000\000\060\271\v\324\363\177\000\000ÔÅ¡@uvU\000\000\023\000\000\000\000\000\000\000@Z\305uvU\000\000\030\217\005L\362\177\000\000\000\000\000\000qQ\262\000\067,+"..., new_alias_buff = "L\362\177\000\000X\f\000L\362\177\000\000\360\216\005L\362\177\000\000\060\304\v\324\363\177\000\000Ƚ\v\324\363\177\000\000\060\273\v\324\363\177\000\000RE\333tvU\000\000t\246\243D!\031\030\000\020\227\022uvU\000\000X\v\000L\362\177\000\000P\005\000\000\000\000\000\000./ownclo\000\000\000\000\000\030\365@lendarsu@&\305uvU\000\000\300Ö¸wvU\000\000#c@uvU\000\000@&\305uvU\000\000\362W7\034\364\177\000\000\200\000\000L\362\177\000\000\000\000\000\000\000\000\000\000\a\000\000\000\000\000\000\000P\t\000L\362\177\000\000\020\b\000\000\000\000\000\000P\000\000", tmp_name_buff = "#sql-alter-3571-52\000\000 \000\000\000\000\000\000\000\202\000\000\000P\000\000\000\240\273\v\324\363\177\000\000\035|\267tvU\000\000\000\000\000\000\000\000\000\000|\000\000\000w\000\000\000n\000\000\000_\000\000\000\243F\020uvU\000\000\220\021\000L\362\177\000\000@&\305uvU\000\000\300Ö¸wvU\000\000#c@uvU\000\000@&\305uvU\000\000\300Ö¸wvU\000\000\340\273\v\324\363\177\000\000\373{\262tvU\000\000\030p-L\362\177\000\000\200{\031\327\363\177\000\000X\f\000L\362\177\000\000\005\000\000\000\000\000\000\000\020\274\v\324\363\177\000\000D\352\033uv", path = "./owncloud/oc_cards\000\r\000L\362\177\000\000\001=\333tvU\000\000\060\274\v\324\363\177\000\000Bu\255tvU\000\000p\274\v\324\363\177\000\000\035|\267tvU\000\000\b\000\000\000\000\000\000\000\060\277\v\324\363\177\000\000\250\r\000L\362\177\000\000\243F\020uvU\000\000\060Õ¸wvU\000\000\250\r\000L\362\177\000\000\220\274\v\324\363\177\000\000WA\333tvU\000\000`\025+L\362\177\000\000\000\247\210\a˝\246\351\020\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\270\236,L\362\177\000\000\026\000\000\000\000\000\000\000\300\274\v\324\363\177\000\000\376\355?uvU", '\000' <repeats 18 times>..., new_path = "./owncloud/oc_cards\000\255uvU\000\000\000\000\000\000\000\000\000\000\060\304\v\324\363\177\000\000\000u\255tvU\000\000p\276\v\324\363\177\000\000\035|\267tvU\000\000\b\000\000\000\000\000\000\000\060\301\v\324\363\177\000\000\250\r\000L\362\177\000\000\243F\020uvU\000\000\060Õ¸wvU\000\000\250\r\000L\362\177\000\000\220\276\v\324\363\177\000\000WA\333tvU\000\000p\276\v\324\363\177\000\000\000\247\210\a˝\246\351\020\000\000\000\000\000\000\000 \000\000\000\000\000\000\000\230\216-L\362\177\000\000\026\000\000\000\000\000\000\000\300\276\v\324\363\177\000\000\376\355?uvU", '\000' <repeats 18 times>..., tmp_path = "./owncloud/#sql-alter-3571-52\000\000\000\000\240\305\v\324\363\177\000\000@\324\v\324\363\177\000\000 \300\v\324\363\177\000\000\fJ\305tvU\000\000\000\000\000\000\000\000\360?\001\000\000\000\000\000\000\000\340\304\v\324\363\177\000\000\270\357\266wvU\000\000\300\302\v\324\363\177\000\000\234[\305tvU\000\000\340\304\v\324\363\177\000\000X\f\000L\362\177\000\000\001\000\000\000\000\000\000\000\005\000\000\000vU\000\000@Z\305uvU\000\000\200\300\v\324\363\177\000 P\304\v\324\363\177\000\000\366\v\273tvU\000\000\376\002\000\000\376\002\000\000\020\301\v\324\363\177\000\000\000\303\v\324\363\177\000\000"...}
#21 0x0000557674d4419f in mysql_recreate_table (thd=thd@entry=0x7ff24c000c58, table_list=table_list@entry=0x7ff24c058a90, table_copy=table_copy@entry=false) at ./sql/sql_table.cc:11804
        create_info = {<HA_CREATE_INFO> = {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x0, tabledef_version = {str = 0x7ff3d40ba3c0 "6,9", length = 16}, org_tabledef_version = {str = 0x0, length = 0}, connect_string = {str = 0x7ff249205ea0 "", length = 0}, comment = {str = 0x7ff249206200 "", length = 0}, alias = {str = 0x7ff24c058a48 "oc_cards", length = 8}, org_storage_engine_name = {str = 0x0, length = 0}, new_storage_engine_name = {str = 0x5576756825a9 <innobase_hton_name> "InnoDB", length = 6}, password = 0x0, tablespace = 0x0, data_file_name = 0x0, index_file_name = 0x0, max_rows = 0, min_rows = 0, auto_increment_value = 1232, table_options = 9, avg_row_length = 0, used_fields = 0, key_block_size = 0, expression_length = 0, field_check_constraints = 0, stats_sample_pages = 0, null_bits = 5, options = 72, merge_insert_method = 0, extra_size = 16, db_type = 0x557677c65088, row_type = ROW_TYPE_COMPRESSED, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_UNDEF, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = true, sequence = false, check_constraint_list = 0x7ff3d40bc2d0, option_struct = 0x7ff24c05ad20, fields_option_struct = 0x7ff24c0595d8, indexes_option_struct = 0x7ff24c059618, table = 0x0, pos_in_locked_tables = 0x0, merge_list = 0x0, mdl_ticket = 0x0, table_was_deleted = false, seq_create_info = 0x0}, vers_info = {<Table_period_info> = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5576756196b9 "SYSTEM_TIME", length = 11}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}, as_row = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, static default_start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5576756196c5 "row_start", length = 9}, <No data fields>}, <No data fields>}, static default_end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5576756196cf "row_end", length = 7}, <No data fields>}, <No data fields>}, versioned_fields = false, unversioned_fields = false}, period_info = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}}, <Schema_specification_st> = {default_table_charset = 0x557675cc1020 <my_charset_utf8mb4_bin>, schema_comment = 0x0}, alter_info = 0x7ff3d40bc240}, <DDL_options_st> = {m_options = DDL_options_st::OPT_NONE}, default_charset_collation = {<Lex_opt_context_charset_st> = {m_had_charset_default = false}, <Lex_exact_charset_extended_collation_attrs_st> = {m_ci = 0x0, m_type = Lex_exact_charset_extended_collation_attrs_st::TYPE_EMPTY}, m_charset_order = Lex_extended_charset_extended_collation_attrs_st::CHARSET_TYPE_EMPTY}, convert_charset_collation = {<Lex_opt_context_charset_st> = {m_had_charset_default = false}, <Lex_exact_charset_extended_collation_attrs_st> = {m_ci = 0x0, m_type = Lex_exact_charset_extended_collation_attrs_st::TYPE_EMPTY}, m_charset_order = Lex_extended_charset_extended_collation_attrs_st::CHARSET_TYPE_EMPTY}}
        alter_info = {drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40bc240, elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40bc258, elements = 0}, <No data fields>}, key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ff24c05a0d0, last = 0x7ff24c05a298, elements = 3}, <No data fields>}, alter_rename_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40bc288, elements = 0}, <No data fields>}, create_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ff24c0597e0, last = 0x7ff24c05a000, elements = 8}, <No data fields>}, alter_index_ignorability_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40bc2b8, elements = 0}, <No data fields>}, check_constraint_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40bc2d0, elements = 0}, <No data fields>}, flags = 1028, partition_flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x557675cd5cf0 <end_of_list>, last = 0x7ff3d40bc300, elements = 0}, <No data fields>}, num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_NONE, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT}
        next_table = 0x0
        res = <optimized out>
#22 0x0000557674db5fcd in admin_recreate_table (thd=thd@entry=0x7ff24c000c58, table_list=table_list@entry=0x7ff24c058a90) at ./sql/sql_class.h:5042
        tmp_disable_binlog__save_options = 2147748608
        result_code = <optimized out>
#23 0x0000557674db8844 in mysql_admin_table (thd=<optimized out>, tables=0x7ff24c058a90, check_opt=0x7ff24c006160, operator_name=0x557675abd020 <msg_optimize>, lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=<optimized out>, view_operator_func=0x0, is_cmd_replicated=true) at ./sql/sql_admin.cc:1131
        alter_info = 0x7ff24c0066a0
        save_next_local = 0x0
        save_next_global = 0x0
        table_name_buff = "owncloud.oc_cards\000arsubscriptions\000\000\324\363\177\000\000\060\234\005L\362\177\000\000\350\262\005L\362\177\000\000\350\262\005L\362\177\000\000\000\311\v\324\363\177\000\000\233v\317tvU", '\000' <repeats 18 times>, "\270V\000L\362\177", '\000' <repeats 26 times>, "\060\311\v\324\363\177\000\000Oz\317tvU\000\000\000\000\000\000\000\000\000\000\270V\000L\362\177\000\000\360\\\315uvU\000\000\000\000\000\000\000\000\000\000`\311\v\324\363\177\000\000\275\060\325tvU\000\000\060\234\005L\362\177\000\000"...
        tabledef_version_buff = "\340\307\v\324\363\177\000\000\360\242\005L\362\177\000"
        db = <optimized out>
        fatal_error = false
        open_error = false
        storage_engine_partitioned = false
        open_for_modify = true
        table_name = <optimized out>
        storage_engine_name = "\000\275\005L\362\177\000\000\001\000\000\000\000\000\000\000\060\310\v\324\363\177\000\000\066\260\334tvU\000\000@\243\005L\362\177\000\000\000\000\000\000\000\000\000\000P\275\005L\362\177\000\000\000\000\000\000\000\000\000\000\070\257\005L\362\177\000\000\060\234\005L\362\177\000\000\200\276\005L\362\177\000\000\000\000\000\000\000\000\000\000\360\242\005L\362\177\000\000P\275\005L\362\177\000\000\300\310\v\324\363\177\000\000\275\070\317tvU\000\000X\f\000L\362\177\000\000\000\000\000\000\000\000\000\000\070\257\005L\362\177\000\000P\275\005L\362\177\000\000\000j\000L\362\177\000\000\000\000\000\000\000\000\000\000\240\026+L\362\177\000\000\000\260\005L\362\177\000"
        collect_eis = false
        table = <optimized out>
        field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7ff24c059210, last = 0x7ff24c0593d8, elements = 4}, <No data fields>}
        protocol = <optimized out>
        lex = 0x7ff24c004de0
        result_code = -7
        compl_result_code = <optimized out>
        need_repair_or_alter = false
        suspended_wfc = 0x0
        is_table_modified = false
        tabledef_version = {str = <optimized out>, length = 0}
#24 0x0000557674dba1b5 in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x7ff24c000c58) at ./sql/sql_admin.cc:1511
        m_lex = 0x7ff24c004de0
        first_table = 0x7ff24c058a90
        res = true
#25 0x0000557674c899be in mysql_execute_command (thd=0x7ff24c000c58, is_called_from_prepared_stmt=<optimized out>) at ./sql/sql_parse.cc:5997
        res = 0
        up_result = 0
        lex = 0x7ff24c004de0
        select_lex = 0x7ff24c0056b8
        first_table = 0x7ff24c058a90
        all_tables = 0x7ff24c058a90
        unit = 0x7ff24c004eb8
        have_table_map_for_update = false
        rpl_filter = <optimized out>
        ots = {ctx = 0x7ff24c004a80, traceable = false}
        orig_binlog_format = BINLOG_FORMAT_ROW
        orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW
#26 0x0000557674c795d7 in mysql_parse (thd=0x7ff24c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at ./sql/sql_parse.cc:8037
        found_semicolon = <optimized out>
        error = <optimized out>
        lex = 0x7ff24c004de0
        err = <optimized out>
#27 0x0000557674c85825 in dispatch_command (command=COM_QUERY, thd=0x7ff24c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at ./sql/sql_class.h:1370
        packet_end = 0x7ff24c0589b9 ""
        parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7ff24c000c58, m_ptr = 0x7ff24c0589ba "\b", m_tok_start = 0x7ff24c0589ba "\b", m_tok_end = 0x7ff24c0589ba "\b", m_end_of_query = 0x7ff24c0589b9 "", m_tok_start_prev = 0x7ff24c0589b9 "", m_buf = 0x7ff24c0589a0 "OPTIMIZE TABLE `oc_cards`", m_buf_length = 25, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff24c058a18 "OPTIMIZE TABLE `oc_cards`", m_cpp_ptr = 0x7ff24c058a31 "", m_cpp_tok_start = 0x7ff24c058a31 "", m_cpp_tok_start_prev = 0x7ff24c058a31 "", m_cpp_tok_end = 0x7ff24c058a31 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff24c058a28 "oc_cards`", m_cpp_text_end = 0x7ff24c058a30 "`", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_UNLOCK, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7ff24c004810}
        net = 0x7ff24c000f08
        error = false
        do_end_of_statement = true
        __FUNCTION__ = "dispatch_command"
        res = <optimized out>
#28 0x0000557674c87a7e in do_command (thd=0x7ff24c000c58, blocking=blocking@entry=true) at ./sql/sql_parse.cc:1407
        return_value = <optimized out>
        packet = 0x7ff24c0085d8 "\002"
        packet_length = <optimized out>
        net = 0x7ff24c000f08
        command = COM_QUERY
        __FUNCTION__ = "do_command"
#29 0x0000557674daa917 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at ./sql/sql_connect.cc:1416
        create_user = true
        thr_create_utime = <optimized out>
        thd = 0x7ff24c000c58
#30 0x0000557674daac6d in handle_one_connection (arg=arg@entry=0x55767802abe8) at ./sql/sql_connect.cc:1318
        connect = 0x55767802abe8
#31 0x00005576750fec96 in pfs_spawn_thread (arg=0x55767802ac58) at ./storage/perfschema/pfs.cc:2201
        typed_arg = 0x55767802ac58
        user_arg = 0x55767802abe8
        user_start_routine = 0x557674daac10 <handle_one_connection(void*)>
        pfs = <optimized out>
        klass = <optimized out>
#32 0x00007ff41cb32609 in start_thread (arg=<optimized out>) at pthread_create.c:477
        ret = <optimized out>
        pd = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140685211330304, 5631586341543191136, 140734346376110, 140734346376111, 93967270871776, 140685211328256, -5638293535366077856, -5634195999430958496}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
        not_first_call = 0
#33 0x00007ff41c3fc133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
No locals.

Comment by Pablo Catalina [ 2022-11-23 ]

Hi,

seems that the issue is still affecting the new version (10.9.4+maria~ubu2004)

Attached new backtrace.

Comment by Sergei Golubchik [ 2022-11-24 ]

This is expected. See the Fix Version/s field of this issue — it says that the issue was fixed in 10.9.5.
You can find the planned release date for 10.9.5 at https://jira.mariadb.org/

Comment by Pablo Catalina [ 2023-01-09 ]

Hi,

I just upgraded to 10.10.2 but the issue is not fixed:

MariaDB 10.10.2 Optimize tables crash backtrace

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1  0x000055f18ab1f7df in my_write_core (sig=sig@entry=6) at ./mysys/stacktrace.c:424
#2  0x000055f18a5efea0 in handle_fatal_signal (sig=6) at ./sql/signal_handler.cc:355
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x00007fe468eff859 in __GI_abort () at abort.c:79
#6  0x000055f18a2226a0 in ut_dbg_assertion_failed (expr=expr@entry=0x55f18adb1770 "i + PAGE_HEAP_NO_USER_LOW == n_heap", 
    file=file@entry=0x55f18adb13d0 "/home/buildbot/buildbot/build/mariadb-10.10.2/storage/innobase/page/page0zip.cc", line=line@entry=760) at ./storage/innobase/ut/ut0dbg.cc:60
#7  0x000055f18a20e33c in page_zip_dir_encode (recs=0x7fe29c591520, buf=<optimized out>, page=0x7fe3f25bc000 "") at ./storage/innobase/page/page0zip.cc:760
#8  page_zip_compress (block=0x7fe3f10b3900, index=0x7fe29c2ab3d0, level=<optimized out>, mtr=mtr@entry=0x7fe29c34ba18) at ./storage/innobase/page/page0zip.cc:1431
#9  0x000055f18a9f6d16 in PageBulk::compress (this=0x7fe29c34ba08) at ./storage/innobase/btr/btr0bulk.cc:579
#10 BtrBulk::pageCommit (this=0x7fe29c29dc08, page_bulk=0x7fe29c34ba08, next_page_bulk=0x7fe4201dece0, insert_father=<optimized out>) at ./storage/innobase/btr/btr0bulk.cc:949
#11 0x000055f18a9f7124 in BtrBulk::pageSplit (this=0x7fe29c29dc08, page_bulk=0x7fe29c34ba08, next_page_bulk=0x7fe29c2ba668) at ./storage/innobase/btr/btr0bulk.cc:902
#12 0x000055f18a9f6653 in BtrBulk::insert (this=this@entry=0x7fe29c29dc08, tuple=tuple@entry=0x7fe29c266730, level=level@entry=0) at ./storage/innobase/btr/btr0bulk.cc:1084
#13 0x000055f18a9775ed in BtrBulk::insert (tuple=0x7fe29c266730, this=0x7fe29c29dc08) at ./storage/innobase/include/btr0bulk.h:301
#14 row_merge_insert_index_tuples (index=0x7fe29c2ab3d0, old_table=0x55f18dc72890, fd=..., block=0x0, row_buf=0x7fe29c1854b0, btr_bulk=0x7fe29c29dc08, table_total_rows=613, pct_progress=0, pct_cost=25, crypt_block=0x0, 
    space=61958, stage=0x0, blob_file=0x0) at ./storage/innobase/row/row0merge.cc:3906
#15 0x000055f18a9807c6 in row_merge_read_clustered_index (trx=<optimized out>, table=<optimized out>, old_table=<optimized out>, new_table=<optimized out>, online=<optimized out>, index=<optimized out>, 
    fts_sort_idx=<optimized out>, psort_info=<optimized out>, files=<optimized out>, key_numbers=<optimized out>, n_index=<optimized out>, defaults=<optimized out>, add_v=<optimized out>, col_map=<optimized out>, 
    add_autoinc=<optimized out>, sequence=..., block=<optimized out>, skip_pk_sort=<optimized out>, tmpfd=<optimized out>, stage=<optimized out>, pct_cost=<optimized out>, crypt_block=<optimized out>, eval_table=<optimized out>, 
    allow_not_null=<optimized out>, col_collate=<optimized out>) at ./storage/innobase/include/os0file.h:82
#16 0x000055f18a9814c4 in row_merge_build_indexes (trx=0x7fe43c261b80, old_table=0x55f18dc72890, new_table=0x7fe29c2987c0, online=true, indexes=0x7fe29c2840f0, key_numbers=0x7fe29c284108, n_indexes=3, table=0x7fe4201e0bb0, 
    defaults=0x0, col_map=0x7fe29c2be978, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x55f18e0b7778, add_v=0x0, eval_table=0x7fe4201e0bb0, allow_not_null=false, col_collate=0x0)
    at ./storage/innobase/row/row0merge.cc:4823
#17 0x000055f18a8ed7af in ha_innobase::inplace_alter_table (this=0x7fe29c2b1890, altered_table=0x7fe4201e0bb0, ha_alter_info=0x7fe4201e0af0) at /usr/include/c++/9/bits/stl_map.h:463
#18 0x000055f18a45d0c0 in handler::ha_inplace_alter_table (ha_alter_info=0x7fe4201e0af0, altered_table=0x7fe4201e0bb0, this=<optimized out>) at ./sql/handler.h:4633
#19 mysql_inplace_alter_table (target_mdl_request=0x7fe4201e1380, if_exists=false, start_alter_id=@0x7fe4201e0a30: 0, partial_alter=@0x7fe4201e0a27: false, alter_ctx=0x7fe4201e2510, trigger_param=0x7fe4201e0f70, 
    ddl_log_state=0x7fe4201e0a90, ha_alter_info=0x7fe4201e0af0, altered_table=0x7fe4201e0bb0, table=0x7fe2c519ff88, table_list=0x7fe29c0590f0, thd=0x7fe29c000c58) at ./sql/sql_table.cc:7676
#20 mysql_alter_table (thd=0x7fe29c000c58, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=<optimized out>, alter_info=<optimized out>, order_num=0, order=0x0, ignore=false, 
    if_exists=false) at ./sql/sql_table.cc:10772
#21 0x000055f18a45dbdf in mysql_recreate_table (thd=thd@entry=0x7fe29c000c58, table_list=table_list@entry=0x7fe29c0590f0, table_copy=table_copy@entry=false) at ./sql/sql_table.cc:11869
#22 0x000055f18a4cfded in admin_recreate_table (thd=thd@entry=0x7fe29c000c58, table_list=table_list@entry=0x7fe29c0590f0) at ./sql/sql_class.h:5032
#23 0x000055f18a4d2664 in mysql_admin_table (thd=<optimized out>, tables=0x7fe29c0590f0, check_opt=0x7fe29c0061a8, operator_name=0x55f18b277d60 <msg_optimize>, lock_type=TL_WRITE, org_open_for_modify=true, 
    repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=<optimized out>, view_operator_func=0x0, is_cmd_replicated=true) at ./sql/sql_admin.cc:1131
#24 0x000055f18a4d3fd5 in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x7fe29c000c58) at ./sql/sql_admin.cc:1511
#25 0x000055f18a3a17ae in mysql_execute_command (thd=0x7fe29c000c58, is_called_from_prepared_stmt=<optimized out>) at ./sql/sql_parse.cc:5997
#26 0x000055f18a3913b7 in mysql_parse (thd=0x7fe29c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at ./sql/sql_parse.cc:8021
#27 0x000055f18a39d875 in dispatch_command (command=COM_QUERY, thd=0x7fe29c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at ./sql/sql_class.h:1346
#28 0x000055f18a39f97e in do_command (thd=0x7fe29c000c58, blocking=blocking@entry=true) at ./sql/sql_parse.cc:1407
#29 0x000055f18a4c4707 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at ./sql/sql_connect.cc:1416
#30 0x000055f18a4c4a5d in handle_one_connection (arg=arg@entry=0x55f18e21c338) at ./sql/sql_connect.cc:1318
#31 0x000055f18a819d56 in pfs_spawn_thread (arg=0x55f18e21c3a8) at ./storage/perfschema/pfs.cc:2201
#32 0x00007fe4697e9609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#33 0x00007fe468ffc133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Generated at Thu Feb 08 10:09:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.