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

Collapse
1: database error with Employee Admin query
Posted by Jamie Ross on 05/01/01 02:45 AM
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
2: Response to database error with Employee Admin query (response to 1)
Posted by Don Baccus on 05/01/01 03:57 AM
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
3: Response to database error with Employee Admin query (response to 1)
Posted by Ben Adida on 05/01/01 04:00 AM
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
4: Response to database error with Employee Admin query (response to 1)
Posted by Jamie Ross on 05/01/01 04:48 AM
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