#30023: SQLite schema editor can cause table corruption if used within a
transaction since Django 2.0
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: Simon
| Charette
Type: Bug | Status: closed
Component: Migrations | Version: 2.0
Severity: Release blocker | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Simon Charette <charette.s@…>):
In [changeset:"ecece1b22e35865cee429e239bcdd19f01925c9d" ecece1b2]:
{{{
#!CommitTicketReference repository=""
revision="ecece1b22e35865cee429e239bcdd19f01925c9d"
[2.0.x] Fixed #30023 -- Prevented SQLite schema alterations while foreign
key checks are enabled.
Prior to this change foreign key constraint references could be left
pointing
at tables dropped during operations simulating unsupported table
alterations
because of an unexpected failure to disable foreign key constraint checks.
SQLite3 does not allow disabling such checks while in a transaction so
they
must be disabled beforehand.
Thanks ezaquarii for the report and Carlton and Tim for the review.
Backport of 315357ad25a6590e7f4564ec2e56a22132b09001 from master.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30023#comment:8>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.59fdf9eafdbd3fe9ab7a0f84365b24a8%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
