Support forum

Home Support forum Using Diafaan SMS Server Diafaan and MySQL ODBC v5.2 leaks p…

Diafaan and MySQL ODBC v5.2 leaks prepared statement

Add Reply

Add Topic

December 11, 2014
3:18 pm

Henk Helmantel

Admin

Forum Posts: 1488

Member Since:
May 28, 2013

Offline

Quote

Hello Guiseppe,

According to this question on Stack Overflow this is a known bug in version 5.2 of the MySQL ODBC driver.

One solution is to downgrade to driver version 5.1. But if you want to use the new driver you can also add 'NO_SSPS=1' to the connection string in the SQL Connector of Diafaan SMS Server. This setting disables the server side prepared statement function that causes the problem.

Regards, Henk

December 11, 2014
2:55 pm

Giuseppe

Guest

Guests

Quote

Hi,
we installed a Diafaan server on a Win7 machine, MySQL DB and MySQL ODBC driver.
Daily, the Diafaan server reports a MySQL error telling

11/12/2014 13:00:35 ERROR [HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.24]Can't create more than max_prepared_stmt_count statements (current value: 16382)

Monitoring MySQL database, we have seen that one new prepared statement was created every 5 secs (!!!). Stopping Diafaan Server we have seen that prepared statement count returned to zero. We have checked that on other box this problem isn't present. We have downgraded to MySQL ODBC driver ver 5.1 fixing the issue.
Is there any particular tips to run with ver MySQL ODBC v5.2?

Add Reply

Add Topic

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)