[OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** RE: ***SPAM*** RE: Trouble with 1.6.1. > 2.0 upgrade
Peters, Michael
MRPeters at library.IN.gov
Wed Nov 10 11:24:25 EST 2010
Hey Mike,
It failed after:
2010-11-08 14:53:19 EST LOG: duration: 0.055 ms statement: INSERT INTO action_trigger.hook (key,core_type,description) VALUES ('renewal','circ','Item
renewed to user');
So I assume the culprit is:
INSERT INTO action_trigger.validator (module,description) VALUES ('MaxPassiveDelayAge','Check that the event is not too far past the delay_field time -- requires a max_delay_age interval parameter');
Sure enough, I already have this:
evergreen=# SELECT * FROM action_trigger.validator WHERE module='MaxPassiveDelayAge';
module | description
--------------------+--------------------------------------------------------------------------------------------------------------
MaxPassiveDelayAge | Check that the event is not too far past the delay_field time -- requires a max_delay_age interval parameter
(1 row)
I'm using a snapshot of our production database. Would this be at all related to already having these in our database in 1.6.0.0 for the notices development we did with you all?
I'm wondering what else, if anything, we may already have backported?
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:17 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** RE: Trouble with 1.6.1. > 2.0 upgrade
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
More information about the Open-ils-dev
mailing list