[OPEN-ILS-DEV] SPAM RE: SPAM RE: Trouble with 1.6.1. > 2.0 upgrade

Wed Nov 10 11:17:12 EST 2010

On Wed, Nov 10, 2010 at 11:09 AM, Peters, Michael
<MRPeters at library.in.gov> wrote:
> 2010-11-08 14:36:44 EST ERROR:  current transaction is aborted, commands ignored until end of transaction block
> 2010-11-08 14:36:44 EST STATEMENT:  CREATE TABLE acq.fiscal_calendar (
>           id              SERIAL         PRIMARY KEY,
>           name            TEXT           NOT NULL
>        );
> 2010-11-08 14:36:44 EST ERROR:  current transaction is aborted, commands ignored until end of transaction block
> 2010-11-08 14:36:44 EST STATEMENT:  CREATE TABLE acq.fiscal_year (
>           id              SERIAL         PRIMARY KEY,
>           calendar        INT            NOT NULL
>                                          REFERENCES acq.fiscal_calendar
>                                          ON DELETE CASCADE
>                                          DEFERRABLE INITIALLY DEFERRED,
>           year            INT            NOT NULL,
>           year_begin      TIMESTAMPTZ    NOT NULL,
>           year_end        TIMESTAMPTZ    NOT NULL,
>           CONSTRAINT acq_fy_logical_key  UNIQUE ( calendar, year ),
>            CONSTRAINT acq_fy_physical_key UNIQUE ( calendar, year_begin )
>        );
> 2010-11-08 14:36:44 EST ERROR:  current transaction is aborted, commands ignored until end of transaction block
> 2010-11-08 14:36:44 EST STATEMENT:  CREATE OR REPLACE FUNCTION acq.find_bad_fy()
>

Can you find the first error?  Those are all failures due to a previous hiccup.

> The upgrade alerted me that it had completed successfully, but the postgres logs seem to indicate otherwise...
>
> Would the upgrade have not stopped on error?

Because it's not using on_error_stop.  Perhaps it should, but I'm not
sure that's true.

