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

More info about MDEV-7367: Updating a virtual column corrupts table which crashes server

    Details

      Description

      Hello,

      I had to create a new bug because the previous bug had been closed.

      I had created a script to duplicate the bug accurately and emailed to the previous bug email. Apparently, it was not added and someone then closed the bug assuming no activity. Please correct this. It was quite annoying.

      Here is my previous email with the two script files:
      """
      Subject: [JIRA] (MDEV-7367) Updating a virtual column corrupts table which crashes server
      Date: Thu, 08 Jan 2015 11:48:04 -0500
      From: Marlon A. Griffith <m3griffi@uwaterloo.ca>
      To: Elena Stepanova (JIRA) <jira@mariadb.atlassian.net>

      Hello Elena,

      Here are my observations:

      • after eliminating most columns, I have tracked the bug to these combination of columns:
        • the ofis_deg_status and deg_as_of_term being updated in the same query in combination with an index on deg_as_of_term
        • the deg_as_of_term's index is corrupted and thus crashing the database server

      I have included two files:

      • grad_degree_build_bug.sql: manually follow the instructions to duplicate the bug
      • gso_grad_supr.csv: a sanitized version of, only, the relevant data to duplicate the bug

      Hope this helps,
      Marlon A. Griffith 519-885-1211 x38146
      """

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                m3griffi Marlon Griffith
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: