Re: [Django] #18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite

[Django]

#18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite
-+-
 Reporter:  rball@…  |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Uncategorized|  Version:  1.4
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:  SQLite, max  | Triage Stage:
  columns, syncdb, permissions   |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by aaugustin):

 * status:  reopened => closed
 * resolution:   => duplicate


Comment:

 The implementation of `syncdb` (actually, the creation of the permissions
 which is triggered by `post_syncdb`) changed between 1.3 and 1.4. Now it
 uses `bulk_create`. So your problem really is a symptom of the regression
 tracked by #17788.

 If you have to use SQLite, your best alternative is to re-compile it with
 higher limits. However, the recommended solution is to use a database that
 isn't limited like SQLite, when you hit its limits.

-- 
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite

[Django]

#18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite
-+-
 Reporter:  rball@…  |Owner:  nobody
 Type:  Bug  |   Status:  reopened
Component:  Uncategorized|  Version:  1.4
 Severity:  Normal   |   Resolution:
 Keywords:  SQLite, max  | Triage Stage:
  columns, syncdb, permissions   |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by rballverisys):

 * keywords:  SQLite, max columns => SQLite, max columns, syncdb,
   permissions
 * status:  closed => reopened
 * resolution:  duplicate =>


Comment:

 I agree that the error message is the same as #17788 but I believe these
 issues are a little different. The other bug is more concerned about
 bulk_create(). This issue is more concerned about being able to run syncdb
 on django 1.4. The core issue is before syncdb worked under django 1.3 and
 now it does not for django 1.4. when running syncdb I cannot control how
 bulk insert works. The permission system is an integral part of our
 project so I cannot get rid of that. At the very least why did this work
 with django 1.3? Has SQLite changed? Is there at least a way around this
 problem?

-- 
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite

[Django]

#18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite
-+-
 Reporter:  rball@…  |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Uncategorized|  Version:  1.4
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:  SQLite, max columns  | Triage Stage:
Has patch:  0|  Unreviewed
  Needs tests:  0|  Needs documentation:  0
Easy pickings:  0|  Patch needs improvement:  0
 |UI/UX:  0
-+-

Comment (by aaugustin):

 Ah, indeed. Sorry. I should have reformatted and read the stack trace.

-- 
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite

[Django]

#18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite
-+-
 Reporter:  rball@…  |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Uncategorized|  Version:  1.4
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:  SQLite, max columns  | Triage Stage:
Has patch:  0|  Unreviewed
  Needs tests:  0|  Needs documentation:  0
Easy pickings:  0|  Patch needs improvement:  0
 |UI/UX:  0
-+-

Comment (by akaariai):

 This is after all about bulk_create. If you check the stack trace, this is
 actually about creating permissions, not create table commands.

-- 
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite

[Django]

#18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite
-+-
 Reporter:  rball@…  |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Uncategorized|  Version:  1.4
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:  SQLite, max columns  | Triage Stage:
Has patch:  0|  Unreviewed
  Needs tests:  0|  Needs documentation:  0
Easy pickings:  0|  Patch needs improvement:  0
 |UI/UX:  0
-+-

Comment (by aaugustin):

 I'm not sure this is a duplicate of #18117. #18117 is about `bulk_insert`,
 and we don't use bulk insert to create tables.

 However, it isn't up to Django to work around limitations in SQLite. I
 suggest either recompiling SQLite with larger limits or using a database
 without such limits. I'd have closed that ticket as "wontfix".

-- 
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite

[Django]

#18117: Django 1.4 Trouble Creating Large Numbers of Tables with SQLite
-+-
 Reporter:  rball@…  |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Uncategorized|  Version:  1.4
 Severity:  Normal   |   Resolution:  duplicate
 Keywords:  SQLite, max columns  | Triage Stage:
Has patch:  0|  Unreviewed
  Needs tests:  0|  Needs documentation:  0
Easy pickings:  0|  Patch needs improvement:  0
 |UI/UX:  0
-+-
Changes (by claudep):

 * status:  new => closed
 * needs_docs:   => 0
 * resolution:   => duplicate
 * needs_tests:   => 0
 * needs_better_patch:   => 0


Comment:

 Duplicate of #17788.

-- 
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.