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

MariaDB hang at MDL_context::acquire_lock , and thread pool was blocked, could not create additional thread to handle queries

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.19
    • N/A
    • None
    • suse 11 SP1 x86_64

    Description

      Thread 346 (Thread 0x7faf2583f700 (LWP 198744)):
      #0  0x00007fb079c6a879 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
      #1  0x0000000000675e9c in MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, PSI_stage_info_v1 const*) ()
      #2  0x000000000067869b in MDL_context::acquire_lock(MDL_request*, unsigned long) ()
      #3  0x000000000055524e in open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, unsigned int, MDL_ticket**) ()
      #4  0x0000000000556f22 in open_table(THD*, TABLE_LIST*, st_mem_root*, Open_table_context*) ()
      #5  0x0000000000558a7a in open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) ()
      #6  0x0000000000558dcb in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) ()
      #7  0x0000000000584a8c in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) ()
      #8  0x000000000059e47e in mysql_execute_command(THD*) ()
      #9  0x000000000085e176 in mysql_open_cursor(THD*, select_result*, Server_side_cursor**) ()
      #10 0x00000000005ac224 in Prepared_statement::execute(String*, bool) ()
      #11 0x00000000005b00fa in Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) ()
      #12 0x00000000005b0754 in mysqld_stmt_execute(THD*, char*, unsigned int) ()
      #13 0x00000000005a08da in dispatch_command(enum_server_command, THD*, char*, unsigned int) ()
      #14 0x00000000005a1ed9 in do_command(THD*) ()
      #15 0x00000000006b6798 in threadpool_process_request(THD*) ()
      #16 0x00000000006f3818 in worker_main(void*) ()
      #17 0x00007fb079c666a6 in start_thread () from /lib64/libpthread.so.0
      #18 0x00007fb078c29ccd in clone () from /lib64/libc.so.6
      #19 0x0000000000000000 in ?? ()
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            catofpei catofpei
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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