Forum OpenACS Q&A: Search Indexer Errors.

Collapse
Posted by Kurt Schwarz on
What the...?!?

I've recently started getting this error. Not sure if it's because I loaded a 2nd instance of ACS, or what, but I can't see to figure out why it's suddenly happening.

Any clues?


[06/Feb/2003:00:06:43][908.16387][-sched-] Error: Transaction aborted: Database operation "1row" failed (exception NSDB, "Query was not a statement returning rows.")
Database operation "1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_db 1row $db $lob_sql"
    invoked from within
"db_exec_lob blob_get $db $full_statement_name $sql"
    invoked from within
"set data [db_exec_lob blob_get $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
	set data [db_exec_lob blob_get $db $full_statement_name $sql]
    }"
    (procedure "db_blob_get" line 6)
    invoked from within
"db_blob_get get_lob_data {}"
    invoked from within
"set data [db_blob_get get_lob_data {}]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $transaction_code "
    (procedure "db_transaction" line 39)
    invoked from within
"db_transaction {
                set data [db_blob_get get_lob_data {}]
            }"
    ("lob" arm line 2)
    invoked from within
"switch $storage_type {
        text {
            set data $content
        }
        file {
            set data [db_blob_get get_file_data {}]
     ..."
    (procedure "search_content_get" line 6)
    invoked from within
"search_content_get txt $datasource(content) $datasource(mime) $datasource(storage_type)"
    ("INSERT" arm line 5)
    invoked from within
"switch $event {
            INSERT {
                set object_type [acs_object_type $object_id]
                if {[acs_sc_binding_exists_p FtsCont..."
    ("uplevel" body line 3)
    invoked from within
"uplevel 1 $code_block "
    ("1" arm line 1)
    invoked from within
"switch $errno {
		0 {
		    # TCL_OK
		}
		1 {
		    # TCL_ERROR
		    global errorInfo errorCode
		    error $error $errorInfo $errorCode
		}
		2 {
	..."
    ("while" body line 20)
    invoked from within
"while { [db_getrow $db $selection] } {
	    incr counter
	    if { [info exists array_val] } {
		unset array_val
	    }
	    if { ![info exists column..."
    ("uplevel" body line 5)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
	set selection [db_exec select $db $full_statement_name $sql]

	set counter 0
	while { [db_getrow $db $selection] } {
	    incr co..."
    (procedure "db_foreach" line 35)
    invoked from within
"db_foreach search_observer_queue_entry {} {

        switch $event {
            INSERT {
                set object_type [acs_object_type $object_id]..."
    (procedure "search_indexer" line 5)
    invoked from within
"search_indexer"
    ("eval" body line 1)
    invoked from within
"eval [concat [list $proc] $args]"
    (procedure "ad_run_scheduled_proc" line 43)
    invoked from within
"ad_run_scheduled_proc {f f 60 search_indexer {} 1044486822 0 t}"
Collapse
2: Re: Search Indexer Errors. (response to 1)
Posted by Kurt Schwarz on
Just an update...This problem seems to have cleared up after re-installing my OpenFTS driver.