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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[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
