Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: Sybase Interfaces problem

    Our application is giving the following error whenever the interfaces file is overwritten when its being run in the background -

    DATABASE ERROR:: Unable to close interfaces file.
    DATABASE ERROR:: Stale NFS file handle

    The error was not there when Sybase 12.0 was running on Unix 2.6. Now its running on Unix 2.8. Has anything changed in the Sybase Unix interface libraries for v2.8?

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Can you pls. provide more detail? Why is the interfaces file overwritten by the application???

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    I'd do an fuser -fu on the interfaces to check who or what has open handles on this file.

  4. #4
    Join Date
    Apr 2004
    Posts
    2
    Originally posted by mkalsi
    Can you pls. provide more detail? Why is the interfaces file overwritten by the application???
    The interfaces file is being overwritten by another event in the background. The application has a handle to the interfaces file. The error is happening once the app was migrated to Unix 2.8

  5. #5
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Not sure why there is already a stale open handle. You should be able to clear this using fuser -ku on the interfaces file.

  6. #6
    Join Date
    Jan 2005
    Posts
    1

    More info an client application

    I am having the same problem. Do you use DBLIB or CTLIB from your application? Is it a PERL app, C++ program or other?

    I am using DBLIB from PERL and experiencing the exact same error when our interfaces file is updated while the app is running.

  7. #7
    Join Date
    Jun 2009
    Posts
    1
    I am using DBLIB from PERL and experiencing the exact same error when our interfaces file is updated while the app is running. How to resolve this issue

  8. #8
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    From the posts, it looks like whoever is having problems has somewhat an fopen (in c terms) on the file. And theres some kind of mechanism from the dba infrastructure side which refreshes your interfaces file on a periodic basis.

    Is this true? If it is, are u closing the file properly once you read it from perl or whatever program? Theres no need for you to keep the file open after u r done with what you want to know.
    Last edited by trvishi; 06-03-09 at 17:27.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •