The following error message is written to the SAS log if the MySQL result set does not fit in memory:

    ERROR: Open cursor error: MySQL client ran out of memory. 

The problem occurs because SAS/ACCESS Interface to MYSQL stores a results set in memory by default.

In SAS/ACCESS Interface to MySQL, the new LIBNAME statement option RESULTS= has been implemented to circumvent this issue. Values for this option are as follows:

• MEMORY—Specifies that the query results should be stored in the client machine's memory. MEMORY is the default value.
• SERVER—Specifies that the query results should be stored on a server. The server must be able to evaluate the entire query. If it cannot evaluate the entire query, the software writes the following message to the log:

  Commands out of sync

  In such a case, you should use RESULTS=MEMORY or RESULTS=DISK instead.
• DISK—Specifies that the query results should be stored in a temporary disk file on the client machine. This storage method enables the application to run complex queries with result sets large enough to cause an out-of-memory error. The size of a results set is limited only to the free space on the disk that is used for the temporary file.

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:

The MYSQL client in SAS/ACCESS Interface to MySQL reads result sets into memory. The following error message is written to the SAS log if the result set does not fit in memory:

ERROR: Open cursor error: MySQL client ran out of memory.