Problem Note 68860: A segmentation violation occurs when you use a SELECT DISTINCT query that refers to an SQL view
 |  |  |  |  |
When you use a SELECT DISTINCT query that references an SQL view, a segmentation violation that is similar to the following can occur:
The SAS task name is [SQL ]
Segmentation Violation
Traceback of the Exception:
/sasgen/dev/mva-v940m7f/SAS/laxdo/sas(+0x17d63e) [0x7f127f6a063e]
/sasgen/dev/mva-v940m7f/SAS/laxdo/sas(+0x503fe) [0x7f127f5733fe]
/sasgen/wky/mva-v940m7/sasdvd/com/laxdo/tkmk.so(bkt_signal_handler+0x14b) [0x7f127d5b32db]
/lib64/libpthread.so.0(+0x39f920f7e0) [0x7f127eed47e0]
/sasgen/wky/mva-v940m7/sasdvd/com/laxdo/tkmk.so(skm_unlinke+0x26) [0x7f127d5cbf96]
/sasgen/wky/mva-v940m7/sasdvd/com/laxdo/tkmk.so(skmMemRelease+0x160) [0x7f127d5c8250]
/sasgen/dev/mva-v940m7f/sasdvd/com/laxdo/sassqx(+0x423c1) [0x7f12506e63c1]
/sasgen/dev/mva-v940m7f/sasdvd/com/laxdo/sassqx(sqxexec+0x69e) [0x7f12506efc3e]
/sasgen/dev/mva-v940m7f/sasdvd/com/laxdo/sassqx(+0x44630) [0x7f12506e8630]
/sasgen/dev/mva-v940m7f/sasdvd/com/laxdo/sassqx(sqlloop+0x33c) [0x7f12506e769c]
/sasgen/dev/mva-v940m7f/sasdvd/com/laxdo/sassql(sassql+0x36d) [0x7f1250f6f97d]
/sasgen/dev/mva-v940m7f/SAS/laxdo/sas(vvtentr+0x17f) [0x7f127f572fbf]
/lib64/libpthread.so.0(+0x39f9207aa1) [0x7f127eeccaa1]
/lib64/libc.so.6(clone+0x6d) [0x7f127e55ac4d]
There is no circumvention. At this time, the problem occurs only on Linux operating systems. Microsoft Windows systems are unaffected.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Linux for x64 | 9.4_M4 | 9.4_M8 | 9.4 TS1M4 | 9.4 TS1M8 |
A fix for this issue for Base SAS 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9R.html#68860| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-02-16 09:08:56 |
| Date Created: | 2022-02-01 09:30:50 |