>
> Sincerely,
> Michael Peters
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
> office - 317.234.2128
> email - mrpeters at library.in.gov
>
>
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Peters, Michael
> Sent: Wednesday, November 10, 2010 11:08 AM
> To: Evergreen Development Discussion List
> Subject: [OPEN-ILS-DEV] ***SPAM*** RE: Trouble with 1.6.1. > 2.0 upgrade
>
> Nope.  Used the one you sent along this morning.
>
> I do see it there now.  Off to look into why it didn't succeed....
>
> Sincerely,
> Michael Peters
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
> office - 317.234.2128
> email - mrpeters at library.in.gov
>
>
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Mike Rylander
> Sent: Wednesday, November 10, 2010 11:07 AM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade
>
> On Wed, Nov 10, 2010 at 11:02 AM, Peters, Michael
> <MRPeters at library.in.gov> wrote:
>> It would appear this is actually stemming back to aou.fiscal_calendar not existing.
>>
>> I've grepped back through all of the upgrades I ran and I don't see where the creation of this should have occurred.
>
> Line  8956 of the 2.0 upgrade script attempts to create this field.
> Edited script?
>
> --miker
>
>>
>> Sincerely,
>> Michael Peters
>> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
>> office - 317.234.2128
>> email - mrpeters at library.in.gov
>>
>>
>> -----Original Message-----
>> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Peters, Michael
>> Sent: Wednesday, November 10, 2010 11:01 AM
>> To: Evergreen Development Discussion List
>> Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade
>>
>> Mike,
>>
>> Thanks for the update.  I completed the upgrade and was singing along until it came time to autogen.
>>
>> Now I'm having some new troubles...
>>
>> The logs indicate that settings is not connected, however all indications are that it is.  Everything in settings-tester.pl checks out as well.
>>
>> opensrf at dev:/openils/bin$ ./autogen.sh -u
>> Updating Evergreen organization tree and IDL using '/openils/conf/opensrf_core.xml'
>>
>> Updating fieldmapper
>> Updating web_fieldmapper
>> Updating OrgTree
>> removing OrgTree from the cache for locale cs-CZ...
>> Exception: OpenSRF::DomainObject::oilsMethodException 2010-11-10T10:53:50 OpenILS::Utils::CStoreEditor /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:409 <500>  Severe query error -- see error log for more details
>>
>>
>> osrfsys.log:[2010-11-10 10:53:28] /usr/sbin/apache2 [ERR :20899:EX.pm:66:] Exception: OpenSRF::EX::Session 2010-11-10T10:53:28 OpenSRF::Transport /usr/local/share/perl/5.10.1/OpenSRF/Transport.pm:92 Session Error: router at private.dev.evergreen.lib.in.us/opensrf.settings IS NOT CONNECTED TO THE NETWORK!!!
>> osrfsys.log:[2010-11-10 10:53:28] /usr/sbin/apache2 [ERR :20899:EX.pm:66:] Exception: OpenSRF::EX::Session 2010-11-10T10:53:28 OpenSRF::Utils::SettingsClient /usr/local/share/perl/5.10.1/OpenSRF/Utils/SettingsClient.pm:103 Session Error: router at private.dev.evergreen.lib.in.us/opensrf.settings IS NOT CONNECTED TO THE NETWORK!!!
>> osrfsys.log:open-ils.cstore 2010-11-10 10:53:50 [ERR :24013:oils_sql.c:5390:] open-ils.cstore: Error retrieving actor::org_unit with query [SELECT  "aou".billing_address, "aou".holds_address, "aou".id, "aou".ill_address, "aou".mailing_address, oils_i18n_xlate('actor.org_unit', 'aou', 'name', 'id', "aou".id::TEXT, 'cs-CZ') AS "name", "aou".ou_type, "aou".parent_ou, "aou".shortname, "aou".email, "aou".phone, "aou".opac_visible, "aou".fiscal_calendar FROM actor.org_unit AS "aou" WHERE "aou".id IS NOT NULL ORDER BY name;]: 0 ERROR:  column aou.fiscal_calendar does not exist
>> osrfsys.log:[2010-11-10 10:53:50] org_tree_js.pl [ERR :26794:CStoreEditor.pm:109:] editor[0|0] request error open-ils.cstore.direct.actor.org_unit.search.atomic : [{"id":{"!=":null}},{"order_by":{"aou":"name"},"no_i18n":0}] : Exception: OpenSRF::DomainObject::oilsMethodException 2010-11-10T10:53:50 OpenILS::Utils::CStoreEditor /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:396 <500>  Severe query error -- see error log for more details
>> osrfsys.log:[2010-11-10 10:53:50] org_tree_js.pl [ERR :26794:EX.pm:66:] Exception: OpenSRF::DomainObject::oilsMethodException 2010-11-10T10:53:50 OpenILS::Utils::CStoreEditor /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:409 <500>  Severe query error -- see error log for more details
>>
>>
>> root at dev:/openils/conf# ejabberdctl connected-users | grep settings
>> opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22665
>> opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22667
>> opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22669
>> opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22671
>> opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_drone_at_dev.evergreen.lib.in.us_22673
>> opensrf at private.dev.evergreen.lib.in.us/opensrf.settings_listener_at_dev.evergreen.lib.in.us_22656
>> router at private.dev.evergreen.lib.in.us/opensrf.settings
>>
>>
>> root at dev:/openils/conf# ps aux | grep settings
>> opensrf  22647  0.0  0.0  87068 20124 ?        Ss   10:53   0:00 OpenSRF controller [opensrf.settings]
>> opensrf  22654  0.0  0.0  87096 21256 ?        S    10:53   0:00 OpenSRF master [opensrf.settings]
>> opensrf  22656  0.0  0.0  87068 20808 ?        S    10:53   0:00 OpenSRF listener [opensrf.settings]
>> opensrf  22665  0.0  0.0  87380 21556 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
>> opensrf  22667  0.0  0.0  87372 21644 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
>> opensrf  22669  0.0  0.0  87096 20600 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
>> opensrf  22671  0.0  0.0  87372 21644 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
>> opensrf  22673  0.0  0.0  87372 21644 ?        S    10:53   0:00 OpenSRF drone [opensrf.settings]
>>
>>
>>
>> Sincerely,
>> Michael Peters
>> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
>> office - 317.234.2128
>> email - mrpeters at library.in.gov
>>
>>
>> -----Original Message-----
>> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Mike Rylander
>> Sent: Wednesday, November 10, 2010 9:59 AM
>> To: Evergreen Development Discussion List
>> Subject: Re: [OPEN-ILS-DEV] Trouble with 1.6.1. > 2.0 upgrade
>>
>> On Wed, Nov 10, 2010 at 9:56 AM, Peters, Michael
>> <MRPeters at library.in.gov> wrote:
>>> Thanks Mike!
>>>
>>> Should I continue on with the current script, or await your updated version?
>>>
>>
>> It's in the repo now, here's the changeset:
>> http://svn.open-ils.org/trac/ILS/changeset/18682
>>
>> --
>> Mike Rylander
>>  | VP, Research and Design
>>  | Equinox Software, Inc. / The Evergreen Experts
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  miker at esilibrary.com
>>  | web:  http://www.esilibrary.com
>>
>
>
>
> --
> Mike Rylander
>  | VP, Research and Design
>  | Equinox Software, Inc. / The Evergreen Experts
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  miker at esilibrary.com
>  | web:  http://www.esilibrary.com
>

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com

[OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** RE: Trouble with 1.6.1. > 2.0 upgrade

[OPEN-ILS-DEV] SPAM RE: SPAM RE: Trouble with 1.6.1. > 2.0 upgrade