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

Mike Rylander mrylander at gmail.com
Wed Nov 10 11:06:38 EST 2010 

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

More information about the Open-ils-dev mailing list