Forum .LRN Q&A: Error when upgrading from DotLRN 1.0.1Final to dotLRN 2.0.0rc1

Collapse
1: Error when upgrading from DotLRN 1.0.1Final to dotLRN 2.0.0rc1
Posted by Holger Merettig on 02/24/04 09:35 AM
I try to upgrade my Testserver from DotLRN 1.0.1Final to dotLRN 2.0.0rc1.

When I come to load the acs-lang data model with the command

psql -f /var/lib/aolserver/dotlearn/packages/acs-lang/sql/postgresql/acs-lang-create.sql -d dotlearn

I get the following errors:

BEGIN
psql:ad-locales.sql:44: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'ad_locale_abbrev_pk' for table 'ad_locales'
psql:ad-locales.sql:44: NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'ad_locale_name_unq' for table 'ad_locales'
psql:ad-locales.sql:44: ERROR:  Relation 'ad_locales' already exists
psql:ad-locales.sql:56: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:60: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:72: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:84: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:90: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:96: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:102: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:108: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:114: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:120: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:126: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:131: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:136: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:141: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:146: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:151: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:156: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:161: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:166: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:171: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:176: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:181: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:186: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:191: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:196: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:201: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:206: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:211: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:216: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:221: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:226: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:231: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:236: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:241: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:246: ERROR:  current transaction is aborted, queries ignored until end of transaction block
COMMIT
BEGIN
psql:message-catalog.sql:18: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE TABLE
psql:message-catalog.sql:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'lang_message_keys_pk' for table 'lang_message_keys'
psql:message-catalog.sql:33: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE TABLE
psql:message-catalog.sql:66: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'lang_messages_pk' for table 'lang_messages'
psql:message-catalog.sql:66: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
psql:message-catalog.sql:66: ERROR:  Relation 'lang_messages' already exists
psql:message-catalog.sql:102: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:130: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:148: ERROR:  current transaction is aborted, queries ignored until end of transaction block
COMMIT

What ist wrong here?

Thanks for help.
Best regards
Holger

Collapse
2: Re: Error when upgrading from DotLRN 1.0.1Final to dotLRN 2.0.0rc1 (response to 1)
Posted by Bruce Spear on 03/16/04 10:44 AM
Hi Holger!

I've got the same error message for the "psql -f acs-lang-create.sql" as you.  Were you able to figure this out?

For those keeping up the documentation.

For the Upgrade ACS Service Contracts manually section, the file is "contract" not "contracts", and I found I had first to cd to the directory before running the psql command, thus:
cd /var/lib/aolserver/service0/packages/acs-service-contract/sql/postgresql/upgrade/
psql -f upgrade-4.7d2-4.7d3.sql service0

For the Load acs-authentication data model I also had to cd to the directory, thus:
cd /var/lib/aolserver/service0/packages/acs-authentication/sql/postgresql/
psql -f acs-authentication-create.sql service0

I've also got a bunch of other errors to sort through, and I list excerpts.

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "enabled_p" not found

Error: Error sourcing /var/lib/aolserver/service0/packages/acs-templating/tcl/acs-templating-init.tcl:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

Error: apm_load_queries: Unable to locate /var/lib/aolserver/service0/packages/acs-content/*.
packages/monitoring/*.
packages/openfts-driver/*.
packages/schema-browser/*.
packages/simple-survey/*.

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "locale" not found

Error: Error sourcing /var/lib/aolserver/service0/packages/acs-lang/tcl/acs-lang-init.tcl:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") ERROR:  Attribute "locale" not found.

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "enabled_p" not found ... [16/Mar/2004:10:13:22][3730.1074087520][-main-] Error: Error sourcing /var/lib/aolserver/service0/packages/acs-templating/tcl/acs-templating-init.tcl: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR:  Attribute "enabled_p" not found

Warning: Gettings dicts and default_lang for aspell failed with error message: "Error: Unknown Action: dump dicts"
[16/Mar/2004:10:13:22][3730.1074087520][-main-] Notice: You might want to upgrade to a more recent version of Aspell ... http://aspell.sourceforge.net/

Warning: keepalive: insufficient maxkeepalive 0:
keepalive disabled

Error: Ns_PgExec: result status: 7 message: ERROR:  No such attribute bulk_mail_messages.status ... Error: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR:  No such attribute bulk_mail_messages.status

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "notif_user" not found ... Error: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") ERROR:  Attribute "notif_user" not found

Does anything look familiar to you/anyone?  I'll appreciate any tips!  Thanks!