phpwiki-talk

[Phpwiki-talk] Odd database problems

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

Hello All,

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?

-------------------8<---------------------
lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_pgsql:
fatal database error

    * DB Error: unknown error
    * (SELECT * FROM page WHERE pagename='BlahBlah'
    * [nativecode=ERROR: current transaction is aborted, queries
    * ignored until end of transaction block
    * ])
-------------------8<---------------------

I'm using phpwiki version 1.3 on a postgre database.

Thanks for any help you can offer.

jeremy

-- 
Jeremy Kelley  <jeremy austin.ibm.com>
Information Security Analyst

Re: [Phpwiki-talk] Odd database problems

[Jeff D. <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?
Can you back-out of the tune-ups, and if so, does the problem go away?
Are there concurrent PhpWiki acesses (edits?) going on when you get the
errors?

PhpWiki version 1.3.<what>?
What version of postgres?

Any other hints regarding how I might be able to replicate the problem
here?

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