Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 10.0.16
-
Fix Version/s: N/A
-
Component/s: Data Manipulation - Update, Documentation
-
Labels:None
-
Environment:See mdev-7367
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
"""
Gliffy Diagrams
Attachments
Issue Links
- is part of
-
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
All data moved to the original report, and it's updated further. Closing this one as s duplicate.
Hi Marlon,
Indeed, your email from Jan 08 seems to have gone nowhere, I can't find any indication of it. Maybe a JIRA glitch, or something.
What for your comment of 2015-02-26 staying unnoticed, it's my fault.
I'll re-open
MDEV-7367and will copy your attachments to it, to preserve all history in one place.Sorry for the inconvenience.