Re: [Django] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
---+
 Reporter:  ojii   |Owner:  nobody
 Type:  Bug|   Status:  closed
Component:  Testing framework  |  Version:  master
 Severity:  Normal |   Resolution:  wontfix
 Keywords: | Triage Stage:  Accepted
Has patch:  0  |  Needs documentation:  0
  Needs tests:  0  |  Patch needs improvement:  0
Easy pickings:  0  |UI/UX:  0
---+
Changes (by timo):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 Marking as won't fix in light of no recent activity and the fact that
 `contrib.comments` is deprecated.

-- 
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/062.1f7af1d0f977c38509dfa9f2813ec23b%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
+---
   Reporter:  ojii  |  Owner:  nobody
   Type:  Bug   | Status:  new
  Milestone:|  Component:  Testing framework
Version:  SVN   |   Severity:  Normal
 Resolution:|   Keywords:
   Triage Stage:  Accepted  |  Has patch:  0
Needs documentation:  0 |Needs tests:  0
Patch needs improvement:  0 |  Easy pickings:  0
  UI/UX:  0 |
+---

Comment (by ramiro):

 One extradata point:

 I see this only when using the MyISAM MySQL storage backend (and using the
 `--pair text.TextTests.test_cookie_date` trick). Inserting prints of
 `connection.queries` show that the SQL queries are:

 {{{
 #!sql
 SELECT `comment_tests_article`.`id`, `comment_tests_article`.`author_id`,
 `comment_tests_article`.`headline` FROM `comment_tests_article` WHERE
 `comment_tests_article`.`id` = 1
 SELECT `django_content_type`.`id`, `django_content_type`.`name`,
 `django_content_type`.`app_label`, `django_content_type`.`model` FROM
 `django_content_type` WHERE (`django_content_type`.`model` = 'article'
 AND `django_content_type`.`app_label` = 'comment_tests' )
 }}}

 The second query is the problematic one.

-- 
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] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
+---
   Reporter:  ojii  |  Owner:  nobody
   Type:  Bug   | Status:  new
  Milestone:|  Component:  Testing framework
Version:  SVN   |   Severity:  Normal
 Resolution:|   Keywords:
   Triage Stage:  Accepted  |  Has patch:  0
Needs documentation:  0 |Needs tests:  0
Patch needs improvement:  0 |  Easy pickings:  0
  UI/UX:  0 |
+---

Comment (by jezdez):

 Seems like a caching issue to me, running the postgres tests gives me the
 same:

 {{{
 [~/Code/git/django/tests] git:master env:django-dev $ python runtests.py
 --settings=django_testing.mysql comment_tests --pair
 text.TextTests.test_cookie_date
 * Trying paired execution
 * 1 of 1: Check test pairing with comment_tests
 Creating test database for alias 'default'...
 
..F
 ==
 FAIL: testRenderCommentFormFromObjectWithQueryCount
 (regressiontests.comment_tests.tests.templatetag_tests.CommentTemplateTagTests)
 --
 Traceback (most recent call last):
   File
 
"/Users/jezdez/Code/git/django/tests/regressiontests/comment_tests/tests/templatetag_tests.py",
 line 46, in testRenderCommentFormFromObjectWithQueryCount
 self.assertNumQueries(1, test)
   File "/Users/jezdez/Code/git/django/django/test/testcases.py", line 549,
 in assertNumQueries
 func(*args, **kwargs)
   File "/Users/jezdez/Code/git/django/django/test/testcases.py", line 234,
 in __exit__
 executed, self.num
 AssertionError: 2 != 1 : 2 queries executed, 1 expected

 --
 Ran 91 tests in 43.983s

 FAILED (failures=1)
 Destroying test database for alias 'default'...
 * Found problem pair with comment_tests
 [~/Code/git/django/tests] git:master env:django-dev $ python runtests.py
 --settings=django_testing.postgres comment_tests --pair
 text.TextTests.test_cookie_date
 * Trying paired execution
 * 1 of 1: Check test pairing with comment_tests
 Creating test database for alias 'default'...
 
..F
 ==
 FAIL: testRenderCommentFormFromObjectWithQueryCount
 (regressiontests.comment_tests.tests.templatetag_tests.CommentTemplateTagTests)
 --
 Traceback (most recent call last):
   File
 
"/Users/jezdez/Code/git/django/tests/regressiontests/comment_tests/tests/templatetag_tests.py",
 line 46, in testRenderCommentFormFromObjectWithQueryCount
 self.assertNumQueries(1, test)
   File "/Users/jezdez/Code/git/django/django/test/testcases.py", line 549,
 in assertNumQueries
 func(*args, **kwargs)
   File "/Users/jezdez/Code/git/django/django/test/testcases.py", line 234,
 in __exit__
 executed, self.num
 AssertionError: 2 != 1 : 2 queries executed, 1 expected

 --
 Ran 91 tests in 31.527s

 FAILED (failures=1)
 Destroying test database for alias 'default'...
 * Found problem pair with comment_tests
 [~/Code/git/django/tests] git:master env:django-dev $ python runtests.py
 --settings=django_testing.mysql comment_tests
 Creating test database for alias 'default'...
 
..
 --
 Ran 90 tests in 47.637s

 OK
 Destroying test database for alias 'default'...
 [~/Code/git/django/tests] git:master env:django-dev $ python runtests.py
 --settings=django_testing.postgres comment_tests
 Creating test database for alias 'default'...
 
..
 --
 Ran 90 tests in 29.361s

 OK
 Destroying test database for alias 'default'...
 }}}

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

