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

    XMLWordPrintable

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

        1. grad_degree_build_bug.sql
          6 kB
          Marlon Griffith
        2. gso_grad_supr.csv
          1 kB
          Marlon Griffith

        Issue Links

          Activity

            People

              Unassigned Unassigned
              m3griffi Marlon Griffith
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.