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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
[EMAIL PROTECTED]
www.georgialibraries.org
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dale Arntson
Sent: Thursday, July 10, 2008 3:42 PM
To: [email protected]
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
