Skip to content

[Bug]: Mysql crash after connection abort with error #87

Open

Description

@holiday-404

What happened?

Steps to Reproduce

Environment

  • OS:
  • Version:
  • Any other relevant details:

Activity

  1. holiday-404 commented on Jul 31, 2025

    @holiday-404
    CollaboratorAuthor
    1. mariadb_src:
      branch: txlog_minio_support_mtr
      hash: 2c1aa6f788bdb

    2. eloq_engine_for_mariadb
      branch: txlog_minio_support_mtr
      hash: b7110e6ece31b

    3. tx_service
      branch: main
      hash: 3f7df1ac4b9

    4. raft_host_manager
      branch: main
      hash: 3f7df1ac4b9

    5. log_service
      branch: txlog_minio_support_mtr
      hash: 5896f06571c7b

    6. store_handler
      branch: txlog_minio_support_mtr
      hash: 86e6963ba07

  2. holiday-404 commented on Jul 31, 2025

    @holiday-404
    CollaboratorAuthor

    [time 2025-07-16T11:57:09.054311] [level WARNING] [thread 52949] [sql_class.h:5238] Aborted connection 322 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets)

    250716 11:57:09 [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.6.10-MariaDB-debug-log
    key_buffer_size=1048576
    read_buffer_size=131072
    max_used_connections=3
    max_threads=65537
    thread_count=1
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 25171359 K bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    Thread pointer: 0x786ea8188c68
    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 = 0x786ea8129bf8 thread_stack 0x49000
    /home/mono/workspace/mariadb/bld/sql/mariadbd(my_print_stacktrace+0x44)[0x6339bda3ae3f]
    /home/mono/workspace/mariadb/bld/sql/mariadbd(handle_fatal_signal+0x415)[0x6339bd11eecb]
    ??:0(__restore_rt)[0x78701a5eb420]
    mysys/list.c:34(list_add)[0x6339bda0e503]
    sql/threadpool_generic.cc:2862(coro_mutex_lock(st_mysql_mutex*, char const*, unsigned int))[0x6339bd048c70]
    sql/sql_class.cc:2180(THD::reset_killed())[0x6339bcccc0e8]
    sql/sql_class.h:4684(THD::reset_kill_query())[0x6339bcd6b122]
    sql/sql_parse.cc:1650(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x6339bcd4e2d7]
    sql/sql_parse.cc:1429(do_command(THD*, bool))[0x6339bcd4dadb]
    sql/threadpool_common.cc:752(SqlCmdCoroutine(boost::context::continuation&&, THD*))[0x6339bd051b57]
    bits/invoke.h:60(boost::context::continuation std::__invoke_impl<boost::context::continuation, boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation, THD*&>(std::__invoke_other, boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation&&, THD*&))[0x6339bd0568cf]
    bits/invoke.h:97(std::__invoke_result<boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation, THD*&>::type std::__invoke<boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation, THD*&>(boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation&&, THD*&))[0x6339bd0566f0]
    9/functional:403(boost::context::continuation std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>::__call<boost::context::continuation, boost::context::continuation&&, 0ul, 1ul>(std::tupleboost::context::continuation&&&&, std::_Index_tuple<0ul, 1ul>))[0x6339bd0564f0]
    9/functional:485(boost::context::continuation std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>::operator()<boost::context::continuation, boo
    st::context::continuation>(boost::context::continuation&&))[0x6339bd0563a9]
    bits/invoke.h:60(boost::context::continuation std::__invoke_impl<boost::context::continuation, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>(std::__invoke_other, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation&&))[0x6339bd0562d9]
    bits/invoke.h:97(std::__invoke_result<std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>::type std::__invoke<std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>(std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation&&))[0x6339bd056121]
    9/functional:83(std::invoke_result<std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>::type std::invoke<std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>(std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation&&))[0x6339bd055e33]
    context/continuation_fcontext.hpp:146(boost::context::detail::record<boost::context::continuation, THD::NoopAllocator, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)> >::run(void*))[0x6339bd055b3c]
    context/continuation_fcontext.hpp:80(void boost::context::detail::context_entry<boost::context::detail::record<boost::context::continuation, THD::NoopAllocator, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)> > >(boost::context::detail::transfer_t))[0x6339bd055763]
    ??:0(make_fcontext)[0x78701a6741cf]

  3. holiday-404 commented on Jul 31, 2025

    @holiday-404
    CollaboratorAuthor

    (gdb) bt
    #0 0x000078701a5e7f68 in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0
    eloqdata/eloqdoc#1 0x00006339bda3af35 in my_write_core (sig=11) at /home/mono/workspace/mariadb/mysys/stacktrace.c:424
    eloqdata/eloqdoc#2 0x00006339bd11f212 in handle_fatal_signal (sig=11) at /home/mono/workspace/mariadb/sql/signal_handler.cc:361
    eloqdata/eloqdoc#3
    eloqdata/eloqdoc#4 0x00006339bda0e503 in list_add (root=0x786ea9fe1ef0, element=0x786ea818aaa8) at /home/mono/workspace/mariadb/mysys/list.c:34
    eloqdata/eloqdoc#5 0x00006339bd048c70 in coro_mutex_lock (that=0x786ea818aa00, src_file=0x6339bdb42ef8 "/home/mono/workspace/mariadb/sql/sql_class.cc", src_line=2179)
    at /home/mono/workspace/mariadb/sql/threadpool_generic.cc:2862
    eloqdata/eloqdoc#6 0x00006339bcccc0e8 in THD::reset_killed (this=0x786ea8188c68) at /home/mono/workspace/mariadb/sql/sql_class.cc:2179
    eloqdata/eloqdoc#7 0x00006339bcd6b122 in THD::reset_kill_query (this=0x786ea8188c68) at /home/mono/workspace/mariadb/sql/sql_class.h:4683
    eloqdata/eloqdoc#8 0x00006339bcd4e2d7 in dispatch_command (command=COM_QUERY, thd=0x786ea8188c68, packet=0x786ea83b0269 "SHOW STATUS LIKE 'Threads_connected'", packet_length=36, blocking=false)
    at /home/mono/workspace/mariadb/sql/sql_parse.cc:1648
    eloqdata/eloqdoc#9 0x00006339bcd4dadb in do_command (thd=0x786ea8188c68, blocking=false) at /home/mono/workspace/mariadb/sql/sql_parse.cc:1429
    eloqdata/eloqdoc#10 0x00006339bd051b57 in SqlCmdCoroutine (caller=..., thd=0x786ea8188c68) at /home/mono/workspace/mariadb/sql/threadpool_common.cc:752
    eloqdata/eloqdoc#11 0x00006339bd0568cf in std::__invoke_impl<boost::context::continuation, boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation, THD*&> (
    __f=@0x786ea8129f18: 0x6339bd051a45 <SqlCmdCoroutine(boost::context::continuation&&, THD*)>) at /usr/include/c++/9/bits/invoke.h:60
    eloqdata/eloqdoc#12 0x00006339bd0566f0 in std::__invoke<boost::context::continuation (&)(boost::context::continuation&&, THD), boost::context::continuation, THD*&> (
    __fn=@0x786ea8129f18: 0x6339bd051a45 <SqlCmdCoroutine(boost::context::continuation&&, THD*)>) at /usr/include/c++/9/bits/invoke.h:96
    eloqdata/eloqdoc#13 0x00006339bd0564f0 in std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>::__call<boost::context::continuation, boost::context::continuation&&, 0ul, 1ul>(std::tupleboost::context::continuation&&&&, std::_Index_tuple<0ul, 1ul>) (this=0x786ea8129f18, __args=...) at /usr/include/c++/9/functional:402
    eloqdata/eloqdoc#14 0x00006339bd0563a9 in std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>::operator()<boost::context::continuation, boost::context::continuation>(boost::context::continuation&&) (this=0x786ea8129f18) at /usr/include/c++/9/functional:484
    eloqdata/eloqdoc#15 0x00006339bd0562d9 in std::__invoke_impl<boost::context::continuation, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>(std::__invoke_other, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation&&) (__f=...)
    at /usr/include/c++/9/bits/invoke.h:60
    eloqdata/eloqdoc#16 0x00006339bd056121 in std::__invoke<std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>(std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation&&) (__fn=...) at /usr/include/c++/9/bits/invoke.h:96
    eloqdata/eloqdoc#17 0x00006339bd055e33 in std::invoke<std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation>(std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)>&, boost::context::continuation&&) (__fn=...) at /usr/include/c++/9/functional:82
    eloqdata/eloqdoc#18 0x00006339bd055b3c in boost::context::detail::record<boost::context::continuation, THD::NoopAllocator, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)> >::run(void*) (this=0x786ea8129f00, fctx=0x786ff009ed80) at /usr/include/boost/context/continuation_fcontext.hpp:146
    eloqdata/eloqdoc#19 0x00006339bd055763 in boost::context::detail::context_entry<boost::context::detail::record<boost::context::continuation, THD::NoopAllocator, std::_Bind<boost::context::continuation ((std::_Placeholder<1>, THD))(boost::context::continuation&&, THD*)> > >(boost::context::detail::transfer_t) (t=...) at /usr/include/boost/context/continuation_fcontext.hpp:80
    eloqdata/eloqdoc#20 0x000078701a6741cf in make_fcontext () from /lib/x86_64-linux-gnu/libboost_context.so.1.71.0
    eloqdata/eloqdoc#21 0x0000000000000000 in ?? ()

  4. transferred this issue fromeloqdata/eloqdocon Aug 26, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions