Sorry, I should have provided more details. I'm using SQLObject to talk to a SqLite database. I don't think I'm doing anything non-standard with that database. I have a job scheduled that runs every 5 minutes. A process queries a pop mailbox, fetches any mail, parses the messages, and puts the data in the database.
It looks (from /proc/<pid>/fds) that I had 47 connections to devdata.sqlite at the time it threw the exception. Anything else I could provide in the way of details? It seems that it's the act of fetching the mail that is triggering the exception, so that might be where the new connections are being made. Here's the job that fetches the mail and puts the data in the database: http://paste.turbogears.org/paste/2639 Hmm, after I create a new MessageInfo record in the table (line 20 in the paste), which creates a new connection to the database, I wonder if I should be deleting the reference to that record? On the other hand, I don't get new mail very often, but I do check it every 5 minutes. The list of file handles seems to increasing faster the number of new records, so perhaps it's the act of fetching the mail that creates the open file. thanks S --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
