Forum OpenACS Development: Re: Install error on head

Collapse
5: Re: Install error on head (response to 1)
Posted by Ola Hansson on 01/11/03 12:34 AM
Here is a snippet with a higher postgresql.conf debug level on: 
" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."acs_objects" x WHERE "object_id" = $1 FOR UPDATE OF x
LOG:  query: insert into acs_object_context_index (object_id, ancestor_id, n_generations) values ( $1 ,  $2 , 0)
LOG:  query: SELECT   $1  is not null and  $2  = 't'
LOG:  query: insert into acs_object_context_index (object_id, ancestor_id, n_generations) select  $1  as object_id, ancestor_id, n_generations + 1 as n_generations from acs_object_context_index where object_id =  $2 
LOG:  query: SELECT 1 FROM ONLY "public"."apm_packages" x WHERE "package_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT   $1  != 0
LOG:  query: insert into acs_object_context_index (object_id, ancestor_id, n_generations) values ( $1 , 0, 1)
LOG:  query: SELECT 1 FROM ONLY "public"."acs_objects" x WHERE "object_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."apm_packages" x WHERE "package_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."apm_parameters" x WHERE "parameter_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."acs_objects" x WHERE "object_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."acs_objects" x WHERE "object_id" = $1 FOR UPDATE OF x

FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."acs_objects" x WHERE "object_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."parties" x WHERE "party_id" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."acs_privileges" x WHERE "privilege" = $1 FOR UPDATE OF x
LOG:  query: SELECT 1 FROM ONLY "public"."site_nodes" x WHERE "node_id" = $1 FOR UPDATE OF x
ERROR:  apm_packages_package_key_fk referential integrity violation - key referenced from apm_packages not found in apm_package_types
LOG:  statement: select inline_0 ();
DEBUG:  AbortCurrentTransaction
DEBUG:  StartTransactionCommand
LOG:  statement: select id from inline_data where name = 'api_doc_id';
LOG:  query: select id from inline_data where name = 'api_doc_id';
DEBUG:  ProcessQuery
LOG:  statement: select id from inline_data where name = 'api_doc_id';
DEBUG:  CommitTransactionCommand
LOG:  statement: select id from inline_data where name = 'api_doc_id';
DEBUG:  StartTransactionCommand
LOG:  statement: update acs_objects
     set security_inherit_p = 'f'
   where object_id = (select id from inline_data where name = 'api_doc_id');

   where object_id = (select id from inline_data where name = 'api_doc_id');
LOG:  query: update acs_objects
     set security_inherit_p = 'f'
   where object_id = (select id from inline_data where name = 'api_doc_id');
DEBUG:  ProcessQuery
LOG:  statement: update acs_objects
     set security_inherit_p = 'f'
   where object_id = (select id from inline_data where name = 'api_doc_id');
DEBUG:  CommitTransactionCommand
LOG:  statement: update acs_objects
     set security_inherit_p = 'f'
   where object_id = (select id from inline_data where name = 'api_doc_id');
DEBUG:  StartTransactionCommand
LOG:  statement: select inline_1 ();
LOG:  query: select inline_1 ();
DEBUG:  ProcessQuery
LOG:  statement: select inline_1 ();
LOG:  query: SELECT  id from inline_data where name = 'api_doc_id'
LOG:  query: SELECT  acs_permission__grant_permission (  $1 , acs__magic_object_id ('registered_users'), 'read' )
ERROR:  ExecInsert: Fail to add null value in not null attribute object_id
LOG:  statement: select inline_1 ();
WARNING:  Error occurred while executing PL/pgSQL function acs_permission__grant_permission
LOG:  statement: select inline_1 ();
WARNING:  line 17 at SQL statement
LOG:  statement: select inline_1 ();
DEBUG:  AbortCurrentTransaction
DEBUG:  StartTransactionCommand
LOG:  statement: drop function inline_0 ();
LOG:  query: drop function inline_0 ();
DEBUG:  ProcessUtility
LOG:  statement: drop function inline_0 ();
DEBUG:  CommitTransactionCommand
LOG:  statement: drop function inline_0 ();
DEBUG:  StartTransactionCommand
LOG:  statement: drop function inline_1 ();
LOG:  query: drop function inline_1 ();
DEBUG:  ProcessUtility
LOG:  statement: drop function inline_1 ();
DEBUG:  CommitTransactionCommand
LOG:  statement: drop function inline_1 ();
DEBUG:  StartTransactionCommand
LOG:  statement: drop table inline_data;
LOG:  query: drop table inline_data;
DEBUG:  ProcessUtility
LOG:  statement: drop table inline_data;
DEBUG:  Drop auto-cascades to toast table pg_toast.pg_toast_28537
LOG:  statement: drop table inline_data;
DEBUG:  Drop auto-cascades to type pg_toast.pg_toast_28537
LOG:  statement: drop table inline_data;
DEBUG:  Drop auto-cascades to index pg_toast.pg_toast_28537_index
LOG:  statement: drop table inline_data;
DEBUG:  Drop auto-cascades to type inline_data
LOG:  statement: drop table inline_data;
DEBUG:  CommitTransactionCommand
LOG:  statement: drop table inline_data;
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  child process (pid 29804) exited with exit code 0
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  child process (pid 29808) exited with exit code 0
If someone can see what is wrong that's good, otherwise I will try some more in the weekend.