Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-04-12 Thread Django 
#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
-+-

Comment (by Wolph):

 Just a little heads-up for others having this issue when running Travis.
 Simply adding `dist: xenial` to your `.travis.yml` will most likely fix
 the issue for you :)

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.5fa7eceae6211ceabb927b0784c8c2fe%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-02-04 Thread Django 
#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
-+-

Comment (by Tim Graham ):

 In [changeset:"d5b43d7226730992f3875605355e7d17837810cd" d5b43d7]:
 {{{
 #!CommitTicketReference repository=""
 revision="d5b43d7226730992f3875605355e7d17837810cd"
 [2.2.x] Refs #30055 -- Bumped minimum SQLite version in GIS docs.

 Backport of 4763c9719135f4de17924d9c8524f1cfe41bc645 from master.
 }}}

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.c2784c336b7e0c94e705adb86087a9f7%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-02-04 Thread Django 
#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
-+-

Comment (by Tim Graham ):

 In [changeset:"4763c9719135f4de17924d9c8524f1cfe41bc645" 4763c971]:
 {{{
 #!CommitTicketReference repository=""
 revision="4763c9719135f4de17924d9c8524f1cfe41bc645"
 Refs #30055 -- Bumped minimum SQLite version in GIS docs.
 }}}

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.f6d146fb383ca04bfc43606316f84261%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-28 Thread Django 
#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
-+-

Comment (by Tim Graham ):

 In [changeset:"d3b4f4b9629f24a59082b74559d131dde592f9f7" d3b4f4b9]:
 {{{
 #!CommitTicketReference repository=""
 revision="d3b4f4b9629f24a59082b74559d131dde592f9f7"
 [2.2.x] Refs #30055 -- Added a helpful error when SQLite is too old.

 Backport of 7444f3252757ed4384623e5afd7dcfeef3e0c74e from master.
 }}}

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.0f083a846494ac07c7852803d0f64071%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-28 Thread Django 
#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
-+-

Comment (by GitHub ):

 In [changeset:"7444f3252757ed4384623e5afd7dcfeef3e0c74e" 7444f32]:
 {{{
 #!CommitTicketReference repository=""
 revision="7444f3252757ed4384623e5afd7dcfeef3e0c74e"
 Refs #30055 -- Added a helpful error when SQLite is too old.
 }}}

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.538eaaaf01bce20bd38b70a1e56a0212%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-26 Thread Django 
#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
-+-

Comment (by Tim Graham):

 Bisected the issue to 7289874adceec46b5367ec3157cdd10c711253a0. The
 addition of `self.connection.check_constraints()` in `__exit__()` is the
 cause. [https://github.com/django/django/pull/10903 PR] to (re)document
 (following its improper removal in
 7e8cf74dc74539f40f4cea53c1e8bba82791fcb6) that apps without migrations
 must not have relations to apps with migrations. This discussion should
 have been on #30033.

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.72ccea163001958363814ac18bd02b26%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-22 Thread Django 
#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
-+-

Comment (by Simon Charette):

 It's really odd that it fails on manual constraint checking as
 `connection.introspection.table_names` should only return existing table
 names (thus `django_site` should exist).

 Also
 
[https://github.com/django/django/blob/bff748df3e1e1c0077e02df2b77bda2b827ad129/django/db/backends/sqlite3/features.py#L42
 constraint checking should not be performed in the first place during
 tests on SQLite < 3.20]. I wonder if it has to do with something `pytest`
 or `pytest-django` does.

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.edd04f2aef14ce79010deac559939d28%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-22 Thread Django 
#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
-+-

Comment (by Tim Graham):

 The error above also reproduces on Ubuntu 16.04 (SQLite 3.11). I'll
 investigate later and follow up elsewhere as it doesn't seem related to
 this ticket.

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.893c00c006600699fb5e7fe55180bbc6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-22 Thread Django 
#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
-+-

Comment (by Simon Charette):

 > 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 think that at this point error'ing loudly when using SQLite < 3.8.3
 might be the best course of action, I foresee a lot of reports even if we
 document it.

 > More investigation might be needed to ensure that SQLite 3.8.3 resolves
 this issue.

 Agreed, it looks like yet another edge case might be at play here.

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.9a24a08dd7018d31320d745bbb4452ca%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2019-01-22 Thread Django 
#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 = 
 sql = '\nSELECT 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':
 , 'cursor': })
 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 = 
 query = '\nSELECT 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: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
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.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2018-12-22 Thread Django 
#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 ):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"d5af14aa84dc5ec913859e787b269fb8029d63cd" d5af14aa]:
 {{{
 #!CommitTicketReference repository=""
 revision="d5af14aa84dc5ec913859e787b269fb8029d63cd"
 Fixed #30055 -- Dropped support for SQLite < 3.8.3.
 }}}

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.86377678cb09663de745d96f0a9b8cc0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #30055: Drop support for SQLite < 3.8.3

2018-12-22 Thread Django 
#30055: Drop support for SQLite < 3.8.3
-+-
 Reporter:  Tim Graham   |Owner:  Tim
 Type:   |  Graham
  Cleanup/optimization   |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 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):

 * has_patch:  0 => 1


Comment:

 [https://github.com/django/django/pull/10782 PR]

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.3c6f74ae50e64cd02c7386a259103bf0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

[Django] #30055: Drop support for SQLite < 3.8.3

2018-12-22 Thread Django 
#30055: Drop support for SQLite < 3.8.3
-+-
   Reporter:  Tim|  Owner:  Tim Graham
  Graham |
   Type: | Status:  assigned
  Cleanup/optimization   |
  Component:  Database   |Version:  master
  layer (models, ORM)|
   Severity:  Normal |   Keywords:
   Triage Stage:  Accepted   |  Has patch:  0
Needs documentation:  0  |Needs tests:  0
Patch needs improvement:  0  |  Easy pickings:  0
  UI/UX:  0  |
-+-
 #30054 requires emulating a TRUNCATE CASCADE which requires a recursive
 retrieval of foreign key constraints. Recursive CTEs are only supported on
 SQLite 3.8.3+.

 Ubuntu Trusty ships with SQLite 3.8.2 and will EOL in April 2019. Debian
 Jessie ships with 3.8.7+.

 SQLite 3.8.2 was released in December 2013. SQLite version support seems
 like a similar situation as GEOS libraries which we generally support
 about 5 years after released.

 ([https://github.com/django/django/pull/10779#issuecomment-449526742
 discussion])

-- 
Ticket URL: 
Django 
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/052.418fc6161cc5784b3d9884769670ea08%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.