Debug messages in beta5

From: Kyle <kyle(at)actarg(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Debug messages in beta5
Date: 2001-02-27 16:47:17
Message-ID: 3A9BDA14.FFBE20A4@actarg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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);

Attachment Content-Type Size
kyle.vcf text/x-vcard 185 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominic J. Eidson 2001-02-27 17:20:48 Re: Does PostGresSQL have this feature?
Previous Message martin.chantler 2001-02-27 16:44:52 Does PostGresSQL have this feature?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-02-27 17:22:35 Re: [SQL] Debug messages in beta5
Previous Message Blaise Carrupt 2001-02-27 16:43:25 Help creating rules/triggers/functions