[Info-ingres] E_DM9003?

[Laframboise, André (BAC/LAC)]

Odd. I always thought the *.m00 files were used during the sort process of a modify statement.

Hate to add to this mystery but I'm confused as to why a truncated would create a *.m00 file.

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 10:36 AM
To: Laframboise, André (BAC/LAC) <andre.laframboise at canada.ca>; info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] E_DM9003?

Hi Andre,

Yes a session temp is being modified to truncated. But I've been completely unable to reproduce the problem wit a simple modify to truncated. There appears to be something else happening tht causes the problem. We've put in place a lot of session tracing and are hoping to catch something interesting.

We see in the errlog:
E_CL0611_DI_FILENOTFOUND The file 'rb4fig.m00' could not be found in '/dbsystem/B6/ingres/work/default/bbflagging_live'

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:rb4fig.m00
didelete.c:295  unlink() failed with operating system error 2 (No such file or directory)

E_DM9291_DM2F_FILENOTFOUND   When attempting to open a file, the file did not exist.

E_DM0095_ERROR_COMMITING_TRAN    Error committing a transaction.

Marty

From: Laframboise, André (BAC/LAC) <andre.laframboise at canada.ca<mailto:andre.laframboise at canada.ca>>
Sent: 13 May 2020 15:14
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] E_DM9003?


Just noticed your missing file was in a work directory. Modifying a session temp table ?

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

[Image removed by sender. 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<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: Wednesday, May 13, 2020 5:04 AM
To: info-ingres at lists.planetingres.org<mailto: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/7c347a59/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 752 bytes
Desc: image001.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200513/7c347a59/attachment.jpg>