[sqr-users] Illegal Instruction & Memory Fault (coredump)

[Christine Sessler <cms41@cornell.edu>]

Folks -

I'm looking for some help on resolving the coredump problem that I'm having 
with an SQR.

The SQR is pretty basic with no complicated JOINS.  It selects about 
300,000+ Emplids and then goes through a series of selects to get Bio/Demo 
and Degree data for each person selected.  Ultimately, two output files 
will be created - one for Bio/Demo and one for Degree data - and these will 
be sent to a vendor.  It also inserts each row processed into a custom SQL 
table.  I'm committing after every 15K Emplids processed.

I've commented out the WRITEs to the file and I'm still encountering the 
following coredump errors.  I've tried chunking the main SQL in batches of 
100,000 Emplids but that's when I got the "illegal instruction" error after 
it processed 124K Emplids.

[...snip...]SQR_AVP601CU_115467/prcs_sqr[96]: 54986 Memory fault(coredump)
[...snip...]SQR_AVP601CU_115478/prcs_sqr[96]: 75854 Illegal 
instruction(coredump)

I'd really rather not have the operator have to run this job numerous 
times, running in batches of 100K Emplids from outside of the program but 
that's what I'm considering now.

I expect that as we bring Contributor Relations into Production (scheduled 
for 7/28) and this interface is run in Production, that the number of 
EmplIds processed is going to continue to grow.

Does anyone have any thoughts on how else to handle this situation?

Thanks,
Chris



************************************************************
Christine Sessler
Cornell University
CIT/Business Information Systems
120 Maple Avenue
Ithaca, NY  14850

607.255.2816 - MARS Project
607.255.8149  - Maple Ave
607.255.6982  - Fax
cms41@cornell.edu
************************************************************
"Live in such a way that you would not be ashamed to sell your parrot to 
the town gossip." - Will Rogers
"If a dog jumps in your lap, it is because he is fond of you;
but if a cat does the same thing, it is because your lap is warmer." - 
Alfred North Whitehead
"When the eagles are silent, the parrots begin to jabber." - Sir Winston 
Churchill  

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users