[Info-ingres] Table specified no longer exists

[Martin Bowes]

If you haven't raised it, I will.

Marty

From: Adrian Williamson <adrian.williamson at rationalcommerce.com>
Sent: 15 February 2022 09:45
To: Martin Bowes <martin.bowes at ndph.ox.ac.uk>; info-ingres at lists.planetingres.org
Subject: RE: [Info-ingres] Table specified no longer exists

Hi,

I have no notes on raising a call, it may have slipped through the cracks I will need to speak with Roy.

I just tried it on :

II 11.2.0 (a64.lnx/100)
15698

And

II 11.2.0 (a64.win/100)

It fails in both, so I would suggest that a fix has not appeared.

Cheers

Adrian



From: info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org> <info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org>> On Behalf Of Martin Bowes
Sent: 15 February 2022 09:32
To: Adrian Williamson <adrian.williamson at rationalcommerce.com<mailto:adrian.williamson at rationalcommerce.com>>; info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: Re: [Info-ingres] Table specified no longer exists

Hi Adrian,

That test case definitely reproduces the problem. Did you get a bug number from Actian and has it been fixed?

Marty

From: Adrian Williamson <adrian.williamson at rationalcommerce.com<mailto:adrian.williamson at rationalcommerce.com>>
Sent: 15 February 2022 09:26
To: Martin Bowes <martin.bowes at ndph.ox.ac.uk<mailto:martin.bowes at ndph.ox.ac.uk>>; info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: RE: [Info-ingres] Table specified no longer exists

Roy created this test case for it:


drop table if exists foo_tbl;

drop table if exists bar_tbl;

drop view if exists nice_view;

\p\g



create table foo_tbl

(

    keycol char(9) not null,

    good_stuff i1 not null default 0

)

\p\g



create table bar_tbl

(

    keycol char(9) not null,

    other_stuff smallint not null default 0

)

\p\g



commit

\p\g



create view nice_view as

select f.keycol

from foo_tbl f left join (select * from bar_tbl b ) x using (keycol) \p\g



commit;

\p\g



alter table foo_tbl drop column good_stuff cascade; \p\g



drop view nice_view;

\p\g



alter table foo_tbl drop column good_stuff cascade; \p\g


From: info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org> <info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org>> On Behalf Of Adrian Williamson
Sent: 15 February 2022 09:19
To: 'Martin Bowes' <martin.bowes at ndph.ox.ac.uk<mailto:martin.bowes at ndph.ox.ac.uk>>; info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: Re: [Info-ingres] Table specified no longer exists

Hi Marty,

We spotted something about this in 2020 - Karl thinks he knows - it is a view thing.

See attached.

Cheers

Adrian

From: info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org> <info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org>> On Behalf Of Martin Bowes
Sent: 15 February 2022 09:17
To: Martin Bowes <martin.bowes at ndph.ox.ac.uk<mailto:martin.bowes at ndph.ox.ac.uk>>; info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: Re: [Info-ingres] Table specified no longer exists

And an addendum...

I can glean nothing else from server tracing, II_EMBED_SET=printqry, verifydb.

Nothing is being written into the errlog.

Marty

From: Martin Bowes <martin.bowes at ndph.ox.ac.uk<mailto:martin.bowes at ndph.ox.ac.uk>>
Sent: 15 February 2022 08:52
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: [Info-ingres] Table specified no longer exists

Hi All,

Ingres 11.1.0 +p15692

I have a table with an integer1 column I wish to drop. The column is not part of the table key, not any index on the table, it has no comments, it is not involved in any constraints, rules, procedures, views etc. The table does have a long object, but this column isn't it.

alter table field drop column cost_ba cascade;
Executing . . .

E_US16D5 Table specified no longer exists.

That was surprising.

I've copied this table to a dummy database and repeated the drop command there but this time with success, so I'm ruling out the possibility of interference from the long object at this point.

As this is a production database I don't want to monkey with it much more so I'm currently recovering it to a backup host so I can play with it in isolation. That will take some time. In the mean time does anyone have a suggestion about what may be causing the problem?

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20220215/0ce7675b/attachment-0001.html>