Problem Note 68544: A segmentation violation occurs and SAS® crashes when you use a PROC SQL CONNECT statement with AUTHDOMAIN= as the final option in the code
 |  |  |  |
A segmentation violation might occur when you use the SQL procedure with a CONNECT statement and an AUTHDOMAIN= option is the last option provided, as shown in this log example. Note: In this example, a macro variable has been used for the AUTHDOMAIN= option and that macro variable has been defined as having a blank value:
78 %let myDomain = ;
79 proc sql;
80 connect to postgres (server=server-name authdomain=&myDomain) ;
79 proc sql;
80 connect to postgres (server=server-name authdomain=&myDomain) ;
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
Please contact technical support and provide them with the following traceback information:
The SAS task name is [SQL ]
Segmentation Violation
Segmentation Violation
Traceback of the Exception:
/opt/sas/viya/home/SASFoundation/sasexe/libsas.so(tktracex+0x42) [0x7ff43945db02]
/opt/sas/viya/home/SASFoundation/sasexe/libsas.so(ht_handle_program_fault+0x2f4) [0x7ff43931b044]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x154) [0x7ff4548b89f4]
/lib64/libpthread.so.0(+0x12b20) [0x7ff455f36b20]
/opt/sas/viya/home/SASFoundation/sasexe/sasxdbi(+0x7d5b0) [0x7ff3e8b5b5b0]
/opt/sas/viya/home/SASFoundation/sasexe/sasxdbi(conn+0x91a) [0x7ff3e8b275fa]
/opt/sas/viya/home/SASFoundation/sasexe/sassqp(sqpcon+0x60d) [0x7ff3e905991d]
/opt/sas/viya/home/SASFoundation/sasexe/sassqx(+0x45b2f) [0x7ff3e9f3fb2f]
/opt/sas/viya/home/SASFoundation/sasexe/sassqx(sqlloop+0x3d0) [0x7ff3e9f3f120]
/opt/sas/viya/home/SASFoundation/sasexe/sassql(sassql+0x389) [0x7ff3ea3c8659]
/opt/sas/viya/home/SASFoundation/sasexe/libsas.so(vvtentr+0x199) [0x7ff43931ac29]
/lib64/libpthread.so.0(+0x814a) [0x7ff455f2c14a]
/lib64/libc.so.6(clone+0x43) [0x7ff4554acdc3]
SAS WTABORT (SQL) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[2D6AC320] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[2D6AC320]
[EVENTTSK] [WAITING ] pri[ 0] reb[2D6AC320] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[2D6AC320] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[1D923E20] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[1D9244C0] WC[0] WN[1]
[Compute ] [WAITING ] pri[ 7] reb[1D924C20] WC[0] WN[1]
[COMPXAM ] [WAITING ] pri[ 7] reb[1D924C20] WC[0] WN[1]
[CMP1 ] [UNKNOWN ] pri[ 5] reb[1D924C20]
[SASODR ] [WAITING ] pri[ 3] reb[19EA2200] WC[0] WN[1]
[SQL ] [RUNNING ] pri[ 7] reb[1906B140]
Traceback
No Traceback Available
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
/opt/sas/viya/home/SASFoundation/sasexe/libsas.so(ht_handle_program_fault+0x2f4) [0x7ff43931b044]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x154) [0x7ff4548b89f4]
/lib64/libpthread.so.0(+0x12b20) [0x7ff455f36b20]
/opt/sas/viya/home/SASFoundation/sasexe/sasxdbi(+0x7d5b0) [0x7ff3e8b5b5b0]
/opt/sas/viya/home/SASFoundation/sasexe/sasxdbi(conn+0x91a) [0x7ff3e8b275fa]
/opt/sas/viya/home/SASFoundation/sasexe/sassqp(sqpcon+0x60d) [0x7ff3e905991d]
/opt/sas/viya/home/SASFoundation/sasexe/sassqx(+0x45b2f) [0x7ff3e9f3fb2f]
/opt/sas/viya/home/SASFoundation/sasexe/sassqx(sqlloop+0x3d0) [0x7ff3e9f3f120]
/opt/sas/viya/home/SASFoundation/sasexe/sassql(sassql+0x389) [0x7ff3ea3c8659]
/opt/sas/viya/home/SASFoundation/sasexe/libsas.so(vvtentr+0x199) [0x7ff43931ac29]
/lib64/libpthread.so.0(+0x814a) [0x7ff455f2c14a]
/lib64/libc.so.6(clone+0x43) [0x7ff4554acdc3]
SAS WTABORT (SQL) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[2D6AC320] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[2D6AC320]
[EVENTTSK] [WAITING ] pri[ 0] reb[2D6AC320] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[2D6AC320] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[1D923E20] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[1D9244C0] WC[0] WN[1]
[Compute ] [WAITING ] pri[ 7] reb[1D924C20] WC[0] WN[1]
[COMPXAM ] [WAITING ] pri[ 7] reb[1D924C20] WC[0] WN[1]
[CMP1 ] [UNKNOWN ] pri[ 5] reb[1D924C20]
[SASODR ] [WAITING ] pri[ 3] reb[19EA2200] WC[0] WN[1]
[SQL ] [RUNNING ] pri[ 7] reb[1906B140]
Traceback
No Traceback Available
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
ERROR: Errors printed on page 1.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 28.89 seconds
cpu time 2.92 seconds
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 28.89 seconds
cpu time 2.92 seconds
This problem has been observed with several SAS/ACCESS® engines, including but not limited to Oracle, Teradata, and Postgres.
To circumvent the segmentation violation in this situation, ensure either that AUTHDOMAIN= is not the final option, or that the AUTHDOMAIN= value is within quotation marks, as shown in this syntax:
%let myDomain = DefaultAuth ;
proc sql ;
connect to postgres (authdomain="&myDomain" server=server-name) ;
quit ;
proc sql ;
connect to postgres (authdomain="&myDomain" server=server-name) ;
quit ;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | 64-bit Enabled AIX | 9.4_M2 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 9.4_M2 | 9.4 TS1M2 | ||||
| HP-UX IPF | 9.4_M2 | 9.4 TS1M2 | ||||
| Linux for x64 | 9.4_M2 | 9.4 TS1M2 | ||||
| Solaris for x64 | 9.4_M2 | 9.4 TS1M2 | ||||
| SAS System | SAS Viya | Linux for x64 | 2021.1.6 | Viya | ||
The AUTHDOMAIN= option should always have a value, but if it is blank, it might trigger a segmentation violation.
| Type: | Problem Note |
| Priority: | low |
| Topic: | Data Management ==> data management Data Management ==> Data Sources ==> Metadata SAS Reference ==> SQL |
| Date Modified: | 2021-10-27 13:51:59 |
| Date Created: | 2021-10-22 11:25:29 |