Ingres Q & A
nordahl@stkd90.alcatel.no (Trygve Nordahl) writes: >Hi, > >we're running Ingres 6.4/04 (su4.us5/02) on Solaris 2.3 machines. From time to >time, the Ingres environment (II_DATABASE, II_CHECKPOINT...) just >disappears ! > >This has happened about 5 times that I know of, in different installations. >However, since it appear at (apparently) random times, it is difficult to debug. > >Running iibuild solves the problem all right. > >Has anyone had similar experience ? Any information on the subject is highly >appreciated. > Yes, I have seen this many times. It occurs when the II_CONFIG disk is full AND somebody tries to: a) start Ingres, b) stop Ingres, c) run ingsetenv or ingsetauth d) or anything that causes symbol.tbl to be rewritten. It happens because the symbol.tbl file is modified the following way: 1. It is read into memory 2. It's underlying file is deleted 3. A new file is opened 4. It's written from memory to disk It's easy to see the problem with this scenario. It's SUPER easy to fix. Ingres does NOT consider this a bug. Cheers, |--------------------------------------------------------------------------| | Michael Leo | The Ingres FAQ is at ftp.adc.com, /pub/ingres. | | York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for | | Minneapolis, MN, USA | the NAIUA Tool Kit. Lastly, access all this via| | (612) 921-8083 (voice) | WWW at http://www.adc.com/ingres/ing-top.html. | | mal@winternet.com | All constructive suggestions/criticism welcome. | |--------------------------------------------------------------------------| jonm@ingres.com "Jon Machtynger" writes: > Roy Hann (rhh@tachy.uah.ualberta.ca) wrote: > : nordahl@stkd90.alcatel.no (Trygve Nordahl) writes: > : : > ::we're running Ingres 6.4/04 (su4.us5/02) on Solaris 2.3 machines. From time > to > ::time, the Ingres environment (II_DATABASE, II_CHECKPOINT...) just > ::disappears ! > :: > ::This has happened about 5 times that I know of, in different installations. > ::However, since it appear at (apparently) random times it is difficult to > debug > :: > :: Running iibuild solves the problem all right. > :: > :: Has anyone had similar experience ? Any information on the subject is highly > :: appreciated. > > : I take it you mean the definitions of those symbols disappears, not > : the locations to which they refer? I do vaguely remember that there > : is some kind of problem where $II_SYSTEM/ingres/files/symbol.tbl > : get trashed. It has never happened to me, but I have a little cron > : job that backs up that file for me every once in a while, just in > : case. > > I've seen this problem when the file system holding the symbol.tbl fills up. > So when Ingres tries to write a new entry in the file, it effectively recreates > the file and there is no room. I have also heard that the file will just > truncate for no reason. I have never seen this myself... > > What I recommend in the second case is that you modify your startup/shutdown > to take a copy on shutdown and recopy the old one on startup. Or alternatively > link ingsetenv to your new ingsetenv that does an ingsetenv.orig.sh and then > copies the file. Then any changes you make between startup and file loss will > also be included. We have had a similar problem recently on OpenIngres 1.1 :- the file symbol.tbl got trashed when the dbms shut down abnormally. This happened at the UK IUA in May (remember the red faces at our OpenIngres IMA demo of I/Watch ?). So its still a potential problem with OI also. As Roy & Jon say, keep a backup copy. -- ------------------------------------------------------------------------------- Dennis Adams Common Sense Computing (UK) Ltd dennis@comsense.com Canada House, 272 Field End Rd, Eastcote, Middx HA4 9NA Phone: 0181 866 4400 Fax: 0181 429 2848 http://www.comsense.com/comsense -------------------------------------------------------------------------------
Ingres Q & A
To William's Home Page
© William Yuan 2000
Email William