[Info-ingres] E_DM9003?

[Laframboise, André (BAC/LAC)]

Hi Marty,

Been a while but seems to me*.m00 files are temporary table file during a modify statement.
They usually get renamed to the original file name at the end.

Isn't the only time Ingres would delete an *.m00 file is if the modify failed or was interrupted.
Can you associate this error with a modify transaction ?

André Laframboise

Conseiller Principal Base de Données, Direction générale de l'Innovation et du Dirigeant principal de l'information
Bibliothèque et Archives Canada<http://www.bac-lac.gc.ca/fra/Pages/bac-web.aspx> / Gouvernement du Canada
andre.laframboise at canada.ca<mailto:andre.laframboise at canada.ca> / Tél. : 613-298-1346

Senior Database Advisor, Innovation and Chief Information Officer Branch
Library and Archives Canada<http://www.bac-lac.gc.ca/eng/Pages/lac-web.aspx> / Government of Canada
andre.laframboise at canada.ca<mailto:andre.laframboise at canada.ca> / Tel: 613-298-1346

[http://www.bac-lac.gc.ca/eng/events/PublishingImages/banner.jpg]<http://www.bac-lac.gc.ca/eng/events/Pages/events.aspx>

From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of Martin Bowes
Sent: Wednesday, May 13, 2020 5:04 AM
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] E_DM9003?

Hi All,

I've seen a storm of messages like:
DBING2_NDPH_OX_AC_::[34476             , 14766     ,  0000000000000000:00007f2a316f2f80, dm2f.c:1883           ]: Wed May 13 09:41:20 2020 E_DM9003_BAD_FILE_DELETE     Disk file delete error on database:bbflagging_live table:NOT_A_TABLE pathname:/dbsystem/B6/ingres/work/default/bbflagging_live filename:rb35ds.m00
didelete.c:295  unlink() failed with operating system error 2 (No such file or directory)

It looks like it's having trouble deleting a modified table...

Anyone seen anything like this? Got any ideas?

Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200513/aa415fc0/attachment.html>