Myodbc too many connections
Article needs peer review
Symptom
You render a scene with BatchServe, and you get this error in the XSI log of the XSIBatchserve Client application :
================================================== SOFTIMAGE(r) | XSI Version 3.51.2003.1208 batch mode Copyright(c) 1998-2003 Avid Technology, Inc. All rights reserved. ================================================== License information: using [XSI Batch,Enterprise] COMMAND: -batchonly -script C:SoftimageXSIBatchServeClient_1.5inXSI_NT_Client.vbs -main main_xsi -args -dbserver computer.domain.net -dbuser xsi_client -dbpasswd XSIBatchServe -c_id 11 'ERROR : "[TCX][MyODBC]Too many connections - [line 505]" ERROR - Script failed. FATAL - Script Aborted.
Cause
The MySQL server on the BatchServe Server has already reach its limits. The MySQL environment variable max_connection is set by default to 100. Since one BatchServe client uses more then one connections during a render, the default limit of 100 can be reached even if you don't have 100 BatchServe clients.
Solution
You need to increase the value of the MySQL environment variable max_connection. The file you need to update is called my.ini, and it is located in the winnt (or windows) folder of the BatchServe Server computer.
You should add this line in the [mysqld] section of the my.ini file :
set-variable=max_connections=1000
Here's an example of a my.ini file modified :
#This File was made using the WinMySQLAdmin 1.4 Tool #1/20/2003 11:37:53 AM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/batchserve/mysql
set-variable=max_connections=1000 #bind-address=10.10.10.1 datadir=C:/batchserve/mysql/data #language=C:/batchserve/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/batchserve/mysql/bin/mysqld-max-nt.exe user=admin password=admin
Applies To: XSI 3.0,XSI 3.0.1,XSI 3.5,XSI 3.5.x on NT,Win2K
Posted: 3/24/2004
