Forum OpenACS Development: install packages

Collapse
1: install packages
Posted by Iuri Sampaio on 10/19/06 03:31 AM
I run OACS head on pg8.1.

After a few installations of random packages. i get this error on any new pkg that i try to install.

[18/Oct/2006:22:24:48][3651.1101376432][-conn:oacsbr::2] Error:

Failed to install Messaging, version 5.3.0d1. The following error was generated:

psql:acs-messaging-create.sql:24: ERROR:  duplicate key violates unique constraint "acs_object_types_pk"
CONTEXT:  SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 ,  $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:acs-messaging-create.sql:37: ERROR:  duplicate key violates unique constraint "acs_object_types_table_name_un"
CONTEXT:  SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 ,  $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:acs-messaging-create.sql:66: ERROR:  relation "acs_messages" already exists
psql:acs-messaging-create.sql:68: ERROR:  relation "acs_messages_tree_skey_idx" already exists
psql:acs-messaging-create.sql:69: ERROR:  relation "acs_messages_reply_to_idx" already exists
psql:acs-messaging-create.sql:70: ERROR:  relation "acs_messages_sender_idx" already exists
psql:acs-messaging-create.sql:71: ERROR:  relation "acs_messages_sent_idx" already exists
psql:acs-messaging-create.sql:128: ERROR:  cannot change return type of existing function
HINT:  Use DROP FUNCTION first.
psql:acs-messaging-create.sql:133: ERROR:  trigger "acs_message_insert_tr" for relation "acs_messages" already exists
psql:acs-messaging-create.sql:177: ERROR:  function "acs_message_update_tr" already exists with same argument types
psql:acs-messaging-create.sql:182: ERROR:  trigger "acs_message_update_tr" for relation "acs_messages" already exists
psql:acs-messaging-create.sql:197: ERROR:  relation "acs_messages_outgoing" already exists
psql:acs-messaging-views.sql:16: ERROR:  relation "acs_messages_all" already exists
psql:acs-messaging-views.sql:23: ERROR:  relation "acs_messages_latest" already exists

<font color="red">NOTE:</font> If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.

I already post at bugtracker:
http://www.openacs.org/bugtracker/openacs/bug?bug%5fnumber=2993

I guess there are more people having this trouble

Collapse
2: Re: install packages (response to 1)
Posted by Iuri Sampaio on 10/19/06 03:34 AM
here it is the log file. it says the pkg already exists but this's the first time i'm installing
Collapse
3: Re: install packages (response to 2)
Posted by Iuri Sampaio on 10/19/06 03:34 AM
sorry, :)

[18/Oct/2006:22:24:48][3651.1101376432][-conn:oacsbr::2] Error: apm_package_install: Error installing Messaging version 5.3.0d1: psql:acs-messaging-create.sql:24: ERROR: duplicate key violates unique constraint "acs_object_types_pk"
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:acs-messaging-create.sql:37: ERROR: duplicate key violates unique constraint "acs_object_types_table_name_un"
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:acs-messaging-create.sql:66: ERROR: relation "acs_messages" already exists
psql:acs-messaging-create.sql:68: ERROR: relation "acs_messages_tree_skey_idx" already exists
psql:acs-messaging-create.sql:69: ERROR: relation "acs_messages_reply_to_idx" already exists
psql:acs-messaging-create.sql:70: ERROR: relation "acs_messages_sender_idx" already exists
psql:acs-messaging-create.sql:71: ERROR: relation "acs_messages_sent_idx" already exists
psql:acs-messaging-create.sql:128: ERROR: cannot change return type of existing function
HINT: Use DROP FUNCTION first.
psql:acs-messaging-create.sql:133: ERROR: trigger "acs_message_insert_tr" for relation "acs_messages" already exists
psql:acs-messaging-create.sql:177: ERROR: function "acs_message_update_tr" already exists with same argument types
psql:acs-messaging-create.sql:182: ERROR: trigger "acs_message_update_tr" for relation "acs_messages" already exists
psql:acs-messaging-create.sql:197: ERROR: relation "acs_messages_outgoing" already exists
psql:acs-messaging-views.sql:16: ERROR: relation "acs_messages_all" already exists
psql:acs-messaging-views.sql:23: ERROR: relation "acs_messages_latest" already exists

