Re: [Phpwiki-talk] Odd database problems

[<je...@au...>]

Quoting Jeff Dairiki (da...@da...):
> > I'm getting some odd errors on about every 10th click.
> > 
> > Has anyone seen this perhaps and knows how to fix it?  I've tuned the
> > database up somewhat.  Is it just running out of juice and need more
> > dedicated memory or something like that?
> 
> I kind of doubt it's a memory problem (but then again I really have no
> idea.)


 
> How have you "tuned up" the database?

I turned up shared buffers and sort_mem on the database.  Trust me,
this was necessary.

> Can you back-out of the tune-ups, and if so, does the problem go away?

Tried this already, unfortunately nope.

> Are there concurrent PhpWiki acesses (edits?) going on when you get the
> errors?

Not at the same time and I'm certain it's not on the same pages if
there are.  The problem isn't isolated to edits though, which is the odd thing.

> PhpWiki version 1.3.<what>?

define ('PHPWIKI_VERSION', '1.3.4');

> What version of postgres?

psql (PostgreSQL) 7.3.2
 
> Any other hints regarding how I might be able to replicate the problem
> here?

For the most part, this is a pretty vanilla install.

I can send you the bread-crumb links module I wrote (planning to
anyways once I get it commented some) and you can see if that will
help you recreate it, but I'm 99.9% certain that's not the problem.

I've run it on mysql and on postgre and not had these
problems in the past.

Any ideas?

jeremy

-- 
Jeremy Kelley  <je...@au...>
Information Security Analyst