I'm picking through some nasty problems with postgres connections on my django install. Bascially, if I do "a lot" of rapid selects and inserts on some models with "a lot" of mutual foreign key constraints, the database connection hangs indefinitely - and quite nastily - it acquires locks such that other django processes trying to access a given record will also hang.
That's all too indefinite I know, but it's going to take a fair bit of labour to reduce this bug to anything more precise --- unless anyone can kindly offer me a couple of handy tips to speed up the process, or has run into the same thing themselves... The problem is, its really hard to find a "simplest" test case, since it seems to be to do with lots of inserts and deletes on complex models. I have no access to the pdb debugger or the query log to resolve this, since python processes that have hung don't respond to keyboard interrupts, and don't throw an error, but simply hang indefinitely and have to be killed from the command line... Messy. I'm going to start some loggin solutions at the db server end, next. So, yes, as I slog away trying to sort this one out, I'd love to know if anyone has similar experiences. Am I re-inventing a wheel here? A bit of googling turns up nothing, but I'm hoping this post might make the silent among you pipe up. Anyone? Cheers, dan FWIW, the django machines are ubunto 8.04 and 8.10, CPython 2.5.2 and are accessing a postgresql 8.3 server with postgis extension running on an ubuntu 8.04 box. django 1.0. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
