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

mysqld segfault - signal 11 - optimizer get_best_combination

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

          Ascending order - Click to sort in descending order
          MartinR Martin Roman created issue -
          MartinR Martin Roman made changes -
          Field Original Value New Value
          Attachment x_bpej.sql [ 54711 ]
          danblack Daniel Black made changes -
          Labels crash crash need_feedback
          danblack Daniel Black made changes -
          Summary mysqld segfault - signal 11 mysqld segfault - signal 11 - optimizer get_best_combination
          danblack Daniel Black made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Cannot Reproduce [ 5 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 115501 ] MariaDB v4 [ 158555 ]

          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.