Home
The Toolkit for Online Communities
16688 Community Members, 1 member online, 2178 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : tdom compile in aolserver error.."TT"

Forum OpenACS Q&A: tdom compile in aolserver error.."TT"

Icon of envelope Request notifications

Collapse
Posted by yi jongwook on
postgresql7.4.2  aolserver 3.3 osc 1 tomcat4.1.30

1)dotlrn error.log

[16/Jul/2004:11:51:14][6023.16384][-main-] Notice: modload: loading '/usr/local/aolserver/bin/libtdom0.7.8.so'
[16/Jul/2004:11:51:14][6023.16384][-main-] Warning: modload: no such symbol 'Ns_ModuleInit' in module '/usr/local/aolserver/bin/libtdom0.7.8.so'
[16/Jul/2004:11:51:14][6023.16384][-main-] Fatal: modload: failed to load module '/usr/local/aolserver/bin/libtdom0.7.8.so

2)compile tdom

unix dir ../configure
make
make test

........
all.tcl: total 506 passed 501  skipped 4  failed 1
sourced 21 test files
files with failing test: domcmd.test
number of tests skipped for each constraint:
4 knownbug

DO YOU KNOW.....?

Collapse
Posted by Jade Rubick on
Not sure, but you do need to get it compiled an put the .so file in /usr/local/aolserver/bin

Did you follow the install guide?

Can you provide more details?

Collapse
Posted by russell muetzelfeldt on
If you're using AOLserver v3 you need to build tDOM as an AOLserver module. See the instructions in README.AOL and unix/CONFIG. In short, you need to pass --with-aolserver and --with-tcl flags to configure.
Collapse
4: thanks... (response to 1)
Posted by yi jongwook on
I worked fine ........but

openacs installation error...

..document no data....

upgrade openacs4.6.2 to 5.1.0

and openacs 5.1.0 dir is not file packages-inatall...

how do i......
Collapse
Posted by Torben Brosten on
Documentation Chapter 5 explains how to upgrade

http://openacs.org/doc/current/upgrade-overview.html

There have been reports that some (usually insignificant) data is lost in the upgrade process.

Hope this helps,

Torben

Collapse
Posted by yi jongwook on
installation error (openacs 5.1.0)

[21/Jul/2004:02:20:36][7814.49156][-conn0-] Error: Unable to source /web/dotlrn/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[21/Jul/2004:02:23:30][7814.81926][-conn2-] Error: tclop: invalid return code from filter proc '': must be filter_ok, filter_return, or filter_break
[21/Jul/2004:08:36:06][7814.114696][-conn4-] Error: Unable to source /web/dotlrn/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.

Collapse
Posted by yi jongwook on
openacs installation: installing openacs core services error

Failed to install ACS Kernel, version 4.7.2d. The following error was generated:

