Forum OpenACS Q&A: database interaction flakiness

Collapse
Posted by Tracy Adams on
We are intermittently seeing the error below regarding the request processor permission queires...

Strange thing is
a) the query does return a row when checked in psql
b) it's 0or1row anyway and the syntax is fine

Anyone hit this or have thoughts?

"switch -glob -- [ad_conn extra_url] {
admin/* {
permission::require_permission -object_id [ad_conn object_id] -privilege adm..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
switch -glob -- [ad_conn extra_url] {
admin/* {
permission::require_permission -object_id [ad_conn object_i..."
(procedure "rp_filter" line 173)
invoked from within
"rp_filter preauth"
[05/Feb/2007:11:28:21][25973.7][-conn:edemocracy-dev::3] Error: Database operation "0or1row" failed (exception \
NSDB, "Query was not a statement returning rows.")

SQL:
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '384' and ppm.party_id = '0' and ppm.privilege = 'admin' )

Collapse
Posted by Tracy Adams on
We traced this down to a library incompatability.