Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21657

Crash in has_stronger_or_equal_type Query doing a LOCK TABLE

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.11
    • 10.4
    • Server
    • None
    • Ubuntu 18.04.3 LTS

    Description

      With a chanche of something like 1 in 1milion
      While performing LOCK TABLE scraper.url WRITE, scraper.keyword WRITE
      The server crash with following stacktrace

      [ERROR] mysqld got signal 11 ;
       
      stack_bottom = 0x7fa5800efdd8 thread_stack 0x49000
      /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x564d845011de]
      /usr/sbin/mysqld(handle_fatal_signal+0x515)[0x564d83f762f5]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7fb5d9dca890]
      /usr/sbin/mysqld(_ZNK10MDL_ticket26has_stronger_or_equal_typeE13enum_mdl_type+0x18)[0x564d83e526a8]
      /usr/sbin/mysqld(_ZN11MDL_context11find_ticketEP11MDL_requestP17enum_mdl_duration+0xbc)[0x564d83e5280c]
      /usr/sbin/mysqld(_ZN11MDL_context21try_acquire_lock_implEP11MDL_requestPP10MDL_ticket+0x2b)[0x564d83e539bb]
      /usr/sbin/mysqld(_ZN11MDL_context12acquire_lockEP11MDL_requestd+0x2e)[0x564d83e53bae]
      /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x52f)[0x564d83d00e9f]
      /usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xc13)[0x564d83d04753]
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x7f9b)[0x564d83d698eb]
      /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x564d83d6a47a]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x13a1)[0x564d83d6ca01]
      /usr/sbin/mysqld(_Z10do_commandP3THD+0x148)[0x564d83d6e2d8]
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25e)[0x564d83e4a2ae]
      /usr/sbin/mysqld(handle_one_connection+0x3d)[0x564d83e4a36d]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7fb5d9dbf6db]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fb5d87e088f]
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              RoyBellingan Roy Bellingan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.