Support forum
Add Reply
Add Topic3:18 pm
May 28, 2013
Offline
QuoteHello 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
2:55 pm
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?
Most Users Ever Online: 529
Currently Online:
6 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 679
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1154
Posts: 3941
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1508