SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 33404: A segmentation violation occurs when a MySQL table contains a binary large object (BLOB) variable

DetailsHotfixAboutRate It

When you use variables of the long binary (BLOB) type, a segmentation violation such as the following occurs in the SAS® System because the length is set to -1.

Segmentation Violation In Task [ SQL      ]
Fault Occurred at [_fill+0x44]

Task Traceback

_fill+0x44
xvsele+0x38 -- bridge stub
sqlprep+0x38 -- bridge stub
sqlloop+0x38 -- bridge stub
_uc_trampoline+0xfffffffffffffffc
NOTE: The SAS System stopped processing this step because of errors.
Segmentation Violation In Task [ SQL      ]
Fault Occurred at [0x100018efc(?)]

A hot fix is available for this issue. Before installing the hot fix, you need to include the appropriate SET= option in the OPTIONS statement for your operating system, as follows:

Host        Options
====        ========
WIN      options set=SASMYL MYWIN417
R64/AIX  options set=SASMYL MYR64417

Then install the hot fix.

Select the Hot Fix tab in this note to access the hot fix.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to MySQL64-bit Enabled AIX9.1 TS1M3 SP49.2 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.