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

MariaDB crashes executing attached query

    XMLWordPrintable

    Details

      Description

      When creating the database "debug" using the attached SQL statements in debug.sql and then executing the attachedf query error.sql, the database server crashes producing the following stack trace in my systemd-journal:

      Okt 24 15:11:55 nuc mysqld[2726]: 151024 15:11:55 [ERROR] mysqld got signal 11 ;
      Okt 24 15:11:55 nuc mysqld[2726]: This could be because you hit a bug. It is also possible that this binary
      Okt 24 15:11:55 nuc mysqld[2726]: or one of the libraries it was linked against is corrupt, improperly built,
      Okt 24 15:11:55 nuc mysqld[2726]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Okt 24 15:11:55 nuc mysqld[2726]: To report this bug, see http://kb.askmonty.org/en/reporting-bugs
      Okt 24 15:11:55 nuc mysqld[2726]: We will try our best to scrape up some info that will hopefully help
      Okt 24 15:11:55 nuc mysqld[2726]: diagnose the problem, but since we have already crashed,
      Okt 24 15:11:55 nuc mysqld[2726]: something is definitely wrong and this may fail.
      Okt 24 15:11:55 nuc mysqld[2726]: Server version: 10.0.21-MariaDB-log
      Okt 24 15:11:55 nuc mysqld[2726]: key_buffer_size=16777216
      Okt 24 15:11:55 nuc mysqld[2726]: read_buffer_size=262144
      Okt 24 15:11:55 nuc mysqld[2726]: max_used_connections=11
      Okt 24 15:11:55 nuc mysqld[2726]: max_threads=153
      Okt 24 15:11:55 nuc mysqld[2726]: thread_count=11
      Okt 24 15:11:55 nuc mysqld[2726]: It is possible that mysqld could use up to
      Okt 24 15:11:55 nuc mysqld[2726]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 136891 K  bytes of memory
      Okt 24 15:11:55 nuc mysqld[2726]: Hope that's ok; if not, decrease some variables in the equation.
      Okt 24 15:11:55 nuc mysqld[2726]: Thread pointer: 0x0x7fa1c261f148
      Okt 24 15:11:55 nuc mysqld[2726]: Attempting backtrace. You can use the following information to find out
      Okt 24 15:11:55 nuc mysqld[2726]: where mysqld died. If you see no messages after this, something went
      Okt 24 15:11:55 nuc mysqld[2726]: terribly wrong...
      Okt 24 15:11:55 nuc mysqld[2726]: stack_bottom = 0x7fa1d3319e80 thread_stack 0x48000
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(my_print_stacktrace+0x3d)[0x5623bfd8c56d]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(handle_fatal_signal+0x33d)[0x5623bf90358d]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/lib/libpthread.so.0(+0x10d60)[0x7fa1e4b5dd60]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_ZN10Item_fieldC2EP5Field+0x9)[0x5623bf91d429]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_ZN14Item_subselect18get_tmp_table_itemEP3THD+0x6e)[0x5623bf982efe]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_ZN20Item_direct_view_ref18get_tmp_table_itemEP3THD+0x11)[0x5623bf92a161]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_ZN4JOIN10exec_innerEv+0x19bc)[0x5623bf7fa3ac]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_ZN4JOIN4execEv+0x11)[0x5623bf7fb111]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1f9)[0x5623bf7f7db9]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x172)[0x5623bf7f8602]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(+0x3c0b79)[0x5623bf79ab79]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_Z21mysql_execute_commandP3THD+0x5a09)[0x5623bf7a7249]
      Okt 24 15:11:55 nuc mysqld[2726]: /usr/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e2)[0x5623bf7a8f42]
      Okt 24 15:11:55 nuc systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
      Okt 24 15:11:55 nuc systemd[1]: mysqld.service: Unit entered failed state.
      Okt 24 15:11:55 nuc systemd[1]: mysqld.service: Failed with result 'exit-code'.
      Okt 24 15:11:55 nuc systemd[1]: mysqld.service: Service hold-off time over, scheduling restart.
      Okt 24 15:11:56 nuc systemd[1]: Stopped MariaDB database server.

      The database is used for a Kodi library. If you omit the "ORDER BY" part of the query, there will be no error.

        Attachments

        1. debug.sql
          30 kB
        2. error.sql
          0.2 kB
        3. my.cnf
          5 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              Brinox Jan Hicken
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: