We don't seem to gain much clarity in the KeepAlive matter and it obviously doesn't have anything to do with the installation problems I saw, and still see even though I've upgraded to AOLserver 4 (cvs HEAD) and reinstalled PostgreSQL 7.3.4 from the debian package on "unstable" ...
I am getting lots and lots of errors (from time to time) when I install a fresh copy of .LRN from the "dotlrn-2-0" and "oacs-5-0" branches.
Am I really the only one to get these errors?
(The extra backslashes is due to some poor cut and paste exercises ... sorry)
[03/Dec/2003:15:18:12][1202.16384][-main-] Notice: nsmain: AOLserver/4.1 starti\ng
...
[03/Dec/2003:15:18:54][1202.65541][-conn:oacsdev::1] Error: apm_package_install\: Error installing Reference Data version 5.0.0a5: psql:acs-reference-create.sq\l:16: WARNING: Error occurred while executing PL/pgSQL function acs_priv_hier_\ins_del_tr
psql:acs-reference-create.sql:16: WARNING: line 61 at SQL statement
psql:acs-reference-create.sql:16: ERROR: cache lookup failed for opclass 2003
psql:acs-reference-create.sql:16: WARNING: Error occurred while executing PL/p\gSQL function acs_priv_hier_ins_del_tr
psql:acs-reference-create.sql:16: WARNING: line 61 at SQL statement
psql:acs-reference-create.sql:16: ERROR: cache lookup failed for opclass 2003
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_mod\el_files $spec_file_path"
invoked from within
"if { $load_data_model_p } {
apm_package_install_data_model -callback $callback -data_model_file\s $data_model_files $spec_file_path
}"
("uplevel" body line 42)
invoked from within
"uplevel $body "
[03/Dec/2003:15:18:54][1202.65541][-conn:oacsdev::1] Error: Failed to instal\l Reference Data, version 5.0.0a5. The following error was generated:
psql:acs-reference-create.sql:16: WARNING: Error occurred while executing PL/p\gSQL function acs_priv_hier_ins_del_tr
psql:acs-reference-create.sql:16: WARNING: line 61 at SQL statement
psql:acs-reference-create.sql:16: ERROR: cache lookup failed for opclass 2003
...
[03/Dec/2003:15:19:02][1202.65541][-conn:oacsdev::1] Error: apm_package_install\: Error installing Content Repository version 5.0.0b4: psql:content-image.sql:4\7: WARNING: Error occurred while executing PL/pgSQL function content_type__ref\resh_view
psql:content-image.sql:47: WARNING: line 22 at for over select rows
psql:content-image.sql:47: ERROR: cache lookup failed for opclass 2002
psql:content-image.sql:58: ERROR: current transaction is aborted, queries igno\red until end of transaction block
psql:content-image.sql:68: ERROR: cr_content_mime_map_ctyp_fk referential inte\grity violation - key referenced from cr_content_mime_type_map not found in acs\_object_types
psql:content-image.sql:73: ERROR: current transaction is aborted, queries igno\red until end of transaction block
psql:content-create.sql:1365: ERROR: cr_type_template_map_typ_fk referential i\ntegrity violation - key referenced from cr_type_template_map not found in acs_\object_types
psql:content-image.sql:47: WARNING: Error occurred while executing PL/pgSQL fu\nction content_type__refresh_view
psql:content-image.sql:47: WARNING: line 22 at for over select rows
psql:content-image.sql:47: ERROR: cache lookup failed for opclass 2002
psql:content-image.sql:58: ERROR: current transaction is aborted, queries igno\red until end of transaction block
psql:content-image.sql:68: ERROR: cr_content_mime_map_ctyp_fk referential inte\grity violation - key referenced from cr_content_mime_type_map not found in acs\_object_types
psql:content-image.sql:73: ERROR: current transaction is aborted, queries igno\red until end of transaction block
psql:content-create.sql:1365: ERROR: cr_type_template_map_typ_fk referential i\ntegrity violation - key referenced from cr_type_template_map not found in acs_\object_types
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_mod\el_files $spec_file_path"
invoked from within
"if { $load_data_model_p } {
apm_package_install_data_model -callback $callback -data_model_file\s $data_model_files $spec_file_path
}"
("uplevel" body line 42)
invoked from within
"uplevel $body "
[03/Dec/2003:15:19:02][1202.65541][-conn:oacsdev::1] Error: Failed to instal\l Content Repository, version 5.0.0b4. The following error was generated:
psql:content-image.sql:47: WARNING: Error occurred while executing PL/pgSQL fu\nction content_type__refresh_view
psql:content-image.sql:47: WARNING: line 22 at for over select rows
psql:content-image.sql:47: ERROR: cache lookup failed for opclass 2002
psql:content-image.sql:58: ERROR: current transaction is aborted, queries igno\red until end of transaction block
psql:content-image.sql:68: ERROR: cr_content_mime_map_ctyp_fk referential inte\grity violation - key referenced from cr_content_mime_type_map not found in acs\_object_types
psql:content-image.sql:73: ERROR: current transaction is aborted, queries igno\red until end of transaction block
psql:content-create.sql:1365: ERROR: cr_type_template_map_typ_fk referential i\ntegrity violation - key referenced from cr_type_template_map not found in acs_\object_types
...
[03/Dec/2003:15:19:02][1202.65541][-conn:oacsdev::1] Error: apm_package_install\: Error installing Reference Data - Timezone version 5.0.0a5: psql:/tmp/psql-co\pyfile-PYr4ra:1: ERROR: GetTypeElement: Cache lookup of type 23 failed
psql:/tmp/psql-copyfile-PYr4ra:1: lost synchronization with server, resetting c\onnection
psql:/tmp/psql-copyfile-PYr4ra:1: ERROR: GetTypeElement: Cache lookup of type \23 failed
psql:/tmp/psql-copyfile-PYr4ra:1: lost synchronization with server, resetting c\onnection
invoked from within
"db_load_sql_data -callback $callback $path/$file_path"
(procedure "apm_package_install_data_model" line 52)
invoked from within
"apm_package_install_data_model -callback $callback -data_model_files $data_mod\el_files $spec_file_path"
invoked from within
"if { $load_data_model_p } {
apm_package_install_data_model -callback $callback -data_model_file\s $data_model_files $spec_file_path
}"
("uplevel" body line 42)
invoked from within
"uplevel $body "
[03/Dec/2003:15:19:02][1202.65541][-conn:oacsdev::1] Error: Failed to instal\l Reference Data - Timezone, version 5.0.0a5. The following error was generate\d:
psql:/tmp/psql-copyfile-PYr4ra:1: ERROR: GetTypeElement: Cache lookup of type \23 failed
psql:/tmp/psql-copyfile-PYr4ra:1: lost synchronization with server, resetting c\onnection
...
[03/Dec/2003:15:19:10][1202.65541][-conn:oacsdev::1] Error: Error sourcing /var\/lib/aolserver/oacsdev/packages/acs-bootstrap-installer/installer/install.tcl:
Selection did not return a value, and no default was provided
while executing
"db_string pretty_name_from_key {select pretty_name
from apm_enabled_pack\age_versions
..."
(procedure "apm_package_instance_new" line 4)
invoked from within
"apm_package_instance_new -package_id $package_id -package_key $package_key \-instance_name $package_name -context_id $context_id"
(procedure "site_node::instantiate_and_mount" line 37)
invoked from within
"site_node::instantiate_and_mount -package_key acs-content-repository"
(procedure "apm_mount_core_packages" line 19)
invoked from within
"apm_mount_core_packages"
(procedure "install_do_packages_install" line 48)
invoked from within
"install_do_packages_install"
(file "/var/lib/aolserver/oacsdev/packages/acs-bootstrap-installer/installe\r/install.tcl" line 52)
invoked from within
"source $__file "
EOF
/Ola