0 Replies Latest reply on Oct 3, 2013 11:01 AM by K3L3H3R

    MySQL Issues when migrating to CF10 - Lock wait timeout exceeded; try restarting transaction

    K3L3H3R

      We are currently trying to migrate our PROD environment from CF8 to CF10.  Everytime we try and add a CF10 instance into our cluster... the following error starts happening:

       

      java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

       

      Here are some environment specifics:

       

      Old Server:

      Coldfusion 8

      CentOS 5.x (32 bit)

      MySQL 5.084

       

      New Server:

      Coldfusion 10

      CentOS 6.4 (64 bit)

      MySQL 5.084

       

       

      Is this possibly driver related?

       

      Unchecking "Maintain Connections" seems to fix the issue, but I have read that unchecking that can cause more harm than good.