Forum OpenACS Q&A: Re: Should Keepalive be enabled in config.tcl?

Collapse
8: Re: Should Keepalive be enabled in config.tcl? (response to 1)
Posted by Ola Hansson on 12/03/03 03:48 PM
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