Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Evergreen Software Performance Analysis
Hi all, Having heard no objections to proceeding with finding somebody to do a software performance analysis, I have created a page on the wiki at http://www.open-ils.org/dokuwiki/doku.php?id=dev:testing:performance_issues where we can identify the pain points that need further evaluation and add any questions that we hope a performance analysis might be able to answer. I have started the list off with some basic issues/questions that have come up in our own systems. During the future of the staff client meeting, Dan Scott had mentioned that there might be three points of attack:client, opensrf, database. I thought dividing the list into those three areas might be a good way to start. I'm hoping that all the knowledgeable sys admins out there who have a stronger understanding of the system architecture than I do can build this list into something that might be a good starting point for any performance evaluation, whether it's done by a third party or by somebody in the Evergreen community. By identifying the questions we hope a performance evaluation might answer, we are also identifying what our expectations are before we enter the process. I would want to be clear on our expectations before formally talking to any third party so that we can be fully informed about whether an evaluation could meet those expectations. Kathy Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 343-0128 kluss...@masslnc.org Twitter: http://www.twitter.com/kmlussier On 2/20/2013 2:26 PM, Mike Rylander wrote: On Wed, Feb 20, 2013 at 2:10 PM, Kathy Lussier kluss...@masslnc.org mailto:kluss...@masslnc.org wrote: Hi all, I wasn't sure if I should add this to the QA discussion, but it seemed worthy of its own thread. During the future of the staff client meeting, I advocated for bringing in a consultant to do a software performance analysis for Evergreen to help us identify where the critical bottlenecks are in the system in the hopes that we could then identify the areas that need to be worked on to improve performance. At the time, I didn't have any concrete suggestions on finding a consultant who could take on this project, but I have since done some more investigation and have a couple of leads, the most promising of which is an individual local to Massachusetts who previously worked for many years at Stratus Technologies where he was involved in all levels of performance analysis. He now teaches graduate-level courses on performance evaluation and also does contract work. Now that I actually have concrete leads, I would like to get the ball rolling, provided there is support from the larger community. I'm not quite sure how this might fit in with ESI's planned QA efforts or with the possibility of bringing in a firm like OmniTI as Dan suggested, but my reading into these QA e-mails is that the focus would be on testing new commits. I want to clarify something that Dan seems to have assumed incorrectly: that anything ESI does is mutually exclusive with bringing in outside expertise. Nobody has any grounds to stop such an effort, and it would be ridiculous to argue otherwise, words put into my mouth notwithstanding. The initial focus of an ESI effort will be what exists today, through infrastructure, so that what exists tomorrow can then be tested. As for how it would fit in, ESI would absorb and internalize any advice or direction, just like any other community member, and work within the community to incorporate that. So, why have ESI involved at all? Besides the fact that we create a significant portion of the code, and that it benefits us as much as anyone to have a more stable Evergreen, there is a need for ongoing, active leadership in QA. The fact is that it has not materialized yet, so we're looking for a way to make that a maintainable proposition for the community's benefit. That means ongoing, deep integration with both developer and user communities. And that is not something that we can expect from OmniTI or any other organization that is not plugged into those communities. Could some other organization step into that role, and provide years of ongoing QA support? Perhaps so, but ESI exists today and has the Evergreen expertise needed to avoid long (and costly) ramp-up time. The point is this, though, ESI will encourage any effort to improve Evergreen, and is willing and able to work in the community, as we always do, to further those efforts. Thanks, Kathy! -- Mike Rylander | Director of Research and Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com mailto:mi...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] E Mail Notification is not working
Hi there, What exactly do you mean by an email id? This term is vague. Could you provide the exact command you run to get that output? James On Mon, Feb 25, 2013 at 12:17 AM, Jayaraj JR jaya...@iisertvm.ac.in wrote: Hi All, We try to activate the e mail notification system in Evergreen server. We have created an e mail id. This entry is made in the opensrf.config file.The mail notifiations are not being sent by the system. But receive back the following lines in the newly created e mail id /home/opensrf/.bashrc: 13: shopt: not found /home/opensrf/.bashrc: 21: shopt: not found /home/opensrf/.bashrc: 99: shopt: not found /etc/bash_completion: 33: [[: not found /etc/bash_completion: 39: [[: not found /etc/bash_completion: 52: Bad substitution Kindly help us -- With Best Regards, Jayaraj J R LIbrary Information Assistant IISER Thiruvananthapuram
[OPEN-ILS-GENERAL] Evergreen T-Shirts
Planning on attending this year's Evergreen Conference in Vancouver? Interested in owning your very own Evergreen T-shirt? Well then, don't miss this limited time offer! The Evergreen Oversight Board is selling two styles of Evergreen T-shirts, with proceeds going to the Evergreen Project (a portion of the money goes to the Software Freedom Conservancy to help cover operating expenses). Evergreen T-Shirt #1: A white Gildan T, with the green Evergreen logo printed across the front Sizes: S, M, L, XL, XXL, XXXL $15 Evergreen T-Shirt #2 (woman's cut): A white Bella T, fitted, with a scoop neck. Green Evergreen logo printed across the front Sizes: S, M, L, XL, XXL $20 See attached for representations of how these shirts will look. Note: the woman's T has more of a scoop neck than the image shows. We need a minimum order for us to move forward with the ordering of these shirts. We'll let you know if we don't reach that minimum order. Right now we're taking pre-orders. Payment will be expected at the Evergreen conference in Vancouver. We will have a table near the registration desk. CASH ONLY. Not coming to the Conference but don't want to miss out on the shirt too? Find a buddy! We just need someone to pick up your shirt at the conference to save those extra shipping costs. HOW TO ORDER: Send me an email (terl...@biblio.org) and include your name, the type of shirt, number of shirts, and size(s) in the email. I will confirm receipt of email and later on, confirm that your order will be processed. Don't miss this opportunity! Deadline is Thursday, March 7th! +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ Amy Terlaga Assistant Director, User Services Bibliomation, Inc. 32 Crest Road Middlebury, CT 06762 203-577-4070 x101 http://www.biblio.org/ www.biblio.org attachment: Evergreen_tshirt.jpg
Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Evergreen Software Performance Analysis
Hi Kathy, Thank you for moving this forward in a sensible and diplomatic fashion. I appreciate the work you do. Cheers, Tara On Mon, Feb 25, 2013 at 8:44 AM, Kathy Lussier kluss...@masslnc.org wrote: Hi all, Having heard no objections to proceeding with finding somebody to do a software performance analysis, I have created a page on the wiki at http://www.open-ils.org/dokuwiki/doku.php?id=dev:testing:performance_issueswhere we can identify the pain points that need further evaluation and add any questions that we hope a performance analysis might be able to answer. I have started the list off with some basic issues/questions that have come up in our own systems. During the future of the staff client meeting, Dan Scott had mentioned that there might be three points of attack:client, opensrf, database. I thought dividing the list into those three areas might be a good way to start. I'm hoping that all the knowledgeable sys admins out there who have a stronger understanding of the system architecture than I do can build this list into something that might be a good starting point for any performance evaluation, whether it's done by a third party or by somebody in the Evergreen community. By identifying the questions we hope a performance evaluation might answer, we are also identifying what our expectations are before we enter the process. I would want to be clear on our expectations before formally talking to any third party so that we can be fully informed about whether an evaluation could meet those expectations. Kathy Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative(508) 343-0128kluss...@masslnc.org Twitter: http://www.twitter.com/kmlussier On 2/20/2013 2:26 PM, Mike Rylander wrote: On Wed, Feb 20, 2013 at 2:10 PM, Kathy Lussier kluss...@masslnc.orgwrote: Hi all, I wasn't sure if I should add this to the QA discussion, but it seemed worthy of its own thread. During the future of the staff client meeting, I advocated for bringing in a consultant to do a software performance analysis for Evergreen to help us identify where the critical bottlenecks are in the system in the hopes that we could then identify the areas that need to be worked on to improve performance. At the time, I didn't have any concrete suggestions on finding a consultant who could take on this project, but I have since done some more investigation and have a couple of leads, the most promising of which is an individual local to Massachusetts who previously worked for many years at Stratus Technologies where he was involved in all levels of performance analysis. He now teaches graduate-level courses on performance evaluation and also does contract work. Now that I actually have concrete leads, I would like to get the ball rolling, provided there is support from the larger community. I'm not quite sure how this might fit in with ESI's planned QA efforts or with the possibility of bringing in a firm like OmniTI as Dan suggested, but my reading into these QA e-mails is that the focus would be on testing new commits. I want to clarify something that Dan seems to have assumed incorrectly: that anything ESI does is mutually exclusive with bringing in outside expertise. Nobody has any grounds to stop such an effort, and it would be ridiculous to argue otherwise, words put into my mouth notwithstanding. The initial focus of an ESI effort will be what exists today, through infrastructure, so that what exists tomorrow can then be tested. As for how it would fit in, ESI would absorb and internalize any advice or direction, just like any other community member, and work within the community to incorporate that. So, why have ESI involved at all? Besides the fact that we create a significant portion of the code, and that it benefits us as much as anyone to have a more stable Evergreen, there is a need for ongoing, active leadership in QA. The fact is that it has not materialized yet, so we're looking for a way to make that a maintainable proposition for the community's benefit. That means ongoing, deep integration with both developer and user communities. And that is not something that we can expect from OmniTI or any other organization that is not plugged into those communities. Could some other organization step into that role, and provide years of ongoing QA support? Perhaps so, but ESI exists today and has the Evergreen expertise needed to avoid long (and costly) ramp-up time. The point is this, though, ESI will encourage any effort to improve Evergreen, and is willing and able to work in the community, as we always do, to further those efforts. Thanks, Kathy! -- Mike Rylander | Director of Research and Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com
[OPEN-ILS-GENERAL] Hostname
Yes, I tried logging in; however, I could not figure out what my hostname is. As always, thanks for the assistance.
[OPEN-ILS-GENERAL] Syntax error when creating postgres function
Will someone please provide assistance or guidance on the problem I am
experiencing while attempting to create the postgres function for inserting
records into the evergreen database?
evergreen=# CREATE OR REPLACE FUNCTION staging_importer() RETURNS NULL AS $$
evergreen$# DECLARE stage RECORD;
evergreen$# BEGIN
evergreen$# FOR stage IN SELECT * FROM staging_records_import ORDER BY id
LOOP
evergreen$# INSERT INTO biblio.record_entry (marc, last_xact_id)
VALUES (s
tage.marc, 'IMPORT');
evergreen$# UPDATE staging_records_import SET dest =
currval('biblio.recor
d_entry_id_seq');
evergreen$#END LOOP;
evergreen$# END;
evergreen$# $$ LANGUAGE plpgsql;
ERROR: syntax error at or near AS
LINE 1: ...TE OR REPLACE FUNCTION staging_importer() RETURNS NULL AS $$
Thank You
Larry Arnold
Re: [OPEN-ILS-GENERAL] Syntax error when creating postgres function
On Mon, Feb 25, 2013 at 4:04 PM, Larry W Arnold arn...@wvlc.lib.wv.uswrote:
Will someone please provide assistance or guidance on the problem I am
experiencing while attempting to create the postgres function for inserting
records into the evergreen database?
** **
evergreen=# CREATE OR REPLACE FUNCTION staging_importer() RETURNS NULL AS
$$
evergreen$# DECLARE stage RECORD;
evergreen$# BEGIN
evergreen$# FOR stage IN SELECT * FROM staging_records_import ORDER BY id
LOOP
evergreen$# INSERT INTO biblio.record_entry (marc, last_xact_id)
VALUES (s
tage.marc, 'IMPORT');
evergreen$# UPDATE staging_records_import SET dest =
currval('biblio.recor
d_entry_id_seq');
evergreen$#END LOOP;
evergreen$# END;
evergreen$# $$ LANGUAGE plpgsql;
ERROR: syntax error at or near AS
LINE 1: ...TE OR REPLACE FUNCTION staging_importer() RETURNS NULL AS $$
Hi Larry,
Try 'RETURNS VOID' instead of 'RETURNS NULL'.
-b
--
Bill Erickson
| Senior Software Developer
| phone: 877-OPEN-ILS (673-6457)
| email: ber...@esilibrary.com
| web: http://esilibrary.com
| Equinox Software, Inc. / Your Library's Guide to Open Source
Re: [OPEN-ILS-GENERAL] Syntax error when creating postgres function
Hi Bill,
That did it!! I owe you a beer - Larry
From: open-ils-general-boun...@list.georgialibraries.org
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
Bill Erickson
Sent: Monday, February 25, 2013 5:18 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Syntax error when creating postgres function
On Mon, Feb 25, 2013 at 4:04 PM, Larry W Arnold arn...@wvlc.lib.wv.us
wrote:
Will someone please provide assistance or guidance on the problem I am
experiencing while attempting to create the postgres function for inserting
records into the evergreen database?
evergreen=# CREATE OR REPLACE FUNCTION staging_importer() RETURNS NULL AS $$
evergreen$# DECLARE stage RECORD;
evergreen$# BEGIN
evergreen$# FOR stage IN SELECT * FROM staging_records_import ORDER BY id
LOOP
evergreen$# INSERT INTO biblio.record_entry (marc, last_xact_id)
VALUES (s
tage.marc, 'IMPORT');
evergreen$# UPDATE staging_records_import SET dest =
currval('biblio.recor
d_entry_id_seq');
evergreen$#END LOOP;
evergreen$# END;
evergreen$# $$ LANGUAGE plpgsql;
ERROR: syntax error at or near AS
LINE 1: ...TE OR REPLACE FUNCTION staging_importer() RETURNS NULL AS $$
Hi Larry,
Try 'RETURNS VOID' instead of 'RETURNS NULL'.
-b
--
Bill Erickson
| Senior Software Developer
| phone: 877-OPEN-ILS (673-6457)
| email: ber...@esilibrary.com
| web: http://esilibrary.com
| Equinox Software, Inc. / Your Library's Guide to Open Source
Re: [OPEN-ILS-GENERAL] Evergreen T-Shirts
I would buy one if the background wasn't white. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Amy Terlaga Sent: Monday, February 25, 2013 1:27 PM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] Evergreen T-Shirts Planning on attending this year's Evergreen Conference in Vancouver? Interested in owning your very own Evergreen T-shirt? Well then, don't miss this limited time offer! The Evergreen Oversight Board is selling two styles of Evergreen T-shirts, with proceeds going to the Evergreen Project (a portion of the money goes to the Software Freedom Conservancy to help cover operating expenses). Evergreen T-Shirt #1: A white Gildan T, with the green Evergreen logo printed across the front Sizes: S, M, L, XL, XXL, XXXL $15 Evergreen T-Shirt #2 (woman's cut): A white Bella T, fitted, with a scoop neck. Green Evergreen logo printed across the front Sizes: S, M, L, XL, XXL $20 See attached for representations of how these shirts will look. Note: the woman's T has more of a scoop neck than the image shows. We need a minimum order for us to move forward with the ordering of these shirts. We'll let you know if we don't reach that minimum order. Right now we're taking pre-orders. Payment will be expected at the Evergreen conference in Vancouver. We will have a table near the registration desk. CASH ONLY. Not coming to the Conference but don't want to miss out on the shirt too? Find a buddy! We just need someone to pick up your shirt at the conference to save those extra shipping costs. HOW TO ORDER: Send me an email (terl...@biblio.orgmailto:terl...@biblio.org) and include your name, the type of shirt, number of shirts, and size(s) in the email. I will confirm receipt of email and later on, confirm that your order will be processed. Don't miss this opportunity! Deadline is Thursday, March 7th! +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ Amy Terlaga Assistant Director, User Services Bibliomation, Inc. 32 Crest Road Middlebury, CT 06762 203-577-4070 x101 www.biblio.orghttp://www.biblio.org/
