[OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** RE: Trouble with 1.6.1. > 2.0 upgrade
Peters, Michael
MRPeters at library.IN.gov
Wed Nov 10 11:11:36 EST 2010
I've attached the full upgrade log.
I guess in my opinion, the script shouldn't tell me it was successful if it had all of these errors.
Should the upgrade script maybe be set to stop on error?
Any ideas for correcting this?
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:09 AM
To: Evergreen Development Discussion List
Subject: [OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** RE: Trouble with 1.6.1. > 2.0 upgrade
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: upgrade.log
Type: application/octet-stream
Size: 178100 bytes
Desc: upgrade.log
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20101110/47b7e849/attachment-0001.obj
More information about the Open-ils-dev
mailing list