#30055: Drop support for SQLite < 3.8.3
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Tim
Type: | Graham
Cleanup/optimization | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham):
* cc: Simon Charette (added)
Comment:
I think I ran into this when adding Django 2.2 testing to django-hosts.
Travis CI still uses trusty (Ubuntu 14.04) by default which has SQLite
3.8.2. All the tests [https://travis-ci.org/jazzband/django-
hosts/jobs/483074583 failed] like this:
{{{
self = <django.db.backends.utils.CursorWrapper object at 0x2b19ed9ba9b0>
sql = '\n SELECT REFERRING.`id`,
REFERRING.`site_id` FROM `tests_author` as REFERRING\n ...
WHERE REFERRING.`site_id` IS NOT NULL AND REFERRED.`id` IS NULL\n
'
params = None
ignored_wrapper_args = (False, {'connection':
<django.db.backends.sqlite3.base.DatabaseWrapper object at
0x2b19ed23a390>, 'cursor': <django.db.backends.utils.CursorWrapper object
at 0x2b19ed9ba9b0>})
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
> return self.cursor.execute(sql)
}}}
and
{{{
self = <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at
0x2b19ed99d1f8>
query = '\n SELECT REFERRING.`id`,
REFERRING.`site_id` FROM `tests_author` as REFERRING\n ...
WHERE REFERRING.`site_id` IS NOT NULL AND REFERRED.`id` IS NULL\n
'
params = None
def execute(self, query, params=None):
if params is None:
> return Database.Cursor.execute(self, query)
E sqlite3.OperationalError: no such table: django_site
}}}
I think we should either warn about this in the documentation (e.g. if you
get this error, check your SQLite version) or add a SQLite version check
somewhere to show a helpful message.
I thought the issue was an unsupported query in
[https://github.com/django/django/blob/bff748df3e1e1c0077e02df2b77bda2b827ad129/django/db/backends/sqlite3/base.py#L315-L336
DatabaseWrapper.check_constraints()] but I bisected the failures to
7289874adceec46b5367ec3157cdd10c711253a0.
More investigation might be needed to ensure that SQLite 3.8.3 resolves
this issue.
--
Ticket URL: <https://code.djangoproject.com/ticket/30055#comment:3>
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.f1eb946f236604d88d37d4cafe590390%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
