[MDEV-7851] More info about MDEV-7367: Updating a virtual column corrupts table which crashes server Created: 2015-03-26  Updated: 2015-03-27  Resolved: 2015-03-27

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update, Documentation
Affects Version/s: 10.0.16
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Marlon Griffith Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

See mdev-7367

Attachments: File grad_degree_build_bug.sql     File gso_grad_supr.csv    
Issue Links:
PartOf
is part of MDEV-7367 Updating a virtual column corrupts ta... Closed

 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
"""

 Comments   
Comment by Elena Stepanova [ 2015-03-27 ]

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-7367 and will copy your attachments to it, to preserve all history in one place.
Sorry for the inconvenience.

Comment by Elena Stepanova [ 2015-03-27 ]

All data moved to the original report, and it's updated further. Closing this one as s duplicate.

Generated at Thu Feb 08 07:22:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.