Segmentation violation error

Sathya3 — Tue, 27 Aug 2024 14:10:53 GMT

I am working on a large data where I am creating 150+ columns using case statements in proc sql create table with multiple join conditions

When I try to run the code and create output it is giving me error for few tables where the record count is around 20 millions in source table .It is running fine for other tables where record count is less in source tables.

I am not creating any sas view. I am creating tables in hive using proc sql sas code. I have done some research over the net about this error and my code is not falling into any categories where this error can occur as per sas support portal

Can someone pls help resolve this.Below is the error

ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:

The SAS task name is [SQL ]
Segmentation Violation

Traceback of the Exception:

/home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(+0x16844e) [0x7f68ffaf444e]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(+0x4ee1f) [0x7f68ff9dae1f]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f68fddcdac4]
/lib64/libpthread.so.0(+0x3d36c0f790) [0x7f68ff33e790]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x23eff) [0x7f68c6175eff]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x22ac3) [0x7f68c6174ac3]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x2f9d8) [0x7f68c61819d8]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x391a1) [0x7f68c618b1a1]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(sqltxt2+0x51e) [0x7f68c616711e]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(+0x5089d) [0x7f68c640d89d]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlpsel+0xfb6) [0x7f68c640c5f6]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlplan+0x219) [0x7f68c63f8de9]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlprep+0x3ee) [0x7f68c642a89e]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqx(+0x3be91) [0x7f68c6dc4e91]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqx(sqlloop+0x417) [0x7f68c6dc4617]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassql(sassql+0x362) [0x7f68c7416402]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(vvtentr+0x18a) [0x7f68ff9da97a]
/lib64/libpthread.so.0(+0x3d36c07a51) [0x7f68ff336a51]
/lib64/libc.so.6(clone+0x6d) [0x7f68fe9c496d]

Re: Segmentation violation error

PaigeMiller — Tue, 27 Aug 2024 14:16:56 GMT

ERROR:  An exception has been encountered.
Please contact technical support and provide them with the following traceback information:

Contact SAS Technical Support.

Re: Segmentation violation error

SASKiwi — Tue, 27 Aug 2024 21:12:14 GMT

What is your SAS session MEMSIZE setting? Normally PROC SQL will error gracefully if it runs out of memory, but it is possible if it has way too little memory it may not behave gracefully. Run this to confirm your MEMSIZE and post the results:

proc options option = memsize;
run;

In my experience, large SQL queries require a MEMSIZE of at least 6GB.

Re: Segmentation violation error

ChrisNZ — Tue, 27 Aug 2024 23:47:29 GMT

To note that MEMSIZE is for memory including paging space. REALMEMSIZE is for RAM only.

topic Segmentation violation error in SAS Programming

Segmentation violation error

Re: Segmentation violation error

Re: Segmentation violation error

Re: Segmentation violation error