Forum OpenACS Q&A: PG Driver problem when using search
I get this error:
handle "select" is not of type "PostgreSQL"
while executing
"ns_pg_bind select nsdb2 {
select arg_name, arg_default
from acs_function_args
where function = upper(:function_name)
order by ..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]
set result [list]
while { [db_get..."
(procedure "db_list_of_lists" line 9)
invoked from within
"db_list_of_lists get_function_args {}"
(procedure "plpgsql_utility::get_function_args" line 2)
invoked from within
"plpgsql_utility::get_function_args search_observer__dequeue"
("eval" body line 1)
invoked from within
"eval $script"
invoked from within
"ns_cache eval util_memoize $script {
list $current_time [eval $script]
}"
(procedure "util_memoize" line 20)
invoked from within
"util_memoize [list plpgsql_utility::get_function_args $function_name"
(procedure "plpgsql_utility::generate_attribute_parameter_call" line 4)
invoked from within
"plpgsql_utility::generate_attribute_parameter_call \
-prepend ":" \
${package_name}__${object_name} \
$pieces"
invoked from within
"subst -nobackslashes \n\n\tselect\ \$\{package_name\}__\$\{object_name\}(\[plpgsql_utility::generate_attribute_parameter_call\ \\\n\t\t-prepend\ \":\"..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list subst -nobackslashes $sql"
(procedure "db_exec" line 16)
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
ns_log Debug "PLPGSQL: bypassed anon function"
set selection [..."
("uplevel" body line 6)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql exec_func_plsql {}"
(procedure "package_exec_plsql" line 31)
invoked from within
"package_exec_plsql -var_list [list [list object_id $object_id] [list event_date $event_date] [list event $event] ] search_observer dequeue"
(procedure "search::dequeue" line 3)
invoked from within
"search::dequeue -object_id $object_id -event_date $event_date -event $event"
("uplevel" body line 49)
invoked from within
"uplevel 1 $code_block "
("1" arm line 1)
invoked from within
"switch $errno {
0 {
# TCL_OK
}
1 {
# TCL_ERROR
..."
("while" body line 20)
invoked from within
"while { [db_getrow $db $selection] } {
incr counter
if { [info exists array_val] } {
unset array_val
..."
("uplevel" body line 5)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]
set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach search_observer_queue_entry {} {
switch -- $event {
INSERT {
# Don't bother reindexing if we've alread..."
(procedure "search::indexer" line 12)
invoked from within
"search::indexer"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 42)
invoked from within
"ad_run_scheduled_proc {t f 30 search::indexer {} 1102697443 0 f}"
I was using an Oracle pool along with the PostgreSQL pools earlier but I commented the Oracle pool out in the config file and the error persists. Any ideas?
Posted by
Peter Marklund
on 12/10/04 06:17 PM
oh, turns out I still had an oracle pool lying around and that was indeed causing the problem. Please ignore my post...