[haiku-web] Re: Trac trouble (WAS Re: [haiku-development] Re: Trac down, bug report here: efi_gpt.cpp has functions with wrong number of parameters)

Am 24.07.2009, 17:04 Uhr, schrieb Brecht Machiels <brecht@xxxxxxxxxxx>:
Yes, very strange. And the problem only occurs after Trac has been running for quite a while, yes?
Trac allegedly (see posts from Federico Di Gregorio on initd.org) suffers from very bad memory leaks over time and usually benefits from a restart. mod_python will keep the Python process running allowing the memory leak to grow. Might be an idea to cron the resource use ("beancounters" seems to be available on one of my virtual machines) and restart once a threshold is reached.
dev.haiku-os.org is using PostgreSQL instead of SQLite, right? SQLite is the default. I'm not sure whether the use of PostgreSQL as backend is wide-spread. This is another thing to look at besides mod_python. I would place PostgreSQL above mod_python on the suspect list.
This is crap. I've got systems running Python and PostgreSQL together for years and a friend of mine is using psycopg2 on a *massive* system without memory problems.
I'm not sure how much work would be involved in switching to SQLite (and back again?). In any case, it feels dangerous.
Not dangerous, insane. SQLite is not multi-user safe and runs database locking. It's great for embedding in applications such as Firefox for providing standardised serialisation and being able to run it directly in Python lets you use SQL databases on the fly so you can use SQL queries on your data without writing custom data but it has never been considered as a replacement for an existing RDBMS. 

Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226
-----------------------------------------------------------------------
haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List

Other related posts: