再遇“含笑半步颠”，升级 MariaDB 10.6.16 的三个理由

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]> s
--------------
mysql Ver 15.1 Distrib 10.6.16-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.6.16-MariaDB-1:10.6.16+maria~ubu2004 mariadb.org binary distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb3
Conn. characterset: utf8mb3
UNIX socket: /run/mysqld/mysqld.sock
Uptime: 10 sec

Threads: 1 Questions: 4 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 0.400
--------------

231121 0:39:51 [ERROR] mysqld got signal 11 ;
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.4.12-MariaDB-1:10.4.12+maria~bionic
key_buffer_size=134217728
read_buffer_size=2097152
max_used_connections=1
max_threads=102
thread_count=7
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760255 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x55c6dce18858
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 = 0x7efe28147dd8 thread_stack 0x49000
mysqld(my_print_stacktrace+0x2e)[0x55c6d9b09c3e]
mysqld(handle_fatal_signal+0x515)[0x55c6d957dcf5]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7efe43934890]
mysqld(_ZN7Item_sp7cleanupEv+0x1b)[0x55c6d959b76b]
mysqld(_ZN12Item_func_sp7cleanupEv+0x18)[0x55c6d95e1598]
mysqld(_Z13cleanup_itemsP4Item+0x21)[0x55c6d9361b81]
mysqld(_ZN7sp_head7executeEP3THDb+0xa34)[0x55c6d92d37c4]
mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x808)[0x55c6d92d4e08]
mysqld(+0x657fe5)[0x55c6d9360fe5]
mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x166)[0x55c6d9362e76]
mysqld(_Z21mysql_execute_commandP3THD+0x1f2b)[0x55c6d936a16b]
mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x55c6d9370d7a]
mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x13a1)[0x55c6d9373311]
mysqld(_Z10do_commandP3THD+0x148)[0x55c6d9374be8]
mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25e)[0x55c6d9450dae]
mysqld(handle_one_connection+0x3d)[0x55c6d9450e6d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7efe439296db]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7efe4234b88f]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x55c6dce26ba0): CALL p1()
Connection ID (thread ID): 8
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