psql:postgresql.sql:1: ERROR: relation "dual" already exists psql:postgresql.sql:4: ERROR: relation "t_anon_func_seq" already exists psql:postgresql.sql:6: ERROR: relation "anon_func_seq" already exists psql:postgresql.sql:44: ERROR: function "instr" already exists with same argument types psql:postgresql.sql:54: ERROR: function "instr" already exists with same argument types psql:postgresql.sql:63: ERROR: function "instr" already exists with same argument types psql:postgresql.sql:97: ERROR: function "split" already exists with same argument types psql:postgresql.sql:142: ERROR: function "get_func_drop_command" already exists with same argument types psql:postgresql.sql:172: ERROR: function "drop_package" already exists with same argument types psql:postgresql.sql:197: ERROR: function "number_src" already exists with same argument types psql:postgresql.sql:247: ERROR: function "get_func_definition" already exists with same argument types psql:postgresql.sql:261: ERROR: function "get_func_header" already exists with same argument types psql:postgresql.sql:266: ERROR: relation "acs_func_defs" already exists psql:postgresql.sql:271: ERROR: relation "acs_func_headers" already exists psql:postgresql.sql:408: ERROR: function "int_to_tree_key" already exists with same argument types psql:postgresql.sql:444: ERROR: function "tree_key_to_int" already exists with same argument types psql:postgresql.sql:473: ERROR: function "tree_ancestor_key" already exists with same argument types psql:postgresql.sql:490: ERROR: function "tree_root_key" already exists with same argument types psql:postgresql.sql:519: ERROR: function "tree_leaf_key_to_int" already exists with same argument types psql:postgresql.sql:545: ERROR: function "tree_next_key" already exists with same argument types psql:postgresql.sql:560: ERROR: function "tree_increment_key" already exists with same argument types psql:postgresql.sql:575: ERROR: function "tree_left" already exists with same argument types psql:postgresql.sql:591: ERROR: function "tree_right" already exists with same argument types psql:postgresql.sql:622: ERROR: function "tree_level" already exists with same argument types psql:postgresql.sql:630: ERROR: function "tree_ancestor_p" already exists with same argument types psql:postgresql.sql:644: ERROR: function "tree_ancestor_keys" already exists with same argument types psql:postgresql.sql:703: ERROR: function "tree_ancestor_keys" already exists with same argument types psql:postgresql.sql:716: ERROR: relation "user_tab_columns" already exists psql:postgresql.sql:725: ERROR: relation "user_col_comments" already exists psql:postgresql.sql:738: ERROR: relation "user_tab_comments" already exists psql:postgresql.sql:751: ERROR: relation "acs_function_args" already exists psql:postgresql.sql:791: ERROR: function "define_function_args" already exists with same argument types psql:postgresql.sql:834: ERROR: function "trigger_type" already exists with same argument types psql:lob.sql:19: ERROR: relation "lob_sequence" already exists psql:lob.sql:24: ERROR: relation "lobs" already exists psql:lob.sql:30: ERROR: function "on_lobs_delete" already exists with same argument types psql:lob.sql:33: ERROR: trigger "lobs_delete_trig" for relation "lobs" already exists psql:lob.sql:41: ERROR: relation "lob_data" already exists psql:lob.sql:43: ERROR: relation "lob_data_index" already exists psql:lob.sql:77: ERROR: function "on_lob_ref" already exists with same argument types psql:lob.sql:82: ERROR: function "empty_lob" already exists with same argument types psql:lob.sql:96: ERROR: function "lob_get_data" already exists with same argument types psql:lob.sql:112: ERROR: function "lob_copy" already exists with same argument types psql:lob.sql:119: ERROR: function "lob_length" already exists with same argument types psql:acs-logs-create.sql:9: ERROR: relation "t_acs_log_id_seq" already exists psql:acs-logs-create.sql:11: ERROR: relation "acs_log_id_seq" already exists psql:acs-logs-create.sql:24: ERROR: relation "acs_logs" already exists psql:acs-logs-create.sql:67: ERROR: function "acs_log__notice" already exists with same argument types psql:acs-logs-create.sql:83: ERROR: function "acs_log__warn" already exists with same argument types psql:acs-logs-create.sql:99: ERROR: function "acs_log__error" already exists with same argument types psql:acs-logs-create.sql:115: ERROR: function "acs_log__debug" already exists with same argument types psql:acs-metadata-create.sql:53: ERROR: relation "acs_object_types" already exists psql:acs-metadata-create.sql:55: ERROR: relation "acs_obj_types_supertype_idx" already exists psql:acs-metadata-create.sql:56: ERROR: relation "acs_obj_types_tree_skey_idx" already exists psql:acs-metadata-create.sql:65: ERROR: function "acs_object_type_get_tree_sortkey" already exists with same argument types psql:acs-metadata-create.sql:84: ERROR: function "acs_object_type_insert_tr" already exists with same argument types psql:acs-metadata-create.sql:88: ERROR: trigger "acs_object_type_insert_tr" for relation "acs_object_types" already exists psql:acs-metadata-create.sql:132: ERROR: function "acs_object_type_update_tr" already exists with same argument types psql:acs-metadata-create.sql:137: ERROR: trigger "acs_object_type_update_tr" for relation "acs_object_types" already exists psql:acs-metadata-create.sql:238: ERROR: relation "acs_object_type_supertype_map" already exists psql:acs-metadata-create.sql:248: ERROR: relation "acs_object_type_tables" already exists psql:acs-metadata-create.sql:250: ERROR: relation "acs_objtype_tbls_objtype_idx" already exists psql:acs-metadata-create.sql:273: ERROR: relation "acs_datatypes" already exists psql:acs-metadata-create.sql:355: ERROR: duplicate key violates unique constraint "acs_datatypes_pk" CONTEXT: PL/pgSQL function "inline_0" line 2 at SQL statement psql:acs-metadata-create.sql:364: ERROR: relation "t_acs_attribute_id_seq" already exists psql:acs-metadata-create.sql:366: ERROR: relation "acs_attribute_id_seq" already exists psql:acs-metadata-create.sql:407: ERROR: relation "acs_attributes" already exists psql:acs-metadata-create.sql:411: ERROR: relation "acs_attrs_obj_type_idx" already exists psql:acs-metadata-create.sql:412: ERROR: relation "acs_attrs_tbl_name_idx" already exists psql:acs-metadata-create.sql:413: ERROR: relation "acs_attrs_datatype_idx" already exists psql:acs-metadata-create.sql:465: ERROR: relation "acs_enum_values" already exists psql:acs-metadata-create.sql:467: ERROR: relation "acs_enum_values_attr_id_idx" already exists psql:acs-metadata-create.sql:480: ERROR: relation "acs_attribute_descriptions" already exists psql:acs-metadata-create.sql:482: ERROR: relation "acs_attr_desc_obj_type_idx" already exists psql:acs-metadata-create.sql:483: ERROR: relation "acs_attr_desc_attr_name_idx" already exists psql:acs-metadata-create.sql:512: ERROR: relation "acs_object_type_attributes" already exists psql:acs-metadata-create.sql:569: ERROR: function "acs_object_type__create_type" already exists with same argument types psql:acs-metadata-create.sql:597: ERROR: function "acs_object_type__drop_type" already exists with same argument types psql:acs-metadata-create.sql:613: ERROR: function "acs_object_type__pretty_name" already exists with same argument types psql:acs-metadata-create.sql:644: ERROR: function "acs_object_type__is_subtype_p" already exists with same argument types psql:acs-metadata-create.sql:700: ERROR: function "acs_attribute__create_attribute" already exists with same argument types psql:acs-metadata-create.sql:706: ERROR: function "acs_attribute__create_attribute" already exists with same argument types psql:acs-metadata-create.sql:727: ERROR: function "acs_attribute__drop_attribute" already exists with same argument types psql:acs-metadata-create.sql:746: ERROR: function "acs_attribute__add_description" already exists with same argument types psql:acs-metadata-create.sql:763: ERROR: function "acs_attribute__drop_description" already exists with same argument types psql:acs-objects-create.sql:156: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at perform psql:acs-objects-create.sql:171: ERROR: relation "t_acs_object_id_seq" already exists psql:acs-objects-create.sql:173: ERROR: relation "acs_object_id_seq" already exists psql:acs-objects-create.sql:193: ERROR: relation "acs_objects" already exists psql:acs-objects-create.sql:196: ERROR: relation "acs_objects_context_object_idx" already exists psql:acs-objects-create.sql:198: ERROR: relation "acs_objs_tree_skey_idx" already exists psql:acs-objects-create.sql:202: ERROR: relation "acs_objects_creation_user_idx" already exists psql:acs-objects-create.sql:203: ERROR: relation "acs_objects_modify_user_idx" already exists psql:acs-objects-create.sql:205: ERROR: relation "acs_objects_object_type_idx" already exists psql:acs-objects-create.sql:213: ERROR: function "acs_objects_mod_ip_insert_tr" already exists with same argument types psql:acs-objects-create.sql:216: ERROR: trigger "acs_objects_mod_ip_insert_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:226: ERROR: function "acs_objects_last_mod_update_tr" already exists with same argument types psql:acs-objects-create.sql:229: ERROR: trigger "acs_objects_last_mod_update_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:238: ERROR: function "acs_objects_get_tree_sortkey" already exists with same argument types psql:acs-objects-create.sql:264: ERROR: function "acs_objects_insert_tr" already exists with same argument types psql:acs-objects-create.sql:268: ERROR: trigger "acs_objects_insert_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:323: ERROR: function "acs_objects_update_tr" already exists with same argument types psql:acs-objects-create.sql:328: ERROR: trigger "acs_objects_update_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:371: ERROR: relation "acs_object_context_index" already exists psql:acs-objects-create.sql:373: ERROR: relation "acs_obj_ctx_idx_ancestor_idx" already exists psql:acs-objects-create.sql:377: ERROR: relation "acs_object_paths" already exists psql:acs-objects-create.sql:382: ERROR: relation "acs_object_contexts" already exists psql:acs-objects-create.sql:413: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-objects-create.sql:416: ERROR: trigger "acs_objects_context_id_in_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:480: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-objects-create.sql:483: ERROR: trigger "acs_objects_context_id_up_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:492: ERROR: function "acs_objects_context_id_del_tr" already exists with same argument types psql:acs-objects-create.sql:495: ERROR: trigger "acs_objects_context_id_del_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:501: ERROR: relation "t_acs_attribute_value_id_seq" already exists psql:acs-objects-create.sql:503: ERROR: relation "acs_attribute_value_id_seq" already exists psql:acs-objects-create.sql:515: ERROR: relation "acs_attribute_values" already exists psql:acs-objects-create.sql:517: ERROR: relation "acs_attr_values_attr_id_idx" already exists psql:acs-objects-create.sql:535: ERROR: relation "acs_static_attr_values" already exists psql:acs-objects-create.sql:537: ERROR: relation "acs_stat_attrs_attr_id_idx" already exists psql:acs-objects-create.sql:587: ERROR: function "acs_object__initialize_attributes" already exists with same argument types psql:acs-objects-create.sql:629: ERROR: function "acs_object__new" already exists with same argument types psql:acs-objects-create.sql:668: ERROR: function "acs_object__new" already exists with same argument types psql:acs-objects-create.sql:676: ERROR: function "acs_object__new" already exists with same argument types psql:acs-objects-create.sql:730: ERROR: function "acs_object__delete" already exists with same argument types psql:acs-objects-create.sql:783: ERROR: function "acs_object__name" already exists with same argument types psql:acs-objects-create.sql:801: ERROR: function "acs_object__default_name" already exists with same argument types psql:acs-objects-create.sql:936: ERROR: function "acs_object__get_attribute_storage" already exists with same argument types psql:acs-objects-create.sql:952: ERROR: function "acs_object__get_attr_storage_column" already exists with same argument types psql:acs-objects-create.sql:973: ERROR: function "acs_object__get_attr_storage_table" already exists with same argument types psql:acs-objects-create.sql:994: ERROR: function "acs_object__get_attr_storage_sql" already exists with same argument types psql:acs-objects-create.sql:1027: ERROR: function "acs_object__get_attribute" already exists with same argument types psql:acs-objects-create.sql:1053: ERROR: function "acs_object__set_attribute" already exists with same argument types psql:acs-objects-create.sql:1101: ERROR: function "acs_object__check_context_index" already exists with same argument types psql:acs-objects-create.sql:1168: ERROR: function "acs_object__check_object_ancestors" already exists with same argument types psql:acs-objects-create.sql:1213: ERROR: function "acs_object__check_object_descendants" already exists with same argument types psql:acs-objects-create.sql:1249: ERROR: function "acs_object__check_path" already exists with same argument types psql:acs-objects-create.sql:1337: ERROR: function "acs_object__check_representation" already exists with same argument types psql:acs-objects-create.sql:1345: ERROR: function "acs_object__update_last_modified" already exists with same argument types psql:acs-objects-create.sql:1375: ERROR: function "acs_object__update_last_modified" already exists with same argument types psql:acs-objects-create.sql:1393: ERROR: relation "general_objects" already exists psql:acs-object-util.sql:16: ERROR: function "acs_object_util__object_type_exist_p" already exists with same argument types psql:acs-object-util.sql:35: ERROR: function "acs_object_util__get_object_type" already exists with same argument types psql:acs-object-util.sql:58: ERROR: function "acs_object_util__type_ancestor_type_p" already exists with same argument types psql:acs-object-util.sql:74: ERROR: function "acs_object_util__object_ancestor_type_p" already exists with same argument types psql:acs-object-util.sql:86: ERROR: function "acs_object_util__object_type_p" already exists with same argument types psql:acs-relationships-create.sql:22: ERROR: relation "acs_rel_roles" already exists psql:acs-relationships-create.sql:55: ERROR: relation "acs_rel_types" already exists psql:acs-relationships-create.sql:57: ERROR: relation "acs_rel_types_objtypeone_idx" already exists psql:acs-relationships-create.sql:58: ERROR: relation "acs_rel_types_role_one_idx" already exists psql:acs-relationships-create.sql:59: ERROR: relation "acs_rel_types_objtypetwo_idx" already exists psql:acs-relationships-create.sql:60: ERROR: relation "acs_rel_types_role_two_idx" already exists psql:acs-relationships-create.sql:97: ERROR: function "acs_rel_type__create_role" already exists with same argument types psql:acs-relationships-create.sql:106: ERROR: function "acs_rel_type__create_role" already exists with same argument types psql:acs-relationships-create.sql:119: ERROR: function "acs_rel_type__drop_role" already exists with same argument types psql:acs-relationships-create.sql:135: ERROR: function "acs_rel_type__role_pretty_name" already exists with same argument types psql:acs-relationships-create.sql:151: ERROR: function "acs_rel_type__role_pretty_plural" already exists with same argument types psql:acs-relationships-create.sql:205: ERROR: function "acs_rel_type__create_type" already exists with same argument types psql:acs-relationships-create.sql:261: ERROR: function "acs_rel_type__create_type" already exists with same argument types psql:acs-relationships-create.sql:279: ERROR: function "acs_rel_type__drop_type" already exists with same argument types psql:acs-relationships-create.sql:299: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "acs_rel_type__create_type" line 23 at perform psql:acs-relationships-create.sql:308: ERROR: relation "t_acs_rel_id_seq" already exists psql:acs-relationships-create.sql:310: ERROR: relation "acs_rel_id_seq" already exists psql:acs-relationships-create.sql:328: ERROR: relation "acs_rels" already exists psql:acs-relationships-create.sql:330: ERROR: relation "acs_rels_object_id_one_idx" already exists psql:acs-relationships-create.sql:331: ERROR: relation "acs_rels_object_id_two_idx" already exists psql:acs-relationships-create.sql:405: ERROR: function "acs_rels_in_tr" already exists with same argument types psql:acs-relationships-create.sql:408: ERROR: trigger "acs_rels_in_tr" for relation "acs_rels" already exists psql:acs-relationships-create.sql:466: ERROR: function "acs_rel__new" already exists with same argument types psql:acs-relationships-create.sql:478: ERROR: function "acs_rel__delete" already exists with same argument types psql:acs-relationships-create.sql:505: ERROR: relation "rel_types_valid_obj_one_types" already exists psql:acs-relationships-create.sql:526: ERROR: relation "rel_types_valid_obj_two_types" already exists psql:utilities-create.sql:53: ERROR: function "util__multiple_nextval" already exists with same argument types psql:utilities-create.sql:71: ERROR: function "rawtohex" already exists with same argument types psql:utilities-create.sql:80: ERROR: function "util__computehash_raw" already exists with same argument types psql:utilities-create.sql:93: ERROR: function "util__computehash" already exists with same argument types psql:utilities-create.sql:107: ERROR: function "util__logical_negation" already exists with same argument types psql:community-core-create.sql:237: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at perform psql:community-core-create.sql:256: ERROR: relation "parties" already exists psql:community-core-create.sql:296: ERROR: function "party__new" already exists with same argument types psql:community-core-create.sql:306: ERROR: function "party__delete" already exists with same argument types psql:community-core-create.sql:319: ERROR: function "party__name" already exists with same argument types psql:community-core-create.sql:334: ERROR: function "party__email" already exists with same argument types psql:community-core-create.sql:349: ERROR: relation "persons" already exists psql:community-core-create.sql:421: ERROR: function "person__new" already exists with same argument types psql:community-core-create.sql:436: ERROR: function "person__delete" already exists with same argument types psql:community-core-create.sql:453: ERROR: function "person__name" already exists with same argument types psql:community-core-create.sql:470: ERROR: function "person__first_names" already exists with same argument types psql:community-core-create.sql:487: ERROR: function "person__last_name" already exists with same argument types psql:community-core-create.sql:512: ERROR: relation "users" already exists psql:community-core-create.sql:524: ERROR: relation "user_preferences" already exists psql:community-core-create.sql:537: ERROR: duplicate key violates unique constraint "acs_object_type_tables_pk" CONTEXT: PL/pgSQL function "inline_1" line 3 at SQL statement psql:community-core-create.sql:547: ERROR: constraint "acs_objects_creation_user_fk" for relation "acs_objects" already exists psql:community-core-create.sql:550: ERROR: constraint "acs_objects_modifying_user_fk" for relation "acs_objects" already exists psql:community-core-create.sql:683: ERROR: function "acs_user__new" already exists with same argument types psql:community-core-create.sql:713: ERROR: function "acs_user__new" already exists with same argument types psql:community-core-create.sql:730: ERROR: function "acs_user__receives_alerts_p" already exists with same argument types psql:community-core-create.sql:744: ERROR: function "acs_user__approve_email" already exists with same argument types psql:community-core-create.sql:758: ERROR: function "acs_user__unapprove_email" already exists with same argument types psql:community-core-create.sql:776: ERROR: function "acs_user__delete" already exists with same argument types psql:groups-create.sql:24: ERROR: relation "composition_rels" already exists psql:groups-create.sql:35: ERROR: relation "membership_rels" already exists psql:groups-create.sql:125: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at assignment psql:groups-create.sql:143: ERROR: relation "group_types" already exists psql:groups-create.sql:160: ERROR: relation "groups" already exists psql:groups-create.sql:175: ERROR: relation "group_type_rels" already exists psql:groups-create.sql:178: ERROR: relation "group_type_rels_rel_type_idx" already exists psql:groups-create.sql:199: ERROR: relation "group_rels" already exists psql:groups-create.sql:202: ERROR: relation "group_rels_rel_type_idx" already exists psql:groups-create.sql:261: ERROR: relation "group_element_index" already exists psql:groups-create.sql:263: ERROR: relation "group_elem_idx_group_idx" already exists psql:groups-create.sql:264: ERROR: relation "group_elem_idx_element_idx" already exists psql:groups-create.sql:265: ERROR: relation "group_elem_idx_rel_id_idx" already exists psql:groups-create.sql:266: ERROR: relation "group_elem_idx_container_idx" already exists psql:groups-create.sql:267: ERROR: relation "group_elem_idx_rel_type_idx" already exists psql:groups-create.sql:285: ERROR: relation "group_element_map" already exists psql:groups-create.sql:290: ERROR: relation "group_component_map" already exists psql:groups-create.sql:295: ERROR: relation "group_member_map" already exists psql:groups-create.sql:301: ERROR: relation "group_approved_member_map" already exists psql:groups-create.sql:305: ERROR: relation "group_distinct_member_map" already exists psql:groups-create.sql:312: ERROR: relation "group_component_index" already exists psql:groups-create.sql:313: ERROR: relation "group_member_index" already exists psql:groups-create.sql:355: ERROR: function "group_contains_p" already exists with same argument types psql:groups-create.sql:378: ERROR: function "membership_rels_in_tr" already exists with same argument types psql:groups-create.sql:381: ERROR: trigger "membership_rels_in_tr" for relation "membership_rels" already exists psql:groups-create.sql:393: ERROR: function "composition_rels_in_tr" already exists with same argument types psql:groups-create.sql:396: ERROR: trigger "composition_rels_in_tr" for relation "composition_rels" already exists psql:groups-create.sql:409: ERROR: duplicate key violates unique constraint "gtr_group_rel_types_un" psql:groups-create.sql:414: ERROR: duplicate key violates unique constraint "gtr_group_rel_types_un" psql:rel-segments-create.sql:42: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at perform psql:rel-segments-create.sql:69: ERROR: relation "rel_segments" already exists psql:rel-segments-create.sql:72: ERROR: relation "rel_segments_rel_type_idx" already exists psql:rel-segments-create.sql:106: ERROR: relation "rel_segment_party_map" already exists psql:rel-segments-create.sql:110: ERROR: relation "rel_segment_distinct_party_map" already exists psql:rel-segments-create.sql:116: ERROR: relation "rel_segment_member_map" already exists psql:rel-segments-create.sql:127: ERROR: relation "rel_seg_approved_member_map" already exists psql:rel-segments-create.sql:131: ERROR: relation "rel_seg_distinct_member_map" already exists psql:rel-segments-create.sql:174: ERROR: relation "party_approved_member_map" already exists psql:rel-segments-create.sql:177: ERROR: relation "party_member_member_idx" already exists psql:rel-segments-create.sql:285: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:288: ERROR: trigger "parties_in_tr" for relation "parties" already exists psql:rel-segments-create.sql:299: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:302: ERROR: trigger "parties_del_tr" for relation "parties" already exists psql:rel-segments-create.sql:322: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:325: ERROR: trigger "rel_segments_in_tr" for relation "rel_segments" already exists psql:rel-segments-create.sql:339: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:342: ERROR: trigger "rel_segments_del_tr" for relation "rel_segments" already exists psql:rel-segments-create.sql:367: ERROR: relation "rel_segment_group_rel_type_map" already exists psql:rel-constraints-create.sql:39: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 2 at perform psql:rel-constraints-create.sql:66: ERROR: relation "rel_constraints" already exists psql:rel-constraints-create.sql:69: ERROR: relation "rel_constraint_req_rel_seg_idx" already exists psql:rel-constraints-create.sql:134: ERROR: relation "constrained_rels1" already exists psql:rel-constraints-create.sql:141: ERROR: relation "rel_constraints_violated_one" already exists psql:rel-constraints-create.sql:176: ERROR: relation "constrained_rels2" already exists psql:rel-constraints-create.sql:184: ERROR: relation "rel_constraints_violated_two" already exists psql:rel-constraints-create.sql:226: ERROR: relation "rc_all_constraints" already exists psql:rel-constraints-create.sql:232: ERROR: relation "rc_all_distinct_constraints" already exists psql:rel-constraints-create.sql:255: ERROR: relation "rc_required_rel_segments" already exists psql:rel-constraints-create.sql:277: ERROR: relation "comp_or_member_rel_types" already exists psql:rel-constraints-create.sql:281: ERROR: relation "group_rel_type_combos" already exists psql:rel-constraints-create.sql:295: ERROR: relation "parties_in_required_segs" already exists psql:rel-constraints-create.sql:300: ERROR: relation "total_num_required_segs" already exists psql:rel-constraints-create.sql:323: ERROR: relation "rc_parties_in_required_segs" already exists psql:rel-constraints-create.sql:385: ERROR: relation "side_one_constraints" already exists psql:rel-constraints-create.sql:391: ERROR: relation "total_side_one_constraints" already exists psql:rel-constraints-create.sql:394: ERROR: relation "rc_all_constraints_view" already exists psql:rel-constraints-create.sql:411: ERROR: relation "rc_valid_rel_types" already exists psql:rel-constraints-create.sql:444: ERROR: relation "rc_violations_by_removing_rel" already exists psql:rel-constraints-create.sql:494: ERROR: relation "rc_segment_required_seg_map" already exists psql:rel-constraints-create.sql:497: ERROR: relation "rc_segment_required_seg_idx" already exists psql:rel-constraints-create.sql:536: ERROR: function "rel_constraints_ins_tr" already exists with same argument types psql:rel-constraints-create.sql:540: ERROR: trigger "rel_constraints_ins_tr" for relation "rel_constraints" already exists psql:rel-constraints-create.sql:586: ERROR: function "rel_constraints_del_tr" already exists with same argument types psql:rel-constraints-create.sql:590: ERROR: trigger "rel_constraints_del_tr" for relation "rel_constraints" already exists psql:rel-constraints-create.sql:642: ERROR: relation "rc_segment_dependency_levels" already exists psql:acs-permissions-create.sql:26: ERROR: relation "acs_privileges" already exists psql:acs-permissions-create.sql:37: ERROR: relation "acs_privilege_hierarchy" already exists psql:acs-permissions-create.sql:39: ERROR: relation "acs_priv_hier_child_priv_idx" already exists psql:acs-permissions-create.sql:49: ERROR: relation "acs_privilege_hierarchy_index" already exists psql:acs-permissions-create.sql:52: ERROR: relation "priv_hier_sortkey_idx" already exists psql:acs-permissions-create.sql:67: ERROR: relation "acs_privilege_descendant_map" already exists psql:acs-permissions-create.sql:72: ERROR: relation "acs_priv_desc_map_idx" already exists psql:acs-permissions-create.sql:180: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-permissions-create.sql:184: ERROR: trigger "acs_priv_hier_ins_del_tr" for relation "acs_privilege_hierarchy" already exists psql:acs-permissions-create.sql:194: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-permissions-create.sql:198: ERROR: trigger "acs_priv_del_tr" for relation "acs_privileges" already exists psql:acs-permissions-create.sql:253: ERROR: function "priv_recurse_subtree" already exists with same argument types psql:acs-permissions-create.sql:282: ERROR: function "acs_privilege__create_privilege" already exists with same argument types psql:acs-permissions-create.sql:290: ERROR: function "acs_privilege__create_privilege" already exists with same argument types psql:acs-permissions-create.sql:302: ERROR: function "acs_privilege__drop_privilege" already exists with same argument types psql:acs-permissions-create.sql:316: ERROR: function "acs_privilege__add_child" already exists with same argument types psql:acs-permissions-create.sql:329: ERROR: function "acs_privilege__remove_child" already exists with same argument types psql:acs-permissions-create.sql:348: ERROR: relation "acs_permissions" already exists psql:acs-permissions-create.sql:350: ERROR: relation "acs_permissions_grantee_idx" already exists psql:acs-permissions-create.sql:351: ERROR: relation "acs_permissions_privilege_idx" already exists psql:acs-permissions-create.sql:369: ERROR: relation "acs_privilege_descendant_map_view" already exists psql:acs-permissions-create.sql:374: ERROR: relation "acs_permissions_all" already exists psql:acs-permissions-create.sql:379: ERROR: relation "acs_object_grantee_priv_map" already exists psql:acs-permissions-create.sql:389: ERROR: relation "acs_object_party_privilege_map" already exists psql:acs-permissions-create.sql:392: ERROR: relation "all_object_party_privilege_map" already exists psql:acs-permissions-create.sql:408: ERROR: relation "acs_permissions_lock" already exists psql:acs-permissions-create.sql:414: ERROR: function "acs_permissions_lock_tr" already exists with same argument types psql:acs-permissions-create.sql:418: ERROR: trigger "acs_permissions_lock_tr" for relation "acs_permissions_lock" already exists psql:acs-permissions-create.sql:451: ERROR: function "acs_permission__grant_permission" already exists with same argument types psql:acs-permissions-create.sql:470: ERROR: function "acs_permission__revoke_permission" already exists with same argument types psql:groups-body-create.sql:86: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger" psql:groups-body-create.sql:110: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:groups-body-create.sql:113: ERROR: trigger "membership_rels_up_tr" for relation "membership_rels" already exists psql:groups-body-create.sql:138: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:groups-body-create.sql:141: ERROR: trigger "membership_rels_del_tr" for relation "membership_rels" already exists psql:groups-body-create.sql:250: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger" psql:groups-body-create.sql:347: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:groups-body-create.sql:350: ERROR: trigger "composition_rels_del_tr" for relation "composition_rels" already exists psql:rel-segments-body-create.sql:45: ERROR: function "rel_segment__new" already exists with same argument types psql:rel-segments-body-create.sql:61: ERROR: function "rel_segment__new" already exists with same argument types psql:rel-segments-body-create.sql:85: ERROR: function "rel_segment__delete" already exists with same argument types psql:rel-segments-body-create.sql:103: ERROR: function "rel_segment__get" already exists with same argument types psql:rel-segments-body-create.sql:111: ERROR: function "rel_segment__get_or_new" already exists with same argument types psql:rel-segments-body-create.sql:159: ERROR: function "rel_segment__get_or_new" already exists with same argument types psql:rel-segments-body-create.sql:176: ERROR: function "rel_segment__name" already exists with same argument types psql:rel-constraints-body-create.sql:36: ERROR: function "rel_constraint__new" already exists with same argument types psql:rel-constraints-body-create.sql:71: ERROR: function "rel_constraint__new" already exists with same argument types psql:rel-constraints-body-create.sql:83: ERROR: function "rel_constraint__delete" already exists with same argument types psql:rel-constraints-body-create.sql:103: ERROR: function "rel_constraint__get_constraint_id" already exists with same argument types psql:rel-constraints-body-create.sql:151: ERROR: function "rel_constraint__violation" already exists with same argument types psql:rel-constraints-body-create.sql:191: ERROR: function "rel_constraint__violation_if_removed" already exists with same argument types psql:security-create.sql:30: ERROR: relation "sec_session_properties" already exists psql:security-create.sql:32: ERROR: relation "sec_property_names" already exists psql:security-create.sql:39: ERROR: relation "secret_tokens" already exists psql:security-create.sql:41: ERROR: relation "t_sec_security_token_id_seq" already exists psql:security-create.sql:43: ERROR: relation "sec_security_token_id_seq" already exists psql:security-create.sql:49: ERROR: relation "t_sec_id_seq" already exists psql:security-create.sql:51: ERROR: relation "sec_id_seq" already exists psql:journal-create.sql:35: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 2 at perform psql:journal-create.sql:53: ERROR: relation "journal_entries" already exists psql:journal-create.sql:55: ERROR: relation "journal_entries_object_idx" already exists psql:journal-create.sql:122: ERROR: function "journal_entry__new" already exists with same argument types psql:journal-create.sql:135: ERROR: function "journal_entry__delete" already exists with same argument types psql:journal-create.sql:153: ERROR: function "journal_entry__delete_for_object" already exists with same argument types psql:site-nodes-create.sql:30: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 4 at perform psql:site-nodes-create.sql:59: ERROR: relation "site_nodes" already exists psql:site-nodes-create.sql:61: ERROR: relation "site_nodes_object_id_idx" already exists psql:site-nodes-create.sql:62: ERROR: relation "site_nodes_parent_id_idx" already exists psql:site-nodes-create.sql:63: ERROR: relation "site_nodes_tree_skey_idx" already exists psql:site-nodes-create.sql:70: ERROR: function "site_node_get_tree_sortkey" already exists with same argument types psql:site-nodes-create.sql:95: ERROR: function "site_node_insert_tr" already exists with same argument types psql:site-nodes-create.sql:99: ERROR: trigger "site_node_insert_tr" for relation "site_nodes" already exists psql:site-nodes-create.sql:154: ERROR: function "site_node_update_tr" already exists with same argument types psql:site-nodes-create.sql:159: ERROR: trigger "site_node_update_tr" for relation "site_nodes" already exists psql:site-nodes-create.sql:249: ERROR: function "site_node__new" already exists with same argument types psql:site-nodes-create.sql:264: ERROR: function "site_node__delete" already exists with same argument types psql:site-nodes-create.sql:290: ERROR: function "site_node__find_pattern" already exists with same argument types psql:site-nodes-create.sql:351: ERROR: function "site_node__node_id" already exists with same argument types psql:site-nodes-create.sql:378: ERROR: function "site_node__url" already exists with same argument types psql:site-node-object-map-create.sql:21: ERROR: relation "site_node_object_mappings" already exists psql:site-node-object-map-create.sql:41: ERROR: function "site_node_object_map__new" already exists with same argument types psql:site-node-object-map-create.sql:56: ERROR: function "site_node_object_map__del" already exists with same argument types psql:apm-create.sql:37: ERROR: relation "apm_package_types" already exists psql:apm-create.sql:97: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 3 at perform psql:apm-create.sql:209: ERROR: duplicate key violates unique constraint "acs_attributes_attr_name_un" CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 30 at SQL statement PL/pgSQL function "inline_1" line 5 at assignment psql:apm-create.sql:225: ERROR: relation "apm_packages" already exists psql:apm-create.sql:227: ERROR: relation "apm_packages_package_key_idx" already exists psql:apm-create.sql:245: ERROR: column "enabled_p" of relation "apm_packages" does not exist psql:apm-create.sql:298: ERROR: relation "apm_package_versions" already exists psql:apm-create.sql:651: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_2" line 4 at assignment psql:apm-create.sql:666: ERROR: relation "apm_package_owners" already exists psql:apm-create.sql:668: ERROR: relation "apm_pkg_owners_version_idx" already exists psql:apm-create.sql:684: ERROR: relation "apm_package_callbacks" already exists psql:apm-create.sql:714: ERROR: relation "apm_package_version_info" already exists psql:apm-create.sql:720: ERROR: relation "apm_enabled_package_versions" already exists psql:apm-create.sql:727: ERROR: relation "apm_package_file_types" already exists psql:apm-create.sql:757: ERROR: duplicate key violates unique constraint "apm_package_file_types_pk" CONTEXT: PL/pgSQL function "inline_3" line 2 at SQL statement psql:apm-create.sql:766: ERROR: relation "apm_package_db_types" already exists psql:apm-create.sql:792: ERROR: relation "apm_package_files" already exists psql:apm-create.sql:794: ERROR: relation "apm_pkg_files_file_type_idx" already exists psql:apm-create.sql:795: ERROR: relation "apm_pkg_files_db_type_idx" already exists psql:apm-create.sql:822: ERROR: relation "apm_file_info" already exists psql:apm-create.sql:851: ERROR: relation "apm_parameters" already exists psql:apm-create.sql:853: ERROR: relation "apm_parameters_package_idx" already exists psql:apm-create.sql:905: ERROR: relation "apm_parameter_values" already exists psql:apm-create.sql:907: ERROR: relation "apm_par_vals_parameter_idx" already exists psql:apm-create.sql:1036: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_4" line 4 at assignment psql:apm-create.sql:1113: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_5" line 4 at assignment psql:apm-create.sql:1133: ERROR: relation "apm_package_dependencies" already exists psql:apm-create.sql:1149: ERROR: relation "apm_applications" already exists psql:apm-create.sql:1161: ERROR: relation "apm_services" already exists psql:apm-create.sql:1190: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_6" line 5 at assignment psql:apm-create.sql:1220: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_7" line 5 at assignment psql:apm-create.sql:1250: ERROR: function "apm__register_package" already exists with same argument types psql:apm-create.sql:1280: ERROR: function "apm__update_package" already exists with same argument types psql:apm-create.sql:1296: ERROR: function "apm__unregister_package" already exists with same argument types psql:apm-create.sql:1312: ERROR: function "apm__register_p" already exists with same argument types psql:apm-create.sql:1341: ERROR: function "apm__register_application" already exists with same argument types psql:apm-create.sql:1357: ERROR: function "apm__unregister_application" already exists with same argument types psql:apm-create.sql:1386: ERROR: function "apm__register_service" already exists with same argument types psql:apm-create.sql:1402: ERROR: function "apm__unregister_service" already exists with same argument types psql:apm-create.sql:1459: ERROR: function "apm__register_parameter" already exists with same argument types psql:apm-create.sql:1487: ERROR: function "apm__update_parameter" already exists with same argument types psql:apm-create.sql:1505: ERROR: function "apm__parameter_p" already exists with same argument types psql:apm-create.sql:1521: ERROR: function "apm__unregister_parameter" already exists with same argument types psql:apm-create.sql:1539: ERROR: function "apm__id_for_name" already exists with same argument types psql:apm-create.sql:1556: ERROR: function "apm__get_value" already exists with same argument types psql:apm-create.sql:1577: ERROR: function "apm__get_value" already exists with same argument types psql:apm-create.sql:1608: ERROR: function "apm__set_value" already exists with same argument types psql:apm-create.sql:1638: ERROR: function "apm__set_value" already exists with same argument types psql:apm-create.sql:1668: ERROR: function "apm_package__initialize_parameters" already exists with same argument types psql:apm-create.sql:1746: ERROR: function "apm_package__new" already exists with same argument types psql:apm-create.sql:1773: ERROR: function "apm_package__delete" already exists with same argument types psql:apm-create.sql:1790: ERROR: function "apm_package__initial_install_p" already exists with same argument types psql:apm-create.sql:1807: ERROR: function "apm_package__singleton_p" already exists with same argument types psql:apm-create.sql:1825: ERROR: function "apm_package__num_instances" already exists with same argument types psql:apm-create.sql:1838: ERROR: function "apm_package__name" already exists with same argument types psql:apm-create.sql:1849: ERROR: function "apm_package__enable" already exists with same argument types psql:apm-create.sql:1860: ERROR: function "apm_package__disable" already exists with same argument types psql:apm-create.sql:1878: ERROR: function "apm_package__highest_version" already exists with same argument types psql:apm-create.sql:1897: ERROR: function "apm_package__parent_id" already exists with same argument types psql:apm-create.sql:1946: ERROR: function "apm_package_version__new" already exists with same argument types psql:apm-create.sql:1970: ERROR: function "apm_package_version__delete" already exists with same argument types psql:apm-create.sql:1983: ERROR: function "apm_package_version__enable" already exists with same argument types psql:apm-create.sql:1997: ERROR: function "apm_package_version__disable" already exists with same argument types psql:apm-create.sql:2053: ERROR: function "apm_package_version__copy" already exists with same argument types psql:apm-create.sql:2108: ERROR: function "apm_package_version__edit" already exists with same argument types psql:apm-create.sql:2143: ERROR: function "apm_package_version__add_file" already exists with same argument types psql:apm-create.sql:2158: ERROR: function "apm_package_version__remove_file" already exists with same argument types psql:apm-create.sql:2185: ERROR: function "apm_package_version__add_interface" already exists with same argument types psql:apm-create.sql:2198: ERROR: function "apm_package_version__remove_interface" already exists with same argument types psql:apm-create.sql:2216: ERROR: function "apm_package_version__remove_interface" already exists with same argument types psql:apm-create.sql:2243: ERROR: function "apm_package_version__add_dependency" already exists with same argument types psql:apm-create.sql:2256: ERROR: function "apm_package_version__remove_dependency" already exists with same argument types psql:apm-create.sql:2274: ERROR: function "apm_package_version__remove_dependency" already exists with same argument types psql:apm-create.sql:2350: ERROR: function "apm_package_version__sortable_version_name" already exists with same argument types psql:apm-create.sql:2370: ERROR: function "apm_package_version__version_name_greater" already exists with same argument types psql:apm-create.sql:2417: ERROR: function "apm_package_version__upgrade_p" already exists with same argument types psql:apm-create.sql:2437: ERROR: function "apm_package_version__upgrade" already exists with same argument types psql:apm-create.sql:2467: ERROR: function "apm_package_type__create_type" already exists with same argument types psql:apm-create.sql:2497: ERROR: function "apm_package_type__update_type" already exists with same argument types psql:apm-create.sql:2535: ERROR: function "apm_package_type__drop_type" already exists with same argument types psql:apm-create.sql:2551: ERROR: function "apm_package_type__num_parameters" already exists with same argument types psql:apm-create.sql:2585: ERROR: function "apm_parameter_value__new" already exists with same argument types psql:apm-create.sql:2599: ERROR: function "apm_parameter_value__delete" already exists with same argument types psql:apm-create.sql:2629: ERROR: function "apm_application__new" already exists with same argument types psql:apm-create.sql:2645: ERROR: function "apm_application__delete" already exists with same argument types psql:apm-create.sql:2679: ERROR: function "apm_service__new" already exists with same argument types psql:apm-create.sql:2695: ERROR: function "apm_service__delete" already exists with same argument types psql:acs-create.sql:14: ERROR: relation "acs_magic_objects" already exists psql:acs-create.sql:16: ERROR: relation "acs_mo_object_id_idx" already exists psql:acs-create.sql:74: ERROR: function "acs__add_user" already exists with same argument types psql:acs-create.sql:85: ERROR: function "acs__remove_user" already exists with same argument types psql:acs-create.sql:100: ERROR: function "acs__magic_object_id" already exists with same argument types psql:acs-create.sql:117: ERROR: relation "registered_users" already exists psql:acs-create.sql:130: ERROR: relation "cc_users" already exists psql:acs-create.sql:165: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "acs_object__new" line 24 at SQL statement PL/pgSQL function "inline_0" line 5 at assignment psql:acs-create.sql:178: ERROR: duplicate key violates unique constraint "acs_privileges_pk" CONTEXT: PL/pgSQL function "acs_privilege__create_privilege" line 6 at SQL statement psql:acs-create.sql:179: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:180: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:181: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:182: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:188: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:189: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:190: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:191: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:261: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "inline_2" line 8 at SQL statement psql:acs-create.sql:306: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "acs_object__new" line 24 at SQL statement PL/pgSQL function "party__new" line 12 at assignment PL/pgSQL function "acs_group__new" line 16 at assignment PL/pgSQL function "inline_3" line 8 at assignment psql:acs-create.sql:317: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "acs_object__new" line 24 at SQL statement psql:acs-create.sql:322: ERROR: duplicate key violates unique constraint "acs_magic_objects_pk" psql:acs-create-2.sql:16: ERROR: duplicate key violates unique constraint "acs_privileges_pk" CONTEXT: PL/pgSQL function "acs_privilege__create_privilege" line 6 at SQL statement PL/pgSQL function "acs_privilege__create_privilege" line 4 at return psql:acs-create-2.sql:17: ERROR: duplicate key violates unique constraint "acs_privilege_hierarchy_pk" CONTEXT: PL/pgSQL function "acs_privilege__add_child" line 5 at SQL statement

