Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Diafaan and MySQL ODBC v5.2 leaks prepared statement
sp_NewPost Add Reply sp_NewTopic Add Topic
December 11, 2014
3:18 pm
Henk Helmantel
Forum Posts: 1499
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

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?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
10 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1148

Posts: 3923

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1499