Segmentation Violation error
- wam
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
13 years 4 months ago - 13 years 4 months ago #10250
by wam
Segmentation Violation error was created by wam
What could be the reasons of jBASE Segmentation violation error
i am trying to select financial files which are carrying huge data i.e in millions.
Be noted the T24 Release:: R8005 and jBASE version :: jBASE526
Below stats FYI
jsh ~ --> SELECT FBNK.RE.SPEC.ENTRY.XREF [having 10 million records approx ]
jBASE: Segmentation violation. Aborting
jsh ~ --> SELECT FBNK.RE.SPEC.ENTRY.DETAIL [having 70 million records approx]
jBASE: Segmentation violation. Aborting
i am trying to select financial files which are carrying huge data i.e in millions.
Be noted the T24 Release:: R8005 and jBASE version :: jBASE526
Below stats FYI
jsh ~ --> SELECT FBNK.RE.SPEC.ENTRY.XREF [having 10 million records approx ]
jBASE: Segmentation violation. Aborting
jsh ~ --> SELECT FBNK.RE.SPEC.ENTRY.DETAIL [having 70 million records approx]
jBASE: Segmentation violation. Aborting
Last edit: 13 years 4 months ago by wam. Reason: edit
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
13 years 4 months ago #10252
by durai611
Replied by durai611 on topic Re: Segmentation Violation error
Try setting ulimit in .profile as unlimited and select the file. Or else it's better to have some conditional select over huge files like this.
Please Log in or Create an account to join the conversation.
- wam
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
13 years 4 months ago #10253
by wam
Replied by wam on topic Re: Segmentation Violation error
To be more interesting this behavior is not occuring on another environment :)
It is giving the correct record count.
It is giving the correct record count.
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
13 years 4 months ago #10256
by durai611
Replied by durai611 on topic Re: Segmentation Violation error
Have you compared the ulimit settings between the two areas?
Please Log in or Create an account to join the conversation.
- wam
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
13 years 4 months ago #10278
by wam
Replied by wam on topic Re: Segmentation Violation error
I have checked in both areas .PROFILE file.There wasn't any setting set for it
i.e ulimit variable was not in use.
Nevertheless i had set the variable as unlimited but the problem still persisted.
i.e ulimit variable was not in use.
Nevertheless i had set the variable as unlimited but the problem still persisted.
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
13 years 4 months ago #10279
by durai611
Replied by durai611 on topic Re: Segmentation Violation error
Not sure what is the problem. But you can check the following,
1. Is the file corrupted . use jstat -v filename
2. file is sized badly. use jrf -Rv filename
1. Is the file corrupted . use jstat -v filename
2. file is sized badly. use jrf -Rv filename
Please Log in or Create an account to join the conversation.
- wam
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
13 years 4 months ago #10283
by wam
Replied by wam on topic Re: Segmentation Violation error
Nopes file in not corrupted i had already checked jstats
Also since table type is XMLORACLE so there is no point of file sizing.
Also since table type is XMLORACLE so there is no point of file sizing.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
13 years 4 months ago #10286
by jpb
Replied by jpb on topic Re: Segmentation Violation error
ulimit is always in use, check it with
ulimit -a
ulimit -a
Please Log in or Create an account to join the conversation.
- wam
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
13 years 4 months ago #10342
by wam
Replied by wam on topic Re: Segmentation Violation error
i checked it was not unlimited
so set it with
>ulimit -d unlimited
the select query worked after it.
By the way what will be its implications on the system as a whole.
so set it with
>ulimit -d unlimited
the select query worked after it.
By the way what will be its implications on the system as a whole.
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
13 years 4 months ago #10343
by durai611
Replied by durai611 on topic Re: Segmentation Violation error
System will allocate full data segment resource for the current process/user. There won't be any implications.
Check Linux/UNIX help of this command in the web.
Check Linux/UNIX help of this command in the web.
Please Log in or Create an account to join the conversation.
Time to create page: 0.041 seconds