I'm having trouble with the search pacakge after Yon ported it to
Oracle.
Specifically, the search_observer_dequeue_entry query called from
inside search_indexer doesn't get picked up by the query dispatcher,
and hence it tries to execute the empty string.
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER =
calling namespace =
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER =
proc_name is -search_indexer-
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = tcl
file is packages/search/tcl/search-procs.tcl
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER =
TEMP - QD: proc_name is search_indexer
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER =
TEMP - QD: local_name is search_observer_dequeue_entry
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER =
generated fullname of dbqd.search.tcl.search-
procs.search_indexer.search_observer_dequeue_entry
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = NO
FULLQUERY FOR dbqd.search.tcl.search-
procs.search_indexer.search_observer_dequeue_entry --> using default
SQL
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER =
PLPGSQL: using anonymous function
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = PRE-
QD: the SQL is
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = NO
FULLQUERY FOR dbqd.search.tcl.search-
procs.search_indexer.search_observer_dequeue_entry --> using default
SQL
I've tried to see if I can figure out what goes wrong, but I find it
very hard to troubleshoot and debug when the query dispatcher fails.
Anybody else have any ideas?