Hi All.

In a distributed database (Ingres10) we have noticed that a registered table is giving some weird errors when accessed.

select count(*) from c_rack_number\g
Executing . . .

E_RD000F The information block is out of date.

And in the errlog we see.
E_RD000F_INFO_OUT_OF_DATE The information block is out of date.
E_PS0904_BAD_RDF_GETDESC RDF error occurred when getting description for an object.
E_PS0007_INT_OTHER_FAC_ERR PSF detected an internal error when calling other facility.
E_SC0215_PSF_ERROR Error returned by PSF.

I've tried to remove and recreate the tables registration but the remove isalso disallowed with E_RD000F.

I suspect that the best thing is to simply drop and recreate the ddb. Anyone got a better idea?

Martin Bowes

On Mar 15, 2011, at 5:56 AM, Martin Bowes wrote:

Does stopping/starting the installation help?

You might also try "set trace point rd10" to try to drop the RDF cache, but
I suspect that won't work.

RD000F happens when the RDF information block has been explicitly
marked "invalid". Presumably the invalid info block is in the process of
being deleted, and other RDF requestors aren't supposed to see it.

Karl

Restarting the installation hasn't helped.

I dropped and recreated the ddb (easy to do, we have a simple script for this task) and now all is fine.

Marty

-----Original Message-----
From: Karl Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: 15 March 2011 11:11
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] E_RD000F ... and distributed databases


On Mar 15, 2011, at 5:56 AM, Martin Bowes wrote:

Does stopping/starting the installation help?

You might also try "set trace point rd10" to try to drop the RDF cache, but
I suspect that won't work.

RD000F happens when the RDF information block has been explicitly
marked "invalid". Presumably the invalid info block is in the process of
being deleted, and other RDF requestors aren't supposed to see it.

Karl



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