Hi,
I get this error from psycopg2: "InterfaceError: cursor already closed"
The error is repeatable, but not the way you would expect.
The error happens at id 1142. If I use objects.filter.(id__gt=1140)
instead of all() it does not happen.
Has someone seen something like this before?
PostgreSQL 8.2.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.2.1 (SUSE Linux)
python-psycopg2-2.0.5.1-2
django 1.0.2
Traceback (most recent call last):
File "/home/mwtest/foo/tests/ReadonlyTestPostInit.py", line 104, in
testBelegartEditView
for belegart in Belegart.objects.all().order_by('id'):
File "/home/mwtest/django/db/models/query.py", line 185, in _result_iter
self._fill_cache()
File "/home/mwtest/django/db/models/query.py", line 618, in _fill_cache
self._result_cache.append(self._iter.next())
File "/home/mwtest/django/db/models/query.py", line 275, in iterator
for row in self.query.results_iter():
File "/home/mwtest/django/db/models/sql/query.py", line 206, in
results_iter
for rows in self.execute_sql(MULTI):
File "/home/mwtest/django/db/models/sql/query.py", line 1748, in <lambda>
result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)),
InterfaceError: cursor already closed
SQL-Queries:
0.004 SELECT "django_session"."session_key",
"django_session"."session_data", "django_session"."expire_date" FROM
"django_session" WHERE ("django_session"."session_key" =
'364c6ecup90613a766e06a8bb118160be0' AND "django_session"."expire_date"
> '2008-12-10 13:27:34.226733' )
0.001 SELECT "auth_user"."id", "auth_user"."username",
"auth_user"."first_name", "auth_user"."last_name", "auth_user"."email",
"auth_user"."password", "auth_user"."is_staff", "auth_user"."is_active",
"auth_user"."is_superuser", "auth_user"."last_login",
"auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1
0.000 SET LOCAL foo.user_id TO 1
0.001 SELECT "foo_userprofile"."id", "foo_userprofile"."user_id",
"foo_userprofile"."send_inbox_mail",
"foo_userprofile"."form_koerbe_hide_if_no_perm",
"foo_userprofile"."form_koerbe_hide_if_no_belege" FROM "foo_userprofile"
WHERE "foo_userprofile"."user_id" = 1
0.002 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart"
0.001 SELECT "foo_buchungskreis"."id", "foo_buchungskreis"."name",
"foo_buchungskreis"."email_footer", "foo_buchungskreis"."email_adresse",
"foo_buchungskreis"."default" FROM "foo_buchungskreis"
0.003 SELECT "auth_permission"."id", "auth_permission"."name",
"auth_permission"."content_type_id", "auth_permission"."codename" FROM
"auth_permission" INNER JOIN "django_content_type" ON
("auth_permission"."content_type_id" = "django_content_type"."id") WHERE
("auth_permission"."codename" = 'change_belegart' AND
"django_content_type"."app_label" = 'foo' ) ORDER BY
"django_content_type"."app_label" ASC, "auth_permission"."codename" ASC
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1142
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."parent_id" = 1142 ORDER BY
"foo_belegart"."name" ASC
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1082
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1034
0.001 SELECT "foo_index"."id" FROM "foo_index" INNER JOIN
"foo_belegart_indexes" ON ("foo_index"."id" =
"foo_belegart_indexes"."index_id") WHERE
"foo_belegart_indexes"."belegart_id" = 1142
0.000 SELECT "foo_index"."id" FROM "foo_index" INNER JOIN
"foo_belegart_indexes" ON ("foo_index"."id" =
"foo_belegart_indexes"."index_id") WHERE
"foo_belegart_indexes"."belegart_id" = 1082
0.000 SELECT "foo_index"."id" FROM "foo_index" INNER JOIN
"foo_belegart_indexes" ON ("foo_index"."id" =
"foo_belegart_indexes"."index_id") WHERE
"foo_belegart_indexes"."belegart_id" = 1034
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1082
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1034
0.001 SELECT "auth_group"."id", "auth_group"."name" FROM "auth_group"
0.000 SELECT "foo_index"."id" FROM "foo_index"
0.001 SELECT "auth_permission"."id", "auth_permission"."name",
"auth_permission"."content_type_id", "auth_permission"."codename" FROM
"auth_permission" INNER JOIN "django_content_type" ON
("auth_permission"."content_type_id" = "django_content_type"."id") WHERE
("auth_permission"."codename" = 'view_belegart' AND
"django_content_type"."app_label" = 'foo' ) ORDER BY
"django_content_type"."app_label" ASC, "auth_permission"."codename" ASC
0.001 SELECT "foo_belegartrequiredgroup"."id",
"foo_belegartrequiredgroup"."belegart_id",
"foo_belegartrequiredgroup"."permission_id",
"foo_belegartrequiredgroup"."group_id" FROM "foo_belegartrequiredgroup"
WHERE ("foo_belegartrequiredgroup"."belegart_id" = 1142 AND
"foo_belegartrequiredgroup"."permission_id" = 64 )
0.000 SELECT "auth_group"."id", "auth_group"."name" FROM "auth_group"
WHERE "auth_group"."id" = 10
0.001 SELECT "auth_permission"."id", "auth_permission"."name",
"auth_permission"."content_type_id", "auth_permission"."codename" FROM
"auth_permission" INNER JOIN "django_content_type" ON
("auth_permission"."content_type_id" = "django_content_type"."id") WHERE
("auth_permission"."codename" = 'change_belegart' AND
"django_content_type"."app_label" = 'foo' ) ORDER BY
"django_content_type"."app_label" ASC, "auth_permission"."codename" ASC
0.000 SELECT "foo_belegartrequiredgroup"."id",
"foo_belegartrequiredgroup"."belegart_id",
"foo_belegartrequiredgroup"."permission_id",
"foo_belegartrequiredgroup"."group_id" FROM "foo_belegartrequiredgroup"
WHERE ("foo_belegartrequiredgroup"."belegart_id" = 1142 AND
"foo_belegartrequiredgroup"."permission_id" = 26 )
0.000 SELECT "auth_group"."id", "auth_group"."name" FROM "auth_group"
WHERE "auth_group"."id" = 10
0.001 SELECT "auth_permission"."id", "auth_permission"."name",
"auth_permission"."content_type_id", "auth_permission"."codename" FROM
"auth_permission" INNER JOIN "django_content_type" ON
("auth_permission"."content_type_id" = "django_content_type"."id") WHERE
("auth_permission"."codename" = 'view_belegart' AND
"django_content_type"."app_label" = 'foo' ) ORDER BY
"django_content_type"."app_label" ASC, "auth_permission"."codename" ASC
0.000 SELECT "foo_belegartrequiredgroup"."id",
"foo_belegartrequiredgroup"."belegart_id",
"foo_belegartrequiredgroup"."permission_id",
"foo_belegartrequiredgroup"."group_id" FROM "foo_belegartrequiredgroup"
WHERE ("foo_belegartrequiredgroup"."belegart_id" = 1142 AND
"foo_belegartrequiredgroup"."permission_id" = 64 )
0.001 SELECT "auth_permission"."id", "auth_permission"."name",
"auth_permission"."content_type_id", "auth_permission"."codename" FROM
"auth_permission" INNER JOIN "django_content_type" ON
("auth_permission"."content_type_id" = "django_content_type"."id") WHERE
("auth_permission"."codename" = 'change_belegart' AND
"django_content_type"."app_label" = 'foo' ) ORDER BY
"django_content_type"."app_label" ASC, "auth_permission"."codename" ASC
0.000 SELECT "foo_belegartrequiredgroup"."id",
"foo_belegartrequiredgroup"."belegart_id",
"foo_belegartrequiredgroup"."permission_id",
"foo_belegartrequiredgroup"."group_id" FROM "foo_belegartrequiredgroup"
WHERE ("foo_belegartrequiredgroup"."belegart_id" = 1142 AND
"foo_belegartrequiredgroup"."permission_id" = 26 )
0.000 SELECT "auth_group"."id", "auth_group"."name" FROM "auth_group"
WHERE "auth_group"."id" = 10
0.000 SELECT "auth_group"."id", "auth_group"."name" FROM "auth_group"
WHERE "auth_group"."id" = 10
0.000 SELECT "foo_index"."id" FROM "foo_index" WHERE "foo_index"."id" =
'ISU'
0.001 SELECT "foo_index"."id" FROM "foo_index" INNER JOIN
"foo_belegart_indexes" ON ("foo_index"."id" =
"foo_belegart_indexes"."index_id") WHERE
"foo_belegart_indexes"."belegart_id" IN (1142, 1082, 1034)
0.000 SELECT "foo_index"."id" FROM "foo_index" WHERE "foo_index"."id" =
'ISU'
0.001 SELECT "foo_index"."id" FROM "foo_index" INNER JOIN
"foo_belegart_indexes" ON ("foo_index"."id" =
"foo_belegart_indexes"."index_id") WHERE
"foo_belegart_indexes"."belegart_id" IN (1142, 1082, 1034)
0.001 SELECT "foo_isu_belegart_contact_klasse"."id",
"foo_isu_belegart_contact_klasse"."belegart_id",
"foo_isu_belegart_contact_klasse"."cls",
"foo_isu_belegart_contact_klasse"."activity" FROM
"foo_isu_belegart_contact_klasse" WHERE
"foo_isu_belegart_contact_klasse"."belegart_id" = 1142
0.000 SELECT "foo_isu_belegart_contact_klasse"."id",
"foo_isu_belegart_contact_klasse"."belegart_id",
"foo_isu_belegart_contact_klasse"."cls",
"foo_isu_belegart_contact_klasse"."activity" FROM
"foo_isu_belegart_contact_klasse" WHERE
"foo_isu_belegart_contact_klasse"."belegart_id" = 1142
0.000 SELECT "foo_isu_belegart_contact_klasse"."id",
"foo_isu_belegart_contact_klasse"."belegart_id",
"foo_isu_belegart_contact_klasse"."cls",
"foo_isu_belegart_contact_klasse"."activity" FROM
"foo_isu_belegart_contact_klasse" WHERE
"foo_isu_belegart_contact_klasse"."belegart_id" = 1082
0.000 SELECT "foo_isu_belegart_contact_klasse"."id",
"foo_isu_belegart_contact_klasse"."belegart_id",
"foo_isu_belegart_contact_klasse"."cls",
"foo_isu_belegart_contact_klasse"."activity" FROM
"foo_isu_belegart_contact_klasse" WHERE
"foo_isu_belegart_contact_klasse"."belegart_id" = 1034
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1142
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1082
0.000 SELECT "foo_belegart"."id", "foo_belegart"."parent_id",
"foo_belegart"."name", "foo_belegart"."duration", "foo_belegart"."text",
"foo_belegart"."default_gruppe_id", "foo_belegart"."archiv_belegart"
FROM "foo_belegart" WHERE "foo_belegart"."id" = 1034
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
