SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 13311: MYSQL engine fails when trying to process more than 4000 inserts or updates via SQL Pass-through

DetailsHotfixAboutRate It
When attempting to execute 4000 or more inserts/updates via SQL
Pass-through with the MYSQL engine, the following error will occur:

    ERROR: Execute error: MySQL server has gone away

SAS is making a call for each insert/update and 4000 is the limit for
Windows.  Our elimination of this call for each insert/update would fix
the problem.  The only workaround is to break the process into multiple
jobs and execute them sequentially.


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

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013311

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013311


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to MySQLLinux9.1 TS1M39.1 TS1M3 SP1
Microsoft Windows NT Workstation9.1 TS1M39.1 TS1M3 SP1
64-bit Enabled Solaris9.1 TS1M39.1 TS1M3 SP1
64-bit Enabled HP-UX9.1 TS1M39.1 TS1M3 SP1
* 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.