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

Wed Nov 10 11:09:19 EST 2010

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()

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?

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

[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