3

I'm in the process of upgrading the CF8 instances in our environment to CF10, but I'm running into a weird issue with the DB.

Datasources connect to a MySQL 5.0.8 DB using InnoDB. Our current setup with CF8 works fine, but when we try and point a CF10 instance, it seems to start leaving connections open on writes which locks the table and that starts to block other connections. Even as connections start to close it causes a backup of writes to happen, eventually causing the other CF hosts/apps to break. I have to kill all connections from the CF10 host to stabilize the rest.

The only (obvious) thing I have done is updating the JDBC connector from the default one to the 5.0.8 version, but that hasn't helped.

Any ideas why CF10 would behave differently than CF8?

Cesar
  • 173

1 Answers1

0

So after everything it turns out there was a change to the MySQL connector. For the version of MySQL that we are running we had to set "useLocalSessionState=false" in the jdbc connection settings. Once we did this, it all worked out perfectly.

Cesar
  • 173