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

Crash in rec_get_offsets_func() due to invalid rec_get_status()

    XMLWordPrintable

Details

    Description

      where to begin.....

      Over the last 24 hours i've had 3 (out of 5 total) mariadb production servers crash with similar errors (see attachment).

      Each server has about 30 customer databases (identical structure) that customers connect to from an indentical win32 desktop using ODBC.

      INNODB tables.

      Not aware of any changes to the servers or the databases or the win32.exe.

      On each server there has been, since yesterday, one database where if i run a couple of specific but seemingly innocuous queries the server crashes and restarts.

      The error mentions an index.... so in each of the queries i (eventually) removed the indexes used by a subquery. and hey presto no crash. slow but no crash.

      I must emphasise that i only removed the indexes from the one database on each server that was mentioned in the crash report. The other databases with the same structure on the same servers continue to work just fine with the same queries and the same indexes . And the database that are causing a crash have been same structure running same queries for months and months.

      the databases causing the error are no larger than any of the others (a few thousand records in the deal and invoices tables).

      i removed the indexes on invoices,dealid invoices.who invoices.term invoices.invoice deal.dealid

      .dealid and .invoice and .term are int 11; .who is varchar 10

      the other query that causes a crash is an update and uses invoice.invoice in a subquery

      again, to emphasise, this query has been run a thousand times a day on 200 or more databases for more than a year with no problem... until yesterday on 3 databases

      Attachments

        1. crashdump.txt
          42 kB
          Nigel Gomm
        2. mariaerror.txt
          7 kB
          Nigel Gomm

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              nigelgomm Nigel Gomm
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.