From: Kyle <kyle@actarg.com>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Debug messages in beta5
Date: Tue, 27 Feb 2001 09:47:17 -0700
Message-ID: <3A9BDA14.FFBE20A4@actarg.com> (raw)
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);
Attachments:kyle.vcf (text/x-vcard, 184B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: kyle@actarg.com, pgsql-general@postgresql.org
Subject: Re: Debug messages in beta5
In-Reply-To: <3A9BDA14.FFBE20A4@actarg.com>
References: <3A9BDA14.FFBE20A4@actarg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox