Connection to MySQL not closed

Hi there,

My scheduled jobs do not run. The event viewer of my Windows Server 2008 R2 says every 10 seconds: [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.27]Can't create more than max_prepared_stmt_count statements (current value: 16382).
If I restart the aetl service, it works again (for a while).

See also the following link, it seems that the connection will not be closed properly:

iammysql.wordpress.com/2012/05/04/cant-c...mt_count-statements/

Happy to help but can you be more specific please

www.etl-tools.com/forum/rules.html


Mike

Program: Advanced ETL Processor Enterprise.
Version: 5.6.1.1
OS: Windows 2008 R2
DB: MySQL 5.5.27


To reproduce it, I just have a few scheduled jobs (e.g. daily export data of a mysql table) which runs successfully for a few days.

What is your repository type?

Do you do anything else apart from exporting the data?
Eg loading data into MySQL,
Running stored procedures etc

Can you email us a backup of your repository please

Mike

Repository is MySQL.
Other activ jobs are transformations to XML files
Backup is on the way.

It can be that connection to the repository is causing the problem
or it might be becauuse there is something wrong with the export

Anyway can you try using MS Access as repository temporary to see if it will make any diffrence

Mike