Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.9.3, 10.9.4, 10.10.2
-
None
-
Ubuntu 20.04 + MariaDB as network server
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)}}
Attachments
Issue Links
- duplicates
-
MDEV-28797 Assertion `page_rec_is_user_rec(rec)' failed in PageBulk::getSplitRec
-
- Closed
-
Activity
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).
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.
|
Hi,
seems that the issue is still affecting the new version (10.9.4+maria~ubu2004)
Attached new backtrace.
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/
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
|
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.
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.