psql:acs-messaging-create.sql:24: ERROR: duplicate key violates unique constraint "acs_object_types_pk"
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:acs-messaging-create.sql:37: ERROR: duplicate key violates unique constraint "acs_object_types_table_name_un"
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:acs-messaging-create.sql:66: ERROR: relation "acs_messages" already exists
psql:acs-messaging-create.sql:68: ERROR: relation "acs_messages_tree_skey_idx" already exists
psql:acs-messaging-create.sql:69: ERROR: relation "acs_messages_reply_to_idx" already exists
psql:acs-messaging-create.sql:70: ERROR: relation "acs_messages_sender_idx" already exists
psql:acs-messaging-create.sql:71: ERROR: relation "acs_messages_sent_idx" already exists
psql:acs-messaging-create.sql:128: ERROR: cannot change return type of existing function
HINT: Use DROP FUNCTION first.
psql:acs-messaging-create.sql:133: ERROR: trigger "acs_message_insert_tr" for relation "acs_messages" already exists
psql:acs-messaging-create.sql:177: ERROR: function "acs_message_update_tr" already exists with same argument types
psql:acs-messaging-create.sql:182: ERROR: trigger "acs_message_update_tr" for relation "acs_messages" already exists
psql:acs-messaging-create.sql:197: ERROR: relation "acs_messages_outgoing" already exists
psql:acs-messaging-views.sql:16: ERROR: relation "acs_messages_all" already exists
psql:acs-messaging-views.sql:23: ERROR: relation "acs_messages_latest" already exists

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 -data_model_files $data_model_files $spec_file_path"
invoked from within
"if { $load_data_model_p } {
apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path
..."
("uplevel" body line 53)
invoked from within
"uplevel $body "
[18/Oct/2006:22:24:48][3651.1101376432][-conn:oacsbr::2] Error:

Failed to install Messaging, version 5.3.0d1. The following error was generated:

psql:acs-messaging-create.sql:24: ERROR:  duplicate key violates unique constraint &quot;acs_object_types_pk&quot;
CONTEXT:  SQL statement &quot;insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 ,  $10 )&quot;
PL/pgSQL function &quot;acs_object_type__create_type&quot; line 37 at SQL statement
psql:acs-messaging-create.sql:37: ERROR:  duplicate key violates unique constraint &quot;acs_object_types_table_name_un&quot;
CONTEXT:  SQL statement &quot;insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 ,  $10 )&quot;
PL/pgSQL function &quot;acs_object_type__create_type&quot; line 37 at SQL statement
psql:acs-messaging-create.sql:66: ERROR:  relation &quot;acs_messages&quot; already exists
psql:acs-messaging-create.sql:68: ERROR:  relation &quot;acs_messages_tree_skey_idx&quot; already exists
psql:acs-messaging-create.sql:69: ERROR:  relation &quot;acs_messages_reply_to_idx&quot; already exists
psql:acs-messaging-create.sql:70: ERROR:  relation &quot;acs_messages_sender_idx&quot; already exists
psql:acs-messaging-create.sql:71: ERROR:  relation &quot;acs_messages_sent_idx&quot; already exists
psql:acs-messaging-create.sql:128: ERROR:  cannot change return type of existing function
HINT:  Use DROP FUNCTION first.
psql:acs-messaging-create.sql:133: ERROR:  trigger &quot;acs_message_insert_tr&quot; for relation &quot;acs_messages&quot; already exists
psql:acs-messaging-create.sql:177: ERROR:  function &quot;acs_message_update_tr&quot; already exists with same argument types
psql:acs-messaging-create.sql:182: ERROR:  trigger &quot;acs_message_update_tr&quot; for relation &quot;acs_messages&quot; already exists
psql:acs-messaging-create.sql:197: ERROR:  relation &quot;acs_messages_outgoing&quot; already exists
psql:acs-messaging-views.sql:16: ERROR:  relation &quot;acs_messages_all&quot; already exists
psql:acs-messaging-views.sql:23: ERROR:  relation &quot;acs_messages_latest&quot; already exists

<font color="red">NOTE:</font> If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.

Collapse
4: Re: install packages (response to 1)
Posted by Vinod Kurup on 10/19/06 04:37 AM
Hi Iuri,

Did you follow the first instructions on this page:

https://openacs.org/xowiki/en/How_to_install_in_Postgres_8%2e1%2ex

Specifically, you need to edit some parameters in postgresql.conf and then restart PG.

You'll then have to drop your DB and recreate it and then retry the install.

Collapse
5: Re: install packages (response to 4)
Posted by Iuri Sampaio on 10/20/06 09:12 PM
yes i did.