Hi All,



I'm running II 9.2.0 (a64.lnx/143)NPTL +13411



Under what circumstances can my journals show:

20000 Insert/Append iietab_f4_f5,ingres

1811 Delete iietab_f4_f5,ingres



And no inserts/deletes to the table that owns the iietab?



The iietab_f4_f5 supports the 'a_long' column of the table resultz. The
table resultz is a journal enabled table.



That sorta just screwed the database recovery! Glad it was only a test!



Martin Bowes

The problem appears to be specific to partitioned tables.



Try this....

sql iidbdb << CREATE_TABLES

\r

drop table resultz;

\p\g

create table resultz(

cid integer not null not default,

trid integer not null not default,

my_date date not null not default,

a_long long varchar not null not default

) with nojournaling, page_size=8192;

\p\g

modify resultz to btree on cid, trid

with partition=(range on my_date

partition resultz_pp01 values < '1/1/2005' ,

partition resultz_pp02 values >= '1/1/2005'

);

\p\g

set journaling on resultz

\p\g

\q

CREATE_TABLES



ckpdb iidbdb



sql iidbdb << SQL_END

insert into resultz values(1,1, 'now', 'one');

\p\g

insert into resultz values(2,1, 'now', 'two');

\p\g

insert into resultz values(3,1, 'now', 'three');

\p\g

\q

SQL_END



Now rollforwarddb iidbdb and you'll see that all the records from
resultz have not been recovered.



Marty



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 July 2009 10:43
To: Ingres and related product discussion forum
Subject: [Info-Ingres] 9.2.0 and database recovery



Hi All,



I'm running II 9.2.0 (a64.lnx/143)NPTL +13411



Under what circumstances can my journals show:

20000 Insert/Append iietab_f4_f5,ingres

1811 Delete iietab_f4_f5,ingres



And no inserts/deletes to the table that owns the iietab?



The iietab_f4_f5 supports the 'a_long' column of the table resultz. The
table resultz is a journal enabled table.



That sorta just screwed the database recovery! Glad it was only a test!



Martin Bowes

And it occurs on 9.0.4 and 9.1.2 as well.



Marty



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 July 2009 11:14
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] 9.2.0 and database recovery



The problem appears to be specific to partitioned tables.



Try this....

sql iidbdb << CREATE_TABLES

\r

drop table resultz;

\p\g

create table resultz(

cid integer not null not default,

trid integer not null not default,

my_date date not null not default,

a_long long varchar not null not default

) with nojournaling, page_size=8192;

\p\g

modify resultz to btree on cid, trid

with partition=(range on my_date

partition resultz_pp01 values < '1/1/2005' ,

partition resultz_pp02 values >= '1/1/2005'

);

\p\g

set journaling on resultz

\p\g

\q

CREATE_TABLES



ckpdb iidbdb



sql iidbdb << SQL_END

insert into resultz values(1,1, 'now', 'one');

\p\g

insert into resultz values(2,1, 'now', 'two');

\p\g

insert into resultz values(3,1, 'now', 'three');

\p\g

\q

SQL_END



Now rollforwarddb iidbdb and you'll see that all the records from
resultz have not been recovered.



Marty



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 14 July 2009 10:43
To: Ingres and related product discussion forum
Subject: [Info-Ingres] 9.2.0 and database recovery



Hi All,



I'm running II 9.2.0 (a64.lnx/143)NPTL +13411



Under what circumstances can my journals show:

20000 Insert/Append iietab_f4_f5,ingres

1811 Delete iietab_f4_f5,ingres



And no inserts/deletes to the table that owns the iietab?



The iietab_f4_f5 supports the 'a_long' column of the table resultz. The
table resultz is a journal enabled table.



That sorta just screwed the database recovery! Glad it was only a test!



Martin Bowes

On Jul 14, 2009, at 6:14 AM, Martin Bowes wrote:

That's not good. I wonder if it's related to the goof-up
whereby etabs per partition are created, but then the master
etab is used.

I'll have to try your test case sometime today. I could believe
that base table log records are hiding from auditdb, but if
rollforwarddb can't find them either, they probably aren't there.

Karl

I'd have to agree with Karl on this. It sounds like a bug. Does it
happen on tables that do not have LOB (e-tab) columns?


--
stephenb

Hi Stephen,

Yes it happens on tables without longs as well.

It seems to be a partitioning problem and it affects 9.0.4, 9.1.x and
9.2.0.

We now have a bug number: 122317

Marty

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Ingres Forums
Sent: 15 July 2009 03:37
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] 9.2.0 and database recovery


I'd have to agree with Karl on this. It sounds like a bug. Does it
happen on tables that do not have LOB (e-tab) columns?


--
stephenb
------------------------------------------------------------------------
stephenb's Profile:
http://community.ingres.com/forum/member.php?userid=175
View this thread:
http://community.ingres.com/forum/sh...ad.php?t=10921

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres