[OPEN-ILS-DEV] staff client searches hang

[Hardy, Elaine]

There are some kinds of searches that do hang and/or time out. MARC
expert searches do so more than not. Currently, you can re-execute the
search and get the result set. "Retrieve records by TCN" searches from
the cataloging tab tend to take longer than TCN searches from the quick
search area. ISBN searches in the advanced search section (rather then
the quick search) can take longer. Other odd searches also hang, as
Frances notes. They are usually keyword searches; the more specific
author or title searches tend not to hang. I hesitate to give my
memories of the explanation Mike gave me; it has been too long for me to
get all the details correct. However, my understanding is that there are
some very nice fixes that have been made that will lessen and even
eliminate these kinds of problems. They are slated for one of the
upcoming releases.

If the search times out (returns zero results when you know there should
be results), re-execute the search and you should have records returned.



 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 3:41 PM
To: Evergreen Development Discussion List
Subject: RE: [OPEN-ILS-DEV] staff client searches hang

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