Re: [Django] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
+---
   Reporter:  ojii  |  Owner:  nobody
   Type:  Bug   | Status:  new
  Milestone:|  Component:  Testing framework
Version:  SVN   |   Severity:  Normal
 Resolution:|   Keywords:
   Triage Stage:  Accepted  |  Has patch:  0
Needs documentation:  0 |Needs tests:  0
Patch needs improvement:  0 |  Easy pickings:  0
  UI/UX:  0 |
+---

Comment (by ojii):

 Ran the tests manually now and get the following:


 {{{
 jenkins@pony:~/jobs/Django/workspace/database/mysql/python/python2.6/tests$
 python runtests.py --settings=test_mysql comment_tests --pair
 text.TextTests.test_cookie_date
 * Trying paired execution
 * 1 of 1: Check test pairing with comment_tests
 Creating test database for alias 'default'...
 Creating test database for alias 'other'...

 Running tests...
 --
 
..F
 ==
 FAIL [0.000s]: testRenderCommentFormFromObjectWithQueryCount
 (regressiontests.comment_tests.tests.templatetag_tests.CommentTemplateTagTests)
 --
 Traceback (most recent call last):
   File
 
"/var/lib/jenkins/jobs/Django/workspace/database/mysql/python/python2.6/tests/regressiontests/comment_tests/tests/templatetag_tests.py",
 line 46, in testRenderCommentFormFromObjectWithQueryCount
 self.assertNumQueries(1, test)
   File
 
"/var/lib/jenkins/jobs/Django/workspace/database/mysql/python/python2.6/tests/django/test/testcases.py",
 line 549, in assertNumQueries
 func(*args, **kwargs)
   File
 
"/var/lib/jenkins/jobs/Django/workspace/database/mysql/python/python2.6/tests/django/test/testcases.py",
 line 234, in __exit__
 executed, self.num
 AssertionError: 2 != 1 : 2 queries executed, 1 expected

 --
 Ran 91 tests in 16.534s

 FAILED (failures=1)

 Generating XML reports...
 Destroying test database for alias 'default'...
 Destroying test database for alias 'other'...
 * Found problem pair with comment_tests
 jenkins@pony:~/jobs/Django/workspace/database/mysql/python/python2.6/tests$
 python runtests.py --settings=test_mysql comment_tests
 Creating test database for alias 'default'...
 Creating test database for alias 'other'...

 Running tests...
 --
 
..
 --
 Ran 90 tests in 16.689s

 OK

 Generating XML reports...
 Destroying test database for alias 'default'...
 Destroying test database for alias 'other'...
 jenkins@pony:~/jobs/Django/workspace/database/mysql/python/python2.6/tests$
 python --version
 Python 2.6.5
 jenkins@pony:~/jobs/Django/workspace/database/mysql/python/python2.6/tests$
 mysql --version
 mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using
 readline 6.1
 jenkins@pony:~/jobs/Django/workspace/database/mysql/python/python2.6/tests$
 uname -a
 Linux pony 2.6.32-31-server #61-Ubuntu SMP Fri Apr 8 19:44:42 UTC 2011
 x86_64 GNU/Linux
 }}}

 only seems to fail in pairing mode

-- 
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] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
+---
   Reporter:  ojii  |  Owner:  nobody
   Type:  Bug   | Status:  new
  Milestone:|  Component:  Testing framework
