2008/3/5 Pigletto <pigle...@gmail.com>:
>
>> > Problem is possibly with multiple interpreters and psycopg2 again,
>>
>> Why do you say that? The thread you refer to above doesn't talk about
>> mod_python, so do you have any extra evidence that support this claim?
> There was a bug in psycopg2 with Decimal data type that sometimes
> caused
> error like that:
> unsupported operand type(s) for *: 'Decimal' and 'Decimal'
>
> It was discussed on the list:
> http://groups.google.com/group/django-users/browse_thread/thread/091aa6c088f6c090
>
> Similarly to "can't adapt" it was raised sometimes, after apache was
> running for few days, etc.. When error appears, restarting apache
> causes everything to work fine but only for some time and then again,
> errors are appearing. It was said that Decimal problem is caused by
> running psycopg2 with multiple interpreters, so thats why I think
> "can't adapt" might be the same thing.
> Exactly same place, same data entered in the form and after submit
> sometimes I get "can't adapt" and sometimes (after apache restart)
> everything works.
>

Sorry for opening an old thread but this is exactly the problem we
have had today with an application that has been running for nearly
two years. We're using mod_python and we run two different sites. We
have the can't adapt error at random basis. Once is produced in one
site the other site gives the same error.

I don't know if is related or not, but the only thing we have done is
to update to the security patch of 1.0 version. Actually we have
updated to the 1.1.2 version but the error still happens.

Restarting Apache makes everythink running again, but after some time
the error appears. The request involves making a query that Django
converts to a Decimal number (a request between 0 and 999999999), I
have refactored to make a different query so It seems this kind of
error is not solved.

Traceback follows:

Traceback (most recent call last):

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/core/handlers/base.py",
line 92, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File "/var/pywww/trobacasaweb/trobacasa/views.py", line 502, in buscar
    resultado['page'] = paginator.page(actual_page)

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/core/paginator.py",
line 37, in page
    number = self.validate_number(number)

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/core/paginator.py",
line 28, in validate_number
    if number > self.num_pages:

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/core/paginator.py",
line 60, in _get_num_pages
    if self.count == 0 and not self.allow_empty_first_page:

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/core/paginator.py",
line 48, in _get_count
    self._count = self.object_list.count()

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/db/models/query.py",
line 292, in count
    return self.query.get_count()

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/db/models/sql/query.py",
line 376, in get_count
    number = obj.get_aggregation()[None]

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/db/models/sql/query.py",
line 348, in get_aggregation
    result = query.execute_sql(SINGLE)

  File 
"/usr/local/virtualenvs/trobacasa/lib/python2.5/site-packages/django/db/models/sql/query.py",
line 2369, in execute_sql
    cursor.execute(sql, params)

ProgrammingError: can't adapt



-- 
Antoni Aloy López
Blog: http://trespams.com
Site: http://apsl.net

--~--~---------~--~----~------------~-------~--~----~
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 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to