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

Crash with dump file

Details

    Description

      Hi.
      An exception Error by "Sorry, we probably made a mistake, and this is a bug." thing.
      mini dump extracted.
      Plus, when you investigate the issue,
      also consider that from H/W failure that memory error which one of my headache to check.
      Thank you in advance.

      server.dll!my_uca_scanner_next_no_contractions_utf8mb4()[ctype-uca-scanner_next.inl:148]
      		 
      server.dll!my_uca_strnncollsp_onelevel_no_contractions_utf8mb4()[ctype-uca.inl:235]
      		 
      server.dll!my_uca_strnncollsp_no_contractions_utf8mb4()[ctype-uca.inl:282]
      		 
      server.dll!cmp_data()[rem0cmp.cc:294]
      		 
      server.dll!cmp_dtuple_rec_with_match_low()[rem0cmp.cc:405]
      		 
      server.dll!row_search_mvcc()[row0sel.cc:5067]
      		 
      server.dll!ha_innobase::index_read()[ha_innodb.cc:9037]
      		 
      server.dll!handler::ha_index_read_map()[handler.cc:3520]
      		 
      server.dll!ha_partition::handle_unordered_scan_next_partition()[ha_partition.cc:7834]
      		 
      server.dll!handler::ha_index_read_map()[handler.cc:3520]
      		 
      server.dll!join_read_key2()[sql_select.cc:23025]
      		 
      server.dll!sub_select()[sql_select.cc:22336]
      		 
      server.dll!evaluate_join_record()[sql_select.cc:22570]
      		 
      server.dll!sub_select()[sql_select.cc:22339]
      		 
      server.dll!evaluate_join_record()[sql_select.cc:22570]
      		 
      server.dll!sub_select()[sql_select.cc:22378]
      		 
      server.dll!do_select()[sql_select.cc:21862]
      		 
      server.dll!JOIN::exec_inner()[sql_select.cc:4910]
      		 
      server.dll!mysql_select()[sql_select.cc:5168]
      		 
      server.dll!handle_select()[sql_select.cc:588]
      		 
      server.dll!mysql_execute_command()[sql_parse.cc:4756]
      		 
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3923]
      		 
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
      		 
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
      		 
      server.dll!sp_head::execute()[sp_head.cc:1463]
      		 
      server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
      		 
      server.dll!do_execute_sp()[sql_parse.cc:3060]
      		 
      server.dll!Sql_cmd_call::execute()[sql_parse.cc:3302]
      		 
      server.dll!mysql_execute_command()[sql_parse.cc:6104]
      		 
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3923]
      		 
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
      		 
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
      		 
      server.dll!sp_head::execute()[sp_head.cc:1463]
      		 
      server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
      		 
      server.dll!do_execute_sp()[sql_parse.cc:3060]
      		 
      server.dll!Sql_cmd_call::execute()[sql_parse.cc:3302]
      		 
      server.dll!mysql_execute_command()[sql_parse.cc:6104]
      		 
      server.dll!Prepared_statement::execute()[sql_prepare.cc:5273]
      		 
      server.dll!Prepared_statement::execute_loop()[sql_prepare.cc:4674]
      		 
      server.dll!mysql_sql_stmt_execute()[sql_prepare.cc:3701]
      		 
      server.dll!mysql_execute_command()[sql_parse.cc:3997]
      		 
      server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3923]
      		 
      server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
      		 
      server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
      		 
      server.dll!sp_head::execute()[sp_head.cc:1463]
      		 
      server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
      		 
      server.dll!Event_job_data::execute()[event_data_objects.cc:1482]
      		 
      server.dll!event_worker_thread()[event_scheduler.cc:268]
      		 
      server.dll!pfs_spawn_thread()[pfs.cc:2204]
      		 
      server.dll!pthread_start()[my_winthread.c:62]
      		 
      ucrtbase.dll!_recalloc()
      		 
      KERNEL32.DLL!BaseThreadInitThunk()
      		 
      ntdll.dll!RtlUserThreadStart()

      Attachments

        1. analyze.txt
          26 kB
          Vladislav Vaintroub
        2. mysqld.dmp
          136 kB
          Mitchell Lee

        Activity

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik added a comment -

          Do you have any more information you can provide? Stack trace shows that you had an EVENT that used dynamic SQL — EXECUTE — to CALL a stored procedure that selected from a partitioned InnoDB table and at the end if crashed in the utf8mb4 string comparison code.

          Can you provide the code for the event and the stored procedure, and the said table definition?

          serg Sergei Golubchik added a comment - Do you have any more information you can provide? Stack trace shows that you had an EVENT that used dynamic SQL — EXECUTE — to CALL a stored procedure that selected from a partitioned InnoDB table and at the end if crashed in the utf8mb4 string comparison code. Can you provide the code for the event and the stored procedure, and the said table definition?
          npdmailing@gmail.com Mitchell Lee added a comment - - edited

          Can you let me know any of specific funtion name?
          for example, that utf conversion function name since have no idea what the code pointing at due to there is non of code conversion in SQL statements.
          And...
          Have no idea that what statement of procedure launches
          since there is tons of prcedure executing(which no explitcit utf conversion.).
          Give me some function name and any name that you expecting from dump file.
          With the stack frame, I have investigate already, no function indicates I'm using. (so report to you guys.)

          npdmailing@gmail.com Mitchell Lee added a comment - - edited Can you let me know any of specific funtion name? for example, that utf conversion function name since have no idea what the code pointing at due to there is non of code conversion in SQL statements. And... Have no idea that what statement of procedure launches since there is tons of prcedure executing(which no explitcit utf conversion.). Give me some function name and any name that you expecting from dump file. With the stack frame, I have investigate already, no function indicates I'm using. (so report to you guys.)
          npdmailing@gmail.com Mitchell Lee added a comment -

          Any of User space/area function name is okay. Just guide me.

          npdmailing@gmail.com Mitchell Lee added a comment - Any of User space/area function name is okay. Just guide me.
          serg Sergei Golubchik added a comment -

          I cannot see it from the stack trace. But look in the error log after the stack trace, there should be the query that caused the crash, that should help.

          serg Sergei Golubchik added a comment - I cannot see it from the stack trace. But look in the error log after the stack trace, there should be the query that caused the crash, that should help.
          npdmailing@gmail.com Mitchell Lee added a comment - - edited

          Then...the stacktrace sequence seems okay?
          Isn't there any non-sense path you can see? For example, impossible to get called between each link.
          If stacktrace it self seems not weird,you can close the issue. Let's treat the issue as H/W failure then.
          Thank you everytime.

          npdmailing@gmail.com Mitchell Lee added a comment - - edited Then...the stacktrace sequence seems okay? Isn't there any non-sense path you can see? For example, impossible to get called between each link. If stacktrace it self seems not weird,you can close the issue. Let's treat the issue as H/W failure then. Thank you everytime.
          wlad Vladislav Vaintroub added a comment - - edited

          analyze.txt
          Stacktrace seems OK. The attached analyze.txt I made out of memory dump is mostly the same, and contains exception record so we know that exception happened while trying to read from address 0xC000 , exact location of the crash

          server!my_uca_scanner_set_weight+0x8 [inlined in server!my_uca_scanner_next_no_contractions_utf8mb4+0xd1]:
          		 
          00007ffc`948d9781 498901          mov     qword ptr [r9],rax ds:00000022`a1df7770={server!nochar (00007ffc`950eae6c)}

          and thread context.

          But the memory dump is minimal, and mostly has stack in it, and no heap. So it does not have the SQL query . Error log does have the SQL query.

          wlad Vladislav Vaintroub added a comment - - edited analyze.txt Stacktrace seems OK. The attached analyze.txt I made out of memory dump is mostly the same, and contains exception record so we know that exception happened while trying to read from address 0xC000 , exact location of the crash server!my_uca_scanner_set_weight+0x8 [inlined in server!my_uca_scanner_next_no_contractions_utf8mb4+0xd1]: 00007ffc`948d9781 498901 mov qword ptr [r9],rax ds:00000022`a1df7770={server!nochar (00007ffc`950eae6c)} and thread context. But the memory dump is minimal, and mostly has stack in it, and no heap. So it does not have the SQL query . Error log does have the SQL query.
          npdmailing@gmail.com Mitchell Lee added a comment - - edited

          Thanks for the sharing.
          Only last question is that what do you think about 'server!nochar (00007ffc`950eae6c)'?
          Is that kinda "not a charactor to convert" a cause of the crash? like null pointer?

          or

          Any possiblity of a table partition broken should be cause of the crash?

          npdmailing@gmail.com Mitchell Lee added a comment - - edited Thanks for the sharing. Only last question is that what do you think about 'server!nochar (00007ffc`950eae6c)'? Is that kinda "not a charactor to convert" a cause of the crash? like null pointer? or Any possiblity of a table partition broken should be cause of the crash?
          wlad Vladislav Vaintroub added a comment - - edited

          server!nochar (00007ffc`950eae6c) refers to this array

          static const uint16 nochar[]= {0,0};

          in strings/ctype-uca.c

          wlad Vladislav Vaintroub added a comment - - edited server!nochar (00007ffc`950eae6c) refers to this array static const uint16 nochar[]= {0,0}; in strings/ctype-uca.c

          People

            Unassigned Unassigned
            npdmailing@gmail.com Mitchell Lee
            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.