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.

ARC crashes and memo file grows infinitely

3 posts in NT Last posting was on 2005-11-30 22:07:51.0Z
"Joshua Graham" <jgraham<nospam> Posted on 2005-11-21 15:57:02.0Z
Reply-To: "Joshua Graham" <jgraham<nospam>@anexix.com>
From: "Joshua Graham" <jgraham<nospam>@anexix.com>
Newsgroups: advantage.nt
Subject: ARC crashes and memo file grows infinitely
Date: Mon, 21 Nov 2005 10:57:02 -0500
Lines: 54
Organization: Anexix, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 70.88.67.218
Message-ID: <4381eda0@solutions.advantagedatabase.com>
X-Trace: 21 Nov 2005 08:54:08 -0700, 70.88.67.218
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!70.88.67.218
Xref: solutions.advantagedatabase.com Advantage.NT:1537
Article PK: 1130501

Hey all,

I've noticed that when I am working with corruption in ADT files that have
ADM files associated with them that I am only able to delete a certain
amount of corrupted data at a time until ARC locks up. As soon as ARC
crashes the ADM file associated with the table that I am working on will
just start growing and growing. ADS will not restart and neither will ARC
and the only way to stop it is to restart the machine. My process for
removing corrupted data is as follows:

1. Identify which tables are corrupted.
2. The files are bound to a data dictionary file so I run ARC and select
"Free Data Dictionary Bound Table".
3. I run ADTFIX 1.4 on the data. (Thanks for fixing the problem with that as
well guys!)
4. Next I open the file in ARC and encrypt it. During that process I always
get an error stating "Browse Table Error: Error 5001: A memory allocation
failed during the operation. The application may need more memory space. Not
enough memory for memo field Documentation." The machine that I use to work
with these files has a Gig of memory. If I don't encrypt the table I get
weird error messages when I try to remove the corruption and it won't let me
remove it.

