After upgrade from 0.8.4 to 0.9.2, search module not returning expected results

[aroach@…]

After I upgraded from 0.8.4 to 0.9.2, when I do a search, I'm not reliably receiving results that include tickets that were entered in the 0.8.4 timeframe.

For example, if I do a search on "resource" against tickets, the system returns two results. When I search against the db using:

select id,summary from ticket where description like '%resource%';

I get four results, and that's not even searching comments or summary. This seems strange to me. I know that at least one other person has seen this based on my queries to the IRC channel.

I'll update this ticket if I can figure out how to reproduce.

[saenger@…]

I recently upgraded trac, too. From 0.8.4 to 0.9.2. Now the search engine is not working properly - it seems that the results are only from tickets, that were added or changed after I upgraded trac.

So, since we have been working with the system, I could try to downgrade to 0.8.4 again and put in all the tickets / changes made since then by hand again, but I would prefer to continue using 0.9.2.

Any idea how to go on with this?

[anonymous]

OK.

Replying to aroach@jabber.com:

After I upgraded from 0.8.4 to 0.9.2, when I do a search, I'm not reliably receiving results that include tickets that were entered in the 0.8.4 timeframe.

For example, if I do a search on "resource" against tickets, the system returns two results. When I search against the db using:

select id,summary from ticket where description like '%resource%';

I get four results, and that's not even searching comments or summary. This seems strange to me. I know that at least one other person has seen this based on my queries to the IRC channel.

I'll update this ticket if I can figure out how to reproduce.

[Matthew Good]

Any more information on this? We should close this if it's no longer reproducible.

[Matthew Good]

Still unable to reproduce. Maintenance has now moved to 0.10 so please try upgrading again and see if you have the same problems with the new version.