Forum OpenACS Q&A: OpenFTS mystery

Collapse
Posted by Roger Metcalf on
I've successfully installed and used OpenFTS several times (Redhat 7.2 and Suse 8 with postgresql). But I've been failing in the last few days, trying both 4.6.2-beta2 and with 4.6 head. I'm using notes package for testing. I was finally going to post here and ask, why is this happening? --
[11/Apr/2003:10:17:02][15199.2051][-sched-] Notice: Running scheduled proc search_indexer...
[11/Apr/2003:10:17:02][15199.2051][-sched-] Warning: ACS-SC: Function Not Found: AcsSc.FtsContentProvider.datasource.note 
[11/Apr/2003:10:17:02][15199.2051][-sched-] Error: can't read "datasource(content)": no such element in array
can't read "datasource(content)": no such element in array
    while executing
"search_content_get txt $datasource(content) $datasource(mime) $datasource(storage_type)"
    ("INSERT" arm line 5)
    invoked from within
...
I'd reinstalled a few times, followed the new instructions, referred to the old instructions, restarted extra times, etc. Finally thought hey! I'll set debug to true and see what I find. I swear I did nothing else (directly). And it started working:

 [11/Apr/2003:10:18:06][17092.2051][-sched-] Notice: Running scheduled proc search_indexer...
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: sql = 
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: bind var: package_id = 310
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: bind var: parameter_name = FtsEngineDriver
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: query with bind variables substituted = 
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = '310'
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = 'FtsEngineDriver'
    
[11/Apr/2003:10:18:06][17092.2051][-sched-] Notice: Querying '
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = '310'
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = 'FtsEngineDriver';'
[11/Apr/2003:10:18:06][17092.2051][-sched-] Notice: dbinit: sql(localhost::ttcdev7): '
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = '310'
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = 'FtsEngineDriver'
    '
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: sql = 
            select object_id, event_date, event
            from search_observer_queue
            order by event_date asc
        
  
I changed debug back, it still works now. Does that make sense? And what sort of thing might be wrong that could cause that first error? Thanks
Collapse
2: Re: OpenFTS mystery (response to 1)
Posted by Roger Metcalf on
Should others have the problem, this seems to be exactly what happens if you don't restart after installing a service contract binding, so maybe late one night I began assuming you didn't have to do that....