Problem Note 13311: MYSQL engine fails when trying to process more than 4000 inserts or
updates via SQL Pass-through
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
SAS System | SAS/ACCESS Interface to MySQL | Linux | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
Microsoft Windows NT Workstation | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
64-bit Enabled HP-UX | 9.1 TS1M3 | 9.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.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2004-12-02 13:44:53 |
Date Created: | 2004-09-13 15:39:21 |