Patron user name search crashes

[Terran McCanna]

In the 2.11 client, searching for a patron by user name (OPAC Login) times out and throws warnings. (It is slow but doesn't time out against the tiny Concerto database, but times out against our full database.)

I'm attaching screenshots of error message & javascript console from the xul client to this ticket.

The web client sometimes times out without an error (just a "No Items to Display" message even though there should be matches), and will sometimes succeed (but is very slow).

Searching by user name in 2.9 against our full database works fine. I don't know if the problem began in 2.10 or 2.11.

[Chris Sharp (chrissharp123)]

Attaching SQL and EXPLAIN ANALYZE output from a long-running search.

[Chris Sharp (chrissharp123)]

I can confirm the issue. Setting priority to High since this is pretty close to a showstopper for us.

[Jason Stephenson (jstephenson)]

You added the unaccent extension to the database?

[Mike Rylander (mrylander)]

It looks like the upgrade script does not add an index to the usrname field like it does for the various person-name fields. Perhaps we need a:

CREATE INDEX CONCURRENTLY actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname));

[Chris Sharp (chrissharp123)]

Works for me! Packaged into a branch here: http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/lp1643932_slow_username_search_index

[Terran McCanna (tmccanna)]

Excellent! Thanks, guys!

[Jason Stephenson (jstephenson)]

I don't think this made it into 2.10, so targeting at 2.11 and 2.next.

[Galen Charlton (gmc)]

Pushed to master and rel_2_11. Thanks, Chris and Mike!