Re: [OPEN-ILS-DEV] (no subject)
If you haven't tried it yet, the troubleshooting page at: http://open-ils.org/dokuwiki/doku.php?id=troubleshooting:checking_for_errors is very helpful for finding the cause of this type of problem. When I ran into opensrf issues, I also found it helped to start the services individually: First osrf_ctl.sh -l -a stop_all then instead of osrf_ctl.sh -l -a start_all I would try: osrf_ctl.sh -l -a start_router osrf_ctl.sh -l -a start_perl osrf_ctl.sh -l -a start_c which seemed to work in many cases. I would also clear some the opensrf related log files if they are getting large. Robert - Original Message - From: Hunt, Phil h...@nelinet.net Date: Friday, February 13, 2009 11:51 am Subject: [OPEN-ILS-DEV] (no subject) To: Evergreen Development Discussion List open-ils-dev@list.georgialibraries.org Phil Hunt Program Director, Information Technology NELINET, Inc. ' Direct Phone: (508)597-1924 '1.508.460.7700 x1924 6 FAX (508)460-9455 * h...@nelinet.net I have upgraded to 1.4.0.1 (1 step back) and am seeing the osrf- routergoing to 100% on 2 copies of the app. My osrf core xml config is mostly standard, public.localhost, private.localhost, with the log stuff set down to 3. Nothing else changed. Running Ubuntu 8.04. Any ideas? Anyone seen this? The system runs, but the 2 100% jobs hurts. This E-mail contains privileged and confidential information intended only for the individual or entity named in the message. If the reader of this message is not the intended recipient, or the agent responsible to deliver it to the intended recipient, you are hereby notified that any review, dissemination, distribution or copying of this communication is prohibited. If this communication was received in error, please notify the sender by reply E-mail immediately, and delete and destroy the original message.
Re: [OPEN-ILS-DEV] (no subject)
So, Grant, try wiping your database, vacuuming it, and loading gutenberg.sqlagain. You just might have success. Hey Dan, I just did a VACCUUM and it then seemed to load fine - at least I have no errors in this process. The Gutenburg titles exist in the record_entry table of the biblio schema. but... OPAC doesn't work in Java or html mode. Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. . . . These are the errors in the Apache error.log. any ideas? Is the CN for the certificate be the problem? Like a dummy I used my own name - Guess I could just rebuild from that point! * [Wed Oct 17 17:34:03 2007] [warn] RSA server certificate CommonName (CN) `Grant Johnson' does NOT match server name!? [Wed Oct 17 17:34:03 2007] [debug] ssl_engine_init.c(768): Configuring RSA server private key [Wed Oct 17 17:34:03 2007] [info] Server: Apache/2.2.3, Interface: mod_ssl/2.2.3, Library: OpenSSL/0.9.8c [Wed Oct 17 17:34:03 2007] [notice] Apache/2.2.3 (Ubuntu) mod_ssl/2.2.3 OpenSSL/0.9.8c mod_perl/2.0.2 Perl/v5.8.8 configured -- resuming normal operations [Wed Oct 17 17:34:03 2007] [info] Server built: Aug 16 2007 22:49:04 [Wed Oct 17 17:34:03 2007] [debug] prefork.c(991): AcceptMutex: sysvsem (default: sysvsem) [Wed Oct 17 17:34:47 2007] [debug] proxy_util.c(1625): proxy: grabbed scoreboard slot 0 in child 13092 for worker proxy:reverse [Wed Oct 17 17:34:47 2007] [debug] proxy_util.c(1724): proxy: initialized single connection worker 0 in child 13092 for (*) [Wed Oct 17 17:34:49 2007] [debug] osrf_json_gateway.c(77): allowed service: opensrf.math\n [Wed Oct 17 17:34:49 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.cat\n [Wed Oct 17 17:34:49 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.search\n [Wed Oct 17 17:34:49 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.circ\n [Wed Oct 17 17:34:49 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.actor\n [Wed Oct 17 17:34:49 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.auth\n [Wed Oct 17 17:34:53 2007] [debug] proxy_util.c(1625): proxy: grabbed scoreboard slot 0 in child 13093 for worker proxy:reverse [Wed Oct 17 17:34:53 2007] [debug] proxy_util.c(1644): proxy: worker proxy:reverse already initialized [Wed Oct 17 17:34:53 2007] [debug] proxy_util.c(1724): proxy: initialized single connection worker 0 in child 13093 for (*) [Wed Oct 17 17:34:53 2007] [debug] osrf_json_gateway.c(77): allowed service: opensrf.math\n [Wed Oct 17 17:34:53 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.cat\n [Wed Oct 17 17:34:53 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.search\n [Wed Oct 17 17:34:53 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.circ\n [Wed Oct 17 17:34:53 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.actor\n [Wed Oct 17 17:34:53 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.auth\n [Wed Oct 17 17:34:54 2007] [debug] proxy_util.c(1625): proxy: grabbed scoreboard slot 0 in child 13090 for worker proxy:reverse [Wed Oct 17 17:34:54 2007] [debug] proxy_util.c(1644): proxy: worker proxy:reverse already initialized [Wed Oct 17 17:34:54 2007] [debug] proxy_util.c(1724): proxy: initialized single connection worker 0 in child 13090 for (*) [Wed Oct 17 17:34:54 2007] [debug] osrf_json_gateway.c(77): allowed service: opensrf.math\n [Wed Oct 17 17:34:54 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.cat\n [Wed Oct 17 17:34:54 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.search\n [Wed Oct 17 17:34:54 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.circ\n [Wed Oct 17 17:34:54 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.actor\n [Wed Oct 17 17:34:54 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.auth\n [Wed Oct 17 17:34:55 2007] [debug] proxy_util.c(1625): proxy: grabbed scoreboard slot 0 in child 13091 for worker proxy:reverse [Wed Oct 17 17:34:55 2007] [debug] proxy_util.c(1644): proxy: worker proxy:reverse already initialized [Wed Oct 17 17:34:55 2007] [debug] proxy_util.c(1724): proxy: initialized single connection worker 0 in child 13091 for (*) [Wed Oct 17 17:34:55 2007] [debug] proxy_util.c(1625): proxy: grabbed scoreboard slot 0 in child 13094 for worker proxy:reverse [Wed Oct 17 17:34:55 2007] [debug] proxy_util.c(1644): proxy: worker proxy:reverse already initialized [Wed Oct 17 17:34:55 2007] [debug] proxy_util.c(1724): proxy: initialized single connection worker 0 in child 13094 for (*) [Wed Oct 17 17:34:55 2007] [debug] osrf_json_gateway.c(77): allowed service: opensrf.math\n [Wed Oct 17 17:34:55 2007] [debug] osrf_json_gateway.c(77): allowed service: open-ils.cat\n [Wed Oct 17 17:34:55 2007] [debug] osrf_json_gateway.c(77):
Re: [OPEN-ILS-DEV] (no subject)
On 15/10/2007, Grant Johnson [EMAIL PROTECTED] wrote: Hey, Anyone know the correct syntax for loading the gutenburg records? and other rec.'s for that matter? On http://open-ils.org/dokuwiki/doku.php?id=evergreen-admin:importing:bibrecords when I get to the step running the sql script (# \i ~/gutenberg.sql) I get a load of errors. And the stdout ends with; psql:/home/evergreen-admin/gutenberg.sql:374485: invalid command \N psql:/home/evergreen-admin/gutenberg.sql:374508: invalid command \. psql:/home/evergreen-admin/gutenberg.sql:435383: ERROR: syntax error at or near Edward LINE 1: Edward Gaylord Bourne (Annotator/subfield/datafielddata... Wife is calling me to bed now - I'll check logs in the AM. ver. 2.2.9, postgres, ubuntu Great to put some faces to names in Victoria. Cheers F. Grant Johnson Systems Coordinator Robertson Library University of Prince Edward Island Hi Grant: Version 2.2.9? Hmm, any chance you've been playing with Koha recently? :) I'm sure it is the right syntax, having run through the instructions with Gutenberg and other records a few times now. I just ran through the Gutenberg import process using OpenSRF trunk Evergreen trunk, twice; the first time I got similar complaints from PostgreSQL about the '\N' commands when loading gutenberg.sql. I then wiped the database with build-db.sh, ran VACUUM FULL to recover the wasted database space, broke the file up into several separate COPY commands wrapped in transactions (BEGIN; COMMIT;), and loaded the files in order to try to reproduce the error in a more specific location of the file, and the entire load succeeded without complaint. Okay. So I wiped the database, ran VACUUM FULL again, and loaded the whole thing as a single file. And once again, it succeeded without complaint. My suspicion is that the transaction for the entire file reached some internal limit for PostgreSQL exacerbated by the lack of vacuuming I had done in the past, freaked out, and started spitting out errors. By running VACUUM FULL I suspect I cleared up the condition that had caused the problem in the first place. So, Grant, try wiping your database, vacuuming it, and loading gutenberg.sqlagain. You just might have success. -- Dan Scott Laurentian University
