Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Myriad or Semaphore Files

3 posts in Networking Last posting was on 2004-11-23 05:19:06.0Z
Nick Posted on 2004-11-17 06:20:34.0Z
Date: Wed, 17 Nov 2004 01:20:34 -0500
From: Nick <adsnews@spamex.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8a4) Gecko/20040914
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: advantage.networking
Subject: Myriad or Semaphore Files
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.195.20.72
Message-ID: <419aedf1@solutions.advantagedatabase.com>
X-Trace: 16 Nov 2004 23:21:37 -0700, 216.195.20.72
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.195.20.72
Xref: solutions.advantagedatabase.com Advantage.Networking:482
Article PK: 1131908

I've enabled the use of semaphore files in my client's medical billing
software which uses the Advantage Database Server. The problem is that
these files are never getting deleted. Over the course of the year, I
have manually deleted hundreds of thousands of them (of course, not
one-by-one ;-). They become a pain when backing up the server because
they take time to process even though they are 0 bytes in length. They
also occupy lots of space in the NTFS MFT area.

How can I get these files to be automatically deleted once they are no
longer being used? Is this a bug?

Thanks,
CodedoC


Mark Wilkins Posted on 2004-11-17 20:16:54.0Z
From: "Mark Wilkins" <mwilkins@extendsys.com>
Newsgroups: advantage.networking
References: <419aedf1@solutions.advantagedatabase.com>
Subject: Re: Myriad or Semaphore Files
Date: Wed, 17 Nov 2004 13:16:54 -0700
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 198.102.102.86
Message-ID: <419bb23e@solutions.advantagedatabase.com>
X-Trace: 17 Nov 2004 13:19:10 -0700, 198.102.102.86
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.86
Xref: solutions.advantagedatabase.com Advantage.Networking:483
Article PK: 1131907

Hi Nick,

I looked into this, and it is a bug. The server is supposed to delete
those, but the client is not closing them correctly. So if the client
application keeps running for any length of time after the disconnect, the
server will not be able to clean up the semaphore files.

Can you turn off the use of semaphores? It is actually more resource
efficient to not use semaphore files.

Mark Wilkins
Advantage R&D

"Nick" <adsnews@spamex.com> wrote in message
news:419aedf1@solutions.advantagedatabase.com...
> I've enabled the use of semaphore files in my client's medical billing
> software which uses the Advantage Database Server. The problem is that
> these files are never getting deleted. Over the course of the year, I
> have manually deleted hundreds of thousands of them (of course, not
> one-by-one ;-). They become a pain when backing up the server because
> they take time to process even though they are 0 bytes in length. They
> also occupy lots of space in the NTFS MFT area.
>
> How can I get these files to be automatically deleted once they are no
> longer being used? Is this a bug?
>
> Thanks,
> CodedoC


Nick Posted on 2004-11-23 05:19:06.0Z
Date: Tue, 23 Nov 2004 00:19:06 -0500
From: Nick <adsnews@spamex.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8a4) Gecko/20040914
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: advantage.networking
Subject: Re: Myriad of Semaphore Files
References: <419aedf1@solutions.advantagedatabase.com> <419bb23e@solutions.advantagedatabase.com>
In-Reply-To: <419bb23e@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.195.20.72
Message-ID: <41a2c87d@solutions.advantagedatabase.com>
X-Trace: 22 Nov 2004 22:19:57 -0700, 216.195.20.72
Lines: 41
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.195.20.72
Xref: solutions.advantagedatabase.com Advantage.Networking:484
Article PK: 1131906

Mark,

Thanks for the response. I can turn off the use of semaphores. The
reason I didn't try it was because it was not clear from the
documentation whether it would cause file sharing issues.

Nick

Mark Wilkins wrote:
> Hi Nick,
>
> I looked into this, and it is a bug. The server is supposed to delete
> those, but the client is not closing them correctly. So if the client
> application keeps running for any length of time after the disconnect, the
> server will not be able to clean up the semaphore files.
>
> Can you turn off the use of semaphores? It is actually more resource
> efficient to not use semaphore files.
>
> Mark Wilkins
> Advantage R&D
>
> "Nick" <adsnews@spamex.com> wrote in message
> news:419aedf1@solutions.advantagedatabase.com...
>
>>I've enabled the use of semaphore files in my client's medical billing
>>software which uses the Advantage Database Server. The problem is that
>>these files are never getting deleted. Over the course of the year, I
>>have manually deleted hundreds of thousands of them (of course, not
>>one-by-one ;-). They become a pain when backing up the server because
>>they take time to process even though they are 0 bytes in length. They
>>also occupy lots of space in the NTFS MFT area.
>>
>>How can I get these files to be automatically deleted once they are no
>>longer being used? Is this a bug?
>>
>>Thanks,
>>CodedoC
>
>
>