trying to close table iirel_idx:bad file number (unix error 9 )

trying to close table iirel_idx:bad file number (unix error 9 )

Post by Laframboise And » Sun, 20 May 2001 04:45:22



 There's a coincidence.

 I got something similar this morning.
 At 5:51 AM, Ingres reported a 'disk file close error' on the configuration
 file for iidbdb (aaaaaaaa.cnf)from one of the 9 DBMS servers.
 Needless to say, the Server went bye-bye and brought down the whole
installation.

 I'm packaging all the logs and stuff before I open an issue with CA.

 Andre

-----Original Message-----

Sent: Friday, May 18, 2001 11:53 AM

Subject: Re: trying to close table iirel_idx:bad file number (unix error

9)


> Hi, have s.b. seen this error? Do we have to search for an error
> on the database or is it a genuine Unix-Error?

Nothing unusual in the log beforehand? This "error" usually
means that the application has tried to reference a file that
is not open, or that an application r/w request has tried to
reference a file not open for r/w (note, the "application"
seems to be trying to close the file). *Might* be worth a
quick look at the file indicated (/ingresdata1/ingres/data/
default/iidbdb/aaaaaaac.t00). A quick shufty in the iidbms.log
(if you use it) may glean extra info, you never know.

Richard.
--
Erratic news-swerver! :. post+e-mail to be sure I get your msg.
aacdehirrsty
The Open University is not responsible for content herein, which
may be incorrect and is used at reader's own risk.

 
 
 

1. trying to close table iirel_idx:bad file number (unix error 9)

Hi, have s.b. seen this error? Do we have to search for an error on the
database or is it a genuine Unix-Error?
Thanks, Hans

dec840::[1904            , 00000007]: Tue May 15 17:47:54 2001
E_GC0001_ASSOC_FA
IL Association failure: partner abruptly released association
      ::[1931            , 417A0940]: Tue May 15 17:50:48 2001
E_CL0605_DI_BADCL
OSE   Error trying to close file
close() failed with UNIX error 9 (Bad file number)
      ::[1931            , 417A0940]: Tue May 15 17:50:49 2001
E_DM9001_BAD_FILE
_CLOSE   Disk file close error on database:iidbdb
table:iirel_
idx                pathname:/ingresdata1/ingres/data/default/iidbdb
filename:aaa
aaaac.t00
close() failed with UNIX error 9 (Bad file number)
      ::[1931            , 417A0940]: Tue May 15 17:50:49 2001
E_DM9240_DM2F_CLO
SE_ERROR Error occurred closing a file for a table.
      ::[1931            , 417A0940]: Tue May 15 17:50:49 2001
E_DM9340_DM2F_REL
EASE_ERROR  Error releasing a File Control Block.
      ::[1931            , 417A0940]: Tue May 15 17:50:49 2001
E_DM9270_RELEASE_
TCB   Error occurred releasing a TCB.
      ::[1931            , 417A0940]: Tue May 15 17:50:49 2001
E_DM9267_CLOSE_DB
   Error occurred closing a database.
      ::[1931            , 417A0940]: Tue May 15 17:50:49 2001
E_SC010E_DB_DELET
E  Error deleting database.  Name: iidbdb                   Owner: $ingres
            Added Id   0x202CDF1C

2. SQL Server tempdb fills up!

3. trying to close table iirel_idx:bad file number (unix error 9 )

4. Quick question on AutoNumber datatype

5. Bad file number errors using Paradox files on NT

6. Mathematica

7. BDE ERROR "Bad File number"

8. encrypting data for database driven website

9. BDE Error "Bad file number"?????

10. Run-time error '52': Bad file name or number

11. DBlib connection error: bad file number

12. osf1 syb 10.02 (o/s error - bad file number)