NOTE: 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.

Installing Search 4.6

# Installing data model for Search 4.6...

    * Loading data model /web/dotlrn/packages/search/sql/postgresql/search-create.sql...

acs_sc_operation__new
-----------------------
                  766
(1 row)
acs_sc_operation__new
-----------------------
                  769
(1 row)
acs_sc_operation__new
-----------------------
                  772
(1 row)
acs_sc_operation__new
-----------------------
                  775
(1 row)
acs_sc_operation__new
-----------------------
                  778
(1 row)
acs_sc_operation__new
-----------------------
                  781
(1 row)
acs_sc_operation__new
-----------------------
                  785
(1 row)
acs_sc_operation__new
-----------------------
                  788
(1 row)

          Failed to install Search, version 4.6. The following error was generated:

              psql:search-tables-create.sql:7: ERROR: relation "search_observer_queue" already exists psql:search-packages-create.sql:21: ERROR: function "search_observer__enqueue" already exists with same argument types psql:search-packages-create.sql:39: ERROR: function "search_observer__dequeue" already exists with same argument types CONTEXT: PL/pgSQL function "acs_object__new" line 12 at select into variables PL/pgSQL function "acs_sc_contract__new" line 7 at assignment psql:search-sc-create.sql:8: ERROR: duplicate key violates unique constraint "acs_sc_contracts_name_un" CONTEXT: PL/pgSQL function "acs_sc_contract__new" line 16 at SQL statement psql:search-sc-create.sql:14: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:18: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:34: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:38: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:54: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:58: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:74: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:78: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:94: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:98: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:113: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:117: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:136: ERROR: duplicate key violates unique constraint "acs_sc_contracts_name_un" CONTEXT: PL/pgSQL function "acs_sc_contract__new" line 16 at SQL statement psql:search-sc-create.sql:141: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:145: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:161: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:165: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement



          NOTE: 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.



        *  Completing Install sequence by mounting the main site and other core packages.

CREATE FUNCTION
DROP FUNCTION

Collapse
Posted by Jade Rubick on
I hope you're doing this on a test server, right?

Upgrading is a lot of work, and it will probably take a number of tries. It's not as hard now, but the 4.6.3 - 5 upgrade is a lot of work.

I'd start over again, and let us know exactly what step you're at when you run into problems.

Collapse
Posted by yi jongwook on
Request Error
Server startup failed: Error during bootstrapping
No fullquery for dbqd.acs-tcl.tcl.apm-procs.apm_package_installed_p_not_cached.apm_package_installed_p and default SQL empty - query for statement missing
    while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
    (procedure "db_qd_replace_sql" line 10)
    invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
    (procedure "db_exec" line 12)
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
        set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 8)
    invoked from within
"db_string apm_package_installed_p {} -default 0"
    (procedure "apm_package_installed_p_not_cached" line 2)
    invoked from within
"apm_package_installed_p_not_cached $package_key"
    (procedure "apm_package_installed_p" line 5)
    invoked from within
"apm_package_installed_p acs-kernel"
    (procedure "ad_verify_install" line 6)
    invoked from within
"ad_verify_install"

...i tried install nsxml 1.5 but syntax error