At this point if the table is just an ADT file with no ADM file associated
with it I am able to select all of the corruption at once and delete it all
at one time (and I don't get that Browse Table Error either). If the file
has an associated ADM file I am only able to delete a a portion of
corruption at a time, but after a certain point ARC freezes up. Like I said,
as soon as ARC freezes I can watch that ADM file grow and grow and grow. The
first time I noticed it happening the ADM file grew to over 9 gigs before I
restarted my machine.

The only way I have been able to get around this in the past is to only
delete a little bit of corruption at a time, stop and close ARC, rewrite the
ADM file with the original ADM, reopen ARC, remove more corruption, and
repeat the process. Now I know that that might be causing a problem, but as
of now I haven't seen any problems with the memos when I actually view them,
and they still are associated with the right record when I am done. This is
the only way that I have found to get around this problem, and now
unfortunately I have a huge table (350 megs) that has an ADM file with it. I
am only able to delete about 5 lines of corruption until it crashes, and
this table has at least 500 lines of corruption. I can't sit here all day
long deleting 5 lines of corruption and rebooting. It would take forever.

You guys recently fixed a memory/memo error with ADTFIX (which was
allocating way too much memory to the memo file and subsequentially causing
it to crash ADTFIX). I was wondering if there may be a similar issue with
ARC. Please help me out here!

Thanks!

Josh


"Joshua Graham" <jgraham<nospam> Posted on 2005-11-29 18:23:41.0Z
Reply-To: "Joshua Graham" <jgraham<nospam>@anexix.com>
From: "Joshua Graham" <jgraham<nospam>@anexix.com>
Newsgroups: advantage.nt
References: <4381eda0@solutions.advantagedatabase.com>
Subject: Re: ARC crashes and memo file grows infinitely
Date: Tue, 29 Nov 2005 13:23:41 -0500
Lines: 61
Organization: Anexix, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 70.88.67.218
Message-ID: <438c9bfe@solutions.advantagedatabase.com>
X-Trace: 29 Nov 2005 11:20:46 -0700, 70.88.67.218
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!70.88.67.218
Xref: solutions.advantagedatabase.com Advantage.NT:1538
Article PK: 1130500

Any takers?

"Joshua Graham @anexix.com>" <jgraham<nospam> wrote in message
news:4381eda0@solutions.advantagedatabase.com...
> Hey all,
>
> I've noticed that when I am working with corruption in ADT files that have
> ADM files associated with them that I am only able to delete a certain
> amount of corrupted data at a time until ARC locks up. As soon as ARC
> crashes the ADM file associated with the table that I am working on will
> just start growing and growing. ADS will not restart and neither will ARC
> and the only way to stop it is to restart the machine. My process for
> removing corrupted data is as follows:
>
> 1. Identify which tables are corrupted.
> 2. The files are bound to a data dictionary file so I run ARC and select
> "Free Data Dictionary Bound Table".
> 3. I run ADTFIX 1.4 on the data. (Thanks for fixing the problem with that
> as well guys!)
> 4. Next I open the file in ARC and encrypt it. During that process I
> always get an error stating "Browse Table Error: Error 5001: A memory
> allocation failed during the operation. The application may need more
> memory space. Not enough memory for memo field Documentation." The machine
> that I use to work with these files has a Gig of memory. If I don't
> encrypt the table I get weird error messages when I try to remove the
> corruption and it won't let me remove it.
>
> At this point if the table is just an ADT file with no ADM file associated
> with it I am able to select all of the corruption at once and delete it
> all at one time (and I don't get that Browse Table Error either). If the
> file has an associated ADM file I am only able to delete a a portion of
> corruption at a time, but after a certain point ARC freezes up. Like I
> said, as soon as ARC freezes I can watch that ADM file grow and grow and
> grow. The first time I noticed it happening the ADM file grew to over 9
> gigs before I restarted my machine.
>
> The only way I have been able to get around this in the past is to only
> delete a little bit of corruption at a time, stop and close ARC, rewrite
> the ADM file with the original ADM, reopen ARC, remove more corruption,
> and repeat the process. Now I know that that might be causing a problem,
> but as of now I haven't seen any problems with the memos when I actually
> view them, and they still are associated with the right record when I am
> done. This is the only way that I have found to get around this problem,
> and now unfortunately I have a huge table (350 megs) that has an ADM file
> with it. I am only able to delete about 5 lines of corruption until it
> crashes, and this table has at least 500 lines of corruption. I can't sit
> here all day long deleting 5 lines of corruption and rebooting. It would
> take forever.
>
> You guys recently fixed a memory/memo error with ADTFIX (which was
> allocating way too much memory to the memo file and subsequentially
> causing it to crash ADTFIX). I was wondering if there may be a similar
> issue with ARC. Please help me out here!
>
> Thanks!
>
> Josh
>


Peter Funk (ADS) Posted on 2005-11-30 22:07:51.0Z
Message-ID: <a46fe23613bb98c7c3d75ae750e9@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <peterf@extendsys.com>
Subject: Re: ARC crashes and memo file grows infinitely
Newsgroups: Advantage.NT
References: <438c9bfe@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 671.6
NNTP-Posting-Host: 198.102.102.31
Date: 30 Nov 2005 15:07:51 -0700
X-Trace: 30 Nov 2005 15:07:51 -0700, 198.102.102.31
Lines: 24
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.31
Xref: solutions.advantagedatabase.com Advantage.NT:1539
Article PK: 1130502

Hello Josh,
The behavior you're describing (ARC allocating tons of memory) and the fact
that you're modifying the table, then replacing the ADM file with an older
copy, screams of memo corruption - either in the ADM file itself or in the
ADT records. In any case, after just one iteration of the steps you perform,
I wouldn't trust your ADM file at all.

The crux of your problem (other than the corruption itself) seems to be that
ARC is crashing (or hanging) while trying to read the corrupted memo fields.
If you can programmatically identify the corrupted records, perhaps you
could write an application which deletes the corrupted records without reading
the memo field data. A more manual approach would be to write an application
similar to ARC in that it displays your table in a grid, only don't display
the memo fields (there must be a way to only display certain fields in a
data grid?). Then you could select and delete the corrupted records (as
you do with ARC) without the memo corruption getting in the way.

Just some ideas...

Regards,
Peter Funk
Advantage R&D