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

mysqld segfault - signal 11 - optimizer get_best_combination

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4.8
    • N/A
    • Server
    • Debian GNU/Linux 10 (buster)

    Description

      I'm getting MariaDB mysqld signal 11 error. It has appeared from one day to another and it looks to be caused by running the below query (a day before it worked fine) - no data is returned but the query generates relatively complex explain due to nested views. The error appears randomly. Could you please advice what to do with that?

      I'm enclosing the error log, the explain of the query, the query itself and source of the underlying view.

      Thank you.

      Martin

      SELECT 
          final_table.*
      FROM
          (SELECT 
              `x588_x_bpej_ku`.`nad1rok_druhpoz2` AS `x9064_nad1rok_druhpoz2`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz99_rsd` AS `x9096_trvaly_druhpoz99_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz3_firma` AS `x9069_trvaly_druhpoz3_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz4_obec` AS `x9074_trvaly_druhpoz4_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz5_kraj` AS `x9079_trvaly_druhpoz5_kraj`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz6_rsd` AS `x9084_trvaly_druhpoz6_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz7` AS `x9089_trvaly_druhpoz7`,
                  `x588_x_bpej_ku`.`trvaly_obec` AS `x9057_trvaly_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz2_obec` AS `x9062_trvaly_druhpoz2_obec`,
                  `x588_x_bpej_ku`.`nad1rok_druhpoz7` AS `x9094_nad1rok_druhpoz7`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz3_kraj` AS `x9067_trvaly_druhpoz3_kraj`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz99_firma` AS `x9099_trvaly_druhpoz99_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz4_rsd` AS `x9072_trvaly_druhpoz4_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz5` AS `x9077_trvaly_druhpoz5`,
                  `x588_x_bpej_ku`.`nad1rok_druhpoz5` AS `x9082_nad1rok_druhpoz5`,
                  `x588_x_bpej_ku`.`trvaly_rsd` AS `x9055_trvaly_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz6_firma` AS `x9087_trvaly_druhpoz6_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz2_rsd` AS `x9060_trvaly_druhpoz2_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz7_obec` AS `x9092_trvaly_druhpoz7_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz99_kraj` AS `x9097_trvaly_druhpoz99_kraj`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz3` AS `x9065_trvaly_druhpoz3`,
                  `x588_x_bpej_ku`.`nad1rok_druhpoz3` AS `x9070_nad1rok_druhpoz3`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz4_firma` AS `x9075_trvaly_druhpoz4_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz5_obec` AS `x9080_trvaly_druhpoz5_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz6_kraj` AS `x9085_trvaly_druhpoz6_kraj`,
                  `x588_x_bpej_ku`.`trvaly_firma` AS `x9058_trvaly_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz7_rsd` AS `x9090_trvaly_druhpoz7_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz2_firma` AS `x9063_trvaly_druhpoz2_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz99` AS `x9095_trvaly_druhpoz99`,
                  `x588_x_bpej_ku`.`nad1rok_druhpoz99` AS `x9100_nad1rok_druhpoz99`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz3_obec` AS `x9068_trvaly_druhpoz3_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz4_kraj` AS `x9073_trvaly_druhpoz4_kraj`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz5_rsd` AS `x9078_trvaly_druhpoz5_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz6` AS `x9083_trvaly_druhpoz6`,
                  `x588_x_bpej_ku`.`trvaly_kraj` AS `x9056_trvaly_kraj`,
                  `x588_x_bpej_ku`.`nad1rok_druhpoz6` AS `x9088_nad1rok_druhpoz6`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz7_firma` AS `x9093_trvaly_druhpoz7_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz2_kraj` AS `x9061_trvaly_druhpoz2_kraj`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz3_rsd` AS `x9066_trvaly_druhpoz3_rsd`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz99_obec` AS `x9098_trvaly_druhpoz99_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz4` AS `x9071_trvaly_druhpoz4`,
                  `x588_x_bpej_ku`.`nad1rok_druhpoz4` AS `x9076_nad1rok_druhpoz4`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz5_firma` AS `x9081_trvaly_druhpoz5_firma`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz6_obec` AS `x9086_trvaly_druhpoz6_obec`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz2` AS `x9059_trvaly_druhpoz2`,
                  `x588_x_bpej_ku`.`trvaly_druhpoz7_kraj` AS `x9091_trvaly_druhpoz7_kraj`,
                  `x588_x_bpej_ku`.`stavba` AS `x5398_stavba`,
                  `x588_x_bpej_ku`.`ku` AS `x5399_ku`,
                  `x588_x_bpej_ku`.`obec` AS `x5400_obec`,
                  `x588_x_bpej_ku`.`kraj` AS `x5401_kraj`,
                  `x588_x_bpej_ku`.`id_etapa` AS `x5402_id_etapa`,
                  `x588_x_bpej_ku`.`bpej` AS `x5403_bpej`,
                  `x588_x_bpej_ku`.`trvaly` AS `x5404_trvaly`,
                  `x588_x_bpej_ku`.`nad1rok` AS `x5405_nad1rok`
          FROM
              `x_bpej_ku` AS `x588_x_bpej_ku`) AS final_table
      WHERE
          (((`x5402_id_etapa` = '643')))
      

      Attachments

        1. error.log
          263 kB
        2. explain.txt
          30 kB
        3. view.sql
          5 kB
        4. x_bpej.sql
          2 kB

        Activity

          People

            Unassigned Unassigned
            MartinR Martin Roman
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.