Home
The Toolkit for Online Communities
17598 Community Members, 0 members online, 4695 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : search_indexer error

Forum OpenACS Q&A: search_indexer error

Icon of envelope Request notifications

Collapse
Posted by Lars Pind on
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?

Collapse
Posted by Vinod Kurup on
... I find it very hard to troubleshoot and debug when the query dispatcher fails.

Me too. Usually I look for either a typo or malformed XML in the query file or a typo in the .tcl file where the query is called. But, I'm not getting this error (CVS updated today).

Collapse
Posted by Yonatan Feldman on
this has already been fixed in the tree.