Forum OpenACS Q&A: database error with Employee Admin query

I am running OpenACS 3.4.2 against Postgresql 7.0.2 and mostly things work. However when I hit the employee admin page I get and error from the big query which uses the UNION.

Each subquery returns fine but when I run the full query I get the following:

NOTICE:  PortalHeapMemoryFree: 0x0x40ba6980 not in alloc set!
NOTICE:  PortalHeapMemoryFree: 0x0x40ba6b98 not in alloc set!
NOTICE:  PortalHeapMemoryFree: 0x0x40ba6b70 not in alloc set!
ERROR:  btree scan list trashed; can't find 0x0x40ba6ac0

Any suggestions?.. is this a issue with 7.0.2 and the way we installed it?..

thanks!

Collapse
Posted by Don Baccus on
Ugh ... you might upgrade to PG 7.0.3 and see if it still fails.

Unless you're able to upgrade to PG 7.1 (or better PG 7.1.1 which gets  cut for release tomorrow).

Collapse
Posted by Ben Adida on
Yes, this is a known 7.0.2 bug. Doesn't exist in 7.0, and it is
solved in 7.0.3. I strongly recommend 7.1 (it's way fast!).
Collapse
Posted by Jamie Ross on
I thought that might be the answer.. I am running 7.1 on my home systems and was hoping to avoid all the "order by" issues I encountered there.. but they are easier to deal with so I think 7.1.1 is the way to go!

thanks