rebuild search index won't run

alexgoldmanccmm

Just updated to 2.0 for php8 support (running 8.2) and tried to run the update-from-1.7 in caUtils, which didn't run. So tried to run the-rebuild-search index and got:
PHP Fatal error: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array, null given in /app/lib/Search/SearchIndexer.php:610
Stack trace:
#0 /app/lib/Search/SearchIndexer.php(610): array_keys(NULL)
#1 /app/lib/Search/SearchIndexer.php(279): SearchIndexer->indexRow('105', '18362', Array, true)
#2 /app/lib/Utils/CLIUtils/Search.php(49): SearchIndexer->reindex(NULL, Array)
#3 /support/bin/caUtils(172): CLIUtils::rebuild_search_index(Object(Zend_Console_Getopt))
#4 {main}
thrown in /app/lib/Search/SearchIndexer.php on line 61

This is going to be an adventure, I think.

seth

update-from-1.7 doesn't do anything yet. It's there as part of preparations for the release of 2.0.

Please do a pull on your install and try again. I have no idea why the array throwing the error is null for you, but I've just added a check for it.

alexgoldmanccmm

Hi Seth, did a pull and that fixed the error, it runs, but searches are returning no results.

monica

alexgoldmanccmm make sure you have set search_engine_plugin = SqlSearch2 in your app.conf if you have overridden it will a local version.

alexgoldmanccmm

I was hopeful it was something as simple as that, but nope. The rebuild search index also runs VERY fast, like only takes 7 seconds, where it used to take at least a few minutes.

monica

alexgoldmanccmm So that setting is SqlSearch2? Make sure all caches are cleared (Redis, Memcache, app/tmp etc.). Do you have search_indexing.conf in your local? Also, what DB version are you using?

alexgoldmanccmm

monica Yep, sqlsearch2, never had a local version so that changed with the update. I don't have any local config files, actually (I mean, besides setup.php, of course). DB revision 197. Cleared all of the caches, and I've never touched search_indexing.conf. No problem browsing to things in the database, but all searches return no results.

seth

I see the problem. It's an error on my part in some recent modifications to reduce the amount of indexing queuing activity. Please do a pull and try it one more time.

Thanks,
Seth

alexgoldmanccmm

seth
Hi Seth!
Rebuilding ran much more as expected. The search is still a little glitchy, not getting results for everything I would expect, but absolutely getting results for most things now. Is there a process that keeps running in the background after a search index rebuild that I need to wait to finish if I'm just using the built-in sqlsearch2?
Thank you so much!
Alex

alexgoldmanccmm

An update... Although there are search results, I'm being told by staff that they're pretty incomplete. Results not coming up if searching by accession numbers or parts of accession numbers, only getting one result from a title search that should bring up 5+ results, etc. I know we're essentially in a beta version right now, so hoping it helps to hear about bugs!