Forum OpenACS Development: acs-lang error while installing from HEAD

From a 2003-Jun-24 checkout. Fails during step two. On the web page, the last thing is
 Completing Install sequence by mounting the main site and other core packages.

CREATE FUNCTION
 inline_0 
----------
(1 row)
DROP FUNCTION
In the log file:
[25/Jun/2003:20:21:56][24769.1078410464][-conn0-] Notice: Mounting acs-lang
[25/Jun/2003:20:21:56][24769.1074120288][-main-] Notice: tclinit: re-initalizing tcl
[25/Jun/2003:20:21:56][24769.1074120288][-main-] Notice: tcl: generating interp init script
[25/Jun/2003:20:21:57][24769.1078410464][-conn0-] Error: Ns_PgExec: result status: 7 message: ERROR:  apm_packages_package_key_
fk referential integrity violation - key referenced from apm_packages not found in apm_package_types

[25/Jun/2003:20:21:57][24769.1078410464][-conn0-] Error: Error sourcing /web/service0/packages/acs-bootstrap-installer/installe
r/packages-install.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  apm_packages_package_key_fk referential integrity violation - key referenced from apm_packages not found in apm_package
_types

and so forth
When I reload the page, it hangs with different errors, and this is in the log file:
[25/Jun/2003:20:30:18][24769.1081207648][-conn3-] Notice: /web/service0/packages/acs-lang/acs-lang.info
[25/Jun/2003:20:30:18][24769.1081207648][-conn3-] Notice: /web/service0/packages/acs-notification/acs-notification.info
[25/Jun/2003:20:30:18][24769.1081207648][-conn3-] Warning: Unable to locate specification file for package acs-notification: Th
e /web/service0/packages/acs-notification/acs-notification.info/acs-notification does not contain a package specification file
(acs-notification.info).
[25/Jun/2003:20:30:18][24769.1081207648][-conn3-] Notice: /web/service0/packages/acs-reference/acs-reference.info
[25/Jun/2003:20:30:18][24769.1081207648][-conn3-] Notice: /web/service0/packages/acs-workflow/acs-workflow.info
[25/Jun/2003:20:30:22][24769.1081207648][-conn3-] Error: Acs-lang not installed
Error:
psql:ad-locales.sql:200: ERROR:  Cannot insert a duplicate key into unique index ad_locale_abbrev_pk
psql:ad-locales.sql:205: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:210: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:215: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:220: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:225: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:230: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:235: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:59: ERROR:  Relation "ad_locales" does not exist
psql:message-catalog.sql:82: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:110: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:128: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:200: ERROR:  Cannot insert a duplicate key into unique index ad_locale_abbrev_pk
psql:ad-locales.sql:205: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:210: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:215: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:220: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:225: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:230: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:235: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:59: ERROR:  Relation "ad_locales" does not exist
psql:message-catalog.sql:82: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:110: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:128: ERROR:  current transaction is aborted, queries ignored until end of transaction block

    invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
   (procedure "apm_package_install_data_model" line 32)
    invoked from within
"apm_package_install_data_model -callback $callback $spec_file"
[25/Jun/2003:20:30:24][24769.1081207648][-conn3-] Error: Error sourcing /web/service0/packages/acs-bootstrap-installer/installe
r/packages-install.tcl:
psql:acs-install.sql:76: WARNING:  Error occurred while executing PL/pgSQL function inline_0
psql:acs-install.sql:76: WARNING:  line 20 at SQL statement
psql:acs-install.sql:76: ERROR:  Cannot insert a duplicate key into unique index app_groups_group_id_pk

    invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-install.sql"
    invoked from within
"if { ![ad_acs_admin_node] } {
    ns_write "   Completing Install sequence by mounting the main site and other core packages.

..." (file "/web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl" line 44) invoked from within "source $__file " [25/Jun/2003:20:30:27][24769.1081711328][-conn4-] Notice: Loading acs-tcl init file utilities-init.tcl [25/Jun/2003:20:30:27][24769.1081711328][-conn4-] Notice: Loading acs-tcl init file site-nodes-init.tcl [25/Jun/2003:20:30:27][24769.1074120288][-main-] Notice: tclinit: re-initalizing tcl [25/Jun/2003:20:30:27][24769.1074120288][-main-] Notice: tcl: generating interp init script [25/Jun/2003:20:30:28][24769.1081711328][-conn4-] Notice: Loading packages/acs-subsite/tcl/application-group-procs.tcl...

Collapse
Posted by jorge freitas on
I have the same problem as Joel, during the installation from the HEAD. Anyone knows what the problem is?
Thanks.
Collapse
Posted by Don Baccus on
I'm doing a reinstall later today I'll check it out.  Also I've been fixing some things and have some commits to do.
Collapse
Posted by Tilmann Singer on
There were duplicate key errors in ad-locales.sql (both pg and oracle). Peter mailed me that he fixed it in CVS today, so you might want to update and try again.
Collapse
Posted by Joel Aufrecht on
fresh checkout fixed it for me, thx.