000 tsql ABEND exception 0xC0000005 (ACCESS_VIOLATION)

danc0 · Post by **danc0** » Mon Aug 11, 2003 3:56 pm

When trying to build indexes are a particularly large table (2gig) I get the following error:
000 tsql ABEND exception 0xC0000005 (ACCESS_VIOLATION)
The indexes built fine on another machine with the same table. I also get the same error when trying to build a metamorph index.

Texis is running in Win2k
Texis Version 04.02.1042137524(20030109) Copyright (c) 1988-2003 Thunderstone EPI

Post by **Kai** » Mon Aug 11, 2003 4:14 pm

How much RAM does the machine have? Any other differences from the other (working) machine?

danc0 · Post by **danc0** » Mon Aug 11, 2003 4:20 pm

The machine has 500mb of RAM. The working machine is a heftier machine, faster processor and 1gig of RAM.

Even a query like:
SELECT id FROM PATN WHERE ((ABST_PAx LIKE 'optical receivers w/17' OR ABST_PAx LIKE 'shaped prism w/12' ) or (ABST_PAx LIKE 'brush dye file interferome
ter pigment sandpaper scraper scratch @0')) ;

Will throw the same error.
I thought the problem might be related to permissions, but even logging on as _SYSTEM doesn't help.

I have 7gig of free space on the drive my system temp directory is on, so I don't think that is a problem. Should I try limiting the memory used?

Watching my system performanace, I never exceed 50% processor usage or 240mb of RAM

Post by **Kai** » Mon Aug 11, 2003 5:04 pm

Could be a bad record in the table causing a problem. Try copying the table locally like this:

tsql "create table test as select * from PATN"

and see if that returns an ABEND as well.

danc0 · Post by **danc0** » Mon Aug 11, 2003 6:09 pm

Thanks, I was able to both create and index the test tbl, so it looks like the original PATN table was indeed corrupted somehow. I am going to drop the original table and indexes then rebuild from the newly created test table. Thanks for the help, give John my regards.