Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1SEkUx36101 for ; Wed, 28 Feb 2001 09:46:30 -0500 (EST) (envelope-from pgsql-general-owner@postgresql.org) Received: from actarg.com (host25.actarg.com [209.180.91.25] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1RGlCx75693; Tue, 27 Feb 2001 11:47:12 -0500 (EST) (envelope-from kyle@actarg.com) Received: from chi.actarg.com (IDENT:root@chi.actarg.com [192.168.2.16]) by actarg.com (8.9.3/8.9.3) with ESMTP id JAA03035; Tue, 27 Feb 2001 09:47:07 -0700 Received: from actarg.com (IDENT:kyle@localhost [127.0.0.1]) by chi.actarg.com (8.9.3/8.9.3) with ESMTP id JAA11509; Tue, 27 Feb 2001 09:47:17 -0700 Message-ID: <3A9BDA14.FFBE20A4@actarg.com> Date: Tue, 27 Feb 2001 09:47:17 -0700 From: Kyle Organization: Action Target Inc. X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Debug messages in beta5 Content-Type: multipart/mixed; boundary="------------390377D3BCFCF28FC3E78C1B" X-Archive-Number: 200102/1438 X-Sequence-Number: 5399 This is a multi-part message in MIME format. --------------390377D3BCFCF28FC3E78C1B Content-Type: multipart/alternative; boundary="------------92F4332889ABA6DABE7FFC4B" --------------92F4332889ABA6DABE7FFC4B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Maybe this will help in evaluating beta5. Here is some debug output from serverlog while the system was doing a restore to 7.1b5 from a pg_dump file created on a 7.0.3 box: DEBUG: MoveOfflineLogs: remove 000000000000003D DEBUG: MoveOfflineLogs: remove 000000000000003E DEBUG: MoveOfflineLogs: remove 000000000000003F DEBUG: MoveOfflineLogs: remove 0000000000000040 DEBUG: MoveOfflineLogs: remove 0000000000000041 DEBUG: MoveOfflineLogs: remove 0000000000000036 DEBUG: MoveOfflineLogs: remove 0000000000000037 DEBUG: MoveOfflineLogs: remove 0000000000000038 DEBUG: MoveOfflineLogs: remove 0000000000000039 DEBUG: MoveOfflineLogs: remove 000000000000003A DEBUG: MoveOfflineLogs: remove 000000000000003B DEBUG: MoveOfflineLogs: remove 000000000000003C DEBUG: copy: line 25300, XLogWrite: new log file created - try to increase WAL_FILES DEBUG: copy: line 57362, XLogWrite: new log file created - try to increase WAL_FILES DEBUG: copy: line 27109, XLogWrite: new log file created - try to increase WAL_FILES DEBUG: copy: line 2978, XLogWrite: new log file created - try to increase WAL_FILES DEBUG: MoveOfflineLogs: remove 0000000000000044 DEBUG: MoveOfflineLogs: remove 0000000000000045 DEBUG: MoveOfflineLogs: remove 0000000000000046 DEBUG: MoveOfflineLogs: remove 0000000000000042 DEBUG: MoveOfflineLogs: remove 0000000000000043 I'm not sure where/how to change WAL_FILES. Is that a compiled in default or a configuration setting? Is the MoveOfflineLogs anything to worry about? These were interesting too: I'm not sure what to make of them: NOTICE: Adding missing FROM-clause entry for table "cont_group_link" ERROR: Rule WHERE condition may not contain references to other relations NOTICE: Adding missing FROM-clause entry for table "cont_group_link" Here's what the original schema definition for cont_group_link looks like: create table cont_group_link ( ------------------------------------- -- Primary Keys: org_id, cont_id, group_owner, group_name -- Foreign Keys: org_id, cont_id into cont_cont org_id int, cont_id int, crt_by int4, group_name varchar, unique (org_id, cont_id, crt_by, group_name), foreign key (org_id) references cont_org on update cascade on delete cascade, foreign key (org_id, cont_id) references cont_cont on update cascade on delete cascade, foreign key (crt_by, group_name) references cont_group on update cascade on delete cascade ); And here's a view definition that the messages are probably related to: drop view cont_group_v; drop view cont_group_link_v; --CV: create view cont_group_v as select *, oid as _oid from cont_group where not (access = 'none' and crt_by != getpguid()); create rule cont_group_v_insert as on insert to cont_group_v do instead insert into cont_group (crt_by, group_name, group_type, descr, access) values (getpguid(), new.group_name, new.group_type, new.descr, new.access); create rule cont_group_v_delete as on delete to cont_group_v do instead delete from cont_group where crt_by = old.crt_by and group_name = old.group_name; create rule cont_group_v_update as on update to cont_group_v do instead update cont_group set group_name = new.group_name, group_type = new.group_type, descr = new.descr, access = new.access where crt_by = old.crt_by and group_name = old.group_name; create view cont_group_link_v as select *, oid as _oid from cont_group_link where cont_group_priv(crt_by,group_name,'r'); create rule cont_group_link_v_innull as on insert to cont_group_link_v do instead nothing; create rule cont_group_link_v_insert as on insert to cont_group_link_v where cont_group_priv(crt_by,group_name,'w') do instead insert into cont_group_link (org_id, cont_id, crt_by, group_name) values (new.org_id, new.cont_id, getpguid(), new.group_name); create rule cont_group_v_link_denull as on delete to cont_group_link_v do instead nothing; create rule cont_group_v_link_delete as on delete to cont_group_link_v where cont_group_priv(crt_by,group_name,'w') do instead delete from cont_group_link where org_id = old.org_id and cont_id = old.cont_id and crt_by = old.crt_by and group_name = old.group_name; This seems to lack sufficient context to find exactly where they came from: ERROR: Rule WHERE condition may not contain references to other relations ERROR: select rule's target entry 27 has different type from attribute lquant However, based on the field name, I can tell the last one is coming from this view: create view mtr_reg_v_unpackaged as select m.*, (select coalesce(sum(l.quant),0) from pak_lnk l where m.ttype = l.ttype and m.ropnum = l.ropnum and m.inum = l.inum and m.minum = l.minum and m.bminum = l.bminum) as lquant, (select p.base||'('||p.parm||')' from prd_part_v_base p where p.pnum = m.pnum) as pname, (select p.descr from prd_part_v_base p where p.pnum = m.pnum) as descr from mtr_reg_v_or m, ord_hdr o where m.status = 'open' and m.ropnum = o.ordnum and o.type = 'ord' and m.rquant > (select coalesce(sum(l.quant),0) from pak_lnk l where m.ttype = l.ttype and m.ropnum = l.ropnum and m.inum = l.inum and m.minum = l.minum and m.bminum = l.bminum); --------------92F4332889ABA6DABE7FFC4B Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Maybe this will help in evaluating beta5.  Here is some debug output from serverlog while the system was doing a restore to 7.1b5 from a pg_dump file created on a 7.0.3 box:

DEBUG:  MoveOfflineLogs: remove 000000000000003D
DEBUG:  MoveOfflineLogs: remove 000000000000003E
DEBUG:  MoveOfflineLogs: remove 000000000000003F
DEBUG:  MoveOfflineLogs: remove 0000000000000040
DEBUG:  MoveOfflineLogs: remove 0000000000000041
DEBUG:  MoveOfflineLogs: remove 0000000000000036
DEBUG:  MoveOfflineLogs: remove 0000000000000037
DEBUG:  MoveOfflineLogs: remove 0000000000000038
DEBUG:  MoveOfflineLogs: remove 0000000000000039
DEBUG:  MoveOfflineLogs: remove 000000000000003A
DEBUG:  MoveOfflineLogs: remove 000000000000003B
DEBUG:  MoveOfflineLogs: remove 000000000000003C
DEBUG:  copy: line 25300, XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  copy: line 57362, XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  copy: line 27109, XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  copy: line 2978, XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  MoveOfflineLogs: remove 0000000000000044
DEBUG:  MoveOfflineLogs: remove 0000000000000045
DEBUG:  MoveOfflineLogs: remove 0000000000000046
DEBUG:  MoveOfflineLogs: remove 0000000000000042
DEBUG:  MoveOfflineLogs: remove 0000000000000043

I'm not sure where/how to change WAL_FILES.  Is that a compiled in default or a configuration setting?  Is the MoveOfflineLogs anything to worry about?

These were interesting too:  I'm not sure what to make of them:

NOTICE:  Adding missing FROM-clause entry for table "cont_group_link"
ERROR:  Rule WHERE condition may not contain references to other relations
NOTICE:  Adding missing FROM-clause entry for table "cont_group_link"

Here's what the original schema definition for cont_group_link looks like:

create table cont_group_link (
-------------------------------------
-- Primary Keys:        org_id, cont_id, group_owner, group_name
-- Foreign Keys:        org_id, cont_id into cont_cont

   org_id int,
   cont_id int,
   crt_by int4,
   group_name varchar,
   unique (org_id, cont_id, crt_by, group_name),

   foreign key (org_id)
        references cont_org
        on update cascade
        on delete cascade,

   foreign key (org_id, cont_id)
        references cont_cont
        on update cascade
        on delete cascade,
 
   foreign key (crt_by, group_name)
        references cont_group
        on update cascade
        on delete cascade
);

And here's a view definition that the messages are probably related to:

drop view cont_group_v;
drop view cont_group_link_v;
--CV:
create view cont_group_v as select *, oid as _oid from cont_group where not (access = 'none' and crt_by != getpguid());

create rule cont_group_v_insert as on insert to cont_group_v
    do instead
    insert into cont_group
   (crt_by, group_name, group_type, descr, access)
    values
       (getpguid(), new.group_name, new.group_type, new.descr, new.access);

create rule cont_group_v_delete as on delete to cont_group_v
    do instead
    delete from cont_group
    where crt_by = old.crt_by
    and group_name = old.group_name;

create rule cont_group_v_update as on update to cont_group_v
    do instead
        update cont_group
        set group_name = new.group_name, group_type = new.group_type, descr = new.descr, access = new.access
        where crt_by = old.crt_by
        and group_name = old.group_name;

create view cont_group_link_v as select *, oid as _oid from cont_group_link where cont_group_priv(crt_by,group_name,'r');

create rule cont_group_link_v_innull as on insert to cont_group_link_v do instead nothing;
create rule cont_group_link_v_insert as on insert to cont_group_link_v where cont_group_priv(crt_by,group_name,'w')
    do instead
    insert into cont_group_link
    (org_id, cont_id, crt_by, group_name)
    values (new.org_id, new.cont_id, getpguid(), new.group_name);

create rule cont_group_v_link_denull as on delete to cont_group_link_v do instead nothing;
create rule cont_group_v_link_delete as on delete to cont_group_link_v where cont_group_priv(crt_by,group_name,'w')
    do instead
    delete from cont_group_link
        where org_id = old.org_id
        and cont_id = old.cont_id
        and crt_by = old.crt_by
        and group_name = old.group_name;
 
 

This seems to lack sufficient context to find exactly where they came from:
ERROR:  Rule WHERE condition may not contain references to other relations

ERROR:  select rule's target entry 27 has different type from attribute lquant

However, based on the field name, I can tell the last one is coming from this view:

create view mtr_reg_v_unpackaged as
   select m.*, (select coalesce(sum(l.quant),0)
                from pak_lnk l
                where m.ttype = l.ttype
                and m.ropnum = l.ropnum
                and m.inum = l.inum
                and m.minum = l.minum
                and m.bminum = l.bminum) as lquant,
          (select p.base||'('||p.parm||')' from prd_part_v_base p where p.pnum = m.pnum) as pname,
          (select p.descr from prd_part_v_base p where p.pnum = m.pnum) as descr
   from mtr_reg_v_or m, ord_hdr o
   where m.status = 'open'
   and m.ropnum = o.ordnum
   and o.type = 'ord'
   and m.rquant >
   (select coalesce(sum(l.quant),0) from pak_lnk l
      where m.ttype = l.ttype
      and m.ropnum = l.ropnum
      and m.inum = l.inum
      and m.minum = l.minum
      and m.bminum = l.bminum);
  --------------92F4332889ABA6DABE7FFC4B-- --------------390377D3BCFCF28FC3E78C1B Content-Type: text/x-vcard; charset=us-ascii; name="kyle.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Kyle Content-Disposition: attachment; filename="kyle.vcf" begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:kyle@actarg.com title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard --------------390377D3BCFCF28FC3E78C1B--