[Building Sakai] Can I Upgrade Search from 1.2.5 to 1.3.5 in Sakai 2.7

[David Horwitz]

Hi Mike,

You can upgrade search to a more resent version, however that you have 
nearly 5K journals suggests something is very wrong. Most likely at some 
point it tried to optimize and failed, you should only ever have <200 
journals or so

Some things to check:

1) Log messages about shared merges suceding/failing
2) if running in a cluster check search_node_status - there should be an 
entry for each node (if running clustered) and the txid for each node 
should be close to the max in search journal.
3) Check the status of your journals - are any "merge-prepare" (like the 
first 100 odd records)


D

On 01/26/2012 06:16 PM, Mike Jennings wrote:
> I am currently running Sakai 2.7 and we are seeing a lot of
> search_jorunal querys in the slow query logs....
>
> # Query_time: 60.008890  Lock_time: 0.000035 Rows_sent: 4858
> Rows_examined: 4858
> # Time: 120126  6:07:21
> # Query_time: 60.008890  Lock_time: 0.000035 Rows_sent: 4858
> Rows_examined: 4858
> SET timestamp=1327576041;
> select txid, indexwriter, status, txts  from search_journal;
>
> I was going to try and upgrade the search indexer from 1.2.5 to 1.3.5 in
> Sakai 2.7 to see if that would help things out..... Is it possible to do
> this since it is a external tool?
>
> Thanks,
>
> Mike