Forum OpenACS Development: Re: install packages
[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 "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.
