Hi, This is not a file corruption I think.
Please try to observe memory allocation during runing this select. Use MW42 -m -P<port_number_of_your_session> to monitor MemFree and MemUsed values. Let us know what is behaviour (how they change). I guess that you may notice pretty high MemFree. Please check also ulimit (process limits) and LDR_CNTRL in order to validate if SIGSEGV does not come from exceeded limits. (Finally) I think that change of malloc options should help you (try with "export MALLOCTYPE=watson" or "export MALLOCTYPE=buckets"). The last undiscussed thing is a sense of running SELECT command on such a big file ;) Kind regards Pawel Dnia 16-03-2009 o godz. 20:51 aft3rgl0w napisał(a): > Hello all. > We are running our T24 on jbase 4.1.5.20 on aix 5.3 and the error ill > explain has also been tested on jbase 4.1.5.24 with the same results. > the problem is during a SELECT statement on a particular file (J4 > type) whose size is ~ 1.6gb and holds about 6 million records.While > SELECT is running i get back a jbase "segmentation violation.aborting" > error after about 1'. I was expecting for jrf -Rv and COUNT to hit > back with the same error or not complete succesfully and give back a > read error or something similar but its not the case, they complete > succesfully. I also ran a jcheck -S on the file but that also > completed without finding any error at all. Even at the new file > created by jcheck i run the SELECT statement and same segmentation > violation error comes up again while jrf and COUNT again complete > succesfully. Does anybody have anything else to suggest to try in > order to make the file healthy again? > thank you. ---------------------------------------------------- Szczypta baśni, garść makabry. Wysmakowana wizualnie opowieść dla całej rodziny. KORALINA I TAJEMNICZE DRZWI 3D - w kinach! Zobacz zwiastun --> http://klik.wp.pl/?adr=http%3A%2F%2Fcorto.www.wp.pl%2Fas%2Fkoralina.html&sid=663 --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
