[OPEN-ILS-DEV] staff client searches hang

[Frances Dean McNamara]

Thanks, Dan.

We have done that vacuumdb and analyze.  We for sure did find that we couldn't search after doing our big loads until that was done.

We think, having done that, that this is an additional problem.  It does not seem to necessarily be related to the size of the result set.

It's weird because on our big db, some searches seem to hang and others complete quickly.  We have done the vacuumdb and analyze, though, so we don't think that's it.

Frances

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Dan Wells
Sent: Friday, July 11, 2008 2:33 PM
To: Evergreen Development Discussion List
Subject: RE: [OPEN-ILS-DEV] staff client searches hang

Hello Frances,

This sounds very similar to a problem I asked about a few weeks ago under the title "Postgres Speed Issues."  The query seems to hang in the browser (or staff client) because it times out on the client side (maybe at 60 seconds or so?).  If you actually run the searches in the command line client, they do finish, but they can take a REALLY long time.  The time seems directly related to the size of the result set, not any particular nature of the query itself.

It turns out that the load process as it stands creates a lot of extra "baggage" in the database.  You can read my last post in that thread and Mike R.'s response for a workaround with future loads, but the simplest answer at this point is that you may need to vacuum the database:

    $ vacuumdb -U postgres --all --full --analyze

You may want to substitute '-U evergreen' if that is the name of your 'evergreen' database owner-user.

This worked for me to clear up these really long queries.

Good luck,
DW

>>> Frances Dean McNamara <fdmcnama at uchicago.edu> 7/11/2008 2:26 PM >>>
A catalog search, can be from Home, a keyword search, or can be from Advanced a keyword search.

Some searches work, some seem to hang and not return results.

Frances

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Hardy, Elaine
Sent: Friday, July 11, 2008 12:25 PM
To: Evergreen Development Discussion List
Subject: RE: [OPEN-ILS-DEV] staff client searches hang

What kind of search are you doing? A patron search?  Or a catalog
search? If it is a catalog search, is it a MARC expert search?

 Elaine


J. Elaine Hardy
Library Services Manager - Collections & Reference
Georgia Public Library Service,
A Unit of the University System of Georgia
1800 Century Place, Suite 150
Atlanta, Ga. 30345-4304
404.235-7128
404.235-7201, fax

ehardy at georgialibraries.org
www.georgialibraries.org

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org
[mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of
Frances Dean McNamara
Sent: Friday, July 11, 2008 1:05 PM
To: Evergreen Development Discussion List
Subject: RE: [OPEN-ILS-DEV] staff client searches hang

Any suggestions, folks?  This is causing a problem for people looking at
the test system.  Thanks.

Frances McNamara

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org
[mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of
Dale Arntson
Sent: Thursday, July 10, 2008 3:42 PM
To: open-ils-dev at list.georgialibraries.org
Subject: [OPEN-ILS-DEV] staff client searches hang

Hi all,

We are having a problem with searches in our staff client intermittently
hanging. The hung searches correlate with the following error in the
open-ils.search_unix.log.

Use of uninitialized value in pattern match (m//) at
/opt/openils/lib/perl5/OpenILS/Application/Search/Biblio.pm line 520

Is any one familiar with this problem? I saw an old open-ils-dev message
that suggests it may be related to some missing circulation modifiers in
openils.xml. Can anyone elaborate? We are running Evergreen 1.2.2.0

Thanks,

-dale