Version:  SVN   |   Severity:  Normal
 Resolution:|   Keywords:
   Triage Stage:  Accepted  |  Has patch:  0
Needs documentation:  0 |Needs tests:  0
Patch needs improvement:  0 |  Easy pickings:  0
  UI/UX:  0 |
+---

Comment (by bpeschier):

 mysql 5.0.51/py2.5

 Normal run:
 {{{
 bpeschier@zeratul:~/dev/python/django/tests$ ./runtests.py
 --settings=test_mysql comment_tests
 Creating test database for alias 'default'...
 Creating test database for alias 'other'...
 
..
 --
 Ran 90 tests in 67.654s

 OK
 Destroying test database for alias 'default'...
 Destroying test database for alias 'other'...
 }}}

 Pair test:
 {{{
 bpeschier@zeratul:~/dev/python/django/tests$ ./runtests.py
 --settings=test_mysql --pair text.TextTests.test_cookie_date comment_tests
 * Trying paired execution
 * 1 of 1: Check test pairing with comment_tests
 Creating test database for alias 'default'...
 Creating test database for alias 'other'...
 
...
 --
 Ran 91 tests in 67.613s

 OK
 Destroying test database for alias 'default'...
 Destroying test database for alias 'other'...
 * No problem pair found
 }}}

 So, mysql version related?

-- 
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] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
+---
   Reporter:  ojii  |  Owner:  nobody
   Type:  Bug   | Status:  new
  Milestone:|  Component:  Testing framework
Version:  SVN   |   Severity:  Normal
 Resolution:|   Keywords:
   Triage Stage:  Accepted  |  Has patch:  0
Needs documentation:  0 |Needs tests:  0
Patch needs improvement:  0 |  Easy pickings:  0
  UI/UX:  0 |
+---
Changes (by aaugustin):

 * stage:  Unreviewed => Accepted


Comment:

 The test doesn't fail in isolation:
 {{{
 tests % PYTHONPATH=.. ./runtests.py --settings=test_mysql comment_tests
 Creating test database for alias 'default'...
 
..
 --
 Ran 90 tests in 25.041s

 OK
 Destroying test database for alias 'default'...
 PYTHONPATH=.. ./runtests.py --settings=test_mysql comment_tests  13,78s
 user 1,53s system 55% cpu 27,642 total
 }}}

 It does in pair mode:
 {{{
 tests % PYTHONPATH=.. ./runtests.py --settings=test_mysql --pair
 text.TextTests.test_cookie_date

 (... snip ...)

 * 94 of 178: Check test pairing with comment_tests
 Creating test database for alias 'default'...
 
..F
 ==
 FAIL: testRenderCommentFormFromObjectWithQueryCount
 (regressiontests.comment_tests.tests.templatetag_tests.CommentTemplateTagTests)
 --
 Traceback (most recent call last):
   File "/Users/myk/Desktop/django-
 trunk/tests/regressiontests/comment_tests/tests/templatetag_tests.py",
 line 46, in testRenderCommentFormFromObjectWithQueryCount
 self.assertNumQueries(1, test)
   File "/Users/myk/Desktop/django-trunk/django/test/testcases.py", line
 549, in assertNumQueries
 func(*args, **kwargs)
   File "/Users/myk/Desktop/django-trunk/django/test/testcases.py", line
 234, in __exit__
 executed, self.num
 AssertionError: 2 != 1 : 2 queries executed, 1 expected

 (... snip ...)

 }}}

-- 
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] #16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount fails on MySQL

[Django]

#16282: CommentTemplateTagTests.testRenderCommentFormFromObjectWithQueryCount 
fails
on MySQL
--+---
   Reporter:  ojii|  Owner:  nobody
   Type:  Bug | Status:  new
  Milestone:  |  Component:  Testing framework
Version:  SVN |   Severity:  Normal
 Resolution:  |   Keywords:
   Triage Stage:  Unreviewed  |  Has patch:  0
Needs documentation:  0   |Needs tests:  0
Patch needs improvement:  0   |  Easy pickings:  0
  UI/UX:  0   |
--+---
Changes (by ojii):

 * needs_better_patch:   => 0
 * needs_tests:   => 0
 * needs_docs:   => 0


Comment:

 Using mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using
 readline 6.1

 Running in --pair mode against text.TextTests.test_cookie_date to make the
 tests run in an acceptable time

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